End-user software engineering with assertions in the spreadsheet paradigm

被引:67
作者
Burnett, M [1 ]
Cook, C [1 ]
Pendse, O [1 ]
Rothermel, G [1 ]
Summet, J [1 ]
Wallace, C [1 ]
机构
[1] Oregon State Univ, Corvallis, OR 97331 USA
来源
25TH INTERNATIONAL CONFERENCE ON SOFTWARE ENGINEERING, PROCEEDINGS | 2003年
关键词
D O I
10.1109/ICSE.2003.1201191
中图分类号
TP31 [计算机软件];
学科分类号
081202 ; 0835 ;
摘要
There has been little research on end-user program development beyond the activity of programming. Devising ways to address additional activities related to end-user program development may be critical, however, because research shows that a large proportion of the programs written by end users contain faults. Toward this end, we have been working on ways to provide formal "software engineering" methodologies to end-user programmers. This paper describes an approach We have developed for supporting assertions in end-user software, focusing on the spreadsheet paradigm. We also report the results of a controlled experiment, with 59 end-user subjects, to investigate the usefulness of this approach. Our results show that the end users were able to use the assertions to reason about their spreadsheets, and that doing so was tied to both greater correctness and greater efficiency.
引用
收藏
页码:93 / 103
页数:11
相关论文
共 31 条
[11]  
Fisher M, 2002, ICSE 2002: PROCEEDINGS OF THE 24TH INTERNATIONAL CONFERENCE ON SOFTWARE ENGINEERING, P141, DOI 10.1109/ICSE.2002.1007963
[12]  
Hangal S, 2002, ICSE 2002: PROCEEDINGS OF THE 24TH INTERNATIONAL CONFERENCE ON SOFTWARE ENGINEERING, P291, DOI 10.1109/ICSE.2002.1007976
[13]   Incorporating incremental validation and impact analysis into spreadsheet maintenance: An empirical study [J].
Krishna, VB ;
Cook, CR ;
Keller, D ;
Cantrell, J ;
Wallace, C ;
Burnett, MM ;
Rothermel, G .
IEEE INTERNATIONAL CONFERENCE ON SOFTWARE MAINTENANCE, PROCEEDINGS: SYSTEMS AND SOFTWARE EVOLUTION IN THE ERA OF THE INTERNET, 2001, :72-81
[14]   ANALYSES OF FACTORS RELATED TO POSITIVE TEST BIAS IN SOFTWARE TESTING [J].
LEVENTHAL, LN ;
TEASLEY, BE ;
ROHLMAN, DS .
INTERNATIONAL JOURNAL OF HUMAN-COMPUTER STUDIES, 1994, 41 (05) :717-749
[15]   APPLYING DESIGN BY CONTRACT [J].
MEYER, B .
COMPUTER, 1992, 25 (10) :40-51
[16]  
MICHAEL J, 2001, INT C TECHN OBJ OR L
[17]  
MILLER R, 2001, ACM S USER INTERFACE
[18]   Studying the language and structure in non-programmers' solutions to programming problems [J].
Pane, JF ;
Ratanamahatana, C ;
Myers, BA .
INTERNATIONAL JOURNAL OF HUMAN-COMPUTER STUDIES, 2001, 54 (02) :237-264
[19]  
PANKO R., 1995, INFORMATION WEEK MAY, P100
[20]  
Panko R. R., 1998, Journal of End User Computing, V10, P15