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.
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 from ClimateCentral looks at the way climate conditions can affect vegetation in the West, and what influence this has on wildfires. Drought and rainfall can have very different wildfire outcomes, depending on vegetation type, extent, and location.
This is a real-time map of current drought conditions in the US, which can be zoomed to the state level, with access to many more resources at that level. Some of these include the National Drought Regional Summaries and animations of historical data.
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).
This is a multi-faceted activity that offers students a variety of opportunities to learn about permafrost through an important sink and source of greenhouse gas (methane), about which most students living in lower latitudes know little.