Pedagogy in Action > Library > Teaching with Spreadsheets > Examples

Examples


Help

Results 41 - 50 of 119 matches

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.

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.

A Percentage Stroll through Norris Geyser Basin, Yellowstone National Park part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum module/Geology of National Parks course. Students calculate percentages and percent differences to compare various measures of fumaroles, mud pots, hot springs and geysers in this introduction to hydrothermal features at Yellowstone NP.

Glacier (?) National Park part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum/Geology of National Parks module. Students examine data about the disappearing glaciers in the park; after calculating percentage change in the number of glaciers from 1850 to 2000, they interpolate to estimate when Grinnell glacier will be gone.

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.

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.

Comparing Stream Discharge in Two Watersheds in Glacier National Park part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum module/Geology of National Parks course. Students study how discharge per unit area varies with elevation in the high country of Glacier National Park from USGS hydrograph data from Swiftcurrent Creek and its tributary Grinnell Creek..

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.