Nitrate Levels in the Rock Creek Park Watershed, Washington DC, 1: Measures of Central Tendency part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum module/Geology of National Parks course. Students examine the histogram of a positively skewed data set and calculate its mean, median and mode.

How Do We Estimate Magma Viscosity? part of Pedagogy in Action:Library:Teaching with SSAC:Examples
SSAC Physical Volcanology module. Students build a spreadsheet to examine how magma viscosity varies with temperature, fraction of crystals, and water content using the non-Arrhenian VFT model.

From Isotopes to Temperature: Working With A Temperature Equation part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum module. Students build a spreadsheet to examine from a dataset the relation between oxygen isotopes in corals and the temperature of surrounding seawater.

What is the Discharge of the Congaree River at Congaree National Park? part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum module/Geology of National Parks course. Students use a rating curve to determine discharge at various stage heights.

Using Excel for Aquifer Test part of Hydrogeology:Activities
Entry level undergraduate students who use commercial software packages for aquifer test often feel frustrated and distant from real field test. This session introduces a method of aquifer test using Excel ...

Something is Askew at Mammoth Cave National Park part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum/Geology of National Parks module. Students use the geometric mean and multiplicative standard deviation to examine the right-skewed distribution of nutrient concentrations in water-quality data at Mammoth Cave National Park.

Exploring Easter Island Economics with Excel part of Integrate:Workshops and Webinars:Systems, Society, Sustainability and the Geosciences:Activities

Flood Recurrence Intervals part of Environmental Geology:Activities
This lab activity has students use stream discharge data obtained from the USGS Water Resources Division web site in order to calculate recurrence intervals for a local stream. Using the recurrence data generated, ...

What are the Winds Blowing into Mammoth Cave? part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum/Geology of National Parks module. Students estimate the net volume of pollutants flowing into the Houchin's Narrows entrance of Mammoth Cave using actual air-flow and air-quality data from the park.

Lithospheric Density part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Students learn about the weighted mean by building spreadsheets that apply this concept to the average density of the oceanic lithosphere.