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...
Unit Plan
Newspaper Association of America

Power Pack: Lessons in Civics, Math, and Fine Arts

For Teachers 3rd - 12th Standards
Newspaper in Education (NIE) Week honors the contributions of the newspaper and is celebrated in the resource within a civics, mathematics, and fine arts setting. The resource represents every grade from 3rd to 12th with questions...
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

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

Data! Data! Graph that Data!

For Teachers 5th
Fifth graders create data graphs using Microsoft Excel. In 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, 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

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

Statistics Newscast in Math Class

For Teachers 7th - 9th
Learners 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. Learners compare the two teams, make...
Lesson Plan
Curated OER

Graphing With Candy

For Teachers 3rd - 5th
Young scholars 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

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 instructional activity, 2nd graders interview family members about their reading habits. They then use a...
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

Journalism

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

Moon Craters Lab

For Teachers 4th - 6th
Students explore characteristics of mass. In this scientific inquiry about mass lesson, students drop rocks of different weights from various heights and record the depth of the "crater" created.  Students record their findings on a...
Lesson Plan
Curated OER

Historical Mathematicians Project

For Teachers 5th - 12th
Students, in small groups, use the Internet and other traditional sources to research historically significant mathematicians, write a paper, and creatively present research in class.
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 a Spreadsheet

For Teachers 8th - 10th
Students create a spreadsheet to analyze data. In this technology lesson, students develop and use an Excel spreadsheet to log their data. They solve real life word problems as they set it up using the spreadsheet.
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

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.
Assessment
Georgia Department of Education

Analytic Geometry Study Guide

For Students 9th - 12th Standards
Are you looking for a comprehensive review that addresses the Common Core standards for geometry? This is it! Instruction and practice problems built specifically for standards are included. The material includes geometry topics from...
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

Excel

For Teachers 9th - 11th
In this technology worksheet, students are taught how to create documents using Excel. They follow the directions on a handout to help them create documents. They print their final work and submit it.
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...