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.

How Large is the Great Pyramid of Giza? -- Would it make a wall that would enclose France? part of Pedagogy in Action:Library:Teaching with SSAC: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.

Maximize the Volume of a Box: Exploring Polynomial Functions part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum module. Students build spreadsheets to find the maximum volume of an open-top box by cut-and-folding a sheet of cardboard.

Creating a Household Budget part of Pedagogy in Action:Library:Teaching with SSAC: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.

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.

How often do earthquakes occur? part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Students use spreadsheet tables and charts to explore the relationship between earthquake magnitude and frequency.

Something is Askew at Mammoth Cave National Park part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum/Geology of National Parks module. Students use the geometric mean and multiplicative standard deviation to examine the right-skewed distribution of nutrient concentrations in water-quality data at Mammoth Cave National Park.

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.

1 2 3 Next»