Pedagogy in Action > Library > Teaching with Spreadsheets > Examples

Examples


Help

Show all pages

Current Search Limits

Subject

showing only Health Sciences Show all Subject
Refine the Results

Subject Show all Subject

Results 1 - 6 of 6 matches

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.

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.

Minimizing Cost while Meeting Nutritional Needs -- An example of linear programming part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum module. Students use Excel Solver to find the linear combination of servings of two specified foods that minimize cost while meeting nutritional requirements.

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.

A Healthier You: Modeling a Healthier Weight from Dietary Improvement and Exercise part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum module. Students calculate the number of days it takes for participants in a hypothetical weight-reduction program to reach a target weight. QL: rates of change.

Why Don't I Feel Better Yet? Examining the effect of dose, time interval, and elimination rate on attaining a therapeutic drug level part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets across the Curriculum module. Students use a spreadsheet to build a two-way table of drug level vs. time and elimination rate with parameters dosage interval and amount.