Activity
TeachEngineering

Teach Engineering: Using Graph Theory to Analyze Drama

For Teachers 9th - 10th
Students analyze dramatic works using graph theory. They gather data, record it in Microsoft Excel and use Cytoscape (a free, downloadable application) to generate graphs that visually illustrate the key characters (nodes) and...
Activity
TeachEngineering

Teach Engineering: Graphing Your Social Network

For Teachers 9th - 10th
Students analyze their social networks using graph theory. They gather data on their own social relationships, either from Facebook interactions or the interactions they have throughout the course of a day, recording it in Microsoft...
Lesson Plan
Other

Laus Dnet: Grade 5 Excel Lesson Plan

For Teachers 3rd - 5th
In this online instructional activity, young scholars will survey students in their school to determine their favorite type of hand-held ice cream. Before performing the survey, young scholars will make predictions about which ice creams...
Website
Other

Water on the Web

For Students 9th - 10th
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.
Whiteboard
ClassFlow

Class Flow: Ice Cream Bar Graph

For Teachers Pre-K - 1st Standards
[Free Registration/Login Required] This flipchart reviews bar graphs, how to create them and read them. Excellent activity to get your students involved in a tasty math activity!
Activity
TeachEngineering

Teach Engineering: Air Pollution in the Pacific Northwest

For Teachers 6th - 8th
Students are introduced to measuring and identifying sources of air pollution, as well as how environmental engineers try to control and limit the amount of air pollution. In Part 1, students are introduced to nitrogen dioxide as an air...
Lesson Plan
Science Education Resource Center at Carleton College

Serc: Exploring Regional Differences in Climate Change

For Teachers 10th - 12th
Students create a set of graphs that facilitate comparison of climate change predicted for various states. They also use Microsoft Excel to create a graph showing precipitation data.
Unit Plan
TeachEngineering

Teach Engineering: Latex Tubing and Hybrid Vehicles

For Teachers 9th - 10th
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...
Lesson Plan
Science Education Resource Center at Carleton College

Serc: Simple vs. Compound Interest Spreadsheeting the Difference

For Teachers 9th - 10th
A lesson plan that includes a PowerPoint learning module for learners. The goal of the lesson plan is to learn the difference between simple and compound interest and to use the functions in Excel to perform the calculations and graph...
Activity
University of Waterloo (Canada)

Wired Math: Organizing Data Grade 7 [Pdf]

For Students 6th - 8th
A collection of worksheets that focus on data analysis and organizing data. Includes detailed examples, colorful visuals, and a link to a related game. Acrobat Reader required.
Unit Plan
TeachEngineering

Teach Engineering: The Energy Problem

For Teachers 6th - 8th
This six-day lesson provides students with an introduction to the importance of energy in their lives and the need to consider how and why we consume the energy we do. The lesson includes activities to engage students in general energy...
Activity
TeachEngineering

Teach Engineering: Energy Perspectives

For Teachers 9th - 10th
Students utilize data tables culled from the US DOE Energy Information Agency to create graphs that illustrate what types of energy we use and how we use it. An MS Excel workbook with several spreadsheets of data is provided. Students...
Activity
TeachEngineering

Teach Engineering: Applying Hooke's Law to Cancer Detection

For Teachers 10th - 12th
Students explore Hooke's law while working in small groups at their lab benches. They collect displacement data for springs with unknown spring constants, k, by adding various masses of known weight. After exploring Hooke's law and...
Lesson Plan
TeachEngineering

Teach Engineering: Stress, Strain and Hooke's Law

For Teachers 10th - 12th
This lesson offers an introduction to Hooke's Law as well as stress-strain relationships. Students will first learn the governing equations. Then students will work through several example problems first individually, then as a class. In...
Lesson Plan
TeachEngineering

Teach Engineering: Presenting Painless Breast Cancer Detection!

For Teachers 10th - 12th
This instructional activity culminates the unit with the Go Public phase of the legacy cycle. In the associated activity, students must depict a tumor amidst healthy body tissue using a graph in Microsoft Excel. In addition, students...
Activity
Texas Instruments

Texas Instruments: Stretching Slinkies

For Teachers 6th - 8th
This lesson provides students with the opportunity to explore the TI-84 graphing calculator in conjunction with Microsoft Excel. Students can use the "Stretching Slinkies" worksheet to record and enter data. They will either: enter data...