Design of numerical simulation in spreadsheet for high school student
The use of numerical methods as a science teaching strategy is employed mainly at universities, because of the calculus and programation notions needed. In this work it’s proposed to secondary teachers the design of activities employing numerical simulations using the graphical interface of spreadsh...
Guardado en:
| Autores principales: | , |
|---|---|
| Formato: | Artículo revista |
| Lenguaje: | Español |
| Publicado: |
Asociación de Profesores de Física de la Argentina
2017
|
| Materias: | |
| Acceso en línea: | https://revistas.unc.edu.ar/index.php/revistaEF/article/view/17149 |
| Aporte de: |
| id |
I10-R316-article-17149 |
|---|---|
| record_format |
ojs |
| spelling |
I10-R316-article-171492023-09-12T16:59:20Z Design of numerical simulation in spreadsheet for high school student Diseño de simulaciones numéricas en hoja de cálculo para estudiantes de preparatoria Mardones Muñoz, Pablo Castillo Riveros, Fernanda Euler method Education Spreadsheets Método de Euler Educación Hojas de cálculo The use of numerical methods as a science teaching strategy is employed mainly at universities, because of the calculus and programation notions needed. In this work it’s proposed to secondary teachers the design of activities employing numerical simulations using the graphical interface of spreadsheets to work analysis and evaluation skills on student. The Euler method in conjunction with the second Newton law will be used to study uniformly accelerated motion, damped harmonic oscillator, various cases of projectiles considering friction and central forces, heat transfer on a wire and finally laminar viscous flux. Euler method calculus error will be addressed, how to face them so that the used models become more accurate than what is predicted by theory. El uso de métodos numéricos como estrategia de enseñanza de las ciencias es empleado principalmente en las universidades, debido a las nociones de cálculo y programación que se necesitan. En este trabajo se propone a los profesores de preparatoria diseñar actividades empleando simulaciones numéricas, al aprovechar la interfaz gráfica de las hojas de cálculo, para trabajar habilidades de análisis y evaluación en los estudiantes. Se utilizará el método de Euler en conjunto con la segunda ley de Newton para estudiar el movimiento rectilíneo uniformemente acelerado, el oscilador armónico amortiguado, distintos casos de proyectiles considerando fricción y fuerzas centrales, transferencia de calor en un alambre y finalmente flujo laminar viscoso. Se tratarán los errores de cálculo asociados al uso del método de Euler y cómo enfrentarlos para que los modelos usados sean más acertados a la teoría. Asociación de Profesores de Física de la Argentina 2017-06-13 info:eu-repo/semantics/article info:eu-repo/semantics/publishedVersion application/pdf https://revistas.unc.edu.ar/index.php/revistaEF/article/view/17149 Journal of Physics Teaching; Vol. 29 No. 1 (2017): January - June; 51-70 Revista de Enseñanza de la Física; Vol. 29 Núm. 1 (2017): Enero - Junio; 51-70 Revista de Enseñanza de la Física; v. 29 n. 1 (2017): Janeiro - Junho; 51-70 2250-6101 0326-7091 spa https://revistas.unc.edu.ar/index.php/revistaEF/article/view/17149/16752 Derechos de autor 2017 Pablo Mardones Muñoz, Fernanda Castillo Riveros |
| 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 |
Euler method Education Spreadsheets Método de Euler Educación Hojas de cálculo |
| spellingShingle |
Euler method Education Spreadsheets Método de Euler Educación Hojas de cálculo Mardones Muñoz, Pablo Castillo Riveros, Fernanda Design of numerical simulation in spreadsheet for high school student |
| topic_facet |
Euler method Education Spreadsheets Método de Euler Educación Hojas de cálculo |
| author |
Mardones Muñoz, Pablo Castillo Riveros, Fernanda |
| author_facet |
Mardones Muñoz, Pablo Castillo Riveros, Fernanda |
| author_sort |
Mardones Muñoz, Pablo |
| title |
Design of numerical simulation in spreadsheet for high school student |
| title_short |
Design of numerical simulation in spreadsheet for high school student |
| title_full |
Design of numerical simulation in spreadsheet for high school student |
| title_fullStr |
Design of numerical simulation in spreadsheet for high school student |
| title_full_unstemmed |
Design of numerical simulation in spreadsheet for high school student |
| title_sort |
design of numerical simulation in spreadsheet for high school student |
| description |
The use of numerical methods as a science teaching strategy is employed mainly at universities, because of the calculus and programation notions needed. In this work it’s proposed to secondary teachers the design of activities employing numerical simulations using the graphical interface of spreadsheets to work analysis and evaluation skills on student. The Euler method in conjunction with the second Newton law will be used to study uniformly accelerated motion, damped harmonic oscillator, various cases of projectiles considering friction and central forces, heat transfer on a wire and finally laminar viscous flux. Euler method calculus error will be addressed, how to face them so that the used models become more accurate than what is predicted by theory. |
| publisher |
Asociación de Profesores de Física de la Argentina |
| publishDate |
2017 |
| url |
https://revistas.unc.edu.ar/index.php/revistaEF/article/view/17149 |
| work_keys_str_mv |
AT mardonesmunozpablo designofnumericalsimulationinspreadsheetforhighschoolstudent AT castilloriverosfernanda designofnumericalsimulationinspreadsheetforhighschoolstudent AT mardonesmunozpablo disenodesimulacionesnumericasenhojadecalculoparaestudiantesdepreparatoria AT castilloriverosfernanda disenodesimulacionesnumericasenhojadecalculoparaestudiantesdepreparatoria |
| first_indexed |
2024-09-03T20:38:47Z |
| last_indexed |
2024-09-03T20:38:47Z |
| _version_ |
1809208759852990464 |