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 describes the role that dendrochronology plays in understanding climate change, especially changes to high elevation environments at an upper tree line. Dendrochronologists from the Big Sky Institute sample living and dead trees, describe how correlations between trees are made, and explain how tree cores record climate changes.
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 interactive visualization describes how climatologists obtain and interpret evidence from the Greenland Ice Sheet in an effort to piece together a picture of Earth's distant climate history. Resource describes how glaciers form and how they can be used to collect ancient atmospheric data. The issues analyzed in the data collection are particularly good in showing how science is done in the field.
This is a figure from the 2007 IPCC Assessment Report 4 on atmospheric concentrations of carbon dioxide, methane and nitrous oxide over the last 10,000 years (large panels) and since 1750 (inset panels).
In this video, students learn that scientific evidence strongly suggests that different regions on Earth do not respond equally to increased temperatures. Ice-covered regions appear to be particularly sensitive to even small changes in global temperature. This video segment adapted from NASA's Goddard Space Flight Center details how global warming may already be responsible for a significant reduction in glacial ice, which may in turn have significant consequences for the planet.
In this activity, students will practice the steps involved in a scientific investigation as they learn why ice formations on land (and not those on water) will cause a rise in sea level upon melting. This is a discovery lesson in ice and water density and displacement of water by ice floating on the surface as it relates to global climate change.
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.