Slide 1 of 7 · Settling starter · Maths · Year 4
5 minutesSorting 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?
Slide 2 of 7 · Today’s brief and key words · Maths · Year 4
3 minutesYour 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.
Slide 3 of 7 · Steps 1 and 2: tally and spreadsheet · Maths · Year 4
18 minutesStep 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.
Slide 4 of 7 · Step 3: draw the bar chart · Maths · Year 4
12 minutesStep 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.
Slide 5 of 7 · Steps 4, 5 and 6: questions, two rules, is it true? · Maths · Year 4
12 minutesSteps 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”?
Slide 6 of 7 · Self and partner check · Maths · Year 4
2 minutesCheck 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.
Slide 7 of 7 · Plenary review · Maths · Year 4
3 minutesQuick-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. |