Reasoning about many-to-many requirement relationships in spreadsheets

被引:6
作者
Beckwith, L [1 ]
Burnett, M [1 ]
Cook, C [1 ]
机构
[1] Oregon State Univ, Corvallis, OR 97331 USA
来源
IEEE 2002 SYMPOSIA ON HUMAN CENTRIC COMPUTING LANGUAGES AND ENVIRONMENTS, PROCEEDINGS | 2002年
关键词
D O I
10.1109/HCC.2002.1046367
中图分类号
TP31 [计算机软件];
学科分类号
081202 [计算机软件与理论]; 0835 [软件工程];
摘要
To help improve the reliability of spreadsheets created by end users, we are working to allow users to communicate the purpose and other underlying information about their spreadsheets, using a form of requirement specifications we call "guards." For large spreadsheets with replicated/shared formulas across groups of rows or columns, guards can only be practical if users can enter them across these groups of rows or columns. The problem is, this introduces many-to-many relationships, and it is not clear how the system should reason and communicate about them in a way that will make sense to end users. In this paper, we present the human-centric design rationale for our approach to how the system should reason about such many-to-many relationships. The design decisions are presented with their reasons gleaned from two design-time models-Cognitive Dimensions and Attention Economics-and from the users themselves in a small think-aloud study.
引用
收藏
页码:149 / 157
页数:9
相关论文
共 21 条
[1]
Helping people find what they don't know -: Recommendation systems help users find the correct words for a successful search. [J].
Belkin, NJ .
COMMUNICATIONS OF THE ACM, 2000, 43 (08) :58-61
[2]
BLACKWELL A, 1999, WKSH PSYCH PROGR INT, P24
[3]
Forms/3: A first-order visual language to explore the boundaries of the spreadsheet paradigm [J].
Burnett, M ;
Atwood, J ;
Djang, RW ;
Reichwein, J ;
Gottfried, H ;
Yang, S .
JOURNAL OF FUNCTIONAL PROGRAMMING, 2001, 11 :155-206
[4]
BURNETT M, 2002, IN PRESS IEEE T SOFT
[5]
CORRITORE C, 2001, HCI INT, V1, P1548
[6]
Ericsson K. A., 1984, PROTOCOL ANAL
[7]
Ernst M. D., 1999, Proceedings of the 1999 International Conference on Software Engineering (IEEE Cat. No.99CB37002), P213, DOI 10.1109/ICSE.1999.841011
[8]
GRAY W, 2001, ACM C HUM FACT COMP, P112
[9]
Usability analysis of visual programming environments: A 'cognitive dimensions' framework [J].
Green, TRG ;
Petre, M .
JOURNAL OF VISUAL LANGUAGES AND COMPUTING, 1996, 7 (02) :131-174
[10]
A testing methodology for a dataflow based visual programming language [J].
Karam, MR ;
Smedley, TJ .
IEEE SYMPOSIA ON HUMAN-CENTRIC COMPUTING LANGUAGES AND ENVIRONMENTS, PROCEEDINGS, 2001, :280-287