# 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 Other Elementary Math Functions Show all Excel Skills
Refine the Results

# Excel Skills Show all Excel Skills

Results 1 - 3 of 3 matches

How Do We Estimate Magma Viscosity? part of Examples
SSAC Physical Volcanology module. Students build a spreadsheet to examine how magma viscosity varies with temperature, fraction of crystals, and water content using the non-Arrhenian VFT model.

Quantitative Concepts: Basic arithmetic; Number sense:Ratio and proportion; percentage; interpolation, Algebra; Modeling; Functions:Nonlinear functions of a single variable:Exponential function, Algebra; Modeling; Functions:Manipulating equations, Basic arithmetic; Number sense:Rates, Algebra; Modeling; Functions:Nonlinear functions of a single variable:Logarithmic function, Measurement; Data presentation and analysis; Probability:Visual display of data :XY scatter plots, Basic arithmetic; Number sense:Logarithms; orders of magnitude; scientific notation, Measurement; Data presentation and analysis; Probability:Visual display of data :Logarithmic scale
Subject: Natural science:Physics, Chemistry, Earth science
Excel Skills: Other Elementary Math Functions:LOG, LOG10, LN, Graphs and Charts:XY Scatterplot:Log Scale, Multiple Plots, One Plot, Basic Arithmetic:Nested Formulas

What is the Volume of the 1992 Eruption of Cerro Negro Volcano, Nicaragua? part of Examples
SSAC Physical Volcanology module. Students build a spreadsheet to calculate the volume a tephra deposit using an exponential-thinning model.

Quantitative Concepts: Measurement; Data presentation and analysis; Probability:Visual display of data :XY scatter plots, Algebra; Modeling; Functions:Nonlinear functions of a single variable:Logarithmic function, Algebra; Modeling; Functions:Manipulating equations, Basic arithmetic; Number sense:Logarithms; orders of magnitude; scientific notation, Estimation, Unit conversions, Algebra; Modeling; Functions:Straight lines and linear functions:Slope, intercept; linear trends, Algebra; Modeling; Functions:Nonlinear functions of a single variable:Exponential decay, Geometry; Trigonometry :Circles (including radians and pi)
Subject: Natural science:Physics, Earth science, Social science:History
Excel Skills: Other Elementary Math Functions:EXP, Basic Arithmetic:Arithmetic Functions:PRODUCT, Other Elementary Math Functions:LN, Graphs and Charts:XY Scatterplot:Trendlines, Other Elementary Math Functions:POWER, Graphs and Charts:XY Scatterplot:One Plot

What is the Relationship between Lava Flow Length and Effusion Rate at Mt Etna? part of Examples
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.

Quantitative Concepts: Measurement; Data presentation and analysis; Probability:Descriptive statistics; trend lines :Goodness of fit (R2), Measurement; Data presentation and analysis; Probability:Visual display of data :XY scatter plots, Basic arithmetic; Number sense:Logarithms; orders of magnitude; scientific notation, Unit conversions, Algebra; Modeling; Functions:Nonlinear functions of a single variable:Power function, Measurement; Data presentation and analysis; Probability:Visual display of data :Logarithmic scale, Measurement; Data presentation and analysis; Probability:Descriptive statistics; trend lines :Line- and curve-fitting
Subject: Natural science:Earth science
Excel Skills: Basic Arithmetic:Nested Formulas, Graphs and Charts:XY Scatterplot, Other Elementary Math Functions:LOG, LOG10, Graphs and Charts:XY Scatterplot:One Plot, Trendlines, Log Scale