Cover lesson · Business · Year 11 · Advanced
DCF: Data and computational thinking → Data and information literacy
Name: Class: Date:
What this practises: GCSE Business (Made for Wales) Unit 3: Business Strategies for Success. Section 3.4 Marketing strategies for success: the marketing mix, and how technology has changed promotion (digital adverts, search engine advertising, social media marketing), with loyalty card data as internal secondary research. It also uses gross profit margin from section 3.3.4 Financial performance. Step 6 is practice for a longer “recommend” answer in the Unit 3 examination.
Print: this sheet, one per pupil, and the stimulus sheet “Pobty’r Cwm: the gift box promotion dossier”, one between two. Pupils need a calculator. No computers are needed. The results are also in pobty-campaign-results.csv if you are in a computer room. Section 8 of the dossier is new evidence: ask pupils not to read it until Step 5.
Run: 6 min read sections 1 to 7 of the dossier in pairs · 12 min Step 2, the performance table · 7 min Step 3, profit after promotion · 7 min Step 4, test Carys’s claim · 7 min Step 5, the new evidence · 16 min Step 6, the recommendation, alone and in silence. Total 55 minutes.
Collect: this sheet. The worked example has every answer.
Carys spent £1,200 promoting her Welsh cake gift boxes online and on paper. She thinks social media won and wants to spend the whole budget there next time. You are going to turn her results into statistical evidence, test her claim, then look at new data that arrived 8 weeks later and decide whether your conclusion still stands. Finally you will write the kind of recommendation the examiner asks for in Unit 3.
Read sections 1 to 7. Do not read section 8 yet. Highlight every figure in the results table that you think matters, and underline anything in the customer comments that could make the results misleading.
Use the key words in section 7. Give percentages to one decimal place and money to the nearest penny. For the leaflets, there are no clicks, so for conversion use orders ÷ leaflets delivered × 100.
| Channel | Click-through rate (%) | Conversion rate (%) | Cost per order (£) | Revenue per £1 spent (£) |
|---|---|---|---|---|
| Social media adverts | ||||
| Search engine advertising | ||||
| Email to loyalty members | ||||
| Printed leaflets | no clicks |
The gross profit margin is 60%, so gross profit = revenue × 0.6. Then take away what the channel cost.
| Channel | Gross profit (£) | Minus spend (£) | Left after promotion (£) |
|---|---|---|---|
| Social media adverts | 480 | ||
| Search engine advertising | 360 | ||
| Email to loyalty members | 60 | ||
| Printed leaflets | 300 | ||
| Whole promotion | 1,200 |
(a) Work out the cost per new customer for each channel (spend ÷ new customers).
| Social media | Search | Leaflets | |
|---|---|---|---|
(b) Carys said: “Social media got us the most clicks and the most new customers.” Is each half of that sentence true? Is it enough to justify spending the whole budget there? Use two figures.
(c) Give two weaknesses of the chart Carys showed her staff (section 4).
Now read section 8. Work out the percentage of each channel’s new customers who bought again, and the cost of finding each returning customer (spend ÷ number who bought again).
| Social media | Search | Leaflets | |
|---|---|---|---|
| % of new customers who bought again | |||
| Spend per returning customer (£) |
How does this change your conclusion from Step 4? What does the finding about the 31 email orders do to your Step 2 figures for email?
Write 200 to 250 words, on your own and in silence: Recommend how Pobty’r Cwm should spend its £1,200 budget on the next gift box promotion. Justify your answer.