Pedagogy in Action > Library > Teaching with Spreadsheets > Examples

Examples


Help

Results 41 - 50 of 120 matches

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.

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.

A Look at High School Dropout Rates: Average Rates of Change and Trend Lines part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum module. Students build a spreadsheet to calculate an average rate of change and compare it to the slope of the trend line on a scatter plot of a real-world data set

Serial Dilution: Tracking Bacterial Population Size and Antibiotic Resistance part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum module. Students build spreadsheets to calculate and compare bacterial population sizes from lab cultures in antibiotic-free and antibiotic-containing media.

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.

Calibrating a Pipettor part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum activity. In advance of an actual lab activity, students virtually simulate the calibration of a laboratory micropipettor. QL: Accuracy and precision.

Chemical Equilibrium -- What Are the Characteristics of Equilibrium Reactions? part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across Curriculum module. Students build spreadsheets to compare the time course of a reaction that goes to completion to that of an equilibrium reaction.

A Healthier You: Modeling a Healthier Weight from Dietary Improvement and Exercise part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum module. Students calculate the number of days it takes for participants in a hypothetical weight-reduction program to reach a target weight. QL: rates of change.

Index Numbers: Gasoline and Inflation -- Why We Need the Consumer Price Index part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across Curriculum module. Students build spreadsheets to examine the price of gasoline, 1978-2005. QL: using ratios and proportions to make comparisons.

Predator-Prey Interactions -- Modeling the Number of Fishers and Porcupines in New Hampshire part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum activity/Introductory Ecology course. Students build and manipulate spreadsheets to model and graph populations using the Lotka-Volterra predator-prey equations.