Pedagogy in Action > Library > Teaching with Spreadsheets > Examples

Examples


Help

Results 41 - 50 of 119 matches

Archimedes and Pi part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets across the Curriculum Activity. Student build spreadsheets that allow them to estimate pi using the same iterative process as Archimedes.

Energy Flow through Agroecosystems (Farms) part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets across the Curriculum module. Students build spreadsheets that allow them to calculate the different values needed to examine energy flow through agroecosystems.

How Sweet Is Your Tea? -- Practical experience with solutions and concentration part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum module. Students build a spreadshet to calculate grams solute to add to liters solvent to produce solution of desired concentration (mol/L).

Introducing Endangered Birds to Ulva, NZ -- Modeling exponential and logistic growth of the yellowhead population part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum module. Students build spreadsheets to model the growth in population of a species of birds introduced to an isolated island in New Zealand.

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.

Getting Your Fair Share -- Jelly beans, student groups, and Alexander Hamilton part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheet Across the Curriculum module. Students develop an Excel spreadsheet to work with the quota method of apportionment designed by Alexander Hamilton.

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.

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.

What's the Difference? -- Calculating the difference in wages for a bookkeeper (AA degree) vs. a cashier (no college degree) part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum module. Students build a basic spreadsheet to calculate the accumulating difference in wages between two jobs in the context of deciding to get an AA degree.