Physics Simulation with Excel Spreadsheet
Main Article Content
Abstract
This study present several examples of using Excel spreadsheets to study and simulate physical phenomena, namely projectile motion, falling motion in The air, The wave function of particles in a one-dimensional box, and nuclear radioactive decay. Spreadsheets are used to analyze the motion of projectiles with and without resistance, falling objects with different terminal velocities, graphs of wave functions and probabilities with different values of n, i.e. n=1 to n=4, and nuclear decay with different probability values of P. The use of excel spreadsheets has proven to be very useful in the physics learning process, namely the rapid response to changes in data and graphs, according to the values given.
Article Details
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
References
Baker, J., & Sugden, J. S. (2007). Spreadsheets in Education –The First 25 Years. Spreadsheets in Education (eJSiE), 1(1), 18-43.
González, M. I. (2018). Lens ray diagrams with a Spreadsheet. Phys. Educ., 53, 1-6.
Griffiths, D. J., & Schroeter, D. F. (2017). Introduction to Quantum Mechanics (Third Edition ed.). Cambridge University Press.
Grigore, I., & Barna, E. S. (2015). Using Excel Spreadsheets to Study The Vertical Motion in A Gravitational Field. Procedia - Social and Behavioral Sciences (hal. 2769 - 2775). Elsevier.
Halliday, D., Resnick, R., & Walker, J. (2010). Fisika Dasar Edisi 7. Erlangga.
Katoch, S. K. (2020). MS-Excel Spreadsheet Applications in Introductory Under-Graduate Physics-A Review. Journal of Science and Technology, 5(3), 48-52.
Oliveira, M., & Napoles, S. (2010). Using a Spreadsheet to Study the Oscillatory Movement of a Mass-Spring System. Spreadsheets in Education (eJSiE), 3(3).
Singh, I., Kaur, B., & Khun, K. K. (2019). Simulating longitudinal vibration of coupled oscillator using 4th order Runge-Kutta method by programming spreadsheet. European Journal of Physics.
Squire, K., Barnett, M., Grant, J. M., & Higginbotham, T. (2004). Electromagnetism Supercharged! Learning Physics with Digital Simulation Games Curriculum & Instruction, School of Education. ICLS '04: Proceedings of the 6th international conference on Learning sciences (hal. 513–520). ACM Digital Library.
Toback, D., Mershin, A., & Novikova, I. (2004). New Pedagogy for Using Internet-Based Teaching Tools in Physics Course. Department of Physics (Texas A& M University, USA).
Uddin, Z., Ahsanuddin, M., & Khan, D. A. (2017). Teaching physics using Microsoft Excel. Phys. Educ, 52.
Warner, C. B., & Judge, G. (2001). Microsoft Excel(TM) as a tool for teaching basic statistics. Teach. Psychol.