Detailed · Deep study
1Spelling and grammar checks
Automated spell check and grammar check highlight possible errors and suggest corrections. Make appropriate changes so work contains as few errors as possible. Suggestions do not always give the correct response: names, place names and technical terms may be flagged wrongly; words that are spelt correctly but wrong in context ("their/there") may be missed; the dictionary may be set to a different language (e.g. US English).
2Validation checks
| Check | Characteristics and use |
|---|---|
| range check | data lies between upper and lower limits, e.g. 0–100 |
| character check | only permitted characters, e.g. letters only in a name |
| length check | number of characters is correct, e.g. 11 digits |
| type check | correct data type, e.g. a number |
| format check | follows a pattern, e.g. DD/MM/YYYY |
| presence check | field is not left blank |
Validation is important because it stops unreasonable data being stored, giving more accurate information. It is set up in databases (validation rules and text) and spreadsheets (data validation).
See Topic 7 · The system life cycleValidation routines are also designed in 7.2.3Exam focus
Key words: spell check; grammar check; validation; range; character; length; type; format; presence.
Quick self-check
Answer in your head first, then reveal.
Correctly spelt wrong words/homophones are missed (1); names/technical words not in the dictionary (1); wrong language dictionary (1).
Format check – DD/MM/YYYY / range check – sensible dates (2).
