The use of the spreadsheet for understanding the daily solar movement from observations of the sky made in non-presential classes

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 stud...

Descripción completa

Guardado en:
Detalles Bibliográficos
Autores principales: Galperin, Diego, Dionofrio, Josué, Raviolo, Andrés
Formato: Artículo revista
Lenguaje:Español
Publicado: Asociación de Profesores de Física de la Argentina 2021
Materias:
Acceso en línea:https://revistas.unc.edu.ar/index.php/revistaEF/article/view/35994
Aporte de:
id I10-R316-article-35994
record_format ojs
spelling I10-R316-article-359942023-09-12T16:46:43Z The use of the spreadsheet for understanding the daily solar movement from observations of the sky made in non-presential classes 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 Galperin, Diego Dionofrio, Josué Raviolo, Andrés Observation Daily solar movement Spreadsheet Polar graph Modeling Observación Movimiento diario del Sol Planilla de cálculo Gráfico polar Modelización 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.   Se presenta una propuesta para reconstruir el movimiento diario del Sol en el cielo local a partir de observaciones realizadas por los estudiantes desde sus propias casas en épocas de no presencialidad escolar. Cada estudiante debía medir la dirección y el largo de la sombra de una estaca vertical en cuatro distintos momentos del día y se programó una planilla de cálculo para representar dichas mediciones en un gráfico polar. Se analizaron los datos de todo el curso y se representó el desplazamiento solar. Se detalla la propuesta, la metodología y los resultados obtenidos en su implementación con un grupo de estudiantes de nivel secundario. Se elaboran conclusiones respecto al uso de este recurso para la modelización de un mismo fenómeno al ser medido por distintos observadores. La secuencia permitió vincular a los estudiantes con la observación del movimiento solar tal como es percibido en su propio entorno celeste, además de favorecer el desarrollo de competencias científicas relacionadas con los procesos de medición, representación gráfica, análisis de datos y modelización. Asociación de Profesores de Física de la Argentina 2021-12-12 info:eu-repo/semantics/article info:eu-repo/semantics/publishedVersion application/pdf text/html https://revistas.unc.edu.ar/index.php/revistaEF/article/view/35994 10.55767/2451.6007.v33.n3.35994 Journal of Physics Teaching; Vol. 33 No. 3 (2021): July - December; 89-100 Revista de Enseñanza de la Física; Vol. 33 Núm. 3 (2021): Julio - Diciembre; 89-100 Revista de Enseñanza de la Física; v. 33 n. 3 (2021): Julho - Dezembro; 89-100 2250-6101 0326-7091 spa https://revistas.unc.edu.ar/index.php/revistaEF/article/view/35994/36111 https://revistas.unc.edu.ar/index.php/revistaEF/article/view/35994/36112 Derechos de autor 2021 Diego Galperin, Josué Dionofrio, Andrés Raviolo http://creativecommons.org/licenses/by-nc-nd/4.0
institution Universidad Nacional de Córdoba
institution_str I-10
repository_str R-316
container_title_str Revista de Enseñanza de la Física
language Español
format Artículo revista
topic Observation
Daily solar movement
Spreadsheet
Polar graph
Modeling
Observación
Movimiento diario del Sol
Planilla de cálculo
Gráfico polar
Modelización
spellingShingle Observation
Daily solar movement
Spreadsheet
Polar graph
Modeling
Observación
Movimiento diario del Sol
Planilla de cálculo
Gráfico polar
Modelización
Galperin, Diego
Dionofrio, Josué
Raviolo, Andrés
The use of the spreadsheet for understanding the daily solar movement from observations of the sky made in non-presential classes
topic_facet Observation
Daily solar movement
Spreadsheet
Polar graph
Modeling
Observación
Movimiento diario del Sol
Planilla de cálculo
Gráfico polar
Modelización
author Galperin, Diego
Dionofrio, Josué
Raviolo, Andrés
author_facet Galperin, Diego
Dionofrio, Josué
Raviolo, Andrés
author_sort Galperin, Diego
title The use of the spreadsheet for understanding the daily solar movement from observations of the sky made in non-presential classes
title_short The use of the spreadsheet for understanding the daily solar movement from observations of the sky made in non-presential classes
title_full The use of the spreadsheet for understanding the daily solar movement from observations of the sky made in non-presential classes
title_fullStr The use of the spreadsheet for understanding the daily solar movement from observations of the sky made in non-presential classes
title_full_unstemmed The use of the spreadsheet for understanding the daily solar movement from observations of the sky made in non-presential classes
title_sort use of the spreadsheet for understanding the daily solar movement from observations of the sky made in non-presential classes
description 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.  
publisher Asociación de Profesores de Física de la Argentina
publishDate 2021
url https://revistas.unc.edu.ar/index.php/revistaEF/article/view/35994
work_keys_str_mv AT galperindiego theuseofthespreadsheetforunderstandingthedailysolarmovementfromobservationsoftheskymadeinnonpresentialclasses
AT dionofriojosue theuseofthespreadsheetforunderstandingthedailysolarmovementfromobservationsoftheskymadeinnonpresentialclasses
AT ravioloandres theuseofthespreadsheetforunderstandingthedailysolarmovementfromobservationsoftheskymadeinnonpresentialclasses
AT galperindiego usodelaplanilladecalculoparalacomprensiondelmovimientodiariodelsolapartirdeobservacionesdelcielorealizadasdurantelanopresencialidad
AT dionofriojosue usodelaplanilladecalculoparalacomprensiondelmovimientodiariodelsolapartirdeobservacionesdelcielorealizadasdurantelanopresencialidad
AT ravioloandres usodelaplanilladecalculoparalacomprensiondelmovimientodiariodelsolapartirdeobservacionesdelcielorealizadasdurantelanopresencialidad
AT galperindiego useofthespreadsheetforunderstandingthedailysolarmovementfromobservationsoftheskymadeinnonpresentialclasses
AT dionofriojosue useofthespreadsheetforunderstandingthedailysolarmovementfromobservationsoftheskymadeinnonpresentialclasses
AT ravioloandres useofthespreadsheetforunderstandingthedailysolarmovementfromobservationsoftheskymadeinnonpresentialclasses
first_indexed 2024-09-03T20:40:40Z
last_indexed 2024-09-03T20:40:40Z
_version_ 1809208878494121984