Lesson Plan
1
1
Earth Watch Institute

Entering Local Groundhog Data in an Excel Spreadsheet

For Teachers 4th
Here is a cross-curricular ecology and technology lesson; your learners create spreadsheets depicting the location and number of groundhog dens in a local park. They research groundhogs and analyze data about where the groundhog...
Lesson Plan
Curated OER

Cold, Clouds, and Snowflakes

For Teachers 4th - 7th
Students explore satellite data and graphing. In this weather data analysis math and science lesson, students analyze NASA satellite data to draw conclusions about geographical areas where precipitation might have happened. Students...
Lesson Plan
Curated OER

Are You Full of Hot Air?

For Teachers 2nd - 3rd Standards
Explore the concept of measuring and recording circumference. In this physical science and measurement lesson, young learners blow up balloons, measure the circumference, and record the data on an interactive graphing website.
Lesson Plan
Curated OER

Graphing With Candy

For Teachers 3rd - 5th
Students gather information and interpret the results using a tally chart, a table, and a bar graph.
Lesson Plan
Curated OER

Great Graphing

For Teachers 7th - 8th
Students collect data, use a computer spreadsheet program to create various graphs, and compare the graphs. They state the findings of each graph in writing and decide which graph type best represents the data.
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

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 plan, students use a variety of visual and written information including maps, data tables, and graphs, to form a hypothesis as to why...
Lesson Plan
Curated OER

kind of Bean

For Teachers 3rd
Third graders sort different types of beans and collect the data. They create a data table, put the information on the data table and then graph their results. They answer follow-up questions.
Lesson Plan
Curated OER

Exploring Wyoming Species Habitats

For Teachers 6th - 8th
Learners are introduced to the concept of species habitats and ranges. They introduced to ArcView GIS as a tool for mapping. Pupils use query data for species withina county, elevation, range, rivers and streams, land cover, and etc....
Lesson Plan
Curated OER

M&M Graphing

For Teachers 4th
Fourth graders name colors of M&Ms and record answers. They estimate number of M&Ms of each color found in a typical package of M&Ms on piece of paper.They record information on sheet of paper and create a spreadsheet. paper.
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

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

Using Computers to Produce Spreadsheets and Bar Graphs

For Teachers 4th - 12th
Students review graphing terminology and how to plot data points, how to input data into a spreadsheet, and how to make a chart using a computer.
Lesson Plan
Curated OER

Weather

For Teachers 5th - 7th
Learners create a spreadsheet and chart using data collected.  In this weather lesson, students select five cities from their state, including the city they live in.  Learners take daily temperature readings from all five...
Lesson Plan
Curated OER

EXCEL It!

For Teachers 5th - 8th
Students surf the Web gathering information about graphs. The data collected is incorporated into an Excel spreadsheet and graphs of varying nature generated to further enhance student understanding.
Lesson Plan
Curated OER

Excel temperature Graphs

For Teachers 4th - 6th
Students gather data about the weather in Nome, Alaska. In this Nome Temperature lesson, students create an excel graph to explore the weather trends in Nome.  Students will find the average weather and add a trend line to their graph.
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

Using Averages to Create Graphs Through Excel

For Teachers 6th
Sixth graders create and use a spreadsheet to make graphs which will be used to analyze Progress Report and Final Report Card grades. They practice finding the mean, median, mode, and range of a data set. Students also incorporate column...
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

Journalism

For Teachers 7th - 10th
Learners insert raw data about Ad sales into an Excel chart. They use raw data in a letter to local businesses by using the Mail Merge program. They represent data using tables and graphs.
Lesson Plan
Curated OER

Marvelous Mathematics

For Teachers 4th - 6th
Students make a table on the computer, but create fractions and equivalent fractions through the use of color. They are able to manipulate fractions in order to gain a greater understanding of the meaning of whole number that is broken...
Lesson Plan
Curated OER

What's A Water Column Profile?

For Teachers 6th - 10th
Students investigate water column data. In this earth science and seawater lesson, students determine how temperature, salinity, and density have an impact on sea water by viewing and analyzing data obtained from a number of websites....
Lesson Plan
Curated OER

Wordle It

For Teachers 4th - 6th
Students discuss, define, and give themselves character traits. In this character traits lesson, students create a list of ten character traits that describe themselves. Students create a data table and poll their classmates about the...
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...