Supply teacher deck · Maths · Year 4

Sorting a School Birdwatch into a Table and Bar Chart

Slide 1 of 7
05:00

Slide 1 of 7 · Settling starter · Maths · Year 4

5 minutes

Sorting a School Birdwatch into a Table and Bar Chart

Year 4 at Ysgol y Wern watched birds for 1 hour. They made a picture card for every bird they saw. The cards are a muddle. Today we turn them into a table, a spreadsheet and a bar chart.

While the register is called: write your name, class and date on your worksheet. Look at the cards on the stimulus sheet.

Starter question: Which bird is on card 1? Which bird is on card 48?

DCF: Data and computational thinking → Data and information literacy No computers needed · ruler and coloured pencils ready

Slide 2 of 7 · Today’s brief and key words · Maths · Year 4

3 minutes

Your brief: turn 48 cards into data that answers questions quickly

You will tally the 48 cards, fill in a pretend spreadsheet, sort it from most to least, draw a bar chart and sort the 7 birds with two rules.

Tally

1 mark for each card. The 5th mark crosses the first 4, like a gate.

Cell

One box in a spreadsheet grid, named by its column letter and row number, like B3.

Carroll diagram

A grid that sorts things using two questions at once, like a database search.

LNF: Numeracy → Statistics and probability → Representing data There are 7 kinds of bird on the sheet

Slide 3 of 7 · Steps 1 and 2: tally and spreadsheet · Maths · Year 4

18 minutes

Step 1: tally the log. Step 2: fill in and sort the spreadsheet

Go along the cards from 1 to 48. Draw 1 tally mark next to each bird. Then check: 6 rows of 8 cards. Does your total match?

Bird Tally Total
Blackbird a gate of 5, then 1 more 6
Blue tit a gate of 5, then 3 more 8

Step 2: copy your totals into column B. Then write the birds again, sorted from most seen to least seen.

Steps 1 and 2 on your worksheet · 10 minutes then 8 minutes Totals must add up to 48

Slide 4 of 7 · Step 3: draw the bar chart · Maths · Year 4

12 minutes

Step 3: draw a bar chart with a ruler

Draw the bars in your sorted order, most to least. The side axis goes up in 2s. An odd number, like 7, is halfway between 6 and 8.

First bar: Starling, 13. Its top is halfway between the 12 line and the 14 line.

Second bar: House sparrow, 10. Its top sits exactly on the 10 line.

Finish it: every bar the same width, each bird’s name under the bottom axis, a title in the top box and a label in each dashed axis box.

Step 3 on your worksheet · 12 minutes Ruler, same width bars, colour them in

Slide 5 of 7 · Steps 4, 5 and 6: questions, two rules, is it true? · Maths · Year 4

12 minutes

Steps 4, 5 and 6: answer, sort with two rules, and judge the claim

Step 4: use your table or chart. Step 5: put each of the 7 birds in the right box of the Carroll diagram, using the bird fact cards for length. Step 6: which format is best, and is Gethin right?

Shorter than 20 cm Not shorter than 20 cm
Seen more than 6 times House sparrow (10, 14 cm) Starling (13, 21 cm)
Not seen more than 6 times Robin (4, 14 cm) Magpie (2, 45 cm)

Careful: is 6 “more than 6”?

Steps 4, 5 and 6 on your worksheet · about 4 minutes each Lengths are on the bird fact cards

Slide 6 of 7 · Self and partner check · Maths · Year 4

2 minutes

Check your work against the success criteria

Swap sheets with your partner. Tick each one you can see on their sheet.

  • I can tally a log and check that my totals add up to 48.
  • I can use cell names like B3 and sort the data from most to least.
  • I can draw a bar chart with a title, axis labels and bars that match a scale in 2s.
  • I can sort the birds using two rules in a Carroll diagram.
2 minutes · partner check Finished early? Try the two tasks at the bottom of your sheet

Slide 7 of 7 · Plenary review · Maths · Year 4

3 minutes

Quick-check answers before handing in

Check these answers on your sheet before it is collected.

Question Correct answer
Which bird was seen the most, and how many times? Starling, 13 times.
How many more starlings than robins were seen? 13 − 4 = 9 more.
Without the flock on cards 18 to 24, which bird would be seen the most? The house sparrow (10). Only 6 starlings would be left.
Check your name and class are on your worksheet Leave stimulus sheets neat on the desk