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...
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
Determining the Density of a Liquid
Students find the density of diet soda and regular soda. In this density lesson plan, students measure the mass of a graduated cylinder with 10 different volumes of each soda. They find the mass of the liquid alone and use the volume to...
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
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.
Teach Engineering
Using Hooke's Law to Understand Materials
Provide a Hooke for a lesson on elasticity with an activity that has groups investigate a set of springs. They use a set procedure to collect data to calculate the spring constant for each spring using Hooke's Law. The groups...
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...
Teach Engineering
Energy Perspectives
The data says ... the resource is great to use. Using Microsoft Excel, pupils analyze data from the US Department of Energy in the fifth lesson of a 25-part Energy Systems and Solutions unit. Each group looks at a different data set and...
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
Water Chestnut Graphing Activity
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...
Curated OER
Historical Pollution in the Hudson: Part 2
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...
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
Graphing Weather
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....
Teach Engineering
The Energy Problem
Think you can solve the energy problem? You'll first need to know about current energy use. Analyzing a set of circle graphs lets scholars see where energy consumption is the greatest, both by sector and by household use. They develop a...
Curated OER
Presenting Painless Breast Cancer Detection!
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.
Earth Watch Institute
Entering Local Groundhog Data in an Excel Spreadsheet
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...
Curated OER
Does Humidity Affect Cloud Formation?
Students use S'COOL data to identify factors that affect cloud formation. They find a data set using the S'COOL database , and use Excel to manipulate the data. Student isolate relevant data, create meaningful graphs from a spreadsheet,...
Curated OER
Graphing Iron Data
Students 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
Polar Bears in Peril - Climate Change Culprit?
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.
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
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...
National Wildlife Federation
I’ve Got the POWER! Solar Energy Potential at Your School
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...
Curated OER
Wind Effects- A Case Study
Students explore hurricanes. In this weather data interpretation instructional activity, students draw conclusions about the impact of Hurricane Floyd as it related to weather conditions. Students read and interpret a tide data...