Utilization of VBA Excel-Based Virtual Laboratories in Kinematics and Dynamics Learning
Pemanfaatan Laboratorium Virtual Berbasis VBA Excel pada Pembelajaran Kinematika dan Dinamika
Abstract
The purpose of this community service activity is to mentor students and teachers in schools in using virtual laboratories. In this case the Excel VBA application is used in its application to kinematics and dynamics material. This activity was carried out at SMAN 1 Kemtuk Gresi, Jayapura Regency. Submission of material is equipped with a practicum module based on LKPD to make it easier for students and teachers during implementation. In carrying out this community service activity, the enthusiasm of students and teachers was very good. This is because the implementation of virtual and real practicum can add insight in learning physics. Students also just realized that MS Excel can be utilized in physics simulations because their perception so far is that MS Excel is only a program that is used only to input data in tables. The teacher also gave a positive response to the community service activities that had been carried out because it helped in making a VBA Excel-based virtual laboratory and making LKPD.
Downloads
References
[2] Susilo, A., & Sarkowi, S. (2018). Peran Guru Sejarah Abad 21 dalam Menghadapi Tantangan Arus Globalisasi. Historia: Jurnal Pendidik Dan Peneliti Sejarah, 2(1), 43. https://doi.org/10.17509/historia.v2i1.11206
[3] Akbar, M., Budiarti, I, S., 2020. Analysis of Higher Order Thinking Skills (HOTs) on Simple Harmonic Motion Concept Using Virtual Laboratory Based on VBA Excel Study in Physics Education Students of Universitas Cenderawasih. Advances in Social science, Education and Humanities Research, Volume 630. Atlantis Press
[4] Chen, X., Song, G., & Zhang, Y. (2010). Virtual and remote laboratory development: A review.In Earth and Space 2010: Engineering, Sci- ence, Construction, and Operations in Chal- lenging Environments (pp. 3843-3852).
[5] Ciepiela, E., Harężlak, D., Kocot, J., Bartyński, T., Kasztelnik, M., Nowakowski, P & Bubak, M. (2010). Exploratory programming in the virtual laboratory. In Computer Science and Information Technology (IMCSIT), Proceedings of the 2010 International Multiconference on (pp. 621-628). IEEE.
[6] Akbar, M., Silaban, A., (2021). Analisis Pemahaman Konsep Harmonik Sederhana Melalui virtual laboratory berbasis VBA Excel pada mahasiswa. Jurnal Pendidikan Fisika Vol.10 No 2
[7] Erwin, E., Robi, D, R., (2016). Simulasi Benda yang Dilepas Horizontal dan Benda yang Dijatuhkan Vertikal Menggunakan VBA pada Microsoft Excel. Prosiding seminar kontribusi fisika (SKF) ITB
[8] Wiyanto. (2008). Menyiapkan Guru Sains Mengem- bangkan Kompetensi Laboratorium. Semarang: Universitas Negeri Semarang Press
[9] Gunawan, A. Harjono, H. Sahidu, L. Herayanti. (2017). Virtual Laboratory Of Electricity Concept To Improve Prospective Physics Teachers’ Creativity. Jurnal Pendidikan Fisika Indonesia 13 (2),102-111
[10] Tatli, Z., & Ayas, A. (2013). Effect of a Virtual Chemistry Laboratory on Students' Achievement. Journal of Educational Technology & Society, 16(1),159-170.
[11] Bernard, M., Senjayawati, E,. (2019). Developing the Students’ Ability in Understanding Mathematics and Self-confidence with VBA for Excel. Journal of Research and Advances in Mathematics Education. 4(1). 45-56.
[12] Wong, K.W.W., Barford, J.P., (2010). Teaching Excel VBA as a problem solving tool for chemical engineering core courses. Education for Chemical Engineers. 5(4). 72-77. https://doi.org/10.1016/j.ece.2010.07.002
[13] Brkic, D., Stajic, Z., (2021). Excel Vba-Based User Defined Functions For Highly Precise Colebrook’s Pipe Flow Friction Approximations: A Comparative Overview. FACTA UNIVERSITATIS Series: Mechanical Engineering. 19(2). 253-269. https://doi.org/10.22190/FUME210111044B
[14] Pane, I. (2015). Pemanfaatan Microsoft Excel Sebagai Perangkat Pengembangan Prototipe Piranti Lunak Visual. Ultima InfoSys : Jurnal Ilmu Sistem Informasi, 6(1), 20-26. https://doi.org/https://doi.org/10.31937/si.v6i1.275
[15] David. (2019). Pemanfaatan Macro VBA dalam Perekaman Data Untuk Meningkatkan Keahlian Pranata Komputer. Seminar Nasional Hasil Pengabdian Kepada Masyarakat 2019. STIMK Pontianak 2019. http://sisfotenika.stmikpontianak.ac.id/index.php/sindimas/article/view/550/356
