links to three
distinct sets of material. The first is to courses.
We have integrated Excel into a
of Economics course
(microeconomic emphasis) and an International Economics course. The
second set of references is to published papers
that relate predominantly
to the materials developed for these courses. Finally, a set of work in progress is
available for use in
developing materials for (mostly microeconomics) courses.
have used Excel
workbooks and ancillary material in Principles of Economics II
(microeconomics) and in International Economics. In each case, the
approach is to write a Study Guide for each chapter. The Study Guide
provides a set of instructions, directing the user to open a specific
workbook and to conduct and report the results of specific exercises.
We often use the workbooks in class to illustrate the relevant
of Economics. The material in this course is
microeconomic. The text for the course is Gwartney, Stroup, Sobel, and
Macpherson, Economics, 10th ed. The workbooks
chapters in that text, with each worksheet corresponding to a graph.
Using Excel allows students to introduce changes and examine the
effects of these changes.
Most of the microeconomic material in Mankiw
available. This material was developed for the 1st
Economics (ECO 440). This
access to Excel-based
counterparts to all graphs in selected chapters of Krugman and
Obstfeld, International Economics: Theory and Policy
relate to material developed for use in the two courses above. An
exception is the paper on the CES utility function.
Heckscher-Ohlin Model with
Variable Input Coefficients in Spreadsheets," Computers
in Higher Education Economics Review, 13
Heckscher-Ohlin model. The article is based on a workbook that
the development of Krugman
and Obstfeld, International
Illustrate Gains from Trade," Business
(2000). The paper and the workbook
develop the simple Ricardian model of trade, showing how specialization
according to comparative advantage increases total product. A slightly
different development that follows Krugman and Obstfeld, International
Microsoft Excel in
Principles of Economics," Computers
in Higher Education Economics Review, 14
how Excel is being used in principles of economics. Most of the graphs
used in the microeconomics chapters of texts by Gwartney, Stroup,
Sobel, and Macpherson; and by Mankiw are used in our principles course.
Curves and How
They Relate," Journal
Economic Education, 33
(2002), 89. The
JEE publishes an abstract of
this article. The article, in HTML format, is here. The
to the workbooks used to draw the various long-run and short-run cost
curves. These links may be broken. Click on the names that follow to open them: CostCurves_Basic.xls, CostCurves_quadratic_AVC.xls, and CostCurves_w_revenue.xls. |
Instruments Using Spreadsheets," Social
Computer Review, 20
197 - 193. A Microsoft Word
version of the paper is here.
The workbook on which the article is based is here.
Specific Factors Model of International Trade." Journal
Economic Education (2003):
No. 2. This paper is based on the
development in Krugman and Obstfeld, International
The Microsoft Word
version of the
document is here,
along with the workbook
upon which it is based. A PDF version is available at the JEE website.
Consumer Theory with the CES Utility Function.” Journal
Economic Education (2004):
Vol 35, No.
3. The Microsoft Word
version of the document is here, along
with the workbook upon
paper is based. |
contains references to a
number of workbooks on which we are working. In some cases, text
accompanies the workbook. In others, the workbooks stand alone. The
state of development varies among the workbooks. Taken a a whole, this
material covers much of the material covered by an undergraduate course
material in this section derives from a set of chapters that we
sketched in hopes of writing a microeconomics text with all graphs
generated by Excel.
underestimated the task, but did develop quite a bit of material that
can be useful in illustrating many of the models used in microeconomics.
set of material provides an overview of competitive (price-taker)
markets. The material is quite similar in many respects to that in the
relevant sections of Principles II.
Basics: Demand, Supply, Equilibrium, and Applications.
set of material contains two Word
documents. Each document is a chapter related to a general overview of
2: Demand, Supply,
and Elasticity relies on
workbooks Demand_intro.xls, Supply_intro.xls, Market_intro.xls,
two chapters, Chapter
3: Competitive Markets and Applications addresses
efficiency of competitive (price-taker) markets, the effects of taxes,
and international trade. The analysis requires the use of the three
Theory. This set
of material explores a model of the consumer’s response to
and prices. It also shows how consumer
surplus, introduced in the preceding chapter, is derived from
function. It is based on a Cobb-Douglas utility function. The Journal
of Economic Education article
based on the
CES utility function may be used along with this material. The material
consists of two parts, a Word document
Graphs in Microsoft Excel." This set of material provides insights into
developing graphs that are useful for the development of economic
models within Excel.
contains a link to the workbook. This paper is in draft form.
Professor of Economics Emeritus
Berry, Georgia 30149
Soumaya M. Tohamy
Economist, United States
4330 East West Highway
Bethesda, Maryland 20814