Pedagogy in Action > Library > Teaching with Spreadsheets > Examples

Examples


Help

Results 41 - 50 of 113 matches

Global Climate: Estimating How Much Sea Level Changes When Continental Ice Sheets Form part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum module. Students build spreadsheets to estimate how far sea level drops during a continental glaciation.

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.

Grade Calculation part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum module. This activity introduces the student to the concept of weighted averages by asking them to calculate course grades and grade point averages.

The Manning Equation part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum Module. Students build spreadsheets to estimate discharge for a culvert using the Manning equation, and to estimate culvert size, given a specified discharge.

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.

Vacation! How Long and How Far? -- A Geological Circuit of National Parks in the Colorado Plateau part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum module/Geology of National Parks course. Students estimate travel times and costs of a driving/camping trip to visit national parks in the Colorado Plateau.

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.

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.

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.

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.