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, 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 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 video shows where and how ice cores are extracted from the West Antarctic Ice Sheet. The cores are 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.