# SSAC Physical Volcanology 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.

There are a couple of ways of searching for modules. The box below left provides a full-text search of the cover material about the module, so you can search by author, subject, or keyword. The controlled vocabularies below right allow targeted searches by three different dimensions (click on the links to see the full, hierarchical vocabularies): Math content (Quantitative Concept) (Microsoft Word 41kB Jun17 10), Context (Subject) (Microsoft Word 29kB Jul13 07), and Excel Skill (Microsoft Word 32kB Jul13 07).

[Nine modules have been created and implemented in courses. They are undergoing a final round of edits and will be posted momentarily.]

Help

# Show all pages

Current Search Limits

## Quantitative Concepts

showing only Measurement; Data presentation and analysis; Probability Show all Quantitative Concepts

## Excel Skills

showing only Angles and Trig Functions Show all Excel Skills
Refine the Results

# Excel Skills Show all Excel Skills

Results 1 - 4 of 4 matches

How Does Surface Deformation at an Active Volcano Relate to Pressure and Volume Change in the Magma Chamber? part of Examples
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.

Quantitative Concepts: Measurement; Data presentation and analysis; Probability:Visual display of data :XY scatter plots, Algebra; Modeling; Functions:Manipulating equations, Basic arithmetic; Number sense:Estimation, Unit conversions, Ratio and proportion; percentage; interpolation, Algebra; Modeling; Functions:Modeling:Forward modeling, Geometry; Trigonometry :Spheres, Measurement; Data presentation and analysis; Probability:Descriptive statistics; trend lines :Goodness of fit (R2), Measurement; Data presentation and analysis; Probability:Visual display of data :Logarithmic scale
Subject: Natural science:Earth science, Physics
Excel Skills: Basic Arithmetic:Simple Formulas, Nested Formulas, Angles and Trig Functions:PI, Graphs and Charts:XY Scatterplot:Multiple Plots, Log Scale

Bubbles in Magmas part of Examples
SSAC Physical Volcanology module. Students build a spreadsheet and apply the ideal gas law to model the velocity of a bubble rising in a viscous magma.

Quantitative Concepts: Measurement; Data presentation and analysis; Probability:Visual display of data :XY scatter plots, Basic arithmetic; Number sense:Rates, Unit conversions, Ratio and proportion; percentage; interpolation, Algebra; Modeling; Functions:Manipulating equations, Geometry; Trigonometry :Circles (including radians and pi), Spheres
Subject: Natural science:Earth science, Chemistry, Physics
Excel Skills: Basic Arithmetic:Arithmetic Functions:SUM, PRODUCT, Angles and Trig Functions:PI, Graphs and Charts:XY Scatterplot:Multiple Plots

Porosity and Permeability of Magmas part of Examples
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.

Quantitative Concepts: Measurement; Data presentation and analysis; Probability:Visual display of data :XY scatter plots, Basic arithmetic; Number sense:Rates, Unit conversions, Algebra; Modeling; Functions:Manipulating equations, Geometry; Trigonometry :Spheres, Calculus; Numerical methods:Iteration
Subject: Natural science:Physics, Earth science
Excel Skills: Basic Arithmetic:Nested Formulas, Angles and Trig Functions:PI, Basic Arithmetic:Simple Formulas, Arithmetic Functions:SUM, Graphs and Charts:XY Scatterplot:Multiple Plots

How are Flow Conditions in Volcanic Conduits Estimated? part of Examples
SSAC Physical Volcanology module. Students build a spreadsheet to calculate velocity of rising magma in steady-state Plinian eruptions using conservation of mass and momentum.

Quantitative Concepts: Basic arithmetic; Number sense:Rates, Estimation, Measurement; Data presentation and analysis; Probability:Visual display of data :XY scatter plots, Basic arithmetic; Number sense:Ratio and proportion; percentage; interpolation
Subject: Natural science:Physics, Chemistry, Earth science
Excel Skills: Basic Arithmetic:Simple Formulas, Graphs and Charts:XY Scatterplot:Multiple Plots, Angles and Trig Functions:PI