Zoom chat analysis tool v 1.2

Bill Pellowe, Kindai Univerity

• Session title: Quickly Analyze Zoom Transcripts for Data on Student Participation
• Sunday, June 4th, 2023, 2:10 PM-2:40 PM
• JALTCALL2023 Conference

Click here to create your own copy in Google Sheets of the Zoom chat analysis tool v 1.2

The student IDs in the data sample files have been changed to protect student privacy. Download the sample files.

• students.txt (paste into "Students" sheet)
• meeting_saved_chat_1.txt (paste into Transcript 1 Paste sheet)
• meeting_saved_chat_2.txt (paste into Transcript 2 Paste sheet)
• meeting_saved_chat_3.txt (paste into Transcript 3 Paste sheet)

How to paste transcripts, and how to add new sheets: