Computer Science – Human-Computer Interaction
Scientific paper
2009-08-06
Proc. European Spreadsheet Risks Int. Grp. (EuSpRIG) 2009 69-81 ISBN 978-1-905617-89-0
Computer Science
Human-Computer Interaction
13 Pages, 4 Figures. Winner of the 2009 David Chadwick Prize for Best Student Paper
Scientific paper
This paper describes an exploratory empirical study of the effect of named ranges on spreadsheet debugging performance. Named ranges are advocated in both academia and industry, yet no experimental evidence has been cited to back up these recommendations. This paper describes an exploratory experiment involving 21 participants that assesses the performance of novices debugging a spreadsheet containing named ranges. The results are compared with the performance of a different set of novices debugging the same spreadsheet without named ranges. The findings suggest that novice users debug on average significantly fewer errors if the spreadsheet contains named ranges. The purpose of the investigative study is to derive a detailed and coherent set of research questions regarding the impact of range names on the debugging performance and behaviour of spreadsheet users. These will be answered through future controlled experiments.
Bishop Brian
McDaid Kevin
McKeever Ruth
No associations
LandOfFree
An Exploratory Analysis of the Impact of Named Ranges on the Debugging Performance of Novice Users does not yet have a rating. At this time, there are no reviews or comments for this scientific paper.
If you have personal experience with An Exploratory Analysis of the Impact of Named Ranges on the Debugging Performance of Novice Users, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and An Exploratory Analysis of the Impact of Named Ranges on the Debugging Performance of Novice Users will most certainly appreciate the feedback.
Profile ID: LFWR-SCP-O-706542