Teaching Macro Excel on Pre-service Mathematics Teachers: Analysis Error in Solving the Syntax Manually

Nourma Pramestie Wulandari; Faishal Wahiduddin; Ulfa Lu'luilmaknun; Mohammad Archi Maulyda; Ratih Ayu Apsari

doi:10.31764/jtam.v5i1.3313

Teaching Macro Excel on Pre-service Mathematics Teachers: Analysis Error in Solving the Syntax Manually

Nourma Pramestie Wulandari, Faishal Wahiduddin, Ulfa Lu'luilmaknun, Mohammad Archi Maulyda, Ratih Ayu Apsari

Abstract

The aim of this study is to describe errors output when pre-service mathematics teachers were writing output of the syntax that given in macro excel manually. This research is a qualitative descriptive research with 101 participants from 2^nd year pre-service mathematics teachers from one of state university at Nusa Tenggara Barat, Indonesia. Instrument used consists of one syntax that has 8 outputs when it is run and that will be analysed using Newman’s procedures. The eight outputs come from 3 types of output, namely text, numbers, and count. The result showed that the average percentage of syntax output writing errors was 87.13%. It also indicated to reading errors of 48.51%, comprehension errors of 18.81%, transformation errors of 83.17%, process skill errors of 20.79%, and encoding errors of 87.13%. Based on the result, errors occur when participants incorrectly write output and wrong in writing the result of the count. In addition, factors that caused these errors are 1) participants were not trained in providing information that was in the problem, 2) participants did not read the instructions in the problem correctly, and 3) participants did not pay attention to the suitability of syntax and output as was learned before. This research can be a reference for lecturers to develop learning about programming languages that can make students understand the use of syntax with the emphasis on manual syntax learning which will make their logic easier when applyng the syntax on a computer.

Keywords

Macro Excel; Pre-service Teachers; Analysis Error; Syntax Manually

Full Text:

DOWNLOAD [PDF]

References

Alhassora, N. S. A., Abu, M. S., & Abdullah, A. H. (2017). Newman Error Analysis on Evaluating and Creating Thinking Skills. Man In India, 97(19), 413–427.

Andrews, P., & Sayers, J. (2015). Identifying opportunities for grade one children to acquire foundational number sense: Developing a framework for cross cultural classroom analyses. Early Childhood Education Journal, 43(4), 257–267. https://doi.org/10.1007/s10643-014-0653-6

Ayuningtyas, W., Mardiyana, & Pramudya, I. (2019). Analysis of student’s geometry reasoning ability at senior high school. Journal of Physics: Conference Series, 1188, 1–8. https://doi.org/10.1088/1742-6596/1188/1/012016

Benefit of learning VBA in microsoft excel macro. (2020). TED Learning.

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), 1(1), 45–56. https://doi.org/10.23917/jramathedu.v1i1.6349

Bhawkar, A., Belsare, R., Gandhi, F., & Somani, P. (2013). Analysis of errors - A support system for teachers to analyze the error occurring to a novice programmer. IJCSN International Journal of Computer Science and Network, 2(5), 2277–5420. www.ijcsn.org

Botchkarev, A. (2015). Assessing excel VBA suitability for monte carlo simulation. Spreadsheets in Education (EJSiE), 8(2), 1–30. http://arxiv.org/abs/1503.08376

Dydowicz, P. (2015). Creation and use of internal matrix database functions in VBA MS Excel environment for bulk data processing. Journal of Software and Systems Development, 2015(2015), 1–12. https://doi.org/10.5171/2016.675401

Hadiyanto, F. R., & Wulandari, N. P. (2019). Identifikasi Kesalahan Siswa Kelas VII dalam Menyelesaikan Soal Cerita Geometri dengan Newman’s Procedure. Mandalika Mathematics and Education Journal, 1(2), 1–7.

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, 2(1), 34. https://doi.org/10.31002/ijome.v2i1.1230

McIntosh, A., Reys, B. J., & Reys, R. E. (1992). A Proposed Framework for Examining Basic Number Sense. For the learning of mathematics. For the Learning of Mathematics, 12(3), 2–8. http://area.dgidc.min-edu.pt/materiais_NPMEB/008_Texto_sentido_numero_Mcintosh.pdf

Muttaqi, U. K., Kartono, K., & Dwidayanti, N. K. (2021). Diagnostic analysis of Newman’ s types of students ’ error in finishing questions of mathematical problem solving. Unnes Journal of Mathematics Education Research, 10(1), 32–40.

Newman, M. A. (1977). An analysis of sixfll-grade pupils’ errors on written mathematicaI tasks. Research in Mathematics Education in Australia, 1, 239–258.

Novianti, V., Sa’adah, N., & Chotimah, S. (2019). Pengaruh penggunaan media pembelajaran berbasis VBA for excel terhadap motivasi siswa SD pada materi bangun datar. Journal On Education, 02(01), 110–116.

Oktaviana, D., Newman, K. K., & Diskrit, M. (2017). Analisis tipe kesalahan berdasarkan teori newman dalam menyelesaikan soal cerita pada mata kuliah matematika diskrit. EduSains: Jurnal Pendidikan Sains & Matematika, 5(2), 22–32.

Pang, A., Anslow, C., & Noble, J. (2018). What programming languages do developers use? A theory of static vs dynamic language choice. Proceedings of IEEE Symposium on Visual Languages and Human-Centric Computing, VL/HCC, 239–247. https://doi.org/10.1109/VLHCC.2018.8506534

Pratiwi, D. D. (2015). Analisis Kemampuan Komunikasi Matematis dalam Pemecahan Masalah Matematika Sesuai dengan Gaya Kognitif dan Gender. Al-Jabar: Jurnal Pendidikan Matematika, 6(2), 131–141. https://doi.org/https://doi.org/10.24042/ajpm.v6i2.28

Puspa, S., Riyadi, R., & Subanti, S. (2019). Profile of mathematical communication skills junior high school students in problem solving. Journal of Physics: Conference Series, 1157. https://doi.org/10.1088/1742-6596/1157/3/032125

Ribando, R. (2018). An Excel/visual basic for applications ( VBA ) programming primer. RJ Ribando, 18, 1–19.

Rohmah, M., & Sutiarso, S. (2018). Analysis problem solving in mathematical using theory Newman. EURASIA Journal of Mathematics, Science and Technology Education, 14(2), 671–681. https://doi.org/10.12973/ejmste/80630

Shehane, R., & Sherman, S. (2014). Visual teaching model for introducing programming languages. Journal of Instructional Pedagogy, 14, 1–8. http://www.aabri.com/OC2014Manuscripts/OC14005.pdf

Sophan, M. K., & Kurniawan, A. (2018). Perancangan aplikasi learning by doing interaktif untuk mendukung pembelajaran bahasa pemrograman. Jurnal Teknologi Informasi Dan Ilmu Komputer (JTIIK), 5(4), 455–464. https://doi.org/10.25126/jtiik

Sumule, U., Amin, S. M., & Fuad, Y. (2018). Error analysis of Indonesian junior high school student in solving space and shape content PISA problem using Newman procedure. Journal of Physics: Conference Series, 947, 1–6. https://doi.org/10.1088/1742-6596/947/1/012053

Thuné, M., & Eckerdal, A. (2019). Analysis of Students’ learning of computer programming in a computer laboratory context. European Journal of Engineering Education, 44(5), 769–786. https://doi.org/10.1080/03043797.2018.1544609

Xi-xia, M. A., Feng, W. A. N. G., & Qiao-hua, M. A. (2003). Application of VBA in the Optimal Selection of Hydrologic Statistic Parameters. Journal of Zhengzhou University(Engineering Edition), 24(2), 67–69.

Xia, B. S. (2017). An in-depth analysis of learning goals in higher education: Evidence from the programming education. Journal of Learning Design, 10(2), 25. https://doi.org/10.5204/jld.v10i2.287

Yan, W., & Hongliang, H. (2012). Hydropower Computation Using Visual Basic for Application Programming. Physics Procedia, 24, 37–43. https://doi.org/10.1016/j.phpro.2012.02.007

Yunus, J., Zaura, B., & Yuhasriati, Y. (2019). Analysis of Students Error According to Newman in Solving Mathematics Problems of Algebra in The Form of Story in Second Grade of SMPN 1 Banda Aceh. Jurnal Geuthèë: Penelitian Multidisiplin, 2(2), 308–313.

DOI: https://doi.org/10.31764/jtam.v5i1.3313