TeachEngineering
Teach Engineering: Linear Models and Latex Explosion!
Students use latex tubes and bicycle pumps to conduct experiments to gather data about the relationship between latex strength and air pressure.
TeachEngineering
Teach Engineering: Latex Tubing and Hybrid Vehicles
This unit gives students the opportunity to make use of linear models in order to make predictions based on real-world data. Students experience how engineers address incredible and important design challenges through the use of linear...
Other
Water on the Web
Water on the Web (WOW) is an advanced site allowing students to actively participate in data analysis from real research sites. Lesson plans on a range of topics are provided. There is also a tutorial for using Excel to graph WOW data.
University of Kentucky
Univ. Of Kentucky: Using Excel to Fit a Titration Curve
This site from the University of Kentucky provides instructions on using a spreadsheet to plot a best-fit titration curve.
Science Education Resource Center at Carleton College
Serc: Using Microsoft Excel to Explore Gravity Forces and Accelerations
Students will learn about the force of gravity and the factors that affect it, and use and analyze the universal gravitation equation using Excel spreadsheets.
Science Education Resource Center at Carleton College
Serc: The Mole in Chemistry: Determining the Number of Atoms in Everyday Items
Students explore the concept of the mole as a measure of quantity. They build spreadsheets that allow them to convert between moles, grams, and atomic mass units for given quantities of everyday items, elements, and simple chemical...
Science Education Resource Center at Carleton College
Serc: Cycles of the Sun and Moon
Students download sunrise and sunset data along with moon phase data, and graph these data sets together in a spreadsheet in order to visualize the cycles of the seasons and the moon.
Other
Learning Link Finders: Filtering an Excel Database
This course will teach you to filter an existing Microsoft Excel database and extract records meeting your criteria. It will cover Data Form Searches, AutoFiltering, Filtering to Match a Selection, and Advanced Filters. A Live Database...
Other
Fast Food Fun
Use your knowledge of spreadsheets to analyze the calories and fat content of fast food choices. This project gives links to a USDA site and a final report format. A sample spreadsheet and grading rubric is also provided.
Other
Making a Word Find With Microsoft Excel
Teachers and students can create a word find using Excel. It will help them learn to manipulate columns and rows and format and lock cells. This plan is based upon 10 word or phrases on any topic.
Other
Laus Dnet: Grade 5 Excel Lesson Plan
In this online lesson, students will survey students in their school to determine their favorite type of hand-held ice cream. Before performing the survey, students will make predictions about which ice creams they think will be the...
Teachnology
Teachnology: Spreadsheet Guide for Teachers
A Spreadsheet is a wonderful tool with applications well beyond simple calculations. This site provides a collection of lesson plans, tutorials and worksheets that help bring spreadsheets into the classroom.
Goodwill
Gcf Global: Office 2016
Links to tutorials on the Microsoft Office 2016 suite including Excel 2016, Word 2016, PowerPoint 2016, and Access 2016.
Other
The Excel Addict
The Excel Addict offers free tips, tutorials, newsletters, and more relating to the spreadsheet and database program, Microsoft Excel.
Other
Lifewire: Excel Tan Function: How to Find the Tangent Angle
This article shows you how to find the tangent angle using Excel. You may be able to accomplish this on a scientific calculator, but if you don't have one handy, Excel can help you make these calculations better than anything else.