Pedagogy in Action > Library > Teaching with Spreadsheets > Examples

Examples


Help

Results 41 - 50 of 119 matches

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.

Earthquake Magnitude: How Can We Compare the Sizes of Earthquakes? part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum module. Students build spreadsheets to tabulate and graph seismic wave amplitude and energy release to explore the logarithmic scale of earthquake magnitude.

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.

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.

Vacation! How Long and How Far? -- A Geological Circuit of National Parks in the Colorado Plateau part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum module/Geology of National Parks course. Students estimate travel times and costs of a driving/camping trip to visit national parks in the Colorado Plateau.

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.

Who Gets Help: A Field Experiment? part of Pedagogy in Action:Library:Undergraduate Research:Example
Students carry out a field experiment in order to test the hypothesis that able bodied individuals receive less help than those perceived to have an injury. Students collect and analyze data and write an APA style research report.

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.