Lesson Plan
Curated OER

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

For Teachers 10th - 12th
Learners use NASA satellite data to compare water vapor over the United States.  In this data analysis activity students use an Excel spreadsheet to map their data. 
Lesson Plan
Howard Hughes Medical Institute

Lesson 8: WildCam Gorongosa Data Analysis

For Teachers 9th - 12th
How do scientists analyze data to get a specific answer to a question? The final chapter in an eight-part series of activities centered around Gorongosa National Park encourages scholars to dig deeper into the scientific process. After...
Lesson Plan
Curated OER

Houses and Cars and Loans

For Teachers 8th - 10th
Young scholars create a spreadsheet to track their spending. In this algebra instructional activity, students use loan formulas to calculate the payback amount plus interest on a loan. They calculate how much money they would need...
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

Graphing Data from the Chemistry Laboratory

For Teachers 9th - 12th
Students graph and analyze data using a spreadsheet.
Lesson Plan
Curated OER

How Would You Spend a Million Dollars?

For Teachers 5th - 8th
Students plan and organize a theme to spend one million dollars. They select a theme, research prices of items on the Internet, organize the information into a spreadsheet, write an introductory paragraph, and create a final project.
Lesson Plan
Curated OER

Collect the Weather Lesson Plan

For Teachers 3rd - 8th
Students explore the weather. In this weather spreadsheet lesson, students keep track of weather patterns as they use instruments and resources to chart the data the collect in spreadsheet form.
Lesson Plan
Curated OER

Should Voting in the United States be Mandatory? Research Activity

For Teachers 8th
Eighth graders research how many voters actually vote in the U.S. and nine other nations. They create a spreadsheet using this information and write a persuasive essay.
Lesson Plan
Curated OER

Loving Literature

For Teachers 1st
First graders, after having "Are You My Mother?" by P.D. Eastman read to them, participate in group discussions or independentally work to analyze a spreadsheet to identify essential elements in the story and graph their data. In...
Lesson Plan
Curated OER

Graphing

For Teachers 5th - 12th
Students gather statistical information on a chosen topic and place it into a spreadsheet. Using th Excel chart wizard, students create tables, graphs and charts of their information. They interpret the data and share it with the class.
Lesson Plan
Curated OER

Building Arrays Using Excel Spreadsheets

For Teachers 3rd - 5th
Young scholars create arrays using Microsoft Excel. For this technology-based math lesson, students expand their knowledge of multiplication by creating arrays on the computer using a spreadsheet program such as Microsoft Excel.
Lesson Plan
Curated OER

Graphing Climate Information

For Teachers 7th
Seventh graders plot the data for the average monthly precipitation for three cities. They make a graph using a spreadsheet.
Lesson Plan
Curated OER

Where Will You Go?

For Teachers 5th
Fifth graders participate in a WebQuest in which they calculate mileage and cost per person for a trip to an amusement park. They explore various websites, and produce an Excel spreadsheet.
Lesson Plan
Curated OER

Math: Football Fever Fun

For Teachers 5th - 8th
Students compile statistics from high school or other football team and construct a spreadsheet on which to record their findings. Using Chart Wizard to analyze the data, they construct charts and graphs for a visual display of the...
Lesson Plan
Curated OER

Made Round To Go Round

For Teachers 2nd - 3rd
In this lesson students investigate what it would cost to furnish one room of their choice by shopping on the Internet. Both Australian and American dollars are to be given for each item to demonstrate the difference between two...
Lesson Plan
Curated OER

Circles and Stars

For Teachers 3rd - 4th
Students solve multiplication problems utilizing virtual manipulatives, express multiplication problems in form of expressions, enter data into a spreadsheet and analyze results, and play game Circles and Stars.
Lesson Plan
Curated OER

Computer Skills

For Teachers 5th - 8th
Students research computer information and use it to find the mean of things.  In this computer skills lesson plan students are given activities in which they calculate and use a spreadsheet to enter data on the mean of their...
Lesson Plan
Curated OER

Don't Lose Your Load!

For Teachers 9th - 11th
Young scholars create graphs using collected data. In this algebra lesson, students use spreadsheet in Excel to create graphs to interpret their data and make predictions. They rewrite word problems using algebraic expressions.
Lesson Plan
Curated OER

Hopes and Dreams: A Spreadsheet Lesson Using Excel

For Teachers 4th
Fourth graders read "The Far Away Drawer" by Harriet Diller and discuss the story as a class. After discussion, 4th graders create a t-shirt GLYPH about their hopes and dreams,share their information with the class and create spreadsheets.
Lesson Plan
Curated OER

Spreadsheet Graphs

For Teachers Higher Ed
Students create graphs using information from spreadsheets. They select a topic from the following choices: website use, digital cameras, spreadsheets, calculators or educational software. They tally the class results and create an...
Lesson Plan
Curated OER

Graphing With a Spreadsheet

For Teachers 4th
Fourth graders review how to create bar, line and circle graphs. Using jelly beans, they collect data and present it in a bar graph form. They enter the same data into a spreadsheet and watch as the program creates the same graph. They...
Lesson Plan
Curated OER

Three Squirrels and a Pile of Nuts

For Teachers 6th - 8th
Students solve story problems using a spreadsheet in combination with various problem-solving strategies. Working in teams of three, students create attempt to solve a story problem using three different methods; using manipulative,...
Lesson Plan
Curated OER

Simple Bar Graphs Using Excel

For Teachers 6th - 8th
Students 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

Checking Test Comparability/Scattergrams

For Teachers 7th - 12th
Students construct a scattergram graph. In this statistics lesson, students graph data by hand and using a spreadsheet program. They establish lines of best fit and draw conclusions using their graphs.

Other popular searches