The Excelets Page
(Excelets are Applets made with Excel instead of Java)

Modules and Related Links

 

 

 

 

 

 

 

Home
Modules
Descriptions
ReEngineering
Collaboratory

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Viewing: When clicking on the .xls files below, Netscape will force the files to be downloaded first (this is true whether you click open it or save to disk) while Internet Explorer in essence only allows the open it option and indeed the files will be viewed in the Browser.  For student purposes, either approach is ok, as long as they can ultimately see the open file.  

Important: In opening one of these files, you will get a message saying that the file contains macros and do you want to enable the macros. Click yes.  The macros are for running the buttons that control parameter values.

Design:  All sheets have the same general format.  Graphical material is at the top and in most cases the student can view and control the graph movie ignoring the numbers and the model that generates the movie.  No attempt is made, however, to hide the model.  It is readily available to the student by scrolling down.  In some cases the student will benefit from looking at the numbers, for example in the PPF  module. 

Mac versus PC users:  For an approach that is truly cross platform, select the version of the file that has "forms" at the end of the title, as in "forms.xls."  If you click on the control button(s), you can advance the graphs.  This works on the Mac and the PC.  However, if you hold down the control button, the data in the table advances while the graph remains static, until the button is released.  To have the graph move while the control button is held down, use the version of the file that has the shorter name, without the "forms.xls" at the end.  This gives a truer animation, but this version works only on a PC.   

Basic Microeconomics Modules

Name File Description Related Links
Production Possibilities and Revenue Maximization PPFandIsoRevenueLineforms.xls

PPFandIsoRevnueLine.xls

Notes and Teaching Tips Marshall's Principles of Economics
Consumer Choice and Comparative Statics ConsumerOptimumforms.xls

ConsumerOptimum.xls

Notes and Teaching Tips
Elasticity, Budget Constraint, and Expenditure Elasticityforms.xls

Elasticity.xls

Notes and Teaching Tips Interactive Tutorial
Short Run Productivity Relations: Total, Average, and Marginal Product Production.xls Notes and Teaching Tips Journal of Economic Education Article
Short Run Cost Relations: Fixed and Variable Cost; Total, Average, and Marginal Cost Cost.xls Notes and Teaching Tips Dialog on Southwern Publishing site
Supply and Demand: equilibrium, comparative statics, effect of a tax, and simple dynamics SupplyandDemandforms.xls

SupplyandDemand.xls

Notes and Teaching Tips Interactive Tutorial
Price Ceilings and Floors, binding or inert? PriceCeilingsandFloorsforms.xls

PriceCeilingsandFloors.xls

Notes and Teaching Tips Minimum Wage, Rent Control, Energy Price Caps
Monopoly Pricing, Welfare, and 3rd Degree Price Discrimination MonopolyPricingforms.xls

MonopolyPricing.xls

Notes and Teaching Tips Dumping

 

Economic Dynamics Modules
Name File Description Related Links
Interest and Discounting, Beyond the two-period model, Loan repayment InterestandDiscountingforms.xls

InterestandDiscounting.xls

Notes and Teaching Tips
A simple overlapping generations model with savings SocialSecurityforms.xls

SocialSecurity.xls

Notes and Teaching Tips Paul Krugman on Social Security
Hotelling model of resource extraction: solution and comparative dynamics ExhaustibleResourcesforms.xls

ExhaustibleResources.xls

Notes and Teaching Tips Historical Overview of Economics of Natural Resources

 

Fun and Games
Name File Description Related Links
Bowling BowlingExample.xls A simple illustration of non-economic dynamics A real online bowling game
Excelet Movie Trailer ExceletsAnimation.xls Another simple illustration of non-economic dynamics Apple Quicktime Trailers
__________________________________________________

Copyright by Lanny Arvan.  Educational use is free and indeed educational users are encouraged to modify the materials for their own purposes.  Commercial use is not allowed without explicit permission from the author.

University of Illinois at Urbana-Champaign CET logo link

Questions or Comments:
Contact l-arvan@uiuc.edu

Last Update: November 11, 2001