Identifying difficulties in graph analysis: a didactic activity using Google Sheets

Authors

  • Gabriel Colla de Amorim Universidade de São Paulo. Programa de Pós-Graduação Interunidades em Ensino de Ciências
  • André Machado Rodrigues Universidade de São Paulo. Instituto de Física

Keywords:

Google Sheets, Graph interpretation, Double Stimulation Method, Physics teaching

Abstract

For this work, a didactic activity was developed using the Google Sheets tool in Physics classes in 10th grade of high school at a private school in São Paulo. During the activity, a pair of students from each class was recorded, so that it was possible to see the webcam, the screen, and hear the audio of the conversations. The main goal of this work is to understand how students organize their reasoning and what mistakes they make in graph interpretation activities in Physics classes using Google Sheets. For this, we used Vygotsky's Double Stimulation Method looking for moments in which students presented difficulties and externalized their reasoning. The analysis of the videos revealed a frequent error that students make when analyzing graphs and allowed the understanding of how the pairs organized their reasoning to solve the problems presented in a sheet given in class.

References

Bowen, G. M., & Roth, W.-M. (2005). Data and graph interpretation practices among preservice science teachers. Journal of Research in Science Teaching, 42(10), 1063–1088. https://doi.org/10.1002/tea.20086

Brisola, A. C., e Romeiro, N. L. (2018). A competência crítica em informação como resistência: Uma análise sobre o uso da informação na atualidade. Revista Brasileira de Biblioteconomia e Documentação, 14(3), Artigo 3.

Curcio, F. R. (1989). Developing Graph Comprehension. Elementary and Middle School Activities. ERIC.

de Souza, R. B. B. e da Rocha Brando, F. (2022). Perspectiva Semiótica dos gráficos como promotores de argumentação no ensino de Ciências. Investigações em Ensino de Ciências, 27(3), Artigo 3. https://doi.org/10.22600/15188795.ienci2022v27n3p01

Leinhardt, G., Zaslavsky, O., & Stein, M. K. (1990). Functions, Graphs, and Graphing: Tasks, Learning, and Teaching. Review of Educational Research, 60(1), 1–64. https://doi.org/10.3102/00346543060001001

McDermott, L. C., Rosenquist, M. L., & Van Zee, E. H. (1987). Student difficulties in connecting graphs and physics: Examples from kinematics. American Journal of Physics, 55(6), 503-513.

Rogers, L. T. (1995). The computer as an aid for exploring graphs. School Science Review, 76, 31–39.

Turner, C. (2017). Fake news is appearing in children’s homework, teachers warn. The Telegraph. https://www.telegraph.co.uk/news/2017/04/12/fake-news-appearing-childrens-homework-teachers-warn1/

Vosoughi, S., Roy, D., & Aral, S. (2018). The spread of true and false news online. Science, 359(6380), Artigo 6380. https://doi.org/10.1126/science.aap9559

Vygotsky, L. S. (2001). A construção do pensamento e da linguagem.

Downloads

Published

2023-12-01

How to Cite

Identifying difficulties in graph analysis: a didactic activity using Google Sheets. (2023). Journal of Physics Teaching, 35, 15-22. https://revistas.psi.unc.edu.ar/index.php/revistaEF/article/view/43255