Pedagogy in Action > Library > Teaching with SSAC > Examples

Examples


Help

Results 21 - 30 of 103 matches

How Large is the Great Pyramid of Giza? -- Would it make a wall that would enclose France? part of Examples
Spreadsheets Across the Curriculum module. Students calculate the volume of the Great Pyramid and, following Napoleon, estimate whether its volume is large enough to make a wall around France.

Subject: History, Mathematics

Radioactive Decay and Popping Popcorn -- Understanding the Rate Law part of Examples
Spreadsheets Across the Curriculum module. Students build spreadsheets to forward model an example of exponential decay and interpret the meaning of the decay constant.

Subject: Physics:Modern Physics:Nuclear Physics, Chemistry

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

Chemical Equilibrium -- What Are the Characteristics of Equilibrium Reactions? part of Examples
Spreadsheets Across Curriculum module. Students build spreadsheets to compare the time course of a reaction that goes to completion to that of an equilibrium reaction.

Subject: Chemistry:General Chemistry:Chemical Reactions

Bacteria in a Flask -- Spreadsheeting Population Density vs. Time part of 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.

Subject: Biology:Microbiology, Health Sciences

Driving Across Town for Cheaper Gas -- A Cost/Benefit Analysis part of Examples
Spreadsheets Across the Curriculum module. Students build a spreadsheet to explore the trade-offs between "bargain-priced" gas vs. the extra mileage needed to get it. A modeling problem.

Subject: Economics

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

How Much Water Is In Crater Lake? part of Examples
Spreadsheets Across the Curriculum module/Geology of National Parks course. Students calculate an answer from a bathymetric map by summing volumes of vertical prisms.

Subject: Geoscience

Spreadsheet Warm Up for SSAC Geology of National Parks Modules part of Examples
Spreadsheets Across the Curriculum module/Geology of National Parks course. A tutorial, first module for the course, intended to introduce spreadsheets and the notion of math in an introductory geology course.