Simulasi Lintasan Partikel Bermuatan dalam Pengaruh Medan Listrik dan Medan Magnet Menggunakan Spreadsheet Excel

  • Sarman Sarman SMAN 1 Kusambi


Abstract: This study aims to describe to students the physics phenomenon of the motion of charged particles in an electric and magnetic field and to simulate the trajectory of particles on a computer using an interactive spreadsheet. The spreadsheet is used to solve the analytical solution of the system of particle motion in the electromagnetic field. The results show that the graph plot of the numerical solution is immediately visible as a simulation of the trajectory of particles in an electromagnetic field. The simulation results show that the course of charged particles in an electromagnetic field depends on the strength of the electric field, magnetic field, particle mass, particle charge, initial velocity, and the angle between the electric field and magnetic field. Simulations developed using spreadsheets can be a powerful pedagogical tool in the study of physics. In conclusion, simulations using excel, as discussed above, appear to help students better understand the mathematical principles underlying physical phenomena and better appreciate the power of mathematics applied to the real world. The simulations generated in this study show that even without using macros, we can create sophisticated simulations.


Keywords: Electromagnetic Field, Simulation, Spreadsheets


Arons, A. B. (1987). Research on Teaching and Learning: What Should Teachers Know and When Should Know It? Presentation made in the panel research on Physics Education, Inter-American Conference on Physics Education, Oaxtepec, 20-24.

Azam, M., Kusbramanto, T., & Suseno, J. E. (2007). Simulasi Gerak Partikel Bermuatan dalam Pengaruh Medan Listrik dan Induksi Magnet Menggunakan Matlab Versi 7.1. Berkala Fisika, 10(1), 99-103.

Bittencourt, J. A. (2004). Fundamentals of Plasma Physics Third Edition. National Institute for Space Research (INPE) Av. dos Astronautas, 1758- Caixa Postal 515 12245-970 Săo Jose dos Carnpos, SP Brazil.

Cooke, B. (1997). Some Ideas for Using Spreadsheets in Physics. Physics Education, 32(2), 80-87.

Fauzi, A. (2007). Analisis Gerak Harmonik Teredam (Damped Harmonic Oscilation) dengan Spreadsheet Excel. Orbith, 7(2), 318-322

Grigore, I. (2014). Excel Spreadsheet – Didactic Interactive Tools in The Exploration of Certain Properties of the Electromagnetic Field. The 10th International Scientific Conference Elearning and Software for Education. 10.12753/2066-026X-14-087

Halliday, D., & Resnick R. (1990). Fisika. Jilid 2. Edisi ke-3 (terjemahan). Jakarta: Erlangga

Huffman, D., Goldberg, F., Michlin, M. (2003). Using Computers to Create Constructivist Learning Environ- Ments: Impact on Pedagogy and Achievement. Journal of Computers in Mathematics and Science Teaching, 22(2), 151–168.

Jimoyiannis, A., & Komis, V. (2001). Computer Simulations in Physics Teaching and Learning: A Case Study on Students Understanding of Trajectory Motion. Computers & Education, 36(2), 183–204.

Kettunen, L. (2000). Electromagnetism and Academic Training of Electrical Engineers. Compel International Journal of Computations and Mathematics in Electrical, 19(4) 1045-1052.

Lim, C. S. (2006). In Search of Good Practice and Innovation in Mathematics Teaching and Learning: A Malaysian Perspective. dalam Masami Isoda, et al (edt.). Tsukuba Journal of Educational Study in Mathematics, 25, 205-214

McDermott, L. (2001). Oersted Medal Lecture 2001: Physics Education Research – The Key to Student Learning. American Journal of Physics, 69(11), 1127 – 1137.

Pfefferová, M. S. (2015). Computer Simulations and Their Influence on Students Understanding of Oscillatory Motion. Informatics in Education, 14(2), 279–289.

Salvat, F., Fernández-Varea, J.M., & Sempau, J. 2003). PENELOPE, A Code System for Monte Carlo Simulation of Electron and Photon Transport. Facultat de Física (ECM), Universitat de Barcelona: Barcelona.

Takwale, R. & Puranik, P. (1997). Introduction to Classical Mechanics. New Delhi: Tata McGraw-Hill Publishing Company Limited

Tambade, P. (2012). Spreadsheet Implementation for Momentum Representation of Gaussian Wave Packet and Uncertainty Principle. European Journal of Physics Education, 3(1), 9-16.

Taras, V. S., & Valentina, V. Z. (2009). Particle Acceleration in a Reconnecting Current Sheet: PIC Simulation. Cambridge University Press

Wagner, J. (2007). Using Spreadsheets to Assess Learning. The Physics Teach., 45(1), 34-37.

Yamani, A., & Kharab A., (2001). Use of Spreadsheet Program in Electromagnetism. IEEE Transactions on Education, 44(3), 292-297.
How to Cite
Sarman, S. (2022). Simulasi Lintasan Partikel Bermuatan dalam Pengaruh Medan Listrik dan Medan Magnet Menggunakan Spreadsheet Excel. SPEJ (Science and Physic Education Journal), 5(2), 61-70.
Abstract viewed = 0 times
pdf downloaded = 0 times