Pedagogy in Action > Library > Teaching with Spreadsheets > Examples

Examples


Help

Results 21 - 30 of 120 matches

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.

Mined-Over Matter: Remembering Copper Mining at Keweenaw National Historic Park, Upper Peninsula Michigan part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum/Geology of National Parks module. Students calculate the amount of rock removed and the value of copper produced at the great Keweenaw District up to 1925.

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.

Carbon Sequestration in Campus Trees part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum module. Students use allometric relationships to calculate tree mass from trunk diameter in a stand of trees in the Pacific Northwest.

How are Flow Conditions in Volcanic Conduits Estimated? part of Pedagogy in Action:Library:Teaching with SSAC: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.

Medicine in the Body part of Examples
In this activity, we will explore how the dosage and frequency of a medicine taken affect the amount of medicine present in the blood.

Estimating Okun's Law part of Examples
This Principles or intermediate level macroeconomics Excel spreadsheet assignment shows students how to estimate the Okun's Law parameter and the potential GDP growth rate.

Using the Taylor rule to analyze monetary policy part of Examples
This Excel spreadsheet exercise has students replicate the Taylor (1993) paper which first presented the Taylor rule for setting the federal funds monetary policy target. Students may then analyze recent monetary policy history.

An Excel Spreadsheet Numerical Example of a Giffen Good part of Examples
Excel and Solver are used to provide a concrete numerical example of a Giffen good. As price rises, ceteris paribus, consumption rises.

Maddison Data on the World Economy part of Examples
Maddison's World economy data is augmented with Excel macros to enable easy charting, computing growth rates, and country comparisons.