Be able to use validation routines to minimise data entry errors

What is Proofing?

Proofing is like checking a recipe before you start cooking. You want to make sure every ingredient is correct, the measurements are right, and nothing is missing. In data entry, proofing means validating the information you put into a system so that mistakes are caught early.

Common Types of Validation

• ?? Syntax validation – checks that the format is correct (e.g., email, phone number).
• ?? Range validation – ensures a number falls within a set range (e.g., age 0–120).
• ?? Consistency validation – checks that related fields match (e.g., password & confirm password).

Using Validation in Spreadsheets

In Excel or Google Sheets, you can set up rules that pop up a warning when data is wrong.

1. Click the cell or range you want to validate.
2. Go to Data > Data Validation.
3. Choose the type of rule (e.g., Whole number, Text length, Custom formula).
4. Set the criteria (e.g., between 1 and 100).
5. Optionally, add a Custom error message to guide the user.

Example: To ensure a date is not in the future, use the formula =A1<=TODAY().

JavaScript Form Validation

When students build web forms, JavaScript can catch errors before the form is submitted.

Remember: always give clear, friendly feedback so users know exactly what to fix.

Exam Tips & Tricks

• 🔍 Read the question carefully – look for keywords like “validate”, “error”, or “range”.
• 📌 Show step-by-step – list the validation rules you would set up.
• 💡 Use examples – give a concrete example (e.g., email format, date range).
• 📝 Explain why validation matters – mention data integrity and user experience.
• ?? Check your work – double‑check that all rules are logically consistent.