Teaching free-falling motion with LibreOffice Calc
DOI:
https://doi.org/10.31349/RevMexFisE.22.010204Keywords:
LibreOffice Calc, Free-falling motion, Teaching Physics, Simulation, Goal Seek functionAbstract
The aim of this work is to demonstrate how to use LibreOffice Calc, a freeware spreadsheet, to teach physics of free-falling motion. Although free-falling motion is experienced in our daily lives, students often misunderstand the calculations, mainly because of the use of signs for related physical parameters. For example, the velocity can be positive, negative, or even zero, depending on the direction of motion. To help students learn, we have used the embedded VLOOKUP function in LibreOffice to create a simulation of the object's trajectory. We have found that the software can be used to create snapshots of consecutive vertical motions of the object. The direction of the object's movement can be determined using the IF function. Moreover, the software can be used to solve equations that are often found in problems in this class. By using the Goal Seek function, the numerical value of the parameter of interest can be obtained.
References
R. Dory, Spreadsheets for physics, Computers in physics 2 (1988) 70. https://doi.org/10.1063/1.168300
E. Adhitama and A. Fauzi, A novel real-time data acquisition using an excel spreadsheet in pendulum experiment tool with light-based timer, Physics Education 53 (2018) 035002. https://dx.doi.org/10.1088/1361-6552/aaa355
M. I. González, Lens ray diagrams with a spreadsheet, Physics Education 53 (2018) 035016. https://dx.doi.org/10.1088/1361-6552/aaacb7
I. Grigore, C. Miron, and E. Barna, Didactic tools created with Excel spreadsheets to study motion on an inclined plane, Romanian Reports in Physics 68 (2016) 440
I. Grigore and E. S. Barna, Using Excel spreadsheets to study the vertical motion in a gravitational field, Procedia-Social and Behavioral Sciences 191 (2015) 2769. https://doi.org/10.1016/j.sbspro.2015.04.259
S. K. Katoch, MS-Excel Spreadsheet Applications in Introductory UnderGraduate Physics-A Review, Journal of Science and Technology 5 (2020) 48. https://doi.org/10.46243/jst.2020.v5.i3.pp48-52
B. Cooke, Some ideas for using spreadsheets in physics, Physics Education 32 (1997) 80. https://dx.doi.org/10.1088/0031-9120/32/2/013
I. Korsun, S. Kryzhanovskyi, and M. Monchuk, The study of thermometers using Microsoft Excel, Physics Education 54 (2019) 065004. https://dx.doi.org/10.1088/1361-6552/ab350c
A. Y. Purnama, et al., Particle trajectory simulation using python and spreadsheet as an online learning alternative, Rev. Mex. Fis. E 20 (2023) 020202. https://doi.org/10.31349/RevMexFisE.20.020202
H. Putranta et al., Visualization of body centered cubic energy bands based on spreadsheet-assisted tight binding: Solutions for distance material physics lectures, Trends in Sciences 19 (2022) 4590. https://doi.org/10.48048/tis.2022.4590
A. Razzak, et al., Root Finding Methods Through GUI in Spreadsheets: Root Finding Methods Through GUI in Spreadsheets, Proceedings of the Pakistan Academy of Sciences: A. Physical and Computational Sciences 59 (2022) 37. https://doi.org/10.53560/PPASA(59-1)644
R. G. Rinaldi and A. Fauzi, A complete damped harmonic oscillator using an Arduino and an Excel spreadsheet, Physics Education 55 (2019) 015024. https://dx.doi.org/10.1088/1361-6552/ab539d
I. Singh, K. K. Khun, and B. Kaur, Simulating Fraunhofer diffraction of waves using Microsoft excel spreadsheet, Physics Education 53 (2018) 055010. https://dx.doi.org/10.1088/1361-6552/aacd82
I. Singh and B. Kaur, Teaching graphical simulations of Fourier series expansion of some periodic waves using spreadsheets, Physics Education 53 (2018) 035031. https://dx.doi.org/10.1088/1361-6552/aab447
I. Singh, K. K. Khun, and B. Kaur, Visualizing the trajectory of a charged particle in electric and magnetic fields using an Excel spreadsheet, Physics Education 54 (2018) 015002. https://dx.doi.org/10.1088/1361-6552/aae3fd
I. Singh, B. Kaur, and K. K. Khun, Simulating longitudinal vibrations of coupled oscillator using the fourth-order rungekutta method by programming spreadsheet, European Journal of Physics 40 (2019) 045003. https://dx.doi.org/10.1088/1361-6404/ab1666
I. Singh et al., Simulating propagation of the resultant electric field vector using 3D vector representations for circular, elliptical and plane-polarised waves, Physics Education 56 (2020) 015012. https://dx.doi.org/10.1088/1361-6552/abc638
K. Sornbundit, Simulating Two-body Pursuit Problem using LibreOffice, Journal of Science and Science Education (JSSE) 6 (2023) 260, https://doi.org/10.14456/jsse.2023.23
P. S. Tambade, Trajectory of Charged Particle in Combined Electric and Magnetic Fields Using Interactive Spreadsheets., European Journal of Physics Education 2 (2011) 49
Z. Uddin, M. Ahsanuddin, and D. A. Khan, Teaching physics using microsoft excel, Physics Education 52 (2017) 053001. https://dx.doi.org/10.1088/1361-6552/aa7919
Z. Uddin and M. Hani Zaheer, Simulating Physics Experiments in Spreadsheets-Experimenting with Ohm’s Law, The Physics Teacher 57 (2019) 182. https://doi.org/10.1119/1.5092481
Z. Uddin et al., Teaching physics using Microsoft Excel-II, Physics Education 58 (2023) 055001. https://dx.doi.org/10.1088/1361-6552/acdbb1
R. A. Serway and J. W. Jewett, Physics for Scientists and Engineers with Modern Physics 9th, Cengage Learning (2013)
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2025 Kan Sornbundit
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.
Authors retain copyright and grant the Revista Mexicana de Física E right of first publication with the work simultaneously licensed under a CC BY-NC-ND 4.0 that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.
