Abstract
The aim of our research project called DidaTab – Didactics of Spreadsheets – is to get a more comprehensive picture of ICT uses in French schools and to obtain a better knowledge of students’ spreadsheet competencies. The exploratory study of curricula and practices shows very sparse use during secondary education. To achieve a more precise estimation of what students can do with spreadsheets, we identified detailed competencies and designed computer performance tasks to serve as a basis for tests. The analysis of the results of a few groups indicates that in most cases students’ knowledge and skills are rather low. A deeper investigation of students’ work shows close links between lack of confidence with spreadsheets and lack of knowledge in mathematics and informatics.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Blondel, F.-M., Bruillard, E.: Analysis of the uses of spreadsheets at home and in schools by French students. In: ECER 2006 (European Conference on Educational Research), Transforming Knowledge, Geneva (September 2006)
Bruillard, E., Blondel, F.-M., Tort, F.: DidaTab project main results: implications for education and teacher development. In: McFerrin, K., Weber, R., Carlsen, R., Willis, D.A. (eds.) Proceedings of Society for Information Technology and Teacher Education International Conference, SITE 2008, pp. 2014–2021. AACE, Chesapeake, USA (2008) ISBN: 1-880094-64-9
Croll, G.: The Importance and Criticality of Spreadsheets in the City of London. In: EuSpRIG conference (2005)
Demunter, C.: How skilled are Europeans in using computers and the Internet, Eurostat, European Communities, 17/2006 (2006)
Eurydice, Key Data on Information and Communication Technology in Schools in 2004 (2004), http://www.eurydice.org/ressources/eurydice/pdf/048EN/004_chapB_048EN.pdf
Haspekian, M., Bruillard, E.: What role does mathematics play in students’ spreadsheet competencies? A case study of French students skills in a vocational school. In: Proceedings of Informatics, Mathematics and ICT, IMICT 2007, College of Computer and Information Science Northeastern University, Boston, USA (2007) ISBN 13: 978-0-615-14623-2
Kvavik, R.B., Caruso, J.B.: ECAR Study of Students and Information Technology, 2005: Convenience Connection, Control and Learning, vol. 6 (2005)
Lenon, M., Kirsh, I., Von Davier, M., Wagner, M., Yamamoto, K.: Feasibility Study for the PISA ICT Literacy Assessment. In: ACER 2003 (2003)
Lim, K.: A Survey of First-Year University Students’ Ability to use Spreadsheets. In: Spreadsheets in Education, 1, 2, pp. 71–85 (2004)
Panko, R.: Spreadsheet Errors: What We Know. What We Think We Can Do. In: Proceedings of the Spreadsheet Risk Symposium; European Spreadsheet Risks Interest Group (EuSpRIG), Greenwich, England, July 17-18 (2000), http://panko.shidler.hawaii.edu/SSR/Mypapers/EUSPRIG_2000.htm
Pemberton, J.D., Robson, A.J.: Spreadsheets in Business. Industrial Management & Data Systems 100, 379–388 (2000)
Snyder, L., Aho, A.V., Linn, M.C., Packer, A., Tucker, A., Ullman, J., Van Dam, A.: Be FIT! Being fluent with information technology. National Academy Press, Washington, DC (1999)
Tort, F., Blondel, F.-M.: Uses of spreadsheets and assessment of competencies of high school students. In: Benzie, D., Iding, M. (eds.) Proceedings of Informatics, Mathematics and ICT, IMICT 2007, College of Computer and Information Science Northeastern University, Boston, USA (2007) ISBN 13: 978-0-615-14623-2
Vandeput, E., Colinet, M.: Utiliser le tableur en toute autonomie. In: Pochon, L.-O., Bruillard, E., Maréchal, A. (eds.) Apprendre (avec) les progiciels: Entre apprentissages scolaires et pratiques professionnelles, pp. 73–98. Neuchâtel: IRDP & Lyon: INRP (2006)
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 2008 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Tort, F., Blondel, FM., Bruillard, É. (2008). Spreadsheet Knowledge and Skills of French Secondary School Students. In: Mittermeir, R.T., Sysło, M.M. (eds) Informatics Education - Supporting Computational Thinking. ISSEP 2008. Lecture Notes in Computer Science, vol 5090. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-69924-8_28
Download citation
DOI: https://doi.org/10.1007/978-3-540-69924-8_28
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-69923-1
Online ISBN: 978-3-540-69924-8
eBook Packages: Computer ScienceComputer Science (R0)