Spreadsheet: 695848d1600426326-multiple-science-gcse-grades-sample-assessment-1-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GTG ARR1 |  | Mean | GTG ARR2 |  | Mean | GTG ARR3 |  | Mean | GTG Total |  | Mean |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AR1 | AR1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AR1 | AR2 | AR3 | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X
 |  |  |  |  |  |  |  | 58 | A* | 8 | 58 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A*-C |  |  | A*-C |  |  | A*-C |  |  | A*-C
 |  |  |  |  |  |  |  | 52 | A | 7 | 52 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A*-A |  |  | A*-A |  |  | A*-A |  |  | A*-A
 |  |  |  |  |  |  |  | 46 | B | 6 | 46 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A* |  |  | A* |  |  | A* |  |  | A*
 |  |  |  |  |  |  |  | 40 | C | 5 | 40 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A |  |  | A |  |  | A |  |  | A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Number
 |  |  |  |  |  |  |  | 34 | D | 4 | 34 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B |  |  | B |  |  | B |  |  | B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Lower
 |  |  |  |  |  |  |  | 28 | E | 3 | 28 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C |  |  | C |  |  | C |  |  | C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Middle
 |  |  |  |  |  |  |  | 22 | F | 2 | 22 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D |  |  | D |  |  | D |  |  | D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Upper
 |  |  |  |  |  |  |  | 16 | G | 1 | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E |  |  | E |  |  | E |  |  | E
 |  |  |  |  |  |  |  | 0 | U | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F |  |  | F |  |  | F |  |  | F
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G |  |  | G |  |  | G |  |  | G
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | U |  |  | U |  |  | U |  |  | U
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Below GTG |  |  | Below GTG |  |  | Below GTG |  |  | Below GTG
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In line GTG |  |  | In line GTG |  |  | In line GTG |  |  | In line GTG
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Above GTG |  |  | Above GTG |  |  | Above GTG |  |  | Above GTG
 | 1: Green learner:  on-track for core subjects 2: Amber learner:  2 grades below core subjects 3: Red learner:  >2 grades below core subjects Grey learner: Missing data | Attendance | Reg | Class | SEN | MAT | FSM? | Gender | LAC | Traveller | CHACE? | Target learner | Mentoring 1 | Mentoring 2 | Mentoring 3 |  | GTG ARR1 |  |  | GTG ARR2 |  |  | GTG ARR3 |  |  | Below ARR1 | In line ARR1 | Above ARR1 | Below ARR2 | In line ARR2 | Above ARR2 | Below ARR3 | In line ARR3 | Above ARR3 | Below Total | In line Total | Above Total | English LAN | English LAN 2 | English LAN 3 | English LAN ACTUAL | English LIT | English LIT 2 | English LIT 3 | English LIT |  | Maths | Maths 2 | Maths 3 | Maths | Numeracy 1 | Numeracy 2 | Numeracy 3 | Numeracy |  | Science GCSE 1 | Science GCSE 2 | Science GCSE 3 | Science DA GCSE | Science SA GCSE 1 | Science SA GCSE 2 | Science SA GCSE 3 | Science SA GCSE | Science BTEC 1 | Science BTEC 2 | Science BTEC 3 | Science BTEC |  | Geography | Geography 2 | Geography 3 | Geography | History | History 2 | History 3 | History | RE | RE2 | RE 3 | RE | Art | Art 2 | Art 3 | Art | Food | Food 2 | Food 3 | Food | [NAME]. | [NAME]. 2 | [NAME]. 3 | [NAME]. | DT | DT 2 | DT 3 | DT | Music | Music 2 | Music 3 | Music | Product Design | Product Design 2 | Product Design 3 | Product design | French | French 2 | French 3 | French | Spanish | Spanish 2 | Spanish 3 | Spanish | Welsh | Welsh 2 | Welsh 3 | Welsh | ICT | ICT 2 | ICT 3 | ICT | Media | Media 2 | Media 3 | Media | PE | PE 2 | PE 3 | PE | Phil & Ethics | Phil & Ethics 2 | Phil & Ethics 3 | Phil & Ethics | A | A | A | A | B | B | B | B | Business* | Business 2* | Business 3* | Business* | [NAME] | [NAME] | [NAME]. 3* | [NAME].* | Construction* | Construction 2* | Construction 3* | Construction* | C* | C* 2 | C* 3 | C* | H&SC* | H&SC* 2 | H&SC* 3 | H&SC* | [NAME]* | SWEET* 2 | [NAME]* 3 | [NAME]* | WBQ* | WBQ* 2 | WBQ* 3 | WBQ* | D* | D* | D* | D* | E* | E* | E* | E* | Prince Trust ** | Prince Trust ** 2 | Prince Trust ** 3 | Prince Trust ** | Public ** | Public ** 2 | Public ** 3 | Public ** | Sport ** | Sport ** 2 | Sport** 3 | Sport** | Eng** | Eng** | Eng** | Eng** | F** | F** | F** | F** | G** | G** | G** | G** |  | Lower Lit | Lower Maths | Lower Science | Higher Lit | Higher num | Highest Science? | Other 6 | Capped 9 | CAPPED 9 |  |  |  | LITERACY |  |  |  | NUMERACY |  |  |  | SCIENCE |  |  |  | GTG - above core | GTG - above E/M and 3 others | GTG*3 | Core mean | GTG mean - core mean |  |  |  |  | English |  |  | English Lit |  |  | Maths |  |  | Numeracy |  |  | Science GCSE |  |  | Science SA GCSE |  |  | Science BTEC |  |  | Geography |  |  | History |  |  | RE |  |  | Art |  |  | Food |  |  | [NAME]. |  |  | DT |  |  | Music |  |  | Product Design |  |  | French |  |  | Spanish |  |  | Welsh |  |  | ICT |  |  | Media |  |  | PE |  |  | Phil&Ethics |  |  | A |  |  | B |  |  | Business* |  |  | [NAME] |  |  | Construction* |  |  | C* |  |  | HS&C* |  |  | [NAME]* |  |  | WBQ* |  |  | D* |  |  | E* |  |  | Prince Trust** |  |  |  | Public** |  |  |  | Sport** |  |  |  | Eng** |  |  |  | F** |  |  |  | G** |  |  |  |  |  | English |  |  | English Lit |  |  | Maths |  |  | Numeracy |  |  | Science GCSE |  |  | Science SA GCSE |  |  | Science BTEC |  |  | Geography |  |  | History |  |  | RE |  |  | Art |  |  | Food |  |  | [NAME]. |  |  | DT |  |  | Music |  |  | Product Design |  |  | French |  |  | Spanish |  |  | Welsh |  |  | ICT |  |  | Media |  |  | PE |  |  | Phil&Ethics |  |  | A |  |  | B |  |  | Business* |  |  | [NAME] |  |  | Construction* |  |  | C* |  |  | HS&C* |  |  | [NAME]* |  |  | WBQ* |  |  | D* |  |  | E* |  |  | Prince Trust** |  |  |  | Public** |  |  |  | Sport** |  |  |  | Eng** |  |  |  | F** |  |  |  | G**
1 | [NAME] |  | L |  | A |  | N | M |  |  |  |  |  |  |  |  | D
2 | [NAME] |  | S |  |  |  | Y | M |  |  |  |  |  |  |  |  | C
3 | [NAME] |  | A |  |  |  | N | F |  |  |  |  |  |  |  |  | C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A
4 | ALEXANDER Rachel |  | W |  |  |  | N | F |  |  |  |  |  |  |  |  | A
5 | AMORUSO Alessandro |  | S |  | A |  | N | M |  |  |  |  |  |  |  |  | D
6 |  |  |  |  |  |  | N | F
7 |  |  |  |  |  |  | N | F
8 |  |  |  |  | P |  | Y | F
9 |  |  |  |  | P |  | N | F
10 |  |  |  |  | P |  | N | M
11 |  |  |  |  | P |  | N | M
12 |  |  |  |  | A |  | N | F
13 |  |  |  |  |  |  | N | F
14 |  |  |  |  | P |  | N | M
15 |  |  |  |  |  |  | N | F
16 |  |  |  |  |  |  | N | F
17 |  |  |  |  |  |  | Y | F
18 |  |  |  |  |  |  | N | F
19 |  |  |  |  | P |  | Y | F
20 |  |  |  |  |  |  | Y | F
21 |  |  |  |  | S |  | Y | M | Y
22 |  |  |  |  | S |  | N | M
23 |  |  |  |  | P |  | Y | M | Y
24 |  |  |  |  | S |  | N | F
25 |  |  |  |  |  |  | N | M
26 |  |  |  |  | A |  | Y | F
27 |  |  |  |  |  |  | N | F
28 |  |  |  |  | P |  | N | F
29 |  |  |  |  |  |  | N | F
30 |  |  |  |  |  |  | N | M
31 |  |  |  |  | N |  | N | F
32 |  |  |  |  |  |  | N | M
33 |  |  |  |  | P |  | N | M
34 |  |  |  |  | P |  | N | M
35 |  |  |  |  | N |  | N | F
36 |  |  |  |  | S |  | Y | M
37 |  |  |  |  |  |  | N | F
38 |  |  |  |  | P |  | N | M
39 |  |  |  |  | N |  | N | M
40 |  |  |  |  |  |  | N | M
41 |  |  |  |  |  |  | N | M
42 |  |  |  |  | P |  | Y | F
43 |  |  |  |  |  |  | N | M
44 |  |  |  |  |  |  | N | F
45 |  |  |  |  |  |  | N | M
46 |  |  |  |  | S |  | Y | M
47 |  |  |  |  | P |  | N | F
48 |  |  |  |  | P |  | N | F
49 |  |  |  |  | P |  | Y | F
50 |  |  |  |  |  |  | N | M
51 |  |  |  |  |  |  | N | M
52 |  |  |  |  | N |  | N | M
53 |  |  |  |  | A |  | N | M
54 |  |  |  |  |  |  | N | F
55 |  |  |  |  | N |  | Y | M
56 |  |  |  |  | A |  | Y | F
57 |  |  |  |  |  |  | N | F
58 |  |  |  |  | N |  | Y | M
59 |  |  |  |  |  |  | N | M
60 |  |  |  |  | P |  | N | F
61 |  |  |  |  |  |  | N | M
62 |  |  |  |  |  |  | N | M
63 |  |  |  |  |  |  | N | M
64 |  |  |  |  | P |  | Y | M | Y
65 |  |  |  |  |  |  | N | F
66 |  |  |  |  | N |  | N | F
67 |  |  |  |  |  |  | N | F
68 |  |  |  |  | A |  | N | M
69 |  |  |  |  |  |  | N | M
70 |  |  |  |  | A |  | Y | F
71 |  |  |  |  |  |  | N | F
72 |  |  |  |  | A |  | N | M
73 |  |  |  |  | S |  | Y | M
74 |  |  |  |  | A |  | N | M
75 |  |  |  |  |  |  | N | F
76 |  |  |  |  | P |  | N | F
77 |  |  |  |  | P |  | N | M
78 |  |  |  |  | S |  | N | M
79 |  |  |  |  |  |  | Y | F
80 |  |  |  |  |  |  | N | F
81 |  |  |  |  | P |  | Y | M
82 |  |  |  |  | N |  | Y | F
83 |  |  |  |  | N |  | N | M
84 |  |  |  |  | A |  | N | F
85 |  |  |  |  | P |  | Y | M
86 |  |  |  |  | S |  | Y | F
87 |  |  |  |  |  |  | N | F
88 |  |  |  |  |  |  | N | M
89 |  |  |  |  | P |  | N | M
90 |  |  |  |  |  |  | N | F
91 |  |  |  |  |  |  | Y | F
92 |  |  |  |  |  |  | N | F
93 |  |  |  |  |  |  | N | F
94 |  |  |  |  | P |  | Y | M
95 |  |  |  |  | P |  | Y | F
96 |  |  |  |  | S |  | N | F
97 |  |  |  |  |  |  | Y | M
98 |  |  |  |  | A |  | N | M
99 |  |  |  |  | P |  | Y | F
100 |  |  |  |  | P |  | N | M
101 |  |  |  |  |  |  | Y | M
102 |  |  |  |  | N |  | N | F
103 |  |  |  |  | P |  | Y | M
104 |  |  |  |  |  |  | N | F
105 |  |  |  |  | P |  | Y | M
106 |  |  |  |  | P |  | Y | F
107 |  |  |  |  | A |  | Y | F
108 |  |  |  |  |  |  | Y | F
109 |  |  |  |  | S |  | N | M
110 |  |  |  |  |  |  | N | F
111 |  |  |  |  | P |  | Y | M
112 |  |  |  |  | N |  | N | M
113 |  |  |  |  | A |  | Y | F
114 |  |  |  |  | A |  | Y | F
115 |  |  |  |  |  |  | N | M
116 |  |  |  |  | N |  | Y | F
117 |  |  |  |  | A |  | N | F
118 |  |  |  |  | N |  | N | M
119 |  |  |  |  |  |  | Y | M
120 |  |  |  |  | A |  | N | F
121 |  |  |  |  | A |  | Y | F
122 |  |  |  |  | P |  | N | F
123 |  |  |  |  |  |  | N | M
124 |  |  |  |  | N |  | Y | M
125 |  |  |  |  |  |  | N | M
126 |  |  |  |  |  |  | N | F
127 |  |  |  |  |  |  | Y | F
128 |  |  |  |  | S |  | Y | M
129 |  |  |  |  | P |  | N | F
130 |  |  |  |  | P |  | N | F
131 |  |  |  |  |  |  | Y | M
132 |  |  |  |  | P |  | Y | M
133 |  |  |  |  | S |  | Y | M
134 |  |  |  |  | A |  | N | M
135 |  |  |  |  |  |  | Y | F
136 |  |  |  |  | P |  | N | M
137 |  |  |  |  | A |  | N | F
138 |  |  |  |  | P |  | Y | F
139 |  |  |  |  |  |  | N | M
140 |  |  |  |  |  |  | N | M
141 |  |  |  |  |  |  | N | F
142 |  |  |  |  | P |  | Y | F
143 |  |  |  |  |  |  | N | F
144 |  |  |  |  |  |  | N | F
145 |  |  |  |  | A |  | N | M
146 |  |  |  |  | P |  | Y | M
147 |  |  |  |  |  |  | N | M
148 |  |  |  |  |  |  | N | M
149 |  |  |  |  |  |  | N | F
150 |  |  |  |  |  |  | N | M