Lesson Plan
Curated OER

Historical Pollution in the Hudson: Part 2

For Teachers 9th
Ninth graders practice how to format and enter data into an Excel spreadsheet, make a graph, and interpret graphed data. They recognize how the pollution in the Hudson River has changed over time, and explain the consequences of these...
Lesson Plan
Curated OER

Hemlock Trees and the Pesky Pest, The Woolly Adelgid

For Teachers 5th - 6th
Students 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 one...
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...
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...
Activity
Teach Engineering

Applying Statistics to Nano-Circuit Dimensions in Fabrication

For Students 11th - 12th Standards
Do flexible circuits change dimensions during fabrication? Groups use GeoGebra software to measure the length of pictures of flexible nano-circuits. To determine if the circuits change dimensions, future engineers use Microsoft...
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
Space Awareness

The Climate in Numbers and Graphs

For Teachers 6th - 10th Standards
Weather versus climate: weather relates to short time periods while climate averages the weather of a period of many years. Scholars learn about average temperature and precipitation in various climate zones and then apply statistics...
Lesson Plan
Curated OER

Presenting Painless Breast Cancer Detection!

For Teachers 10th - 12th
Students depict a tumor inside a healthy body using a graph in Microsoft Excel. in this breast cancer lesson plan, students also design a brochure that advertises a new form of painless breast cancer treatment.
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
Jason Learning

Tech in the Cycle

For Students 9th - 12th Standards
It might not be easy, but it is worth recycling electronics. Small groups determine the percentage of the materials that make up an iPad 2 and display the information in a circle graph. They then research the recycling process for...
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
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...
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
National Wildlife Federation

I’ve Got the POWER! Solar Energy Potential at Your School

For Teachers 9th - 12th Standards
Should every school have solar panels? The 19th activity in a series of 21 has scholars research the feasibility of using solar panels at their school. They begin by gathering data on the solar energy in the area before estimating the...
Lesson Plan
Curated OER

Water Chestnut Graphing Activity

For Teachers 9th - 12th
Students are taught how to format and enter data into an Excel spreadsheet. They make a graph and interpret graphed data. Students discuss possible impacts of water chestnut invasion. They graph data on water chestnut. Students report...
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

Investigating Seasonal Variability in NO2 Concentrations

For Teachers 8th - 10th
Young scholars study different formats of data and determine the nitrogen dioxide concentrations.  In this seasons instructional activity students understand the different relationships that NO2 can have.
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

Trends of Snow Cover and Temperature in Alaska

For Teachers 9th - 12th
Students gather historical snow cover and temperature data from the MY NASA DATA Web site. They compare this data to data gathered using ground measurements from the ALISON Web site for Shageluk Lake. They graph both sets of data and...
Lesson Plan
Curated OER

Case Study of Local Trends in the Carbon Cycle

For Teachers 10th - 12th
Students examine the relationship between chlorophyll and carbon dioxide in the atmosphere.  In this investigative lesson plan students study the local effects of climate change. 
Activity
North Haven Middle School

Environmental Expert Presentation

For Teachers 6th - 12th
Individuals or groups select an environmental issue, then spend time researching and creating a presentation to share in class. By allowing learners to choose the issue that matters most to them, you will motivate them to do...
Lesson Plan
Curated OER

Graphing Weather

For Teachers 2nd - 3rd
Students make a graph. In this weather lesson, 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 are common....
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

Using Imported Data in Excel

For Teachers 7th - 10th
Young scholars import atmospheric data from the internet. In this earth science lesson, students graph the data they collected. They complete the worksheet after the activity.

Other popular searches