What we know about spreadsheet errors
Journal of End User Computing - End User Development
The invisible computer
Verification and validation and complex environments: a study in service sector
Proceedings of the 30th conference on Winter simulation
A methodology for testing spreadsheets
ACM Transactions on Software Engineering and Methodology (TOSEM)
An Experimental Study of Spreadsheet Presentation and Error Detection
HICSS '96 Proceedings of the 29th Hawaii International Conference on System Sciences Volume 2: Decision Support and Knowledge-Based Systems
Communications of the ACM - End-user development: tools that empower users to create their own software solutions
Designing Features for Both Genders in End-User Programming Environments
VLHCC '05 Proceedings of the 2005 IEEE Symposium on Visual Languages and Human-Centric Computing
Strategies and behaviors of end-user programmers with interactive fault localization
HCC '03 Proceedings of the 2003 IEEE Symposium on Human Centric Computing Languages and Environments
Applying code inspection to spreadsheet testing
Journal of Management Information Systems - Special section: Strategic and competitive information systems
A critical review of the literature on spreadsheet errors
Decision Support Systems
Are Mobile Spreadsheet Applications Usable?
Journal of Organizational and End User Computing
| Hi-index | 0.00 |
The reliability of end-user developed spreadsheets is poor. Research studies find that 94% of 'real-world' spreadsheets contain errors. Although some research has been conducted in the area of spreadsheet testing, little is known about the behaviour or processes of individuals during the debugging task. In this paper, the authors investigate the performance and behaviour of expert and novice end-users in the debugging of an experimental spreadsheet. To achieve this aim, a spreadsheet debugging experiment was conducted, with professional and student participants requested to debug a spreadsheet seeded with errors. The work utilises a novel approach for acquiring experimental data through the unobtrusive recording of participants' actions using a custom built VBA tool. Based on findings from the experiment, a debugging tool is developed, and its effects on debugging performance are investigated.