Pedagogy in Action > Library > Teaching with Spreadsheets > Examples

Examples


Help

Results 21 - 30 of 113 matches

Medicine in the Body part of Examples
In this activity, we will explore how the dosage and frequency of a medicine taken affect the amount of medicine present in the blood.

Estimating Okun's Law part of Examples
This Principles or intermediate level macroeconomics Excel spreadsheet assignment shows students how to estimate the Okun's Law parameter and the potential GDP growth rate.

Using the Taylor rule to analyze monetary policy part of Examples
This Excel spreadsheet exercise has students replicate the Taylor (1993) paper which first presented the Taylor rule for setting the federal funds monetary policy target. Students may then analyze recent monetary policy history.

An Excel Spreadsheet Numerical Example of a Giffen Good part of Examples
Excel and Solver are used to provide a concrete numerical example of a Giffen good. As price rises, ceteris paribus, consumption rises.

What would GDP have been in 2009 if growth didn't slow down in the 1970s? part of Examples
This Excel spreadsheet assignment guides students through the process of projecting what GDP would have been for the years 1972-2009 if long run (potential) growth did not slow down.

Exploring Easter Island Economics with Excel part of Integrate:Workshops:Systems, Society, Sustainability and the Geosciences:Activities

Principles of Sociology part of SSDAN:Activities
We have spent the last few weeks discussing race, class, and gender inequalities and how sociologists conceptualize these inequalities on the structural, rather than the individual, level. In this second research report, you will have the opportunity to apply this structural perspective. You will use U.S. Census data from 1950 to 1990 to analyze shifts in occupational structures in your home state and how these shifts vary by race, sex, or education.

Understanding Mortgage Payments part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets across the Curriculum module. Students build Excel spreadsheets to calculate monthly mortgage payments and evaluate how much of their payment is applied to the principle and interest.

How Far is Yonder Mountain? -- A Trig Problem part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum module. Students use Polya's problem-solving heuristic to find the distance of a peak using vertical angles sighted from a wagon train heading toward the peak.

Earth's Planetary Density: Constraining What We Think about the Earth's Interior part of Pedagogy in Action:Library:Teaching with SSAC:Examples
Spreadsheets Across the Curriculum module. Students build spreadsheets to forward calculate the Earth's aggregate density from combinations of densities and thicknesses of the Earth's four shells.