The Effect of VBA for Microsoft Excel as Teaching Material to Improve Prospective Elementary School Teachers' Mathematical Conceptual Understanding

Siti Ruqoyyah, Sukma Murni, Tommy Tanu Wijaya


This research is motivated by the low ability to understand mathematical concepts possessed by prospective elementary school teacher students. This study aims to see the achievement and improvement of students' mathematical understanding abilities that use Microsoft Excel-based VBA teaching materials with those using conventional learning. This study uses a quasi-experimental method with a non-equivalent pre-test and post-test control group design. This study's population were all second-semester elementary school teacher candidates in one private university in West Java, Indonesia. The sample in this study was 70 prospective 2nd-grade elementary school teacher candidates. The instrument used in this study was a test of understanding mathematical concepts. The results showed: 1) learning using VBA Microsoft Excel as a teaching material was able to improve students' ability to understand mathematical concepts; 2) learning using Microsoft Excel VBA as teaching material is better than conventional learning; and 3) students can be enthusiastic, active and motivated in learning mathematics with VBA Microsoft Excel.


microsoft excel VBA; understanding of the mathematical concept; teaching materials; elementary school students'

Full Text:



Agyei, D. D. (2019). From needs analysis to large-scale implementation: Using collaborative design to support ict integration. Collaborative Curriculum Design for Sustainable Innovation and Teacher Learning, 305–328.

Akkaya, A., Tatar, E., & Kaǧizmanli, T. B. (2011). Using dynamic software in teaching of the symmetry in analytic geometry: The case of GeoGebra. Procedia - Social and Behavioral Sciences, 15, 2540–2544.

Babinčáková, M., Ganajová, M., Sotáková, I., & Bernard, P. (2020). Influence of formative assessment classroom techniques (Facts) on student’s outcomes in chemistry at secondary school. Journal of Baltic Science Education, 19(1), 36–49.

Baya’a, N., & Daher, W. (2013). Mathematics teachers’ readiness to integrate ICT in the classroom. International Journal of Emerging Technologies in Learning, 8(1), 46–52.

Bernard, M., Akbar, P., Ansori, A., & Filiestianto, G. (2019). Improve the ability of understanding mathematics and confidence of elementary school students with a contextual approach using VBA learning media for Microsoft Excel. IOP Conf. Series: Journal of Physics: Conf. Series, 1318(1), 012035.

Bernard, M., & Senjayawati, E. (2019). Developing the Students’ Ability in Understanding Mathematics and Self-confidence with VBA for Excel. JRAMathEdu (Journal of Research and Advances in Mathematics Education), 4(1), 45–56.

Bernard, Martin, & Chotimah, S. (2018). Improve student mathematical reasoning ability with open-ended approach using VBA for powerpoint. AIP Conference Proceedings, 2014(September).

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.

Boholano, H. (2017). Smart Social Networking: 21st Century Teaching and Learning Skills. Research in Pedagogy, 7(1), 21–29.

Cahyani, K. S. (2018). Pemahaman Matematika Anak Indonesia Cuma Naik 11 Persen dalam 14 Tahun (Indonesian Children’s Mathematics Understanding Only Raised 11 Percent in 14 Years). Detik Health.

Çalışkan, N., Kahya, E., & Durmuş, Y. T. (2018). An Analysis of Mathematics Questions of the TPESE Exam According to Cognitive Levels of TIMMS 2015. 7(5), 67–82.

Cengiz, N., Kline, K. &, & Grant, T. J. (2011). Extending students’ mathematical thinking during whole-group discussions. Journal of Mathematics Teacher Education, 14(1), 355–374.

Chaamwe, N., & Shumba, L. (2016). ICT Integrated Learning: Using Spreadsheets as Tools for e-Learning, A Case of Statistics in Microsoft Excel. International Journal of Information and Education Technology, 6(6), 435–440.

Chang, Y. J., Wang, T. Y., Chen, S. F., & Liao, R. H. (2011). Student Engineers as Agents of Change: Combining Social Inclusion in the Professional Development of Electrical and Computer Engineering Students. Systemic Practice and Action Research, 24(3), 237–245.

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).

Dewabrata, M. (2019, December). Hasil PISA 2018 Resmi Diumumkan, Indonesia Alami Penurunan Skor di Setiap Bidang (PISA 2018 Results Officially Announced, Indonesia Has Decreased Score in Every Field). Zenius.Net.

Duval, R. (2017). Understanding the mathematical way of thinking - The registers of semiotic representations. In Understanding the Mathematical Way of Thinking - The Registers of Semiotic Representations.

Esmonde, I. (2009). Mathematics Learning in Groups: Analyzing Equity in Two Cooperative Activity Structures. Journal of the Learning Sciences, 18(2), 247–284.

Fennema, E., & Romberg, T. A. (1999). Mathematics Classrooms That Promote Understanding. Lawrence Erlbaum Assoeiates.

Häkkinen, P., Järvelä, S., Mäkitalo-Siegl, K., Ahonen, A., Näykki, P., & Valtonen, T. (2017). Preparing teacher-students for twenty-first-century learning practices (PREP 21): a framework for enhancing collaborative problem-solving and strategic learning skills. Teachers and Teaching, Taylor & Francis, 23(1), 25–41.

Harsusilo, Y. E. (2019). Ironi Matematika: Juara di Olimpiade Miris di Peringkat PISA, Ada Apa? (Mathematical irony: Champion in the Olympics is sad at the PISA Ranking, What’s wrong?). Kompas.Com.

Herawaty, D., & Widada, W. (2017). The Influence of Contextual Learning Models and the Cognitive Conflict to Understand Mathematical Concepts and Problems Solving Abilities. Proceedings of the 1st Annual International Conference on Mathematics, Science, and Education (ICoMSE 2017), 96–102.

Hidayat, W., Wahyudin, W., & Prabawanto, S. (2018). Improving students’ creative mathematical reasoning ability students through adversity quotient and argument driven inquiry learning. Journal of Physics: Conference Series, 948(1).

Ketelhut, D. J. (2019). Contemporary Technologies in Education. Contemporary Technologies in Education, 17–29.

Kilpatrick, J., Swafford, J., & Findell, B. (2001). Adding it Up: Helping Childern Learn Mathematics. National Academy Press.

Kustos, P., & Zelkowski, J. (2013). Grade-continuum trajectories of four known probabilistic misconceptions: What are students’ perceptions of self-efficacy in completing probability tasks? Journal of Mathematical Behavior, 32(3), 508–526.

Lee, C. J., & Kim, C. M. (2017). A technological pedagogical content knowledge based instructional design model: a third version implementation study in a technology integration course. Educational Technology Research and Development, 65(6), 1627–1654.

Minarni, A., Napitupulu, E. E., & Husein, R. (2016). Mathematical understanding and representation ability of public junior high school in North Sumatra. Journal on Mathematics Education, 7(1), 43–56.

Murni, S., Bernard, M., Ruqoyyah, S., & Chotimah, S. (2020). PGSD student’s mathematical creative thinking skills judging from creativity quotations by making vba-based teaching. Journal of Physics: Conference Series, 1521(3), 032040.

OECD. (2018). PISA 2015 Result in Focus. OECD.

Özyurt, Ö., Özyurt, H., Güven, B., & Baki, A. (2014). The effects of UZWEBMAT on the probability unit achievement of Turkish eleventh grade students and the reasons for such effects. Computers and Education, 75, 1–18.

Pape, S. J., & Tchoshanov, M. A. (2001). The role of representation (s) in developing mathematical understanding. Theory into Practice, Taylor & Francis, 40(2), 118–127.

Partnership for 21st Century Leaning. (2015). P21 framework definitions: 21st CENTURY STUDENT OUTCOMES.

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. Mimbar Sekolah Dasar, 6(2), 147–159.

Reis, Z. A. (2010). Computer supported mathematics with Geogebra. Procedia - Social and Behavioral Sciences, 9, 1449–1455.

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.

Romlah, S., Nugraha, N., & Setiawan, W. (2019). Analisis Motivasi Belajar Siswa SD Albarokah 448 Bandung dengan Menggunakan Media ICT Berbasis For VBA Excel Pada Materi Garis Bilangan (Analysis of Learning Motivation of Students SD Albarokah 448 Bandung Using ICT-Based Media For VBA Excel on Number Lines). Jurnal Cendekia : Jurnal Pendidikan Matematika., 3(1), 220–226.

Ruqoyyah, S. (2018). Meningkatkan Kemampuan Komunikasi Matematik Siswa MA melalui Contextual Teaching and Learning (Improve Mathematical Communication Skills of MA Students through Contextual Teaching and Learning). P2M STKIP Siliwangi, 5(2), 85–99.

Ruqoyyah, S., Murni, S., & Fasha, L. H. (2020). Microsoft Excel VBA on mathematical resilience of primary school teacher education students. Journal of Physics: Conference Series, 1657(1), 012010.

Ruseffendi, E. T. (2010). Dasar-dasar Penelitian Pendidikan dan Bidang Non-Eksakta Lainnya (Fundamentals of Educational Research and Other Non-Exact Fields). Bandung: Tarsito.

Suan, L., Ying, Z., & Wijaya, T. T. (2020). Using hawgent dynamic mathematics software in teaching arithmetic operation. International Journal of Education and Learning, 2(1), 25–31.

Tsany, U. N., Septian, A., & Komala, E. (2020). The ability of understanding mathematical concept and self-regulated learning using macromedia flash professional 8. Journal of Physics: Conference Series, 1657(1), 012074.

Wijaya, T. T., Jianlan, T., & Aditya, P. (2020). Developing an Interactive Mathematical Learning Media Based on the TPACK Framework Using the Hawgent Dynamic Mathematics Software. Emerging Technologies in Computing, 318–328.

Wijaya, T. T., Ying, Z., Cunhua, L., & Zulfah. (2020). Using vba learning media to improve students ’ mathematical understanding ability. Journal On Education, 02(02), 245–254.

Wijaya, T. T., Zulfah, Z., Hidayat, A., Akbar, P., Arianti, W., & Asyura, I. (2020). Using VBA for microsoft excel based on 6-questions cognitive theory in teaching fraction. Journal of Physics: Conference Series, 1657(1), 012078.

Zhang, L., Zhou, Y., & Wijaya, T. T. (2020). Hawgent dynamic mathematics software to improve problem-solving ability in teaching triangles. Journal of Physics: Conference Series, 1663(1).



  • There are currently no refbacks.

Copyright (c) 2020 Mimbar Sekolah Dasar

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

View Mimbar Sekolah Dasar Stats