# MENTAL TEST Y4 GRID - Excel

Shared by:
Categories
Tags
-
Stats
views:
6
posted:
5/29/2012
language:
English
pages:
7
Document Sample

```							                                                                                                                                                                   Total marks obtained to question by pupils
Number of Marks Awarded to Question

% Correct Response for Cohort
WARNING
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

Question number
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

Question number
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 %

```
Related docs
Other docs by pFh4174
South Downs NHS Trust
Karl Allen