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

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.

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.

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.

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.

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.

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.