Worked example · Mathematics and Numeracy · Year 4

Sorting a school birdwatch into a table and bar chart

DCF: Data and computational thinking → Data and information literacy

Also assessed, LNF: Numeracy → Statistics and probability → Representing data

What this is

A secure Year 4 response, annotated so you can see which success criterion each part meets. It is also the answer key. Key figures: starling 13, house sparrow 10, blue tit 8, blackbird 6, woodpigeon 5, robin 4, magpie 2; total 48. Most: starling. Least: magpie. Without the flock there are 6 starlings and the house sparrow is most common.

Step 1: tally chart

BirdTallyTotal
Blackbird6 tally marks6
Blue tit8 tally marks8
House sparrow10 tally marks10
Magpie2 tally marks2
Robin4 tally marks4
Starling13 tally marks13
Woodpigeon5 tally marks5
All the totals added together48

Check: 6 rows of 8 cards is 6 × 8 = 48 cards. My totals add up to 6 + 8 + 10 + 2 + 4 + 13 + 5 = 48. They match.

Tallies are grouped in gates of 5, and the total is checked against 6 × 8. Evidences criterion 1.

Step 2: the spreadsheet

AB
1BirdNumber seen
2Blackbird6
3Blue tit8
4House sparrow10
5Magpie2
6Robin4
7Starling13
8Woodpigeon5
9Total48

(b) The number of robins is in cell B6. Cell B4 holds 10 (the house sparrows).

(c) Sorted, most to least

AB
1BirdNumber seen
2Starling13
3House sparrow10
4Blue tit8
5Blackbird6
6Woodpigeon5
7Robin4
8Magpie2

(d) Cell A2 holds Starling. Cell B8 holds 2.

Each number moves with its bird when the rows are sorted, and cells are named column first, then row. Evidences criterion 2.

Step 3: bar chart

Model bar chart of the birds seen at Ysgol y Wern, sorted from most to least 0 2 4 6 8 10 12 14 16 Starling Housesparrow Bluetit Blackbird Woodpigeon Robin Magpie Birds seen at Ysgol y Wern in 1 hour Number of birds seen Type of bird

Bars are in sorted order and the same width. Odd values (13 and 5) sit halfway between two lines. There is a title and both axes are labelled. Evidences criterion 3.

Step 4: answers

QuestionAnswer
(a) MostStarling (13)
(b) LeastMagpie (2)
(c) Exactly 8 timesBlue tit
(d) Starlings compared with robins13 − 4 = 9 more
(e) House sparrows compared with blackbirds10 − 6 = 4 more
(f) Altogether48

Differences are found by subtracting, and the total matches the check in Step 1. Evidences criterion 4.

Step 5: Carroll diagram

Shorter than 20 cmNot shorter than 20 cm
Seen more than 6 timesHouse sparrow (10, 14 cm)
Blue tit (8, 12 cm)
Starling (13, 21 cm)
Not seen more than 6 timesRobin (4, 14 cm)Blackbird (6, 24 cm)
Woodpigeon (5, 41 cm)
Magpie (2, 45 cm)

The database search finds the house sparrow and the blue tit.

Every bird is in exactly one box. The blackbird, seen exactly 6 times, is correctly placed in “not seen more than 6 times”. Evidences criterion 5.

Step 6: which is best, and is it true?

QuestionBest way
Which bird was seen first?The log (card 1 is a house sparrow)
Exactly how many blue tits were seen?The spreadsheet (8)
Which bird was seen most, at a quick glance?The bar chart (tallest bar)
Which small birds were seen more than 6 times?The Carroll diagram

(b) 13 − 7 = 6 starlings. The house sparrow (10) would be seen the most.

(c) I do not agree. We only watched for 1 hour, at 1 school, on 1 day. Also, 7 of the 13 starlings came in one flock, all at once. Without the flock, house sparrows win. Some birds may have been counted twice if they flew off and came back.

(d) Ask lots of schools all over Wales to count for 1 hour on the same days, at different times of year, and add all the results together.

The pupil matches each question to the format that answers it best, and uses the data itself (the flock) to show the claim is not supported. Evidences criterion 6.

If you finish early: answers

New Carroll diagram. Has some red or orange feathers and seen more than 6 times: none. Red or orange, not more than 6 times: robin. No red or orange, more than 6 times: starling, house sparrow, blue tit. No red or orange, not more than 6 times: blackbird, woodpigeon, magpie. (The blackbird’s beak is orange, but its feathers are not.) An empty box is a correct answer.

Pairs that make 10: blue tit and magpie (8 + 2) and blackbird and robin (6 + 4).

Why this response is secure