Pedagogy in Action > Library > Teaching with Spreadsheets > Examples

Examples


Help

Results 41 - 50 of 113 matches

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.

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.

How Large is a Ton of Rock? -- Thinking about Rock Density part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum module. Students build spreadsheets to calculate the edge length of cubes and diameter of spheres of various rocks starting with their mineralogic composition.

Radioactive Decay and Popping Popcorn -- Understanding the Rate Law part of Pedagogy in Action:Library:Teaching with SSAC: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.

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.

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.

Investing for Retirement part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum module. Students use the Compound Interest Equation and an annuity equation to calculate the growth of investments over time.

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.

Modeling Exponential Bacteria Growth on Planet Riker part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets across the Curriculum Module. Students use Excel to conduct data analysis and examine bacteria growth in a lake.

Computing Dosage for Infants and Children -- Calculation of Dosage by the Body Weight Method part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum module. Students build spreadsheets to find dosages in mL/admin from prescription in mg/day/kg and admins/day; body weight in lbs; and concentration in mg/mL.