Generating reports is a key functionality of the Attendance Taker for Google Calendar app. Here are the steps to follow to generate a report:
Open Google Calendar.
Select Attendance Taker from the sidebar on the right.
Click on the Attendance Report button.
Under Choose meeting type select Other meetings > Generate report.
Select a date range by picking dates for the columns Since and Until.
Click Generate report.
The report is initially generated using a predefined template. To expedite the generation process, select Export the report in raw format option by clicking the corresponding checkbox.
By default, the report is generated for all students in the class. You can exclude certain students by selecting Customize in the Attendees section.
Click Generate Report.
A report is generated in Google Sheets and you will be redirected to the report in a new tab. Below is a sample report generated with the Export the report in raw format checkbox option checked.
Every student's attendance is displayed in detail in separate rows.
The rate column displays students' attendance rate as a percentage.
A rate of 100 means full attendance.
The date and time columns display the dates chosen in the date range, along with the meeting start times.
In the subsequent rows, the date and time columns display students' join time, or "absent" if they did not join.
Depending on how much data is generated within the report, you may receive a message that your report is still being processed, and may take a few minutes. You can always check the status of the report by clicking on View reports, the report should be ready in just a few minutes.
In Google Sheets, you can choose to download the report in .xlsx (Excel) format by clicking File > Download > Microsoft Excel(.xlsx)