Pedagogy in Action > Library > Teaching with Spreadsheets > Examples

Examples


Help

Show all pages

Current Search Limits

Subject

showing only Mathematics Show all Subject
Refine the Results

Subject Show all Subject

Results 1 - 10 of 22 matches

Frequency of Large Earthquakes -- Introducing Some Elementary Statistical Descriptors part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum module. Students examine the number of large earthquakes (magnitude 7 and above) per year for 1970-1999 and 1940-1999. QL: descriptors of a frequency distribution.

Understanding Standard Deviations: A Learning Activity Using Microsoft Excel part of Examples
In this activity, students will use Microsoft Excel to calculate standard deviations both manually, and using the STDEV function.

Medicine in the Body part of Examples
In this activity, we will explore how the dosage and frequency of a medicine taken affect the amount of medicine present in the blood.

Let's Take a Hike in Catoctin Mountain Park part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum module/Geology of National Parks course. Students use a topographic map and spreadsheet to find how many Big Macs they burned off on a five-mile hike at Catoctin Mountain Park.

Dirty Jobs vs. Clean Jobs part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum module. Students use spreadsheets to help find the difference in percentages of salaries between dirty and clean jobs.

How Diverse Are We? -- Comparing Racial Composition of NYC and USA, 1980-2000 part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum module. Students analyze the percentage of change in the diversity of the US compared to New York City over 20 years.

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.

The Digital Divide: A Data Analysis Activity Using Subtotals part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum module. Students analyze a given data set to understand the "Digital Divide" by means of percentages and the Subtotal tool in Excel.

Grade Calculation part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum module. This activity introduces the student to the concept of weighted averages by asking them to calculate course grades and grade point averages.

1 2 3 Next»