Pedagogy in Action > Library > Teaching with Spreadsheets > Examples

Examples


Help

Results 41 - 50 of 113 matches

How Far is Yonder Mountain? -- A Trig Problem part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum module. Students use Polya's problem-solving heuristic to find the distance of a peak using vertical angles sighted from a wagon train heading toward the peak.

Predator-Prey Interactions -- Modeling the Number of Fishers and Porcupines in New Hampshire part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum activity/Introductory Ecology course. Students build and manipulate spreadsheets to model and graph populations using the Lotka-Volterra predator-prey equations.

Index Numbers: Gasoline and Inflation -- Why We Need the Consumer Price Index part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across Curriculum module. Students build spreadsheets to examine the price of gasoline, 1978-2005. QL: using ratios and proportions to make comparisons.

Maximize the Volume of a Box: Exploring Polynomial Functions part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum module. Students build spreadsheets to find the maximum volume of an open-top box by cut-and-folding a sheet of cardboard.

The "Perfect" Date: Ranking and Rating Decisions with a Spreadsheet part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum module. Students build a spreadsheet to rank and rate potential dates by calculating weighted sums of a variety of attributes.

What are the Winds Blowing into Mammoth Cave? part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum/Geology of National Parks module. Students estimate the net volume of pollutants flowing into the Houchin's Narrows entrance of Mammoth Cave using actual air-flow and air-quality data from the park.

Tale of Two Cities (and two hurricanes): Miami part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Students use a spreadsheet to compute the hypothetical risk of an Andrew-like hurricane to downtown Miami.

Simple vs. Compound Interest -- Spreadsheeting the Difference part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across Curriculum module. Students build spreadsheets to tabulate, graph and compare the future value of investments with compound vs. simple interest. Spreadsheet level: beginner.

Is It Hot in Here? -- Spreadsheeting Conversions in the English and Metric Systems part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across Curriculum module/Introductory chemistry course. Students build spreadsheets to examine unit conversions between the metric and English systems. Spreadsheet level: Beginner.

Earth's Planetary Density: Constraining What We Think about the Earth's Interior part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum module. Students build spreadsheets to forward calculate the Earth's aggregate density from combinations of densities and thicknesses of the Earth's four shells.