Using and Managing Data and Information

This document covers the topic of using and managing data and information. It includes tasks such as labeling categories, creating frequency tables, graphical representation, spending analysis, network diagram, line graph, and more. The aim is to understand data management and information utilization.

Using and Managing Data and
Information

Contents
TASK 1............................................................................................................................................3
1. Label the codes for categories:...........................................................................................3
2. Frequency and percentage frequency tables:......................................................................3
3. Graphical representation:....................................................................................................5
4. Spending.............................................................................................................................6
5. Cross Table:........................................................................................................................7
6. Scatter Diagram:.................................................................................................................8
TASK 2............................................................................................................................................8
TASK 3............................................................................................................................................9
TASK 4..........................................................................................................................................13

INTRODUCTION
Data management is method of storing, managing as well as utilizing data in safe, reliable
and cost-effective process. The aim of the data governance is to assist individuals, organisations
and related items improve the utilization of information within the legislative and regulatory
system such that they would create decisions and choices that maximises the benefits of the
enterprise. A comprehensive data processing policy is growing more critical than ever as
companies increasingly dependent upon intangible assets which generate value. The study covers
multiple aspects of use as well as managing data through multiple tasks.
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:
Gender
Frequency Percentage
Male 94 47.47%
Female 102 51.51%
Prefer not to
say
2 1.01%
Total 198 100%
Age Frequency Percentage
Less than 18 9.09%

21
21 to 34 17 8.58%
35 to 47 32 16.16%
48 to 60 94 47.47%
61 and
over
37 18.68%
Total 198 100
Education Frequency Percentage
GCSE or below 67 33.83838
A’ level or
Diploma
72 36.36364
Degree or further 59 29.79798
Total 198 100
SSC
User
Frequency Percentage
Yes 69 34.84848
No 129 65.15152
Total 198 100
Spending Frequency Percentage
<100 10 5.050505
100-109 28 14.14141
110-119 71 35.85859
120-129 79 39.89899
130-140 9 4.545455
>140 1 0.505051
Total 198 100

3. Graphical representation:

4. Spending
Minimum Mean: 92
Maximum Mean: 149
Median: 198/2 = 99th value i.e. 106
Quartiles:
Q1: ¼ (198) th value = 49.5th value = (113+122)/2 = 117.5
Q2.: 2/4(198) th value = 99th value = 106
Q3: ¾ (198) th value = (126+121)/2 = 123.5
Mean and Standard Deviation:

Spending Frequency
<100 10
100-109 28
110-119 71
120-129 79
130-140 9
>140 1
Total 198
Mean = 198 / 6 = 33
Sd:
Spending Frequency (x-
mean)2
<100 10 529
100-109 28 25
110-119 71 1444
120-129 79 2116
130-140 9 576
>140 1 1024
Total 198 5714
Sd: 30.86
5. Cross Table:
Gender Yes No
Male 34 60
Female 33 69
Prefer not to
say
2 nil
Age Yes No
Less than
21
18 nil

21 to 34 17 nil
35 to 47 17 15
48 to 60 17 77
61 and
over
nil 37
6. Scatter Diagram:
TASK 2
1. Network Diagram:

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

Moving Average:
Year Quarter Sales Average Moving
Average
2015 1 139 119.5 126.0625
2 135
3 91
4 113
2016 1 145 123.75
2 137
3 95
4 118
2017 1 150 127.25
2 141
3 99
4 119
2018 1 156 133.75
2 149
3 105
4 125
Line Graph:

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

3.
Salt cheese in comparison will provide maximum profit with higher profits.
CONCLUSION
Form above study this has been articulated that Today 's corporations should have a
effective data management system that offers an effective way to handle data through a complex
yet centralised data stream. Data managing systems are based on data analysis technologies
which can involve databases, unstructured data and storage, advanced analytics tools, business
analytics and much more.