Role of gender, self-efficacy, anxiety and testing formats in learning spreadsheets

In this paper we investigate the role of spreadsheet self-efficacy, spreadsheet anxiety, and gender in explaining performance in using spreadsheets. Additionally, we compare two learning assessment formats: multiple choice tests and constructed response tests, as applied to spreadsheets. The empirical investigation using data from 217 students indicates the following: (1) spreadsheet self-efficacy was inversely related to spreadsheet anxiety. (2) Female students reported higher levels of spreadsheet anxiety. (3) There was significant difference between the variances of multiple choice test scores and constructed response test scores and (4) Female students performed better than male students in multiple choice test format and were at par with male students in constructed response test format.

[1]  Gabriele Piccoli,et al.  Computer Self-Efficacy and Motivation to Learn in a Self-Directed Online Course , 2009 .

[2]  R. Heinssen,et al.  Assessing computer anxiety: Development and validation of the Computer Anxiety Rating Scale , 1987 .

[3]  W. Michael Reed,et al.  Effects of Learning Styles, Programming, and Gender on Computer Anxiety , 1995 .

[4]  Scott B. MacKenzie,et al.  Common method biases in behavioral research: a critical review of the literature and recommended remedies. , 2003, The Journal of applied psychology.

[5]  Sue Newell,et al.  The issue of gender within computing: reflections from the UK and Scandinavia , 2001, Inf. Syst. J..

[6]  Magid Igbaria,et al.  A Path Analytic Study of Individual Characteristics, Computer Anxiety and Attitudes toward Microcomputers , 1989 .

[7]  Richard D. Johnson,et al.  The Multilevel and Multifaceted Character of Computer Self-Efficacy: Toward Clarification of the Construct and an Integrative Framework for Research , 1998, Inf. Syst. Res..

[8]  M. Kinzie,et al.  Computer technologies: Attitudes and self-efficacy across undergraduate disciplines , 1994 .

[9]  Carol Saunders,et al.  PLS: A Silver Bullet? , 2006 .

[10]  Raymond R. Panko,et al.  What we know about spreadsheet errors , 1998 .

[11]  Rex Karsten,et al.  Computer Self-Efficacy: A Meta-Analysis , 2012, J. Organ. End User Comput..

[12]  Sylvia Beyer,et al.  Gender Differences and Intra-Gender Differences amongst Management Information Systems Students , 2008, J. Inf. Syst. Educ..

[13]  Poornima Madhavan,et al.  Effects of computer self-efficacy and system reliability on user interaction with decision support systems , 2010, Comput. Hum. Behav..

[14]  Joseph J. Martocchio,et al.  Microcomputer playfulness: development of a measure with workplace implications , 1992 .

[15]  Robert Anson,et al.  An Assessment of Cooperative Learning used for Basic Computer Skills Instruction in the College Classroom , 1995 .

[16]  Magid Igbaria,et al.  The respective roles of perceived usefulness and perceived fun in the acceptance of microcomputer technology , 1994, Behav. Inf. Technol..

[17]  Asli Yagmur Akbulut,et al.  Inspiring students to pursue computing degrees , 2007, CACM.

[18]  Mark G. Simkin,et al.  Why Is Performance on Multiple‐Choice Tests and Constructed‐Response Tests Not More Closely Related? Theory and an Empirical Test* , 2010 .

[19]  Chelley Vician,et al.  Learning by Doing: A Remote Communication Project , 1998, J. Inf. Syst. Educ..

[20]  Anne Beaudry,et al.  Antecedents of computer self-efficacy: A study of the role of personality traits and gender , 2011, Comput. Hum. Behav..

[21]  Lee A. Freeman,et al.  Are Men More Technology-Oriented Than Women? The Role of Gender on the Development of General Computer Self-Efficacy of College Students , 2010, AMCIS.

[22]  P. Okebukola,et al.  The gender factor in computer anxiety and interest among some Australian high school students , 1993 .

[23]  Deborah Compeau,et al.  Computer Self-Efficacy: Development of a Measure and Initial Test , 1995, MIS Q..

[24]  F. Wilson.  Can Compute, Won't Compute: Women's Participation in the Culture of Computing , 2003 .

[25]  Vallabh Sambamurthy,et al.  Sources of Influence on Beliefs about Information Technolgoy Use: An Empirical Study of Knowledge Workers , 2003, MIS Q..

[26]  Mark J. Brosnan,et al.  The impact of computer anxiety and self-efficacy upon performance , 1998, J. Comput. Assist. Learn..

[27]  Mark Brosnan,et al.  The Impact of Psychological Gender, Gender-Related Perceptions, Significant Others, and the Introducer of Technology upon Computer Anxiety in Students , 1998 .

[28]  Ulla K. Bunz.  A Generational Comparison of Gender, Computer Anxiety, and Computer-Email-Web Fluency , 2009 .

[29]  J. D. Pemberton,et al.  Spreadsheets in business , 2000 .

[30]  Mark G. Simkin,et al.  Multiple-Choice Tests and Student Understanding: What Is the Connection? , 2005 .

[31]  Souren Paul,et al.  The Use of Problem‐Based Learning to Enhance MIS Education , 2008 .

[32]  Peter E. Kennedy,et al.  Are Multiple-Choice Exams Easier for Economics Students? A Comparison of Multiple-Choice and “Equivalent” Constructed-Response Exam Questions , 2002 .

[33]  John D. Gould,et al.  An experimental study of people creating spreadsheets , 1987, TOIS.

[34]  W. Becker,et al.  The Relationship between Multiple Choice and Essay Response Questions in Assessing Economics Understanding , 1999 .

[35]  MaryEllen C. Sievert,et al.  Investigating computer anxiety in an academic library , 1988 .

[36]  A. Bandura,et al.  Differential engagement of self-reactive influences in cognitive motivation , 1986, Organizational Behavior and Human Decision Processes.

[37]  Regina Vollmeyer,et al.  Computer use and the gender gap: The issue of access, use, motivation, and performance , 2007, Comput. Hum. Behav..

[38]  John E Baker,et al.  Spreadsheets in Education-The First 25 Years , 2007 .

[39]  M MarakasGeorge,et al.  The Multilevel and Multifaceted Character of Computer Self-Efficacy , 1998 .

[40]  Jeng-Yi Tzeng,et al.  The impact of general and specific performance and self-efficacy on learning with computer-based concept mapping , 2009, Comput. Hum. Behav..

[41]  J. Cooper,et al.  The digital divide: the special case of gender , 2006, J. Comput. Assist. Learn..

[42]  A. Bandura.  Social Foundations of Thought and Action: A Social Cognitive Theory , 1985 .

[43]  Kevin Tierney,et al.  The relation of gender and background experience to self-reported computing anxieties and cognitions , 2001, Comput. Hum. Behav..

[44]  Stephen G. Powell,et al.  Impact of errors in operational spreadsheets , 2009, Decis. Support Syst..

[45]  Mark G. Simkin,et al.  Why Use Multiple-Choice Questions on Accounting Certification Examinations? , 2011 .

[46]  Jenine Beekhuyzen,et al.  Women Working in the IT Industry: Challenges for the New Millennium , 2011 .

[47]  E. Hargittai,et al.  Differences in Actual and Perceived Online Skills: The Role of Gender* , 2006 .

[48]  Jane Webster,et al.  Are we talking about the task or the computer? An examination of the associated domains of task-specific and computer self-efficacies , 2011, Comput. Hum. Behav..

[49]  Jason Bennett Thatcher,et al.  An Empirical Examination of Individual Traits as Antecedents to Computer Anxiety and Computer Self-Efficacy , 2002, MIS Q..

[50]  Geoffry S. Howard,et al.  Computer Anxiety and Computer Attitudes: An Investigation of Construct and Predictive Validity Issues , 1990 .