Topic 33 - Processing data Flashcards
What is data?
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
How can inaccurate data be a serious problem?
(Important of data accuracy)
Inaccurate data can be a serious problem for orgainisastions and individuals, as it leads to incorrect decisions being made
What are the 2 examples of inaccurate data?
(Important of data accuracy)
- 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
What do IT systems allow us to apply?
(Methods of ensuring data accuracy)
- 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)
What is the 1st Methods?
(Methods of ensuring data accuracy)
Validation ensures data entered is sensible and reasonable
What is the Type check to be carried out?
(Methods of ensuring data accuracy)
Type check - Data must be the correct type
What is the example of Type check?
(Methods of ensuring data accuracy)
(Example Type Check)
Data in a date of birth field
What is the Range check to be carried out?
(Methods of ensuring data accuracy)
Range check - Numerical data must be less than or greater than a certain number of digits
What is the example of Range check?
(Methods of ensuring data accuracy)
(Example Range Check)
Age name must be between 18 and 65
What is the Length check to be carried out?
(Methods of ensuring data accuracy)
Length check - Data must be less than or greater than a certain number of digits
What is the example of Length check?
(Methods of ensuring data accuracy)
(Example Length Check)
- First name must be less than 15 characters
What is the Format check to be carried out?
(Methods of ensuring data accuracy)
Format check - Data must be in the correct predefined format
What is the example of Format check?
(Methods of ensuring data accuracy)
(Example Format Check)
- Postcode must be LLN NLL
What is the 2nd Methods?
(Methods of ensuring data accuracy)
Verification ensures data entered matches the original source
What is the Double-entry-check to be carried out?
(Methods of ensuring data accuracy)
Double-entry-check - Data must be entered twice, and both entries must match
What is the example of Double-entry-check?
(Methods of ensuring data accuracy)
(Example Double-entry-check)
- Entering a password twice on a registration
What is the Proofreading check to be carried out?
(Methods of ensuring data accuracy)
Proofreading check - Data must be read through to ensure there are no data entry errors
What is the example of Format check?
(Methods of ensuring data accuracy)
(Example Proofreading check)
- A checkbox asking you to confirm data entered is correct
What are the four steps of Extracting and sorting data?
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
What does Data modelling ensure?
(Numerical and data modelling)
- Data modelling ensures that the database is
correctly structured, allowing the data to be
efficiently processed
What can happen to correctly stored data?
(Numerical and data modelling)
- 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
