Data Management Data Verification Data Validation Data Verification

  • Slides: 14
Download presentation
Data Management • Data Verification • Data Validation

Data Management • Data Verification • Data Validation

Data Verification • Double Entry • Parallel Entry • Verify against the original source

Data Verification • Double Entry • Parallel Entry • Verify against the original source

Double Entry Please Enter Your Password : ****** Re-enter your password : ****** Sorry!

Double Entry Please Enter Your Password : ****** Re-enter your password : ****** Sorry! Not the same. Please re-enter!

Double Entry Please Enter Your Password : ****** Re-enter your password : ******

Double Entry Please Enter Your Password : ****** Re-enter your password : ******

Parallel Entry 246789 246879

Parallel Entry 246789 246879

Verify with original Enter you student number : 9801234 Student Card No: 9801234 Correct

Verify with original Enter you student number : 9801234 Student Card No: 9801234 Correct ? Name: Chan ching Sex: F

Data Validation • • • Type Check Range Check Presence Check Control Total Check

Data Validation • • • Type Check Range Check Presence Check Control Total Check Digit

Type Check Name : Le 0 n La 1 Invalid

Type Check Name : Le 0 n La 1 Invalid

Range Check Date of birth : 32/13/1986 Invalid

Range Check Date of birth : 32/13/1986 Invalid

Presence Check Name : Leon Lai Date of birth : 23/3/1986 Student Number: Sex

Presence Check Name : Leon Lai Date of birth : 23/3/1986 Student Number: Sex : F Invalid

Control Total Check Total number of students in class = 40 DATA Invalid Number

Control Total Check Total number of students in class = 40 DATA Invalid Number of records processed = 39

Check Digit- weighted modulo 11 method Use the ID no E 453712(x) as an

Check Digit- weighted modulo 11 method Use the ID no E 453712(x) as an example Weightings: 8 7 6 5 4 3 2 X = 14 * 11 - (5*8 + 4*7 +5*6 +3*5 + 7*4 + 1*3 + 2*2) = 154 - 148 = 6 Valid ID no = E 453712( 6 )

Verification vs Validation • Verification • Validation • Make sure the data entered •

Verification vs Validation • Verification • Validation • Make sure the data entered • Make sure the data meets the specified criteria entered is the same as • Name must be letters the source • Months must be 1 – 12 • All necessary fields must be present e. g. student no. • Numbers must match with the check digit

Web reference • http: //www. webopedia. com/ • http: //www. ora. com/reference/dictionary/

Web reference • http: //www. webopedia. com/ • http: //www. ora. com/reference/dictionary/