Helping end users create and manage test cases in the WYSIWYT methodology

• Main Author: Fisher, Marc Randall
• Other Authors: Rothermel, Gregg
• Language: en_US
• Published: 2012
• Subjects: Electronic spreadsheets > Testing
• Online Access: http://hdl.handle.net/1957/28615

Previous work has developed the What You See Is What You Test (WYSIWYT) methodology for testing spreadsheets. This methodology has been shown to help end users test, debug, and modify spreadsheets. To date, however, this system has provided no support for creating, reusing, and managing test cases, a process that can be tedious and time-consuming. To alleviate this, we have developed automated test case generation and test reuse methodologies for the WYSIWYT methodology. For test case generation, we have prototyped two techniques, and performed a study to assess the effectiveness and efficiency of these techniques. The results of this study show that we can efficiently exercise a large percentage of a spreadsheet under test. We also implemented a test reuse methodology and performed a study that shows that we are able to find a relatively small subset of test cases to reuse after a modification to a spreadsheet, and that these test cases re-establish much of the coverage lost by modifications made to the spreadsheet. === Graduation date: 2003