Topic 33 - Processing data

Question 1

What is data?

Answer 1

Data is invaluable to organisations and individuals.
It is used to mak edecisions, spot trends, gain competitive advantage and to monitor progress.
It is at the heart of a modern company

Question 2

How can inaccurate data be a serious problem?
(Important of data accuracy)

Answer 2

Inaccurate data can be a serious problem for orgainisastions and individuals, as it leads to incorrect decisions being made

Question 3

What are the 2 examples of inaccurate data?
(Important of data accuracy)

Answer 3

• Incorrectly recorded stock levels could lead to ordering too little or too much stock
• Inaccurate traffic information could lead to being late for an interview

Question 4

What do IT systems allow us to apply?
(Methods of ensuring data accuracy)

Answer 4

• IT systems allow us to apply automated checks on data being entered.
• These do not ensure the data is 100 per cent accurate, but they do ensure it is sensible and matches the original source

(A validation error message)

Question 5

What is the 1st Methods?
(Methods of ensuring data accuracy)

Answer 5

Validation ensures data entered is sensible and reasonable

Question 6

What is the Type check to be carried out?
(Methods of ensuring data accuracy)

Answer 6

Type check - Data must be the correct type

Question 7

What is the example of Type check?
(Methods of ensuring data accuracy)

Answer 7

(Example Type Check)

Data in a date of birth field

Question 8

What is the Range check to be carried out?
(Methods of ensuring data accuracy)

Answer 8

Range check - Numerical data must be less than or greater than a certain number of digits

Question 9

What is the example of Range check?
(Methods of ensuring data accuracy)

Answer 9

(Example Range Check)

Age name must be between 18 and 65

Question 10

What is the Length check to be carried out?
(Methods of ensuring data accuracy)

Answer 10

Length check - Data must be less than or greater than a certain number of digits

Question 11

What is the example of Length check?
(Methods of ensuring data accuracy)

Answer 11

(Example Length Check)

• First name must be less than 15 characters

Question 12

What is the Format check to be carried out?
(Methods of ensuring data accuracy)

Answer 12

Format check - Data must be in the correct predefined format

Question 13

What is the example of Format check?
(Methods of ensuring data accuracy)

Answer 13

(Example Format Check)

• Postcode must be LLN NLL

Question 14

What is the 2nd Methods?
(Methods of ensuring data accuracy)

Answer 14

Verification ensures data entered matches the original source

Question 15

What is the Double-entry-check to be carried out?
(Methods of ensuring data accuracy)

Answer 15

Double-entry-check - Data must be entered twice, and both entries must match

Question 16

What is the example of Double-entry-check?
(Methods of ensuring data accuracy)

Answer 16

(Example Double-entry-check)

• Entering a password twice on a registration

Question 17

What is the Proofreading check to be carried out?
(Methods of ensuring data accuracy)

Answer 17

Proofreading check - Data must be read through to ensure there are no data entry errors

Question 18

What is the example of Format check?
(Methods of ensuring data accuracy)

Answer 18

(Example Proofreading check)

• A checkbox asking you to confirm data entered is correct

Question 19

What are the four steps of Extracting and sorting data?

Answer 19

1 - Data is extracted from unstructured sources, such as web pages (web scraping), emails and documents

2 -The data is entered into a system for processing

3 - The data is stored in a database program to add structure

4 - The database can be sorted and searched using SQL queries

Question 20

What does Data modelling ensure?
(Numerical and data modelling)

Answer 20

• Data modelling ensures that the database is
  correctly structured, allowing the data to be
  efficiently processed

Question 21

What can happen to correctly stored data?
(Numerical and data modelling)

Answer 21

• Correctly stored data can be used in numerical modelling.
• This involves simulating systems to help
  analyse data and make predictions, such as
  weather models used to forecast future
  weather patterns