Spreadsheet: 90794d1290530826-conditional-formatting-with-a-range-year-10-format
Sheet: year 9 data

 |  | Gender | Gifted and talented | End of Year TA | Target Grade | Religion and Animals % | Religion and Animals Grade | Religion and Prejudice % | Religion and Prejudice Grade | Religion, War and Peace % | Religion, War and Peace Grade
 |  | M |  |  | C
 |  | F
 |  | M | sch |  | A
 |  | F | sch |  | A
 |  | F |  |  | C
 |  | M |  |  | C
 |  | F |  |  | D
 |  | F |  |  | B
 |  | M |  |  | B
 |  | M |  |  | B
 |  | M |  |  | D
 |  | M |  |  | A
 |  | M |  |  | C
 |  | M |  |  | A
 |  | F |  |  | C
 |  | M |  | D | C
 |  | F |  |  | C
 |  | M |  |  | A
 |  | M |  |  | C
 |  | M |  |  | C
 |  | M |  |  | C
 |  | F |  |  | B
 |  | F | sch |  | B
 |  | M |  | D | C
 |  | F |  |  | C
 |  | F
 |  | F |  |  | B
 |  | M |  |  | B
 |  | M |  |  | C
 |  | F |  |  | A
 |  | F | sub |  | B
 |  | M | sch |  | A
 |  | M |  |  | B
 |  |  |  |  | B
 |  | F |  |  | B
 |  | F | sch/sub | A | A
 |  | M |  |  | C
 |  | F |  | B | C
 |  | M
 |  | M |  |  | C
 |  | M |  | D | B
 |  | M |  |  | C
 |  | F |  |  | B
 |  | F |  |  | C
 |  | M |  | A | B
 |  | M |  | B | A
 |  | F |  |  | A
 |  | F |  |  | B
 |  | M |  |  | B
 |  | F |  |  | A
 |  | M |  |  | B
 |  | F | sch/sub |  | A
 |  | M |  | C | B
 |  | M |  | B | B
 |  | M |  |  | B
 |  | F |  |  | A
 |  | F |  | B | B
 |  | F | sch/sub |  | A
 |  | M |  | B | B
 |  | M |  |  | B
 |  | M |  |  | A
 |  | M | sch |  | A
 |  | F |  | B | B
 |  | F |  |  | B
 |  | F |  |  | B
 |  | F |  |  | A
 |  | M |  |  | B
 |  | M |  |  | B
 |  | F |  |  | B
 |  | F |  |  | A
 |  | M |  |  | B
 |  | F |  | B | B
 |  | F |  |  | B
 |  | F | sch/sub | A | A
 |  | F |  | B
 |  | M |  |  | C
 |  | F |  |  | B
 |  | F |  |  | B
 |  | M |  |  | B
 |  | M | sch |  | B
 |  | M |  | B | A
 |  | F | sch | A* | A
 |  | F |  |  | B
 |  | F |  | D | B
 |  | M |  | A | A
 |  | F |  |  | A
 |  | M | sch | A | B
 |  | F |  |  | B
 |  | F |  |  | B
 |  | F |  |  | A
 |  | M | sub |  | A
 |  | F |  | B | B
 |  | F |  | A | B
 |  | F | sub | A* | B
 |  | F |  | A | A
 |  | F |  |  | B
 |  | M |  |  | A
 |  | F |  |  | B
 |  | F |  | B | A
 |  | M |  |  | B
 |  | M |  |  | A
 |  | M |  |  | B
 |  | M |  |  | B
 |  | M |  | A | B
 |  | F |  |  | B
 |  | M |  |  | C
 |  | M |  | B | B
 |  | F |  |  | B
 |  | M |  |  | B |  |  |  |  |  |  |  |  | Attended 2 catch-up sessions to complete work which had not been done in class.
 |  | M |  |  | B
 |  | F |  |  | B
 |  | M |  |  | B
 |  | F |  |  | A
 |  | M |  |  | B
 |  | F |  | C | B
 |  | M | sub | A* | B
 |  | M |  |  | B
 |  | F |  |  | A
 |  | F | sub | A | A*
 |  | F |  |  | A
 |  | M |  |  | B
 |  | F |  |  | B
 |  | M |  |  | B
 |  | F |  | B | B
 |  | F |  | C | B
 |  | F |  |  | B
 |  | F | sch |  | B
 |  | F |  |  | A
 |  | M |  | C | B
 |  | F |  | A* | B
 |  | F |  |  | B
 |  | F | sub |  | A*
 |  | F | sub | B | B
 |  | F | sch |  | A
 |  | M | sch |  | C
 |  | M | sch | B | B
 |  | F |  |  | B
 |  | M | sch |  | C
 |  | M |  | F | B
 |  | M | sch |  | A
 |  | M | sch |  | B
 |  | F |  |  | B
 |  | F |  |  | B
 |  | F | sch/sub | A | A
 |  | F | sch/sub |  | A
 |  | M |  |  | A
 |  | M |  |  | B
 |  | M |  |  | B
 |  | M |  |  | B
 |  | F |  | F | B
 |  | F |  |  | B
 |  | F |  |  | B
 |  | M |  |  | B
 |  | M |  |  | B
 |  | F |  |  | B
 |  | F |  |  | B
 |  | F |  |  | B
 |  | F |  | A* | A
 |  | F |  |  | A
 |  | F |  |  | B
 |  | M |  |  | A
 |  | M |  |  | B
 |  | M |  |  | B
 |  | M |  | B | B
 |  | F |  | B | B
 |  | F |  |  | B
 |  | M |  |  | B
 |  | F |  |  | B
 |  | F |  |  | B
 |  | M |  |  | B
 |  | F |  |  | B
 |  | F | sch/sub | A* | A
 |  | M | sub |  | B
 |  | F |  | B | B
 |  | F
 |  | F | sch |  | B
 |  | M |  |  | A
 |  | M | sch/sub | A* | A
 |  | M |  |  | B
 |  | F |  |  | B
 |  | F |  |  | B
 |  | F |  |  | A
 |  | M |  | A* | A
 |  | F |  |  | B
 |  | M |  | A | B
 |  | M |  |  | B
 |  | F |  |  | A
 |  | F |  |  | C
 |  | F | sch/sub | A* | A
 |  | F | sub |  | A
 |  | F |  |  | C
 |  | M | sch |  | A
 |  | F |  |  | B
 |  | F |  |  | B
 |  | F |  | B | B
 |  | F |  |  | B
 |  | M |  | C | B
 |  | F |  | D | B
 |  | M |  |  | B
 |  | F |  |  | B
 |  | M |  |  | B
 |  | F |  | B | B
 |  | M |  |  | B
 |  | M |  |  | B
 |  | M |  |  | B
 |  | M |  |  | B
 |  | F | sch |  | A
 |  | F |  | A | C
 |  | M |  | B | B
 |  | M |  |  | A
 |  | F |  |  | B
 |  | F |  | A* | B
 |  | F |  |  | B
 |  | F |  |  | B
 |  | M |  |  | A
 |  | M |  |  | B
 |  | M |  |  | B
 |  | F |  |  | B
 |  | M |  |  | A
 |  | F |  |  | C
 |  | F |  |  | B
 |  | M | sch/sub |  | A
 |  | M |  | B | B
 |  | M |  |  | B
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 94.44444444444444