Worked example · Science and Technology · Year 4

Building a branching database of minibeasts

DCF: Data and computational thinking → Data and information literacy

Also assessed, LNF: Numeracy → Learning that statistics represent data and that probability models chance helps us make informed inferences and decisions → 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. Totals: 0 legs 18, 6 legs 24, 8 legs 3, more than 8 legs 14, so 59 found altogether. Pupils’ own questions 8 to 11 will differ: accept any set of yes or no questions with fixed answers that ends at all 5 winged minibeasts.

Step 1: the database

MinibeastNumber of legsWings?Shell?Number found
Ladybird6YesNo4
Bumblebee6YesNo3
Large white butterfly6YesNo2
Hoverfly6YesNo5
Damselfly6YesNo1
Worker ant6NoNo9
Garden spider8NoNo3
Woodlouse14NoNo12
Brown centipede30NoNo2
Garden snail0NoYes6
Slug0NoNo4
Earthworm0NoNo8

Every record complete; numbers copied exactly. The woodlouse’s plates are not a shell. Evidences criterion 1.

Step 2: searches

(a) Ladybird, bumblebee, large white butterfly, hoverfly, damselfly.

(b) Slug, earthworm.

(c) Worker ant (9), woodlouse (12), garden snail (6), earthworm (8). The hoverfly (5) is not included, because 5 is not more than 5.

Both parts of the “and” rule checked; the boundary at 5 handled correctly. Evidences criterion 2.

Step 3: the branching database

No.Yes or No questionIf YESIf NO
1Does it have legs?Go to 4Go to 2
2Does it have a shell?Garden snailGo to 3
3Is its body made of rings?EarthwormSlug
4Does it have wings?Go to 8Go to 5
5Does it have 6 legs?Worker antGo to 6
6Does it have 8 legs?Garden spiderGo to 7
7Does it have more than 20 legs?Brown centipedeWoodlouse
8Does it have spots?LadybirdGo to 9
9Does it have large white wings?Large white butterflyGo to 10
10Is its body long and thin?DamselflyGo to 11
11Does it have only 2 wings?HoverflyBumblebee

Bold entries are the pupil’s. Each question has a fixed yes or no answer and every minibeast is reached exactly once. Other good questions: “Is it furry?” (bumblebee), “Is it blue?” (damselfly). Evidences criterion 3.

Step 4: testing

(a) Woodlouse (14 legs). (b) Yes: I chose the hoverfly. 8 No, 9 No, 10 No, 11 Yes: hoverfly.

Step 5: Carroll diagram

6 legsNot 6 legs
Wingsladybird, bumblebee, large white butterfly, hoverfly, damselfly (5 kinds)none (0)
No wingsworker ant (1)garden spider, woodlouse, brown centipede, garden snail, slug, earthworm (6)

The box is empty because all the minibeasts with wings are insects, and insects have 6 legs. 5 + 0 + 1 + 6 = 12, so every kind is in one box.

Sorted by 2 rules at once, every box counted, and the total checked against 12. Numeracy evidence. Evidences criterion 4.

Step 6: bar chart

0 legs6 legs8 legsMore than 8 legsTotal found
6 + 4 + 8 = 184 + 3 + 2 + 5 + 1 + 9 = 24312 + 2 = 1459
024681012141618202224260 legs6 legs8 legsmore than 8 legsNumber found

(c) 24 − 18 = 6 more.

Group totals added correctly from the Number found field, the bar for 3 sits halfway between 2 and 4, and the difference is read correctly. Numeracy evidence. Evidences criterion 5.

If you finish early: answers

Harvestman: it reaches question 6 and gets “Yes”, the same as the spider. Add a question there: “Does its body have 2 parts?” Yes: garden spider. No: harvestman.

Venn diagram: the 5 winged insects go in the overlap; the worker ant goes in “6 legs” only; the “wings” only part is empty; the other 6 go outside both circles.

Why this response is secure