+
Lesson Plan
Curated OER

Weather, Weather, Everywhere!

For Teachers 6th
Sixth graders collect weather data to compare temperatures around the world. Using the Internet, learners collect data, put it into spreadsheets, and analyze and graph the results. An interesting way to cover the topic of weather.
+
Lesson Plan
Curated OER

Buying a Car

For Teachers 8th
Eighth graders create spreadsheets to calculate payments. They create a list of items they would like to purchase that require monthly payments. They simulate buying a car and create a spreadsheet to determine the amount of the monthly...
+
Lesson Plan
Curated OER

Electronic Hydrology Lesson Plan - Revised

For Teachers 8th - 12th
Students use Excel spreadsheets. They predict time and height of peak flow on river
+
Lesson Plan
Curated OER

Solving Polynomial Equations

For Teachers 9th - 12th
Students demonstrate how to use spreadsheets as a tool for analyzing, visualizing and solving mathematical problems. Students obtain fundamental grasp of cubic equations and other polynomial equations.
+
Lab Resource
Pingry School

The Water Lab – Spreadsheet Simulation

For Students 9th - 12th Standards
More than 70 percent of people and 90 percent of businesses use spreadsheets regularly. While many courses overlook the important skill, the simple water lab focuses on entering spreadsheet data, formatting it, and printing plots based...
+
Lesson Plan
Curated OER

Super Spreadsheets

For Teachers 6th - 8th
Students discover information about each of the fifty states in the United States. In groups, they create a spreadsheet organizing the information to show to the class. They discover different ways to display the data and identify the...
+
Lesson Plan
Curated OER

Comp Tech: Format Cells Scavenger Hunt

For Teachers 6th - 8th
Learners begin their use of Microsoft Excel. Individually, they practice using the program, formatting cells and changing the appearance of the spreadsheet. To end the instructional activity, they participate in a scavenger hunt...
+
Lesson Plan
Curated OER

Exploring Careers

For Teachers 7th
Seventh graders investigate their career aptitudes and interests through a scavenger hunt. They display their choices in Excel spreadsheets.
+
Lesson Plan
Curated OER

Sales Spreadsheet

For Teachers 6th - 8th
Learners use Excel spreadsheets to organize purchases, discounts, sales prices, and sales tax. Students follow step by step instructions and enter formulas as well as use the auto sum feature to calculate required calculations.
+
Lesson Plan
Curated OER

Introduction to Spreadsheets

For Teachers 6th
Sixth graders utilize Excel or other spreadsheet software to create both text and numerical valued columns to produce a Christmas or birthday wish list. They study the difference between text and numerical values for column use and...
+
Lesson Plan
Curated OER

Simple Bar Graphs Using Excel

For Teachers 6th - 8th
Young scholars create original survey questions, and develop a bar graph of the data on paper. They input the survey data using two variables onto an Excel bar graph spreadsheet.
+
Lesson Plan
Curated OER

Graphically Speaking

For Teachers 4th - 6th
Students discover the links between population and Congressional representation. In this government lesson, students research population statistics and create spreadsheets that compare population to the number of Congress members per state.
+
Lesson Plan
Curated OER

A Comparison Study of Water Vapor Data to Precipitation over North America

For Teachers 10th - 12th
Students use NASA satellite data to compare water vapor over the United States.  For this data analysis lesson students use an Excel spreadsheet to map their data. 
+
Lesson Plan
Code.org

Making Data Visualizations

For Teachers 9th - 12th
Relax ... now visualize the data. Introduce pupils to creating charts from a single data set. Using chart tools included in spreadsheet programs class members create data visualizations that display data. The activity encourages...
+
Lesson Plan
Bowland

Speed Cameras

For Teachers 6th - 9th
Do speed cameras help reduce accidents? Scholars investigate this question using a series of spreadsheet activities. Along the way, they learn about randomness, probability, and statistical analysis.
+
Lesson Plan
Curated OER

Break Even Analysis and Budgeting

For Teachers 11th - Higher Ed
Students analyze the use of break even charts in business planning. They examine the purpose and nature of budgets. They explore price elasticity and how to use Excel spreadsheets to manipulate financial information.
+
Lesson Plan
Curated OER

Chaucer's Characters in The General Prologue

For Teachers 12th
Twelfth graders explore the characters in The General Prologue. They describe the characters and their occupations and their lands of origin. Students organize the characters using Excel spreadsheets.
+
Lesson Plan
Curated OER

Topic 6: Evaluating and Presenting Results

For Teachers 8th - 9th
Students construct spreadsheets from raw data. In this spreadsheet construction lesson, students compile data into Microsoft Excel. Students familiarize themselves with entering and presenting data in a spreadsheet.
+
Lesson Plan
Curated OER

Dental Detectives

For Teachers 1st
First graders explore the theme of dental health and hygeine. They make tooth loss predictions, count lost teeth, and graph tooth loss. In addition, they listen to dental health stories, read online stories, create spreadsheets, and play...
+
Activity
Howard Hughes Medical Institute

Spreadsheet Tutorial 5: Histogram

For Students 9th - 12th
A professional-looking histogram is just a few clicks away. The last installment of a five-part Spreadsheet Data Analysis series focuses on histograms. Learners work through a tutorial to see how spreadsheets can help make frequency...
+
Lesson Plan
Council for Economic Education

Loan Amortization - Mortgage

For Teachers 9th - 12th Standards
When you buy a home for $100,000, you pay $100,000—right?  On the list of important things for individuals to understand, the lesson plan presents the concept of interest rates and loan amortization using spreadsheets and online sources....
+
Lesson Plan
1
1
Curated OER

The Solstices

For Teachers 6th - 9th
Compare surface temperatures when the solstice occurs in the different hemispheres. Young scientists draw conclusions from their investigation of data collected using spreadsheets and a globe.
+
Lesson Plan
Curated OER

Computer Science: Pendulum

For Teachers 7th - 9th
Students investigate the basic properties of pendulums as a function of spreadsheets. Working in groups, they measure the period for a pendulum at six different lengths and record the results. They prepare a file using Microsoft Excel...
+
Lesson Plan
Curated OER

Graphs! Graphs! Graphs!

For Teachers 6th - 8th
Students practice making charts and graphs from data on spreadsheets. Individually, they create a graph representing the latest information on voter registration. They answer questions and analyze the data to end the instructional...

Other popular searches