Spreadsheets on trial: A survey of research on spreadsheet risks

Proceedings of the Annual Hawaii International Conference on System Sciences

Volumn 2, Issue , 1996, Pages 326-335

  Panko, R R ^a   Halverson, R P ^a  

^a UNIVERSITY OF HAWAII   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

DECISION SUPPORT SYSTEMS; KNOWLEDGE BASED SYSTEMS; SURVEYS;

ANECDOTAL EVIDENCES; END USER COMPUTING; END USERS; SPREADSHEET DEVELOPMENT;

SPREADSHEETS;

EID: 77953475502     PISSN: 15301605     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1109/HICSS.1996.495416     Document Type: Conference Paper

References (25)

1. Brown, P. S. & Gould, J. D. "An Experimental Study of People Creating Spreadsheets," ACM Transactions on Office Information Systems (5:3) July 1987, pp. 258-272.
2. Cale, E. G., Jr., "Quality Issues for End-User Developed Software," Journal of Systems Management (45:1) January 1994, pp. 36-39.
3. Cragg, P. G. & King, M. "Spreadsheet Modelling Abuse: An Opportunity for OR?" Journal of the Operational Research Society (44:8) August 1993, pp. 743-752.
4. Davies, N. & Ikin, C. "Auditing Spreadsheets," Australian Accountant, December 1987, pp. 54-56.
5. Dent, A., personal communication with the first author via electronic mail, April 2, 1995.
6. Floyd, B. D. & Pyun, J. Errors in Spreadsheet Use, Working Paper 167, Information Systems Department, New York University, 1987.
7. Floyd, B. D., Walls, J., & Marr, K., "Managing Spreadsheet Model Development," Journal of Systems Management (46:1) May/June 1995, pp. 38-43, 68.
8. Galletta, D. F.; Abraham, D.; El Louadi, M.; Lekse, W.; Pollalis, Y. A.; & Sampler, J. L. "An Empirical Study of Spreadsheet Error-Finding Performance," Accounting Management Information Technology (3:2) 1993.
9. Galletta, D. F.; Hartzel, K. S.; Johnson, S.; Joseph, J.; & Rustagi, S, "An Experimental Study of Spreadsheet Presentation and Error Detection." Proceedings of the Twenty-Ninth Hawaii International Conference on System Sciences, Maui, Hawaii, January 1996.
10. Galletta, D. F. & Hufhagel, E. M. "A Model of End-User Computing Policy," Information & Management (22) 1992, pp. 1-18.
11. Hall, M. J. J., "A Risk and Control Oriented Study of the Practices of Spreadsheet Application Developers, Proceedings of the Twenty-Ninth Hawaii International Conference on System Sciences, Maui, Hawaii, January 1996.
12. Hassinen, K. An experimental study of spreadsheet errors made by novice spreadsheet users, Department of Computer Science, University of Joensuu, P. O. Box 111, SF-80101 Joensuu, Finland, 1988.
13. Hassinen, K., University of Joensuu, private communication with the first author, January 1995.
14. Hicks, L., NYNEX Corporation. Private communication with the author, June 1995.
15. Hendry, D. G. & Green, T. R. G. "Creating, Comprehending, and Explaining Spreadsheets: A Cognitive Interpretation of What Discretionary Users Think of the Spreadsheet Model," International Journal of Human-Computer Studies (40:6) June 1994, pp. 1033-1065.
16. Janvrin, D. & Morrison, J., "Factors Influencing Risks and Outcomes in End-User Development," Proceedings of the Twenty-Ninth Hawaii International Conference on System Sciences, Maui, Hawaii, January 1996.
17. Lerch, F. J. Computerized Financial Planning: Discovering Cognitive Difficulties in Knowledge Building. Unpublished doctoral dissertation, University of Michigan, Ann Arbor, Michigan, 1988. Cited in Olson, J. R. & Olson, G. M., 1990.
18. Lorge, I. & Solomon, H. "Two Models of Group Behavior in the Solution of Eureka-Type Problems," Psychometrika (20:2) June 1955, pp. 139-148.
19. Nardi, B. A. & Miller, J. R. "Twinkling Lights and Nested Loops: Distributed Problem Solving and Spreadsheet Development," International Journal of Man-Machine Studies (34:2) February 1991, pp. 161-184.
20. Olson, J. R. & Nilsen, E. "Analysis of the Cognition Involved in Spreadsheet Interaction. Human- Computer Interaction (3:4) 1987-1988, pp. 309-349.
21. Panko, R. R. & Halverson, R. H. Patterns of Errors in Spreadsheet Development I: Quantitative Errors, Working Paper, Department of Decision Sciences, College of Business Administration, University of Hawaii, 2404 Maile Way, Honolulu, HI 96822, March 1995. ftp://splicer2.cba.hawaii.edu/panko/ sserrors/sswpmar.doc
22. Panko, R. R. "Hitting the Wall: Errors in Developing and Debugging in a "Simple" Spreadsheet Problem," Proceedings of the Twenty-Ninth Hawaii International Conference on System Sciences, Maui, Hawaii, January 4-7, 1996.
23. Ruby, R. J.; Dana, J. A.; & Biche, P. W. "Quantitative Aspects of Software Validation," IEEE Transactions on Software Engineering (SE-1:2) June 1975, pp. 156-155.
24. Schultheis, R. & Sumner, M. "The Relationship of Application Risks to Application Controls: A Study of Microcomputer-Based Spreadsheet Applications," Journal of End User Computing (6:2) Spring 1994, pp. 11-18.
25. Speier, C & Brown, C. V., "Perceived Risks and Management Actions: Differences in End-User Application Development Across Functional Groups," Proceedings of the Twenty-Ninth Hawaii International Conference on System Sciences, Maui, Hawaii, January 1996.