Pedagogy in Action > Library > Teaching with Spreadsheets > Examples

Examples


Help

Results 41 - 50 of 119 matches

The Mole in Chemistry: How do you determine the number of atoms or molecules in everyday items? part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets across the Curriculum Module. Students build spreadsheets to practice converting between moles, grams, and atomic mass units.

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.

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.

Modeling Exponential Bacteria Growth on Planet Riker part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets across the Curriculum Module. Students use Excel to conduct data analysis and examine bacteria growth in a lake.

Computing Dosage for Infants and Children -- Calculation of Dosage by the Body Weight Method part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum module. Students build spreadsheets to find dosages in mL/admin from prescription in mg/day/kg and admins/day; body weight in lbs; and concentration in mg/mL.

Achieve New Heights: Go to the Rockies! 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 Colorado.

Nitrate Levels in the Rock Creek Park Watershed, Washington DC, 2: Variability part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum module/Geology of National Parks course. Students calculate standard deviation and z-values to examine a possible outlier in a positively skewed data set.