+
Lesson Plan
Polar Trec

How Much Data is Enough?

For Teachers 6th - 12th Standards
The next time you read a magazine or watch the news, make note of how many graphs you see because they are everywhere! Here, scholars collect, enter, and graph data using computers. The graphs are then analyzed to aid in discussion of...
+
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

Creating Climographs

For Teachers 6th - 8th
Young scholars use satellite data to compare precipitation and surface temperatures on different islands.  In this satellite instructional activity students create graphs and explain the differences between weather and climate. 
+
Lesson Plan
Curated OER

Hemlock Trees and the Pesky Pest, The Woolly Adelgid

For Teachers 5th - 6th
Young scholars review Excel and how to create graphs with this program. They create two graphs in Excel, one showing the average number of woolly adelgid egg sacks on the outer 15 cm of hemlock branch at sites sorted by latitude, then...
+
Lesson Plan
Towson University

Looking Backwards, Looking Forward

For Teachers 6th - 8th Standards
How do scientists know what Earth's climate was like millions of years ago? Young environmental scholars discover how researchers used proxy data to determine the conditions present before written record. Grouped pupils gain experience...
+
Organizer
Curated OER

Tides at the Battery, NY

For Students 7th - 12th
Skill in using Excel and increasing proficiency in manipulating data are challenged with this data analysis work.  A web link supplies data and step-by-step instructions help learners create a graph.  There are many extension activities...
+
Lesson Plan
Curated OER

Does cloud type affect rainfall?

For Teachers 7th - 9th
Student use MY NASA DATA to obtain precipitation and cloud type data. They create graphs of data within MY NASA DATA. Students compare different cloud types, compare precipitation, and cloud type data They qualitatively describe graphs...
+
Lesson Plan
Curated OER

Using SWMP Data

For Teachers 9th - 12th
Students are introduced to the SWMP system which tracks short-and long-term changes in water. Using this data, they plot and interpret the data on a graph to determine how human activities are lowering the water quality. They also...
+
Lesson Plan
Curated OER

It's In The Chocolate Chips

For Teachers 6th - 8th
Students investigate which brand of chocolate chip cookies contains the most chocolate. They analyze and compare data using Microsoft Word and Microsoft Excel. They communicate the results with Microsoft PowerPoint.
+
Lesson Plan
Curated OER

Using Imported Data in Excel

For Teachers 7th - 10th
Students import atmospheric data from the internet. In this earth science lesson, students graph the data they collected. They complete the worksheet after the activity.
+
Lesson Plan
Curated OER

Bats and Hot Dogs

For Teachers 7th - 10th
Young scholars identify patterns and relationships from data that is collected and solve variables.  In this investigative lesson students study ocean productivity, the nitrogen cycle and phytoplankton then answer questions.
+
Lesson Plan
Curated OER

Is Portland, Oregon Experiencing Global Warming?

For Teachers 6th - 9th
Students use data to determine if the climate in Portland has changed over the years.  In this weather activity students complete line graphs and study long wave radiation. 
+
Lesson Plan
Curated OER

Think GREEN - Utilizing Renewable Solar Energy

For Teachers 7th - 12th
Students use data to find the best renewable energy potential.  In this solar energy lesson students import data into Excel and explain how solar energy is beneficial. 
+
Lesson Plan
Curated OER

Investigating Seasonal Variability in NO2 Concentrations

For Teachers 8th - 10th
Students study different formats of data and determine the nitrogen dioxide concentrations.  For this seasons lesson students understand the different relationships that NO2 can have.
+
Worksheet
Curated OER

Endangered Species

For Students 9th - 12th
For 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
Curated OER

Fish and Clips

For Teachers 1st - 2nd
Youngsters test magnetic strength by measuring the mass of paper clips that they "hook" with a magnet. Your first and second graders should love the hands-on activities associated with this plan. The reproducible materials are quite good...
+
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.
+
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 lesson plan, students review and examine 20 years of data. They use Excel to graph data and analyze trends.
+
Lesson Plan
Curated OER

Graphing in Science

For Teachers 8th - 12th
Students manipulate and interpret data. They are given a dataset from a described experiment and interpret the data. A "How to Sheet for graphing" is included in lesson plan.
+
Lesson Plan
Curated OER

Impact Craters and Water on Mars

For Teachers Higher Ed
Students explore for water on Mars using impact crater morphology. During this lab, students: investigate how to use the equation writing and graphing capabilities in Microsoft Excel, then develop and apply an impact crater...
+
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

How Do Plants Grow?

For Teachers 3rd - 5th
Students investigate plant growth. In this plant growth lesson, students investigate what would happen to plants if they did not have water and sunlight. Students conduct experiments to determine what plants need. Students create a...
+
Lesson Plan
Curated OER

May The Force Be With You

For Teachers 8th
Eighth graders investigate Newton's Laws of Motion. They use the example of a roller coaster for illustration purposes. A force associated with a roller coaster is tested, data graphed, and a conclusion is drawn. They use excel in order...
+
Lesson Plan
Curated OER

The Racing Heart

For Teachers 5th
Fifth graders locate their own pulse rate from their carotid or radial artery, and graph their pulse rates after completing various exercise activities. They graph their data on a pie graph using Microsoft Excel software.