Curated OER
Investigating Seasonal Variability in NO2 Concentrations
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.
Curated OER
Polar Bears in Peril - Climate Change Culprit?
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.
Curated OER
Trends of Snow Cover and Temperature in Alaska
High schoolers 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...
Curated OER
Case Study of Local Trends in the Carbon Cycle
Students examine the relationship between chlorophyll and carbon dioxide in the atmosphere. For this investigative lesson students study the local effects of climate change.
North Haven Middle School
Environmental Expert Presentation
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 excellent...
Curated OER
This is the Way We Go To School
Second graders create and utilize a graph using the Excel computer program. They gather data regarding how the students get to school, tally the numbers for the class, and create a bar graph on paper and using Excel.
Curated OER
Fairy Tales
Sixth graders explore the elements of fairy tales. For this fairy tales lesson, 6th graders analyze several versions of Cinderella from around the world. Students graph fairy tale elements using Excel and create Venn diagrams comparing...
Curated OER
Using Excel to Reference and Graph Live Data from a Web Site
Students collect live buoy data about water temperatures in the Gulf of Mexico from the Internet and work individually to organize their data and create a line graph using Excel Spreadsheet. Students analyze their data and examine any...
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....
Curated OER
Graphs! Graphs! Graphs!
Students practice making charts and graphs from data on spreadsheets. Individually, they create a graph representing the latest information on voter registration. They answer questions and analyze the data to end the instructional...
Curated OER
Graphing in Science
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.
Curated OER
Using Imported Data in Excel
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.
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...
Curated OER
Data! Data! Graph that Data!
Fifth graders create data graphs using Microsoft Excel. For this data collection lesson, 5th graders create and conduct a survey, then use Excel to organize and graph their data.
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
Time Management
Learners record their daily activities and graph the results using the educational software program called Inspiration. This instructional activity is intended for the upper-elementary classroom and includes resource links and activity...
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
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...
Yummy Math
Parametric Equations and a Heart
Trigonometry, art, and Valentine's Day come together in a creative activity about parametric equations. Learners calculate several equations before graphing them either by hand, on a graphic calculator, or Excel spreadsheet to curve...
National Council of Teachers of Mathematics
National Debt and Wars
Take a functional approach to the national debt. Learners collect information about the national debt by decade and plot the data. They determine whether an exponential curve is a good fit for the data by comparing the percent changes...
Curated OER
Microsoft Office Excel
Students use Microsoft Office Excel. For this technology lesson, students enter data on a spreadsheet using Excel. This programs tallies data and presents it using graphs.
Curated OER
Using Excel to Draw a Best Fit Line
Students create line graphs for given data in Microsoft Excel. Students follow step by step instructions on how to create their graph, including how to create a trend line. Students print graphs without trend lines and manually draw...
Curated OER
Graphing
Young scholars gather statistical information on a chosen topic and place it into a spreadsheet. Using th Excel chart wizard, students create tables, graphs and charts of their information. They interpret the data and share it with the...
Curated OER
Graph Related Linear Inequalities
High schoolers explore the concept of linear inequalities. In this linear inequality lesson, students graph linear inequalities using Microsoft Excel.