Curated OER
Hemlock Trees and the Pesky Pest, The Woolly Adelgid
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...
Curated OER
Does cloud type affect rainfall?
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...
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 activities...
Curated OER
Creating Climographs
Students use satellite data to compare precipitation and surface temperatures on different islands. For this satellite lesson students create graphs and explain the differences between weather and climate.
Earth Watch Institute
Entering Local Groundhog Data in an Excel Spreadsheet
Here is a cross-curricular ecology and technology lesson plan; 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
Data Collection
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.
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...
Towson University
Looking Backwards, Looking Forward
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...
Curated OER
Fast Food Survey Using Bar Graphs
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.
Curated OER
Graphing and Analyzing Biome Data
Students explore biome data. In this world geography and weather data analysis lesson, students record data about weather conditions in North Carolina, Las Vegas, and Brazil. Students convert Fahrenheit degrees to Celsius degrees and use...
Curated OER
Polar Bears in Peril - Climate Change Culprit?
Students explore the changes in sea ice over several years. In this life science lesson, students review and examine 20 years of data. They use Excel to graph data and analyze trends.
Curated OER
Graphing Weather
Students make a graph. In this weather instructional activity, students fill in a KWL chart about different types of weather. Students watch a PowerPoint presentation about weather and natural disasters and where these types of weather...
Curated OER
Curious Clouds
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.
Curated OER
What Goes Up Must Come Down!!
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...
Curated OER
Precipitation in Michigan Cities
Third graders investigate the rainfall amounts in four Michigan cities to observe how cities near lakes are affected differently by precipitation than those that are inland. They record the rainfall for the cities over an eight day...
Curated OER
Shake, Rattle, and Roll: Mt. St. Helens - Lesson Plan 2
Students compile information on volcanic activity at Mount St. Helens. In this earth science lesson plan, students use the information they gathered on Mount St. Helens to answer questions and create charts in Excel. Then students...
Curated OER
Graphing Iron Data
Learners apply a data set to create a graph show how iron ore impacts an ecosystem. They explain how the iron effects the distribution and abundance of phytoplankton in coastal ecosystems using spreadsheet software.
Curated OER
The Stoichiometry Behind Pollution
Students research car emissions of various cars and find the toxins emitted. In this stoichiometry lesson, students calculate the relationship between reactants and products in a chemical reaction. Students collect data on emissions and...
Curated OER
Excel temperature Graphs
Learners 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. Learners will find the average weather and add a trend line to their graph.
Curated OER
Endangered Species
In this geography instructional activity, 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...
Curated OER
How Do Plants Grow?
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...
Curated OER
Science in Focus: Force and Motion
Students explore force and motion through a series of experiments. In this physics lesson plan, students create and interpret speed graphs. They build an electromagnet and explain the factors affecting its strength.
Curated OER
Stress, Strain and Hooke's Law
Students study Hooke's Law and stress-strain relationships. In this spring lesson plan students create a strain graph in Microsoft Excel.
Curated OER
Does Cloud Type Affect Rainfall?
Student uses MY NASA DATA to obtain precipitation and cloud type data. They create graphs of data within MY NASA DATA. They compare different cloud types as well as precipitation types. They describe graphs of the precipitation and cloud...