Pedagogy in Action > Library > Teaching with Spreadsheets > Examples

Examples


Help

Results 41 - 50 of 119 matches

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.

Calzones vs. Mini-Pizzas -- A Linear Programming Problem part of Pedagogy in Action:Library:Teaching with SSAC: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.

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.

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.

Spreadsheet Warm Up for SSAC Geology of National Parks Modules part of Pedagogy in Action:Library:Teaching with SSAC: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.

Lithospheric Density part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Students learn about the weighted mean by building spreadsheets that apply this concept to the average density of the oceanic lithosphere.

Who Gets Help: A Field Experiment? part of Pedagogy in Action:Library:Undergraduate Research:Example
Students carry out a field experiment in order to test the hypothesis that able bodied individuals receive less help than those perceived to have an injury. Students collect and analyze data and write an APA style research report.

The Effect of Race and Ethnicity on High School Graduation Rates in Florida part of Pedagogy in Action:Library:Undergraduate Research:Example
In this individual research project, a senior thesis student conducts a regression analysis that investigates the effects of race, ethnicity, and poverty on high school graduation rates in Florida. The data are easily obtainable from the Florida Department of Education. The project can be modified to be a group research project in a Research Methods Class or a Special Topics Upper Level Economics class.

Understanding Mortgage Payments part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets across the Curriculum module. Students build Excel spreadsheets to calculate monthly mortgage payments and evaluate how much of their payment is applied to the principle and interest.

The Mole in Chemistry: How do you determine the number of atoms or molecules in everyday items? part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets across the Curriculum Module. Students build spreadsheets to practice converting between moles, grams, and atomic mass units.