Lesson Plan
Curated OER

Height and Weight

For Teachers 3rd
Third graders explore their height and weight. They measure the heights and weights of their peers. Students record their data using an Excel spreadsheet. They create a graph to compare the data and analyze it for a correlation between...
Lesson Plan
Curated OER

Heartbeat Project

For Teachers 9th - 12th
Pupils 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

Is the Rainbow Fair?

For Teachers 3rd
Third graders perform statistical calculations. Given a bag of Skittles, 3rd graders sort and collect data regarding the colors included in their bag. Using spreadsheet software, students create a bar graph of the information collected....
Lesson Plan
Curated OER

Louisville's Best Field Day Park

For Teachers 7th - 12th
Students create a survey to hand out to determine the best field day park. Using their local area, they select five parks, if possible, that meet the criteria and calculate the distance and estimated time travel. They use this...
Lesson Plan
Intel

Prototyping

For Teachers 6th - 10th
I need something to test. The three sessions in this lesson have individuals build and test a prototype of their design. The first two sessions are devoted to prepping for the prototype by drawing up specifications and materials. The...
Lesson Plan
Curated OER

Favorite Apple Graph

For Teachers 1st
First graders record their favorite type of apple in the form of a graph. They each try one slice of a Red Delicious, Golden Delicious, and Granny Smith apple, select their favorite type, and create a class graph using the data collected.
Lesson Plan
Curated OER

Examine Your State Government's Demographics

For Teachers 8th - 11th
How is your state government organized? How many elected officials are women? What is the mean age of your state representatives? Young scholars answer these questions in a research project before creating a chart to reflect their...
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.
Lesson Plan
Curated OER

Get A Life

For Teachers 9th - 12th
Students explore choosing a career and living on a budget. They receive an alternative identity and must make choices and decisions based upon given situations. Students research possible solutions, and use spreadsheet technology to...
Lesson Plan
American Institutes for Research

Digital Smiles

For Teachers 4th - 6th
Explore metric measurement, recording data, and creating an electronic spreadsheet displaying results with your math class. Scholars will measure the length of their smiles, record the measurements, and represent the results on an...
Unit Plan
Radford University

Fibonacci is All Around

For Teachers 9th - 12th Standards
One ratio to rule them all. Young mathematicians investigate the Fibonacci sequence and the Golden Ratio. To begin the first lesson, they use a spreadsheet to see how the Fibonacci sequence gives the Golden Ratio. The second lesson...
Unit Plan
Radford University

Real World Data

For Teachers 9th - 12th Standards
Make math class feel more real by using real-world data. Scholars research or collect data on several different topics, such as nutrition, the motion of moving objects, cooling curves, and daylight hours. They create scatter plots using...
Lesson Plan
Curated OER

Sweet Data

For Teachers 3rd - 12th
Students input data about the colors of their serving of M&M candies onto a spreadsheet. They create charts and graphs based on this information.
Lesson Plan
Curated OER

School Yard Waste

For Teachers 4th
Fourth graders examine the types of garbage that they collect on the playground. They collect the information in a spreadsheet and create a graph that displays the number of types of trash found. They design and monitor a playground...
Lesson Plan
Curated OER

What's Your Shoe Size? Linear Regression with MS Excel

For Teachers 8th - 12th
Learners collect and analyze data. In this statistics instructional activity, pupils create a liner model of their data and analyze it using central tendencies. They find the linear regression using a spreadsheet.
Lesson Plan
Curated OER

Pedestrian Safety for Students

For Teachers 3rd - 4th
Students create a spreadsheet. In this spreadsheet lesson, students take the responses they received from a pedestrian safety survey to create their spreadsheet. Then they turn this information into a graph.
Lesson Plan
Curated OER

Graphing Iron Data

For Teachers 8th - 10th
Students apply a data set to create a graph show how iron ore impacts an ecosystem. They explain how the iron effects the distribution and abundance of phytoplankton in coastal ecosystems using spreadsheet software.
Lesson Plan
Curated OER

The Expenditure Sheet

For Teachers 9th - 10th
Students differentiate between expenditure and income. In this algebra lesson, students create a spreadsheet labeling the date, item and amount as they track their expenses. They format the cells of the spreadsheet to do all the...
Lesson Plan
Curated OER

Super Spreadsheets

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

What's Playing Tonight?

For Teachers 5th - 9th
Pupils collect data and visually represent it. They conduct a survey of favorite movies. Using a spreadsheet, students organize the data and create bar and circle graphs. Pupils answer statistical questions regarding the data.
Organizer
Curated OER

What's Alike, What's Different Worksheet

For Students 6th - 9th
In this occupations worksheet, students create a spreadsheet by answering the 3 short answer questions in order to find similarities and differences among occupations.
Lesson Plan
Curated OER

MAISA and the REMC Association of Michigan

For Teachers 5th - 7th
Students complete online research to study geography's impact on weather. In this geography and weather lesson plan, students research weather in their city for ten days using an online website. Students bookmark the site, enter data...
Lesson Plan
Curated OER

Curious Clouds

For Teachers 2nd
Second graders explore clouds. They read The Cloud Book by Tomie dePola. Students sort the cloud pictures into three categories. Students create a graph using the cloud pictures. They use Excel to create a bar graph.
Lesson Plan
Curated OER

Data Lesson Vital Information

For Teachers K - 2nd
Students prepare and collect data and use excel and create a graph. They collect data about the number of pattern blocks that are put on tables. Students then record that data in Excel.