Lesson Plan
Curated OER

Correlation of Variables by Graphing

For Teachers 7th - 10th
Middle and high schoolers use a spreadsheet to graph data. In this graphing lesson plan, learners determine how two parameters are correlated. They create a scatter plot graph using a computer spreadsheet.
Unit Plan
1
1
Florida Department of Health

Safe and Happy: Safety for All at School and Online Unit

For Teachers 9th - 12th
Bystander or upstander and advocate? Three lessons have high schoolers investigating data about bullying and school safety. Participants then learn how to take a stand against bullying and use what they have learned to create a PSA to...
Lesson Plan
Curated OER

M & M Madness

For Teachers K
Students work with the mathematics unit of collection, organization, and presentation of data. In this math and technology lesson plan, students use Valentine M & M’s and The Graph Club to sort and graph the various colored M & M’s.
Lesson Plan
Curated OER

Data! Data! Graph that Data!

For Teachers 5th
Fifth graders create data graphs using Microsoft Excel. For this data collection lesson, 5th graders create and conduct a survey, then use Excel to organize and graph their data.
Lesson Plan
Curated OER

Jellybean Graphs

For Teachers 2nd
Second graders predict and graph data based on the color of jelly beans they think are in a handful. In this prediction lesson plan, 2nd graders will predict how many of each color jellybean are in a handful. Then they graph these...
Lesson Plan
Curated OER

Gummy Bear Math

For Teachers 1st
First graders predict, collect data, and create a graph based on gummy bear colors they are given. In this graphing lesson plan, 1st graders first predict how many colors of gummy bears there are. They then count the colors, graph them,...
Lesson Plan
Curated OER

Graphing Family Reading Habits

For Teachers 2nd
Second graders collect data from their families about their reading habits and graph them. In this graphing family reading habits lesson, 2nd graders interview family members about their reading habits. They then use a graphing computer...
Lesson Plan
Curated OER

Oil and its Everyday Uses

For Teachers 4th - 6th
Explore the properties of oil through an experiment. They use the scientific process to investigate oil, participate in experiments, watch videos,and use information from the internet to determine how oil has changed our...
Lesson Plan
Curated OER

The Solar Cycle

For Teachers 7th - 12th
Students research the solar cycle. In this Science lesson, students use the internet to investigate the solar cycle. Students produce a spreadsheet and graph from the information collected.
Lesson Plan
Curated OER

Excel temperature Graphs

For Teachers 4th - 6th
Young scholars gather data about the weather in Nome, Alaska. In this Nome Temperature lesson plan, students create an excel graph to explore the weather trends in Nome.  Young scholars will find the average weather and add a trend...
Lesson Plan
Curated OER

Temperature High and Lows

For Teachers 5th - 8th
Students gather high and low temperature readings through email. In this temperature graphing lesson, students use a spreadsheet to input data for a graph. students interpret the graphs to compare and contrast the data from different...
Lesson Plan
Curated OER

Probability and Geometry

For Teachers 4th - 5th
Students examine the relationship between probability and geometry to solve problems. In this geometry and probability lesson, students investigate the effect of changing percentages on a spinner to the probability of landing on a...
Lesson Plan
Curated OER

Using Computer for Statistical Analysis

For Teachers 6th - 12th
Students examine the use for spreadsheets in analyzing data. They make spreadsheets that display and calculate a given data set such as temperature change.
Lesson Plan
Curated OER

I'm Out of Here

For Teachers 4th - 6th
Students create a travel budget. In this budget lesson, students research vacation destinations. Working independently, students research destinations on the Internet and construct a budget for the vacation.  Resources provided.
Lesson Plan
Curated OER

Basic Excel

For Teachers 1st - 4th
Students explore basic Excel spreadsheets.  In this spreadsheet lesson plan, students enter Alaska weather information and  perform calculations. Students title the columns on the spreadsheet and format the cells. ...
Lesson Plan
Curated OER

Graphing Favorite Colors

For Teachers 3rd
Third graders collect data and insert it into ClarisWorks to create a spreadsheet/graph of their favorite color. They interpret the data together.
Lesson Plan
Curated OER

Is the Hudson River Too Salty to Drink?

For Teachers 6th - 9th
Students explore reasons for varied salinity in bodies of water. In this geographical inquiry lesson, students use a variety of visual and written information including maps, data tables, and graphs, to form a hypothesis as to why the...
Lesson Plan
Curated OER

Graphing With Second Graders

For Teachers 2nd
Second graders sort M & M's and then enter the data into a spreadsheet in order to create a simple graph. After printing the spreadsheet generated graph, have students compare the printed graph with their paper graph.
Lesson Plan
Curated OER

M & M Madness

For Teachers 2nd
Second graders graph M & M's by color. In this graphing lesson plan, 2nd graders first predict how many of each color they think are in a handful of M & M's. Then they graph the amounts of each color on a computer program....
Lesson Plan
Curated OER

Examine Methods of Reporting Research Results

For Teachers 10th - Higher Ed
Students analyze a research report and the list of components needed in a research report and then identify those components based on a set of standards using the scientific method. They collect data which can be used for a graphical...
Lesson Plan
Curated OER

Space Presents Problems

For Teachers 6th - 8th
Middle schoolers use the internet to research problems related to space. They complete a questionaire to direct their research before beginning. They create a database of moon and planet characteristics.
Lesson Plan
Curated OER

Statistics Newscast in Math Class

For Teachers 7th - 9th
Students study sports teams, gather data about the teams, and create a newscast about their data. In this sports analysis lesson, students research two teams and define their statistical data. Students compare the two teams, make...
Lesson Plan
Curated OER

Phenomenal Weather-Related Statistics

For Teachers 8th
Eighth graders research, collect and interpret data about weather statistics. They record that data on spreadsheets. they create Powerpoint presentations on their individual or group research.
Lesson Plan
Curated OER

Historical Temperatures

For Teachers 6th - 9th
Students research historical regional temperatures for their current season. In this historical weather lesson, students conduct weather station and Internet research to learn about historical regional temperatures. Students collect and...