Canvas Attendance

1. Go Settings and Course Details scroll to
2. Click the checkbox to “ Enable course grade scheme ” then click on “view grading scheme”
3. Once in the View Grading Scheme screen click on “ manage grading schemes ” at the bottom
4. Once on the Manage screen click on “ +Add grading scheme ”
   Note: This example is based on 32 class meetings (2x week for 16 week) sessions, yours may vary.

Be sure to un-check “ Enable course grade scheme ” after you have set up your Attendance grading schema.

Canvas lets you run “ Attendance Reports ” for your course that you can download (sends to email) and open in Excel. When email is received, click link (it is a very long link ) and select Open in Excel

Excel Spreadsheet
You can set up and use a Pivot Table in Excel that quickly gives you the detail you need in an understandable format in just “three” steps.

1. Select (highlight) range that includes column heading/detail for Student, Class Date, and Attendance
2. Select from the Menu ribbon, Insert, Pivot Table (don’t need to change any defaults) and click OK . A new sheet opens and displays the empty Pivot Table with the selected columns to the right.

• Select and drag Student Name field down to Rows
• Select and drag Attendance field to Rows (under Student Name) and finally
• Select and drag the Attendance field (again) to Value
  ( Note: Even though the Class Date is not selected it is needed to compile information)

3. The worksheet now displays each student with the count of absences, late, and present