Pedagogy in Action > Library > Teaching with SSAC > Examples

Examples


Help

Results 41 - 50 of 103 matches

Is It Hot in Here? -- Spreadsheeting Conversions in the English and Metric Systems part of Examples
Spreadsheets Across Curriculum module/Introductory chemistry course. Students build spreadsheets to examine unit conversions between the metric and English systems. Spreadsheet level: Beginner.

Subject: Biology, Chemistry, Geoscience, Physics

Index Numbers: Gasoline and Inflation -- Why We Need the Consumer Price Index part of Examples
Spreadsheets Across Curriculum module. Students build spreadsheets to examine the price of gasoline, 1978-2005. QL: using ratios and proportions to make comparisons.

Subject: Economics

Predator-Prey Interactions -- Modeling the Number of Fishers and Porcupines in New Hampshire part of 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.

Subject: Biology:Ecology

A Healthier You: Modeling a Healthier Weight from Dietary Improvement and Exercise part of 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.

Subject: Health Sciences, Biology

A Look at High School Dropout Rates: Average Rates of Change and Trend Lines part of Examples
Spreadsheets Across the Curriculum module. Students build a spreadsheet to calculate an average rate of change and compare it to the slope of the trend line on a scatter plot of a real-world data set

Subject: Education

How Far is Yonder Mountain? -- A Trig Problem part of Examples
Spreadsheets Across the Curriculum module. Students use Polya's problem-solving heuristic to find the distance of a peak using vertical angles sighted from a wagon train heading toward the peak.

Subject: Mathematics, Geography

Minimizing Cost while Meeting Nutritional Needs -- An example of linear programming part of 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.

Subject: Health Sciences, Economics

What's the Difference? -- Calculating the difference in wages for a bookkeeper (AA degree) vs. a cashier (no college degree) part of 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.

Subject: Education

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

Subject: Geoscience

The "Perfect" Date: Ranking and Rating Decisions with a Spreadsheet part of Examples
Spreadsheets Across the Curriculum module. Students build a spreadsheet to rank and rate potential dates by calculating weighted sums of a variety of attributes.