Beyond the Mechanics of Spreadsheets: Using Design Instruction to Address Spreadsheet Errors
Given that the usage and complexity of spreadsheets in the accounting profession are expected to increase, it is more important than ever to ensure that accounting graduates are aware of the dangers of spreadsheet errors and are equipped with design skills to minimize those errors. Although spreadsheet mechanics are prevalent in accounting curricula, less attention has been given to design considerations that can reduce the incidence of spreadsheet errors. The extant literature provides evidence of the most common types of spreadsheet errors and explanations as to why they occur. Using the work of Panko and others, this paper outlines a three-step approach for introducing spreadsheet design practices to novice spreadsheet developers. To facilitate design instruction, this paper provides a summary of foundational readings related to spreadsheet errors as well as specific teaching strategies for addressing the most common spreadsheet errors identified in the literature.
Schneider, Kent N.; Becker, Lana L.; and Berg, Gary G.. 2017. Beyond the Mechanics of Spreadsheets: Using Design Instruction to Address Spreadsheet Errors. Accounting Education. Vol.26(2). 127-143. https://doi.org/10.1080/09639284.2016.1274912 ISSN: 0963-9284