AS Level ICT Data entry Validation Validation Validation
![AS Level ICT Data entry: Validation AS Level ICT Data entry: Validation](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-1.jpg)
![Validation • Validation is a check that is carried out during the process of Validation • Validation is a check that is carried out during the process of](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-2.jpg)
![Validation checks • Validation checks are used to restrict the data that can be Validation checks • Validation checks are used to restrict the data that can be](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-3.jpg)
![Validation checks • These validation checks include: – Data type checks – Presence checks Validation checks • These validation checks include: – Data type checks – Presence checks](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-4.jpg)
![Validation checks • These validation checks include: – Format checks – Check digits – Validation checks • These validation checks include: – Format checks – Check digits –](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-5.jpg)
![Data type checks • Character type checks make sure that the correct type of Data type checks • Character type checks make sure that the correct type of](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-6.jpg)
![Data type checks Data type checks](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-7.jpg)
![Presence checks • Presence checks ensure that data that must be entered is entered Presence checks • Presence checks ensure that data that must be entered is entered](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-8.jpg)
![Length checks • A length check makes sure that the number of characters entered Length checks • A length check makes sure that the number of characters entered](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-9.jpg)
![Length checks • If this data is entered into a field specially set up Length checks • If this data is entered into a field specially set up](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-10.jpg)
![File/Table lookups • A lookup table contains a list of valid codes that can File/Table lookups • A lookup table contains a list of valid codes that can](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-11.jpg)
![File/Table lookups Example: • A data management system for a restaurant uses lookup tables File/Table lookups Example: • A data management system for a restaurant uses lookup tables](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-12.jpg)
![File/Table lookups Code Description Price File/Table lookups Code Description Price](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-13.jpg)
![File/Table lookups • When the unique code is entered, the item description and price File/Table lookups • When the unique code is entered, the item description and price](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-14.jpg)
![Cross field checks • Cross field checks occur when data in one field needs Cross field checks • Cross field checks occur when data in one field needs](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-15.jpg)
![Cross field checks Example: • The salutation field on a record contains the value Cross field checks Example: • The salutation field on a record contains the value](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-16.jpg)
![Range checks • Range checks make sure that numerical data falls between pre-determined limits Range checks • Range checks make sure that numerical data falls between pre-determined limits](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-17.jpg)
![Check digits • When large numbers are entered into a data system there is Check digits • When large numbers are entered into a data system there is](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-18.jpg)
![Check digits Example: • Check digits are found on barcodes • When the barcode Check digits Example: • Check digits are found on barcodes • When the barcode](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-19.jpg)
![Check digits Example: • The first number (4) is the check digit • Starting Check digits Example: • The first number (4) is the check digit • Starting](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-20.jpg)
![Check digits Example: • 315 is then divided by 11 (there are 11 numbers) Check digits Example: • 315 is then divided by 11 (there are 11 numbers)](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-21.jpg)
![Format checks • A format check ensures that data conforms to the requisite combination Format checks • A format check ensures that data conforms to the requisite combination](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-22.jpg)
![Parity checks • When data is transmitted from one computer to another it is Parity checks • When data is transmitted from one computer to another it is](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-23.jpg)
![Parity checks Example: • Data is being transmitted via a data link from one Parity checks Example: • Data is being transmitted via a data link from one](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-24.jpg)
![Spell checks • Most computer applications have a spell check function • This spell Spell checks • Most computer applications have a spell check function • This spell](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-25.jpg)
![Spell checks • The spell check function can – in some applications – be Spell checks • The spell check function can – in some applications – be](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-26.jpg)
![Grammar checks • The grammar check function can – in word processing applications – Grammar checks • The grammar check function can – in word processing applications –](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-27.jpg)
![Grammar checks Example: Grammar checks Example:](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-28.jpg)
![Custom dictionaries • If a spell check function is enabled it should automatically identify Custom dictionaries • If a spell check function is enabled it should automatically identify](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-29.jpg)
![Custom dictionaries Example: • A spell check identifies the surname Bellingham as a spelling Custom dictionaries Example: • A spell check identifies the surname Bellingham as a spelling](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-30.jpg)
![AS Level ICT Data entry: Validation AS Level ICT Data entry: Validation](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-31.jpg)
- Slides: 31
![AS Level ICT Data entry Validation AS Level ICT Data entry: Validation](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-1.jpg)
AS Level ICT Data entry: Validation
![Validation Validation is a check that is carried out during the process of Validation • Validation is a check that is carried out during the process of](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-2.jpg)
Validation • Validation is a check that is carried out during the process of data entry • It is also the process by which data is accepted as being sensible and reasonable in the context within which it is being used • Validation is performed by the computer program that is in use, and consists of a series of checks that are called validation checks
![Validation checks Validation checks are used to restrict the data that can be Validation checks • Validation checks are used to restrict the data that can be](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-3.jpg)
Validation checks • Validation checks are used to restrict the data that can be entered so that it complies with the data rules that have been laid down • There are several different type of validation check that can be used, each of which has specific uses
![Validation checks These validation checks include Data type checks Presence checks Validation checks • These validation checks include: – Data type checks – Presence checks](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-4.jpg)
Validation checks • These validation checks include: – Data type checks – Presence checks – Length checks – File/Table lookups – Cross field checks – Range checks
![Validation checks These validation checks include Format checks Check digits Validation checks • These validation checks include: – Format checks – Check digits –](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-5.jpg)
Validation checks • These validation checks include: – Format checks – Check digits – Parity checks – Spell checkers – Grammar checkers – Custom dictionaries
![Data type checks Character type checks make sure that the correct type of Data type checks • Character type checks make sure that the correct type of](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-6.jpg)
Data type checks • Character type checks make sure that the correct type of data has been entered Example: • A letter has been entered into a database field that has been pre-set so that only it will only accept numerical data • The incorrect data type triggers a warning message and will not allow further data to be entered until the error has been corrected
![Data type checks Data type checks](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-7.jpg)
Data type checks
![Presence checks Presence checks ensure that data that must be entered is entered Presence checks • Presence checks ensure that data that must be entered is entered](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-8.jpg)
Presence checks • Presence checks ensure that data that must be entered is entered Example: • An online application form for a job requires the applicant to include their National Insurance number • If that was not entered the presence check would detect this and notify whoever was entering the data
![Length checks A length check makes sure that the number of characters entered Length checks • A length check makes sure that the number of characters entered](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-9.jpg)
Length checks • A length check makes sure that the number of characters entered into field matches that fields requirements Example: • A National Insurance number will have two letters, followed by six numbers, followed by one letter (e. g. YY 232425 A)
![Length checks If this data is entered into a field specially set up Length checks • If this data is entered into a field specially set up](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-10.jpg)
Length checks • If this data is entered into a field specially set up to only accept data that is nine characters long, a length check will immediately identify if more or less than that number of characters has been entered
![FileTable lookups A lookup table contains a list of valid codes that can File/Table lookups • A lookup table contains a list of valid codes that can](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-11.jpg)
File/Table lookups • A lookup table contains a list of valid codes that can be used to enter data • If a code that is not in the lookup table is entered, it is rejected • This prevents any incorrect data from being processed
![FileTable lookups Example A data management system for a restaurant uses lookup tables File/Table lookups Example: • A data management system for a restaurant uses lookup tables](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-12.jpg)
File/Table lookups Example: • A data management system for a restaurant uses lookup tables that contain the codes for each course that can be ordered
![FileTable lookups Code Description Price File/Table lookups Code Description Price](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-13.jpg)
File/Table lookups Code Description Price
![FileTable lookups When the unique code is entered the item description and price File/Table lookups • When the unique code is entered, the item description and price](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-14.jpg)
File/Table lookups • When the unique code is entered, the item description and price are automatically entered • The system prompts the user to enter a correct code and does do allow incorrect codes to be entered
![Cross field checks Cross field checks occur when data in one field needs Cross field checks • Cross field checks occur when data in one field needs](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-15.jpg)
Cross field checks • Cross field checks occur when data in one field needs to be checked against data in another field in order for it to make sense • The simplest forms of cross field checks depend upon the use of check boxes, radio buttons, and/or drop down lists • In this cases it is simple for the cross field checks to take place
![Cross field checks Example The salutation field on a record contains the value Cross field checks Example: • The salutation field on a record contains the value](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-16.jpg)
Cross field checks Example: • The salutation field on a record contains the value ‘Mrs’ but the gender field has been ticked to show the gender is ‘Male’ • The cross field check would identify this anomaly and should flag the record up for checking
![Range checks Range checks make sure that numerical data falls between predetermined limits Range checks • Range checks make sure that numerical data falls between pre-determined limits](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-17.jpg)
Range checks • Range checks make sure that numerical data falls between pre-determined limits (i. e. within a certain range of numbers) Example: • Data about a pensioner is being added to a database • The bottom limit of the age range is 65 • If the age is entered as 56, the range check will display this as an error because the age falls outside the pre-determined limits
![Check digits When large numbers are entered into a data system there is Check digits • When large numbers are entered into a data system there is](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-18.jpg)
Check digits • When large numbers are entered into a data system there is always a chance of error • To help to overcome this problem an additional number is often added to the end of the original number • This number is a check digit, and is calculated from the other numbers in the original number
![Check digits Example Check digits are found on barcodes When the barcode Check digits Example: • Check digits are found on barcodes • When the barcode](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-19.jpg)
Check digits Example: • Check digits are found on barcodes • When the barcode is scanned, the computer automatically removes the end number and uses the rest of the numbers to calculate what the check digit should be • If the result is the same, then the number has been entered correctly
![Check digits Example The first number 4 is the check digit Starting Check digits Example: • The first number (4) is the check digit • Starting](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-20.jpg)
Check digits Example: • The first number (4) is the check digit • Starting from the left, the next number (7) is multiplied by 11, the second (8) by 10, and so on • The total is then found: 7 x 11 + 8 x 10 + 0 x 9 + 8 x 8+3 x 7+2 x 6+1 x 5+8 x 4+1 x 3+6 x 2+9 x 1 = 315
![Check digits Example 315 is then divided by 11 there are 11 numbers Check digits Example: • 315 is then divided by 11 (there are 11 numbers)](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-21.jpg)
Check digits Example: • 315 is then divided by 11 (there are 11 numbers) and the answer is 28 with a remainder of 7 • The remainder is then deducted from 11 and the result should equal the check digit (11 – 7 = 4) • As the check digit is 4, the barcode has been entered correctly
![Format checks A format check ensures that data conforms to the requisite combination Format checks • A format check ensures that data conforms to the requisite combination](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-22.jpg)
Format checks • A format check ensures that data conforms to the requisite combination of characters • It achieves this by the use of a data input mask Example: • A field in a data management system has been allocated so that National Insurance numbers can be inputted into it • The field has a data input mask that will only allow data that follows the correct combination of letters and numbers (e. g. YY 232425 A [LLNNNNNNL]) to be entered
![Parity checks When data is transmitted from one computer to another it is Parity checks • When data is transmitted from one computer to another it is](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-23.jpg)
Parity checks • When data is transmitted from one computer to another it is important that does not become damaged or ‘corrupted’ during transmission • Parity checking is a means of doing this • Parity is the sum of the bits within a piece of data • A parity error occurs when one of the bits is changed
![Parity checks Example Data is being transmitted via a data link from one Parity checks Example: • Data is being transmitted via a data link from one](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-24.jpg)
Parity checks Example: • Data is being transmitted via a data link from one computer to another • During the transmission of the data there is an interruption • This may not be noticed by anyone using either computer, but a parity check will alert them to the fact that data is incomplete or corrupted
![Spell checks Most computer applications have a spell check function This spell Spell checks • Most computer applications have a spell check function • This spell](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-25.jpg)
Spell checks • Most computer applications have a spell check function • This spell check function can usually be ‘enabled’ (switched on) so that it can check the spelling of data as it is entered and automatically identify any mistakes
![Spell checks The spell check function can in some applications be Spell checks • The spell check function can – in some applications – be](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-26.jpg)
Spell checks • The spell check function can – in some applications – be enabled to automatically correct what appear to incorrect spellings, but this option should always be used with caution as it may lead to words that are not recognised but that are spelt correctly being ‘corrected’ Example: • An spell checker set to correct spelling ‘mistakes’ automatically changed a person’s surname from ‘Connew’ to ‘Conned’ – it replaced the correct spelling with another, incorrect word
![Grammar checks The grammar check function can in word processing applications Grammar checks • The grammar check function can – in word processing applications –](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-27.jpg)
Grammar checks • The grammar check function can – in word processing applications – be enabled to identify what appears to be the use of incorrect grammar, and to suggest alternatives
![Grammar checks Example Grammar checks Example:](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-28.jpg)
Grammar checks Example:
![Custom dictionaries If a spell check function is enabled it should automatically identify Custom dictionaries • If a spell check function is enabled it should automatically identify](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-29.jpg)
Custom dictionaries • If a spell check function is enabled it should automatically identify any words that it does not recognise • Spell checkers often fail to recognise proper names (i. e. the names of people or places) or specialist words or jargon • It is possible to avoid this by setting up customised dictionaries to which words can be added • Once a word had been add to the customised dictionary, the spellchecker will recognised the new words as being spelt correctly
![Custom dictionaries Example A spell check identifies the surname Bellingham as a spelling Custom dictionaries Example: • A spell check identifies the surname Bellingham as a spelling](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-30.jpg)
Custom dictionaries Example: • A spell check identifies the surname Bellingham as a spelling mistake • Once that surname is added to the custom dictionary, it is no longer identified as a spelling mistake as it is now on the list of correctly spelt words that the spell check function checks against
![AS Level ICT Data entry Validation AS Level ICT Data entry: Validation](https://slidetodoc.com/presentation_image_h/df0e3ef13dd5aa07d459b9bacd7d523b/image-31.jpg)
AS Level ICT Data entry: Validation
Length check ict
Validation check ict
Advantages of single entry system
New entry entrepreneurship
Difference between single entry and double entry
Cambridge technicals ict level 3 unit 1 resources
Coborn's edi
Fighter brand strategy
Uci entry level writing requirement
Eclipse driver training
Eduqas esubmission
Gis data validation
Gis data validation
Data validation software
Data types ict
Teach ict data protection act
Data protection act 1998 ict
What is touch system data entry
Udise+ data entry module
Rch portal
Pengolahan data editing, coding processing cleaning
Qc definition
Mgnrega data entry
Introduction to data entry
Www.idsp.nic.in data entry
Touchpad input or output device
Awaassoft data entry
Ncd nhp gov in
Hmis clearance
Fsaa performance task portal
What is dhims
Awaassoft data entry