Earth Watch Institute
Entering Local Groundhog Data in an Excel Spreadsheet
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...
Curated OER
Science-Observation Skill Builders
Pupils explore observation while making connections between observation skills and careers (like how farmers observe the weather). They view a variety of nature photographs on the computer and practice their observation skills by...
Curated OER
A Comparison Study of Water Vapor Data to Precipitation over North America
Students use NASA satellite data to compare water vapor over the United States. In this data analysis instructional activity students use an Excel spreadsheet to map their data.
Chicago Botanic Garden
GEEBITT (Global Equilibrium Energy Balance Interactive TinkerToy)
Young scholars use the GEEBITT excel model to explore how global average temperatures are affected by changes in our atmosphere in part two of this series of seven lessons. Working in groups, they discuss, analyze graphs, and enter data...
Howard Hughes Medical Institute
Spreadsheet Tutorial 1: Formulae, Functions, and Averages
Spread your knowledge of spreadsheets. The first of five tutorials in the Spreadsheet Data Analysis unit introduces the basics of spreadsheets. It shows future data analysts how to organize and format tables, and how to use functions to...
Captain Planet Foundation
P is for Poppies
Explore the way local farming and rationing helped the war effort in World War I with a lesson plan on gardening. After learning about trench warfare, reading "In Flanders' Field" by John McCrae, and studying poppies, kids discuss...
Curated OER
Think GREEN - Utilizing Renewable Solar Energy
Learners 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.
Curated OER
Tides at the Battery, NY
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...
Teach Engineering
Understanding the Air through Data Analysis
Is there a correlation or causation relationship between air pollutants? Groups develop a hypothesis about the daily variation of air pollutants, specifically ozone and CO2. Using Excel to analyze the data, the groups evaluate their...
Curated OER
Wind Effects- A Case Study
Students explore hurricanes. In this weather data interpretation lesson, students draw conclusions about the impact of Hurricane Floyd as it related to weather conditions. Students read and interpret a tide data table, a barometric...
Chicago Botanic Garden
Micro-GEEBITT Climate Activity
A truly hands-on and inquiry based learning activity bridges all the lessons in the series together. Beginning with a discussion on average global temperatures, young meteorologists use real-world data to analyze climate trends in order...
Curated OER
A Whole Lotta Changin' Goin' On
Here's a fabulous lesson on the life cycle of a butterfly. Youngsters are able to identify and understand the four stages of life. They construct models of a caterpillar and write a sequence story about the life of a butterfly. This...
Curated OER
Autism and Autism Spectrum Disorders: Disorders Extending Beyond the "Norm"
Learners develop an understanding of autism by engaging in an inquiry-based discussion. Pupils are exposed to the vast array of defining characteristics of autism spectrum disorders. They create posters about the developmental...
Curated OER
Conserving Electric Energy
Another fantastic lesson on energy is presented by the American Coal Foundation. This one focuses on electricity; how it is produced, how it is delivered, and how it is used. Some excellent handouts are embedded in this fine plan which...
Curated OER
Fill In The GAPP
Youngsters discover what recycling is and identify things that can be recycled. They use both video and Internet resources to aid them in their study. This is a well-designed lesson plan with excellent activities and a nicely-written...
Curated OER
This Little Light of Mine
Elementary schoolers discover how electricity travels and create an electron flow through a closed circuit. They work together to make a closed circuit and observe the electricity being made. This outstanding lesson plan is well worth...
Curated OER
Current Sources of Energy to Maintain a Sustainable Future
In small groups, fourth graders identify different sources of renewable and non-renewable energy. They research the pros and cons of using each of these resources. They rank household appliances according to energy usage and efficiency....
Chicago Botanic Garden
Calculating Your Carbon Footprint
Unplugging from technology for one day per week will decrease your carbon footprint—are you up to the challenge? Part two in a series of three allows individuals to explore their personal carbon footprints. By first taking a quiz at home...
Smithsonian Institution
Water/Ways: The Poetry of Science
Water is the source of life. It appears in poetry in both peaceful and torrential descriptions; it appears in earth science in its liquid, gaseous, and solid states. Combine these interpretations of our planet's most precious and...
Polar Trec
How Much Data is Enough?
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...
Curated OER
Hurricane Happenings
Fourth and fifth graders engage in this impressive lesson which focuses on the causes of hurricanes and tropical storms. The use of video clips and Internet sites helps facilitate discussion amongst pupils which should lead them to a...
Curated OER
Is Portland, Oregon Experiencing Global Warming?
Students use data to determine if the climate in Portland has changed over the years. In this weather lesson students complete line graphs and study long wave radiation.
Curated OER
Protocol for Backyard Bird Research Project
Students investigate a hypothesis about birds in their backyard using identification and survey skills.
Curated OER
I'm Here, I'm There, I'm Everywhere-I'm Super Spud!
Students generate a computer model of a potato plant. In this potato lesson plan, students study the history of potatoes, the variety of potatoes, the functions of the potato plant parts, and make a potato model on the computer.