Teaching Macroeconomics with Excel

Screencasts

Each Excel workbook contains links to screencasts streamed from vimeo.com.

All screencasts are aggregated into a Macroeconomics with Excel channel (which is initially organized in the order listed below and is sortable and searchable), but it can be a chore to find a particular video. Thus, below is a complete listing of every screencast, organized by workbook, with a brief description. Click to view or select the link and copy to send it to someone.

Total Screencasts Listed Below: 85

Video quality is affected by connection, device, and player. Pause to buffer if choppy playback and toggle HD if the image is grainy. Some browsers have issues displaying HD so try a different browser if you have trouble.

Remember to pause or rewind as needed.

I recorded and uploaded these screencasts over a period of 12-18 months some time ago. Since then, I have updated and corrected the Excel files so the screencast may not exactly match the Excel file. I won't bother to redo the screencast unless it's so dated or different from the Excel file that it will confuse you. In other words, if you notice slight differences, just power through.

1. Charting in Excel

HowtoChart.xls: a gentle introduction to graphing in Excel, includes simple and double Y charts using data from Central American countries. (6 screencasts)

RecessionChart.xls: uses the EconChart.xla add-in to enhance an oil price chart by adding shaded regions for recessions and applies shaded areas to a chart of USincome inequality. (5)

2. Economic Growth Literacy

MaddisonData.xls:a macro-enhanced Excel workbook of Maddison’s World Economy data that enables easy comparison of countries over time. (9)

Numeracy -- mastering fundamental mathematical concepts about growth.

Economic Growth Literacy -- knowing what economists know about economic growth.

3. The Solow Model

1. KAcc.xls: introduction to the Solow Model with focus on capital accumulation and the mechanics of the model. (2)

2. GoldenRule.xls: explores transitional dynamics after changing the saving rate. (3)

3. Population.xls: empirical data followed by analysis of the effect of population growth on the Solow Model. (9)

Demography -- the statistical study of human populations, including areas such as fertility, death, and migration.

The Solow Model with Population Growth (n > 0)

4. TechProgress.xls: culmination of Solow Model series; incorporates technological progress; theory and data. (8)

4. Data via the FRED add-in

1. GDP.xls: uses the FRED add-in to download and analyze basic aggregate data from national income accounts (3)

2. Unem.xls: uses the FRED add-in to download and analyze labor market statistics. (6)

3. Inflation.xls: uses the FRED add-in to download price index and inflation data (4)

4. Money.xls: uses the FRED add-in to download monetary aggregates, interest rates, and exchange rates (7)

5. The Keynesian Model

1. KCross.xls: introduces the Keynesian Model via the familiar income-expenditure diagram and does comparative statics and multiplier analysis (3)

2. MoneyMarket.xls: shows equilibrium in money market and derives money demand with a Baumol-Tobin Model (3)

3. ISLM.xls: implements the ISLM Model with screencasts organized in three groups (11)

Group 1: The first four screencasts are focused on the initial equilibrium and how it is obtained.

Group 2: The next three screencasts are concerned with the mechanics of the model itself and how it functions.

Group 3: The final four screencasts are devoted to the comparative statics properties of the model, including applications and analysis of fiscal and monetary policy.

4. ISLMADAS.xls: extends the ISLM Model by endogenizing the price level (6)

 

Last Update: 5 June 2014