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.

In this video scientists discuss possible rates of sea level rise, storms and resulting damage, rising temperatures and melting ice, and their collective effects on ecosystems.

In this activity, students consider Greenland reflectivity changes from 2000 to 2012 and what albedo anomalies may indicate about how the Greenland ice sheet is changing in a case study format.

In this activity, students will use oxygen isotope values of two species of modern coral to reconstruct ambient water temperature over a four-year period. They use Microsoft Excel, or similar application, to create a spreadsheet of temperature values calculated from the isotope values of the corals by means of an algebraic equation. Students then use correlation and regression techniques to determine whether isotope records can be considered to be good proxies for records of past temperatures.

This is an interactive graph that involves records of ice cover in two Wisconsin lakes - Lake Mendota and Lake Monona - from 1855-2010.

This animation depicts global surface warming as simulated by NCAR's Community Climate System Model (CCSM) Version 3. It shows the temperature anomalies relative to the end of the 19th century, both over the entire globe and as a global average. The model shows the temporary cooling effects during 5 major volcanic eruptions and estimates future temperature trends based on different amounts of greenhouse gas emissions.

In this activity, students use authentic Arctic climate data to unravel some causes and effects related to the seasonal melting of the snowpack and to further understand albedo.

In this activity, students examine climate variability in the North Atlantic associated with the North Atlantic Oscillation (NOA) in a case study format.

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.

This short video, adapted from NOVA, explains how Earth's position relative to the Sun might be responsible for the dramatic shift in the climate of what is now the Saharan nation of Djibouti.

Pages