[Attendance] Making Attendance Downloads a little less noisy

Problem statement:

I have to present an attendance sheet at the end of every term. When we used Moodle, I used excel, because the Moodle gradebook is not at all intuitive. With our conversion to canvas, I decided to go all in on the gradebook and attendance. While I would prefer if the gradebook had a way to filter out graded discussions, that is a conversation for another day. But when I downloaded my attendance, I got a ton of useless information that took me several hours to condense into a simple list with my students running vertically down the first two columns and the dates across the second row, with their absences, presents, and lates put into the proper position on the grid.

Proposed solution:

I would propose a filter that would create a matrix as described above, a simplified gradebook without the extraneous information that detracts from the reason we take attendance: to find out who was there, who was not there, and who came in late.

User role(s):

instructor

Added to Theme

2 Comments
HankBordowitz
Community Member
Author

A sample of your Attendance Report:

Course ID SIS Course ID Course Code Course Name Section Name Section ID SIS Section ID Teacher ID Teacher Name Student ID Student Name Class Date Attendance Timestamp  
7354 202532 WRT-201-103HY.2023S2 Summer II 2023 English Composition II (WRT-201-103HY) Summer II 2023 English Composition II (WRT-201-103HY) 7540 202532 465 Hank Bordowitz 5208 Stephen Crocitto 6/29/2023 present 2023-06-29 16:38:37 UTC
7354 202532 WRT-201-103HY.2023S2 Summer II 2023 English Composition II (WRT-201-103HY) Summer II 2023 English Composition II (WRT-201-103HY) 7540 202532 465 Hank Bordowitz 21129 Chris Hernandez 6/29/2023 present 2023-06-29 16:39:02 UTC
7354 202532 WRT-201-103HY.2023S2 Summer II 2023 English Composition II (WRT-201-103HY) Summer II 2023 English Composition II (WRT-201-103HY) 7540 202532 465 Hank Bordowitz 6820 Erika Alvarez 6/29/2023 present 2023-06-29 16:38:30 UTC
7354 202532 WRT-201-103HY.2023S2 Summer II 2023 English Composition II (WRT-201-103HY) Summer II 2023 English Composition II (WRT-201-103HY) 7540 202532 465 Hank Bordowitz 21600 Julia Jonas 6/29/2023 present 2023-06-29 16:39:05 UTC
7354 202532 WRT-201-103HY.2023S2 Summer II 2023 English Composition II (WRT-201-103HY) Summer II 2023 English Composition II (WRT-201-103HY) 7540 202532 465 Hank Bordowitz 1080 Sage Reyes 6/29/2023 present 2023-06-29 16:39:16 UTC
7354 202532 WRT-201-103HY.2023S2 Summer II 2023 English Composition II (WRT-201-103HY) Summer II 2023 English Composition II (WRT-201-103HY) 7540 202532 465 Hank Bordowitz 9468 Richard Wolf 6/29/2023 present 2023-06-29 16:39:39 UTC
7354 202532 WRT-201-103HY.2023S2 Summer II 2023 English Composition II (WRT-201-103HY) Summer II 2023 English Composition II (WRT-201-103HY) 7540 202532 465 Hank Bordowitz 2251 Paula Rodriguez 6/29/2023 present 2023-06-29 16:39:19 UTC
7354 202532 WRT-201-103HY.2023S2 Summer II 2023 English Composition II (WRT-201-103HY) Summer II 2023 English Composition II (WRT-201-103HY) 7540 202532 465 Hank Bordowitz 16825 Joanne Alexis Tinsay 6/29/2023 present 2023-06-29 16:48:53 UTC
7354 202532 WRT-201-103HY.2023S2 Summer II 2023 English Composition II (WRT-201-103HY) Summer II 2023 English Composition II (WRT-201-103HY) 7540 202532 465 Hank Bordowitz 13192 Ciaran Cronogue 6/29/2023 present 2023-06-29 18:15:18 UTC
7354 202532 WRT-201-103HY.2023S2 Summer II 2023 English Composition II (WRT-201-103HY) Summer II 2023 English Composition II (WRT-201-103HY) 7540 202532 465 Hank Bordowitz 1080 Sage Reyes 7/6/2023 present 2023-07-06 16:33:16 UTC
7354 202532 WRT-201-103HY.2023S2 Summer II 2023 English Composition II (WRT-201-103HY) Summer II 2023 English Composition II (WRT-201-103HY) 7540 202532 465 Hank Bordowitz 5208 Stephen Crocitto 7/6/2023 present 2023-07-06 16:33:00 UTC
7354 202532 WRT-201-103HY.2023S2 Summer II 2023 English Composition II (WRT-201-103HY) Summer II 2023 English Composition II (WRT-201-103HY) 7540 202532 465 Hank Bordowitz 21600 Julia Jonas 7/6/2023 present 2023-07-06 16:33:09 UTC

There were 130 lines like that, and as you will see with the next graph, that was for eleven students in a shortened term class.

Here is a sample of what I, and I imagine most people, would want to see:

WRT-201-103HY SU23                      
Student   6/29/2023 7/6/2023 7/11/2023 7/13/2023 7/18/2023 7/20/2023 7/25/2023 7/27/2023 8/1/2023 8/3/2023 8/8/2023
Alexis-Tinsay  Joanne  present present present present present present late late present present present
Alvarez  Erika present present present present absent present present late late late late
Crocitto  Stephen present present present present present absent absent absent late late present
Cronogue  Ciaran present present present late late late late present late present late
Hernandez  Chris present present present present present present present present present present present
Jonas  Julia present present present present present late late present present present present
Jones  Yasmine absent present present present present present present present present absent present
Reyes  Sage present present present present present present present late late present present
Rodriguez  Paula present present present present present present present present present present present
Trivedi  Kunal absent absent absent absent absent absent absent absent absent absent absent
Wolf  Richard present present present late present present late present present late present

 

jpoulos
Instructure Alumni
Instructure Alumni
Status changed to: Added to Theme

I've added this to the Roll Call Attendance improvements theme