Lesson Plan
Science Education Resource Center at Carleton College

Serc: Using Microsoft Excel to Explore Gravity Forces and Accelerations

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

Serc: The Mole in Chemistry: Determining the Number of Atoms in Everyday Items

For Teachers 9th - 10th
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...
Lesson Plan
Alabama Learning Exchange

Alex: Becoming a Wise Consumer: Creating a Budget

For Teachers 6th - 8th
In this lesson, students will learn how to become a wise consumer by creating a budget based on needs and wants. Students will create a weekly budget with a variable income using the interactive app MWB: My Weekly Budget available on...
Lesson Plan
Other

Laus Dnet: Grade 5 Excel Lesson Plan

For Teachers 3rd - 5th
In this online instructional activity, 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...
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
Utah Education Network

Uen: Design Your Own Bedroom

For Teachers 6th - 8th
Many students dream of designing their ideal bedroom. In this exercise, students will be required to limit their designs by size (as a specific volume) and price (a specific amount). They must design the floor plan, including furniture...
Lesson Plan
Science Education Resource Center at Carleton College

Serc: Rainfall and Elevation: A Charting and Critical Thinking Exercise

For Teachers 9th - 10th
In this lab, students will learn to organize and present data in a visual way so that they can then summarize in writing their conclusions about the relationships between the data.
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 students. The goal of the lesson is to learn the difference between simple and compound interest and to use the functions in Excel to perform the calculations and graph the data.
Lesson Plan
Science Education Resource Center at Carleton College

Serc: The Digital Divide: A Data Analysis Activity Using Subtotals

For Teachers 10th - 12th
A lesson plan that includes a PowerPoint learning module for students. The purpose of the lesson is to teach how to use Excel to analyze a large amount of data, in this case from the US Census. The example being used is the accessibility...
Lesson Plan
Other

Personal: Let's Go Shopping

For Teachers 9th - 10th
This personal site provides a student activity that allows learners to practice spreadsheet skills in inputting data and creating function formulas. The activity is based on the collection and comparison of shopping receipts using max,...
Lesson Plan
Other

Tonya Skinner Business Ed Lesson Plans: Grocery Shopping

For Teachers 9th - 10th
This personal site provides a student activity that allows learners to plan a class party while organizing the budget details in a spreadsheet program. Learners will demonstrate computer skills in inputting data, formatting data, and...
Lesson Plan
Alabama Learning Exchange

Alex: Comparing Two Fossil Localities

For Teachers 6th - 8th
During this lesson plan young scholars go on a field trip to locate fossils. Students investigate their findings and identify them using resources from the Internet. They then videoconference to compare/contrast their hypotheses with...
Lesson Plan
PBS

Pbs Teachers: Sports and Math: Batting Averages and More

For Teachers 9th - 10th Standards
Set up a spreadsheet using a computer or graphing calculator, and perform calculations using columns. Calculate percentages and solve a system of equations regarding baseball statistics.

Other popular searches