Cover lesson · MFL · Year 8 · Intermediate
DCF: Data and computational thinking → Data and information literacy
Name: Class: Date:
What this practises: designing an online form that collects data fairly and safely, in French. Pupils check a draft French survey for a twin school and find what is wrong: it asks for names, emails and dates of birth it does not need, its time options overlap, one question is leading, and a free-text box makes the answers hard to count. They rewrite the questions in French, sort 30 typed replies into a frequency table, judge how to choose a fair sample, and compare the 2 schools using percentages. The French needed is in the glossary. The schools and the data are invented.
Print: this sheet, one per pupil, and the stimulus sheet “Sondage : ton temps libre. The draft online survey and the first replies”, one between two. Pupils need a calculator. No computers are needed. French dictionaries help but are not essential.
Run: 10 min Step 1, check the draft · 12 min Step 2, rewrite the questions in French · 12 min Step 3, tally the 30 replies · 8 min Step 4, a fair sample and a fair comparison · 8 min Step 5, keeping the data safe. Total 50 minutes. Pupils may work in pairs, but each pupil fills in their own sheet.
Collect: this sheet.
Quick checks: Step 1: questions 1 to 3 collect personal data the survey does not need, and make it required; question 4’s options overlap at 1, 2 and 3 hours; question 5 is leading (“Sport is great, isn’t it?”) and has only yes or no; question 6 is free text. Step 3 frequencies: sport 9, music 6, video games 7, reading 3, drawing 2, other 3, total 30. Step 4: the football club would over-count sport; every 3rd pupil of 150 gives 50; sport is 30% in both schools; video games 23.3% in France and 28% in Wales. The worked example has every answer.
Your school and a school in Brittany want to find out how pupils spend their free time, using the same online survey in both countries. A badly designed form gives you data you cannot use, or data you should never have collected. Your job is to fix the French survey before anyone fills it in, then try out the improved version on real-looking data.
Key words:
Use the glossary to work out what each question in Part A means. Then find what is wrong.
| Q | What it means in English | What is wrong with it, and why it matters |
|---|---|---|
| 1 to 3 | ||
| 4 | ||
| 5 | ||
| 6 |
A pupil spent exactly 2 hours on a screen last night. Which box in question 4 should they tick? Explain the problem.
Write the improved survey in French. Use the glossary and the French in the draft to help you.
(a) A first line that tells people the survey is anonymous and they should not give their name:
(b) Instead of questions 1 to 3, one question asking their age, with 4 tick-box options:
(c) Question 4 with 4 options that do not overlap. Tip: de 0 à 59 minutes, de 1 h à 1 h 59 ...
(d) Question 5 as a fair question: Tu aimes le sport ? with 3 options that include a negative answer:
(e) Question 6 with 6 tick boxes instead of a free-text box. The last one must be autre.
Sort the 30 typed replies in Part B into the 6 options of your new question 6. Write the reply numbers in each row, then the frequency. Some replies say the same thing in different words: le foot, jouer au foot and le football are all sport.
| Option | Reply numbers | Tally | Frequency |
|---|---|---|---|
| le sport | |||
| la musique | |||
| les jeux vidéo | |||
| la lecture | |||
| le dessin | |||
| autre | |||
| Total |
Check that your total is 30. Then explain why tick boxes are better than a free-text box for this question.
(a) Read Part C. Why would asking the football club give an unfair picture of Year 8?
(b) Mr Jenkins asked every 3rd pupil on the register of 150. Show that this gives 50 pupils.
(c) The French class has 30 pupils and the Welsh sample has 50, so you cannot compare the raw numbers. Work out each option as a percentage of its school’s total. Round to 1 decimal place.
| Option | France (out of 30) | France % | Wales (out of 50) | Wales % |
|---|---|---|---|---|
| Sport | 15 | |||
| Music | 10 | |||
| Video games | 14 | |||
| Reading | 4 |
(d) Write one true sentence comparing the 2 schools, using percentages.
(a) The draft made name, email and date of birth obligatoire. Give 2 reasons why a school survey about hobbies should not collect them.
(b) The 2 schools will share the results. What should they share: every pupil’s individual answers, or the totals and percentages? Why?