Presentation: Charting Visitor Feedback for an Online Exhibition

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

4 minutes

Charting visitor feedback for an online exhibition

Oriel Glan-y-Môr, a small gallery on the west Wales coast, ran an online exhibition called Tirlun of Year 9 landscape paintings and prints from 1 to 14 March. Today you are the gallery’s data assistant: clean the feedback, chart it honestly and decide how much it can really tell the gallery.

While the register is called: write your name, class and date on your worksheet, then read the stimulus sheet: the exhibition, the form, the 40 submissions and the social media post.

Starter question: How many visits did the exhibition page record, and what did the form fail to stop people doing?

DCF: Data and computational thinking → Data and information literacy No computers needed · no art is made today

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

2 minutes

Your brief: clean it, chart it, question it, advise

You will cross out the repeated submissions, tally the genuine ones, draw a bar chart and a pie chart by hand, work out the averages, take apart the gallery’s misleading chart, judge whether the data can be trusted and write 4 or 5 sentences of advice.

Repeat

A row with the same date and time to the minute and exactly the same answers as the row above it. Keep the first, cross out the rest.

Frequency

How many times an answer appears. Every frequency table today must total 36.

Leading question

A question that pushes people towards an answer, such as “How much did you love our amazing exhibition?”

LNF: Numeracy → Statistics and probability → Representing data Work in pencil so you can correct a tally

Slide 3 of 7 · Steps 1 and 2: find the repeats, then tally · Art · Year 9

12 minutes

Step 1 & Step 2: cross out the repeats, then tally the genuine responses

Step 1 (5 min): find the 4 repeats on the stimulus sheet and cross them out. Answer (a) and (b).

Step 2 (7 min): tally the 3 questions in bundles of 5. Each table must total 36.

Stars (Q1)	Tally	Frequency
1	\|\|	2
Search engine (Q2)	\|\|\|	3

Steps 1 and 2 on your worksheet · 12 minutes Same answers is not enough: the time must match too

Supply teacher script (no subject knowledge needed)

Say aloud: “5 minutes for Step 1. A repeat has the same date and time to the minute and exactly the same answers as the row above. Cross out every repeat on the stimulus sheet and write their numbers in (a). Then 7 minutes for Step 2: tally the 3 questions. Two rows are already done for you on the board. If a table does not total 36, you have missed a row or counted one twice.”

Quick check, Step 1: repeats are 10, 11, 21 and 24; 40 − 4 = 36 genuine. All 4 repeats are 5 stars, social media, phone. (b) Responses 1 and 18 were sent at different times (1 March 12:07 and 5 March 22:44), so they are almost certainly 2 different visitors.

Quick check, Step 2: stars 1 to 5: 2, 3, 7, 13, 11. Found us by: school website 8, social media 12, email newsletter 6, search engine 3, word of mouth 7. Device: phone 18, tablet 5, laptop 9, desktop computer 4. Every total is 36.

Slide 4 of 7 · Steps 3 and 4: bar chart, averages and pie chart · Art · Year 9

18 minutes

Step 3 & Step 4: draw the bar chart and the pie chart

Step 3 (9 min): bar chart of the star ratings with a ruler: title, both axes labelled, frequency axis from 0 with an even scale, equal gaps between bars of equal width. Then the mean, median, mode and range with working.

Step 4 (9 min): 360° ÷ 36 visitors = 10° per visitor. Show the working for every angle, check they total 360°, then draw with a protractor from the line already drawn.

Found us by	Frequency	Working	Angle
Search engine	3	3 × 10 = 30	30°

Steps 3 and 4 on your worksheet · 18 minutes Measure each new angle from the line you just drew

Supply teacher script (no subject knowledge needed)

Say aloud: “Step 3 first: draw the bar chart on the grid with a ruler, 1 square for 1 visitor, and start the frequency axis at 0. Then fill in the averages table. After about 9 minutes move to Step 4: each visitor is worth 10 degrees. Work out all 5 angles, check they add up to 360, then put the centre of your protractor on the dot, measure the first angle clockwise from the line already drawn, draw it, and measure the next angle from your new line. Label or colour each sector and add a key and a title.”

Quick check, Step 3: bar heights 2, 3, 7, 13, 11. Mean: 2 + 6 + 21 + 52 + 55 = 136; 136 ÷ 36 = 3.8 stars. Median: halfway between the 18th and 19th values, both 4, so 4 stars. Mode 4 stars (13 visitors). Range 5 − 1 = 4. The median and mode sum up the ratings best because the 2 one-star ratings pull the mean down.

Quick check, Step 4: school website 8 × 10 = 80°, social media 120°, email newsletter 60°, search engine 30°, word of mouth 70°; 80 + 120 + 60 + 30 + 70 = 360°. Accept drawn bars and angles within 2° or half a square. A good title is “How 36 visitors found Tirlun”.

Slide 5 of 7 · Steps 5 to 7: the misleading chart, trust and advice · Art · Year 9

16 minutes

Step 5, Step 6 & Step 7: take the post apart, judge the data, advise the gallery

Step 5 (6 min): the gallery’s chart starts its axis at 5. Work out how many times taller the social media bar looks than the school website bar, and how many times bigger the real number is. Give 3 more faults, then redraw it fairly from 0 using your Step 2 frequencies.

Step 6 (6 min): 450 visits: what percentage gave a genuine response? Who is missing from the sample? Rewrite Q1 so it is neutral. Find one more weakness, then work out the mode with the 4 repeats left in.

Step 7 (4 min): 4 or 5 sentences. Which channel or channels should the gallery use next year? Quote at least 2 numbers from your charts, correct the claim in the post, and suggest one change to the exhibition page.

Steps 5, 6 and 7 on your worksheet · 16 minutes “Most” means more than half

Supply teacher script (no subject knowledge needed)

Say aloud: “Look at the gallery’s post on the stimulus sheet. Its axis starts at 5, not 0. Step 5 is 6 minutes: measure the bars, find 3 more faults and redraw the chart fairly. Step 6 is 6 minutes: use your calculator for the response rate and think about who never filled in the form. Then 4 minutes for Step 7, your advice in full sentences with numbers from your charts.”

Quick check, Step 5: (a) the social media bar shows 16 − 5 = 11 units and the school website bar 8 − 5 = 3 units, so it looks 11 ÷ 3 = 3.7 times taller; really 16 ÷ 8 = 2 times, and with the repeats removed 12 ÷ 8 = 1.5 times. (b) any 3 of: the search engine bar has vanished because 3 is below the axis start; the chart counts the 4 repeats so social media is 16 not 12; the vertical axis has no label; “most of you” is false since 12 out of 36 is a third; “40 visitors” should be 36 and the genuine mean is 3.8, not 3.9. (c) bars 8, 12, 6, 3, 7 from 0, title and both axes labelled.

Quick check, Steps 6 and 7: (a) 36 ÷ 450 × 100 = 8%. (b) a self-selected sample: people who gave up before the last page, including those who could not view the pictures on a phone, never saw the form, and families who loved it are more likely to bother, so real ratings are probably lower. (c) “How would you rate the exhibition? 1 star = poor, 5 stars = excellent.” (d) Q2 has no “Other” option, or nothing blocks a second submission; with the repeats left in, 5 stars has 15 and 4 stars has 13, so the mode becomes 5. Step 7: a secure answer keeps social media (12 of 36, 120°, a third) but adds the school website (8, 80°) and word of mouth (7, 70°), which together beat social media; corrects “most”; and asks for pictures that enlarge on a phone, since 18 of 36 used a phone and 4 of the 5 low ratings came from phones.

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

2 minutes

Check your work as if you were the gallery director

Tick each success criterion on your sheet that your work meets. Swap with a partner, check that every table totals 36 and the angles total 360°, then correct 1 thing.

I can clean a data set by removing repeated submissions, using a clear rule.
I can organise raw data into frequency tables that total correctly.
I can draw an accurate bar chart with a title, labelled axes and an even scale from 0.
I can calculate pie chart angles with working and draw them accurately with a protractor.
I can calculate the mean, median, mode and range and say which best sums up the ratings.
I can explain how a chart or a question misleads, and judge how far a sample can be trusted.
I can give advice that quotes numbers from my charts accurately.

2 minutes · self and partner check Finished early? Try the tasks at the bottom of your sheet

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

2 minutes

Quick-check answers before handing in

Check these three answers before your worksheets are collected.

Question	Correct answer
Which responses are repeats, and how many genuine responses are left?	10, 11, 21 and 24; 40 − 4 = 36.
What angle does social media get on the pie chart?	12 × 10 = 120°, a third of the pie, so not “most”.
What is the genuine mean star rating, and what did the post claim?	136 ÷ 36 = 3.8 stars; the post claimed 3.9 from 40 visitors.

Check your name and class are on your worksheet Leave stimulus sheets and protractors on the desk