Teaching Business Modeling Using Spreadsheets

Before spreadsheets, modeling of business concerns required some competency in mathematics (algebra, calculus, statistics, and probability) and in computer programming, skills that are rather intimidating for the average business executive and management school student. However, the spreadsheet and the personal computer revolution challenged that paradigm. With its simple intuitive interface, direct interactivity, and universal presence, the humble spreadsheet has made business modeling much easier and has been considered by many analysts as the tool of choice for exploring business opportunities. Many university professors have already adopted spreadsheets as their computing platform in support of teaching business mathematics, statistics, and management science courses. Though some business modeling skills can be learned when spreadsheets are used in the courses, they are often secondary to the task of delivering the main subject content. Working out business challenges in the real world, however, requi...

[1]  Thomas A. Grossman.  Causes of the Decline of the Business School Management Science Course , 2001 .

[2]  Thin-Yin Leong.  Simpler Spreadsheet Simulation of Multi-Server Queues , 2007, INFORMS Trans. Educ..

[3]  John Walkenbach.  Excel VBA Programming For Dummies , 2004 .

[4]  Wayne Winston.  The Teachers' Forum: Management Science with Spreadsheets for MBAs at Indiana University , 1996 .

[5]  Wayne L. Winston,et al.  Microsoft Excel Data Analysis and Business Modeling , 2004 .

[6]  Stephen G. Powell.  The Teachers' Forum: From Intelligent Consumer to Active Modeler, Two MBA Success Stories , 1997 .

[7]  Stephen G. Powell.  The Teachers' Forum: Requiem for the Management Science Course? , 1998, Interfaces.

[8]  John F. Kros.  Spreadsheet Modeling for Business Decisions w/St CD, @RISK & Crystal Ball Access Cards , 2007 .

[9]  Thomas A. Grossman.  Integrating Spreadsheet Engineering in a Management Science Course: A Hierarchical Approach , 2006, INFORMS Trans. Educ..

[10]  Matthew J. Liberatore,et al.  The Teachers' Forum: Breaking the Mold - A New Approach to Teaching the First MBA Course in Management Science , 1999, Interfaces.

[11]  Peter J. Regan,et al.  Professional Decision Modeling: Practitioner as Professor , 2006, Interfaces.

[12]  Stephen G. Powell.  The Teachers’ Forum: Teaching the Art of Modeling to MBA Students , 1995 .

[13]  Saul I. Gass,et al.  Model World: The Spreadsheeting of OR/MS , 2000, Interfaces.

[14]  Stephen G. Powell,et al.  The Teachers’ Forum: Six Key Modeling Heuristics , 1995 .

[15]  Jonathan P. Caulkins,et al.  When Parametric Sensitivity Analysis Isn't Enough , 2001 .

[16]  Stephen G. Powell.  Teaching Modeling in Management Science , 2001 .

[17]  Thin Yin Leong,et al.  Spreadsheet Modeling of Hotel Room Sales and Demand Distributions Estimation , 2009 .

[18]  James Gips.  Mastering Excel: A Problem-Solving Approach , 1996 .

[19]  Thin Yin Leong,et al.  Spreadsheet Modeling of Equipment Acquisition Plans , 2008 .

[20]  Thomas A. Grossman.  Spreadsheet Engineering: A Research Framework , 2007, ArXiv.

[21]  Cliff T. Ragsdale.  Teaching Management Science with Spreadsheets: From Decision Models to Decision Support , 2001 .

[22]  Thin-Yin Leong.  Monte Carlo Spreadsheet Simulation Using Resampling , 2007, INFORMS Trans. Educ..

[23]  John F. Barlow.  Excel Models for Business and Operations Management , 1998 .

[24]  Stephen G. Powell,et al.  The Art of Modeling with Spreadsheets , 2003 .