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 interactive lets students determine the extent of average temperature change both in their community and anywhere else in the world, relative to average temperatures for the three decades between 1951 and 1980.
This narrated slideshow describes the impact of sea level rise on Tuvalu, one of the low-lying island nations in the South Pacific. As the frequency and intensity of floods and cyclones increases, the island is shrinking and saltwater intrusion is affecting local food production on the plantations. As a result, many residents are moving off the island to New Zealand, where they face major cultural changes.
In this visualization, students can explore North American fossil fuel CO2 emissions at very fine space and time scales. The data is provided by the Vulcan emissions data project, a NASA/DOE funded effort under the North American Carbon Program (NACP).
This video is one of a series of videos from the Switch Energy project. It describes three types of geothermal sources -- rare ones in which high temperatures are naturally concentrated near the surface, deep wells that require fracturing the rock and then circulating water to bring heat to the surface, and low temperature sources that use constant temperatures just below the surface to heat or cool a building. The latter two are more widely available but cost-prohibitive today.
This short cartoon video uses a simple baseball analogy (steroid use increases probability of hitting home runs) to explain how small increases in greenhouse gases can cause global temperature changes and increase the probability of extreme weather events.
In this video segment, two students discuss the greenhouse effect and visit with research scientists at Biosphere 2 in Arizona, who research the effects of global climate change on organisms in a controlled facility. Their current research (as of 2002) focuses on the response to increased quantities of CO2 in a number of different model ecosystems.
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.