An Exploratory Analysis of the Impact of Named Ranges on the Debugging Performance of Novice Users

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.

[1]  Kevin McDaid,et al.  Spreadsheet End-User Behaviour Analysis , 2008, ArXiv.

[2]  Wales,et al.  Spreadsheet modelling best practice , 1995 .

[3]  Henry C. Lucas,et al.  Spreadsheet analysis and design , 1989, CACM.

[4]  Stephen G. Powell,et al.  Impact of errors in operational spreadsheets , 2009, Decis. Support Syst..

[5]  Stephen G. Powell,et al.  Errors in Operational Spreadsheets , 2009, J. Organ. End User Comput..

[6]  M. Fisher,et al.  The EUSES spreadsheet corpus: a shared resource for supporting experimentation with spreadsheet dependability mechanisms , 2005, WEUSE@ICSE.

[7]  Kevin McDaid,et al.  An Empirical Study of End-User Behaviour in Spreadsheet Error Detection & Correction , 2008, ArXiv.

[8]  Gregg Rothermel,et al.  WYSIWYT testing in the spreadsheet paradigm: an empirical evaluation , 2000, Proceedings of the 2000 International Conference on Software Engineering. ICSE 2000 the New Millennium.

[9]  S. E. Kruck,et al.  Spreadsheet Accuracy Theory , 2001, J. Inf. Syst. Educ..

[10]  Mark G. Simkin,et al.  Factors Affecting the Ability to Detect Spreadsheet Errors , 2006 .

[11]  Martin Erwig,et al.  UCheck: A spreadsheet type checker for end users , 2007, J. Vis. Lang. Comput..

[12]  Maria Jean Johnstone Hall.  A risk and control-oriented study of the practices of spreadsheet application developers , 1996, Proceedings of HICSS-29: 29th Hawaii International Conference on System Sciences.