Incorporating incremental validation and impact analysis into spreadsheet maintenance: an empirical study
- 13 November 2002
- conference paper
- Published by Institute of Electrical and Electronics Engineers (IEEE)
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. The 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.Keywords
This publication has 21 references indexed in Scilit:
- Reducing and estimating the cost of test coverage criteriaPublished by Institute of Electrical and Electronics Engineers (IEEE) ,2002
- What you see is what you test: a methodology for testing form-based visual programsPublished by Institute of Electrical and Electronics Engineers (IEEE) ,2002
- Keyboardless visual programming using voice, handwriting, and gesturePublished by Institute of Electrical and Electronics Engineers (IEEE) ,2002
- WYSIWYT testing in the spreadsheet paradigm: an empirical evaluationPublished by Institute of Electrical and Electronics Engineers (IEEE) ,2002
- A methodology for testing spreadsheetsACM Transactions on Software Engineering and Methodology, 2001
- Slicing spreadsheetsPublished by Association for Computing Machinery (ACM) ,1999
- What We Know About Spreadsheet ErrorsJournal of Organizational and End User Computing, 1998
- Spreadsheets on trial: a survey of research on spreadsheet risksPublished by Institute of Electrical and Electronics Engineers (IEEE) ,1996
- Graphical techniques in a spreadsheet for specifying user interfacesPublished by Association for Computing Machinery (ACM) ,1991
- Selecting Software Test Data Using Data Flow InformationIEEE Transactions on Software Engineering, 1985