Task 3 Objectives:

Today you will learn:
How to create pivot charts
How to create meaningful statistics

I am looking for you to:
Gather some market research on what teenagers do with their money.

 

Teacher feedback wiki

Instructions      See Teacher Info Below

Help and Resources 

Time

Welcome View welcome slide and complete first instructions

Welcome3.ppt

 

3.1 Open your billboard advert from last lesson and make changes to refine it. Open Billboard.ppt for ideas.

OPEN Billboard.ppt

 10 mins

3.2 Save  mymoney.xls and market research.doc into your mymoney folder.

SAVE mymoney.xls and market research.doc

 10 mins

3.3 Watch your teacher demonstrate how to create a pivot chart and complete the questions on market research.doc

Pivot table tutorial
mymoney2.xls

25 mins

3.4 Your teacher will assess your advert from task 2

Assess billboard.ppt

 

Plenary Discuss what statistics the market research has shown.

 

5 mins

 

*Teacher info:

You could make this task last more than one lesson by allowing students more time to complete their billboard and analyse the survey data in more detail.

Keywords: