Roll Call Attendance Reports

	A	B	C
1	This sheet uses pivot tables in Google Sheets to summarize your attendance report generated by Roll Call Attendance
2
3	Step 1	Get your attendance report
4		Details for this are here:	https://community.canvaslms.com/docs/DOC-10433-4152107417
5		You will be notified via email when the report is ready.
6
7	Step 2	Click on the link in the email and save the file. (It will have a .csv file extension.)
8
9	Step 3	-OPEN your attendance report CSV file. Since you already must have a Google Drive account to have used this shared sheet that you are on, you might as well open it in Google Sheets.
10		-Go to File>>Open in Google Sheets, and then click Upload. (Don't worry, it will not affect this sheet; it will open in a new tab.) Navigate to your downloaded attendance report CSV file and open it.
11
12	Step 4	-Select ALL cells in the spreadsheet. A quick way to do this in Google Sheets is to click on the blank "button" in the upper left, right between the A and the 1:
13
14
15
16
17
18		-After all cells are selected, click EDIT>>COPY
19
20	Step 5	-Switch to this copied Google Sheet.
21		-Go to the OriginalCSVData tab.
22		-Click in cell A1 (it likely is already the active cell for you; it is first empty cell in the sheet) and PASTE the copied contents into the OriginalCSVData sheet
23		-It may take a few seconds to paste properly, especially if you had a big report.
24
25	Step 6	Click on the other tabs in this sheet for your data. Here is what they do:
26
27		NumTimesPresentAbsent takes your list of students in alpha order and indicates the total number of times they were Present/Absent/Tardy, based on your markings in Roll Call Attendance
28		ListofDaysPresentAbsent takes your list of students in alpha order and lists, for each student, each date you took attendance and whether they were present or absent
29		RecordedDaysbyStudentName makes it easier to see if you missed taking attendance for student(s). It displays all dates you took attendance. If a cell(s) is not colored green with the number 1 in it, it means you forgot to take attendance for that student that day.
30		Because of the potential horizontal length of RecordedDaysbyStudentName, I have FROZEN the names of the students in column A.
31
32	Step 7	-If you are concerned about privacy, after you noted your data DELETE everything on the OriginalCSVData sheet by again selecting ALL cells (see Step 4) and then clicking Edit>>Delete Values
33		-All data will be removed, including from the other tabs
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100