Pedagogy in Action > Library > Teaching with Spreadsheets > Examples

Examples


Help

Show all pages

Current Search Limits

Subject

showing only Biology Show all Subject
Refine the Results

Results 1 - 10 of 19 matches

What Time Did The Potato Die? part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum module. Simulating a forensic calculation, students build spreadsheets and create graphs to find the time of death of a potato victim from temperature vs. time data.

Predator-Prey Interactions -- Modeling the Number of Fishers and Porcupines in New Hampshire part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum activity/Introductory Ecology course. Students build and manipulate spreadsheets to model and graph populations using the Lotka-Volterra predator-prey equations.

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.

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.

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.

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.

Carbon Sequestration in Campus Trees part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum module. Students use allometric relationships to calculate tree mass from trunk diameter in a stand of trees in the Pacific Northwest.

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.

Serial Dilution: Tracking Bacterial Population Size and Antibiotic Resistance part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum module. Students build spreadsheets to calculate and compare bacterial population sizes from lab cultures in antibiotic-free and antibiotic-containing media.

1 2 Next»