Spreadsheet: 728324d1618409031-vlookup-has-stopped-returning-the-correct-value-2021-cohort-evidence
Sheet: TAG work

 |  | Prior Evidence (Foundation) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Prior Evidence (Higher) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Future Evidence
 | Out of: | 16 |  |  | 16 |  |  | 10 |  |  | 9 |  |  |  |  |  | 40 |  |  |  |  | 32 |  |  | 32 |  |  | 12 |  |  | 9
Name |  | 90 Word Question | % | Grade | 90 Word Question | % | Grade | Translation (W) | % | Grade | Translation (R) | % | Grade | Speaking (Qs 1 and 2) | % | Grade | Listening | % | Grade | Average | Grade | 150 Word Question | % | Grade | 150 Word Question | % | Grade | Translation (W) | % | Grade | Translation (R) | % | Grade | Speaking (Qs 1 and 2) | % | Grade | Listening | % | Grade | Higher Translation | % | Grade | Average | Grade | Speaking roleplay (as a writing) | % | Grade | Speaking Photocard | % | Grade | Speaking Conversation | % | Grade | 90 Word Task | % | Grade | 150 Word Task | % | Grade | Reading Translation (2020 Higher paper) | % | Grade | Reading Task (4 Qs from 2020 paper) | % | Grade | Listening Task (4 Qs from 2020 paper) | % | Grade | Average | Grade
 | WSP1 | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28 |  |  |  |  | 22 |  |  |  |  |  | 12 |  |  | 4
 | WSP1 | 10 |  |  |  |  |  | 4 |  |  | 2 |  |  |  |  |  | 16
 | WSP1 | 13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21 |  |  |  |  | 16 |  |  |  |  |  | 9 |  |  | 1
 | WSP1 | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34 |  |  |  |  | 23 |  |  |  |  |  | 12 |  |  | 7
 | WSP1 | 12 |  |  |  |  |  | 6 |  |  | 2 |  |  |  |  |  | 21
 | WSP1 | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 27 |  |  |  |  | 21 |  |  |  |  |  | 9 |  |  | 2
 | WSP1 | 9 |  |  |  |  |  | 7 |  |  | 4 |  |  |  |  |  | 17
 | WSP1 | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18 |  |  |  |  | 15 |  |  |  |  |  | 8 |  |  | 1
 | WSP1 | 10 |  |  |  |  |  | 5 |  |  | 2 |  |  |  |  |  | 18
 | WSP1 | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24 |  |  |  |  | 20 |  |  |  |  |  | 8 |  |  | 4
 | WSP1 | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18 |  |  |  |  | 17 |  |  |  |  |  | 10 |  |  | 2
 | WSP1 | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21 |  |  |  |  | 19 |  |  |  |  |  | 8 |  |  | 2
 | WSP1 | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23 |  |  |  |  | 21 |  |  |  |  |  | 10 |  |  | 2
 | WSP1 | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32 |  |  |  |  | 25 |  |  |  |  |  | 12 |  |  | 6
 | WSP1 | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23 |  |  |  |  | 23 |  |  |  |  |  | 10 |  |  | 4
 | WSP1 | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36 |  |  |  |  | 27 |  |  |  |  |  | 12 |  |  | 8
 | WSP1 | 13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22 |  |  |  |  | 18 |  |  |  |  |  | 6 |  |  | 2
 | XSP1
 | XSP1
 | XSP1
 | XSP1
 | XSP1
 | XSP1
 | XSP1
 | XSP1
 | XSP1
 | XSP1
 | XSP1
 | XSP1
 | XSP1
 | ZSP1
 | ZSP1
 | ZSP1
 | ZSP1
 | ZSP1
 | ZSP1
 | ZSP1
 | ZSP1
 | ZSP1
 | ZSP1
 | ZSP1
 | ZSP1
 | ZSP1
 | ZSP1
 | ZSP1
 | WFR1
 | WFR1
 | WFR1
 | WFR1
 | WFR1
 | WFR1
 | WFR1
 | WFR1
 | WFR1
 | WFR1
 | WFR1
 | WFR1
 | WFR1
 | WFR1
 | WFR1
 | WFR1
 | WFR1
 | WFR1
 | WFR1
 | WFR1
 | XFR1 | 12 |  |  |  |  |  | 5 |  |  | 8 |  |  |  |  |  | 19 |  |  |  |  | na
 | XFR1 | 14 |  |  |  |  |  | 8 |  |  | 9 |  |  |  |  |  | 21 |  |  |  |  | na
 | XFR1 | 15 |  |  |  |  |  | na |  |  | na |  |  |  |  |  | 23 |  |  |  |  | 16 |  |  |  |  |  | 6 |  |  | 4
 | XFR1 | 8 |  |  |  |  |  | 2 |  |  | 2 |  |  |  |  |  | 17 |  |  |  |  | na
 | XFR1 | 13 |  |  |  |  |  | 7 |  |  | 6 |  |  |  |  |  | 18 |  |  |  |  | na
 | XFR1 | 16 |  |  |  |  |  | na |  |  | na |  |  |  |  |  | 39 |  |  |  |  | 28 |  |  |  |  |  | 11 |  |  | 9
 | XFR1 | 15 |  |  |  |  |  | na |  |  | na |  |  |  |  |  | 21 |  |  |  |  | 11 |  |  |  |  |  | 6 |  |  | 3
 | XFR1 | 9 |  |  |  |  |  | 5 |  |  | 4 |  |  |  |  |  | 18 |  |  |  |  | na
 | XFR1 | 10 |  |  |  |  |  | 6 |  |  | 8 |  |  |  |  |  | 22 |  |  |  |  | na
 | XFR1 | 9 |  |  |  |  |  | 6 |  |  | 3 |  |  |  |  |  | 19 |  |  |  |  | na
 | XFR1 | 9 |  |  |  |  |  | 6 |  |  | 6 |  |  |  |  |  | 18 |  |  |  |  | na
 | XFR1 | 16 |  |  |  |  |  | na |  |  | na |  |  |  |  |  | 31 |  |  |  |  | 27 |  |  |  |  |  | 11 |  |  | 7
 | XFR1 | 8 |  |  |  |  |  | 7 |  |  | 3 |  |  |  |  |  | 21 |  |  |  |  | na
 | XFR1 | 13 |  |  |  |  |  | 6 |  |  | 7 |  |  |  |  |  | 15 |  |  |  |  | na