Teaching Macroeconomics with Microsoft Excel®

✍ Scribed by Humberto Barreto

• Publisher: Cambridge University Press
• Year: 2016
• Tongue: English
• Leaves: 199
• Category: Library

✦ Synopsis

Humberto Barreto gives professors a simple way to teach fundamental concepts for any undergraduate macroeconomics course using Microsoft Excel® with Excel workbooks and add-ins and videos freely available on his university website. The Excel files are designed to be used by students with any textbook, and have been used many times by the author in his own teaching. Each Excel workbook contains links to short screencasts, around five to ten minutes, that show the cursor and typing as the file is manipulated with narration that walks the student through the steps needed to complete a task. The book shows professors a simple way to present macroeconomic models and incorporate data into their courses.

✦ Table of Contents

Contents
Preface
Software Requirements and Opening a Macro-Enhanced Workbook
Introduction: Why Simulation and Excel?
1 Charting in Excel
1.1 Introduction
1.2 Simple Scatterplot and Double Y Charts
1.3 The Shaded (Recession) Chart
1.4 Summary
2 Economic Growth Literacy
2.1 Introduction
2.2 Setting the Scene
2.3 Attaining Economic Growth Literacy: MaddisonData.xls
2.4 Summary
3 The Solow Model
3.1 Introduction
3.2 Capital Accumulation: KAcc.xls
3.3 The Golden Rule: GoldenRule.xls
3.4 Population Growth: Population.xls
3.5 Technological Progress: TechProgress.xls
4 Macro Data with FRED in Excel
4.1 Introduction: FRED.xla
4.2 GDP: GDP.xls
4.3 Unemployment: Unem.xls
4.4 Inflation: Inflation.xls
4.5 Money: Money.xls
5 The Keynesian Model
5.1 Introduction
5.2 The Keynesian Cross: KCross.xls
5.3 The Money Market: MoneyMarket.xls
5.4 The ISLM Model: ISLM.xls
5.5 The ISLMADAS Model: ISLMADAS.xls
6 Epilogue