Integrating Spreadsheet Engineering in a Management Science Course: A Hierarchical Approach

Thomas A. Grossman - tagrossman@usfca.edu
School of Business and Management,
University of San Francisco,
2130 Fulton Street, Malloy Hall,
San Francisco, California 94117-1045

Abstract

Business students who rely on spreadsheets can use management science only to the extent that they can build a spreadsheet model of an unstructured business situation. Spreadsheets are the primary vehicle for analytical work in business, are advantageous for modeling and model representation, and are used by management science practitioners as well as end-user modelers. There is a common misperception that spreadsheets are somehow "easy" to use. However, the spreadsheet is a powerful rapid development computer programming language that requires software engineering for serious work. People struggle to efficiently build effective, transferable spreadsheet models. Students need certain spreadsheet engineering principles that they do not know, but value highly when they learn them. Spreadsheet engineering can be taught using a hierarchical "Skills, Capabilities and Practices Model.'' Low-level "Skills'' need to be evaluated and fixed early in a spreadsheet-oriented management science course. High-level "Capabilities'' and "Practices'' should be integrated throughout the course. Embracing spreadsheet engineering provides a magnificent opportunity for management science instructors to increase relevance and student satisfaction while increasing the likelihood of management science application by our graduates.

Download the PDF
10.1287/ited.7.1.18

Citation Information
Grossman, T. A. 2006. Integrating Spreadsheet Engineering in a Management Science Course: A Hierarchical Approach. INFORMS Trans. Ed. 7(1) 18-36. Available online at http://ite.pubs.informs.org/.

DOI: 10.1287/ited.7.1.18