*Detecting errors during the construction of mathematical formulas in a spreadsheet environment: An empirical study involving novice users*

**DOI:**422 Downloads 6671 Views

**Author(s)**

**Abstract**

In this study we examine the familiarization of students with the basic functions for formula insertion in a general purpose spreadsheet software. Two teaching interventions and two respective follow-up tests were conducted to 124 students of Educational Sciences, with little prior experience in the use of spreadsheets. Through the data collected (test results, registration forms for the students to record any difficulties they had during the tests, video captures of the interactions of the students with the software during the tests) the errors the students made and also any attempts to correct these errors were identified. Our findings indicated that the software error messages and the unexpected results were the main events that prompted the students to recognize their errors.

**Keywords**

Enter formula; error detection and correction; feedback; learning process; Spreadsheets; mathematical formulas

**Cite this paper**

Konstantinos Lavidas, Vasilis Komis, Iro Voulgari,
Detecting errors during the construction of mathematical formulas in a spreadsheet environment: An empirical study involving novice users
, *SCIREA Journal of Education*.
Volume 2, Issue 1, February 2017 | PP. 1-17.

**References**

[ 1 ] | Agyei, D. D., & Voogt, J. M. (2014). Pre-service mathematics teachers’ learning and teaching of activity-based lessons supported with spreadsheets. Technology, Pedagogy and Education, (ahead-of-print), 1-21. |

[ 2 ] | Aurigemma, S., & Panko, R. (2014). Evaluating the Effectiveness of Static Analysis Programs Versus Manual Inspection in the Detection of Natural Spreadsheet Errors. Journal of Organizational and End User Computing (JOEUC), 26(1), 47-65. |

[ 3 ] | Carlson, D., (2003). The Teaching and Learning of Tertiary Algebra, The Future of the Teaching and Learning of Algebra The 12 th ICMI Study, New ICMI Study Series, 2004, Volume 8, 293-309. |

[ 4 ] | Chorana, A., Lakhdari, A., Cherroun, H., & Oulad-Naoui, S. (2015). XML-based e-assessment system for Office skills in open learning environments. Research and Practice in Technology Enhanced Learning, 10(1), 1-17. |

[ 5 ] | Eizenberg, Μ., & Zaslavsky, Ο. (2002). Undergraduate students verification strategies of solutions to combinatorial problems. In A. Cock burn & E. Nardi (Eds.) Proceedings of the26th Conference of the International Group for the Psychology of Mathematics Education (II, pp. 321-328). Norwich, UK: School of Education and Professional Development. |

[ 6 ] | Epstein, M. L., Lazarus, A. D., Calvano, T. B., Matthews, K. A., Hendel, R. A., Epstein, B. B., & Brosvic, G. M. (2010). Immediate feedback assessment technique promotes learning and corrects inaccurate first responses. The Psychological Record, 52(2), 5. |

[ 7 ] | Fessakis G., Dimitracopoulou A., Komis V. (2005). «Improving database design teaching in secondary education: Action research implementation for documentation of didactic requirements and strategies», Computers in Human Behavior Volume 21, Issue 2, Pages 159-194 |

[ 8 ] | Friedlander. Α., & Tabach. Μ. (2001). Developing a curriculum of beginning algebra in a spreadsheet environment. In H. Chick. K. Stacey. J. Vincent, & J. Vincent (Eds.), The future of the teaching and learning of algebra (Proceedings of the 12th ICMI Study Conference, pp. 252-257). Melbourne, Australia: The University of Melbourne. |

[ 9 ] | Galletta, D., Hartzel, K., Johnson, S., Joseph, J., Rustagi, S. (1997). Spreadsheet presentation and error detection: an experimental study, Journal of Management Information Systems, 13 (3), 45–63. |

[ 10 ] | Hodnigg, K. (2005). A Pragmatic Approach to Spreadsheet Training Based Upon the “Projection–Screen” Model. In R. Mittermeir (Ed.), From Computer Literacy to Informatics Fundamentals SE - 15 (Vol. 3422, pp. 116–129). Springer Berlin Heidelberg. |

[ 11 ] | Jonassen, D. (2000). Toward a design theory of problem solving. Educational Technology: Research & Development, 48 (4), 63-85. |

[ 12 ] | Karasavvidis, I., Pieters, J.M. & Plomp, T. (2003). Exploring the mechanisms through which computers contribute to learning. Journal of Computer Assisted Learning, 19(1), 115-128. |

[ 13 ] | Komis, V. Lavidas, K. Papageorgiou, V. Zacharos, K. Politis, P. (2005). L’enseignement des tableurs dans le collège grec : étude des cas et implications pour une approche interdisciplinaire. In Colloque DIDAPRO2, Progiciels, apprentissages scolaires et pratiques professionnelles, Deuxièmes journées francophones de didactique des progiciels , Neuchâtel, Suisse , 29-30 Septembre 2005, pp. 253-260. |

[ 14 ] | Lavidas, K., Komis, V., & Gialamas, V. (2013). Spreadsheets as cognitive tools: A study of the impact of spreadsheets on problem solving of math story problems. Education and Information Technologies, 18(1), 113–129. |

[ 15 ] | Lavidas, K., Komis, V., Zacharos, K., Papageorgiou, V. (2007). Etude de la contribution des tableurs dans le processus de résolution des problèmes en mathématiques. Scholé, vol. Hors Série 1, no., pp. 53-65. |

[ 16 ] | Lehman, Μ. & Herring, C. (2003). Creating interactive spreadsheets to provide immediate feedback. Journal of Journal of Accountancy. Ed. 21, 327–337. |

[ 17 ] | Lim, K. F. (2004). A Survey of First-Year University Students' Ability to Use Spreadsheets. Spreadsheets in Education. 1(2), 52-66. |

[ 18 ] | Mayes, J. & Fowler, C. (1999). Learning technology and usability: a framework for understanding courseware. Interacting with Computers. 11, 485–497. |

[ 19 ] | Nardi, B. A., & Miller, J. R. (1990). An ethnographic study of distributed problem solving in spreadsheet development. Proceedings of CSCW' 90, ACM conference on Computer supported cooperative work, 1990, 197-208. ACM Press. |

[ 20 ] | Nobre, S., Amado, N., & Carreira, S. (2012). Solving a contextual problem with the spreadsheet as an environment for algebraic thinking development. Teaching Mathematics and Its Applications , 31(1 ), 11–19. |

[ 21 ] | Norman, D. (1988). The Psychology of Everyday Things. New York, NY: Basic Books. |

[ 22 ] | Palaigeorgiou, G., Siozos, P. & Konstantakis, N. (2006). CEAF: A Measure for Deconstructing Students’ Prior Computer Experience. Journal of Information Systems Education, 17(4), 459-468. |

[ 23 ] | Panko, R. & Halverson, R. (1997). Are Two Heads Better than One? (At Reducing Errors in Spreadsheet Modeling?). Office Systems Research Journal. 15, 21-32. |

[ 24 ] | Panko, R. R. (2008). What We Know About Spreadsheet Errors. Journal of End User Computing’s, 10, 15–21. doi:Article |

[ 25 ] | Panko, R. R., & Aurigemma, S. (2010). Revising the Panko-Halverson taxonomy of spreadsheet errors. Decision Support Systems, 49, 235–244. |

[ 26 ] | Reinhardt, T. & Pillay, N. (2004). Analysis of Spreadsheet Errors Made by Computer Literacy Students, in Proceedings of the IEEE International Conference on Advanced Learning Technologies, ICALT 2004, 30 August - 1 September 2004, Joensuu, Finland, IEEE Press. |

[ 27 ] | Schwarz, B., & Dreyfus, T. (1993). Measuring integration of information in multirepresentational software. Interactive Learning Environments, 3(3), 177-198. |

[ 28 ] | Shim, J. Ε., & Li, Υ (2006). Applications of Cognitive Tools in the Classroom. In M. Orey (Ed.), Emerging perspectives on learning, teaching, and technology. Retrieved 13 May 2011, from http://projects.coe. uga.edu/epltt/). |

[ 29 ] | Teo, T. & Lee-Partridge, J. (2001). Effects of Error Factors and Prior Incremental Practice on Spreadsheet Error Detection: An Experimental Study. Omega 29, 445-456. |

[ 30 ] | Tort, E, Blondel, F.-M., & Bruillard, E. (2008). Spreadsheet Knowledge and Skills of French Secondary School Students. In R. T. Mittermeir & Μ. Μ. Syslo (Eds.), ISSEP 2008, LNCS 5090 (pp. 305-316). |

[ 31 ] | Walkenbach, J. (2004). Excel programming with VBA, Wiley Publishing, Inc Indianapolis, Indiana. |

[ 32 ] | Wing, J. M. (2006). Computational thinking. Communications of the ACM, 49(3), 33-35. |

[ 33 ] | Yerushalmy, Μ. (1991). Effects of computerized feedback on performing and debugging algebraic transformations. Journal of Educational Computing Research, 7. 309-330. |