lesson 7.6 data verification
Data verification ensures your data is accurate. Learn proofreading and double entry methods now!
image-00-learning-question.png
Last lesson, we were the 'digital bouncer', using validation to stop 'garbage' data from getting into our system. But what if the bouncer lets someone in, and they've just typed their name wrong? That's where verification comes in. This lesson is all about the art of double-checking. You'll learn the techniques businesses like Pedal Power Cycles use to ensure the data they enter is a perfect, error-free copy of the original.
Learning Outcomes
The Building Blocks (Factual Knowledge)
The Connections and Theories (Conceptual Knowledge)
The Skills and Methods (Procedural Knowledge)
Recall the two main methods of data verification (C2.A3.2).
The Connections and Theories (Conceptual Knowledge)
Describe the purpose of data verification.
Explain the difference between data verification and data validation.
The Skills and Methods (Procedural Knowledge)
Apply verification techniques to identify errors in a given dataset.
Digital Skill Focus: This lesson, you will focus on using clipboard editing tools - specifically cut, copy, and paste - to rapidly check, compare, and correct information.
Verification: The Art of the Double-Check
Validation vs. Verification: What's the Difference?
This is a really important distinction, and an easy place to get confused!
Validation is an automated check to see if data is sensible.
Example: A validation rule checks if the 'Quantity' is a number greater than 0. The computer can do this on its own.
Verification is a check to see if the data entered is an accurate copy of the original source.
Example: A manager types a customer's name as "Jhon Smith" from a paper form. A validation check won't spot this error because "Jhon" is sensible text. A verification check is needed to compare it to the original form and see it should have been "John".
In short: Validation checks for sensibility, Verification checks for transcription errors.
Two Key Methods of Verification
So, how do we perform this double-check? There are two main methods.
1. Proofreading
This is the simplest method. It involves one person checking the entered data against the original source document.
The Process: A data entry clerk types up a list of new customer addresses from a stack of paper forms into a spreadsheet. When they are finished, they (or a colleague) carefully read the spreadsheet on the screen while comparing it, line-by-line, with the original paper forms to spot any typing mistakes.
Advantage: It's simple and quick for small amounts of data.
Disadvantage: It's easy for the human brain to miss errors, especially if the person checking is the same person who made the mistakes. Our brains often see what we expect to see.
2. Double Entry
This is a more robust and common method used in professional systems. It involves two people entering the same data, or one person entering it twice.
The Process:
Step 1: One person enters the data from the source documents. The computer stores it but doesn't show it.
Step 2: A second person (or the same person later) enters the exact same data from the same source documents.
Step 3: The computer compares the two entries in the background. If they match perfectly, the data is accepted. If there's a difference, the system flags an error and asks the user to re-enter the data for the specific field that doesn't match.
Common Example: When you sign up for a new online account and it asks you to "Enter your password" and then "Confirm your password". This is double entry verification in action!
Advantage: It is far more accurate than proofreading and significantly reduces the chance of transcription errors.
Disadvantage: It takes twice as long and is more expensive as it requires more staff time.
Time to be the teacher. Turn to the person next to you and explain the difference between data validation and data verification in 60 seconds, as if they have never heard of it before. Use an example for Pedal Power Cycles to make your point.
Task Error Detective: The Verification Challenge
You've been asked to join the data quality team at Pedal Power Cycles. A new junior clerk has been entering data, and your job is to verify their work to make sure it's 100% accurate. Time to put on your detective hat!
1
Get Organised!
Navigate to your Component_2 -> 01-PSA-Brief folder.
Create a new word processing document and name it Verification Task.docx.
2
Part 1: The Proofreading Test
Below is a memo from a manager, followed by the version the clerk typed into the system. There are five errors in the transcribed version.
Copy both blocks of text into your document.
Use the highlighter tool in your word processor to highlight every single error you can find in the 'Transcribed Version'.
Original Memo
Please update the customer record for Mr. Smith. His recent purchase was for a 'City-Rider' bike, model CR-003, for a price of £450.50. This information is critical for our upcoming sales team meeting.Transcribed Version (Contains 5 errors)
Please update the costomer record for Mr. Smith. His recent purchase was for a 'City-Rider' bike, model CR-002, for a price of £350.50. This information is critical for our upcoming sles meeting.3
Part 2: The Double Entry Simulation
The system has flagged a verification error. Two different clerks entered the same new customer details, and they don't match. Your task is to find the differences.
Below your proofreading work, create a simple table with two columns: 'Field with Error' and 'Conflicting Data'.
Compare 'Entry 1' and 'Entry 2' below.
For every field where the data is different, add a new row to your table listing the field name and the two different entries.
Entry 1
FirstName: David
Surname: Jones
Address: 12 Park Road
City: Birmingham
Postcode: B15 2TT
BikeModel: Mountain-Pro
Entry 2
FirstName: David
Surname: Jonez
Address: 12 Park Road
City: Birmingham
Postcode: B15 2TP
BikeModel: Mountain-Pro X
Act as a data entry manager. Explain why double-entry verification is more accurate than proofreading. Use the example of entering a customer's postcode into a system. Limit the response to 100 words for a Key Stage 4 student. NO intro, NO outro, NO deviation from the topic, NO follow-up questions.
Outcome: A completed document showing 5 highlighted proofreading errors and a verification report table listing 3 data conflicts.
Hungry for more?
Everyday Verification: The next time you sign up for an online account and it asks you to confirm your password or email, recognise this as double-entry verification. Why do you think they don't use it for your username?
Proofreading Pros: Research professional proofreading techniques online. Find some tips here. What is the tip you find most useful? Try using it on your next piece of schoolwork.
Automated Verification: Research what a 'checksum' or 'hash file' is. How do these allow computers to automatically verify that a downloaded file has not been corrupted?
Application to the Component Sample PSA
In the Component 2 PSA, the data files you receive from Pedal Power Cycles may contain transcription errors. Understanding verification helps you appreciate why these errors exist. In Task 1, when you write your report on the quality of the data, you can suggest that the company's lack of verification procedures might be a reason for any inaccuracies you find. For Task 2, as you clean the data, you are effectively doing the job of a verifier, correcting mistakes to ensure the information you use for your dashboard is accurate. An accurate dashboard can only be built on accurate information.
Out of Lesson Learning
⭐ Real-World Spotting
The next time you are online or using an app, look for an example of data verification. This is most often when you are asked to enter the same piece of information twice. Write down what website or app you were using, and what information it asked you to verify (e.g., your password).
The next time you are online or using an app, look for an example of data verification. This is most often when you are asked to enter the same piece of information twice. Write down what website or app you were using, and what information it asked you to verify (e.g., your password).
⭐⭐ Pros and Cons
Create a simple two-column table. In the first column, list two advantages of using 'Proofreading' as a verification method. In the second column, list two disadvantages. Think about things like speed, cost, and accuracy.
Create a simple two-column table. In the first column, list two advantages of using 'Proofreading' as a verification method. In the second column, list two disadvantages. Think about things like speed, cost, and accuracy.
⭐⭐⭐ Verification Policy
Imagine you are the manager of Pedal Power Cycles. Write a short email (3-4 sentences) to your data entry team. In the email, explain that from now on, all new customer details must be verified using the double-entry method. Justify your decision by explaining why this is better than the old proofreading system.
Imagine you are the manager of Pedal Power Cycles. Write a short email (3-4 sentences) to your data entry team. In the email, explain that from now on, all new customer details must be verified using the double-entry method. Justify your decision by explaining why this is better than the old proofreading system.
Last modified: June 22nd, 2026
