Presentation: Analysing Online Audience Feedback for the School Panto

Slide 1 of 7 · Settling starter · Drama · Year 9

3 minutes

Analysing online audience feedback for the school panto: can Mr Bowen trust his 4 stars?

You have a worksheet and, between 2, a stimulus sheet with the online feedback form for the panto Sinderela, its results tables, an automatic chart and some comments. Mr Bowen, Head of Drama, says “Nearly 4 stars, and everybody loved the songs!” Before it goes in the newsletter, you check the data: is the form fair, what do the numbers really say, and who answered?

While the register is called: write your name, class and date on your worksheet, then read The form, exactly as it was written on the stimulus sheet.

Starter question: Question 3 asks “How much did you love our amazing songs?” What is wrong with that question?

DCF: Data and computational thinking → Data and information literacy No computers needed · calculator and ruler on the desk

Supply teacher script (no subject knowledge needed)

Hand out: one worksheet per pupil, one stimulus sheet (Sinderela: the online audience feedback form and its results) between 2, a calculator and a ruler each. No computers. The school, the show, Mr Bowen and every figure are invented. Pupils may talk quietly in pairs in Steps 1 to 4; Step 5 is written alone.

Say aloud: “Name, class and date at the top. While I take the register, read the 7 questions on the form, exactly as they were written. Look hard at Question 3 and decide what is wrong with it.”

Starter answer: it is a leading question: “love our amazing songs” tells people what to think. And every answer option says “loved” (Loved them / Really loved them / Absolutely loved them), so there is no way to say you did not like the songs. The data from it can only ever look positive.

Slide 2 of 7 · Today’s brief and key words · Drama · Year 9

3 minutes

Your brief: judge the form, do the sums, find out who answered, fix the chart, advise

You will find 3 problems with the form and rewrite Question 3, work out the mean, median, mode, range and a percentage from the star ratings with working shown, compare the people who answered through the family group chat with those who used the programme QR code, explain why the automatic chart misleads and sketch a fair one, then write Mr Bowen a recommendation of 100 to 150 words backed by figures.

Mean, median, mode

Mean: add every value and divide by how many. Median: the middle value when they are in order. Mode: the most common value. Range: highest minus lowest.

Sample bias

When the people who answer are not typical of everyone, so the results lean one way. The cast’s families are not a typical audience.

Personal data

Information that identifies a person: name, address, phone number. Collect only what you really need, and never force people to give it.

DCF: Data and computational thinking → Data and information literacy LNF: Numeracy → Statistics → Interpreting data

Slide 3 of 7 · Steps 1 and 2: judge the form, then the star ratings · Drama · Year 9

17 minutes

Step 1 & Step 2: 3 problems with the form, then total, mean, mode, range, median and percentage

Step 1 (7 min): 3 problems with the questions (which question, what is wrong, how it affects the data), rewrite Question 3 fairly with new options, and say what to do about Question 6. Copy the first row from the board. Step 2 (10 min): use the All responses column of Table 1. Show working for every answer.

Q	What is wrong	How it affects the data or the people answering
3	Leading: “love our amazing songs” tells people what to think.	People are pushed towards a good answer, so the result is not their real opinion.

Steps 1 and 2 on your worksheet · 17 minutes, quietly in pairs Step 2: stars × number of people, then add · mean to 2 decimal places

Supply teacher script (no subject knowledge needed)

Say aloud: “Seven minutes for Step 1. Row 1 is on the board; find 2 more problems, rewrite Question 3 so it is fair, and say in 1 sentence what to do about Question 6. Then 10 minutes for Step 2: the All responses column of Table 1. Total stars first, then mean, mode, range, median and the percentage who gave 4 or 5 stars. Working on the sheet for every one.”

Quick check, Step 1: Q3 has no negative option: every answer says “loved”, so anyone who could not hear the songs has to pick a “loved” answer or give up. Q6 asks for a full name, home address and phone number and makes them required; the school does not need them, some people stop and do not send the form (comment 6 asks “Why do you need my home address?”), and the school now holds private data it must keep safe. (b) A fair Question 3: “How did you find the songs?” with options Very good / Good / OK / Poor / Very poor / I could not hear them. (c) Remove Question 6, or make it optional and only ask for an email address if people want news of next year’s show.

Quick check, Step 2: (a) 5 × 27 = 135, 4 × 15 = 60, 3 × 8 = 24, 2 × 4 = 8, 1 × 6 = 6; total 233 stars. (b) 233 ÷ 60 = 3.88. (c) Mode 5 (27 people). (d) Range 5 − 1 = 4. (e) Counting up: 1 star is values 1 to 6, 2 stars 7 to 10, 3 stars 11 to 18, 4 stars 19 to 33; the 30th and 31st are both 4, so median 4. (f) 27 + 15 = 42; 42 ÷ 60 × 100 = 70%. (g) He is using the mean, 3.88, pulled down by the 6 people who gave 1 star. The median, 4, is a fairer headline because it is the middle opinion; the mode, 5, would be too flattering because fewer than half gave 5 stars.

Slide 4 of 7 · Steps 3 and 4: who answered, then the misleading chart · Drama · Year 9

14 minutes

Step 3 & Step 4: response rate and the 2 group means, then fix the chart

Step 3 (8 min): response rate (60 out of 340, to 1 decimal place), the mean for each group in Table 1 to 2 decimal places, then which group is more likely to show what the whole audience thought, with 2 reasons, and why people at the back may not have answered. Step 4 (6 min): why does Friday’s bar look so much taller, how big is the real difference, sketch a fair chart from 0 to 5 with a ruler, and write an honest headline.

Group	Working	Mean
Family group chat (41)	110 + 36 + 12 + 6 + 3 = 167; 167 ÷ 41 = 4.073…	4.07

Steps 3 and 4 on your worksheet · 14 minutes A fair chart’s vertical axis starts at 0

Supply teacher script (no subject knowledge needed)

Say aloud: “Eight minutes for Step 3. The group chat mean is on the board with its working: 22 fives, 9 fours, 4 threes, 3 twos, 3 ones. Do the response rate, then the QR code group the same way, then answer (c) and (d) in sentences. Then 6 minutes for Step 4: look at the chart the form tool made, say why Friday looks so much better, work out the real difference, and draw a fair version with a ruler on the axes that go from 0 to 5.”

Quick check, Step 3: (a) 60 ÷ 340 × 100 = 17.6%. (b) QR code: 25 + 24 + 12 + 2 + 3 = 66; 66 ÷ 19 = 3.47. (c) The QR code group is more likely to show what the whole audience thought: every audience member got a programme, so anyone could answer, while the group chat only reached the cast’s families; and cast families are proud of their own children, so they rate higher, which is why their mean is 0.6 stars higher. But 19 is a small group, so even the QR results are not certain. (d) People who could not hear may have enjoyed it less and not bothered to scan the code; they are also less likely to be cast families, who usually sit near the front.

Quick check, Step 4: (a) the vertical axis starts at 3.7, not 0, so only the tops of the bars show; Friday looks almost 3 times as tall but the real difference is 3.94 − 3.79 = 0.15 stars. (b) Bars at 3.79 and 3.94 on an axis from 0 to 5 look almost the same height. (c) An honest headline: “Both nights scored nearly 4 stars from the people who replied.”

Slide 5 of 7 · Step 5: your recommendation · Drama · Year 9

9 minutes

Step 5: 100 to 150 words to Mr Bowen, on your own

Write your recommendation and count the words. Include all 4 parts.

1. What the data can tell him, with at least 3 figures you worked out today (for example median 4, 70% gave 4 or 5 stars, response rate 17.6%).

2. What the data cannot tell him, and why (who answered, and what Question 3 could never record).

3. One change to the show next year, based on the evidence in the comments.

4. Two changes to the feedback form.

Step 5 on your worksheet · 9 minutes, written alone Figures, not feelings: quote the numbers you calculated

Supply teacher script (no subject knowledge needed)

Say aloud: “Nine minutes on your own. Write to Mr Bowen: what the data can tell him with at least 3 of your figures, what it cannot tell him and why, one change to next year’s show based on the comments, and 2 changes to the form. Between 100 and 150 words; write the word count at the bottom.”

Walk the room: a secure answer, like the worked example, says most people who answered enjoyed it (median 4 stars, 70% gave 4 or 5, 52 out of 60 would come again), but only 17.6% of the audience answered and 41 of 60 came through the cast families’ group chat (mean 4.07 against 3.47 from the QR code), so the results are probably too generous; the data cannot say what the whole audience thought, and Question 3 tells him nothing because every option says “loved”. The change to the show should come from the comments: microphones near the singers or speakers at the back, because 2 comments say the back rows could not hear the songs. Form changes: a fair question about the songs, and remove the name and address question. Prompt anyone whose change to the show is based on Question 3.

Slide 6 of 7 · Self and partner check · Drama · Year 9

2 minutes

Swap with your partner and check against the success criteria

Tick each criterion your partner’s work meets. Check their recommendation has at least 3 figures and says something the data cannot tell Mr Bowen. Swap back and correct 1 thing.

I can spot leading questions, missing answer options and unnecessary personal data in an online form.
I can calculate the mean, median, mode and range from a frequency table, and a percentage, showing working.
I can explain how the way a link is shared affects who answers and how far the results can be trusted.
I can explain why a chart with an axis that does not start at 0 can mislead, and draw a fair one.
I can write a recommendation that uses figures accurately and is honest about the limits of the data.

2 minutes · partner check Finished early? Which night had the higher response rate: 24 of 150 or 36 of 190?

Supply teacher script (no subject knowledge needed)

Say aloud: “Swap worksheets. Tick the 5 criteria. Count the figures in your partner’s recommendation: fewer than 3, write more figures beside it. If it never says what the data cannot show, write limits beside it. Swap back and fix 1 thing.”

Extension answers: Thursday 24 ÷ 150 × 100 = 16%; Friday 36 ÷ 190 × 100 = 18.9%; Friday had the higher response rate, which makes sense because the group chat link was shared on Friday night. The 32 “Absolutely loved them” answers tell us almost nothing because Question 3 only offers 3 ways of saying “loved”; someone who disliked the songs had no answer to choose. A better form has 5 neutral questions with balanced options and one that helps the sound team, such as where you sat and whether you could hear the songs.

Slide 7 of 7 · Plenary review · Drama · Year 9

2 minutes

Round the room, then quick-check answers before handing in

Everyone gives 1 figure they calculated and what it shows, nobody repeats one. Then check these answers.

Question	Correct answer
Mean, median and mode of the 60 star ratings?	Mean 3.88, median 4, mode 5. Total 233 stars, range 4, 70% gave 4 or 5 stars.
Group chat mean against QR code mean, and the response rate?	4.07 against 3.47; the cast’s families rated higher. Only 17.6% of the 340 audience answered.
Why does the chart make Friday look so much better?	The axis starts at 3.7, not 0. The real difference is 3.94 − 3.79 = 0.15 stars.

Check your name and class are on your worksheet Worksheets in · stimulus sheets, calculators and rulers back