Lesson Plan
Curated OER

Data Collection

For Teachers 3rd - 5th
Students write a journal exercise that relates to pets. They collect information from each other in order to practice making and interpreting bar graphs. They Continue building different kinds of graphs with the group.
Lesson Plan
Curated OER

Fast Food Survey Using Bar Graphs

For Teachers 2nd
Second graders create a bar graph to pictorically represent the data collected from a survey of students. They use Excel to electronically create the graphs and data tallies. They then interpret their data using sentences to explain.
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.
Worksheet
Curated OER

Endangered Species

For Students 9th - 12th
In this geography worksheet, students identify how to manipulate data on a range of endangered species. They create a bar graph of endangered animals from Africa, Asia, Australia, North America, or South America. Students use a...
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 activity; 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

Polar Bears in Peril - Climate Change Culprit?

For Teachers 9th - 12th
High schoolers explore the changes in sea ice over several years. In this life science instructional activity, students review and examine 20 years of data. They use Excel to graph data and analyze trends.
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.
Activity
Teach Engineering

Air Pollution in the Pacific Northwest

For Teachers 6th - 8th Standards
Scholars investigate levels of nitrogen dioxide in the Pacific Northwest by examining the role of nitrogen in air pollution and how remote sensing can be used to measure nitrogen levels. An Excel spreadsheet calculates the difference...
Lesson Plan
Curated OER

Finding Caterpillars

For Teachers 4th - 6th
Students examine how animals protect themselves from predators and camouflage themselves. They participate in a simulation in which they locate red and green yarn "caterpillars," organize their data, and generate a bar graph using...
Lesson Plan
PHET

Soda Bottle Magnetometer

For Teachers 6th - 8th Standards
Introduce learners to set of complete instructions that describe how to build a magnetometer that works just like the ones professional photographers use to predict auroras. The diagrams are wonderfully descriptive, and the written...
Lesson Plan
Curated OER

What Goes Up Must Come Down!!

For Teachers 5th
Fifth graders look at actual sunrise and sunset times for their hometown to determine a pattern in the amount of daylight. They collect their data in Excel and create a chart to help them identify the pattern, then write an explanation...
Lesson Plan
Curated OER

Predicting Temperature: An Internet/Excel Learning Experience

For Teachers 3rd
Third graders use the Internet (www.weather.com) to find the high temperature for our locale and the high temperature for another city around the world. They keep track of the temperature in these two locations for 10 days.
Lesson Plan
Curated OER

Scientific Method and Graphing

For Teachers 7th
Seventh graders use the scientific method to determine how many seeds are in a watermelon.
Lesson Plan
Curated OER

Toy Dissection Graph

For Teachers 3rd - 6th
Students explore simple machines and how they are made. They examine the parts of the simple machine and collect information about its parts. Using Excel, students create circle and bar graphs from the collected data.
Lesson Plan
Curated OER

Testing Battery Combinations

For Teachers 4th
Fourth graders examine the required combinations of plates and predict which combination will generate the most and least current and voltage. They use an ammeter and experiment with combinations of their own testing and record each...
Lesson Plan
Curated OER

Dental Detectives

For Teachers 1st
First graders explore the theme of dental health and hygeine. They make tooth loss predictions, count lost teeth, and graph tooth loss. In addition, they listen to dental health stories, read online stories, create spreadsheets, and play...
Lesson Plan
Curated OER

Seasons and Cloud Cover, Are They Related?

For Teachers 6th - 12th
Students use NASA satellite data to see cloud cover over Africa.  In this seasons lesson students access data and import it into Excel. 
Lesson Plan
Curated OER

Planet Protectors

For Teachers 6th - 8th
Students explore ways to protect the earth.  In this environmental issues and technology instructional activity, students investigate the water quality in their community and compare their findings to the water quality in other...
Lesson Plan
Curated OER

How Does a Seed Grow Into a Plant?

For Teachers 2nd
Second graders explore how seeds grow into plants. They discuss types of seeds and place seeds in wet paper towels to germinate. They draw a picture in their journal to record their observations for four days. They take pictures of their...
Lesson Plan
Curated OER

When You're Hot, You're Not!!

For Teachers 6th - 8th
Students investigate volcanoes. In this landforms lesson, students locate two volcanoes on a world map. Students compare and contrast the types of volcanoes by using various Internet sites.
Lesson Plan
Curated OER

What Do Plants Need to Grow?

For Teachers 4th
Fourth graders control variables to determine the effect on plant growth. They collect information by observing and measuring and construct simple graphs, tables, maps and charts to organize, examine and evaluate information.
Lesson Plan
Curated OER

Power Point -- Science Portfolio

For Teachers 3rd - 5th
Students are introduced to Microsoft PowerPoint. Using the internet, they research a topic of interest to them related to science. They create three slides and share them with the class. They also discover how to print the slides and...
Lesson Plan
Curated OER

Weather Or Not

For Teachers 3rd - 5th
Students use the internet to find pen pals to share in their weather experiment. Individually, they research the high and low temperatures for cities within the United States and email the results to their pen pal. They also develop a...
Lesson Plan
Curated OER

Blast the Fats

For Teachers 3rd - 4th
Students examine the fats found in foods. In this nutrition lesson, students identify the types and amounts of fats found in foods as they research food labels and the Internet. Students classify the fats and record their data.