Spreadsheet: 679335d1590337956-text-join-ignoring-blanks-but-limited-to-a-maximum-of-five-entries-topic-test-spreadsheet-draft-1
Sheet: Number

Question number |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19
 |  | I can order negative numbers | I can use negative number in a temperature context | I can use negative number in a temperature context | I can multiply and divide using negative numbers | I can add and subtract using negative numbers | I know the first 10 square numbers | I understand the definition of a square number | I know the first 4 cube numbers | I understand the definition of a cube number | I can find multiples of a number | I can find factors of a number | I can find the LCM of two numbers | I can find the HCF of two numbers | I know the first 5 prime numbers | I understand the definition of a prime number | I can use BIDMAS correctly | I can calculate square and cube roots | I can check the accuracy of a calculation by using its magnitude | I can write a number as a product of its prime factors | Total marks |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I NEED THIS COLUMN TO LOOK LIKE IT IS WITH A FORMULA
Pupil Names | % | 2 | 3 | 4 | 3 | 4 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 1 | 1 | 3 | 3 | 1 | 2 |  | Incorrect Questions |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Text Join | First 5 incorrect questions
A |  | 2 | 3 | 2 | 3 | 4 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 1 | 1 | 2 | 2 | 1 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19
B |  | 2 | 3 | 3 | 3 | 4 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 0 | 1 | 3 | 3 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14
C |  | 2 | 3 | 4 | 3 | 3 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 0 | 1 | 3 | 3 | 1 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14
D |  | 2 | 3 | 4 | 3 | 2 | 0 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 1 | 1 | 3 | 3 | 1 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
E |  | 2 | 3 | 4 | 3 | 4 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 1 | 1 | 3 | 2 | 1 | 2
F |  | 2 | 3 | 4 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 1 | 1 | 3 | 3 | 1 | 1
G |  | 2 | 3 | 4 | 3 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 0 | 1 | 3 | 3 | 0 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14, 18
H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | abs | 1, 2, 3, 4, 5
I |  | 2 | 3 | 4 | 3 | 3 | 1 | 0 | 1 | 0 | 0 | 1 | 2 | 2 | 1 | 1 | 3 | 3 | 1 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7, 9, 10
J |  | 2 | 2 | 4 | 3 | 3 | 1 | 1 | 0 | 1 | 1 | 1 | 2 | 2 | 0 | 1 | 1 | 3 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8, 14
K |  | 2 | 3 | 3 | 3 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 1 | 1 | 3 | 1 | 1 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19
L |  | 2 | 3 | 2 | 2 | 4 | 1 | 1 | 0 | 1 | 1 | 0 |  |  | 1 | 1 | 3 | 2 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8, 11, 12, 13
M |  | 2 | 3 | 4 | 3 | 3 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 1 | 1 | 2 | 2 | 1 | 2
N |  | 2 | 3 | 4 | 3 | 3 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 1 | 1 | 3 | 3 | 1 | 2
O |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | abs | 1, 2, 3, 4, 5
P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | abs | 1, 2, 3, 4, 5
Q |  | 2 | 3 | 4 | 3 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 1 | 1 | 3 | 3 | 1 | 2
R |  | 2 | 3 | 4 | 3 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 3 | 3 | 1 | 2
S |  | 2 | 3 | 4 | 3 | 4 | 0 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 1 | 0 | 3 | 3 | 1 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6, 15, 19
T |  | 2 | 3 | 4 | 3 | 3 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 1 | 1 | 3 | 3 | 1 | 2
U |  | 2 | 3 | 4 | 2 | 3 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 1 | 1 | 3 | 3 | 1 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19
V |  | 2 | 3 | 4 | 3 | 3 | 0 | 1 | 0 |  | 1 | 1 | 2 | 0 | 1 | 0 | 3 | 3 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6, 8, 9, 13, 14
W |  | 2 | 3 | 4 | 3 | 4 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 1 | 1 | 3 | 2 | 1 | 2
X |  | 2 | 3 | 4 | 2 | 2 | 0 | 1 | 0 | 0 | 1 | 1 | 2 | 0 | 0 | 1 | 2 | 2 | 1 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6, 8, 9, 13, 14
Y |  | 2 | 3 | 4 | 3 | 3 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 0 | 1 | 3 | 3 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14
Z |  | 2 | 3 | 4 | 3 | 4 | 1 | 1 | 1 | 0 | 1 | 1 | 2 | 2 | 1 | 1 | 3 | 3 | 1 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9, 19
AA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1, 2, 3, 4, 5
AB |  | 2 | 3 | 2 | 3 | 2 | 0 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 1 | 1 | 3 | 3 | 1 | 2
AC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1, 2, 3, 4, 5
AD |  | 2 | 3 | 4 | 3 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 1 | 1 | 3 | 3 | 1 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
AE |  | 2 | 3 | 4 | 3 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 0 | 2 | 1 | 1 | 3 | 3 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8, 12, 19