Using a structured design approach to reduce risks in end user spreadsheet development

Information and Management

Volumn 37, Issue 1, 2000, Pages 1-12

  Janvrin, Diane ^a   Morrison, Joline ^b  

^a UNIVERSITY OF IOWA   (United States)

^b UNIVERSITY OF WISCONSIN EAU CLAIRE   (United States)

Author keywords

Risks in end user development; Spreadsheet errors; Structured design

Indexed keywords

EID: 0042633688     PISSN: 03787206     EISSN: None     Source Type: Journal    
DOI: 10.1016/S0378-7206(99)00029-4     Document Type: Article

References (39)

1. B. Adelson, E. Soloway, The role of domain experience in software design, IEEE Transactions on Software Engineering 11(11) (1985), pp. 1351-1360.
2. M. Alavi, I. Weiss, Managing the risks associated with end-user computing, Journal of Management Information Systems 2(3) (1986), pp. 413-426.
3. D. Batra, A framework for studying human error behavior in conceptual database modeling, Information and Management 25(3) (1993), pp. 121-131.
4. R.S. Billings, S.P. Wroten, Use of path analysis industrial/ organizational psychology: Criticisms and suggestions, Journal of Applied Psychology 63 (1978), pp. 677-688.
5. P.S. Brown, J.D. Gould, An experimental study of people creating spreadsheets, ACM Transactions on Office Information Systems 5 (1987), pp. 258-272.
6. E. Cale, Quality issues for end-user developed software, Journal of Systems Management 45 (1994), pp. 36-39.
7. P. Cheney, R. Mann, D. Amoroso, Organizational factors affecting the success of end-user computing, Journal of Management Information Systems 3(1) (1986), pp. 65-80.
8. L. Constantine, E. Yourdon, Structured Design, Prentice-Hall, Englewood Cliffs, NJ, 1979.
9. W. Cotterman, K. Kumar, User cube: a taxonomy of end users, Communications of the ACM 32(11) (1989), pp. 1313-1320.
10. B. Curtis, H. Krasner, N. Iscoe, A field study of the software design process for large systems, Communications of the ACM 31(11) (1988), pp. 1268-1287.
11. N. Davies, C. Ikin, Auditing spreadsheets, Australian Accountant, 1987, pp. 54-56.
12. F. Davis, Perceived usefulness, and user acceptance of information technology, MIS Quarterly 13(3) (1989), pp. 318-339.
13. F. DeRemer, H. Kron, Programming-in-the-large versus programming-in-the-small, IEEE Transactions on Software Engineering 2(1) (1976), pp. 80-86.
14. W. Doll, W. Torkzadeh, A discrepancy model of end-user computing involvement, Management Science 35(10) (1989), pp. 1151-1171.
15. J. Frank, B. Shamir, W. Briggs, Security-related behavior of PC users in organizations, Information and Management. 21(4) (1991), pp. 127-135.
16. C. Gane, T. Sarson, Structured Systems Analysis, Prentice-Hall, Englewood Cliffs, NJ, 1979.
17. A. Harrison, R.K. Rainer, The influence of individual differences on skill in end-user computing, Journal of Management Information Systems 9(1) (1992), pp. 93-111.
18. D.R. Heise, Problems in path analysis and causal inference, in: E.F. Borgatta (Ed.), Sociological Methodology, Jossey-Bass, San Francisco, CA 1969, pp. 38-73.
19. J. Henderson, M. Treacy, Managing end-user computing for competitive advantage, Sloan Management Review 28 (1986), pp. 3-14.
20. D.G. Hendry, T.R.G. Green, Creating, Creating and comprehending and explaining spreadsheets: a cognitive interpretation of what discretionary users think of the spreadsheet model, International Journal of Human-Computer Studies 40 (1994), pp. 1033-1065.
21. R. Hilton, Managerial Accounting, 2nd ed., McGraw Hill, New York, NY, 1994, pp. 439-440.
22. M. Igbaria, S. Parasuraman, A path analytic study of individual characteristics, computer anxiety and attitudes toward microcomputers, Journal of Management 15(3) (1989), pp. 373-387.
23. I. Lorge, H. Solomon, Two models of group behavior in the solution of Eureka-type problems, Psychometrika 20(2) (1955) (cited in [29]).
24. L. Markus, M. Keil, If we build it, they will come: designing information systems that people want to use, Sloan Management Review 36 (1994), pp. 11-25.
25. S. Moriarity, C. Allen, Cost Accounting, 3rd ed., Wiley, New York, NY, 1991, pp. 285-291.
26. B. Nardi, J. Miller, Twinkling lights and nested loops: distributed problem solving and spreadsheet development, International Journal Man-Machine Studies 24 (1991), pp. 161-184.
27. O. Ngwenyama, Developing end-users' systems development competence, Information and Management 25(6) (1993), pp. 291-302.
28. R.R. Panko, What we know about spreadsheet errors, Journal of End User Computing 10 (1998), pp. 15-21.
29. R.R. Panko, R.P. Halverson, Individual and group spreadsheet design: Patterns of Errors, in Proceedings of the 27th Hawaii International Conference on System Sciences, Vol. IV, IEEE Computer Society Press, 1994, pp. 4-10.
30. R.R. Panko, R.P. Halverson, Spreadsheets on trial: a survey of research on spreadsheet risks, in Proceedings of the 29th Hawaii International Conference on System Sciences, Vol. II, IEEE Computer Society Press, 1996, pp. 326-335.
31. R.R. Panko, R.P. Halverson, Are two heads better than one (at reducing spreadsheet errors in spreadsheet modeling)?, Office Systems Research Journal 15 (1997), pp. 21-32.
32. R.R. Panko, R.H. Sprague, Hitting the wall: errors in developing and code inspecting a 'simple' spreadsheet model, Decision Support Systems 22 (1998), pp. 337-353.
33. K. Rajalingham, D. Chadwick, Integrity control of spreadsheets: Organization & tools, in: S. Jajodia, W. List, G. McGregor, L. Strous (Eds.), Integrity and Internal Control in Information Systems, Kluwer Academic Publishers, Boston, MA, 1998, pp. 147-168.
34. J. Rockart, L. Flannery, The management of end user computing, Communications of the ACM 26 (1983), pp. 776-784.
35. B. Ronen, M. Palley, H. Lucas, Spreadsheet analysis and design, Communications of the ACM 32 (1989), pp. 84-93.
36. D. Ross, K. Schoman, Structured analysis for requirements definition, IEEE Transactions on Software Engineering 3(1) (1977), pp. 6-15.
37. L. Salchenberger, Structured development techniques for user-developed systems, Information and Management 24(1) (1993), pp. 41-50.
38. E.J. Savitz, Magellan loses its compass, Barron's 84(12) (1994), pp. 50.
39. M.G. Simkin, How to validate spreadsheets, Journal of Accountancy 164(5) (1987), pp. 130-138.