Pedagogy in Action > Library > Teaching with Spreadsheets > Examples

Examples


Help

Results 31 - 40 of 113 matches

What is the Volume of a Debris Flow? part of Pedagogy in Action:Library:Teaching with SSAC:Examples
SSAC Physical Volcanology module. Students build a spreadsheet to estimate the volume of volcanic deposits using map, thickness and high-water mark data from the 2005 Panabaj debris flow (Guatemala).

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.

Introduction to Hazard and Risk: Part 1 part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Students are are introduced to Excel and its capabilities by building some simple spreadsheets.

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.

Tale of Two Cities (and two hurricanes): Miami part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Students use a spreadsheet to compute the hypothetical risk of an Andrew-like hurricane to downtown Miami.

The Effect of Race and Ethnicity on High School Graduation Rates in Florida part of Pedagogy in Action:Library:Undergraduate Research:Example
In this individual research project, a senior thesis student conducts a regression analysis that investigates the effects of race, ethnicity, and poverty on high school graduation rates in Florida. The data are easily obtainable from the Florida Department of Education. The project can be modified to be a group research project in a Research Methods Class or a Special Topics Upper Level Economics class.

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

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.

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.