Spreadsheet: 740630d1626431066-using-multiple-if-functions-with-vlookup-aqa-gcse-mock-mfl-results
Sheet: French Mock Results

AQA GCSE Mock French Results 2018-19
 |  |  |  | [NAME] | TG | Tier | L |  | SM | GRADE | R |  | SM | GRADE | S |  | SM | GRADE | W |  | SM | GRADE | MSM | GRADE | GRADE | GRADE
 |  |  |  |  |  | of Entry | 40 | 50 | 60 | 9-1 | 60 | 60 | 60 | 9-1 | 60 | 60 | 60 | 9-1 | 50 | 60 | 60 | 9-1 |  | 9-1 | v. [NAME] | v. TG |  |  | 9-1 | 9-1 | 9-1
 |  |  |  |  |  |  | F | H |  | L | F | H |  | R | F | H |  | S | F | H |  | W |  | Overall |  |  |  |  | TG | [NAME] | Overall
Pupil 1 | M | Tutor | TchGrp | 7.5 | 8 | H |  | 46 |  |  |  | 50 |  |  |  | 50 |  |  |  | 50 |  |  |  |  |  |  |  | U
Pupil 2 | M | Tutor | TchGrp | 5 | 6 | H |  | 32 |  |  |  | 45 |  |  |  | 41 |  |  |  | 49 |  |  |  |  |  |  |  | 1
Pupil 3 | M | Tutor | TchGrp | 7 | 7 | H |  | 48 |  |  |  | 35 |  |  |  | 25 |  |  |  | 34 |  |  |  |  |  |  |  | 2
Pupil 4 | M | Tutor | TchGrp | 6.5 | 7 | H |  | 11 |  |  |  | 41 |  |  |  | 29 |  |  |  | 40 |  |  |  |  |  |  |  | 3
Pupil 5 | F | Tutor | TchGrp | 6.4 | 6 | F |  |  |  |  | 36 |  |  |  | 36 |  |  |  | 31 |  |  |  |  |  |  |  |  | 4
Pupil 6 | M | Tutor | TchGrp | 4.5 | 6 | H |  | 14 |  |  |  | 36 |  |  |  | 20 |  |  |  | 36 |  |  |  |  |  |  |  | 5
Pupil 7 | M | Tutor | TchGrp | 7.5 | 8 | H |  | 31 |  |  |  | 57 |  |  |  | 48 |  |  |  | 55 |  |  |  |  |  |  |  | 6
Pupil 8 | M | Tutor | TchGrp | 6.3 | 5 | F |  |  |  |  | 5 |  |  |  | 37 |  |  |  | 19 |  |  |  |  |  |  |  |  | 7
Pupil 9 | M | Tutor | TchGrp | 6.1 | 6 | F |  |  |  |  | 40 |  |  |  | 42 |  |  |  | 34 |  |  |  |  |  |  |  |  | 8
Pupil 10 | M | Tutor | TchGrp | 5.7 | 7 | H |  | 15 |  |  |  | 50 |  |  |  | 30 |  |  |  | 45 |  |  |  |  |  |  |  | 9
Pupil 11 | M | Tutor | TchGrp | 5.4 | 5 | F | 16 |  |  |  | 20 |  |  |  | 34 |  |  |  | 24
Pupil 12 | M | Tutor | TchGrp | 4.2 | 4 | F | 12 |  |  |  |  |  |  |  | 31 |  |  |  | 17 |  |  |  |  |  |  |  |  | U
Pupil 13 | M | Tutor | TchGrp | 7 | 8 | H |  | 30 |  |  |  | 53 |  |  |  | 30 |  |  |  | 48 |  |  |  |  |  |  |  | 1
Pupil 14 | F | Tutor | TchGrp | 6.4 | 7 | H |  | 19 |  |  |  | 36 |  |  |  | 35 |  |  |  | 46 |  |  |  |  |  |  |  | 2
Pupil 15 | F | Tutor | TchGrp | 5.9 | 7 | H |  | 20 |  |  |  | 53 |  |  |  | 40 |  |  |  | 47 |  |  |  |  |  |  |  | 3
Pupil 16 | M | Tutor | TchGrp | 5.5 | 5 | F | 12 |  |  |  | 31 |  |  |  | 37 |  |  |  | 27 |  |  |  |  |  |  |  |  | 4
Pupil 17 | M | Tutor | TchGrp | 6.8 | 7 | H |  | 8 |  |  |  | 26 |  |  |  | 27 |  |  |  | 27 |  |  |  |  |  |  |  | 5
Pupil 18 | M | Tutor | TchGrp | 5.6 | 7 | H |  | 19 |  |  |  | 41 |  |  |  | 32 |  |  |  | 43 |  |  |  |  |  |  |  | 6
Pupil 19 | F | Tutor | TchGrp | 6 | 6 | H |  | 10 |  |  |  | 20 |  |  |  | 21 |  |  |  | 26 |  |  |  |  |  |  |  | 7
Pupil 20 | F | Tutor | TchGrp | 6.4 | 7 | H |  | 15 |  |  |  | 27 |  |  |  | 38 |  |  |  | 38 |  |  |  |  |  |  |  | 8
Pupil 21 | F | Tutor | TchGrp | 4.7 | 5 | H |  | 10 |  |  |  | 23 |  |  |  | 15 |  |  |  | 23 |  |  |  |  |  |  |  | 9
Pupil 22 | M | Tutor | TchGrp | 5.7 | 6 | H |  | 21 |  |  |  | 40 |  |  |  | 27 |  |  |  | 35
Pupil 23 | F | Tutor | TchGrp | 6.9 | 7 | H |  | 18 |  |  |  | 45 |  |  |  | 39 |  |  |  | 45
Pupil 24 | M | Tutor | TchGrp | 5.2 | 5 | H |  | 8 |  |  |  | 20 |  |  |  | 24 |  |  |  | 21
Pupil 25 | F | Tutor | TchGrp | 7.2 | 8 | H |  | 21 |  |  |  | 54 |  |  |  | 44 |  |  |  | 58
Pupil 26 | F | Tutor | TchGrp | 5 | 5 | H |  | 9 |  |  |  | 29 |  |  |  | 21 |  |  |  | 32
Pupil 27 | M | Tutor | TchGrp | 7.1 | 7 | H |  | 13 |  |  |  | 43 |  |  |  | 37 |  |  |  | 42
Pupil 28 | F | Tutor | TchGrp | 3 | 6 | H |  | 20 |  |  |  | 29 |  |  |  | 38 |  |  |  | 27
Pupil 29 | M | Tutor | TchGrp | 6.2 | 6 | H |  | 14 |  |  |  | 34 |  |  |  | 25 |  |  |  | 28
Pupil 30 | F | Tutor | TchGrp | 5.1 | 5 | F | 19 |  |  |  | 45 |  |  |  | 44 |  |  |  | 38
Pupil 31 | M | Tutor | TchGrp | 6 | 5 | F | 20 |  |  |  | 32 |  |  |  | 38 |  |  |  | 19
Pupil 32 | M | Tutor | TchGrp | 4.6 | 5 | F | 16 |  |  |  | 20 |  |  |  | 36 |  |  |  | 19
Pupil 33 | M | Tutor | TchGrp | 7.1 | 7 | H |  | 9 |  |  |  | 25 |  |  |  | 21 |  |  |  | 38
Pupil 34 | F | Tutor | TchGrp | 7.1 | 7 | H |  | 10 |  |  |  | 26 |  |  |  | 22 |  |  |  | 39
Pupil 35 | M | Tutor | TchGrp | 7.1 | 7 | H |  | 11 |  |  |  | 27 |  |  |  | 23 |  |  |  | 40
Pupil 36 | M | Tutor | TchGrp | 7.1 | 7 | H |  | 12 |  |  |  | 28 |  |  |  | 24 |  |  |  | 41
Pupil 37 | M | Tutor | TchGrp | 7.1 | 7 | H |  | 13 |  |  |  | 29 |  |  |  | 25 |  |  |  | 42
Pupil 38 | F | Tutor | TchGrp | 7.1 | 7 | H |  | 14 |  |  |  | 30 |  |  |  | 26 |  |  |  | 43
Pupil 39 | F | Tutor | TchGrp | 7.1 | 7 | H |  | 15 |  |  |  | 31 |  |  |  | 27 |  |  |  | 44
Pupil 40 | F | Tutor | TchGrp | 7.1 | 7 | H |  | 16 |  |  |  | 32 |  |  |  | 28 |  |  |  | 45
Pupil 41 | M | Tutor | TchGrp | 7.1 | 7 | H |  | 17 |  |  |  | 33 |  |  |  | 29 |  |  |  | 46
Pupil 42 | F | Tutor | TchGrp | 7.1 | 7 | H |  | 18 |  |  |  | 34 |  |  |  | 30 |  |  |  | 47
Pupil 43 | M | Tutor | TchGrp | 7.1 | 7 | H |  | 19 |  |  |  | 35 |  |  |  | 31 |  |  |  | 48
Pupil 44 | F | Tutor | TchGrp | 7.1 | 7 | H |  | 20 |  |  |  | 36 |  |  |  | 32 |  |  |  | 49
Pupil 45 | F | Tutor | TchGrp | 7.1 | 7 | H |  | 21 |  |  |  | 37 |  |  |  | 33 |  |  |  | 50
Pupil 46 | M | Tutor | TchGrp | 7.1 | 7 | H |  | 22 |  |  |  | 38 |  |  |  | 34 |  |  |  | 51
Pupil 47 | F | Tutor | TchGrp | 7.1 | 7 | H |  | 23 |  |  |  | 39 |  |  |  | 35 |  |  |  | 52
Pupil 48 | M | Tutor | TchGrp | 7.1 | 7 | H |  | 24 |  |  |  | 40 |  |  |  | 36 |  |  |  | 53
Pupil 49 | F | Tutor | TchGrp | 7.1 | 7 | H |  | 25 |  |  |  | 41 |  |  |  | 37 |  |  |  | 54
Pupil 50 | M | Tutor | TchGrp | 7.1 | 7 | H |  | 26 |  |  |  | 42 |  |  |  | 38 |  |  |  | 55