Effects of error factors and prior incremental practice on spreadsheet error detection: An experimental study

Omega

Volumn 29, Issue 5, 2001, Pages 445-456

  Teo, Thompson S H ^a   Lee Partridge, Joo Eng ^a  

^a NATIONAL UNIVERSITY OF SINGAPORE   (Singapore)

Author keywords

Debugging; Detection of errors; Qualitative errors; Quantitative errors; Spreadsheet errors

Indexed keywords

SPREADSHEETS;

DEBUGGING; DETECTION OF ERROR; DOMAIN FREE; ERROR FACTORS; QUALITATIVE ERROR; QUANTITATIVE ERROR; SPREADSHEET ERRORS; TWO DOMAINS;

ERROR DETECTION;

EID: 0042381851     PISSN: 03050483     EISSN: None     Source Type: Journal    
DOI: 10.1016/S0305-0483(01)00037-8     Document Type: Article

References (39)

1. Ditlea S. Spreadsheets can be hazardous to your health. Personal Computing. 11(1):1987;60-69.
2. Galletta DF, Hartzel KS, Johnson S, Joseph J, Rustagi S. Spreadsheet presentation and error detection: an experimental study. Journal of Management Information Systems 1996-97;13:45-63.
3. Kee R.C., Mason Jr J.O. Preventing errors in spreadsheets. Internal Auditor. 45(1):1988;42-47.
4. Panko RR. Hitting the wall: errors in developing and debugging in a "simple" spreadsheet problem. In: Proceedings of the 29th Hawaii International Conference on System Sciences, Maui, Hawaii, January 4-7, 1996. p. 356-63.
5. Teo TSH, Tan M. Quantitative and qualitative errors in spreadsheet development. Proceedings of the 30th Annual Hawaii International Conference on System Sciences, Wailea, Hawaii, 7-10 January, 1996. p. 149-55.
6. Cale Jr E.G. Quality issues for end-user developed software. Journal of Systems Management. 45:1994;36-39.
7. Cragg P.G., King M. Spreadsheet modelling abuse: an opportunity for OR? Journal of the Operational Research Society. 44:1993;743-752.
8. 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):1994;1033-1065.
9. 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):1994;11-18.
10. Olson JR, Nilsen E. Analysis of the cognition involved in spreadsheet interaction Human Computer Interaction 1987-88;3:309-49.
11. Janvrin D, Morrison, J. Factors influencing risks and outcomes in end-user development. In: Proceedings of the 29th Hawaii International Conference on System Sciences, Maui, Hawaii, January 4-7, 1996. p. 346-55.
12. Galletta D.F., Abraham D., El Louadi M., Leske W., Pollalis Y.A., Sampler J.L. An empirical study of spreadsheet error-finding performance. Accounting, Management and Information Technologies. 3:1993;79-95.
13. Galletta DF, Hartzel KS, Johnson S, Joseph J, Rustagi S (1996). An experimental study of spreadsheet presentation and error detection. In: Proceedings of the 29th Hawaii International Conference on System Sciences, Maui, Hawaii, January 4-7, 1996. p. 336-45.
14. Davies N., Ikin C. Auditing spreadsheets. Australian Accountant. 57(11):1987;54-56.
15. Hall MJJ. A risk and control oriented study of the practices of spreadsheet application developers. In: Proceedings of the 29th Hawaii International Conference on System Sciences, Maui, Hawaii, January 4-7, 1996. p. 364-73.
16. Brown P.S., Gould J.D. An experimental study of people creating spreadsheets. ACM Transactions on Office Information Systems. 5:1987;258-272.
17. Creeth R. Microcomputers' spreadsheets: their uses and abuses. Journal of Accountancy. 159(6):1985;90-93.
18. Panko RR, Halverson Jr RP. Spreadsheets on trial: a survey of research on spreadsheet risks. Proceedings of the 29th Hawaii International Conference on System Sciences, Maui, Hawaii, January 4-7, 1996. p. 326-35.
19. Floyd B.D., Walls J., Marr K. Managing spreadsheet model development. Journal of Systems Management. 46(1):1995;38-43,68.
20. Anderson K., Bernard A. Spreading mistakes. Journal of Accounting and EDP. 4(2):1988;42-45.
21. Ballou D.P., Pazer H.L., Belardo S., Klein B. Implications of data quality for spreadsheet analysis. Data Base. 18:1987;13-19.
22. Pearson R. Lies, damned lies, and spreadsheets. Byte. 299-304:1988.
23. Stang D. Spreadsheet disasters I have known. Information Center. 3:1987;26-30.
24. Panko R.R., Halverson Jr R.P. Are two heads better than one? (at reducing errors in spreadsheet modeling? Office Systems Research Journal. 15(1):1997;21-32.
25. Panko RR, Halverson Jr RP. Patterns of errors in spreadsheet development I: quantitative errors. Working Paper, Department of Decision Sciences, College of Business Administration, University of Hawaii, March 1995.
26. Panko R.R., Sprague Jr R.H. Hitting the wall: errors in developing and code inspecting a 'simple' spreadsheet model. Decision Support Systems. 22:1998;337-353.
27. Lerch FJ. Computerized financial planning: discovering cognitive difficulties in model building. Unpublished Ph.D. dissertation, University of Michigan, Ann Arbor, 1988.
28. Reithal B.J., Nichols D.L., Robinson R.K. An experimental investigation of the effects of size, format, and errors on spreadsheet reliability perception. Journal of Computer Information Systems. 54-64:1996.
29. Panko R.R. End user computing: management, applications, and technology. 1988;Wiley, New York.
30. Teo T.S.H., Tan M. Spreadsheet development and "what-if" analysis: quantitative versus qualitative errors. Accounting, Management and Information Technologies. 9:1999;141-160.
31. Dillon A. Reading from paper versus screens: a critical review of the empirical literature. Ergonomics. 35(10):1992;1297-1326.
32. Gould JD, Alfaro L, Barnes V, Finn R, Grischkowsky N, Minuto A. Reading is slower from CRT displays than from paper: attempts to isolate a single-variable explanation. Human Factors 1987a;29(3):269-99.
33. Gould JD, Alfaro L, Finn R, Haupt B, Minuto A. Reading from CRT displays can be as fast as reading from paper. Human Factors 1987b;29(5):497-517.
34. Oliver R. Proof-reading on paper and screens: the influence of practice and experience on performance. Journal of Computer-based Instruction. 20(4):1994;118-124.
35. Davis G.B., Olson M.H. Management information systems: conceptual foundations, structure and development. 2nd edn. 1984;McGraw-Hill, Singapore.
36. Igbaria M., Iivari J. The effects of self-efficacy on computer usage. Omega. 23(6):1995;587-605.
37. Young E.A. Human errors in programming. International Journal of Man-Machine Studies. 6:1974;361-376.
38. Goss E., Dillon T., Kendrick J. Bittersweet spreadsheets: application development needs control. The Woman CPA. 51(3):1990;20-24.
39. Janvrin D., Morrison J. Using a structured design approach to reduce risks in end user development. Information and Management. 37:2000;1-12.