Lesson Plan
Cyberbee

Adventures of Cyberbee: Graphing

For Teachers Pre-K - 1st Standards
Teacher-directed lesson plan focusing on data analysis, graphing, and probability. Lesson includes a video and engaging spreadsheet activities.
Lesson Plan
Science Education Resource Center at Carleton College

Serc: Mn Step: Statistical Analysis of Lincoln

For Teachers 9th - 10th
For this activity, students first work in groups to collect information about a set of pennies. They measure and record the mass for each one in a table using a spreadsheet program if possible. They also record its year and, for 1982...
Lesson Plan
Science Education Resource Center at Carleton College

Serc: Take a Deep Breath on the Appalachian Trail

For Teachers 10th - 12th
A lesson plan that includes a PowerPoint learning module for students. They will examine spreadsheet data on air quality in Great Smoky National Parks, and solve problems using ratio and proportion. The exercises will help them to...
Lesson Plan
Microsoft

Microsoft Education Lesson Plan: Making Money From Lemons

For Teachers 3rd - 8th
Simulation where learners apply mathematics and economics concepts in the lemonade business. Learners set up a virtual lemonade stand and must determine production costs, product variables, and profits. Students record data collected on...
Lesson Plan
Science Education Resource Center at Carleton College

Serc: Resource Usage Project and Journal

For Teachers 9th - 10th
Students pick a resource and track their use of it over the course of one week. Students record their data in a spreadsheet, write a summary of it, and draw conclusions from their usage patterns. A detailed student handout is provided.
Lesson Plan
Science Education Resource Center at Carleton College

Serc: Creating a Household Budget

For Teachers 9th - 10th
In this Spreadsheets Across the Curriculum PowerPoint module, students create a household budget by tracking their expenditures over a month-long period. Students use Microsoft Excel to create a spreadsheet to track their own...
Lesson Plan
Council for Economic Education

Econ Ed Link: Education: Weigh Your Options

For Teachers 9th - 10th
Getting and keeping a job often requires special education or training. While an employer may provide or pay for some additional education or training, workers often have to obtain it on their own. In this instructional activity,...
Lesson Plan
Alabama Learning Exchange

Alex: Charting the Weather

For Teachers 3rd - 5th
During this activity, students will gather data from temperature and water gauges set up on the playground to learn about weather patterns. Then students will build a spreadsheet with data related to temperature, wind direction and...
Lesson Plan
Alabama Learning Exchange

Alex: Find a Pattern Using Children's Literature

For Teachers 6th - 8th
Students use the problem-solving strategy of "find a pattern" to predict the number of grains of rice Rani (from the book, One Grain of Rice: A Mathematical Folktale by Demi) will receive after 30 days. Students use a spreadsheet to...
Lesson Plan
Alabama Learning Exchange

Alex: Math Is Functional

For Teachers 9th - 10th Standards
This lesson is a technology-based activity in which students extend graphing of linear functions to the use of spreadsheet software. After students have become proficient in constructing a table of values, students are able to...
Lesson Plan
Alabama Learning Exchange

Alex: There's Perimeter in the School!

For Teachers 3rd - 5th
Students will work in groups to measure the perimeter of items around the school. They will record their data on a spreadsheet in the form of a line plot.
Lesson Plan
Alabama Learning Exchange

Alex: The Elephants Truncate Roots

For Teachers 6th - 8th Standards
Learners will learn the process of finding where the square root of 2 is on the number line by truncating the square of a number between 1 and 2. They will also work with other square roots to learn how to order them on the number line....
Lesson Plan
Alabama Learning Exchange

Alex: Bloodstain Pattern Doesn't Lie

For Teachers 9th - 10th
Learners will formulate a hypothesis about the relationship (linear, direct, indirect, etc.) between the distance a drop of blood falls and the diameter of the splatter it makes. To test their hypothesis, the students will work...
Lesson Plan
Alabama Learning Exchange

Alex: How Much Will This Lifestyle Cost?

For Teachers 9th - 10th
Students will create a detailed monthly budget using a spreadsheet. The budget will depend on an individual's earning potential as determined by career choice and education. This is a project-based, Commerce and Information Technology...
Lesson Plan
Alabama Learning Exchange

Alex: Can I Afford This House?

For Teachers 9th - 10th
In this lesson, students will prepare a spreadsheet that provides information about purchasing a house. Using functions and formulas, they will determine if they can afford the house. This is a Commerce and Information Technology lesson...
Lesson Plan
Alabama Learning Exchange

Alex: Scale Drawings

For Teachers 9th - 10th
During this lesson students practice measuring and converting to scaled measurements. Students measure various places on campus, such as a classroom or the gym. They place their findings on a spreadsheet. After converting these...

Other popular searches