Spreadsheet: 120960d1315676369-combining-two-data-sets-help
Sheet: Test Results Core

Surname | Forename | Name | Form | P/G | Set | B1 Grade | B2 Grade | [NAME] | C2 Grade | P1 Grade | [NAME] | Predicted grade for OCR | MOCK PAPER APRIL 2011 /60 | MOCK PAPER APRIL 2011 GRADE |  | UMS Score B1C1P1 | [NAME]
Abdel-Rahim | Tariq |  | LSA | 2 | 10sAB
Alliker | [NAME] |  | RDA | 4 | 10tBC | D |  | C |  | E | C |  | 25 | D
Ancill | [NAME] |  | RHW | 3 | 10tAC |  |  |  |  |  |  |  | 33
Ansell | Connor |  | LSA | 3 | 10tAC |  | D |  |  |  |  |  | 27
Attree | [NAME] |  | HTO | 2 | 10sAB
[NAME] | Verity |  | CVA | 4 | 10tAC |  |  |  |  |  |  |  | 28
[NAME] | [NAME] |  | LSA | 3 | 10tBC | E |  | C |  | C |  |  | 30 | C
[NAME] | [NAME] |  | HTO | 2 | 10sAC |  |  |  |  |  |  |  | 30
Barrow | Charlotte |  | LSA | 3 | 10tBC | D |  | D |  |  | D |  | 28 | D
Beaumont | [NAME] |  | HRO | 3 | 10tBC | C |  |  |  | C | D |  | 19 | E
Bell | George |  | HTO | 2 | 10sAB | C |  |  |  |  | B |  | 41 | A
Berkane | [NAME] |  | BMA | 2 | 10sAC
Boon | Natasha |  | LSA | 2 | 10tAC |  |  |  |  |  |  |  | 25
[NAME] | [NAME] |  |  |  | 10sAC |  |  |  |  |  |  |  | 32
Braybrook | [NAME] |  | RHW | 3 | 10tBC | C |  | C |  | c | D |  | 29 | C
Britt | [NAME] |  | RHW | 1 | 10sAB | U |  |  |  |  | A |  | 25 | C
Buckland | [NAME] |  | RHW | 1 | 10sAC |  |  |  |  |  |  |  | 14
Buick | Amanda |  | HRO | 2 | 10sAC |  |  |  |  |  |  |  | 23
[NAME] | [NAME] |  | MTR | 1 | 10sAC |  |  |  |  |  |  |  | 31
[NAME] | Lauren |  | LSA | 2 | 10tAC |  |  |  |  |  |  |  | 25
Catchpole | Lewis |  | RDA | 2 | 10sAC |  |  |  |  |  |  |  | 19
Cheek | Jake |  | BMA | 2 | 10tAC |  | D |  |  |  |  |  | 23
Chinery | Susannah |  | MTR | 1 | 10sAB | D |  |  |  |  | B |  | 24 | C
[NAME] | Ashvi |  | CVA | 3 | 10tBC | D |  | D |  |  | C |  | 23 | D
Cowie | Dominic |  | ACA | 3 | 10sAB | D | C |  |  |  | A |  | 26 | C
Cox | Ellie |  | RHW | 4 | 10tBC |  |  | C |  |  |  |  | 28 | D
Croal | Felicity |  | RDA | 3 | 10tAC |  | B |  |  |  |  |  | left
[NAME] | Bethany |  | RHW | 2 | 10sAB | C |  |  |  |  | B |  | 32 | B
[NAME] | Holly |  | CVA | 2 | 10tAC |  | D |  |  |  |  |  | 21
Dooley | Jasmin |  | RDA | 3 | 10tAC |  | C |  |  |  |  |  | 16
Dunlop | [NAME] |  | LSA | 1 | 10sAB | B |  |  |  |  | C |  | 28 | B
Edwards | [NAME] |  | HRO | 2 | 10tBC | D | D | C |  |  | D |  | 25 | D
[NAME] | Bryony |  | HRO | 2 | 10tAC |  | B |  |  |  |  |  | 22
[NAME] | [NAME] |  | RDA | 4 | 10tBC | C |  | C |  |  | C |  | 25 | D
French | [NAME] |  | RHW | 3 | 10tBC |  |  | C |  |  | C |  | 29 | C
Fritz | Charlotte |  | ACA | 2 | 10sAC |  |  |  |  |  |  |  | 23
Graves | [NAME] |  | RDA | 2 | 10sAB |  |  |  |  |  | C |  | 27 | C
Green | [NAME] |  | HTO | 2 | 10sAB | C |  |  |  |  | D |  | 24 | C
Greene | [NAME] |  | ACA | 1 | 10sAB | C |  |  |  |  | A |  | 27 | C
Hales | [NAME] |  | HRO | 1 | 10sAB | D |  |  |  |  | A |  | 26 | C
Hall | [NAME] |  |  |  | 10tBC |  |  | F
[NAME] | Dominic |  | BMA | 3 | 10sAC |  |  |  |  |  |  |  | 17
Horsley | Isobel |  | ACA | 1 | 10sAB | C |  |  |  |  | B |  | 23 | C
Hull | [NAME] |  | HRO | 3 | 10tAC |  | C |  |  |  |  |  | 32
Hume | [NAME] |  | RDA | 1 | 10tAC |  |  |  |  |  |  |  | 30
[NAME] | [NAME] |  | RHW | 3 | 10tBC | D |  | E |  |  | C |  | 23 | D
Kendall | Louis |  | BMA | 2 | 10tAC |  |  |  |  |  |  |  | 11
[NAME] | George |  | ACA | 4 | 10tBC | D |  | D |  |  | U |  | 28 | D
King | [NAME] |  | RDA | 2 | 10sAC |  |  |  |  |  |  |  | 23
Knauss | [NAME] |  | HRO | 2 | 10sAC |  |  |  |  |  |  |  | 23
Kyriacou | [NAME] |  | CVA | 2 | 10tAC |  | C |  |  |  |  |  | 25
Le Marquand | Lewis |  | LSA | 2 | 10sAB | B |  |  |  |  | B |  | 26 | C
[NAME] | Louis |  | HRO | 2 | 10sAC |  |  |  |  |  |  |  | 38
[NAME] | [NAME] |  | RHW | 1 | 10sAC |  |  |  |  |  |  |  | 12
Lock | [NAME] |  | HTO | 1 | 10sAB | B |  |  |  |  | C | C | 34 | B
[NAME] | Jordan |  | RDA | 3 | 10tAC |  | B |  |  |  |  | C | 26
[NAME] | [NAME] |  | HTO | 2 | 10tBC | C | U | D |  | C |  | C | 36 | C
Mclean | Toby |  |  |  | 10sAB | B |  |  |  |  | U | C | 16 | D
Millard | Sophie |  | MTR | 3 | 10tAC |  |  |  |  |  |  | B | 26
[NAME] | [NAME] |  | RDA | 2 | 10sAC |  |  |  |  |  |  | C | 7
Mills | [NAME] |  | HRO | 3 | 10tBC | C |  | C |  | c | C | B | 29 | C
Morris | Demi |  | HTO | 3 | 10sAB | U |  |  |  |  | B | B | 28 | B
[NAME] | Jade |  | RHW | 2 | 10sAB | B |  |  |  |  | A | C | 43 | A
[NAME] | Olivia |  | MTR | 4 | 10tBC | C |  | E |  | C | C | B
Napthine | Emma |  | MTR | 2 | 10tAC |  | D |  |  |  |  | B | 34
Newman | Hayleigh |  | BMA | 4 | 10tAC |  |  |  |  |  |  | C | 24
[NAME] | Callum |  | CVA | 1 | 10sAB | B |  |  |  |  | B | B | 28 | B
[NAME] | [NAME] |  | LSA | 1 | 10sAC |  |  |  |  |  |  | C | 28
O'Byrne | [NAME] |  | LSA | 1 | 10sAB |  |  |  |  |  | D | C | 28 | B
[NAME] | [NAME] |  | LSA | 2 | 10sAC |  | B |  |  |  |  | C | 19
Osborne | [NAME] |  | RHW | 3 | 10tBC |  |  |  |  |  |  | C
[NAME] | Georgia |  | ACA | 2 | 10sAB | B |  |  |  |  | D | B | 31 | B
[NAME] | Tara |  | MTR | 2 | 10sAC |  |  |  |  |  |  | B | 23
Parker | [NAME] |  | HRO | 1 | 10sAB | B |  |  |  |  | C | C | 33 | B
Parker | Kirstie |  | HTO | 3 | 10sAB |  |  |  |  |  | C | C | 35 | B
[NAME] | Rachel |  | ACA | 3 | 10tBC | D |  | C |  | C |  | B | 24 | D
Pearson | Ewen |  | CVA | 2 | 10sAB | U |  |  |  |  | C | C | 17 | D
[NAME] | Jessica |  | ACA | 1 | 10sAC |  |  |  |  |  |  | C | 34
[NAME] | Emily |  | RDA | 2 | 10tAC |  |  |  |  |  |  | C | 25
Pinkney | [NAME] |  | LSA | 3 | 10tAC |  |  |  |  |  |  | C | 15
Pollard | [NAME] |  | HTO | 3 | 10tAC |  | D |  |  |  |  | C | 28
[NAME] | Emily |  | CVA | 4 | 10tBC | C | U | C |  | C | D | C | 23 | D
Rich | Georgina |  |  |  | 10sAC |  |  |  |  |  |  | C
Rusby | Robyn |  | LSA | 2 | 10sAC |  |  |  |  |  |  | C | 16
[NAME] | [NAME] |  | HRO | 2 | 10sAB | C |  |  |  |  | A* | C | 38 | A
Sarafis | Demetra |  | LSA | 2 | 10tBC | E |  | D |  | C | U | C | 17 | E
Sheffield | [NAME] |  | BMA | 2 | 10sAC |  |  |  |  |  |  | C | 21
Smith | Olivia |  | CVA | 4 | 10tAC |  | D |  |  |  |  | C | 23
Stant | Holly |  | CVA | 2 | 10sAB | D |  |  |  |  | B | C | 27 | C
Stevenson | Emily |  | BMA | 4 | 10tAC |  |  |  |  |  |  | C | 20
Stockwell | Shae |  | CVA | 4 | 10tBC | C |  |  |  |  | C | D
Sykes | [NAME] |  | RDA | 3 | 10tBC |  | D | C |  | c | C | C | 29 | C
Thompson | [NAME] |  | RHW | 3 | 10sAB | D |  |  |  |  | U | C | 21 | C
Thorndyke | [NAME] |  | MTR | 3 | 10tAC |  | D |  |  |  |  | C | 15
Thorpe | Kimberly |  | MTR | 2 | 10tBC |  |  | C |  |  | C | C | 28 | D
Turner | [NAME] |  | MTR | 3 | 10tBC | C |  | C |  | C | U | C | 32 | C
Upsher | Ellen |  | BMA | 2 | 10tAC |  | D |  |  |  |  | C | abs
Ward | Cameron |  | LSA | 1 | 10sAC |  |  |  |  |  |  | C | 40
Webb | [NAME] |  | RDA | 2 | 10sAB | D |  |  |  |  | A* | C | 29 | B
Wicks | [NAME] |  | MTR | 3 | 10tAC |  | B |  |  |  |  | C | 15
Wilson | Natasha |  | MTR | 2 | 10sAC |  |  |  |  |  |  | C | 28
Wilson | [NAME] |  | MTR | 1 | 10sAC |  |  |  |  |  |  | C | 27
Wingate | [NAME] |  | CVA | 2 | 10sAC |  |  |  |  |  |  | C | 32
Woods | Connor |  | RDA | 2 | 10sAC |  |  |  |  |  |  | C | 18
Worboys | [NAME] |  | BMA | 3 | 10tBC | D |  | D |  | C | D | C | 29 | C
Breeze | [NAME] |  | RHW | 2 | 10tBD |  |  |  |  |  |  | 0
Chatten | Ellie |  | HRO | 5 | 10tBD |  |  |  |  |  |  | C
Clarke | [NAME] |  | RHW | 5 | 10tBD |  |  |  |  |  |  | D
Crow | [NAME] |  | CVA | 5 | 10tBD |  |  |  |  |  |  | C
[NAME] | [NAME] |  | LSA | 4 | 10tBD |  |  |  |  |  |  | C
Edmonds | [NAME] |  | HRO | 4 | 10tBD |  |  |  |  |  |  | 0
Edwards | [NAME] |  | RHW | 3 | 10tBD |  |  |  |  |  |  | C
Ellis | Chloe |  | RHW | 4 | 10tBD |  |  |  |  |  |  | C
Ellis | Gemma |  | BMA | 4 | 10tBD |  |  |  |  |  |  | C
Forbes-Brown | [NAME] |  | MTR | 4 | 10tBD |  |  |  |  |  |  | C
Gould | Lauren |  | RDA | 3 | 10tBD |  |  |  |  |  |  | C
Gymer | Kayley |  | HTO | 5 | 10tBD |  |  |  |  |  |  | D
Hetrick | [NAME] |  | CVA | 2 | 10tBD |  |  |  |  |  |  | 0
Kruger | [NAME] |  | ACA | 3 | 10tBD |  |  |  |  |  |  | C
[NAME] | Lauren |  | HRO | 4 | 10tBD |  |  |  |  |  |  | D
[NAME] | [NAME] |  | HTO | 3 | 10tBD | E |  |  |  |  |  | 0
Murphy | [NAME] |  | MTR | 4 | 10tBD |  |  |  |  |  |  | D
New | Jordan |  | RDA | 4 | 10tBD |  |  |  |  |  |  | D
Osborne | [NAME] |  | HRO | 3 | 10tBD |  |  |  |  |  |  | C
Reed | [NAME] |  | RHW | 2 | 10tBD |  |  |  |  |  |  | C
[NAME] | [NAME] |  | HRO | 3 | 10tBD |  |  |  |  |  |  | C
Rutherford | Eleanor |  | HRO | 4 | 10tBD |  |  |  |  |  |  | C
Tatam | [NAME] |  | LSA | 4 | 10tBD |  |  |  |  |  |  | D
Woodhouse | [NAME] |  | ACA | 2 | 10tBD |  | U |  |  |  |  | C
[NAME] | [NAME] |  | MTR |  | 10tBC |  |  |  |  | c
Attree | [NAME] |  |  |  | 10sAC |  |  |  |  |  |  |  | 20
[NAME] | Sydney |  |  |  | 10tAC |  |  |  |  |  |  |  | 30
Szczypior | [NAME] |  |  |  | 10tAC |  |  |  |  |  |  |  | 7