In this activity, students work in groups, plotting carbon dioxide concentrations over …
In this activity, students work in groups, plotting carbon dioxide concentrations over time on overheads and estimating the rate of change over five years. Stacked together, the overheads for the whole class show an increase on carbon dioxide over five years and annual variation driven by photosynthesis. This exercise enables students to practice basic quantitative skills and understand how important sampling intervals can be when studying changes over time. A goal is to see how small sample size may give incomplete picture of data.
In this activity, students create graphs of real temperature data to investigate …
In this activity, students create graphs of real temperature data to investigate climate trends by analyzing the global temperature record from 1867 to the present. Long-term trends and shorter-term fluctuations are both evaluated. The data is examined for evidence of the impact of natural and anthropogenic climate forcing mechanisms on the global surface temperature variability. Students are prompted to determine the difficulties scientists face in using this data to make climate predictions.
This multi-week project begins with a measurement of baseline consumptive behavior followed …
This multi-week project begins with a measurement of baseline consumptive behavior followed by three weeks of working to reduce the use of water, energy, high-impact foods, and other materials. The assignment uses an Excel spreadsheet that calculates direct energy and water use as well as indirect CO2 and water use associated with food consumption. After completing the project, students understand that they do indeed play a role in the big picture. They also learn that making small changes to their lifestyles is not difficult and they can easily reduce their personal impact on the environment.
In this activity, students compare carbon dioxide data from Mauna Loa Observatory, …
In this activity, students compare carbon dioxide data from Mauna Loa Observatory, Barrow, Alaska, and the South Pole over the past 40 years. Students use the data to learn about what causes short-term and long-term changes in atmospheric carbon dioxide. This activity makes extensive use of Excel.
In this intermediate Excel activity, students import US Historical Climate Network mean …
In this intermediate Excel activity, students import US Historical Climate Network mean temperature data into Excel from a station of their choice. They are then guided through the activity on how to use Excel for statistical calculations, graphing, and linear trend estimates. The activity assumes some familiarity with Excel and graphing in Excel.
This activity with a lab report instructs students to solve and plot …
This activity with a lab report instructs students to solve and plot 160,000 years' worth of ice core data from the Vostok ice core using Excel or similar spreadsheets to analyze data. Students learn about ice cores and what they can tell us about past atmospheric conditions and the past atmospheric concentrations of CO2 and CH4.
No restrictions on your remixing, redistributing, or making derivative works. Give credit to the author, as required.
Your remixing, redistributing, or making derivatives works comes with some restrictions, including how it is shared.
Your redistributing comes with some restrictions. Do not remix or make derivative works.
Most restrictive license type. Prohibits most uses, sharing, and any changes.
Copyrighted materials, available under Fair Use and the TEACH Act for US-based educators, or other custom arrangements. Go to the resource provider to see their individual restrictions.