Pedagogy in Action > Library > Teaching with Spreadsheets > Examples

Examples


Help

Results 41 - 50 of 119 matches

Driving Across Town for Cheaper Gas -- A Cost/Benefit Analysis part of Pedagogy in Action:Library:Teaching with SSAC: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.

Bacteria in a Flask -- Spreadsheeting Population Density vs. Time part of Pedagogy in Action:Library:Teaching with SSAC: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.

First Accounting Cycle, 2 -- Sorting and Grouping Data Using Excel part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets across the Curriculum module. Students work with the spreadsheet they created in Part I to sort and classify the data they entered using a Pivot Table.

First Accounting Cycle, 1 -- Classifying Accounting Data Using Excel part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets across the Curriculum module. Students build a spreadsheet to post financial transactions and use a table-lookup function to classify them.

Just How Faithful is Old Faithful? Finding Order in Random Behavior part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum/Geology of National Parks Collection. Students create a histogram to examine the time between geyser eruptions of Old Faithful, Yellowstone National Park.

What Does the Mean Mean? Describing Eruptions at Riverside Geyser, Yellowstone National Park part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum/Geology of National Parks module. Students study measures of central tendency in a bimodal dataset of eruption intervals.

Take a Deep Breath on the Appalachian Trail in Great Smoky Mountains National Park: How Many Ozone Molecules Do You Inhale? part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum module/Geology of National Parks course. Students work with ratio and proportion and the concept of mole to calculate the number of molecules of ozone in a volume of air from concentration data.

Nitrate Levels in the Rock Creek Park Watershed, Washington DC, 2: Variability part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum module/Geology of National Parks course. Students calculate standard deviation and z-values to examine a possible outlier in a positively skewed data set.

Earth's Planetary Density: Constraining What We Think about the Earth's Interior part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum module. Students build spreadsheets to forward calculate the Earth's aggregate density from combinations of densities and thicknesses of the Earth's four shells.

Is It Hot in Here? -- Spreadsheeting Conversions in the English and Metric Systems part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across Curriculum module/Introductory chemistry course. Students build spreadsheets to examine unit conversions between the metric and English systems. Spreadsheet level: Beginner.