Lesson Plan
Google

Google for Education: Data Aggregation and Decomposition (Python)

For Teachers 9th - 10th
Students learn how to use and analyze data to draw conclusions about information collected from classmates. Then they use computational thinking by collecting and aggregating data onto a spreadsheet, identifying patterns in their data,...
Lesson Plan
Google

Google for Education: Sorting the World's Cities (Python)

For Teachers 9th - 10th
The second of two similar lessons where students learn how a Python program can organize and sort data. When taught in conjunction with Sorting the World's Cities with Excel, students make the connection between writing a program and...
Lesson Plan
NASA

Nasa: Sea Surface Temperature Trends of the Gulf Stream

For Teachers 9th - 10th
Students investigate changes in the surface temperatures of the Gulf Stream over the course of the seasons using data collected by NASA's satellites. The data is inputted into a spreadsheet and graphed.
Lesson Plan
National Council of Teachers of Mathematics

The Math Forum: Seventh Grade Mathematics: Data Sense

For Teachers 6th - 8th
This site has some interesting ways to collect and evaluate data. There are some activities about note taking, spreadsheets, surveys, and a cool bridge construction project. Teachers may want to use this site as a resource for some...
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 instructional activity, 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...
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 instructional activity is to learn the difference between simple and compound interest and to use the functions in Excel to perform the calculations...
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 plan 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...
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 middle schoolers 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 those...
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