Proceedings of The 3rd International Conference on Mathematics and Science Education (ICMSE-2024)

Application of Excel VBA in Physics Education: A Case Study of Vector Field Simulation

Authors
Naim Naim1, *
1Department of Physics Education, Universitas Halu Oleo, Kendari, Indonesia
*Corresponding author. Email: naim@uho.ac.id
Corresponding Author
Naim Naim
Available Online 14 May 2025.
DOI
10.2991/978-2-38476-402-0_9How to use a DOI?
Keywords
Field Simulation; Excel Functions; Field Equations; Visualization
Abstract

The objective of this research is to develop field functions in Microsoft Excel by utilising pertinent field equations. In the context of terrain analysis, these equations frequently entail intricate calculations and demand a profound comprehension of the variables that exert influence upon them. The creation of terrain functions in Excel provides an accessible and efficient tool for simulating terrain, which can be used for both educational and research purposes. The utilisation of Excel as a simulation platform is anticipated to assist users, particularly students and researchers, in comprehending terrain behaviour with greater depth, obviating the necessity to master sophisticated simulation software that is typically more intricate. Moreover, this approach enables the visualisation of calculation outcomes in the format of graphs and tables, thus elucidating the effects and interrelationships between field parameters in an interactive and real-time manner.

Copyright
© 2025 The Author(s)
Open Access
Open Access This chapter is licensed under the terms of the Creative Commons Attribution-NonCommercial 4.0 International License (http://creativecommons.org/licenses/by-nc/4.0/), which permits any noncommercial use, sharing, adaptation, distribution and reproduction in any medium or format, as long as you give appropriate credit to the original author(s) and the source, provide a link to the Creative Commons license and indicate if changes were made.

Download article (PDF)

Volume Title
Proceedings of The 3rd International Conference on Mathematics and Science Education (ICMSE-2024)
Series
Advances in Social Science, Education and Humanities Research
Publication Date
14 May 2025
ISBN
978-2-38476-402-0
ISSN
2352-5398
DOI
10.2991/978-2-38476-402-0_9How to use a DOI?
Copyright
© 2025 The Author(s)
Open Access
Open Access This chapter is licensed under the terms of the Creative Commons Attribution-NonCommercial 4.0 International License (http://creativecommons.org/licenses/by-nc/4.0/), which permits any noncommercial use, sharing, adaptation, distribution and reproduction in any medium or format, as long as you give appropriate credit to the original author(s) and the source, provide a link to the Creative Commons license and indicate if changes were made.

Cite this article

TY  - CONF
AU  - Naim Naim
PY  - 2025
DA  - 2025/05/14
TI  - Application of Excel VBA in Physics Education: A Case Study of Vector Field Simulation
BT  - Proceedings of The 3rd International Conference on Mathematics and Science Education (ICMSE-2024)
PB  - Atlantis Press
SP  - 72
EP  - 81
SN  - 2352-5398
UR  - https://doi.org/10.2991/978-2-38476-402-0_9
DO  - 10.2991/978-2-38476-402-0_9
ID  - Naim2025
ER  -