Hitting the wall: Errors in developing and code inspecting a 'simple' spreadsheet model

Decision Support Systems

Volumn 22, Issue 4, 1998, Pages 337-353

  Panko, Raymond R ^a   Sprague Jr , Ralph H ^a  

^a UNIVERSITY OF HAWAII   (United States)

Author keywords

Audit; Code inspection; Decision support system; End user computing; Error; Fault; Modeling; Spreadsheet

Indexed keywords

CODES (SYMBOLS); ERROR ANALYSIS; SPREADSHEETS;

CELL ERROR RATE (CER); CODE INSPECTION;

DECISION SUPPORT SYSTEMS;

EID: 0032043170     PISSN: 01679236     EISSN: None     Source Type: Journal    
DOI: 10.1016/S0167-9236(97)00038-9     Document Type: Article

References (53)

1. A.J. Albrecht, J. Gaffney Jr., Software function, software lines of code, and development effort prediction: a software science, IEEE Trans. Software Eng. 9 (11) (1983) 639-648.
2. C.M. Allwood, Error detection processes in statistical problem solving, Cogn. Sci. 8 (4) (1984) 413-437.
3. B.J. Baars (Ed.), Experimental Slips and Human Error, Plenum, New York, 1992.
4. V.R. Basili, R.W. Selby, Jr., Four applications of a software data collection and analysis methodology, in: J.K. Skwirzynski (Ed.), Software System Design Methods, Springer-Verlag, Berlin, 1986, pp. 3-33.
5. B. Beizer, Software Testing Techniques, 2nd edn., Van Nostrand-Reinhold, New York, 1990.
6. Y.M.M. Bishop, S.E. Fienberg, P.W. Holland, Discrete Multivariate Analysis: Theory and Practice, MIT Press, Cambridge, MA, 1975.
7. B.W. Boehm, Improving software productivity, Computer 20 (9) (1987) 43-57.
8. P.S. Brown, J.D. Gould, An experimental study of people creating spreadsheets, ACM Trans. Office Information Systems 5 (3) (1987) 258-272.
9. E.G. Cale Jr., Quality issues for end-user developed software, J. Systems Manage. 45 (1) (1994) 36-39.
10. S.K. Card, T.P. Moran, A. Newell, The Psychology of Human-Computer Interaction, Erlbaum, Hillsdale, NJ, 1983.
11. H.C. Chan, H.J. Lu, K.K. Wei, A survey of SQL language, J. Database Manage. 4 (4) (1993) 4-15.
12. P.G. Cragg, M. King, Spreadsheet modelling abuse: an opportunity for OR?, J. Operational Res. Soc. 44 (8) (1993) 743-752.
13. R. Creeth, Microcomputer spreadsheets: their uses and abuses, J. Accountancy 159 (6) (1985) 90-93.
14. A.D. Danu Tjahjono, Exploring The Effectiveness Of Formal Technical Review Factors With CSRS, A Collaborative Software Review System, Technical Report ICS-TR-95-08, Information and Computer Science Department, Univ. of Hawaii, Honolulu, HI, 96822, June, 1996.
15. N. Davies, C. Ikin, Auditing spreadsheets, Australian Accountant, December (1987) pp. 54-56.
16. S. Ditlea, Spreadsheets can be hazardous to your health, Personal Computing, January (1987) pp. 60-69.
17. M.E. Fagan, Design and code inspections to reduce errors in program development, IBM Systems J. 15 (3) (1976) 182-211.
18. B.D. Floyd, J. Pyun, Errors in Spreadsheet Use, working paper 167, Center for Research on Information Systems, Information Systems Department, New York Univ., New York, 1987.
19. E.H. Forman, N.D. Singpurwalla, An empirical stopping rule for debugging and testing computer software, J. Am. Stat. Assoc., Application Section 72 (360) (1977) 750-757.
20. D. Freeman, How to make spreadsheets error-proof, J. Accountancy 181 (5) (1996) 75-77.
21. D.F. Galletta, D. Abraham, M. ElLouadi, W. Lekse, Y.A. Pollalis, J.L. Sampler, An empirical study of spreadsheet error-finding performance, Accounting Manage. Information Technol. 3 (2) (1993) 79-95.
22. D.F. Galletta, K.S. Hartzel, S.E. Johnson, J.L. Joseph, S. Rustagi, Spreadsheet presentation and error detection, J. Manage. Information Systems 13 (3) Winter (1996) 45-63.
23. J.T. Grudin, Error patterns in novice and skilled transcription typing, Chap. 6, in: W.E. Cooper (Ed.), Cognitive Aspects of Skilled Typewriting, Springer-Verlag, New York, 1983, pp. 121-143.
24. M.J.J. Hall, A risk and control oriented study of the practices of spreadsheet application developers, in: Proceedings of the 29th Hawaii International Conference on System Sciences, Vol. II, January 1996, pp. 364-373.
25. K. Hassinen, An Experimental Study of Spreadsheet Errors Made by Novice Spreadsheet Users, Department of Computer Science, Univ. of Joensuu, P.O. Box 111, SF-80101 Joensuu, Finland, 1988.
26. J.R. Hayes, L.S. Flower, Identifying the organization of writing processes, in: L. Gregg, E. Steinberg (Eds.), Cognitive Processes in Writing, Erlbaum, Hillsdale, NJ, 1980, pp. 3-30.
27. D.G. Hendry, T.R.G. Green, Creating, comprehending, and explaining spreadsheets: a cognitive interpretation of what discretionary users think of the spreadsheet model, Int. J. Human-Comput. Studies 40 (6) (1994) 1033-1065.
28. M. Igbaria, F.N. Pavri, S.L. Huff, Microcomputer applications: an empirical look at usage, Information Manage. 16 (4) (1989) 187-196.
29. D. Janvrin, J. Morrison, Factors influencing risks and outcomes in end-user development, in: Proceedings of the 29th International Conference on System Sciences, Vol. II, Maui, Hawaii, January 1996, pp. 346-355.
30. C. Jones, Programming Productivity, McGraw-Hill, New York, 1986.
31. B. Kantowitz, R.D. Rorkin, Human Factors: Understanding People-System Relationships, Wiley, New York, 1983.
32. R. Kee, Programming standards for spreadsheet software, CMA Mag. 62 (3) (1988) 55-60.
33. K. Kukich, Techniques for automatically correcting words in text, ACM Computing Surveys 24 (4) (1992) 377-436.
34. F.J. Lerch, Computerized financial planning: discovering cognitive difficulties in knowledge building. Unpublished doctoral dissertation, Univ. of Michigan, Ann Arbor Sci. Publ., Ann Arbor, MI, 1988.
35. I. Lorge, H. Solomon, Two models of group behavior in the solution of eureka-type problems, Psychometrika 20 (2) (1955) 139-148.
36. M. Mattson, B.J. Baars, Error-minimizing mechanisms: boosting or editing, in: B.J. Baars (Ed.), Experimental Slips and Human Error, New York, Plenum, 1992, pp. 263-287.
37. E.R. McLean, L.A. Kappelman, J.P. Thompson, Converging end-user and corporate computing, Commun. ACM 36 (12) (1993) 79-92.
38. R.E. Melchers, M.V. Harrington, Human Error in Simple Design Tasks, Report No. 31, Civil Engineering Research Reports, Monash Univ., 1982.
39. G.A. Miller, The magic number seven plus or minus two, Psychol. Rev. 63 (1956) 81-97.
40. Morrison, 1995.
41. G.J. Myers, A controlled experiment in program testing and code walkthroughs/inspections, Commun. ACM 21 (9) (1978) 760-768.
42. R.R. Panko, End User Computing: Management, Applications, and Technology, Wiley, New York, 1988.
43. R.R. Panko, R.H. Halverson, Jr., Are two heads better than one? (at reducing errors in spreadsheet development), Office Systems Res. J., forthcoming.
44. R.R. Panko, R.H. Halverson, Jr., Introduction to the minitrack on risks in end user computing, in: Proceedings of the 29th Hawaii International Conference on System Sciences, Vol. II, Maui, Hawaii, January (1996a) pp. 324-325.
45. R.R. Panko, R.H. Halverson, Jr., Spreadsheets on trial: a survey of research on spreadsheet risks, in: Proceedings of the 29th Hawaii International Conference on System Sciences, Vol. II, Maui, Hawaii, January (1996b) pp. 324-325.
46. L.H. Putnam, W. Myers, Measures for Excellence: Reliable Software on Time, on Budget, Yourdon, Englewood Cliffs, NJ, 1992.
47. J. Reason, Human Error, Cambridge Univ. Press, Cambridge, UK, 1990.
48. B. Ronen, M.A. Palley, H. Lucas, Spreadsheet analysis and design, Commun. ACM 32 (1) (1989) 84-92.
49. B. Spencer, Software inspections at applicon, in: T. Gilb, D. Graham (Eds.), Software Inspection, Addison-Wesley, Workingham, England, 1993, pp. 264-279.
50. R.H. Sprague, Jr., E.D. Carlson, Building Effective Decision Support Systems, Prentice-Hall, Englewood Cliffs, NJ, 1982.
51. Strauss, Ebenau, 1983.
52. S.H. Strauss, R.G. Ebenau, Software Inspection Process, McGraw-Hill, New York, 1994.
53. T.S.H. Teo, M. Tan, Quantitative and qualitative errors in spreadsheet development, in: Proceedings of the Thirtieth Hawaii International Conference on System Sciences, Vol. III, Kihei, Hawaii, January 1997, pp. 149-155.