Setting up a Keynesian cross model in Excel
This material is replicated on a number of sites
as part of the
SERC Pedagogic Service Project
Initial Publication Date: October 14, 2010
Summary
In this assignment, students are guided through the process of setting up a standard Keynesian cross model in Microsoft Excel. Excel is used to solve for GDP (and other variables) using the "iteration" option so the model is entered just as it appears in a textbook. Students are then asked to use the spreadsheet to explore the model by answering a series of questions.
CollapseLearning Goals
Students gain a better understanding of the basic Keynesian cross model, and in particular how the terms interact with each other. They also learn some basic spreadsheet modeling skills.
Context for Use
This is designed for principles-level macroeconomics courses. It may be used in a computer laboratory setting or as a take-home assignment.
Description and Teaching Materials
Below find an instruction sheet in Word format for completing the assignment. The instruction sheet is tailored for distributing to students. In addition, an Excel file containing the completed assignment is provided.
Instruction sheet (Microsoft Word 34kB Jun24 10)
Excel file containing completed assignment (Excel 17kB Jun24 10)
Instruction sheet (Microsoft Word 34kB Jun24 10)
Excel file containing completed assignment (Excel 17kB Jun24 10)
Teaching Notes and Tips
The instructions should make the assignment easy to implement. It make take some time to de-bug the spreadsheet, so it may be best to complete the assignment in a lab session.
Share your modifications and improvements to this activity through the Community Contribution Tool »
Assessment
The completed assignment may be handed in for grading electronically or in a print-out form.