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 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 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 (1870-1899), both over the entire globe and as a global average. The model shows the temporary cooling effects during the 5 major volcanic eruptions of this time period, and then the model's estimates of warming under the different scenarios taken from the fourth IPCC report.

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 video shows where and how ice cores are extracted from the West Antarctic Ice Sheet (WAIS), cut, packaged, flown to the ice core storage facility in Denver, further sliced into samples, and shipped to labs all over the world where scientists use them to study indicators of climate change from the past.

This activity focuses on reconstructing the Paleocene-Eocene Thermal Maximum (PETM) as an example of a relatively abrupt global warming period. Students access Integrated Ocean Drilling Program (IODP) sediment core data with Virtual Ocean software in order to display relevant marine sediments and their biostratigraphy.

This video is the second of a three-video series in the Sea Change project, which follows the work of Dr. Maureen Raymo, paleogeologist at Columbia University's Lamont-Doherty Earth Observatory, who travels with fellow researchers to Australia in search of evidence of sea level that was once higher than it is today.

This teaching activity is an introduction to how ice cores from the cryosphere are used as indicators and record-keepers of climate change as well as how climate change will affect the cryosphere.

This is a simulation that illustrates how temperature will be affected by global CO2 emission trajectories. It addresses the issue that even if global emissions begin to decrease, the atmospheric concentration of CO2 will continue to increase, resulting in increased global temperatures.

In this activity, students download historic temperature datasets and then graph and compare with different locations. As an extension, students can download and examine data sets for other sites to compare the variability of changes at different distinct locations, and it is at this stage where learning can be individualized and very meaningful.

Pages