Using Microsoft Excel for Lesson Transcript Analysis
DOI:
https://doi.org/10.5564/lavai.v21i32.4030Keywords:
lesson analysis, transcript-based lesson analysis, analysis, toolsAbstract
Transcript-Based Lesson Analysis (TBLA) involves transcribing entire lesson recordings into verbatim notes, followed by both quantitative and qualitative analyses to derive meaningful conclusions. This process demands substantial effort and time on the part of the researcher. For example, the researcher must listen to the lesson recording multiple times and transcribe every word spoken by both the teacher and students verbatim, ensuring complete accuracy without omissions or errors. Therefore, automating the TBLA process is essential not only for enhancing the reliability and accuracy of research findings but also for improving researcher productivity. This study introduces an automated digital tool for Transcript-Based Lesson Analysis (TBLA), developed using Microsoft Excel’s Visual Basic for Applications (VBA) and graphical user interface (GUI) functionalities. We applied the tool to analyze an 11th-grade mathematics lesson, demonstrating that the use of this automated digital tool not only facilitates the researcher’s workload but also enhances the validity and reliability of the results. In the future, the application of this digital tool can be expanded to enhance the outcomes of lesson analysis, facilitate lesson sensitivity analysis, and support the development of data-driven approaches in educational research.
Downloads
157
References
Arani, M. R. S., Yoshiaki Shibata, Sakamoto, M., Iksan, Z., Haziah, A., Amirullah, H., Bruce Lander, & Lander. (2017). How teachers respond to students ’ mistakes in lessons : a cross cultural analysis of a mathematics lesson Article information : To cite this document : Users who downloaded this article also downloaded : About Emerald www.emeraldinsight.com. International Journal of Lesson and Learning Studies.
Fernandez, C., Cannon, J., & Chokshi, S. (2003). A US-Japan lesson study collaboration reveals critical lenses for examining practice. In Teaching and Teacher Education (Vol. 19, Issue 2, pp. 171–185). Elsevier Ltd. https://doi.org/10.1016/S0742-051X(02)00102-6
Ganbaatar, T. (2016). Lesson study and future trends. In Teaching methodology for supporting child development - 2014 (p. 24).
Jadamba, B., Ganbaatar, T., & Gereltuya, Ts. (2022). An approach and application of note-based analysis (Case of mathematics lesson in general education). Journal of Mathematics and Natural Sciences, (7/2022). ISSN 2709-2259.
Lee, H. N. (2025). ChatGPT, Python, and Microsoft Excel. ChatGPT. Evidence-Based Medicine, 8(2), 38. https://doi.org/dx.doi.org/10.5195/jmla.2025.2065 110
Nozaki, S. (2022). The study of students’ discussion process in a teacher-developed problem-solving learning design: Transcript-based lesson analysis of a social studies lesson. International Journal for Lesson and Learning Studies, 11(4), 305–317. https://doi.org/10.1108/IJLLS-05-2022-0072
Narayana, D., Ranjan, S., & Tyagi, N. (2023). Basic Computational Techniques for Data Analysis: An Exploration in MS Excel (2nd ed.). Routledge India. https://doi.org/10.4324/9781003398127
Reza, M., Arani, S., Shibata, Y., Lee, K. C., Kuno, H., Matoba, M., Lay, F., John, L., Reza, M., Arani, S., Shibata, Y., Lee, K. C., Kuno, H., Matoba, M., Lay, F., John, L., Studies, L., Brosnan, A., Studies, L., … Ko, P. Y. (2014). Article information :
Tan, S., Goei, S. L., & Willemse, T. M. (2024). Global insights on lesson study in initial teacher education: A systematic literature review encompassing English, Japanese, and Chinese language sources. Teaching and Teacher Education, 152(September), 104791. https://doi.org/10.1016/j.tate.2024.104791
Tan, S., Nozaki, S., Fu, H., & Shibata, Y. (2021). The principles of teacher ’ s decision-making in Japanese board writing ( bansho ) process. Asia Pacific Journal of Education, 00(00), 1–16. https://doi.org/10.1080/02188791.2021.1924119
Yoshida, N., Matsuda, M., & Miyamoto, Y. (2021). Characteristics and Challenges of Lesson Study and Lesson Analysis of Learning Group Formation ( Gakushu Shudan Zukuri ). 2, 175–184.
Zamawe, F. C. (2015). The implication of using NVivo software in qualitative data analysis: Evidence-based reflections. Malawi Medical Journal, 27(1), 13–15. https://doi.org/10.4314/mmj.v27i1.4
Published
How to Cite
Issue
Section
License
Copyright (c) 2025 Gereltuya Tsereljav, Ganbaatar Tumurbaatar, Jadamba Badrakh , Battogtokh Tsiyen-Oidov
This work is licensed under a Creative Commons Attribution 4.0 International License.
Copyright on any research article in the Lavai - International Journal of Educatioin is retained by the author(s).
The authors grant the Lavai - International Journal of Educatioin a license to publish the article and identify itself as the original publisher.
Articles in the Lavai - International Journal of Educatioin are Open Access articles published under a Creative Commons Attribution 4.0 International License CC BY.
This license permits use, distribution and reproduction in any medium, provided the original work is properly cited.
