Uso de la planilla de cálculo para la comprensión del movimiento diario del Sol a partir de observaciones del cielo realizadas durante la no presencialidad

Abstract

This work presents a proposal to reconstruct the daily solar movement from observations made by students from their own homes in times of non-presential classes. The measurement of the direction and length of the shadow of a vertical stake at four different times of the day was proposed to each student, and a spreadsheet was programmed to represent these measurements on a polar graph. The data obtained were analyzed and the solar displacement was represented. The proposal, the methodology and the results obtained in its implementation with a group of high school students are detailed. Conclusions are presented on the use of this resource for modeling the same phenomenon when it is measured by different observers. The sequence made it possible to relate students to the solar movement as it is perceived in their own celestial environment, in addition to favoring the development of scientific skills related to measurement, graphic representation, data analysis and modeling.