The role of spreadsheet knowledge in user-developed application success

Spreadsheets are the most commonly used tool for end user development of applications, and organizations depend heavily upon them for decision making. This paper reports on a study to investigate the role of spreadsheet knowledge in the successful use of spreadsheet applications. It considers both the spreadsheet knowledge of the user developer and the spreadsheet knowledge of the user and tests a model of the effect of spreadsheet knowledge on the success of a user-developed spreadsheet application. Spreadsheet knowledge was shown to be important in two ways. It influences the quality of the system being developed, but it also acts directly upon the individual impact of the application. Successful use appears to require sufficient knowledge to understand and, if necessary, alter the application.

[1]  Suzanne Rivard,et al.  Factors of success for end-user computing , 1988, CACM.

[2]  Richard G. Lomax,et al.  A Beginner's Guide to Structural Equation Modeling , 2022 .

[3]  R. Bagozzi,et al.  A general approach to representing multifaceted personality constructs: Application to state self‐esteem , 1994 .

[4]  Henry C. Lucas,et al.  Spreadsheet analysis and design , 1989, CACM.

[5]  Timothy Paul Cronan,et al.  On the improvement of end-user developed systems using systems analysis and design , 1998 .

[6]  Keen.  An Empirical Evaluation of User Information Satisfaction (UIS) Measures for Use with General Ledger Accounting Software I. Introduction , 2002 .

[7]  George M. Kasper,et al.  The Effect of User-Developed DSS Applications of Forecasting Decision-Making Performance in an Experimental Setting , 1985, J. Manag. Inf. Syst..

[8]  Larry E. Rittenberg,et al.  Audit and Control of End-User Computing , 1990 .

[9]  Martin D. Goslar,et al.  Decision support systems: an empirical assessment for decision making , 1986 .

[10]  Brent J. Bowman.  An investigation of application development process controls in an end user setting: a field study , 1988 .

[11]  Donald L. Amoroso,et al.  Testing a Causal Model of End-User Application Effectiveness , 1991, J. Manag. Inf. Syst..

[12]  Tanya McGill,et al.  Spreadsheet knowledge: An exploratory study , 2001 .

[13]  Mark John Taylor,et al.  End‐user computing and information systems methodologies , 1998, Inf. Syst. J..

[14]  Peter B. Seddon.  A Respecification and Extension of the DeLone and McLean Model of IS Success , 1997, Inf. Syst. Res..

[15]  Robert P. Bostrom,et al.  Training End Users: An Experimental Investigation of the Roles of the Computer Interface and Training Methods , 1993, MIS Q..

[16]  Tanya McGill,et al.  User satisfaction as a measure of success in end user application development: An empirical investigation , 1998 .

[17]  Paul H. Cheney,et al.  System effectiveness of knowledge-based technology: the relationship of user performance and attitudinal measures , 1994, 1994 Proceedings of the Twenty-Seventh Hawaii International Conference on System Sciences.

[18]  Isaac O. Agboola.  An experimental study of the effects of application domain knowledge and data modeling knowledge on the quality of database implementations by non-experts , 1999 .

[19]  Albert H. Segars,et al.  Re-examining perceived ease of use and usefulness , 1993 .

[20]  Tanya McGill,et al.  An investigation of end user development success , 2002 .

[21]  John F. Rockart,et al.  The management of end user computing , 1983, CACM.

[22]  Ephraim R. McLean,et al.  Information Systems Success: The Quest for the Dependent Variable , 1992, Inf. Syst. Res..

[23]  Maarten Gelderman,et al.  The relation between user satisfaction, usage of information systems and performance , 1998, Inf. Manag..

[24]  Timothy Paul Cronan,et al.  End-user Training and Computing Effectiveness in Public Agencies: An Empirical Study , 1990, J. Manag. Inf. Syst..

[25]  Tanya J. McGill,et al.  User-Developed Applications: Can End Users Assess Quality? , 2002, J. Organ. End User Comput..

[26]  Paul H. Cheney,et al.  A tool for measuring and analyzing end user computing abilities , 1988, Inf. Process. Manag..

[27]  Louis Raymond,et al.  Development of a measure to assess the quality of user-developed applications , 1997, DATB.

[28]  Suzanne Rivard,et al.  An empirical study of users as application developers , 1985, Inf. Manag..

[29]  Veda C. Storey,et al.  The use of spreadsheets in organizations: Determinants and consequences , 1996, Inf. Manag..

[30]  Jo Ellen Moore,et al.  The Focus of Research in End User Computing: Where Have We Come Since the 1980s? , 2002, J. Organ. End User Comput..

[31]  D. R. Lawrence,et al.  A Study of End User Computing and the Provision of Tool Support to Advance End User Empowerment , 1996 .

[32]  James C. Anderson,et al.  STRUCTURAL EQUATION MODELING IN PRACTICE: A REVIEW AND RECOMMENDED TWO-STEP APPROACH , 1988 .

[33]  Barbara D. Klein,et al.  User evaluations of IS as surrogates for objective performance , 2000, Inf. Manag..

[34]  Dana Edberg,et al.  User-Developed Applications: An Empirical Study of Application Quality and Developer Productivity , 1996, J. Manag. Inf. Syst..

[35]  Jane E. Klobas,et al.  User Developed Applications and Information Systems Success: A Test of DeLone and McLean's Model , 2003, Inf. Resour. Manag. J..

[36]  Linda Salchenberger.  Structured development techniques for user-developed systems , 1993, Inf. Manag..

[37]  Raymond R. Panko,et al.  Spreadsheets on trial: a survey of research on spreadsheet risks , 1996, Proceedings of HICSS-29: 29th Hawaii International Conference on System Sciences.

[38]  Donald L. Amoroso,et al.  Quality end user-developed applications: some essential ingredients , 1992, DATB.

[39]  Wynne W. Chin,et al.  On the use, usefulness, and ease of use of structural equation modeling in MIS research: a note of caution , 1995 .

[40]  Timothy Paul Cronan,et al.  Applications development by end-users: can quality be improved? , 2000, Decis. Support Syst..

[41]  Brian Knight,et al.  Quality control in spreadsheets: a software engineering-based approach to spreadsheet development , 2000, Proceedings of the 33rd Annual Hawaii International Conference on System Sciences.

[42]  B. Elango,et al.  The Effect of Attitudes, Goal Setting and Self-Efficacy on End User Performance , 2001, J. Organ. End User Comput..

[43]  Paul E. Tesluk,et al.  A Comparison of Approaches to Forming Composite Measures in Structural Equation Models , 2000 .

[44]  Prashant Palvia,et al.  On end-user computing productivity: Results of controlled experiments , 1991, Inf. Manag..

[45]  Gayle J. Yaverbaum,et al.  Effects of information system education and training on user satisfaction: An empirical evaluation , 1992, Inf. Manag..

[46]  J. Hair.  Multivariate data analysis , 1972 .

[47]  Maria Jean Johnstone Hall.  A risk and control-oriented study of the practices of spreadsheet application developers , 1996, Proceedings of HICSS-29: 29th Hawaii International Conference on System Sciences.

[48]  Leon A. Kappelman,et al.  Converging end-user and corporate computing , 1993, CACM.

[49]  Magid Igbaria,et al.  Exploring the measurement of end user computing success , 1999 .

[50]  Amy W. Gatian.  Is user satisfaction a valid measure of system effectiveness? , 1994, Inf. Manag..

[51]  Izak Benbasat,et al.  An experimental program investigating color-enhanced and graphical information presentation: an integration of the findings , 1986, CACM.

[52]  Peter B. Seddon,et al.  A Partial Test and Development of Delone and Mclean's Model of IS Success , 1996, Australas. J. Inf. Syst..