PROBLEM SOLVING APPROACH AND LEARNING MEDIA BASED ON VBA FOR EXCEL AS AN EFFORT TO IMPROVE THE MATHEMATICAL COMMUNICATION SKILLS OF ELEMENTARY SCHOOL STUDENTS
DOI:
https://doi.org/10.31949/jcp.v11i2.13237Abstract
Digital technology is one of the strongest driving forces in the modern economy, requiring the mastery of 21st-century skills. These skills can be developed through mathematics, as its learning process enhances students' strategic thinking. Mathematics should be taught from the elementary level to equip students with logical, analytical, systematic, critical thinking, and communication skills. Mathematical communication is especially important for elementary students to understand, express ideas, model problems, and find solutions. However, current evidence shows that students’ mathematical communication skills remain relatively low, partly due to the limited use of learning models and classroom activities designed to foster such abilities. One potential solution is the use of a problem-solving approach supported by VBA for Excel-based learning media. This combination can improve students’ mathematical understanding and enhance their 21st-century skills, particularly in mathematical communication. The use of VBA-based media provides students with visual and interactive tools to solve and communicate various mathematical problems. This study aims to examine the effectiveness of the problem-solving approach and VBA for Excel media in improving elementary students’ mathematical communication skills. A quasi-experimental method was used, applying a Pretest-Posttest Control Group Design in two classes at a public elementary school in Bandung, with sampling through Non-Probability Sampling techniques. The results showed that this approach effectively improved students’ mathematical communication skills. Moreover, the learning media helped optimize the learning process and received positive feedback from students.
Keywords:
Problem solving, VBA Excel, mathematical communication skillsDownloads
References
Aedi, W. G. (2020). Upaya meningkatkan prestasi belajar matematika dengan pendekatan problem solving. JIPMat, 5(1), 433370.
Aini, K., Prihandoko, A. C., Yuniar, D., & Faozi, A. K. A. (2020). The students’ mathematical communication skill on caring community-based learning cycle 5E. Journal of Physics: Conference Series, 1538(1), 012075.
Amran, A., Fadil, K., & Kurnia, D. (2020). Perbedaan Kemampuan Pemahaman Konsep Matematika Antara Pendekatan Realistic Mathematics Education dan Pendekatan Problem Solving di Sekolah Dasar. Jurnal Basicedu, 5(1), 19–29.
Asikin, M., Nurhidayat, M. F., & Ardiansyah, A. S. (2021). Development of STEM-nuanced textbook to improve students’ mathematical communication skill. Journal of Physics: Conference Series, 1918(4), 042064.
Barreto, H. (2024). Gateway to Business Analytics with Microsoft Excel.
Bernard, M. (2018). Meningkatkan kemampuan berpikir kreatif mahasiswa matematik melalui pendekatan problem posing berbantuan visual basic application for microsoft excel. JPMI (Jurnal Pembelajaran Matematika Inovatif), 1(1), 69–78.
Bernard, M., Minarti, E. D., & Hutajulu, M. (2018). Constructing Student’s Mathematical Understanding Skills and Self Confidence: Math Game with Visual Basic Application for Microsoft Excel in Learning Phytagoras at Junior High School. International Journal of Engineering & Technology, 7(3.2), 732–736.
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.
Bernard, M., Sunaryo, A., Akbar, P., Siliwangi, P., Terusan Jenderal Sudirman, J., Putra Juang, S., & Cipetir Sukatani, J. (2021). Primary School Students’ Learning Toward The Use of VBA For Excel Based Games In Learning Number. 05(01), 448–457.
Chotimah, S., Bernard, M., & Wulandari, S. M. (2018). Contextual approach using VBA learning media to improve students’ mathematical displacement and disposition ability. Journal of Physics: Conference Series, 948(1). https://doi.org/10.1088/1742-6596/948/1/012025
Fitri, S. A. N., & Pertiwi, C. M. (2024). The Improvement of Mathematical Communication Ability Using Problem-Based Learning Model on Junior High School Students. (JIML) Journal Of Innovative Mathematics Learning, 7(3), 272–280.
Fitriani, A., Baharullah, B., & Husniati, A. (2022). Pengaruh Pendekatan Problem Solving Berbantuan Lembar Kerja Peserta Didik Berbasis Higher Order Thinking Skill Terhadap Kemampuan Berpikir Kreatif. Pedagogika, 135–149.
Hardman, J. (2019). Towards a pedagogical model of teaching with ICTs for mathematics attainment in primary school: A review of studies 2008–2018. Heliyon, 5(5). https://doi.org/10.1016/j.heliyon.2019.e01726
Hermawati, F. E. (2023). Penerapan Model Pembelajaran SSCS (Search-Solve-Create-Share) untuk Meningkatkan kemampuan Komunikasi Matematis Siswa Kelas 8 SMP Negeri 25 Malang pada Materi Statistika.
JIN, G. (1999). A review of hydrologic frequency analysis. Advances in Water Science, 10(3), 319–327.
Koskinen, R., & Pitkäniemi, H. (2022). Meaningful learning in mathematics: A research synthesis of teaching approaches. International Electronic Journal of Mathematics Education, 17(2), em0679.
Lestari, K. E., & Yudhanegara, M. R. (2019). Penelitian pendidikan matematika.
Linda, L., Fitriani, N., & Bernard, M. (2020). Resiliensi Matematik Siswa Sekolah Dasar Melalui Edukasi VBA di Masa New Normal.
Maharjan, M., Dahal, N., & Pant, B. P. (2022). ICTs into mathematical instructions for meaningful teaching and learning. Advances in Mobile Learning Educational Research, 2(2), 341–350. https://doi.org/10.25082/AMLER.2022.02.004
Melinda, V., & Zainil, M. (2020). Penerapan model project based learning untuk meningkatkan kemampuan komunikasi matematis siswa sekolah dasar (studi literatur). Jurnal Pendidikan Tambusai, 4(2), 1526–1539.
Meltzer, D. E. (2002). The relationship between mathematics preparation and conceptual learning gains in physics: A possible “hidden variable” in diagnostic pretest scores. American Journal of Physics, 70(12), 1259–1268.
NCTM, P. (2000). Standart for School Mathematics. USA: The National Council of Teacher of Mathematics. Inc.
Nurhayati, L., & Chotimah, S. (2020). Analisis Pengaruh Penggunaan Visual Basic Application Terhadap Minat Belajar Matematika Siswa SD pada Materi Bilangan Prima. Edumatica: Jurnal Pendidikan Matematika, 10(1), 19–26.
Pertiwi, C. M., Rohaeti, E. E., & Hidayat, W. (2021). The Students’mathematical Problem-Solving Abilities, Self-Regulated Learning, And Vba Microsoft Word In New Normal: A Development Of Teaching Materials. Infinity Journal, 10(1), 17–30.
Pertiwi, C. M., Rosyana, T., Supardi, A. F., & Al Mawaddah, A. M. (2023). Implementasi IMATIC (Interactive Mathematic Comic) berbasis VBA-Excel pada materi matematika SMP untuk kemampuan literasi dan numerasi calon guru matematika di era society 5.0. JPMI (Jurnal Pembelajaran Matematika Inovatif), 6(6), 2139–2148.
Pratiwi, I. C., Inganah, S., & Putri, O. R. U. (2020). Analysis on written mathematical communication skills at system of linear equations in two variables (SLETV) material viewed from student learning styles. Mathematics Education Journal, 3(2), 119–129.
Purbaningrum, M., & Palupi, E. L. W. (2022). Students’ mathematical communication: Covid-19 problem-solving experience among high achievers. Jurnal Pengembangan Pembelajaran Matematika (JPPM), 4(1), 1–15.
Putri, D. P., Ferdianto, F., & Fauji, S. H. (2020). Designing a digital teaching module based on mathematical communication in relation and function. Journal on Mathematics Education, 11(2), 223–236.
Putri, N. D., & Musdi, E. (2020). Analysis of students Initial mathematical communication skills in mathematics learning. Journal of Physics: Conference Series, 1554(1), 012064.
Rahayu, G., Arga, H., Altaftazani, D., & Bernard, M. (2019). Effect of VBA learning media to improve students decision making skill of elementary school. 2019 Ahmad Dahlan International Conference Series on Education & Learning, Social Science & Humanities (ADICS-ELSSH 2019), 146–150.
Rahayu, G. D. S., & Arga, H. S. P. (2019). Influence of VBA-Based Monopoly Game in Microsoft Excel as Teaching Material on Primary School Students’ Cross-Cultural Competence in Social Studies Learning. Elementary School Forum (Mimbar Sekolah Dasar), 6(2), 147–159.
Rahayu, G. D. S., Bernard, M., Mulyono, D., & Rabbani, S. (2020). VBA media development for microsoft excel against students’ mathematical problem solving. Journal of Physics: Conference Series, 1657(1). https://doi.org/10.1088/1742-6596/1657/1/012079
Refiyeti, Y. (2023). Pengaruh model pembelajaran problem solving berbantuan media pembelajaran geogebra terhadap kemampuan komunikasi matematis siswa SMPN 9 Bandar Lampung. Universitas Islam Negeri Raden Intan Lampung.
Rohaeti, E. E., Fitriani, N., & Akbar, P. (2020). Developing An Interactive Learning Model Using Visual Basic Applications With Ethnomathematical Contents To Improve Primary School Students’mathematical Reasoning. Infinity Journal, 9(2), 275–286.
Rohid, N., & Rusmawati, R. D. (2019). Students’ Mathematical Communication Skills (MCS) in Solving Mathematics Problems: A Case in Indonesian Context. Anatolian Journal of Education, 4(2), 19–30.
Rusdi, M., Fitaloka, O., Basuki, F. R., & Anwar, K. (2020). Mathematical Communication Skills Based on Cognitive Styles and Gender. International Journal of Evaluation and Research in Education, 9(4), 847–856.
Sugandi, A. I., Sofyan, D., & Maesaroh, S. (2021). Pengembangan Perangkat Pembelajaran Menggunakan Deduktif Induktif Berbantuan Geogebra Dalam Meningkatk Kemampuan Berpikir Kreatif Siswa Pada Masa Pandemi. JPMI (Jurnal Pembelajaran Matematika Inovatif), 4(1), 149–160.
Sumarmo, U. (2010). Berpikir Dan Disposisi Matematik: Apa, Mengapa, dan bagaimana dikembangkan pada peserta didik. Bandung: FPMIPA UPI, 1–27.
Suri, F. I., Anggoro, B. S., Komarudin, K., & Fahmi, R. R. (2022). Improving mathematic communication ability through islamic math e-comic media: A study on building flat sides. Desimal: Jurnal Matematika, 5(2), 223–234.
Susilawati, E., Hamidah, I., Rustaman, N., & Liliawati, W. (2024). Problem Solving Learning in Science Education: A Systematic Literature Review. Jurnal Penelitian Pendidikan IPA, 10(8), 548–558.
Suyani, N. M. F., & Wulandari, I. G. A. A. (2020). Penhgaruh Model Probing Prompting Terhadap Komunikasi Matematika Siswa SD. Jurnal Ilmiah Pendidikan Dan Pembelajaran, 4(2), 379–389.
Syamsyiah, Z. M., Amelia, S., & Maarif, S. (2022). Kemampuan Komunikasi Matematis: Sebuah Systematic Literature Review dengan Analisis Bibliometrik Menggunakan Vos Viewers. Jurnal Pendidikan Matematika (JPM), 8(2), 114–128.
Szabo, Z. K., Körtesi, P., Guncaga, J., Szabo, D., & Neag, R. (2020). Examples of problem-solving strategies in mathematics education supporting the sustainability of 21st-century skills. Sustainability, 12(23), 10113.
Tiarawati, U. H. (2024). Utilizing Snakes And Ladders Media In Learning Mathematic Elementary School Students. Jurnal Cakrawala Pendas, 10(2), 296–306.
Valente, M. J., & MacKinnon, D. P. (2017). Comparing models of change to estimate the mediated effect in the pretest–posttest control group design. Structural Equation Modeling: A Multidisciplinary Journal, 24(3), 428–450.
Wicaksono, Y. (2014). Membuat fungsi excel untuk bisnis dan perkantoran. Elex Media Komputindo.
Winggowati, S., & Herman, T. (2023). The Effect Of Gender On Elementary Students’mathematical Communication Ability. Jurnal Cakrawala Pendas, 9(2), 370–377.
Zain, B. P., & Ahmad, R. (2021). Pengaruh Model Kooperatif Tipe Think Pair Share terhadap Motivasi dan Kemampuan Komunikasi Matematis Siswa Sekolah Dasar. Jurnal Basicedu, 5(5), 3668–3676.
Zebua, M. B., Harefa, A. O., & Harefa, A. R. (2022). Analisis Kemampuan Metakognitif Siswa dalam Memecahkan Masalah dengan Menggunakan Pendekatan Problem Solving di Kelas VIII SMP Negeri 2 Tugalaoyo. Formosa Journal of Applied Sciences, 1(4), 493–512.
Ziegler, E., Edelsbrunner, P. A., & Stern, E. (2018). The relative merits of explicit and implicit learning of contrasted algebra principles. Educational Psychology Review, 30, 531–558.
Published
How to Cite
Issue
Section
License
Copyright (c) 2025 Citra Megiana Pertiwi, Nendi Rohaendi, Galih Dani Septiyan Rahayu
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
Authors who publish with this journal agree to the following terms:
- Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgment of the work's authorship and initial publication in this journal.
- 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 this journal.
- 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).
