Using and Managing Data and Information

Using and Managing Data and Information

Contents
TASK 1..........................................................................................................................................................4
TASK 2........................................................................................................................................................10
TASK 3........................................................................................................................................................11
TASK 4........................................................................................................................................................13
TASK 5........................................................................................................................................................14

TASK 1
1. Label the codes for categories:
 Gender:
1. Male? 2. Female? 3. Prefer not to say
 Age:
1. Less than 21 2. 21 to 34 3. 35 to 47 4. 48 to 60 5. 61 and over
 Education:
1. GCSE or below 2. A’ level or Diploma 3. Degree or further
 Are you a regular user of self-checkout user?
1. Yes 2. No
2. Frequency and percentage frequency tables:

3. Graphical representation:
Gender
Male Female Prefer not to say Total

Less than 21
21 to 34
35 to 47
48 to 60
61 and over
Total
0 20 40 60 80 100 120
Age

4. Spending

TASK 2
2. Total Duration: 3+2+3+2+1+2+2+1 = 16
3. Critical path:

TASK 3
1 2 3 4
0
20
40
60
80
100
120
140
160
2017
0.5 1 1.5 2 2.5 3 3.5 4 4.5
0
20
40
60
80
100
120
140
160
2018

0.5 1 1.5 2 2.5 3 3.5 4 4.5
0
20
40
60
80
100
120
140
160
2019
0.5 1 1.5 2 2.5 3 3.5 4 4.5
0
50
100
150
200
2020
Moving Average:
Year Quarter Sales Average Moving
Average
201
5
1 239 219.5 201.13
2 235
3 191
4 213
201
6
1 245 223.75
2 237

3 195
4 218
201
7
1 250 227.25
2 241
3 199
4 219
201
8
1 156 133.75
2 149
3 105
4 125
Line Graph:
2015
: Q1 2015
: Q2 2015
: Q3 2015
: Q4 2016
: Q1 2016
: Q2 2016
: Q3 2016
: Q4 2017
: Q1 2017
: Q2 2017
: Q3 2017
: Q4 2018
: Q1 2018
: Q2 2018
: Q3 2018
: Q4
0
20
40
60
80
100
120
140
160
180
Line Graph
TASK 4
Decision Tree:

TASK 5
1.
Packet Brie Gouda
Quantity 0 0 Total Profit
Unit
Profit
5 4 = 5*4=
20
Used Symbol Max
Milk 2 2 = 2 * 2
= 4
Salt 3 2 = 3 *2 =
6
2.

3. It can be argued in the above the suspension that is fairer to have a maximum profit.