Denise Davis

Spreadsheet Warm Up for SSAC Geology of National Parks Modules, 2: Elementary Spreadsheet Manipulations and Graphing Tasks part of Pedagogy in Action:Partners:Spreadsheets Across the Curriculum:Geology of National Parks:Examples
Spreadsheets Across the Curriculum/Geology of National Parks module. The second of two tutorials. Focuses on modifying spreadsheets (e.g., copy/paste, insert, sort) and creating and modifying graphs.

Nitrate Levels in the Rock Creek Park Watershed, Washington DC, 1: Measures of Central Tendency part of Pedagogy in Action:Partners:Spreadsheets Across the Curriculum:Geology of National Parks: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.

Nitrate Levels in the Rock Creek Park Watershed, Washington DC, 2: Variability part of Pedagogy in Action:Partners:Spreadsheets Across the Curriculum:Geology of National Parks:Examples
Spreadsheets Across the Curriculum module/Geology of National Parks course. Students calculate standard deviation and z-values to examine a possible outlier in a positively skewed data set.

What Does the Mean Mean? Describing Eruptions at Riverside Geyser, Yellowstone National Park part of Pedagogy in Action:Partners:Spreadsheets Across the Curriculum:Geology of National Parks:Examples
Spreadsheets Across the Curriculum/Geology of National Parks module. Students study measures of central tendency in a bimodal dataset of eruption intervals.

Just How Faithful is Old Faithful? Finding Order in Random Behavior part of Pedagogy in Action:Partners:Spreadsheets Across the Curriculum:Geology of National Parks:Examples
Spreadsheets Across the Curriculum/Geology of National Parks Collection. Students create a histogram to examine the time between geyser eruptions of Old Faithful, Yellowstone National Park.

Comparing Stream Discharge in Two Watersheds in Glacier National Park part of Pedagogy in Action:Partners:Spreadsheets Across the Curriculum:Geology of National Parks:Examples
Spreadsheets Across the Curriculum module/Geology of National Parks course. Students study how discharge per unit area varies with elevation in the high country of Glacier National Park from USGS hydrograph data from Swiftcurrent Creek and its tributary Grinnell Creek..

Shifting Sands: Quantifying Shoreline and Dune Migration at Indiana Dunes National Lakeshore part of Pedagogy in Action:Partners:Spreadsheets Across the Curriculum:Geology of National Parks:Examples
Spreadsheets Across the Curriculum module/Geology of National Parks course. Students use weighted averages and data from air photos from 1939 to 2005 to calculate the rate of retreat of the shoreline and the advance of the front of dunes along the shoreline.

A Percentage Stroll through Norris Geyser Basin, Yellowstone National Park part of Pedagogy in Action:Partners:Spreadsheets Across the Curriculum:Geology of National Parks:Examples
Spreadsheets Across the Curriculum module/Geology of National Parks course. Students calculate percentages and percent differences to compare various measures of fumaroles, mud pots, hot springs and geysers in this introduction to hydrothermal features at Yellowstone NP.

Dunes, Boxcars, and Ball Jars: Mining the Great Lakes Shores part of Pedagogy in Action:Partners:Spreadsheets Across the Curriculum:Geology of National Parks:Examples
Spreadsheets Across the Curriculum module/Geology of National Parks course. Students estimate the volume of sand in Hoosier Slide, a large dome-shaped dune quarried away in the 1920s from what is now Indiana Dunes National Lakeshore. They also estimate the number of boxcars to carry the sand, and the number of Ball jars produced from it.

Yellowstone! A National Park on a Hot Spot part of Pedagogy in Action:Partners:Spreadsheets Across the Curriculum:Geology of National Parks:Examples
Spreadsheets Across the Curriculum module/Geology of National Parks course. Students use foundational math to study the velocity of the North American Plate over the hot spot, the volume of eruptive materials from it, and the recurrence interval of the cataclysmic eruptions.

Mapping Coastal Vulnerability to Sea-Level Rise at Point Reyes National Seashore part of Pedagogy in Action:Partners:Spreadsheets Across the Curriculum:Geology of National Parks:Examples
Spreadsheets Across the Curriculum/Geology of National Parks module. Students work with a color-coded conditional-formatted spreadsheet map to work through a USGS report applying a coastal vulnerability index.

Salmon Use of Geomorphically Restored Streams at Point Reyes National Seashore part of Pedagogy in Action:Partners:Spreadsheets Across the Curriculum:Geology of National Parks:Examples
Spreadsheets Across the Curriculum module/Geology of National Parks course. Students work with salmon-trace streambed data to study whether removal of a spawning run barrier was effective

Mined-Over Matter: Remembering Copper Mining at Keweenaw National Historic Park, Upper Peninsula Michigan part of Pedagogy in Action:Partners:Spreadsheets Across the Curriculum:Geology of National Parks:Examples
Spreadsheets Across the Curriculum/Geology of National Parks module. Students calculate the amount of rock removed and the value of copper produced at the great Keweenaw District up to 1925.

Let's Take a Hike in Catoctin Mountain Park part of Pedagogy in Action:Partners:Spreadsheets Across the Curriculum:Geology of National Parks:Examples
Spreadsheets Across the Curriculum module/Geology of National Parks course. Students use a topographic map and spreadsheet to find how many Big Macs they burned off on a five-mile hike at Catoctin Mountain Park.

Getting to the Point: Exploring Tectonic Motion at Point Reyes National Seashore part of Pedagogy in Action:Partners:Spreadsheets Across the Curriculum:Geology of National Parks:Examples
Spreadsheets Across the Curriculum module/Geology of National Parks course. Students use foundational math to calculate such earthquake-related numbers as fault displacement rate and earthquake recurrence interval associated with the San Andreas Fault at Point Reyes National Seashore.