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.
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 video considers the current estimates of sea level rise as possibly too conservative and discusses more recent data on ice melt rates coming from Antarctica and Greenland, showing rates of melt at up to 5 times as rapid. Scientists discuss what levels and rates of sea level rise have occurred in the past, including the Pliocene, which demonstrated 1m rise every 20 years.
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 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.
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.