Teaching Macro Excel on Pre-service Mathematics Teachers: Analysis Error in Solving the Syntax Manually
DOI:
https://doi.org/10.31764/jtam.v5i1.3313Keywords:
Macro Excel, Pre-service Teachers, Analysis Error, Syntax ManuallyAbstract
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 2nd 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.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.
Downloads
Published
Issue
Section
License
Authors who publish articles in JTAM (Jurnal Teori dan Aplikasi Matematika) agree to the following terms:
- Authors retain copyright of the article and grant the journal right of first publication with the work simultaneously licensed under a CC-BY-SA or The Creative Commons Attribution–ShareAlike License.
- 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).
