Keep Your Stats in the Cloud! Evaluating the Use of Google Sheets to Teach Quantitative Methods

References

• Agresti, A., Franklin, C. A., and Klingenberg, B. (2017), Statistics: The Art and Science of Learning from Data (4th ed.), New York: Pearson.
   Google Scholar
• Aiken, L. S., West, S. G., Sechrest, L., Reno, R. R., Roediger, H. L., Scarr, S., Kazdin, A. E., and Sherman, S. J. (1990), “Graduate Training in Statistics, Methodology, and Measurement in Psychology: A Survey of PhD Programs in North America,” American Psychologist, 45, 721–734. DOI: 10.1037/0003-066X.45.6.721.
   Web of Science ®Google Scholar
• American Statistical Association (2016), “Guidelines for Assessment and Instruction in Statistics Education (GAISE) College Report 2016.” Available at: https://www.dol.gov/asp/evaluation/resources/ASASTYLE_GUIDE.PDF
   Google Scholar
• Appelbaum, M., Cooper, H., Kline, R. B., Mayo-Wilson, E., Nezu, A. M., and Rao, S. M. (2018), “Journal Article Reporting Standards for Quantitative Research in Psychology: The APA Publications and Communications Board Task Force Report,” American Psychologist, 73, 3–25. DOI: 10.1037/amp0000191.
   PubMed Web of Science ®Google Scholar
• Baker, R. S. J. D., D’Mello, S. K., Rodrigo, M. T., and Graesser, A. C. (2010), “Better to be Frustrated than Bored: The Incidence, Persistence, and Impact of Learners’ Cognitive–Affective States During Interactions with Three Different Computer-Based Learning Environments,” International Journal of Human-Computer Studies, 68, 223–241. DOI: 10.1016/j.ijhcs.2009.12.003.
   Web of Science ®Google Scholar
• Bandura, A. (1986), Social Foundations of Thought and Action, Englewood Cliffs, NJ: Prentice-Hall.
   Google Scholar
• Bandura, A. (1997), Self-Efficacy: The Exercise of Control, San Francisco, CA: Freeman.
   Google Scholar
• Basturk, R. (2005), “The Effectiveness of Computer-Assisted Instruction in Teaching Introductory Statistics,” Educational Technology & Society, 8, 170–178.
   Web of Science ®Google Scholar
• Chemers, M. M., Hu, L. T., and Garcia, B. F. (2001), “Academic Self-Efficacy and First Year College Student Performance and Adjustment,” Journal of Educational Psychology, 93, 55–64. DOI: 10.1037//0022-0663.93.1.55.
   Web of Science ®Google Scholar
• Cummings, G. (2011), Understanding the “New” Statistics, New York: Routledge.
   Google Scholar
• Davis, P. (1997), “What Computer Skills do Employers Expect from Recent Graduates?” THE Journal, 24, 74–78.
   Google Scholar
• Dunn, D. S. (2000), “Letter Exchanges on Statistics and Research Methods: Writing, Responding, and Learning,” Teaching of Psychology, 27, 128–130. DOI: 10.1207/s15328023top2301_8.
   Web of Science ®Google Scholar
• Garfield, J. (2002), “The Challenge of Developing Statistical Reasoning,” Journal of Statistics Education, 10, 1–12. DOI: 10.1080/10691898.2002.11910676.
   Google Scholar
• Gold, M. S., and Bentler, P. M. (2000), “Treatments of Missing Data: A Monte Carlo Comparison of RBHDI, Iterative Stochastic Regression Imputation, and Expectation-Maximization,” Structural Equation Modeling: A Multidisciplinary Journal, 7, 319–355. DOI: 10.1207/S15328007SEM0703_1.
   Web of Science ®Google Scholar
• Gravetter, F. J., and Wallnau, L. B. (2017), Essentials of Statistics for the Behavioral Sciences (10th ed.), Belmont, CA: Wadsworth Cengage Learning.
   Google Scholar
• Harlow, L. L., Burkholder, G., and Morrow, J. (2002), “Evaluating Attitudes, Skill and Performance in a Learning Enhanced Quantitative Methods Course: A Structural Modeling Approach,” Structural Equation Modeling: A Multidisciplinary Journal, 9, 413–430. DOI: 10.1207/S15328007SEM0903_6.
   Web of Science ®Google Scholar
• Harlow, L. L. (2013), “Teaching Quantitative Psychology,” in Oxford Handbook of Quantitative Methods, ed. T. Little, Cary, NC: Oxford University Press, pp. 105–117.
   Google Scholar
• Harlow, L. L., Korendijk, E., Hamaker, E. L., Hox, J., and Duerr, S. R. (2013), “A Meta-View of Multivariate Statistical Inference Methods in European Psychology Journals,” Multivariate Behavioral Research, 48, 749–774. DOI: 10.1080/00273171.2013.822784.
   PubMed Web of Science ®Google Scholar
• Harlow, L. L. (2014), The Essence of Multivariate Thinking: Basic Themes and Methods (2nd ed.), New York: Routledge.
   Google Scholar
• Harlow, L. L., Mulaik, S. and Steiger, J. (Eds.) (2016), What If There Were No Significance Tests? (Classic ed.), New York: Routledge.
   Google Scholar
• Hu, L., and Bentler, P. M. (1999), “Cutoff Criteria for Fit Indexes in Covariance Structure Analysis: Conventional Criteria Versus New Alternatives,” Structural Equation Modeling: A Multidisciplinary Journal, 6, 1–55. DOI: 10.1080/10705519909540118.
   Web of Science ®Google Scholar
• Kavanagh, M. H., and Drennan, L. (2008), “What Skills and Attributes Does an Accounting Graduate Need? Evidence from Student Perceptions and Employer Expectations,” Accounting & Finance, 48, 279–300. DOI: 10.1111/j.1467-629X.2007.00245.x.
   Web of Science ®Google Scholar
• Lukowski, S. L., DiTrapani, J., Jeon, M., Wang, Z., Schenker, V. J., Doran, M. M., Hart, S. A., Mazzocco, M. M., Willcutt, E. G., Thompson, L. A., and Petrill, S. A. (2016), “Multidimensionality in the measurement of math-specific anxiety and its relationship with mathematical performance,” Learning and Individual Differences, 70, 228–235. DOI: 10.1016/j.lindif.2016.07.007.
   PubMed Web of Science ®Google Scholar
• McKnight, K., O’Malley, K., Ruzic, R., Horsley, M. K., Franey, J. J., and Bassett, K. (2016), “Teaching in a Digital Age: How Educators Use Technology to Improve Student Learning,” Journal of Research on Technology in Education, 48, 194–211. DOI: 10.1080/15391523.2016.1175856.
   Web of Science ®Google Scholar
• Moore, D. S., McCabe, G. P., and Craig, B. A. (2016), Introduction to the Practice of Statistics (2nd ed.), New York: W.H. Freeman.
   Google Scholar
• Newsom, J. T. (2015), Longitudinal Structural Equation Modeling: A Comprehensive Introduction, New York: Routledge.
   Google Scholar
• Pajares, F. (1996), “Self-Efficacy Beliefs in Academic Settings,” Review of Educational Research, 66, 543–578. DOI: 10.3102/00346543066004543.
   Web of Science ®Google Scholar
• Prvan, T., Reid, A., and Petocz, P. (2002), “Statistical Laboratories using Minitab, SPSS and Excel: A Practical Comparison,” Teaching Statistics, 24, 68–75. DOI: 10.1111/1467-9639.00089.
   Google Scholar
• Onwuegbuzie, A. J., and Wilson, V. A. (2003), “Statistics Anxiety: Nature, Etiology, Antecedents, Effects, and Treatments – A Comprehensive Review of the Literature,” Teaching in Higher Education, 8, 195–209. DOI: 10.1080/1356251032000052447.
   Google Scholar
• Rackliffe, U. R., and Ragland, L. (2016), “Excel in the Accounting Curriculum: Perceptions from Accounting Professors,” Accounting Education, 25, 139–166. DOI: 10.1080/09639284.2015.1126791.
   Web of Science ®Google Scholar
• Ramirez, C., Schau, C., and Emmioglu, E. (2012), “The Importance of Attitudes in Statistics Education,” Statistics Education Research Journal, 11, 57–71.
   Google Scholar
• Rodgers, J. L. (2010), “The Epistemology of Mathematical and Statistical Modeling: A Quiet Methodological Revolution,” American Psychologist, 65, 1–12. DOI: 10.1037/a0018326.
   PubMed Web of Science ®Google Scholar
• Schneider, K. N., Becker, L. L., and Berg, G. G. (2017), “Beyond the Mechanics of Spreadsheets: Using Design Instruction to Address Spreadsheet Errors,” Accounting Education, 26, 127–143. DOI: 10.1080/09639284.2016.1274912.
   Web of Science ®Google Scholar
• Sosa, G. W., Berger, D. E., Saw, A. T., and Mary, J. C. (2011), “Effectiveness of Computer-Assisted Instruction in Statistics: A Meta-Analysis,” Review of Educational Research, 81, 97–128. DOI: 10.3102/0034654310378174.
   Web of Science ®Google Scholar
• Springer, L., Stanne, M. E., and Donovan, S. S. (1999), “Effects of Small-Group Learning on Undergraduates in Science, Mathematics, Engineering, and Technology: A Meta-Analysis,” Review of Educational Research, 69, 21–51. DOI: 10.3102/00346543069001021.
   Web of Science ®Google Scholar
• Steiger, J. H., and Lind, J. C. (1980), “Statistically Based Tests for the Number of Factors,” Paper Presented at the Annual Spring Meeting of the Psychometric Society, May, Iowa City, IA.
   Google Scholar
• Warner, C. B., and Meehan, A. M. (2001), “Microsoft ExcelTM as a Tool for Teaching Basic Statistics,” Teaching of Psychology, 28, 295–298. DOI: 10.1207/S15328023TOP2804_11.
   Web of Science ®Google Scholar
• Zieffler, A., Garfield, J., Alt, S., Dupuis, D., Holleque, K., and Chang, B. (2008), “What Does Research Suggest About the Teaching and Learning of Introductory Statistics at the College Level? A Review of the Literature,” Journal of Statistics Education, 16, 1–25. DOI: 10.1080/10691898.2008.11889566.
   PubMedGoogle Scholar