The Effect of Interactive Learning Media Using Visual Basic for Application Excel Spreadsheet to Reduce Misconception in Physics Learning

Authors

Roza Zulfira , Abdul Halim , Ibnu Khaldun , Elmi Mahzum , Muhammad Nazar , Elisa Kasli

DOI:

10.29303/jppipa.v10i1.6387

Published:

2024-01-25

Issue:

Vol. 10 No. 1 (2024): January

Keywords:

Interactive learning media, Misconceptions, Traveling wave, Visual basic for application

Research Articles

Downloads

How to Cite

Zulfira, R. ., Halim, A. ., Khaldun, I. ., Mahzum, E. ., Nazar, M. ., & Kasli, E. . (2024). The Effect of Interactive Learning Media Using Visual Basic for Application Excel Spreadsheet to Reduce Misconception in Physics Learning. Jurnal Penelitian Pendidikan IPA, 10(1), 28–36. https://doi.org/10.29303/jppipa.v10i1.6387
Crossref
Scopus
Google Scholar
Europe PMC

Downloads

Download data is not yet available.

Metrics

Metrics Loading ...

Abstract

Misconceptions in physics learning are often caused by students’ preconceptions that are not in accordance with the actual physics theory. The use of interactive digital technology-based learning media makes it easier for students to understands physics concepts. This research aims to apply interactive learning media based on Visual Basic for Application (VBA) excel spreadsheets to remediate misconceptions in traveling wave material. The research method is a pre-experimental design, with one group for pretest and posttest. A total of 21 samples were selected using purposive sampling technique. Data collection was carried out twice, namely during the pretest and posttest using a five-tier multiple choice diagnostic test with 10 questions. The results of the misconception remediation analysis showed a decrease in misconceptions from 28.5% to 11.3% with an average N-Gain score (-0.31). This means that there was a decrease in the percentage of misconceptions before and after treatment. This data is also supported by the results of the paired sample t-test analysis, namely 0.000 < 0.5, which means that the use of interactive learning media based on Visual Basic for Application (VBA) Excel spreadsheets has a significant effect on remediating students' misconceptions about traveling wave material. This interactive learning media is expected to be an alternative for teachers in remediating misconceptions in learning physics.

References

Ayuni, A., & Arif, S. (2023). Analisis Miskonsepsi Ditinjau dari Gaya Belajar dengan Certainty of Response Index. Jurnal Tadris IPA Indonesia, 3(1), 69–82. https://doi.org/10.21154/jtii.v3i1.837

Banda, H. J., & Nzabahimana, J. (2023). The Impact of Physics Education Technology (PhET) Interactive Simulation-Based Learning on Motivation and Academic Achievement Among Malawian Physics Students. Journal of Science Education and Technology, 32(1), 127–141. https://doi.org/10.1007/s10956-022-10010-3

Bertacchini, F., Bilotta, E., Caldarola, F., & Pantano, P. (2019). The role of computer simulations in learning analytic mechanics towards chaos theory: a course experimentation. International Journal of Mathematical Education in Science and Technology, 50(1), 100–120. https://doi.org/10.1080/0020739X.2018.1478134

Cárdenas-Sainz, B. A., Barrón-Estrada, M. L., Zatarain-Cabada, R., & Chavez-Echeagaray, M. E. (2023). Evaluation of eXtended reality (XR) technology on motivation for learning physics among students in mexican schools. Computers & Education: X Reality, 3, 100036. https://doi.org/10.1016/j.cexr.2023.100036

Elfina, N., & Maria, H. T. (2017). Penggunaan macromedia flash berbantuan spreadsheet untuk meremediasi miskonsepsi pada tekanan zat cair di SMP. Jurnal Pendidikan Dan Pembelajaran Khatulistiwa, 6(5), 1–17. https://doi.org/10.26418/jppk.v6i5.19943

Fajarianingtyas, D. A., Herowati, H., & Yuniastri, R. (2018). Gaya Belajar Dan Miskonsepsi Siswa Pada Konsep Redoks Di Sma Negeri I Sumenep. LENSA (Lentera Sains): Jurnal Pendidikan IPA, 7(1), 2301–5071. https://doi.org/10.24929/lensa.v7i1.21

Gulo, S., & Harefa, A. O. (2022). Pengembangan Media Pembelajaran Interaktif Berbasis Powerpoint. Educativo: Jurnal Pendidikan, 1(1), 291–299. https://doi.org/10.56248/educativo.v1i1.40

Gunawan. (2022). Media Pembelajaran Insteraktif Sederhana untuk MI/SD. Yogyakarta: K- Media.

Halim, A., Soewarno, S., Elmi, E., Zainuddin, Z., Huda, I., & Irwandi, I. (2020). The Impact of the E-Learning Module on Remediation of Misconceptions in Modern Physics Courses. Jurnal Penelitian & Pengembangan Pendidikan Fisika, 6(2), 203–216. https://doi.org/10.21009/1.06207

Harahap, L. (2019). Peran Teknologi Informasi dan Komunikasi dalam Pendidikan. Prosiding Seminar Nasional Teknologi Pendidikan Pascasarjana UNIMED. http://digilib.unimed.ac.id/38785/

Kamal, S., & Mulhayatiah, D. (2019). Identifikasi Miskonsepsi Menggunakan Tes Diagnostik Three-Tier pada Hukum Newton dan Penerapannya. Journal of Teaching and Learning Physics, 1(1), 34–39. https://doi.org/10.15575/jotalp.v1i1.3441

Khaldun, I. (2019). Aplikasi Microsoft Excel Pada Program Titraasi Volumetri. Banda Aceh: Syiah Kuala University Press.

Lee, D. (2012). Drug Induced Liver Disease. MedicineNet. Retrieved from https://www.medicinenet.com/drug_induced_liver_disease/article.htm

Malik, A., Wandira, A., Kuntadi, D., & Nugraha, A. R. (2022). How can interactive multimedia direct instruction model improve student cognitive learning outcomes? Momentum: Physics Education Journal, 6(2), 104–118. https://doi.org/10.21067/mpej.v6i2.6686

Malone, K. L., Schunn, C. D., & Schuchardt, A. M. (2018). Improving Conceptual Understanding and Representation Skills Through Excel-Based Modeling. Journal of Science Education and Technology, 27(1), 30–44. https://doi.org/10.1007/s10956-017-9706-0

Mufidah, I., & Budiarto, M. T. (2018). Miskonsepsi Siswa SMP dalam Memahami Konsep Bangun Datar Segiempat Ditinjau dari Gaya Belajar VAK. Mathedunesa Jurnal Ilmiah Pendidikan Matematika, 2(7), 232–239. Retrieved from https://core.ac.uk/download/pdf/230666919.pdf

Muhid, A. (2019). Analisis Statistik. Sidoarjo: Zifatama Jawara.

Mukramah, W. A. N., Halim, A., Winarni, S., Yusrizal, Safrida, Jannah, M., & Wahyuni, A. (2023). Effect of Using Comic-based E-Module Assisted by the Flipbook Maker for Remediation of Newton’s Law Misconceptions. Jurnal Penelitian Pendidikan IPA, 9(8), 6384–6392. https://doi.org/10.29303/jppipa.v9i8.4389

Nurhafidhah, N., & Hasby, H. (2018). Identifikasi Miskonsepsi Siswa pada Penerapan Media Pembelajaran Interaktif Berbasis Microsoft Excel. Jurnal Pendidikan Sains Indonesia, 6(1), 32–39. https://doi.org/10.24815/jpsi.v6i1.10717

Putra, I., Adlim, A., & Halim, A. (2016). Analisis Miskonsepsi dan Upaya Remediasi Pembelajaran Listrik Dinamis dengan Menggunakan Media Pembelajaran Lectora Inspire dan Phet Simulation Di Sman Unggul Tunas Bangsa. Jurnal Pendidikan Sains Indonesia, 4(2), 13–19. Retrieved from https://jurnal.unsyiah.ac.id/JPSI/article/view/7565

Sa’diyah, E. Z., & Sukarmin, S. (2021). Pengembangan Media Pembelajaran Interaktif C-Bonds untuk Mendeteksi dan Mereduksi Miskonsepsi dengan Strategi Conceptual Change Text. Jurnal Kependidikan: Jurnal Hasil Penelitian Dan Kajian Kepustakaan Di Bidang Pendidikan, Pengajaran Dan Pembelajaran, 7(4), 1039. https://doi.org/10.33394/jk.v7i4.3443

Salimah, R., & Mulyani. (2018). Pengaruh Penerapan Strategi Everyone Is A Teacher Here Terhadap Hasil Belajar Ips Siswa Kelas Iv Sdn Kwedenkembar Mojokerto. Jpgsd, 6(13), 2348–2358. https://ejournal.unesa.ac.id/index.php/jurnapenelitian-

Sari, K. (2018). Miskonsepsi Pembelajaran Fisika pada Konsep Gerak Lurus di SMA Negeri 1 Baitussalam Aceh Besar. Jurnal Serambi PTK, 5(2), 24–29. Retrieved from https://ojs.serambimekkah.ac.id/serambi-ptk/article/view/857

Shweta, B., C., R., & Chaturvedi, H. K. (2015). Evaluation of Inter-Rater Agreement and Inter- Rater Reliability for Observational Data: An Overview of Concepts and Methods. Journal of the Indian Academy of Applied Psychology, 41(3), 20–27. Retrieved from https://www.researchgate.net/publication/2734

Soeharto, Csapó, B., Sarimanah, E., Dewi, F. I., & Sabri, T. (2019). A review of students’ common misconceptions in science and their diagnostic assessment tools. Jurnal Pendidikan IPA Indonesia, 8(2), 247–266. https://doi.org/10.15294/jpii.v8i2.18649

Sugiyono. (2019). Metode Penelitian Kuantitatif, Kualitatif dan R&D. Bandung: Alfabeta.

Sunyoto, A. (2007). Pemrograman Database dengan Visual Basic dan Microsoft SQL 2000. Yogyakarta: Andi Offset.

Suparno, P. (2013). Miskonsepsi & Perubahan Konsep Pendidikan Fisika. Jakarta: PT Grasindo.

Suryani, N. (2018). Media Pembelajaran Inovatif dan Pengembangannya. Bandung: PT Remaja Rosdakarya.

Sutarti, T., & Irawan, E. (2017). Kiat Sukses Meraih Hibah Penelitian Pengembangan. Yogyakarta: Deeppublish.

Swandi, S. : A., Rahmadhanningsih, S., Putri, R. A., Suryadi, A., Simulasi, P., Swandi, A., & Viridi, S. (2021). Pengembangan Simulasi Interaktif Gerak Parabola Menggunakan VBA Excel Dalam Pembelajaran Fisika. JRPF (Jurnal Riset Pendidikan Fisika), 6(1), 75–85. Retrieved from http://journal2.um.ac.id/index.php/jrpf/

Tarmizi, T., Halim, A., & Khaldun, I. (2017). Penggunaan Metode Eksperimen Untuk Mengatasi Miskonsepsi Dan Meningkatkan Minat Belajar Peserta Didik Pada Materi Rangkaian Listrik Di Sma Negeri 1 Jaya Kabupaten Aceh Jaya. Jurnal IPA & Pembelajaran IPA, 1(2), 149–158. https://doi.org/10.24815/jipi.v1i2.9689

Wahjusaputri, S., & Purwanto, A. (2022). Statistika Pendidikan. Yogyakarta: CV. Bintang Semesta Media.

Wibawanto, W. (2017). Desain dan Pemograman Multimedia Pembelajaran Interaktif. Jawa Timur: Cerdas Ulet Kreatif Publisher.

Widiyanto, A., Sujarwanto, E., & Prihaningtiyas, S. (2018). Analisis Pemahaman Konsep Peserta Didik Dengan Instrumen Four Tier Diagnostic Test Pada Materi Gelombang Mekanik. SNAMI : Prosiding Seminar Nasional Multidisiplin, 138–146. Retrieved from https://ejournal.unwaha.ac.id/index.php/snami/article/view/279

Wijaya, T. T., Tang, J., & Purnama, A. (2020). Developing an Interactive Mathematical Learning Media Based on the TPACK Framework Using the Hawgent Dynamic Mathematics Software. International Conference for Emerging Technologies in Computing, 318–328. https://doi.org/10.1007/978-3-030-60036-5_24

Wulandari, D. N., & Purwani, W. A. (2021). Examining Students’ Speaking Skill Through Youtube Videos: Pre-Experimental Design Study. Chalim Journal of Teaching and Learning, 1(2), 117–121. Retrieved from https://pasca.jurnalikhac.ac.id/index.php/cjotl/article/view/93

Yusup, F. (2018). Uji Validitas dan Reliabilitas Instrumen Penelitian Kuantitatif. Jurnal Tarbiyah: Jurnal Ilmiah Kependidikan, 7(1), 17–23. https://doi.org/10.18592/tarbiyah.v7i1.2100

Zulvita, Halim, A., & Kasli, E. (2017). Identifikasi dan remediasi miskonsepsi konsep hukum newton dengan menggunakan metode eksperimen di MAN darussalam. Jurnal Ilmiah Mahasiswa (JIM) Pendidikan Fisika, 2(1), 128–134. Retrieved from https://jim.usk.ac.id/pendidikan-fisika/article/view/2213

Author Biographies

Roza Zulfira, Syiah Kuala University, Darussalam, Banda Aceh

Abdul Halim, Syiah Kuala University, Darussalam, Banda Aceh

Ibnu Khaldun, Syiah Kuala University, Darussalam, Banda Aceh

Elmi Mahzum, Syiah Kuala University, Darussalam, Banda Aceh

Muhammad Nazar, Syiah Kuala University, Darussalam, Banda Aceh

Elisa Kasli, Syiah Kuala University, Darussalam, Banda Aceh

License

Copyright (c) 2024 Roza Zulfira, Abdul Halim, Ibnu Khaldun, Elmi Mahzum, Muhammad Nazar, Elisa Kasli

Creative Commons License

This work is licensed under a Creative Commons Attribution 4.0 International License.

Authors who publish with Jurnal Penelitian Pendidikan IPA, 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 4.0 International License (CC-BY License). This license allows authors to use all articles, data sets, graphics, and appendices in data mining applications, search engines, web sites, blogs, and other platforms by providing an appropriate reference. The journal allows the author(s) to hold the copyright without restrictions and will retain publishing rights without restrictions.
  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 acknowledgment of its initial publication in Jurnal Penelitian Pendidikan IPA.
  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 (See The Effect of Open Access).