Unit 1: Page 33: Processing data Flashcards

1
Q

Explain the importance of data accuracy.

A

Inaccurate data leads to incorrect decisions being made.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What are two examples of the consequences of data inaccuracy?

A
  • 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.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Methods of ensuring data accuracy data does not ensure data is 100% accurate but ensures data is what?

A

They ensure it is sensible and matches the original source.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

List two types of methods to ensure data accuracy.

A
  • Validation
  • Verification
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Describe what validation is.

A

Validation ensures data entered is sensible and reasonable.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

List the 4 types of Validation checks.

A
  • Type check
  • Range check
  • Length check
  • Format check
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Describe Type check and give an example.

A
  • Data must be the correct type
  • For example, data in a date of birth field.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Describe Range check and give an example.

A
  • Numerical data must be between set values.
  • For example, Age must be between 18 and 65.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Describe Length check and give an example.

A
  • Data must be less than or greater than a certain number of digits.
  • For example, first name must be less than 15 characters.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Describe Format check and give an example.

A
  • Data must be in the correct predefines format.
  • For example, Postcode must be LLN NLL.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Describe what verification is.

A

Verification ensures data entered matches the original source.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

List two types of verification checks.

A
  • Double entry check
  • Proofreading check
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Describe a Double Entry Check and give an example.

A
  • Data must be entered twice and both entries must match.
  • For example, entering a password twice on a registration form.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Describe Proofreading Check and give an example.

A
  • Data must be read through to ensure there are no data entry errors
  • For example, A checkbox asking you to confirm the data entered is correct.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What’s the 1st step for extracting and sorting data?

A
  1. Data is extracted from unstructured sources, such as web pages (web scraping), emails and documents.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What’s the 2nd step for extracting and sorting data?

A
  1. The data is entered into a system for processing.
17
Q

What’s the 3rd step for extracting and sorting data?

A
  1. The data is stored in a database program to add structure.
18
Q

What’s the last step for extracting and sorting data?

A
  1. The database can be sorted can be sorted and searched using SQL queries.
19
Q

Describe what data modelling is.

A

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

20
Q

Describe numerical modelling.

A

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.