Pedagogy in Action > Library > Teaching with Spreadsheets > Examples

Examples


Help

Results 41 - 50 of 119 matches

Administering Medications to Patients -- Calculating Dosages in the Clinical Setting part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets across the Curriculum Module. Students build a spreadsheet to calculate proper medicine dosages using the metric system.

Illegal Software Installation: Tracking software piracy rates around the world part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets across the Curriculum Module. Students use spreadsheets to analyze data on software piracy rates in various regions throughout the world

Bacteria in a Flask -- Spreadsheeting Population Density vs. Time part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum module. Students tabulate and graph data on bacteria density vs. time for a culture. Data start with innoculation and progress through the peak and decline.

Calzones vs. Mini-Pizzas -- A Linear Programming Problem part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum module. Students build a spreadsheet to find the combination of mini-pizzas and calzones that maximizes revenue given constraints on labor time and baking time.

From Isotopes to Temperature: Working With A Temperature Equation part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum module. Students build a spreadsheet to examine from a dataset the relation between oxygen isotopes in corals and the temperature of surrounding seawater.

Driving Across Town for Cheaper Gas -- A Cost/Benefit Analysis part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum module. Students build a spreadsheet to explore the trade-offs between "bargain-priced" gas vs. the extra mileage needed to get it. A modeling problem.

Salmon Use of Geomorphically Restored Streams at Point Reyes National Seashore part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum module/Geology of National Parks course. Students work with salmon-trace streambed data to study whether removal of a spawning run barrier was effective

Getting to the Point: Exploring Tectonic Motion at Point Reyes National Seashore part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum module/Geology of National Parks course. Students use foundational math to calculate such earthquake-related numbers as fault displacement rate and earthquake recurrence interval associated with the San Andreas Fault at Point Reyes National Seashore.

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.