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 examine climate variability in the North Atlantic associated with the North Atlantic Oscillation (NOA) in a case study format.

In this activity, students are guided through the process of locating and graphing web-based environmental data that has been collected by GLOBE Program participants using actual data collected by students in Pennsylvania and comparing them to their local climatic boundary conditions. This activity highlights the opportunities for using GLOBE data to introduce basic concepts of Earth system science.

In this activity, students review techniques used by scientists as they analyze a 50-year temperature time series dataset. The exercise helps students understand that data typically has considerable variability from year to year and to predict trends, one needs to consider long-term data.

In this activity, students are guided through graphs of surface air temperature anomaly data and Vostok ice core data to illustrate how scientists use these data to develop the basis for modeling how climate is likely to change in the future.

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 lesson, students examine and interpret varied observational datasets and are asked to determine whether the data supports or does not support the statement: climate change is occurring in Colorado.

In this 6-part activity, students learn about climate change during the Cenozoic and the abrupt changes at the Cretaceous/Paleogene boundary (65.5 million years ago), the Eocene/Oligocene boundary (33.9 million years ago), and the Paleocene/Eocene boundary (55.8 million years ago).

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.

For this lesson, the guiding Concept Question is: What is climate change and how does climate relate to greenhouse gas concentrations over time? This activity is the second lesson in a nine-lesson module 'Visualizing and Understanding the Science of Climate Change' produced by the International Year of Chemistry project (2011).

Pages