School Logo

Witton Middle School


Mrs Watson

For the final two weeks of term, your priority is to complete the transition work for DSHS.

If you have done all of that and are twiddling your thumbs, then you can have a go at this project.

The project page is here:


Monday – market research: data collection

  • Click on the computer that says “Introduction: Meet Brad King”
  • Watch the overall brief video.
  • Watch the market research video.
  • Have a look at the Option A questionnaire. How could you improve it?
  • Use the template on the tab “Option C” to create your own questionnaire.
    Make sure your questions do not overlap.
  • Think about who you are going to ask. Try to get a balance or genders and ages.
  • Collect data from as many people as you can (max 20).


Tuesday – market research: analyse data

  • Look at these graphs. What problems can you identify?

Looking at the data you collected yesterday…
(If you were unable to collect sufficient data, use the data on the tab “Data Sheet – Option A”)

  • Calculate the mean, median, mode and range for each question.
    (Watch the hyperlinked videos if you need a reminder)
  • Choose the 3 questions that give you the most relevant insights.
    Present this data as a graph. Will you draw a bar chart, a line graph or a pie chart?
    You can use a spreadsheet programme or you can draw your graphs by hand.
  • What conclusions can you draw?
  • What are the limitations to your data?


Wednesday – ultimate smoothie: recipes

  • Complete the questions on nutrition labels.
  • Return to the project page
  • Click on the computer that says “Introduction: Meet Brad King”
    Watch the “Ultimate smoothie” video
  • This task will be easier with MSExcel as the spreadsheet does some of the calculations for you! If you cannot open the spreadsheet, you will have to the calculations yourself!
  • Experiment with putting in some ingredients:
    • Write the name in H9
    • Decide the mass you will use and type this in I9. You will see that the total in I15 increases
    • Copy how many kcal are in 100 g from the table in J9. You will see that the spreadsheet uses the mass from I9 to calculate how many kcals are in your smoothie. This value will appear in K9. The total kcals in your drink will automatically appear in K15.
  • You now need to come up with 4 recipes. Each recipe must:
    • Add up to 980g
    • Contain at least 5 ingredients
    • Have less than 60 kcal per 100g
    • Be something people would want to buy – use your market research
  • Save your recipes somewhere safe as you will need them tomorrow


Thursday – ultimate smoothie: labels

For each of the recipes you decided upon yesterday:

  • Calculate the amount of protein, fat and carbohydrate per 100g.
    You can use the table you used yesterday by changing column J.
  • Enter the data onto the labels on the third tab of the workbook.
  • Calculate the proportion of the reference intake and colour code
    (kcal = 2000, fat = 70g and sugar = 90g).
    like this:

Use this code to decide on your colours.

  • draw bar graphs to compare the number of kcals and the amount of protein, fat and carbohydrate in a 100g serving of each smoothie
  • Look at how nutritional information is displayed on different food packets. Which method is the easiest to understand? Why is the information important?


We will continue with this project next week….



Like last week, we are going to do a paper with a variety of questions. This time you can use a calculator.

There are some questions on probability but you should be able to work them out

Q3b) A ∩ B means “intersection” (i.e. where the venn diagram intersects or overlaps)

Q8a) write as a fraction (or a percentage or a decimal)

Q11b) write as a fraction (or a percentage or a decimal)


When you have marked it, please send me a message on epraise with your score.


Thank you and good luck!