Developing of PowerPoint Based on Visual Basic for Application as a Interactive Learning Media to Increase Learning Interest
DOI: https://doi.org/10.26618/pck6y971
astronomy education, interactive learning media, powerpoint-based instruction, visual basic for application
Abstract
Student interest in astronomy has often been reported as relatively low due to the abstract nature of its concepts, reliance on mathematical reasoning, and the dominance of English-language resources, which collectively reduce motivation and engagement. This condition underlines the urgency of developing innovative learning media that not only deliver content but also actively stimulate curiosity and participation. The present study aimed to develop and validate interactive learning media for the fundamental astronomy course at Universitas Muhammadiyah Sumatera Utara by utilizing Microsoft PowerPoint integrated with Visual Basic for Applications (VBA). Employing a Research and Development approach based on the ADDIE model, the research was limited to the analysis, design, and development stages, followed by expert validation. The developed media incorporated hyperlink navigation, animations, three-dimensional models, and randomized quizzes with automated scoring and feedback. Validation results indicated that the product achieved an average score of 90.3% from media experts and 96.8% from material experts, both categorized as very valid according to established criteria. These findings confirm the reliability of the product in terms of technical quality, interactivity, and content accuracy. The novelty of this study lies in repurposing a widely available platform into an advanced instructional tool by embedding VBA programming, thereby expanding the pedagogical possibilities of conventional presentation software. In conclusion, the VBA-based PowerPoint media was proven to be highly valid and holds strong potential to enhance students’ learning interest in astronomy. This research contributes to the field of physics education by providing a validated framework for developing interactive, discipline-specific digital learning resources.
References
Aiyesi, S., Jumadi, & Prasetyo, Z. K. (2025). Development of a problem-based learning e-book to enhance students’ creative thinking skills in senior high school. Jurnal Pendidikan Fisika, 13(2), 103–118. https://journal.unismuh.ac.id/index.php/jpf/article/view/17419
Arsyad, A. (2019). Media pembelajaran. Rajawali Pers.
Asih, & Imami, A. I. (2021). Analisis minat belajar siswa SMP pada pembelajaran matematika. Jurnal Pembelajaran Matematika Inovatif, 4(4), 799–808. https://journal.ikipsiliwangi.ac.id/index.php/jpmi/article/view/7311
Aulia, S., Zetriuslita, Amelia, S., & Qudsi, R. (2021). Analisis minat belajar matematika siswa dalam menggunakan aplikasi Scratch pada materi trigonometri. Juring (Journal for Research in Mathematics Learning), 4(3), 205–214. http://dx.doi.org/10.24014/juring.v4i3.13128
Ayuningtyas, T. Y., & Wijayaningsih, L. (2020). Efektivitas permainan Detumbar (Dengarkan, temukan gambar) terhadap minat belajar anak usia dini. Jurnal Obsesi: Jurnal Pendidikan Anak Usia Dini, 5(1), 814–822. https://doi.org/10.31004/obsesi.v5i1.724
Bernard, M., & Chotimah, S. (2018). Improve student mathematical reasoning ability with open-ended approach using VBA for PowerPoint. AIP Conference Proceedings,1-9. https://doi.org/10.1063/1.5054417
Branch, R. M. (2009). Instructional design: The ADDIE approach. Springer Science+Business Media. https://doi.org/10.1007/978-0-387-09506-6
Chotimah, S. C., & Manoy, J. T. (2021). Pengembangan media pembelajaran berbasis PowerPoint Visual Basic for Application (VBA) untuk mendukung kemampuan spasial siswa. MATHEdunesa, 10(2), 374–384. https://doi.org/10.26740/mathedunesa.v10n2.ppdf_374-384
Djajadi, M. (2019). The use of outdoor study methods in physics kinematics learning (A classroom action research). Jurnal Pendidikan Fisika, 7(2), 151–172. https://doi.org/10.26618/jpf.v7i2.2070
Egara, F. O., & Mosimege, M. (2024). Effect of flipped classroom learning approach on mathematics achievement and interest among secondary school students. Education and Information Technologies, 29(7), 8131–8150. https://doi.org/10.1007/s10639-023-12145-1
Fatimah, C., Asmara, P. M., Mauliya, I., & Puspaningtyas, N. D. (2021). Peningkatan minat belajar siswa melalui pendekatan matematika realistik pada pembelajaran berbasis daring. Mathema: Jurnal Pendidikan Matematika, 3(2), 117–126. https://doi.org/10.33365/jm.v3i2.1310
Fauzi, M., & Shodiq, L. J. (2022). Development of learning media Microsoft PowerPoint based on Visual Basic for Application (VBA). AIP Conference Proceedings, 2577(1), 020018. http://dx.doi.org/10.1063/5.0096105
Febrina, V., & Setiawan, D. (2024). Analysis of the use of learning media on the learning interest of learning science students and environmental themes. Jurnal Penelitian Pendidikan IPA, 10(8), 5702–5709. https://doi.org/10.29303/jppipa.v10i8.7497
Habibah, N., & Napitupulu, S. (2021). Pengaruh media PowerPoint fitur hyperlink terhadap hasil belajar matematika siswa pada materi bangun datar kelas III SD Negeri 101771 Tembung. Invention: Journal Research and Education Studies, 2(3), 57–63. https://doi.org/10.51178/invention.v2i3.348
Hasana, S. N., & Alifiani, A. (2019). Multimedia development using Visual Basic for Application (VBA) to improve students’ learning motivation in studying mathematics of economics. Indonesian Journal of Mathematics Education, 1(1), 34–42. https://doi.org/10.31002/ijome.v2i1.1230
Hermawan, T., Khairiani, D., Muthmainnah, M., Saifullah, I., & Bisri, H. (2024). Pengaruh penggunaan media pembelajaran PowerPoint interaktif terhadap minat belajar matematika siswa kelas VII Madrasah Tsanawiyah. Asas Wa Tandhim: Jurnal Hukum, Pendidikan dan Sosial Keagamaan, 3(2), 87–98. https://doi.org/10.47200/awtjhpsa.v3i2.2173
Huijun, N., & Asaad, H. Q. M. (2023). Application of PowerPoint and the Visual Basic for Applications programming language in interactive educational software. Kurdish Studies, 11(2), 3215–3225. https://kurdishstudies.net/menu-script/index.php/KS/article/view/908
Julianti, V., Permana, A. H., & Fahdiran, R. (2022). Pengembangan e-modul astrofisika sebagai modul pendamping persiapan KSN Astronomi. Prosiding Seminar Nasional Fisika, 10(1), 45–50. https://journal.unj.ac.id/unj/index.php/prosidingsnf/article/view/24404
Kalwar, M. A., & Marri, H. B. (2021). Performance improvement of sale order detail preparation by using Visual Basic for Applications: A case study of footwear industry. International Journal of Business Education and Management Studies, 3(1), 1–22. https://www.researchgate.net/publication/356943752_Performance_Improvement_of_Sale_Order_Detail_Preparation_by_Using_Visual_Basic_for_Applications_A_Case_Study_of_Footwear_Industry
Lai, C., Chen, Q., Wang, Y., & Qi, X. (2024). Individual interest, self-regulation, and self-directed language learning with technology beyond the classroom. British Journal of Educational Technology, 55(1), 379–397. https://doi.org/10.1111/bjet.13366
León, S. P., & García-Martínez, I. (2021). Impact of the provision of PowerPoint slides on learning. Computers & Education, 173, 1-11. https://doi.org/10.1016/j.compedu.2021.104283
Liliana, R. A., Raharjo, W., Jauhari, I., & Sulisworo, D. (2020). Effects of the online interactive learning media on students’ achievement and interest in physics. Universal Journal of Educational Research, 8(3B), 59–68. https://doi.org/10.13189/ujer.2020.081507
Pertiwi, Harnipa, H., Hasan, N., & Fatmawati, T. (2022). The effect of the mysterious physics learning model based on fun learning on the physics learning outcomes. Jurnal Pendidikan Fisika, 10(1), 50–57. https://journal.unismuh.ac.id/index.php/jpf/article/view/7087
Pohan, S., Mavianti, M., Setiawan, H. R., & Marpaung, A. H. (2022). Meningkatkan minat belajar siswa dengan menggunakan media bergambar dan PowerPoint pada mata pelajaran fiqih. Edukasi Islami: Jurnal Pendidikan Islam, 11(3), 779–788. https://doi.org/10.30868/ei.v11i03.2446
Pramesti, P. D., Dibia, I. K., & Ujianti, P. R. (2021). Media pembelajaran daring interaktif berbasis PowerPoint dengan fungsi hyperlink. Jurnal Pedagogi dan Pembelajaran, 4(2), 258–267. https://doi.org/10.23887/jp2.v4i2.36524
Raisal, A. Y., Rakhmadi, A. J., & Hidayat, M. (2024). The development of Android-based interactive learning media on the topic of discussing the atmosphere. Journal of Physics: Conference Series, 2773(1), 1-6. https://doi.org/10.1088/1742-6596/2773/1/012023
Rohaeti, E. E., Bernard, M., & Primandhika, R. B. (2019). Developing interactive learning media for school-level mathematics through open-ended approach aided by Visual Basic application for Excel. Journal on Mathematics Education, 10(1), 59–68. https://www.researchgate.net/publication/331017134_Developing_interactive_learning_media_for_school_level_mathematics_through_open-ended_approach_aided_by_visual_basic_application_for_excel
Rohima, I. (2021). Pengaruh penggunaan PowerPoint dengan Visual Basic Application terhadap hasil belajar siswa pada materi fungsi invers di SMK Wikrama Bogor. Vocational: Jurnal Inovasi Pendidikan Kejuruan, 1(4), 280–285. https://doi.org/10.51878/vocational.v1i4.730
Rosyiddin, A. A. Z., Fiqih, A., Nugraha, H., Hadiapurwa, A., & Komara, D. A. (2023). The effect of interactive PowerPoint media design on student learning interests. Edcomtech: Jurnal Kajian Teknologi Pendidikan, 8(1), 12–24. http://dx.doi.org/10.17977/um039v8i12023p12
Sakiah, N. A., & Effendi, K. N. S. (2021). Analisis kebutuhan multimedia interaktif berbasis PowerPoint materi aljabar pada pembelajaran matematika SMP. JP3M (Jurnal Penelitian Pendidikan dan Pengajaran Matematika), 7(1), 39–48. https://doi.org/10.37058/jp3m.v7i1.2623
Trinovita, D., & Ratnasari, M. (2023). Pemanfaatan 3D models pada PowerPoint sebagai media pembelajaran interaktif. Journal of Computer Science and Informatics (JOCSI), 1(1), 27–31. https://doi.org/10.69747/jocsi.v1i1.18
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2025 Jurnal Pendidikan Fisika

This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
Copyright:
Authors who publish with this journal agree to the following terms:
1. Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution-ShareAlike 4.0 International License that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.
2. Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgement of its initial publication in this journal.
3. Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work.
Licence:
Authors are free to:
1. Share: Copy and redistribute the material in any medium or format
2. Adapt: Remix, transform, and build upon the material for any purpose, even commercially.
The licensor cannot revoke these freedoms as long as the authors follow the license terms, which include the following:
1. Attribution: You must give appropriate credit, provide a link to the license, and indicate if changes were made. You may do so in any reasonable manner, but not in any way that suggests the licensor endorses you or your use.
2. ShareAlike: If you remix, transform, or build upon the material, you must distribute your contributions under the same license as the original.
3. No additional restrictions: You may not apply legal terms or technological measures that legally restrict others from doing anything the license permits.
Jurnal Pendidikan Fisika is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.