Incorporating incremental validation and impact analysis into spreadsheet maintenance: An empirical study

IEEE International Conference on Software Maintenance, ICSM

Volumn , Issue , 2001, Pages 72-81

  Krishna, Vijay B ^a   Cook, Curtis R ^a   Keller, Daniel ^a   Cantrell, Joshua ^a   Wallace, Chris ^a   Burnett, Margaret M ^a   Rothermel, Gregg ^a  

^a OREGON STATE UNIVERSITY   (United States)

Author keywords

Empirical study; Impact analysis; Maintenance; Spreadsheets; Testing; Visual programming

Indexed keywords

IMPACT ANALYSIS; INCREMENTAL VALIDATION; VISUAL PROGRAMMING;

ADMINISTRATIVE DATA PROCESSING; COMPUTER PROGRAMMING LANGUAGES; COMPUTER SOFTWARE MAINTENANCE; FINANCIAL DATA PROCESSING; SPREADSHEETS;

SOFTWARE ENGINEERING;

EID: 77956612197     PISSN: None     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1109/ICSM.2001.972713     Document Type: Conference Paper

References (26)

1. A. Ambler, M. Burnett, and B. Zimmerman, "Operational versus definitional: A perspective on programming paradigms", Computer, 25(9):28-43, Sept. 1992.
2. P. Brown and J. Gould, "Experimental study of people creating spreadsheets", ACM Trans. Office Info. Sys., 5(3):258-272, July 1987.
3. M. Burnett and H. Gottfried, "Graphical definitions: Expanding spreadsheet languages through direct manipulation and gestures", ACM Trans. Computer Human Interaction, pages 1-33, Mar. 1998.
4. E. H. Chi, P. Barry, J. Riedl, and J. Konstan, "A spreadsheet approach to information visualization", In IEEE Symp. Info. Visualization, Oct. 1997.
5. J. S. Davis, "Tools for spreadsheet auditing", Intl. J. of Human-Computer Studies, 45:429-442, 1996.
6. E. Duesterwald, R. Gupta, and M. L. Soffa, "Rigorous data flow testing through output influences", In Proc. 2nd Irvine Softw. Symp., Mar. 1992.
7. P. Frankl and S. Weiss, "An experimental comparison of the effectiveness of branch testing and data flow testing", IEEE Trans. Softw. Eng., 19(8):774-787, Aug. 1993.
8. P. Frankl and E. Weyuker, "An applicable family of data flow criteria", IEEE Trans. Softw. Eng., 14(10):1483-1498, Oct. 1988.
9. M. Hutchins, H. Foster, T. Goradia, and T. Ostrand, "Experiments on the effectiveness of dataflow and control flow-based test adequacy criteria", In 16th Intl. Conf. Softw. Eng., pages 191-200, May 1994.
10. V. Krishna, C. Cook, D. Keller, J. Cantrell, C. Wallace, M. Burnett, G. Rothermel, "Empirical Study of a Spreadsheet Maintenance Task", Oregon State University, TR 01-60-06, Mar. 2001.
11. J. Leopold and A. Ambler, "Keyboardless visual programming using voice, handwriting, and gesture", IEEE Symp. On Visual Language., pages 28-35, Sept. 1997.
12. M. Marre and A. Bertolino, "Reducing and estimating the cost of test coverage criteria", In 1996 IEEE 18th Intl. Conf. Softw. Eng., pages 486-494, Mar. 1996.
13. B. Myers, "Graphical techniques in a spreadsheet for specifying user interfaces", In ACM CHI '91, pages 243-249, Apr. 1991.
14. R. Panko, "Finding spreadsheet errors: Most spreadsheet models have design flaws that may lead to long-term miscalculations", Information Week, pg. 100, May 29, 1995.
15. R. Panko, "What we know about spreadsheet errors", J. End User Comp., pages 15-21, Spring 1998.
16. R. Panko and R. Halverson Jr., "Spreadsheets on trial: A framework for research on spreadsheet risks", 29th Hawaii Intl. Conf. on System Sciences, Vol. II, pages 326-335, Jan. 1996.
17. K. Rajalingham, D. Chadwick, B. Knight and D. Edwards, "An integrated spreadsheet engineering methodology", IFIP TC11 WG11.5 Third Working Conf. on Integrity and Internal Control in Info. Systems, pages 41-58, Nov 1999.
18. S. Rapps and E. J. Weyuker, "Selecting software test data using data flow information", IEEE Trans. Softw. Eng., 11(4):367-375, Apr. 1985.
19. J, Reichwein, G. Rothermel, and M. Burnett, "Slicing spreadsheets: An integrated methodology for spreadsheet testing and debugging", 2nd Conf. on Domain Specific Languages, pages 25-38, Oct. 1999
20. K. Rothermel, C. Cook, M. Burnett, J. Schonfeld, T.R.G. Green, and G. Rothermel. "WYSIWYT testing in the spreadsheet paradigm: An empirical evaluation", 22nd Intl. Conf. on Softw. Eng., Limerick, pp. 230-239, June 2000.
21. G. Rothermel, M. Burnett, L. Li, C. DuPuis, A. Sheretov, "A methodology for testing spreadsheets", ACM Trans. on Softw. Eng. and Methodology, pages 110-147, Jan. 2001.
22. G. Rothermel, L. Li, C. DuPuis, and M. Burnett, "What you see is what you test: A methodology for testing form-based visual programs", In The 20th Intl. Conf. Softw. Eng., pages 198-207, Apr. 1998.
23. T. Smedley, P. Cox, and S. Byrne, "Expanding the utility of spreadsheets through the integration of visual programming and user interface objects", In Adv. Vis. Int. '96, May 1996.
24. G. Viehstaedt and A. Ambler, "Visual representation and manipulation of matrices", Journal Vis. Lang. and Comp., 3(3):273-298, Sept. 1992.
25. E. J. Weyuker, "More experience with dataflow testing", IEEE Trans. Softw. Eng., 19(9):912-919, Sept. 1993.
26. E. Wilcox, J. Atwood, M. Burnett, J. Cadiz, and C. Cook, "Does continuous visual feedback aid debugging in direct-manipulation programming systems", In ACM CHI'97, pages 258-265, Mar. 1997.