The code assumes that zoomdata.do is in the working directory, which also has:Ī folder named “rosters” which has in it “roster.xlsx”. Stata will not modify the original roster file but will generate two new files (or over-write existing files) containing the output: “roster_with_attendance.dta” and “roster_with_attendance.xlsx”, in Stata and Excel format. To help check for situations where this is not the case, it generates a log file, “unknown_email.txt”. It will only work well if students are required to log into Zoom with the same email address that is in the roster file. It uses the student’s email address to match Zoom reports with the roster. (It does not judge whether students’ poll responses were “correct” or not, just whether any were submitted.) It also records attendance at weekly sections, which take place on various days. It then uses this information to calculate a simple 1-or-0 score for attendance that day. For each Zoom lecture it determines, for each student, the total number of minutes spent logged into Zoom, the number of log-ins, and whether the student submitted at least one answer to Zoom polls. This do-file takes attendance and poll reports produced by Zoom and merges them into a student roster. See here for a new version that scores correct answers to quizzes that the instructor gives via Zoom’s poll feature, rather than merely using poll data to check on attendance.) Hope it helps! please like and mark this as solution so whenever someone has the same question this content will help.Merge Zoom Attendance and Poll Reports into Student Roster, via Stata Once the report has been generated, it will automatically download and can be opened in Excel, Notepad, or any other application compatible with the CSV format. Select the webinar, then click Generate CSV Report. Note : Attendee, Performance, Q&A, Poll, and Survey reports are available after the webinar has ended.Įnter the date range for the webinar and click Filter, or enter the Webinar ID number and click Search. Select the Report Type you would like to search for.If you are an account owner or admin, or have access to the Usage Report role, you will need to select Account Management and then Reports. In the navigation menu, click Reports.

You can generate the webinar report with step below ' How to generate webinar reports

Zoom webinar reports