The IRMA Community
Newsletters
Research IRM
Click a keyword to search titles using our InfoSci-OnDemand powered search:
|
Expert and Novice End-User Spreadsheet Debugging: A Comparative Study of Performance and Behaviour
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.
Related Content
|
Rod D. Roscoe, Russell J. Branaghan, Nancy J. Cooke, Scotty D. Craig.
© 2018.
34 pages.
|
|
Steve Ritter, R. Charles Murray, Robert G. M. Hausmann.
© 2018.
17 pages.
|
|
Yvonne S. Kao, Bryan J. Matlen, Michelle Tiu, Linlin Li.
© 2018.
24 pages.
|
|
Melissa L. Stone, Kevin M. Kent, Rod D. Roscoe, Kathleen M. Corley, Laura K. Allen, Danielle S. McNamara.
© 2018.
23 pages.
|
|
Elizabeth R. Kazakoff, Melissa Orkin, Kristine Bundschuh, Rachel L. Schechter.
© 2018.
24 pages.
|
|
Irfan Kula, Russell J. Branaghan, Robert K. Atkinson, Rod D. Roscoe.
© 2018.
17 pages.
|
|
Erin Walker, Ruth Wylie, Andreea Danielescu, James P. Rodriguez III, Ed Finn.
© 2018.
19 pages.
|
|
|