# SSAC Geologic Hazards Modules

Following are short descriptions of the available modules. To access any of them, select from the list and you will connect to cover material including learning goals, context of use, and other information. Within the cover material (under "Teaching Materials") there is a link by which you can download the student version of the module. You can also request an instructor's version by clicking on the "request" link under Teaching Materials.

To find content, use the search box for a full text search of title, author, and text of the cover pages of the modules. Refined results can be seen in the boxes on the right side of the page.

# Quantitative Concepts

# Excel Skills

Results 1 - 9 of **9 matches**

Lithospheric Density part of Examples

Tom Juster, University of South Florida

Students learn about the weighted mean by building spreadsheets that apply this concept to the average density of the oceanic lithosphere.

Excel Skills: Basic Arithmetic:Arithmetic Functions:SUM, Basic Arithmetic:Simple Formulas, Logic Functions:IF

Subject: Earth & Space Science:Geology:Plate Tectonics, Earth & Space Science, Physics:Classical Mechanics

Introduction to Hazard and Risk: Part 1 part of Examples

Tom Juster, University of South Florida

Students are are introduced to Excel and its capabilities by building some simple spreadsheets.

Excel Skills: Statistical Functions, Basic Arithmetic:Arithmetic Functions:SUM, Statistical Functions:One array:COUNT, COUNTA, Basic Arithmetic, Simple Formulas, Arithmetic Functions, Statistical Functions:One array:AVERAGE, Statistical Functions:One array

Subject: Earth & Space Science,

How often do earthquakes occur? part of Examples

Tom Juster, University of South Florida

Students use spreadsheet tables and charts to explore the relationship between earthquake magnitude and frequency.

Excel Skills: Graphs and Charts:XY Scatterplot, Graphs and Charts, XY Scatterplot:Log Scale, Basic Arithmetic, Other Elementary Math Functions:EXP, Graphs and Charts:XY Scatterplot:Trendlines, Basic Arithmetic:Arithmetic Functions:SUM, Basic Arithmetic:Simple Formulas, Other Elementary Math Functions:LOG, LOG10, Graphs and Charts:XY Scatterplot:Multiple Plots

Subject: Earth & Space Science:Geology, Geology:Earthquakes & Volcanoes, Earth & Space Science, , Earth & Space ScienceGeologyPlate Tectonics, Environmental Science, Physics:Oscillations & Waves, Environmental Science:Natural Hazards

Tale of Two Cities (and two hurricanes): New Orleans part of Examples

Tom Juster, University of South Florida

Students use spreadsheets to analyze the reasons why New Orleans has subsided in the past 250 years.

Excel Skills: Basic Arithmetic, Simple Formulas, Arithmetic Functions:SUM, Basic Arithmetic:Percent (format)

Subject: Earth & Space Science:Ground & Surface Water, Processes that Shape Earth's Surface, Atmospheric & Climate Science:Climate Change, Earth & Space Science

Introduction to Hazard and Risk: Part 2 part of Examples

Tom Juster, University of South Florida

Students continue their introduction to Excel by building spreadsheets that estimate the risk of a major earthquake along the Cascadia Subduction Zone to Benton County, Oregon.

Excel Skills: Basic Arithmetic:Simple Formulas

Subject: Earth & Space Science:Geology:Plate Tectonics, Earth & Space Science,

Tsunami-Time part of Examples

Tom Juster, University of South Florida

Students build spreadsheets to compute the time it takes a tsunami wave to pass over different regions of the ocean.

Excel Skills: Basic Arithmetic:Arithmetic Functions:SUM, Basic Arithmetic, Simple Formulas

Subject: Physics:Oscillations & Waves

Assessing earthquake risk: How often does the Big One occur? part of Examples

Tom Juster, University of South Florida

Students use spreadsheet tables and charts to explore the Gutenberg-Richter relationship between an earthquakes magnitude and recurrence interval.

Subject: Earth & Space Science

Tale of Two Cities (and two hurricanes): Miami part of Examples

Tom Juster, University of South Florida

Students use a spreadsheet to compute the hypothetical risk of an Andrew-like hurricane to downtown Miami.

Excel Skills: Statistical Functions, One array, Basic Arithmetic:Percent (format), Basic Arithmetic, Statistical Functions:One array:COUNT, COUNTA, Basic Arithmetic:Simple Formulas, Arithmetic Functions, Statistical Functions:One array:AVERAGE, Basic Arithmetic:Arithmetic Functions:SUM, Statistical Functions:One array:MAX, MIN, etc

Subject: Earth & Space Science

Lithospheric Density part of Examples

Tom Juster, University of South Florida

Students learn about the weighted mean by building spreadsheets that apply this concept to the average density of the oceanic lithosphere.

Excel Skills: Logic Functions:IF, Basic Arithmetic:Simple Formulas, Arithmetic Functions:SUM

Subject: Physics:Classical Mechanics, Earth & Space Science:Geology:Plate Tectonics, Earth & Space Science