Spreadsheet: 191669d1352177135-what-to-use-in-place-of-if-data-tracker-with-pivot-table-for-upload2
Sheet: SummarySheet

Assessments | 001-Border | 002-T-Square | 003-Lettering | 004-Triangle | 005-Compass
Date | 2012-11-01 00:00:00 | 2012-11-01 00:00:00 | 2012-11-02 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
Total Class Average 0-5 Range | 3.15 | 4 | 3 | 2 | 1
Total Class Average in percentage | 0.63 | 0.8 | 0.6 | 0.4 | 0.2
Class Average of Students that took assessment | 3.5 | 4 | 3 | 2 | 1
Class Average of Students that took assessment in percentage | 0.7 | 0.8 | 0.6 | 0.4 | 0.2
# of students that took assessment | 18 | 20 | 20 | 20 | 20
81-100 | 4 | 0 | 0 | 0 | 0
61-80 | 7 | 20 | 0 | 0 | 0
41-60 | 3 | 0 | 20 | 0 | 0
21-40 | 2 | 0 | 0 | 20 | 0
1-20 | 2 | 0 | 0 | 0 | 20
Not Taken | 2 | 0 | 0 | 0 | 0
List of students that received a 81-100 rating | Last, Student11 | Last, Student12 | Last, Student13 | Last, Student18
Percentage of students that took assessment and received 81-100 | 0.2222222222222222 | 0 | 0 | 0 | 0
List of students that received a 61-80 rating | Last, Student2 | Last, Student10 | Last, Student14 | Last, Student16 | Last, Student17 | Last, Student19 | Last, Student20 | Last, Student1 | Last, Student2 | Last, Student3 | Last, Student4 | Last, Student5 | Last, Student6 | Last, Student7 | Last, Student8 | Last, Student9 | Last, Student10 | Last, Student11 | Last, Student12 | Last, Student13 | Last, Student14 | Last, Student15 | Last, Student16 | Last, Student17 | Last, Student18 | Last, Student19 | Last, Student20
Percentage of students that took assessment and received 61-80 | 0.3888888888888889 | 1 | 0 | 0 | 0
List of students that received a 41-60 rating | Last, Student3 | Last, Student9 | Last, Student15 |  | Last, Student1 | Last, Student2 | Last, Student3 | Last, Student4 | Last, Student5 | Last, Student6 | Last, Student7 | Last, Student8 | Last, Student9 | Last, Student10 | Last, Student11 | Last, Student12 | Last, Student13 | Last, Student14 | Last, Student15 | Last, Student16 | Last, Student17 | Last, Student18 | Last, Student19 | Last, Student20
Percentage of students that took assessment and received 41-60 | 0.1666666666666667 | 0 | 1 | 0 | 0
List of students that received a 21-40 rating | Last, Student4 | Last, Student8 |  |  | Last, Student1 | Last, Student2 | Last, Student3 | Last, Student4 | Last, Student5 | Last, Student6 | Last, Student7 | Last, Student8 | Last, Student9 | Last, Student10 | Last, Student11 | Last, Student12 | Last, Student13 | Last, Student14 | Last, Student15 | Last, Student16 | Last, Student17 | Last, Student18 | Last, Student19 | Last, Student20
Percentage of students that took assessment and received 21-40 | 0.1111111111111111 | 0 | 0 | 1 | 0
List of students that received a 1-20 rating | Last, Student5 | Last, Student7 |  |  |  | Last, Student1 | Last, Student2 | Last, Student3 | Last, Student4 | Last, Student5 | Last, Student6 | Last, Student7 | Last, Student8 | Last, Student9 | Last, Student10 | Last, Student11 | Last, Student12 | Last, Student13 | Last, Student14 | Last, Student15 | Last, Student16 | Last, Student17 | Last, Student18 | Last, Student19 | Last, Student20
Percentage of students that took assessment and received 1-20 | 0.1111111111111111 | 0 | 0 | 0 | 1
List of students who did not take assessment. | Last, Student1 | Last, Student6
Total percentage of students that did NOT take assessment | 0.1 | 0 | 0 | 0 | 0