...
- Go to Attendance in your Course Navigation menu.
- Click on the Settings icon from and select Attendance Report.
- Specify your dates, and then click RUN REPORT. There are three options that you can use to download the reports:
- Specify the same Start date and End Date, the report will be generated for every class. This option is useful if you maintain an Excel attendance sheet outside of Canvas. Copy the column M from your downloaded report and paste into your Excel attendance sheet.
Specify a date range for the report. This is useful, if you want to look at attendance reports for specific period (e.g., weeks 1-7; weeks 8-13)
Leave the date fields blanks, the report will be generated for the entire course.
The report is sent to your email and can be downloaded as a (CSV) file.
You may need to use the Insert Pivot Table option in downloaded Excel report to quickly get a tabulation of the attendance by Dates. Follow the steps below:
Select the entire sheet of the downloaded CSV report or you may simply select all the columns in the sheet.
Click on Insert > Pivot Table.
Now select New worksheet option and click ok.
From the Pivot Table fields on your, drag Student Name into Rows; drag Class Date into Columns; and drag Attendance into Values to achieve the desired result.
(See a sample screenshot)
