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.

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.

Skip to search results Skip to search facet filtersSkip to text search formSkip to pagination

Results 1 - 9 of 9 matches

Lithospheric Density part of Examples
Thomas 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.

Quantitative Concepts: Basic arithmetic; Number sense:Average; weighted average
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

Assessing earthquake risk: How often does the Big One occur? part of Examples
Thomas Juster, University of South Florida
Students use spreadsheet tables and charts to explore the Gutenberg-Richter relationship between an earthquakes magnitude and recurrence interval.

Quantitative Concepts: Basic arithmetic; Number sense
Subject: Earth & Space Science

Lithospheric Density part of Examples
Thomas 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.

Quantitative Concepts: Basic arithmetic; Number sense:Average; weighted average
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

Tale of Two Cities (and two hurricanes): New Orleans part of Examples
Thomas Juster, University of South Florida
Students use spreadsheets to analyze the reasons why New Orleans has subsided in the past 250 years.

Quantitative Concepts: Basic arithmetic; Number sense:Rates:Rates of Change, Basic arithmetic; Number sense:Rates, Number operations:Number operations: addition, subtraction, multiplication, division, Basic arithmetic; Number sense:Comparisons; percent difference, change, increase, Estimation, Basic arithmetic; Number sense, Algebra; Modeling; Functions:Modeling:Forward modeling, Algebra; Modeling; Functions:Modeling, Algebra; Modeling; Functions, Creating and manipulating tabular data, Measurement; Data presentation and analysis; Probability:Uncertainty:Manipulating tabular data, Measurement; Data presentation and analysis; Probability:Uncertainty
Excel Skills: Basic Arithmetic:Arithmetic Functions:SUM, Basic Arithmetic:Percent (format), Simple Formulas, Basic Arithmetic
Subject: Earth & Space Science:Processes that Shape Earth's Surface, Ground & Surface Water, Atmospheric & Climate Science:Climate Change, Earth & Space Science

Tale of Two Cities (and two hurricanes): Miami part of Examples
Thomas Juster, University of South Florida
Students use a spreadsheet to compute the hypothetical risk of an Andrew-like hurricane to downtown Miami.

Quantitative Concepts: Basic arithmetic; Number sense:Ratio and proportion; percentage; interpolation, Unit conversions, Average; weighted average, Number operations:Number operations: addition, subtraction, multiplication, division, Basic arithmetic; Number sense:Units and Dimensions:Unit Conversions, Basic arithmetic; Number sense:Units and Dimensions, Basic arithmetic; Number sense, Measurement; Data presentation and analysis; Probability:Gathering data , Descriptive statistics; trend lines :Mean
Excel Skills: Basic Arithmetic:Arithmetic Functions:SUM, Basic Arithmetic:Arithmetic Functions, Percent (format), Simple Formulas, Basic Arithmetic, Statistical Functions:One array:COUNT, COUNTA, AVERAGE, MAX, MIN, etc, Statistical Functions:One array, Statistical Functions
Subject: Earth & Space Science

Introduction to Hazard and Risk: Part 1 part of Examples
Thomas Juster, University of South Florida
Students are are introduced to Excel and its capabilities by building some simple spreadsheets.

Quantitative Concepts: Basic arithmetic; Number sense:Number operations:Number operations: addition, subtraction, multiplication, division, Basic arithmetic; Number sense:Order of operations, Basic arithmetic; Number sense
Excel Skills: Basic Arithmetic:Arithmetic Functions:SUM, Basic Arithmetic:Arithmetic Functions, Simple Formulas, Basic Arithmetic, Statistical Functions:One array:COUNT, COUNTA, AVERAGE, Statistical Functions:One array, Statistical Functions
Subject: Earth & Space Science

How often do earthquakes occur? part of Examples
Thomas Juster, University of South Florida
Students use spreadsheet tables and charts to explore the relationship between earthquake magnitude and frequency.

Quantitative Concepts: Basic arithmetic; Number sense:Unit conversions, Number operations:Number operations: addition, subtraction, multiplication, division, Basic arithmetic; Number sense:Logarithms; orders of magnitude; scientific notation, Units and Dimensions:Unit Conversions, Basic arithmetic; Number sense:Units and Dimensions, Basic arithmetic; Number sense, Algebra; Modeling; Functions:Straight lines and linear functions:Slope, intercept; linear trends, Algebra; Modeling; Functions:Straight lines and linear functions, Nonlinear functions of a single variable:Exponential function, Logarithmic function, Algebra; Modeling; Functions:Nonlinear functions of a single variable, Measurement; Data presentation and analysis; Probability:Gathering data , Visual display of data :XY scatter plots, Logarithmic scale, Reading graphs, Measurement; Data presentation and analysis; Probability:Visual display of data , Measurement; Data presentation and analysis; Probability
Excel Skills: Basic Arithmetic:Arithmetic Functions:SUM, Basic Arithmetic:Simple Formulas, Basic Arithmetic, Other Elementary Math Functions:EXP, LOG, LOG10, Graphs and Charts:XY Scatterplot:Multiple Plots, Trendlines, Log Scale, Graphs and Charts:XY Scatterplot, Graphs and Charts
Subject: Earth & Space Science:Geology:Plate Tectonics, Earthquakes & Volcanoes, Earth & Space Science:Geology, Earth & Space Science, Environmental Science:Natural Hazards, Environmental Science, Physics:Oscillations & Waves

Introduction to Hazard and Risk: Part 2 part of Examples
Thomas 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.

Quantitative Concepts: Basic arithmetic; Number sense:Unit conversions, Number operations:Number operations: addition, subtraction, multiplication, division, Basic arithmetic; Number sense:Units and Dimensions:Unit Conversions, Measurement; Data presentation and analysis; Probability:Gathering data , Creating equations; text-to-math translation
Excel Skills: Basic Arithmetic:Simple Formulas
Subject: Earth & Space Science:Geology:Plate Tectonics, Earth & Space Science

Tsunami-Time part of Examples
Thomas 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.

Quantitative Concepts: Basic arithmetic; Number sense:Unit conversions, Rates:Rates of Change, Basic arithmetic; Number sense:Rates, Number operations:Number operations: addition, subtraction, multiplication, division, Basic arithmetic; Number sense:Units and Dimensions:Unit Conversions, Basic arithmetic; Number sense:Units and Dimensions, Basic arithmetic; Number sense, Algebra; Modeling; Functions:Manipulating equations
Excel Skills: Basic Arithmetic:Arithmetic Functions:SUM, Basic Arithmetic:Simple Formulas, Basic Arithmetic
Subject: Physics:Oscillations & Waves


« Previous Page