Data‑validation rules – apply the five standard checks to prevent incorrect data entry.
Cross‑referencing – ensure that tables, charts and textual references match the source data.
Peer review – another person examines the work for logical, factual or presentation errors.
Test cases – predefined inputs with expected outputs used to verify software functions.
Validation activities – checking that the final product meets the brief or user requirements (e.g., confirming the grading scale follows school policy).
Validation in Spreadsheet Software
Most spreadsheet packages (e.g., Microsoft Excel, Google Sheets) provide a Data Validation dialog where the five checks can be set.
Select the range of cells for “Score”.
Open Data → Data Validation.
Choose “Whole number” and set the minimum to 0 and the maximum to 100 (Range check).
Optionally tick “Show input message” to remind users of the required format.
Evidence of Proofing (AO 3)
For assessment, learners must record the proofing process. The record demonstrates analysis and evaluation of their work and provides the evidence required for AO 3.
Practical Activity – Proof a Sample Report
Task: Using the checklist below, proof the supplied “Class Performance Report” (Word document). Record your findings in the “Verified?” and “Validated?” columns.
Run spell‑check and grammar checker (note any limitations).
Verify that every student name matches the enrolment list (verification).
Validate that the grading scale follows the school policy (validation).
Check page numbers, headers, footers and that no widows/orphans appear (visual verification).
Cross‑reference each chart with its source table.
Ask a peer to review the document and note any additional comments.
Verify that all student names are spelled correctly and match the enrolment list.
Validate that the grading scale used matches the school policy.
Print a test copy to verify page breaks, page numbers, headers and footers (visual verification).
Cross‑reference each chart with its source data table to ensure figures match.
Ask a colleague to review the report for any overlooked errors.
Record the verification and validation results in the checklist – this forms the AO 3 evidence.
Key Points to Remember
Verification = “Did we build it right?” – focus on technical accuracy.
Validation = “Did we build the right product?” – focus on meeting user or client requirements.
Both activities are essential for high‑quality ICT products and are assessed under AO 1‑3.
Use a blend of automated tools (spell‑check, data‑validation dialogs) and human review (peer check, visual verification).
Document the proofing process – this provides the required AO 3 evidence for the exam and for real‑world projects.
Suggested Diagram
Flowchart showing the relationship between verification and validation steps in a typical ICT project (Specification → Design → Coding → Verification → Integration → Validation → Release).
Self‑Check Questions
Define verification and validation in your own words, using the exact syllabus wording.
Give two examples of verification activities and two examples of validation activities.
Why is it important to perform both verification and validation before publishing a document?
Explain how the five standard data‑validation rules can prevent errors in a spreadsheet.
Describe a situation where a document passes verification but fails validation.
Support e-Consult Kenya
Your generous donation helps us continue providing free Cambridge IGCSE & A-Level resources,
past papers, syllabus notes, revision questions, and high-quality online tutoring to students across Kenya.