Create a survey

Things to do

 

Produce a questionnaire using word . Include a series of questions with multiple choice answers e.g.

 

  • Do you want a funday? Yes/ No/ Not bothered
  • What is the best day?Mon/ Tues/ Wed/ Thurs/ Fri/ Sat/ Sun
  • What time of day? 9 am/ 10 am/ 11 am/ 12 am/ 13 pm/ 14 pm
  • What activities would you like?
  • How long do you want it to last? 2,3,4,5 hours

 

Create a tally sheet for results

 

 

 

Interpret the results

Give the questionnaires out and when returned analyse data e.g.

Day

Number of choices

Monday

3

Tuesday

2

Wednesday

4

Thursday

5

Friday

10

Saturday

2

Sunday

3

 

Create graphs using excel- select and justify which graph details the information clearer.

 

e.g. bar chart, scatter graph, line graph

 

Interpret the results into percentages.

 

AON Work with and convert between fractions, decimals and percentages

 

E.g  10/29 x 100=34 % wanted Friday

5/29 x100=17% wanted Thursday 

 

80% said yes to a Funday 15 % weren’t bothered, 5% said no

 

Copy and paste into powerpoint and comment on data.

Use the data to work out the mean, mode and median.

 

Median

 

The median number of choices

2,2,3,3,4,5,10- 2,3,4,5,10 median = 4

Mode

e.g.The most commonly chosen day is Friday with 10 choices

 

Time of day to start

Choices

 

 

9

5

9x5

45

10

3

10x3

30

11

4

11x4

44

12

5

12x5

60

13

8

13x8

104

14

4

14x4

56

Total

 

 

339

 

Mean

 

The mean starting time was

339/(5+3+4+5+8+4=29)=11.68 so a wanted mean start time of around 11.45am.

 

Mode

9,9,9,9,9,10,10,10,11,11,11,11,12,12,12,12,12,13,13,13,13,13,13,13,13,14,14,14,14,

Mode is 13 i.e.most common