A Quantitative Visualization of Mantle Melting part of Pedagogy in Action:Library:Spatial Reasoning with GeoClick Questions:Examples
Hannah Shamloo, Oregon State University
Here is an exercise to acquaint students with pressure-temperature diagrams related to Earth's interior, teach why the mantle melts in the context of pressure and temperature, demonstrate the role water has on melting, and review the three ways to melt the mantle.

What is the Volume of the 1992 Eruption of Cerro Negro Volcano, Nicaragua? part of Pedagogy in Action:Partners:Spreadsheets Across the Curriculum:Physical Volcanology:Examples
chuck connor, University of South Florida-St. Petersburg
SSAC Physical Volcanology module. Students build a spreadsheet to calculate the volume a tephra deposit using an exponential-thinning model.

Porosity and Permeability of Magmas part of Pedagogy in Action:Partners:Spreadsheets Across the Curriculum:Physical Volcanology:Examples
chuck connor, University of South Florida-St. Petersburg
SSAC Physical Volcanology module. Students build a spreadsheet for an iterative calculation to find volume of bubbles and hence porosity, permeability and gas escape as a function of depth.

Glacier (?) National Park part of Pedagogy in Action:Partners:Spreadsheets Across the Curriculum:Geology of National Parks:Examples
Judy McIlrath, University of South Florida
Spreadsheets Across the Curriculum/Geology of National Parks module. Students examine data about the disappearing glaciers in the park; after calculating percentage change in the number of glaciers from 1850 to 2000, they interpolate to estimate when Grinnell glacier will be gone.

Chemical Equilibrium Misconceptions part of Pedagogy in Action:Library:Mathematical and Statistical Models:Examples
Barry Bickmore, Brigham Young University
This STELLA modeling and writing assignment helps students confront and replace common misconceptions about chemical equilibrium.

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
Module by: Dorien McGee, Meghan Lindsay, Len Vacher, University of South Florida Cover Page by: Len Vacher and Denise Davis, University of South Florida
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.

What is the Discharge of the Congaree River at Congaree National Park? part of Pedagogy in Action:Partners:Spreadsheets Across the Curriculum:Geology of National Parks:Examples
Denise Davis, University of South Florida-St. Petersburg
Spreadsheets Across the Curriculum module/Geology of National Parks course. Students use a rating curve to determine discharge at various stage heights.

Something is Askew at Mammoth Cave National Park part of Pedagogy in Action:Partners:Spreadsheets Across the Curriculum:Geology of National Parks:Examples
Module by: Amie O. West, University of South Florida Cover Page by: Amie O. West, University of South Florida
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.

How Does Surface Deformation at an Active Volcano Relate to Pressure and Volume Change in the Magma Chamber? part of Pedagogy in Action:Partners:Spreadsheets Across the Curriculum:Physical Volcanology:Examples
Peter LaFemina, Pennsylvania State University-Main Campus
SSAC Physical Volcanology module. Students build a spreadsheet to examine and apply the Mogi model for horizontal and vertical surface displacement vs. depth and pressure conditions in the magma chamber.

What is the Relationship between Lava Flow Length and Effusion Rate at Mt Etna? part of Pedagogy in Action:Partners:Spreadsheets Across the Curriculum:Physical Volcanology:Examples
chuck connor, University of South Florida-St. Petersburg
SSAC Physical Volcanology module. Students use Excel to determine a log-log relationship for flow length vs effusion rate and compare it with a theoretical expression for the maximum flow length.