|
 ABSTRACT
Nine experienced users of electronic spreadsheets each created three spreadsheets. Although participants were quite confident that their spreadsheets were accurate, 44 percent of the spreadsheets contained user-generated programming errors. With regard to the spreadsheet creation process, we found that experienced spreadsheet users spend a large percentage of their time using the cursor keys, primarily for the purpose of moving the cursor around the spreadsheet. Users did not spend a lot of time planning before launching into spreadsheet creation, nor did they spend much time in a separate, systematic debugging stage. Participants spent 21 percent of their time pausing, presumably reading and/or thinking, prior to the initial keystrokes of spreadsheet creation episodes.
REFERENCES
Note: OCR errors may be found in this Reference List extracted from the full text article. ACM has opted to expose the complete List rather than only correct and linked references.
| |
1
|
|
| |
2
|
CREETH, R. Micro-computer spreadsheets: Their uses and abuses. J. Account. {June 1985), 90-93.
|
| |
3
|
DOHERTY, W. J., AND POPE, W. Computing as a tool for human augmentation. IBM Tech. Rep. RC- 11622, June 1986.
|
| |
4
|
GOULD, J.D. Experiments on composing letters: Some facts, some myths, and some observations. In Cognitive Processes in Writing, L. Gregg and E. R. Steinberg, Eds. Erlbaum, Hillsdale, N.J., 1980, 97-118.
|
| |
5
|
GOULD, J. D. Composing letters with computer-based text editors. Hum. Factors 23 (1981), 593-606.
|
 |
6
|
|
| |
7
|
GRUSHCOW, J. Avoid these common spreadsheet errors. Lotus (July 1984), 59-62.
|
| |
8
|
LEVY, S. A spreadsheet way of knowledge. Harpers (Nov. 1984), 58-64.
|
| |
9
|
OLSON, J., AND NILSEN, E. Analysis of the cognition involved in spreadsheet software interaction. Paper presented at the twenty-sixth annual meeting of the Psychonomics society, 1985.
|
| |
10
|
John Whiteside , Norman Archer , Dennis Wixon , Michael Good, How do people really use text editors?, Proceedings of the SIGOA conference on Office information systems, p.29-40, June 21-23, 1982, Philadelphia, Pennsylvannia, United States
|
CITED BY 34
|
|
|
|
|
|
|
|
Gregg Rothermel , Lixin Li , Christopher DuPuis , Margaret Burnett, What you see is what you test: a methodology for testing form-based visual programs, Proceedings of the 20th international conference on Software engineering, p.198-207, April 19-25, 1998, Kyoto, Japan
|
|
|
|
|
|
Marc Fisher , Mingming Cao , Gregg Rothermel , Curtis R. Cook , Margaret M. Burnett, Automated test case generation for spreadsheets, Proceedings of the 24th International Conference on Software Engineering, May 19-25, 2002, Orlando, Florida
|
|
|
|
|
|
|
|
|
Karen J. Rothermel , Curtis R. Cook , Margaret M. Burnett , Justin Schonfeld , T. R. G. Green , Gregg Rothermel, WYSIWYT testing in the spreadsheet paradigm: an empirical evaluation, Proceedings of the 22nd international conference on Software engineering, p.230-239, June 04-11, 2000, Limerick, Ireland
|
|
|
|
|
|
E. M. Wilcox , J. W. Atwood , M. M. Burnett , J. J. Cadiz , C. R. Cook, Does continuous visual feedback aid debugging in direct-manipulation programming systems?, Proceedings of the SIGCHI conference on Human factors in computing systems, p.258-265, March 22-27, 1997, Atlanta, Georgia, United States
|
|
|
|
|
|
|
|
|
|
|
|
Martin Erwig , Robin Abraham , Irene Cooperstein , Steve Kollmansberger, Automatic generation and maintenance of correct spreadsheets, Proceedings of the 27th international conference on Software engineering, May 15-21, 2005, St. Louis, MO, USA
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Bradley T. Vander Zanden , David Baker , Jing Jin, An explanation-based, visual debugger for one-way constraints, Proceedings of the 17th annual ACM symposium on User interface software and technology, October 24-27, 2004, Santa Fe, NM, USA
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Marc Fisher, II , Gregg Rothermel , Darren Brown , Mingming Cao , Curtis Cook , Margaret Burnett, Integrating automated test generation into the WYSIWYT spreadsheet testing methodology, ACM Transactions on Software Engineering and Methodology (TOSEM), v.15 n.2, p.150-194, April 2006
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
REVIEW
"Robert M. Lynch : Reviewer"
.abstract
Nine experienced users of electronic spreadsheets each created three
spreadsheets. Although participants were quite confident that their
spreadsheets were accurate, 44 percent of the spreadsheets contained
user-generated programming er
more...
|
Adobe Acrobat
QuickTime
Windows Media Player
Real Player
Pdf
D.3