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...
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
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.
Activity
Other

G Calc: Java Online Graphing Calculator

For Students 9th - 10th
This free online graphics calculator is an excellent resource to aid with studies in algebra, calculus, trigonometry, etc.
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...
Website
US Department of Education

Helping Your Child Learn Math: Math in the Home

For Students Pre-K - 1st
An excellent compilation of activities that engage parents and children in math explorations at home. Detailed lessons covering a wide range of math topics such as fractions, measurements, money, data collection, and math in newspapers....
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!
Unit Plan
Department of Defense

Do Dea: Spreadsheet Software Applications: M4: L1: Chart It! Working With Charts

For Students 9th - 10th
In Module 4 Lesson 1 of this course on spreadsheets, students learn how to build a chart from their spreadsheet data so that it is easier to interpret. Includes a glossary and slideshow tutorials.
Activity
Texas Instruments

Texas Instruments: Math Today the Next Frontier for Flight

For Teachers 6th - 8th
This activity provides students the opportunity to gain experience in creating circle graphs on the calculator and provides an excellent real-world review of computation with percents.
Lesson Plan
Science Education Resource Center at Carleton College

Serc: Cycles of the Sun and Moon

For Teachers 9th - 10th
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.
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: 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...
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.
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
Texas Instruments

Texas Instruments: Math Today Challenge New Color of Money

For Teachers 9th - 10th
In this activity, students will read about the changes in the "new money" and then create a graph to represent various combinations of currency produced. This activity provides an excellent example of discrete, real-world data.
Handout
Wikimedia

Wikipedia: Economy of the United States

For Students 9th - 10th
This site from the encyclopedia Wikipedia gives the reader excellent insight into the United States economy. Includes historical references, the influence of technology, resources, and the role of government. Includes numerous charts and...
Lesson Plan
Discovery Education

Discovery Education: Comparing Countries

For Teachers 3rd - 5th
Excellent instructional activity in which students make predictions and collect information about the United States, China, and the Democratic Republic of Congo. After collecting data, students compare the information and create graphs...
Website
US Department of Education

Helping Your Child Learn Math: Math on the Go

For Students Pre-K - 1st
Parents and children explore math in the world around them in this collection of math activities. Simple, engaging, and fun, these lessons offer learners the opportunity to discover math even when they're "on the go." An excellent...
Website
Teachnology

Teachnology: Spreadsheet Guide for Teachers

For Teachers 9th - 10th
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.
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...
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...
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...

Other popular searches