Pedagogy in Action > Library > Teaching with Spreadsheets > Examples

Examples


Help

Results 11 - 20 of 113 matches

Frequency of Large Earthquakes -- Introducing Some Elementary Statistical Descriptors part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum module. Students examine the number of large earthquakes (magnitude 7 and above) per year for 1970-1999 and 1940-1999. QL: descriptors of a frequency distribution.

Flood Days and Good Canoeing Days at Congaree National Park part of Pedagogy in Action:Library:Teaching with SSAC:Examples
SSAC Geology of National Parks module/Geology of National Parks course. Students calculate probabilities using USGS hydrograph data, a spreadsheet of daily stage heights, and the COUNTIF function.

Deciviews from Look Rock, Great Smoky Mountains National Park: How Hazy is it? part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum/Geology of National Parks module. Students calculate the haze index and standard visual range from concentrations of particulate matter.

Shaking Ground - Linking Earthquake Magnitude and Intensity part of Pedagogy in Action:Library:Teaching with SSAC:Examples
An in-class activity for connecting earthquake magnitude, shaking, and intensity.

Mapping Coastal Vulnerability to Sea-Level Rise at Point Reyes National Seashore part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum/Geology of National Parks module. Students work with a color-coded conditional-formatted spreadsheet map to work through a USGS report applying a coastal vulnerability index.

Maddison Data on the World Economy part of Examples
Maddison's World economy data is augmented with Excel macros to enable easy charting, computing growth rates, and country comparisons.

Understanding Standard Deviations: A Learning Activity Using Microsoft Excel part of Examples
In this activity, students will use Microsoft Excel to calculate standard deviations both manually, and using the STDEV function.

Carbon Dioxide Emissions part of Examples
In this activity, the students explore the data set which describes the carbon dioxide emissions from fossil fuels between 1980 and 2006 to create bar charts, pie charts and histograms.

Exploring the Solow balanced growth model part of Examples
This Excel spreadsheet assignment bring students through a process of exploring numerical example of the Solow neoclassical balanced growth model. It is appropriate for use in macroeconomics courses at all levels, including intermediate, principles and electives.

Setting up a Keynesian cross model in Excel part of Examples
This Excel spreadsheet assignment brings students step-by-step through the process of solving and analyzing a Keynesian cross model. It is most appropriate for principles-level macroeconomics courses.