Starting Point: Teaching and Learning Economics > Teaching Methods > Teaching with Spreadsheets > Examples

Examples


Help

Results 11 - 18 of 18 matches

Understanding Mortgage Payments part of Spreadsheets Across the Curriculum:General Collection: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.

Investing for Retirement part of Spreadsheets Across the Curriculum:General Collection:Examples
Spreadsheets Across the Curriculum module. Students use the Compound Interest Equation and an annuity equation to calculate the growth of investments over time.

What is the Volume of a Debris Flow? part of Pedagogy in Action:Partners:Spreadsheets Across the Curriculum:Physical Volcanology:Examples
SSAC Physical Volcanology module. Students build a spreadsheet to estimate the volume of volcanic deposits using map, thickness and high-water mark data from the 2005 Panabaj debris flow (Guatemala).

Index Numbers: Gasoline and Inflation -- Why We Need the Consumer Price Index part of Spreadsheets Across the Curriculum:General Collection:Examples
Spreadsheets Across Curriculum module. Students build spreadsheets to examine the price of gasoline, 1978-2005. QL: using ratios and proportions to make comparisons.

Driving Across Town for Cheaper Gas -- A Cost/Benefit Analysis part of Spreadsheets Across the Curriculum:General Collection:Examples
Spreadsheets Across the Curriculum module. Students build a spreadsheet to explore the trade-offs between "bargain-priced" gas vs. the extra mileage needed to get it. A modeling problem.

Vacation! How Long and How Far? -- A Geological Circuit of National Parks in the Colorado Plateau part of Pedagogy in Action:Partners:Spreadsheets Across the Curriculum:Geology of National Parks: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.

Simple vs. Compound Interest -- Spreadsheeting the Difference part of Spreadsheets Across the Curriculum:General Collection:Examples
Spreadsheets Across Curriculum module. Students build spreadsheets to tabulate, graph and compare the future value of investments with compound vs. simple interest. Spreadsheet level: beginner.

The Effect of Race and Ethnicity on High School Graduation Rates in Florida part of Starting Point: Teaching and Learning Economics:Teaching Methods:Undergraduate Research:Examples
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.



« Previous Page      Next Page »