[ARCHIVED] Is there a simple way to view how many absences each student has?

[njacoberger]

I downloaded the report but the excel spreadsheet is a mess - it lists every student's attendance by date in a giant list. I need a way to see absences only, not attendances. With 300 students, this is an impossible way to count total absences at the end of the semester. 

[kblack · Accepted solution]

Hi  @njacoberger  Welcome to the Canvas Community. I feel your pain....and that of my own faculty, as well. Because of that, I contributed two things to this Community that may assist you that try to help matters along.  The easiest is this one, especially if you want this done immediately:  Easy to Use Google Sheet for Interpreting Your Roll Call Attendance Report . The other explains how to do things yourself using Excel, if you're interested:  https://community.canvaslms.com/docs/DOC-6802-using-the-roll-call-report-a-guide-for-people-who-do-n... .  Hopefully one of these will help.

[njacoberger]

Thank you, Ken. It seems that I am not alone here!