Teaching project management using Excel Online publication date: Mon, 01-Oct-2007
by Kal Namit, Moula Cherikh, Jim Chen
International Journal of Information and Operations Management Education (IJIOME), Vol. 2, No. 2, 2007
Abstract: In this paper, we present an application of Excel spreadsheets in teaching the traditional Program Evaluation and Review Technique/Critical Path Method. This spreadsheet approach can be used in class with little cost in time or effort because it eliminates the need for tedious calculations and extensive algebraic manipulations, yet the students can understand and apply the algorithm without the black-box features that characterise most of the commercial project management software. To maintain a direct relationship with the traditional method, the spreadsheet uses the same familiar forward and backward operations required in the traditional manual calculations to find the critical path. Similar spreadsheet models are combined with the Solver in Excel to perform cost analysis by linear programming.
Existing subscribers:
Go to Inderscience Online Journals to access the Full Text of this article.
If you are not a subscriber and you just want to read the full contents of this article, buy online access here.Complimentary Subscribers, Editors or Members of the Editorial Board of the International Journal of Information and Operations Management Education (IJIOME):
Login with your Inderscience username and password:
Want to subscribe?
A subscription gives you complete access to all articles in the current issue, as well as to all articles in the previous three years (where applicable). See our Orders page to subscribe.
If you still need assistance, please email subs@inderscience.com