Research in spreadsheet management proved that the overuse of slow thinking, rather than fast thinking, is the primary source of erroneous end-user computing. However, we found that the reality is not that simple. To view end-user computing in its full complexity, we launched a project to investigate end-user education, training, support, activities, and computer problem solving. In this project we also set up the base and mathability-extended typology of computer problem solving approaches, where quantitative values are assigned to the different problem solving methods and activities. In this paper we present the results of our analyses of teaching materials collected in different languages from all over the world and our findings considering the different problem solving approaches, set in the frame of different thinking modes, the characteristics of expert teachers, and the meaning system model of teaching approaches. Based on our research, we argue that the proportions of fast and slow thinking and most importantly their manifestation are responsible for erroneous end-user activities. Applying the five-point mathability scale of computer problem solving, we recognized slow thinking activities on both tails and one fast thinking approach between them. The low mathability slow thinking activities, where surface navigation and language details are focused on, are widely accepted in end-user computing. The high mathability slow thinking problem solving activities, where the utilization of concept based approaches and schema construction take place, is hardly detectable in end-user activities. Instead of building up knowledge which requires slow thinking and then using the tools with fast thinking, end-users use up their slow thinking in aimless wandering in huge programs, making wrong decisions based on their untrained, clueless intuition, and distributing erroneous end-user documents. We also found that the dominance of low mathability slow thinking activities has its roots in the education system and through this we point out that we are in great need of expert teachers and institutions and their widely accepted approaches and methods.
KeywordsComputer Problem SolvingEnd-User ComputingTeaching MaterialsMathabilityMeaning System ModelExpert Teachers
Panko, R. (2013) The Cognitive Science of Spreadsheet Errors: Why Thinking Is Bad. Proceedings of the 46th Hawaii International Conference on System Sciences, 7-10 January 2013, Maui, 4013-4022. https://doi.org/10.1109/hicss.2013.513
Ben-Ari, M. and Yeshno, T. (2006) Conceptual Models of Software Artifacts. Interacting with Computers, 18, 1336-1350. https://doi.org/10.1016/j.intcom.2006.03.005
Csernoch, M. (2009) Teaching Word Processing—The Theory Behind. Teaching Mathematics and Computer Science, 7, 119-137. https://doi.org/10.5485/TMCS.2009.0212
Csernoch, M. (2010) Teaching Word Processing—The Practice. Teaching Mathematics and Computer Science, 8, 247-262. https://doi.org/10.5485/TMCS.2010.0252
Ben-Ari, M. (1999) Bricolage Forever! PPIG 1999. 11th Annual Workshop, 5-7 January 1999, Computer-Based Learning Unit, University of Leeds, Leeds, UK. http://www.ppig.org/papers/11th-benari.pdf
Kadijevich, D. (2013) Learning about Spreadsheet. In: Kadijevich, D., Angeli, C. and Schulte, C., Eds., Improving Computer Science Education, Routledge, New York, 19-33.
Van Deursen, A. and Van Dijk, J. (2012) Ctrl Alt Delete. Lost Productivity Due to IT Problems and Inadequate Computer Skills in the Workplace. Universiteit Twente, Enschede.
Panko, R. (2015) What We Don’t Know about Spreadsheet Errors Today: The Facts, Why We Don’t Believe Them, and What We Need to Do. arXiv:1602.02601 [cs]. http://arxiv.org/abs/1602.02601
Panko, R. and Port, D. (2013) End User Computing: The Dark Matter (and Dark Energy) of Corporate It. Journal of Organizational and End User Computing, 25, 1-19. https://doi.org/10.4018/joeuc.2013070101
Csernoch, M. and Biró, P. (2016) Teaching Methods Are Erroneous: Approaches Which Lead to Erroneous End-User Computing. EuSpRIG2016. London. http://www.eusprig.org/mcsernoch-2016.pdf
Wing, J.M. (2006) Computational Thinking. Communications of the ACM, 49, 33-35. https://doi.org/10.1145/1118178.1118215
Hattie, J. (2003) Teachers Make a Difference: What Is the Research Evidence? Distinguishing Expert Teachers from Novice and Experienced Teachers. Australian Council for Educational Research (ACER) Annual Conference on: Building Teacher Quality. https://www.det.nsw.edu.au/proflearn/docs/pdf/qt_hattie.pdf
Hattie, J. (2012) Visible Learning for Teachers: Maximizing Impact on Learning. Routledge, New York and London.
Csernoch, M. and Biró, P. (2015) Computer Problem Solving. In Hungarian: Számítógépes problémamegoldás, TMT, Tudományos és Muszaki Tájékoztatás, 62, 86-94.
Case, J.M. and Gunstone, R.F. (2002) Metacognitive Development as a Shift in Approach to Learning: An In-Depth Study. Studies in Higher Education, 27, 459-470. https://doi.org/10.1080/0307507022000011561
Booth, S. (1992) Learning to Program: A Phenomenographic Perspective. Goteborg Studies in Educational Sciences 89. Acta Univesitatis Gothoburgenis, Gothenburg.
Polya, G. (1957) How to Solve It. A New Aspect of Mathematical Method. 2nd Edition, Princeton University Press, Princeton.
Baranyi, P., Csapo, A. and Varlaki, P. (2014) An Overview of Research Trends in CogInfoCom. IEEE 18th International Conference on Intelligent Engineering Systems INES 2014, 181-186. https://doi.org/10.1109/INES.2014.6909365
Baranyi, P. and Csapó, A. (2012) Definition and Synergies of Cognitive Infocommunications. Acta Polytechnica Hungarica, 9, 67-83.
Baranyi, P. and Gilanyi, A. (2013) Mathability: Emulating and Enhancing Human Mathematical Capabilities. 2013 IEEE 4th International Conference on Cognitive Infocommunications (CogInfoCom), 555-558.
Borus, Gy. and Gilanyi, A. (2013) Solving Systems of Linear Functional Equations with Computer. 2013 IEEE 4th International Conference on Cognitive Infocommunications (CogInfoCom), 559-562. https://doi.org/10.1109/coginfocom.2013.6719310
Biró, P. and Csernoch, M. (2015) The Mathability of Computer Problem Solving Approaches. 2015 6th IEEE International Conference on Cognitive Infocommunications (CogInfoCom), 111-114.
Biró, P. and Csernoch, M. (2015) The Mathability of Spreadsheet Tools. 2015 6th IEEE International Conference on Cognitive Infocommunications (CogInfoCom), 105-110. https://doi.org/10.1109/coginfocom.2015.7390573
Kahneman, D. (2011) Thinking, Fast and Slow. Farrar, Straus; Giroux, New York.
Skemp, R. (1971) The Psychology of Learning Mathematics. Lawrence Erlbaum Associatives, New Jersey.
Merrienboer, J.J.G. van and Sweller, J. (2005) Cognitive Load Theory and Complex Learning: Recent Developments and Future Directions. Educational Psychology Review, 17, 147-177. https://doi.org/10.1007/s10648-005-3951-0
Kruger, J. and Dunning, D. (1999) Unskilled and Unaware of It: How Difficulties in Recognizing One’s Own Incompetence Lead to Inflated Self-Assessments. Journal of Personality and Social Psychology, 77, 1121-34. https://doi.org/10.1037/0022-3514.77.6.1121
Hromkovic, J. (2009) Algorithmic Adventures. Springer Berlin Heidelberg. Berlin, Heidelberg. http://link.springer.com/10.1007/978-3-540-85986-4 https://doi.org/10.1007/978-3-540-85986-4
Mireault, P. (2016) Characteristics of Spreadsheets Developed with the SSMI Methodology. EuSpRIG2016. http://www.eusprig.org/pmireault-2016.pdf
Reynolds, G. (2011) Presentation Zen: Simple ideas on Presentation Design and Delivery. New Riders, Berkeley.
Message, R. (2013) Programming for Humans: A New Paradigm for Domain-Specific Languages. Technical Report. University of Cambridge. Computer Laboratory. https://www.cl.cam.ac.uk/techreports/UCAM-CL-TR-843.pdf
Stockli, T. (2011) Lebenslernen: Ein zukunftsfahiges Paradigma des Lernens als Antwort auf die Bedürfnisse heutiger Jugendlicher. Von der Fakultat I—Geisteswissenschaften (Institut für Kunstwissenschaft und Historische Urbanistik) der Technischen Universitat Berlin zur Erlangung des akademischen Grades Dr. phil. genehmigte Dissertation. https://depositonce.tu-berlin.de/bitstream/11303/3165/1/Dokument_43.pdf
Gove, M. (2012) Michael Gove speech at the BETT Show 2012. Published 13 January 2012. Digital Literacy Campaign. http://www.theguardian.com/education/2012/jan/11/digital-literacy-michael-gove-speech
Bell, T. and Newton, H. (2013) Unplugging Computer Science. In: Kadijevich, D.M., Angeli, C. and Schulte, C., Eds., Improving Computer Science Education, Routledge, New York and London, 66-81.
Soloway E. (1993) Should We Teach Students to Program? Communications of the ACM, 36, 21-24. https://doi.org/10.1145/163430.164061
Mayer, R.E. (1981) The Psychology of How Novices Learn Computer Programming. ACM Computing Surveys, 13, 121-141. https://doi.org/10.1145/356835.356841
Kirschner, P.A., Sweller, J. and Clark, R.E. (2006) Why Minimal Guidance During Instruction Does Not Work: An Analysis of the Failure of Constructivist Discovery, Problem-Based, Experiential, and Inquiry-Based Teaching. Educational Psychologist, 41, 75-86. https://doi.org/10.1207/s15326985ep4102_1
Wakeling, D. (2007) Spreadsheet Functional Programming. Journal of Functional Programming, 17, 131-143. https://doi.org/10.1017/S0956796806006186
Sestoft, P. (2011) Spreadsheet Technology. Version 0.12 of 2012-01-31. IT University Technical Report ITU-TR-2011-142. IT University of Copenhagen, December 2011.
Ben-Ari, M. (2011) Non-Myths about Programming. Communications of the ACM, 54, 35. https://doi.org/10.1145/1965724.1965738
Chen, J.A., Morris, D.B. and Mansour, N. (2015) Science Teachers’ Beliefs. Perceptions of Efficacy and the Nature of Scientific Knowledge and Knowing. In: Fives, H. and Gill, M.G., Eds., International Handbook of Research on Teachers’ Beliefs. Routledge, New York and London, 370-386.
Spreadsheet Competency Framework (2016) A Structure for Classifying Spreadsheet Ability in Finance Professionals. ICAEW. http://www.icaew.com/-/media/corporate/files/technical/information-technology/it-faculty/spreadsheet-competency-framework.ashx
Freiermuth, K., Hromkovic, J. and Steffen, B. (2008) Creating and Testing Textbooks for Secondary Schools. Proceedings of the 3rd International Conference on Informatics in Secondary Schools—Evolution and Perspectives: Informatics Education—Supporting Computational Thinking, Springer-Verlag, Berlin, Heidelberg, 216-228.
Florida Gulf Coast University 2013. Excel 2013 Tutorial. http://www.fgcu.edu/Support/excel2013.html
Dancsó, T. and Korom, P. (2013) Informatics for Grades 9-10. In Hungarian: Informatika 9-10. A gimnáziumok számára. Nemzedékek Tudása Tankonyvkiadó (Oktatáskutató és Fejleszto Intézet), Budapest.
Cours Excel: Formules de calculs et fonctions. http://www.excel-pratique.com/fr/cours/excel_formules_calculs_fonctions.php
Gross, D., Akaiwa, F. and Nordquist, K. (2014) Succeeding in Business with Microsoft Excel 2013: A Problem-Solving Approach. Cengage Learning, Delhi.
Csernoch, M. (2014) Programming with Spreadsheet Functions: Sprego. In Hungarian, Programozás táblázatkezelo függvényekkel—Sprego. Muszaki Konyvkiadó, Budapest.
Csernoch, M. and Biró, P. (2015) Sprego Programming. Spreadsheets in Education (eJSiE), 8, Article 4. http://epublications.bond.edu.au/ejsie/vol8/iss1/4
Csernoch, M. and Biró, P. (2015) Sprego Programming. LAP Lambert Academic Publishing, Saarbrücken.
Guidelines and Examples of Array Formulas (2010). https://support.office.com/en-us/article/Guidelines-and-examples-of-array-formulas-7D94A64E-3FF3-4686-9372-ECFD5CAA57C7
Walkenbach, J. (2003) Excel2003 Formulas. John Wiley & Sons, Foster City.
Walkenbach, J. (2010) Excel 2010 Bible. Wiley Pub., Indianapolis, Indiana, United States. https://ebooks-it.org/0470474874-ebook.htm
Csernoch, M., Biró, P., Máth, J. and Abari, K. (2015) Testing Algorithmic Skills in Traditional and Non-Traditional Programming Environments. Informatics in Education, 14, 175-197. https://doi.org/10.15388/infedu.2015.11
Hubwieser, P. (2004) Functional Modelling in Secondary Schools Using Spreadsheets. Education and Information Technologies, 9, 175-183. https://doi.org/10.1023/B:EAIT.0000027929.91773.ab
Tort, F., Blondel, F.M. and Bruillard, é. (2008) Spreadsheet Knowledge and Skills of French Secondary School Students. In Mittermeir, R.T. and Syslo, M.M., Eds., Informatics Education—Supporting Computational Thinking, Springer, Berlin and Heidelberg, 305-316. http://link.springer.com/chapter/10.1007/978-3-540-69924-8_28 https://doi.org/10.1007/978-3-540-69924-8_28
Csernoch, M. (1997) Methodological Questions of Teaching Word Processing. 3rd International Conference on Applied Informatics, Eger-Noszvaj, 375-382.
Kadijevich, D. (2009) Simple Spreadsheet Modeling by First-Year Business Undergraduate Students: Difficulties in the Transition from Real World Problem Statement to Mathematical Model. In: Blomhrj, M. and Carreira, S., Eds., Mathematical Applications and Modeling in the Teaching and Learning of Mathematics: Proceedings the 11th International Congress on Mathematical Education, Monterrey, Mexico, 241-248.
Angeli, C. (2013) Teaching Spreadsheets: A TPCK Perspective. In: Kadijevich, D.M., Angeli, C. and Schulte, C., Eds., Improving Computer Science Education. Routledge, New York and London, 132-146.