Lesson Plan
Google

Google for Education: Data Aggregation and Decomposition (Excel)

For Teachers 9th - 10th
By using Microsoft Excel, learners 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: 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
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
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
Council for Economic Education

Econ Ed Link: Using an Excel Checkbook

For Teachers 9th - 10th
Students will use a spreadsheet to enter checkbook transactions and reconcile.
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. Learners record data collected on...
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.
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
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
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...
Lesson Plan
TeachEngineering

Teach Engineering: Presenting Painless Breast Cancer Detection!

For Teachers 10th - 12th
This lesson 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 will design a...
Lesson Plan
Science Education Resource Center at Carleton College

Serc: Quantitative Reasoning and Analytical Writing in a Global Climate Change

For Teachers 9th - 10th
In this lesson students use Microsoft Excel to manipulate and statistically analyze large climate databases of precipitation., temperature, stream discharge, tree ring data, ice core data, and ENSO to determine climate relationships and...
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: Statistically Thinking

For Teachers 9th - 10th Standards
The object of this project is for students to learn how to find univariate and bivariate statistics for sets of data. Also, the students will be able to determine if two sets of data are linearly correlated and to what degree. The...

Other popular searches