Student Difficulties and Teacher Strategies in Learning Accounting Spreadsheets
Kesulitan Siswa dan Strategi Guru dalam Mempelajari Spreadsheet Akuntansi
-
(1) * Diyana Pangestuti
Keguruan dan Ilmu Pendidikan, Universitas Muhammadiyah Surakarta
Indonesia
(2) Moh. Chairil Asmawan Keguruan dan Ilmu Pendidikan, Universitas Muhammadiyah Surakarta
Indonesia
(*) Corresponding Author
Abstract
This study aims to find out: 1) types of student learning difficulties in learning Accounting Spreadsheet at SMK Negeri 1 Salatiga, 2) factors causing learning difficulties, and 3) teacher strategies in overcoming these difficulties. This research uses a qualitative method with a case study approach. Data collection techniques include interviews, observation, and documentation, with triangulation techniques for data validity. The stages of data analysis include data reduction, data presentation, and conclusion drawing. The results showed that: (1) the types of student difficulties are classified as moderate, namely lack of understanding in operating computers and difficulty memorising spreadsheet formulas. (2) Factors causing learning difficulties consist of internal factors such as limited understanding in using computers and memorising formulas, and external factors such as not having a personal laptop and unsupportive devices. (3) Teachers‘ strategies to overcome students’ difficulties include applying learning methods using room passwords and providing routine practice questions.
Highlights:
- Moderate Student Challenges – Students struggle with using computers and memorizing spreadsheet formulas.
- Internal & External Factors – Issues stem from limited skills and lack of personal tech devices.
- Teacher Solutions – Applied room password methods and frequent practice to aid learning.
Keywords: Learning Difficulties, Teaching Strategies, Spreadsheet
References
Anderson, M., & Kalman, A. (2023). Digital workplace skills: Designing the integrated learning of accounting and Microsoft Excel. Accounting and Finance Research, 8(3), 22–35. ttps://doi.org/10.21428/afgr.2023.77593
Ardiansyah, D. (2022). Analisis Kesulitan Belajar Myob Accounting Dalam Mata Pelajaran Komputer Akuntansi (Studi Kasus Pada Kelas Xi Akuntansi Keuangan Dan Lembaga Smk Negeri 1 Purwodadi 2021/2022). Universitas Muhammadiyah Surakarta.
Asmawan, M. C., & Rismawati, R. (2020). Analysis Of Accounting Learning Difficulties In Myob Accounting.
Astriani, A., & Ulfatun, T. (2023). Analisis Kesulitan Belajar Siswa pada Mata Pelajaran Spreadsheet Kelas X AKL di SMK Negeri 1 Sragen. JIIP-Jurnal Ilmiah Ilmu Pendidikan, 6(9), 7053–7058.
Bakhruddin, M., Shoffa, S., Holisin, I., Ginting, S., Fitri, A., Lestari, I. W., Pudyastuti, Z. E., Zainuddin, M., Alam, H. V., & Kurniawati, N. (2021). Strategi Belajar Mengajar. CV. Agrapana Media.
Darman, R. A. (2020). Belajar dan pembelajaran. Guepedia.
Dewi, N. K., Untu, Z., & Dimpudus, A. (2020). Analisis kesulitan menyelesaikan soal matematika materi operasi hitung bilangan pecahan siswa kelas VII. Primatika: Jurnal Pendidikan Matematika, 9(2), 61–70.
Gonzalez, L. A., & Johnson, R. T. (2021). Student preference for spreadsheet-based learning in accounting education. Accounting and Finance Research, 8(3), 16–21. https://doi.org/10.5430/afr.v8n3p16
Haryanti, S., Lastini, F., & Setyaningsih, N. (2024). Analisis Kesulitan Belajar Peserta Didik Sekolah Dasar Terhadap Kemampuan Koneksi Matematis Dalam Statistika. Pendas: Jurnal Ilmiah Pendidikan Dasar, 9(04), 231–249.
Hernandez, M., & Beasley, J. (2021). Analysis of difficulties in learning accounting among senior high students. Asian Journal of Education and Training, 8(1), 1–10. https://doi.org/10.18488/journal.73.2021.8.1.1.10
Johnson, B. G., & Sargent, C. S. (2014). Impact of Formulas, Language and Instruction on Student Performance on Cost-Volume-Profit Problems. Accounting Education, 23(1), 22–41. https://doi.org/10.1080/09639284.2013.824702
Latshaw, C. A., & Hunton, J. E. (2022). Interactive spreadsheeting: A learning strategy and exercises for accounting education. Issues in Accounting Education, 37(2), 45–58. https://doi.org/10.2308/ISSUES-2022-005
Mahdi, H. S., Ahmed, T. M., & Khasawneh, M. (2021). Factors affecting learning performance of accounting information system students. Asian Journal of Finance & Accounting, 10(2), 101–114. https://doi.org/10.5296/ajfa.v10i2.13039
Maryani, I., Fatmawati, L., Erviana, V. Y., Wangid, M. N., & Mustadi, A. (2018). Model intervensi gangguan kesulitan belajar. Ika Maryani.
Ningtyas, E. (2019). Analisis Kesulitan Belajar Myob Accounting Kelas Xi Akuntansi Di Smk Batik 2 Surakarta Tahun 2018/2019. Universitas Muhammadiyah Surakarta.
Rosnawati, S. P. (2021). Teori-teori belajar dan pembelajaran. Penerbit Adab.
Sargent, C. S., & Johnson, B. G. (2021). Getting students ready for accounting spreadsheets: Training for basic spreadsheet skills with pre/post assessments. Issues in Accounting Education, 36(3), 33–47. https://doi.org/10.2308/ISSUES-2021-010
Sugiono, M., & Rohayati, S. (2018). Pengaruh Penggunaan Bahan Ajar E-Book Interaktif, Pemahaman Analisis Transaksi Dan Intensitas Latihan Soal Terhadap Hasil Belajar Siswa Pada Materi Jurnal Khusus Akuntansi Perusahaan Dagang Kelas Xi Smk Negeri 2 Buduran Sidoarjo.
Sugiyono. (2020). Metode Penelitian Kualitatif . Alfabeta.
Suwiji, & Zhafira, N. S. (2020). Cara Menggunakan Google Spreadsheet Secara Offline.
Tan, A. C., & Koh, E. L. (2021). Students’ perceptions of factors contributing to performance in accounting principles courses. International Journal of Higher Education, 10(5), 18–27. https://doi.org/10.5430/ijhe.v10n5p18
Utami, Y. S. (2020). Penggunaan Media Gambar Untuk Meningkatkan Hasil Belajar Siswa Dalam Pembelajaran IPA. Jurnal Pendidikan Dan Konseling (JPDK), 2(1), 104–109.
Widjaja, T., & Santoso, H. B. (2020). Student acceptance of the use of spreadsheet-based accounting applications. Advances in Social Science, Education and Humanities Research, 418, 167–171. https://doi.org/10.2991/assehr.k.200331.033
Copyright (c) 2025 Diyana Pangestuti, Moh. Chairil Asmawan
This work is licensed under a Creative Commons Attribution 4.0 International License.
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 that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.
