Beyond the mechanics of spreadsheets: using design instruction to address spreadsheet errors

ABSTRACT

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.

KEYWORDS:

• Spreadsheet planning errors
• domain planning errors
• spreadsheet design
• error-trapping
• spreadsheet protection

Disclosure statement

No potential conflict of interest was reported by the authors.

ORCID

Kent N. Schneider http://orcid.org/0000-0003-4238-3487

Lana L. Becker http://orcid.org/0000-0002-1187-5836

Gary G. Berg http://orcid.org/0000-0002-6374-802X