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

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

Exploring Wyoming Species Habitats

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

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

Let's Get Organized

For Teachers 6th
Sixth graders identify table and each of its parts, including cell, column, row, header, and formula bar. Students then explain how tables are used to store and organize information in database, organize and categorize information...
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
Learners 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

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

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

Graphing Family Reading Habits

For Teachers 2nd
Second graders collect data from their families about their reading habits and graph them. For 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

Is the Hudson River Too Salty to Drink?

For Teachers 6th - 9th
Learners explore reasons for varied salinity in bodies of water. In this geographical inquiry activity, 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

Pollution and Environmental Studies- Daily Water Use

For Teachers 4th - 9th
In this environmental studies worksheet, students create a data table to discover how much water each person uses on a daily basis and what it is used for. They complete a post activity to make and test solutions for pollution using a...
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

Microsoft Access Lesson Plan

For Teachers 3rd
Third graders read children's literature during the school year and compile a list of books and genres in an Access database. They print out a report of all the different books and genres of they read over the whole school year.
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

Making and Using a Graphic Organizer for Solving a Mystery

For Teachers 3rd - 5th
Students create tables in a word processing program which helps them organize their text clues when reading a mystery story. They develop reading comprehension strategies while using a computer based graphic organizer in order to solve...
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 plan, students create an excel graph to explore the weather trends in Nome.  Students will find the average weather and add a trend line to...
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

Banquet Menu Assessment: Exposure Investigation Exercise

For Teachers 9th - 12th
Students identify sources of Food Borne illness and their prevention. They formulate hypotheses based on collected information. Pupils become aware of Nutrintional value of food. Students collected data are synthesized to formulate...
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 plan, students determine how temperature, salinity, and density have an impact on sea water by viewing and analyzing data obtained from a number of...
Lesson Plan
Curated OER

Internet Shopping Business Idea

For Teachers 9th - 12th
Learners create their own Internet business based on data they find concerning trends in Internet shopping. They discuss advantages and disadvantages to selling specific products and/or services over the Internet.
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.

Other popular searches