Welcome to the InfoSci Platform
Reference Hub3
Expert and Novice End-User Spreadsheet Debugging: A Comparative Study of Performance and Behaviour

Expert and Novice End-User Spreadsheet Debugging: A Comparative Study of Performance and Behaviour

Brian Bishop, Kevin McDaid
Copyright: © 2011 |Volume: 23 |Issue: 2 |Pages: 24
ISSN: 1546-2234|EISSN: 1546-5012|EISBN13: 9781466600089|DOI: 10.4018/joeuc.2011040104
Cite Article Cite Article

MLA

Bishop, Brian, and Kevin McDaid. "Expert and Novice End-User Spreadsheet Debugging: A Comparative Study of Performance and Behaviour." JOEUC vol.23, no.2 2011: pp.57-80. http://doi.org/10.4018/joeuc.2011040104

APA

Bishop, B. & McDaid, K. (2011). Expert and Novice End-User Spreadsheet Debugging: A Comparative Study of Performance and Behaviour. Journal of Organizational and End User Computing (JOEUC), 23(2), 57-80. http://doi.org/10.4018/joeuc.2011040104

Chicago

Bishop, Brian, and Kevin McDaid. "Expert and Novice End-User Spreadsheet Debugging: A Comparative Study of Performance and Behaviour," Journal of Organizational and End User Computing (JOEUC) 23, no.2: 57-80. http://doi.org/10.4018/joeuc.2011040104

Export Reference

Mendeley
Favorite Full-Issue Download

Abstract

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.

Request Access

You do not own this content. Please login to recommend this title to your institution's librarian or purchase it from the IGI Global bookstore.