Lesson Plan
Curated OER

Time Management

For Teachers 6th - 9th
Learners plot activities for a 24 hour day. They record their information on a spread sheet program. Students list categories they use and write equations for cells that add cells of each category together. Learners create a pie chart of...
Lesson Plan
National Council of Teachers of Mathematics

National Debt and Wars

For Teachers 9th - 12th Standards
Take a functional approach to the national debt. Learners collect information about the national debt by decade and plot the data. They determine whether an exponential curve is a good fit for the data by comparing the percent changes...
Lesson Plan
Curated OER

Discovering Pi

For Teachers 9th - 11th
Define terminology related to a circle. Practice accuracy in measuring and then create a spreadsheet based on data collected from solving for parts of a circle. Groups can have fun analyzing their data as it relates to Pi.
Lesson Plan
Curated OER

Using Computers for Statistical Analysis of Weather

For Teachers 9th - 12th
Students use temperature, cloud cover and other weather data from the S'COOL website to statistically analyze weather around the country. They use computers to calculate and graph standard deviations, means and modes of the weather...
Activity
1
1
Agile Mind

Isabella’s Credit Card

For Teachers 8th - 12th Standards
An in-depth activity that involves a real-world problem about credit card debt. Learners are given a scenario in which Isabella plans to stop using her credit card and pay off the balance by paying a fixed amount each month. The first...
Lesson Plan
Virginia Department of Education

Mystery Iron Ions

For Teachers 9th - 12th Standards
Young chemists perform an experiment to determine if a compound is iron (II) chloride or iron (III) chloride. Then they determine the formula, balance the equation, and answer analysis questions. 
Lesson Plan
Curated OER

Using Electronic Manipulatives in Multiplication

For Teachers 9th - 11th
Factor polynomials using electronic manipulatives. Your class will create a spreadsheet in excel and use it to multiply and perform basic operations and solve problems correctly. They create a visual to go along with each multiplication...
Lesson Plan
Curated OER

Heartbeat Project

For Teachers 9th - 12th
Students enter information about their heartbeats into a spreadsheet. They construct data displays and calculate statistics. They describe and justify their conclusions from the data collected.
Lesson Plan
Curated OER

Moving Day!

For Teachers 8th
Eighth graders continue their geometry unit by focusing on volume. Using data, they create a spreadsheet, estimate and calculate volume. They solve real-life problems and round their answers to the hundredths place. They also practice...
Lesson Plan
Curated OER

Unit 2: Lesson 8

For Teachers 6th - 8th
Students login to their account and access information from keypals. They compare their data with information recieved by classmates. Students review question that were asked of keypals. They discuss ways that expected data can be...
Lesson Plan
Curated OER

Technology Integration Lesson Plan: Civil War Spreadsheet

For Teachers 8th
Eighth graders discuss and analyze Civil War data, manually graph data on handout, work with partners to enter data into spreadsheets, and create charts on spreadsheet for each data set.
Worksheet
Curated OER

Experiment-Using Formulas and Spreadsheets

For Students 9th
In this Algebra I worksheet, 9th graders track information relating to a sporting event and create a spreadsheet and appropriate formulas used to track data.  The one page worksheet contains the assignment and...
Lesson Plan
Curated OER

When Dinosaurs Ruled the World

For Teachers 3rd - 4th
Students graph the varying sizes of dinosaurs.  In this math and dinosaur lesson, students view dinosaur models and compare the different shapes and sizes of the dinosaurs.  Students complete a dinosaur math activity, read The...
Lesson Plan
Curated OER

A Fishy Tale

For Teachers 8th
Eighth graders do a research project on a particular species of Atlantic seafood and record and graph information pertaining to commercial landings of that species of seafood. They use a website and an Appleworks spreadsheet.
Lesson Plan
Curated OER

Investing

For Teachers 8th - 10th
Students collect data on investments and draw conclusions. In this algebra lesson, students analyze exponential graphs as they relate to money. They discuss the cause of an account balance being high or low.
Lesson Plan
Curated OER

Let's Keep Track of Grades

For Teachers 7th - 8th
Students participate in a technology project. This lesson is a hands-on spreadsheet project where students are responsible for keeping track of their grades for class. The students learn to enter data into a spreadsheet, create...
Lesson Plan
Curated OER

Using Excel To Teach Probability And Graphing

For Teachers 3rd - 8th
Students engage in the use of technology to investigate the mathematical concepts of probability and graphing. They use the skills of predicting an outcome to come up with reasonable possibilities. Students also practice using a...
Lesson Plan
Curated OER

The Statistics of Shoes

For Teachers 7th - 10th
Students open a blank spreadsheet and format it for a class survey about the number of shoes owned by the men and women in the class. They enter the data before finding the mean, median, mode, quartiles, variance, and the standard...
Assessment
Noyce Foundation

Pizza Crusts

For Teachers 6th Standards
Enough stuffed crust to go around. Pupils calculate the area and perimeter of a variety of pizza shapes, including rectangular and circular. Individuals design rectangular pizzas with a given area to maximize the amount of crust and do...
Lesson Plan
Curated OER

Spreadsheet Project: Planning a Party

For Teachers 9th - 12th
Students create a spreadsheet and stay within a budget as they plan a class party for the next holiday.
Lesson Plan
Curated OER

4 Month Budget Spreadsheet

For Teachers 8th
Eighth graders create and maintain a spreadsheet budget based on a predetermined salary. They have an opportunity to make "investments and purchases." Budget records be kept for an imaginary 4 month period.
Interactive
Curated OER

Lunch Menu Calories tracking project

For Students 5th - 10th
In this lunch menu worksheet, students make a spreadsheet where they count the calories of different food items on the lunch menu, chart their findings, and answer short answer questions. Students answer 5 questions.
Lesson Plan
Curated OER

Collecting Data on Running Speeds

For Teachers All
Students collect data on running speeds of various individuals in class to determine the average running speed for a distance of 20 meters.
Lesson Plan
Curated OER

Comparing Temperatures in Different Cities

For Teachers 6th - 12th
Students generate a spreadsheet to calculate average daily temperature. They create graphs from spreadsheet data and comprehend the components of the a spreadsheet.

Browse by Subject


Data Formulas