i-nth logo

Authors

Harry Benham & Marc Giullian

Abstract

This study looks at the impact of spreadsheet training that includes emphasis on spreadsheet errors and their consequences in reducing spreadsheet error rates.

The same spreadsheet modeling task was given to students exposed to this "error awareness" training as well as similar students exposed to structural design training. Empirical results indicate that students exposed to the "error awareness" approach produced fewer errors than students exposed to the other training method.

Additionally, the study indicates that more knowledge of the problem domain is associated with fewer spreadsheet errors.

Sample

Domain knowledge and error awareness
Domain knowledge and error awareness

Looking at All errors, the results suggest two significant influences, domain knowledge and error awareness.

Knowledge of the subject domain being modeled in a spreadsheet results in fewer overall errors. But importantly, having been sensitized to spreadsheet errors also significantly reduces the number of errors.

Publication

2005, Issues in Information Systems, Volume VI, Number 1, pages 28-34

Full article

Reducing spreadsheet error rates