Pedagogy in Action > Library > Teaching with Spreadsheets > Examples

Examples


Help

Results 11 - 20 of 119 matches

Flood Frequency Analysis part of Cutting Edge:Environmental Geology:Activities
This assignment asks students to do a flood frequency analysis to determine the size and stage of various floods and determine if the town of Crawford, OH is likely to be flooded or not. Outcomes: learn to work ...

Flood Recurrence Intervals part of Cutting Edge: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 can zircons tell us about the Early Earth? part of Cutting Edge:Early Earth:Activities
This image shows an array of Jack Hill zircons arranged on a piece of tape prior to casting in epoxy. Details Students create U-Pb concordia plots in Excel to experience the methods used to date the worlds oldest ...

Flood Days and Good Canoeing Days at Congaree National Park part of Pedagogy in Action:Library:Teaching with SSAC:Examples
SSAC Geology of National Parks module/Geology of National Parks course. Students calculate probabilities using USGS hydrograph data, a spreadsheet of daily stage heights, and the COUNTIF function.

Shaking Ground - Linking Earthquake Magnitude and Intensity part of Pedagogy in Action:Library:Teaching with SSAC:Examples
An in-class activity for connecting earthquake magnitude, shaking, and intensity.

Deciviews from Look Rock, Great Smoky Mountains National Park: How Hazy is it? part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum/Geology of National Parks module. Students calculate the haze index and standard visual range from concentrations of particulate matter.

Mapping Coastal Vulnerability to Sea-Level Rise at Point Reyes National Seashore part of Pedagogy in Action:Library:Teaching with SSAC: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.

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.

Frequency of Large Earthquakes -- Introducing Some Elementary Statistical Descriptors part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum module. Students examine the number of large earthquakes (magnitude 7 and above) per year for 1970-1999 and 1940-1999. QL: descriptors of a frequency distribution.

How Do We Estimate Melt Density? part of Pedagogy in Action:Library:Teaching with SSAC:Examples
SSAC Physical Volcanology module. Students build spreadsheets to estimate melt density at high temperatures and pressures from the thermodynamic properties of silicates.