Get documents about "MENTAL TEST Y4 GRID - Excel
Document Sample
Total marks obtained to question by pupils
Number of Marks Awarded to Question
% Correct Response for Cohort
WARNING
This spreadsheet
allows for 36 pupils
Question number
doing Paper 4A and
QCA Year 4 Mathematics Test 2006 Mental 36 doing Paper 4B.
Strand Altering this sheet will
Mathematics affect the automatic
level calculation for
Papers 4A and 4B on
the appropriate grid
sheets.
Enter names of pupils taking written Paper 4A above. These names will Enter names of pupils taking written Paper 4B above. These names will
Enter No. of Pupils in Grey Cell automatically be copied to Paper 4A automatically be copied to Paper 4B
1 Look at your answer sheet. How much do the coins total? (5p, 20p, 20p, 20p) Measures: Money 1 0 ### 1
2 Multiply seven by two. Rapid Recall 1 0 ### 2
3 What is seven less than one hundred? Calculation: + & - 1 0 ### 3
4 Half of a number is forty-five. What is the number? Calculation: x & ÷ 1 0 ### 4
5 Write two hundred and sixty-one to the nearest hundred. Place Value & Ordering: Rounding 1 0 ### 5
6 How many minutes are there in three-quarters of an hour? Measures: Time 1 0 ### 6
7 Divide sixty by five. Calculation: x & ÷ 1 0 ### 7
8 Double eight point four. Calculation: x & ÷ : decimals 1 0 ### 8
9 How many metres are there in three kilometres? Measures: Distance 1 0 ### 9
10 What is half of thirteen? Calculation: x & ÷ 1 0 ### 10
11 Add nine and six and five. Calculation: + & - 1 0 ### 11
12 (Look at ans sheet). Put a ring around the name of the shape that has six sides. Shape and Space 1 0 ### 12
13 What is the remainder when eighteen is divided by five? Calculation: x & ÷ 1 0 ### 13
14 I spend seventy-five pence. How much change do I get from a two pound coin? Problems: Money 1 0 ### 14
15 What number is half way between three hundred and six hundred? Place Value & Ordering 1 0 ### 15
16 What number multiplied by ten makes one hundred and eighty? Calculation: x & ÷ 1 0 ### 16
17 Multiply four by six then add nine. Problems: Number 1 0 ### 17
18 What is one-third of thirty-three? Fractions 1 0 ### 18
19 Look at your answer sheet. Put a ring around the number that is a multiple of eight. Properties of Numbers 1 0 ### 19
20 (Look at ans sheet). Complete the fraction so that it is equivalent to one-quarter. Fractions 1 0 ### 20
Total Marks Achieved by
20 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Pupil:
QCA Year 4 Mathematics Test 2006 Mental Mathematics with success rate of < % highlighted
Strand Question Numbers Q. No. Correct, No. giving No. in Threshold Enter Threshold figure
as % correct cohort Percentage figure in box on left
response 0 0 to perform analysis
Number
Counting/Properties of Numbers 19
Calculation: + & - 3 11 1 #DIV/0! 0
Calculation: x & ÷ 4 7 8 2 #DIV/0! 0
10 13 16 3 #DIV/0! 0 Note:
Place Value & Ordering 5 15 4 #DIV/0! 0
Rapid recall 2 5 #DIV/0! 0 GREEN highlighting
6 #DIV/0! 0 indicates that correct
Fractions 18 20 7 #DIV/0! 0 response rate is less
Problems 8 #DIV/0! 0 than the Threshold %
Involving money 14 9 #DIV/0! 0
Involving number 17 10 #DIV/0! 0
11 #DIV/0! 0
Shape and Space 12 12 #DIV/0! 0
13 #DIV/0! 0
Measures 14 #DIV/0! 0
Money 1 15 #DIV/0! 0
Time 6 16 #DIV/0! 0
Distance 9 17 #DIV/0! 0
18 #DIV/0! 0
19 #DIV/0! 0
20 #DIV/0! 0
Total marks obtained to question by pupils
Number of Marks Awarded to Question
% Correct Response for Cohort
Warning. Adding
additional columns to
Question number
add children will
interfere with the
QCA Year 4 Mathematics Test automatic Level
Strand
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
2006 Paper 4A Level 2 - 3 Calculation. Several
changes will be
needed. Ensure that
you save data before
making changes.
Enter No. of Pupils in Grey Cell Pupil names will automatically be entered from the Mental Maths Grid
1 14+15+16 Calculation: addition 1 0 ### 1
2 What is the length of the straw to the nearest cm (picture) Measures - length 1 0 ### 2
3 Missing numbers on number line (9 either side of 29) Calculation addition & subtraction 1 0 ### 3
4 Write in missing numbers on part of 100 square Calculation addition & subtraction 1 0 ### 4
5a Enter age / birth month data into table Handling data: Carroll diagrams 1 0 ### 5a
5b Enter age / birth month data into table Handling data: Carroll diagrams 1 0 ### 5b
6 Use two of x, ÷ and = to complete 104 • • 4 26 Understanding x and ÷ 1 0 ### 6
7i 56 people visit the zoo. 23 are girls, 21 are boys (Method) Calculation: + & - / Problem solving 1 0 ### 7i
7ii 5 are teachers, rest are parents. How many parents? (Answer) Calculation: + & - / Problem solving 1 0 ### 7ii
8a Shade one more square to make (1st way) Shape and Space: line symmetry 1 0 ### 8a
8b a shape with a line of symmetry (2nd way) Shape and Space: line symmetry 1 0 ### 8b
9 Use digit cards 5, 7, 3 to make number nearest 400 Properties of number 1 0 ### 9
10 75 children in a quiz. Teams of 5. How many teams? Understanding x and ÷ 1 0 ### 10
11 5 shapes on grid. Identify the two octogons Shape and Space 1 0 ### 11
12i Put 4 more ticks in table to show if Properties of number - multiples 1 0 ### 12i
12ii 12, 15, 20 are multiples of 10, 2, 5 Properties of number - multiples 1 0 ### 12ii
13 Order the 5 angles shown, smallest to largest Shape and Space : angle size 1 0 ### 13
14 How many more girls stay at school than go home for lunch? Handling data: Carroll diag / pictogram 1 0 ### 14
15 How many counters could Zak have? (Groups of 3, >10, <20) Problem solving : number 1 0 ### 15
16 Tick the shape that has 3/4 shaded Fractions 1 0 ### 16
17 About how much water could the kettle hold (picture) Measures: capacity 1 0 ### 17
18 145-83 Calculation: subtraction 1 0 ### 18
19i Zak has one 50p coin and three 20p coins (Method) Problem Solving: money 1 0 ### 19i
19ii How much left after buying grapefruit (45p) & melon (59p)? Problem Solving: money 1 0 ### 19ii
20 Write missing number on number line (0 to 1 in tenths) Decimals 1 0 ### 20
21 Write (digital) time on the clock when cake done Measures : time 1 0 ### 21
22i Pictures of 3D shapes and faces. Write numbers Shape and Space: properties of shapes 1 0 ### 22i
22ii on the faces to show how many there are. (5 entries in total) Shape and Space: properties of shapes 1 0 ### 22ii
23 4 ice creams @ 85p. How much altogether? Calculation: multiplication / money 1 0 ### 23
24 Write the next two numbers (inc by 101): 606. 707, 808, • •
, Place value, sequences, addition 1 0 ### 24
25a How tall is Lauren's sunflower? (Reading chart) Handling data: bar charts 1 0 ### 25a
25b How much taller is Zak's …. (Interpreting / using bar chart) Handling data: bar charts 1 0 ### 25b
26 4 two digit number cards. Which two have a difference of 32? Problem solving: number 1 0 ### 26
27 How many originally? (Eats 2, eats 1/2 those left, now has 6) Problem solving: number 1 0 ### 27
28 Using given digits (1-5) to complete 5x6=• and 5x6<• Calculation: mult / ordering 1 0 ### 28
Total Marks Achieved by Pupil: 35 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Total Marks (mental + written) 55 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
<L2A
<L2A
<L2A
<L2A
<L2A
<L2A
<L2A
<L2A
<L2A
<L2A
<L2A
<L2A
<L2A
<L2A
<L2A
<L2A
<L2A
<L2A
<L2A
<L2A
<L2A
<L2A
<L2A
<L2A
<L2A
<L2A
<L2A
<L2A
<L2A
<L2A
<L2A
<L2A
<L2A
<L2A
<L2A
<L2A
Level Achieved
Level "Look Up" Table 0 <L2A
15 L2A
26 L3C
35 L3B
42 L3A
QCA TEST YEAR 4 PAPER 4A Level 2-3 with success rate of < % highlighted
Strand Question Numbers Q. No. Correct, No. giving No. in Threshold Enter Threshold figure
and Levels as % correct cohort Percentage figure in box on left
response
0 60 to perform analysis
Number Level 2 Level 3
Counting / Properties of Numbers 9 12i 12ii
Calculation / Understanding + & - 1 3 4 18 1 #DIV/0! 0
2 #DIV/0! 0
Calculation / Understanding x & ÷ 6 10 23 28 3 #DIV/0! 0 Note:
Place Value & Ordering 24 4 #DIV/0! 0
Fractions 16 5a #DIV/0! 0 GREEN highlighting
Decimals 20 5b #DIV/0! 0 indicates that correct
6 #DIV/0! 0 response rate is less
Problems 7i #DIV/0! 0 than the Threshold %
Involving Money 19i 19ii 7ii #DIV/0! 0
Involving Number 7i 7ii 15 26 27 8a #DIV/0! 0
Reasoning 8b #DIV/0! 0
9 #DIV/0! 0
Data Handling 10 #DIV/0! 0
Organising and Using Data 5a 25a 11 #DIV/0! 0
Data interpretation 5b 14 25b 12i #DIV/0! 0
12ii #DIV/0! 0
13 #DIV/0! 0
Shape & Space 8a 8b 11 22i 22ii 14 #DIV/0! 0
13 15 #DIV/0! 0
16 #DIV/0! 0
Measures 2 17 21 17 #DIV/0! 0
18 #DIV/0! 0
19i #DIV/0! 0
19ii #DIV/0! 0
20 #DIV/0! 0
21 #DIV/0! 0
22i #DIV/0! 0
22ii #DIV/0! 0
23 #DIV/0! 0
24 #DIV/0! 0
25a #DIV/0! 0
25b #DIV/0! 0
26 #DIV/0! 0
27 #DIV/0! 0
28 #DIV/0! 0
Total marks obtained to question by pupils
Number of Marks Awarded to Question
% Correct Response for Cohort
Warning. Adding
additional columns to
Question number
add children will
interfere with the
QCA Year 4 Mathematics Test 2006 automatic Level
Strand
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Paper 4B Level 3 - 4 Calculation. Several
changes will be
needed. Ensure that
you save data before
making changes.
Enter No. of Pupils in Grey Cell Pupil names will automatically be entered from the Mental Maths Grid
1 145-83 Calculation: subtraction 1 0 ##### 1
2i Zak has one 50p coin and three 20p coins (Method) Problem Solving: money 1 0 ##### 2i
2ii How much left after buying grapefruit (45p) & melon (59p)? Problem Solving: money 1 0 ##### 2ii
3 Write missing number on number line (0 to 1 in tenths) Decimals 1 0 ##### 3
4 Write (digital) time on the clock when cake done Measures : time 1 0 ##### 4
5i Pictures of 3D shapes and faces. Write numbers Shape and Space: properties of shapes 1 0 ##### 5i
5ii on the faces to show how many there are. (5 entries in total) Shape and Space: properties of shapes 1 0 ##### 5ii
6 4 ice creams @ 85p. How much altogether? Calculation: multiplication / money 1 0 ##### 6
7 Write the next two numbers (inc by 101): 606. 707, 808, • • , Place value, sequences, addition 1 0 ##### 7
8a How tall is Lauren's sunflower? (Reading chart) Handling data: bar charts 1 0 ##### 8a
8b How much taller is Zak's …. (Interpreting / using bar chart) Handling data: bar charts 1 0 ##### 8b
9 4 two digit number cards. Which two have a difference of 32? Problem solving: number 1 0 ##### 9
10 How many originally? (Eats 2, eats 1/2 those left, now has 6) Problem solving: number 1 0 ##### 10
11 Using given digits (1-5) to complete 5x6=• and 5x6<• Calculation: mult / ordering 1 0 ##### 11
12 Date of 2 weeks from 24th October Measures: time 1 0 ##### 12
13 Fruit salad. 3 a for 1 b. How many bananas for 27 apples? Ratio 1 0 ##### 13
14 How much higher is temp at midday than midnight? Measures: temp / negative numbers 1 0 ##### 14
15a Which number is at start of row of chart (multiples of 5) Properties of number / multiples 1 0 ##### 15a
15b Which number is at end of row on chart Properties of number / multiples 1 0 ##### 15b
16 Co-ordinates of missing point (4th point on kite) Shape and Space: co-ordinates 1 0 ##### 16
17i Two spinners. Find all differenct possible totals. (Part) Problem solving: number / reasoning 1 0 ##### 17i
17ii Two spinners. Find all differenct possible totals. (Complete) Problem solving: number / reasoning 1 0 ##### 17ii
18 Daw all the lines of symmetry on the triangle (equilateral) Shape and Space: Lines of Symmetry 1 0 ##### 18
19 Explain why … (1 pack @£3.60 c/f 20 single cards @ 20p) Problem solving: money 1 0 ##### 19
20i 64 cards. Five children have the same number (Method) Problem solving: number 1 0 ##### 20i
20ii each. 24 left over. How many for each child? (Answer) Problem solving: number 1 0 ##### 20ii
21 Picture of litre jug (full). Pour out 400 ml. Mark new level. Measures: capacity 1 0 ##### 21
22 Order 2.04, 0.24, 0.4, 24, 4. Smallest to largest Ordering numbers (2 decimal places) 1 0 ##### 22
23 Calculate 37 x 80 Calculation: multiplication 1 0 ##### 23
24 Total length round a square formed from 2 given triangles Shape and space / length 1 0 ##### 24
25 How many days had a tiotal of more than 150 visitors? Handling data: table 1 0 ##### 25
26 Give example to show mult of 10 plus mult of 10 is not mult of 20Properties of number 1 0 ##### 26
27 Find missing numbers (1 1/2 x 100 and 3/4 x 100) Calculation: multiplication by 100 / fractions 1 0 ##### 27
28 Tick the 2 cards showing the same weight. (mix of kg and grams)Measures: mass - understanding units 1 0 ##### 28
29 • 4 = 25 remainder 3. Find the missing number
÷ Calculation: division 1 0 ##### 29
Total Marks Achieved by Pupil: 35 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Total Marks (mental + written)
55 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
<L3B
<L3B
<L3B
<L3B
<L3B
<L3B
<L3B
<L3B
<L3B
<L3B
<L3B
<L3B
<L3B
<L3B
<L3B
<L3B
<L3B
<L3B
<L3B
<L3B
<L3B
<L3B
<L3B
<L3B
<L3B
<L3B
<L3B
<L3B
<L3B
<L3B
<L3B
<L3B
<L3B
<L3B
<L3B
<L3B
Level Achieved
Level Look Up Table 0 <L3B
26 L3B
32 L3A
38 L4C
43 L4B
47 L4A
QCA TEST YEAR 4 PAPER 4B Level 3 - 4 with success rate of < % highlighted
Strand Question Numbers Q. No. Correct, No. giving
and Levels as % correct
response
Number Level 3 Level 4
Counting / Properties of Numbers 1 15a 15b 26 1 #DIV/0! 0
Calculation / Understanding + & - 14 2i #DIV/0! 0
Calculation / Understanding x & ÷ 6 11 23 27 29 2ii #DIV/0! 0
Place Value & Ordering 7 22 3 #DIV/0! 0
4 #DIV/0! 0
Fractions 27 5i #DIV/0! 0
Decimals 3 5ii #DIV/0! 0
Ratio 13 6 #DIV/0! 0
7 #DIV/0! 0
8a #DIV/0! 0
Problems 8b #DIV/0! 0
Involving Money 2i 2ii 19 9 #DIV/0! 0
Involving Number 9 10 17i 17ii 10 #DIV/0! 0
20i 20ii 11 #DIV/0! 0
12 #DIV/0! 0
Data Handling 13 #DIV/0! 0
Organising and Using Data 8a 14 #DIV/0! 0
Data interpretation 8b 25 15a #DIV/0! 0
15b #DIV/0! 0
Shape & Space 5i 5ii 16 18 24 16 #DIV/0! 0
17i #DIV/0! 0
17ii #DIV/0! 0
Measures 4 12 14 21 18 #DIV/0! 0
28 19 #DIV/0! 0
20i #DIV/0! 0
20ii #DIV/0! 0
21 #DIV/0! 0
22 #DIV/0! 0
23 #DIV/0! 0
24 #DIV/0! 0
25 #DIV/0! 0
26 #DIV/0! 0
27 #DIV/0! 0
28 #DIV/0! 0
29 #DIV/0! 0
< % highlighted
No. in Threshold Enter Threshold figure
cohort Percentage figure in box on left
0 60 to perform analysis
Note:
GREEN highlighting
indicates that correct
response rate is less
than the Threshold %
