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

Authors

  • Abu Yazid Raisal Study Program of Islamic Astronomy, Universitas Muhammadiyah Sumatera Utara, Indonesia
  • Muhammad Hidayat Study Program of Islamic Astronomy, Universitas Muhammadiyah Sumatera Utara, Indonesia
  • Nurul Zahriani Jf Study Program of Early Childhood Islamic Education, Universitas Muhammadiyah Sumatera Utara, Indonesia

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

2025-09-30

How to Cite

Developing of PowerPoint Based on Visual Basic for Application as a Interactive Learning Media to Increase Learning Interest. (2025). Jurnal Pendidikan Fisika, 13(3), 523-538. https://doi.org/10.26618/pck6y971

How to Cite

Developing of PowerPoint Based on Visual Basic for Application as a Interactive Learning Media to Increase Learning Interest. (2025). Jurnal Pendidikan Fisika, 13(3), 523-538. https://doi.org/10.26618/pck6y971