Treffer: Using Microsoft Excel for Lesson Transcript Analysis.

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. [ABSTRACT FROM AUTHOR]

Copyright of Lavai: International Journal of Education is the property of Mongolian National University of Education and its content may not be copied or emailed to multiple sites without the copyright holder's express written permission. Additionally, content may not be used with any artificial intelligence tools or machine learning technologies. However, users may print, download, or email articles for individual use. This abstract may be abridged. No warranty is given about the accuracy of the copy. Users should refer to the original published version of the material for the full abstract. (Copyright applies to all Abstracts.)