Simulating Two-body Pursuit Problem using LibreOffice
Article Sidebar
Main Article Content
Abstract
In this research, we propose the use of LibreOffice, which is a free spread sheet software, for simulating the two-body pursuit problem and use the GOAL SEEK function to estimate the time that one body takes to reach the other one. We found that LibreOffice can be used to simulate the motion of the system and estimate the approached time without using sophisticated programming skill. The software is suitable for self-learning of undergraduate students. Moreover, instructors can use the software to create different exercises by adjusting free parameters.
Article Details
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.
The Journal of Science and Science Education (JSSE) retain the right of all articles published in JSSE. The coresponding author or the authorized person on behalf of the authors must send the complete Copyright Transfer Form to JSSE before any article get published in JSSE.
Copyright Transfer Form
The JSSE request the coresponding author or the authorized person on behalf of the authors upload the manuscript under the together with the Copyright Transfer Form under the supplementary data. The guidline for uploading both manuscript and Copyright Transfer Form is shown below:
1. Upload the manuscript in the sub-menu, Article Component > Article Text.
2. Upload the the Copyright Transfer Form in the sub-menu, Article Component > Other.
Download Copyright Transfer Form
References
Cooke, B. (1997). Some ideas for using spreadsheets in physics. Physics Education, 32(2), 80.
Dory, R. (1988). Spreadsheets for physics. Computers in Physics, 2(3), 70-74.
González, M. I. (2018). Lens ray diagrams with a spreadsheet. Physics Education, 53(3), 035016.
Grigore, I., Miron, C. and Barna, E. (2016). Didactic tools created with Excel spreadsheets to study motion on an inclined plane. Romanian Reports in Physics, 68(1), 440-454.
Guerrero, H. and Guerrero, H. (2019). Solver, Scenarios, and Goal Seek Tools. Excel Data Analysis: Modeling and Simulation, 311-346.
Korsun, I., Kryzhanovskyi, S. and Monchuk, M. (2019). The study of thermometers using Microsoft Excel. Physics Education, 54(6), 065004.
Oliveira, M. C. and Nápoles, S. (2010). Using a spreadsheet to study the oscillatory movement of a mass-spring system. Spreadsheets in Education, 3(3), 1-23.
Pornsuriwong, S. and Sungthong, A. (2020). The results of learning activities using STEM education of motion in physics for grade-11 students (in Thai). Journal of Science and Science Education, 3(1), 30-40.
Robinson, G. and Jovanoski, Z. (2011). The use of Microsoft Excel to illustrate wave motion and Fraunhofer diffraction in first year physics courses. Spreadsheets in Education, 4(3), 1-21.
Singh, I. and Kaur, B. (2018). Teaching graphical simulations of Fourier series expansion of some periodic waves using spreadsheets. Physics Education, 53(3), 035031.
Singh, I., Khun, K. K. and Kaur, B. (2018a). Simulating Fraunhofer diffraction of waves using Microsoft Excel spreadsheet. Physics Education, 53(5), 055010.
Singh, I., Khun, K. K. and Kaur, B. (2018b). Visualizing the trajectory of a charged particle in electric and magnetic fields using an Excel spreadsheet. Physics Education, 54(1), 015002.
Uddin, Z., and Zaheer, H.M. (2019). Simulating Physics Experiments in Spreadsheets–Experimenting with Ohm’s Law. The Physics Teacher, 57(3), 182-183.