Lesson Plan
Google

Google for Education: Applyng Discrete and Continuous Data in a Spreadsheet

For Teachers 9th - 10th
Students collect data in a spreadsheet and learn to use various functions and analysis tools to better see patterns in their eating habits.
Lesson Plan
Alabama Learning Exchange

Alex: Creating a Payroll Spreadsheet

For Teachers 9th - 10th
Spreadsheet software allows you to calculate numbers arranged in rows and columns for specific financial tasks. This activity allows students to create an "Employee Work/Pay Schedule" spreadsheet to reinforce spreadsheet skills. Students...
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 "Perfect" Date: Ranking and Rating Decisions With a Spreadsheet

For Teachers 9th - 10th
A lesson plan that includes a PowerPoint learning module for students. The purpose of the lesson is to use spreadsheets to explore a rating and ranking method for choosing someone to date. They look at the problems that arise when...
Lesson Plan
PBS

Pbs: Personal Spending Spreadsheet

For Teachers 10th - 12th
This activity helps students create their own personal spending plan.
Lesson Plan
Google

Google for Education: Patterns in the Periodic Table

For Teachers 9th - 10th
Students study trends in the periodic table of elements, supplemented by the use of spreadsheet functions. The spreadsheet functions presented can be used on any data set.
Lesson Plan
Google

Google for Education: Energy Analysis

For Teachers 9th - 10th
Young scholars collect data on energy production and consumption around the world. They input the data into a spreadsheet and use spreadsheet functions to analyze it. Finally, they upload the data into a fusion table to create a...
Lesson Plan
Google

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

For Teachers 9th - 10th
Students learn to organize, sort, and display data in a Microsoft Excel spreadsheet using latitude data for 120 major world cities.
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
Science Education Resource Center at Carleton College

Serc: Cycles of the Sun and Moon

For Teachers 9th - 10th
Young scholars 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.
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
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
Council for Economic Education

Econ Ed Link: Loan Amortization Mortgage

For Teachers 9th - 10th
How to amortize a loan using an Excel spreadsheet.
Lesson Plan
Science Education Resource Center at Carleton College

Serc: Know Your Neighbors: Researching the Planets

For Teachers 5th - 8th
Students will study planets and moons in our solar system by working online and other resources. This lesson has students working together to generate a spreadsheet of data found. Students will use this information to describe why Earth...
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
Science Education Resource Center at Carleton College

Serc: Reasoning About Center and Spread: How Do Students Spend Their Time?

For Teachers 9th - 10th Standards
Using their own habits for data, students predict how much time they spend on different activities each day, and how much variability each activity is likely to have. They then collect data into a class spreadsheet and look at the...
Lesson Plan
Other

Ontario Council for Technology Education: Designing a Tool Storage Board [Pdf]

For Teachers 10th - 12th
Students begin this project by taking an inventory of hand tools at home. They then categorize their tools and make a detailed list in a spreadsheet. After research on tool storage, they will choose materials and a tool board style, then...
Lesson Plan
Google

Google for Education: Data Aggregation and Decomposition (Excel)

For Teachers 9th - 10th
By using Microsoft Excel, students collect, decompose, and re-aggregate class data. Students use computational thinking skills by decomposing long lists of information and writing basic algorithms to help analyze data.
Lesson Plan
Google

Google for Education: Energy Analysis

For Teachers 9th - 10th
By creating a spreadsheet, students can learn more about energy production and consumption around the world. Students have to research the data to be analyzed in the spreadsheet. An example of the spreadsheet is given in this lesson plan.
Lesson Plan
Science Education Resource Center at Carleton College

Serc: Westward Ho! How Far Is Yonder Mountain

For Teachers 9th - 10th
In this instructional activity quantitative skills in geologic context are reinforced. Students create a spreadsheet to calculate the distance of a peak using vertical angles sighted from a wagon train heading directly for the peak. The...
Lesson Plan
Alabama Learning Exchange

Alex: French Internet Clothes Shopping

For Teachers 9th - 10th
Students practice clothing vocabulary and computer spreadsheet skills by visiting authentic French online clothing catalogs. They choose articles of clothing for purchase for themselves and family members and create a spreadsheet to...
Lesson Plan
Science Education Resource Center at Carleton College

Serc: Mn Step: Statistical Analysis of Lincoln

For Teachers 9th - 10th
For this activity, learners 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 learners. 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...

Other popular searches