Pedagogy in Action > Library > Teaching with Spreadsheets > Examples

Examples


Help

Results 31 - 40 of 113 matches

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.

Yellowstone! A National Park on a Hot Spot part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum module/Geology of National Parks course. Students use foundational math to study the velocity of the North American Plate over the hot spot, the volume of eruptive materials from it, and the recurrence interval of the cataclysmic eruptions.

Dunes, Boxcars, and Ball Jars: Mining the Great Lakes Shores part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum module/Geology of National Parks course. Students estimate the volume of sand in Hoosier Slide, a large dome-shaped dune quarried away in the 1920s from what is now Indiana Dunes National Lakeshore. They also estimate the number of boxcars to carry the sand, and the number of Ball jars produced from it.

Tale of Two Cities (and two hurricanes): New Orleans part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Students use spreadsheets to analyze the reasons why New Orleans has subsided in the past 250 years.

Tsunami-Time part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Students build spreadsheets to compute the time it takes a tsunami wave to pass over different regions of the ocean.

Assessing earthquake risk: How often does the Big One occur? part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Students use spreadsheet tables and charts to explore the Gutenberg-Richter relationship between an earthquakes magnitude and recurrence interval.

Creating a Household Budget part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum module. Students track their expenses and use Excel to compare them to Seattle/Tacoma averages. Developed for adult students taking English as a Second Language.

Minimizing Cost while Meeting Nutritional Needs -- An example of linear programming part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum module. Students use Excel Solver to find the linear combination of servings of two specified foods that minimize cost while meeting nutritional requirements.

What's the Difference? -- Calculating the difference in wages for a bookkeeper (AA degree) vs. a cashier (no college degree) part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum module. Students build a basic spreadsheet to calculate the accumulating difference in wages between two jobs in the context of deciding to get an AA degree.

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.