Identify and understand the difficulties of the students in class by analysing their activity in the case of prescribed tasks with the spreadsheet



The objective of this study is to provide teachers with indicators to help them take into account the difficulties’ students face when performing tasks prescribed with a computer tool like the spreadsheet. Trying to identify these difficulties should allow teachers to better understand why students learn or not. We analysed the activity of 12 students from a professional course. The results of two representative students are presented in detail in this article as case studies. Finally, we propose to use these results for educational implications, results obtained from behaviours that could be identified in class by the teacher.


Analyse of the activity, strategy, behaviour, spreadsheet, learning

Full Text:



Amadieu, F., & Tricot, A. (2006). Utilisation d'un hypermédia et apprentissage: deux activités concurrentes ou complémentaires? Psychologie Française, 51, 5-23.

Anderson, J. R. (2000). Learning and Memory: an integrated approach. New York: Wiley.

Aoudé, P. (2012). Les futurs enseignants du primaire face aux TIC: questions de compétences et de formation. Le cas du tableur. PhD thesis, Université René Descartes-Paris V, France (

Babin, L. M., Tricot, A., & Mariné, C. (2009). Seeking and providing assistance while learning to use information systems. Computers & Education, 53(4), 1029-1039.

Baron, G. L., & Bruillard, E. (2001). Une didactique de l'informatique ? Revue Française de Pédagogie, 135, 163-172.

Bastien, C. (2002). L'adaptation des opérateurs aux nouveaux outils (Adventic - Apport Industriel de l'Automatique Avancée). Retrieved from

Bastien, C., & Bastien-Toniazzo, M. (2004). Apprendre à l'école. Paris: Armand Colin.

Baviskar, S. N., Hartle, R. T., & Whitney, T. (2009). Essential criteria to characterize constructivist teaching: derived from a review of the literature and applied to five constructivist-teaching method articles. International Journal of Science Education, 31(4), 541-550.

Berry, R. Q., & Ritz, J. M. (2004). Technology education: a resource for teaching mathematics. Technology Teacher, 63(8), 5-20.

Blondel, F. M., & Tort F. (2007). Comment évaluer les compétences des lycéens en matière de tableur ? In T. Nodenot, J. Wallet & E. Fernandes (Eds), Actes de la conférence EIAH 2007 (pp. 77-82). Lyon: INRP & Paris: ATIEF.

Blondel, F. M., Bruillard, E., & Tort, F. (2008). Overview and main results of the DidaTab project. In D. Ward (Ed.), Pursuit of Spreadsheet Excellence, Proceedings of European Spreadsheet Risks Interest Group, 2008 Annual Conference (pp. 187-198). London: EuSpRIG.

Carroll, J. M., & Rosson, M. B. (1987). Paradox of the active user. In J. M. Carroll (Ed.), Interfacing thought: cognitive aspects of human computer interaction (pp. 80-11). Cambridge, MA: MIT Press.

Chadwick, D., & Sue, R. (2001). Teaching spreadsheet development using peer audit and self-audit methods for reducing errors. In Controlling the Subversive Spreadsheet – Risks, Audit and Development Methods, Proceedings of EuSpRIG 2001 Conference. London: EuSpRIG.

Chanquoy, L., Tricot, A., & Sweller, J. (2007). La charge cognitive. Théories et applications. Paris: Armand Colin.

Clément, E. (2003). L’analyse de l’activité dans la résolution de problème. Psychologie et Psychométrie, 24(4), 25-36.

Clément, E. (2005). Compréhension et résolution de problème: que nous apprennent les difficultés de l’apprenant. Rééducation Orthophonique, 25, 239-250.

Cooper, G., Tindall-Ford, S., Chanderler, P., & Sweller, J. (2001). Learning by imaging. Journal of Experimental Psychology: Applied, (7)1, 68-82.

Handler, M.-G. (1993). Preparating new teachers to use technology: perceptions and suggestions for teachers educators. Computers & Education, 29(2), 147-156.

Haspekian, M. (2006). Intégration d’outils informatiques dans l’enseignement des mathématiques: étude du cas des tableurs. Phd thesis, Université Paris-Diderot – Paris VIII, France (

Hérold, J.-F. (2014). A cognitive analysis of students’ activity: an example in mathematics. Australian Journal of Teacher Education, 39(1), 137-158.

Hérold, J.-F., & Ginestié, J. (2011). Help with solving technological problems in project activities. International Journal of Technology and Design Education, 21, 55-70.

Huang, S.-H., & Liu, M. (2003). Education students' perceptions computers: a cross-cultural study. Journal of Educational Computing Research, 29(4), 451-469.

Lavidas, K., Komis, V., & Gialamas, V. (2013). Spreadsheet 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.

Le Bohec, O. L., & Jamet, E. (2005). Les effets de redondance dans l'apprentissage à partir de documents multimédia. Le Travail Humain, 68(2), 97-124.

Mayer, R. E. (2001). Multimedia learning. Cambridge: Cambridge University Press.

Mayer, R. E. (2008). Learning and Instruction. Upper Saddle River NJ: Prentice Hall.

Mayer, R. E., & Moreno, R. (2002). Aids to computer-based multimedia-learning. Learning and Instruction, 12, 107-119.

Mc Inerney, V., Mc Inerney, D. M., & Sinclair, K. E. (1994). Student teachers, computer anxiety and computer experience. Journal of Educational Computing Research, 11(1), 27-50.

Merrill, M. D. (2002). First principles of instruction. Educational Technology Research and Development, 50(3), 43-59.

Mioduser, D., & Kiperman, D. (2002). Evaluations/modifications cycles in junior high students. International Journal of Technology and Design Education, 8(2), 167-184.

Petrina, S., Feng, F., & Kim, J. (2008). Researching cognition and technology: how we learn across the lifespan. International Journal of Technology and Design Education, 18, 375-396.

Przasnyski, Z., Leon, L., & Seal, K. C. (2011). In search of taxonomy for classifying qualitative spreadsheet errors. In Proceedings of EuSpRIG 2011 Conference “Spreadsheet Governance – Policy and Practice”. London: EuSpRIG.

Richard, J.-F. (2005). Les activités mentales. Comprendre, raisonner, trouver des solutions. Paris: Armand Colin.

Richard, J.-F., Poitrenaud, S., & Tijus, C. (1993). Problem-Solving restructuration: elimination of implicit constraints. Cognitive Science, 17, 497-529.

Schneider, M., & Stern, E. (2010). The cognitive perspective on learning: ten cornerstone findings. In OECD (Ed.), The nature of learning: using research to inspire practice (pp. 69-90). Paris: OECD.

Sweller, J., van Merriënboer, J., & Paas, F. (1998). Cognitive architecture and instructional design. Educational Psychology Review, 10(3), 251-296.

Sweller, J., & van Merriënboer, J. (2005). Cognitive load theory and complex learning: recent developments and future direction. Educational Psychology Review, 17(2), 147-177.

Tort, F., Blondel, F. M., & Bruillard, E. (2009). From error detection to behaviour observation: first results from screen capture analysis. In D. Ward & G. Croll (Eds), The role of spreadsheets in organizational excellence, Proceedings of the EuroSpRIG 2009 Annual Conference. (pp. 119-132). London: EuSpRIG.

van der Linden, D., Sonnentag, S., Frese, M., & van Dick, C. (2001). Exploration strategies, performance, and error consequences when learning a complex computer task. Behaviour & Information Technology, 20(3), 189-198.

van Gog, T., Paas, F., & van Merriënboer, J. (2006). Effects of process-oriented worked examples on troubleshooting transfer performance. Learning and Instruction, 16, 154-164.

Watson, J. (1995). Teacher talk and student thought. Educational Psychology, 15(1), 57-68.


View Counter: Abstract | 31 | times, and PDF | 14 | times

Re S M ICT E | ISSN: 1792-3999 (electronic), 1791-261X (print) | Laboratory of Didactics of Sciences, Mathematics and ICT, Department of Educational Sciences and Early Childhood Education - University of Patras.

Pasithee | Library & Information Center | University of Patras