Spreadsheet: 489218d1479146230-conditional-formatting-student-target-grades-with-actual-grades-four-colours-gradesheetv2
Sheet: Master

Departmental Tracking ART 2016-2017
Personal  Information |  |  |  |  | [NAME]
Year | Surname | Forename | Set | Art Target Grade | Assessment 1 | Assessment 2 | Assessment 3 | CHRISTMAS REVIEW | Assessment 1 | Assessment 2 | Assessment 3 | EASTER REVIEW | Assessment 1 | Assessment 2 | Assessment 3 | SUMMER REVIEW
R14 |  |  |  | A | A* | A | B | C | D | E | F | G |  |  |  |  | Grade | Point
R14 |  |  |  | A | A* | A | B | C | D | E | F | G |  |  |  |  | A* | 8
R14 |  |  |  | A |  |  |  |  |  |  |  |  |  |  |  |  | A | 7
R14 |  |  |  | A |  |  |  |  |  |  |  |  |  |  |  |  | B | 6
R14 |  |  |  | A |  |  |  |  |  |  |  |  |  |  |  |  | C | 5
R14 |  |  |  | A |  |  |  |  |  |  |  |  |  |  |  |  | D | 4
R14 |  |  |  | A |  |  |  |  |  |  |  |  |  |  |  |  | E | 3
R14 |  |  |  | A |  |  |  |  |  |  |  |  |  |  |  |  | F | 2
R14 |  |  |  | A |  |  |  |  |  |  |  |  |  |  |  |  | G | 1
R14 |  |  |  | A
R14 |  |  |  | A
R14 |  |  |  | A
R14 |  |  |  | C
R14 |  |  |  | B
R14 |  |  |  | A
R14 |  |  |  | A
R14 |  |  |  | A
R14 |  |  |  | B
R14 |  |  |  | C
R14 |  |  |  | B
R14 |  |  |  | D
R14 |  |  |  | B
R14 |  |  |  | A
R14 |  |  |  | A*
R14 |  |  |  | A*
R14 |  |  |  | A*
R14 |  |  |  | A*
R14 |  |  |  | A*
R14 |  |  |  | A*
R14 |  |  |  | A*
R14 |  |  |  | A*
R14 |  |  |  | B
R14 |  |  |  | C
R14 |  |  |  | C
R14 |  |  |  | C
R14 |  |  |  | B
R14 |  |  |  | B
R14 |  |  |  | B
R14 |  |  |  | A
R14 |  |  |  | A
R14 |  |  |  | A
R14 |  |  |  | A
R14 |  |  |  | A*
R14 |  |  |  | A*
R14 |  |  |  | B
R15 |  |  |  | A
R15 |  |  |  | A
R15 |  |  |  | A
R15 |  |  |  | A
R15 |  |  |  | B
R15 |  |  |  | A
R15 |  |  |  | A
R15 |  |  |  | A
R15 |  |  |  | A
R15 |  |  |  | A
R15 |  |  |  | A
R15 |  |  |  | A
R15 |  |  |  | A
R15 |  |  |  | A
R15 |  |  |  | A
R15 |  |  |  | A
R15 |  |  |  | A
R15 |  |  |  | A*
R15 |  |  |  | A*
R15 |  |  |  | A*
R15 |  |  |  | A*
R15 |  |  |  | A*
R15 |  |  |  | B
R15 |  |  |  | C
R15 |  |  |  | D
R15 |  |  |  | E
R15 |  |  |  | C
R15 |  |  |  | C
R15 |  |  |  | B
R15 |  |  |  | B
R15 |  |  |  | B
R15 |  |  |  | B
R15 |  |  |  | B
R15 |  |  |  | B
R15 |  |  |  | B
R15 |  |  |  | B
R15 |  |  |  | A
R15 |  |  |  | A
R15 |  |  |  | A
R15 |  |  |  | A
R15 |  |  |  | A
R15 |  |  |  | A
R15 |  |  |  | A
R15 |  |  |  | A
R15 |  |  |  | B
R15 |  |  |  | A
R15 |  |  |  | A*
R15 |  |  |  | A*
R15 |  |  |  | A*
R15 |  |  |  | A*
R15 |  |  |  | A
R15 |  |  |  | A
R15 |  |  |  | A
R15 |  |  |  | A
R15 |  |  |  | A
R15 |  |  |  | A
R15 |  |  |  | A
R16 |  |  |  | A
R16 |  |  |  | A
R16 |  |  |  | A
R16 |  |  |  | A
R16 |  |  |  | A
R16 |  |  |  | A
R16 |  |  |  | A
R16 |  |  |  | A
R16 |  |  |  | B
R16 |  |  |  | B
R16 |  |  |  | B
R16 |  |  |  | B
R16 |  |  |  | B
R16 |  |  |  | C
R16 |  |  |  | C
R16 |  |  |  | A
R16 |  |  |  | B
R16 |  |  |  | A
R16 |  |  |  | B
R16 |  |  |  | C
R16 |  |  |  | A
R16 |  |  |  | B
R16 |  |  |  | B
R16 |  |  |  | B
R16 |  |  |  | B
R16 |  |  |  | B
R16 |  |  |  | C
R16 |  |  |  | D
R16 |  |  |  | C
R16 |  |  |  | A
R16 |  |  |  | A*
R16 |  |  |  | A*
R16 |  |  |  | A*
R16 |  |  |  | C
R16 |  |  |  | C
R16 |  |  |  | C
R16 |  |  |  | A