The Community for Technology Leaders
Proceedings IEEE International Conference on Software Maintenance. ICSM 2001 (2001)
Florence, Italy
Nov. 7, 2001 to Nov. 9, 2001
ISSN: 1063-6773
ISBN: 0-7695-1189-9
pp: 72
Vijay B. Krishna , Oregon State University
Curtis R. Cook , Oregon State University
Daniel Keller , Oregon State University
Joshua Cantrell , Oregon State University
Chris Wallace , Oregon State University
Margaret M. Burnett , Oregon State University
Gregg Rothermel , Oregon State University
ABSTRACT
Spreadsheets are among the most common form of software in use today. Unlike more traditional forms of software however, spreadsheets are created and maintained by end users with little or no programming experience. As a result, a high percentage of these programs" contain errors. Unfortunately, software engineering research has for the most part ignored this problem. We have developed a methodology that is designed to aid end users in developing, testing, and maintaining spreadsheets. The methodology communicates testing information and information about the impact of cell changes to users in a manner that does not require an understanding of formal testing theory or the behind the scenes mechanisms. This paper presents the results of an empirical study that shows that, during maintenance, end users using our methodology were more accurate in making changes and did a significantly better job of validating their spreadsheets than end users without the methodology.
INDEX TERMS
spreadsheets, maintenance, testing, impact analysis, empirical study, visual programming
CITATION

C. R. Cook et al., "Incorporating Incremental Validation and Impact Analysis into Spreadsheet Maintenance: An Empirical Study," Proceedings IEEE International Conference on Software Maintenance. ICSM 2001(ICSM), Florence, Italy, 2001, pp. 72.
doi:10.1109/ICSM.2001.972713
86 ms
(Ver 3.3 (11022016))