Pedagogy in Action > Library > Teaching with SSAC > Examples

Examples


Help

Results 21 - 30 of 103 matches

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

Dunes, Boxcars, and Ball Jars: Mining the Great Lakes Shores part of Examples
Spreadsheets Across the Curriculum module/Geology of National Parks course. Students estimate the volume of sand in Hoosier Slide, a large dome-shaped dune quarried away in the 1920s from what is now Indiana Dunes National Lakeshore. They also estimate the number of boxcars to carry the sand, and the number of Ball jars produced from it.

Subject: Geoscience

Yellowstone! A National Park on a Hot Spot part of Examples
Spreadsheets Across the Curriculum module/Geology of National Parks course. Students use foundational math to study the velocity of the North American Plate over the hot spot, the volume of eruptive materials from it, and the recurrence interval of the cataclysmic eruptions.

Subject: Geoscience:Geology:Tectonics, Igneous and Metamorphic Petrology:Volcanology

Calzones vs. Mini-Pizzas -- A Linear Programming Problem part of Examples
Spreadsheets Across the Curriculum module. Students build a spreadsheet to find the combination of mini-pizzas and calzones that maximizes revenue given constraints on labor time and baking time.

Subject: Business, Mathematics

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

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 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.

Subject: Chemistry, Biology:Microbiology, Health Sciences

Shifting Sands: Quantifying Shoreline and Dune Migration at Indiana Dunes National Lakeshore part of Examples
Spreadsheets Across the Curriculum module/Geology of National Parks course. Students use weighted averages and data from air photos from 1939 to 2005 to calculate the rate of retreat of the shoreline and the advance of the front of dunes along the shoreline.

Subject: Geoscience

A Percentage Stroll through Norris Geyser Basin, Yellowstone National Park part of Examples
Spreadsheets Across the Curriculum module/Geology of National Parks course. Students calculate percentages and percent differences to compare various measures of fumaroles, mud pots, hot springs and geysers in this introduction to hydrothermal features at Yellowstone NP.

Subject: Geoscience

Comparing Stream Discharge in Two Watersheds in Glacier National Park part of Examples
Spreadsheets Across the Curriculum module/Geology of National Parks course. Students study how discharge per unit area varies with elevation in the high country of Glacier National Park from USGS hydrograph data from Swiftcurrent Creek and its tributary Grinnell Creek..

Subject: Geoscience

Creating a Household Budget part of Examples
Spreadsheets Across the Curriculum module. Students track their expenses and use Excel to compare them to Seattle/Tacoma averages. Developed for adult students taking English as a Second Language.

Subject: Mathematics, Economics