For an overview of my research, ideas and projects related to student participation, please see:
My 2020 OTJ presentation (recorded Zoom session) from the days I preferred Zoom polls over direct chat messages. This video includes a literature review that I might skip in this PanSIG presentation.
The MOARS project (Mobile Audience Response System), an open-source classroom response system I released in 2010, created for iPod Touch and able to be used on any HTML browser (including the old gara-kei Japanese flipphones). This sytem had some limited success, but the biggest obstacle was the difficulty of installing it onto your own server.
Captur Paddles, a low tech classroom response system I co-designed with Paul Shimizu. It's an A-B-C-D paddle with colors and shapes that bear a remarkable resemblance to Kahoot! but predates it by at least four years. (The MOARS system also shares a feature with Kahoot: enter activity numbers to access your activity; again, four years earlier.)
Open the "zoom-transcript-tally-master.xlsx" file in Excel. If you don't have your own data, use the files I've provided.
In "Sheet 1", paste the Student IDs. This assumes a 6-character ID that students use in Zoom.
In the "Transcript Paste" sheets, click in the A1 cell, and paste the whole Zoom transcript.
Look at the corresponding "Transcript Format" sheet to award points to chat contributions. "FALSE" in the same row as a Student ID means that this ID does not appear on "Sheet 1".
Look at "Sheet 1" to see the tallies of chat messages and points you've awarded.
Example
After you paste your Zoom chat transcript into sheet "Transcript 1 Paste", it will look like the image below. Note that Zoom uses two rows per comment, and this is reflected in how it gets pasted (and affects how the "Formatted" sheet looks, too).
After you paste the trascript, look at Transcript 1 Formatted (below). You can see the student ID, time, and answer have been automatically put into their respective columns. The "Points" column is where the teacher can add points for comments. Every other line is blank because Zoom splits each comment into two lines; removing this is straightforward but impractically time-consuming. The "Check" column will show "TRUE" if the Student ID appears on Sheet 1, and "FALSE" if the student's name on this trascript does not match the name they're supposed to use in Zoom.
In the image below of Sheet 1, "T 1 Count" shows the number of comments made by each student in the first transcript. "T 1 Points" shows the total points awarded to the student in the "Trascript 1 Formatted" sheet. The reason the points totals are lower than the number of contributions is that some contributions may be simple greetings, messages (e.g., "My mic is not working"), or wrong answers.
The downloadable file is good for only three transcripts; if you want to do more, the formulas are below.
Formulas
Formulas for file Transcript X Formatted (change X to a number; paste into the formula bar for the cells in Row 2; copy paste cells down the column to row 1400)
Formulas for file Sheet 1 (change X to a number; paste into the formula bar for the cells in Row 2; copy paste cells down the column; the new sheet name will also need to be Transcript X Formatted)
This counts how many chat contributions were made by each student using COUNTIF and VLOOKUP.
This totals up the points you've awarded to each student, and supresses error reports for students who were absent that session.
