Attendance Reports Are Not Clear

[chabotnutrition]

When using the Attendance/Roll Call feature, and you ask for an attendance report for the entire class, it sends the report as an Excel document. However, the document doesn't show the columns in the correct order. For instance, it shows the students that were enrolled on one day, and not another, and it is all shown vertically, instead of horizontally, so it's practically impossible to run a report with, say, 10 days of attendance, and try to find which students missed which date of attendance, and which student did not, since the roll call file has each date separately, but vertically, and the students names are listed in sets of dates... it's hard to explain unless you do it and see it. I attached an example, removing students' names, but what is an easy way to tell which student missed one day or another?

[kblack · Accepted solution]

Hi  @chabotnutrition  Welcome to the Canvas Community.  This is an issue for lots of folks; so much so that I finally wrote a couple of documents that address this problem.  I don't like to self-promote, but in this case I'm pretty sure one of these will answer your question.  One document covers the nuts and bolts from an Excel perspective; the other is a Google spreadsheet that you can download that will do all of the work for you since the formulas you need are embedded within it:

• Using the Roll Call Report: A Guide for People Who Do Not Use Excel 
• Easy to Use Google Sheet for Interpreting Your Roll Call Attendance Report 

I hope one of these two helps, Begonia.