I'm looking for ideas for the best way to record attendance from a magnetic card reader. When the card is read, a list of students who are present is created in Excel. Here's what the faculty member currently is doing:
- Get the Excel output (which only has the present students)
- Upload it to Canvas Grades (this clearly shows which students are present and absent)
- Download the Canvas grades
This works well in some ways but it fills the Grades area with many, many assignments that don't actually count toward the grade. Even Muting the assignments doesn't help, since they still take up columns. The faculty can't just mark the attendance as "Ungraded" since it then doesn't export in the CSV file.
What would you suggest as the best approach? Keep in mind that the course in question typically has 50+ students.