The Barangay Records Digitization
A barangay secretary is encoding 300 resident records into a spreadsheet. Each record has a surname, first name, birthdate, and address. The encoding rules are: (1) surnames are typed in ALL CAPS; (2) birthdates use the format YYYY-MM-DD; (3) addresses are typed exactly as written on the form, including abbreviations like 'St.' and 'Brgy.'; (4) records are entered in the order of the paper forms, which are already alphabetized by surname. The secretary has finished 180 records. A spot-check finds: record 47 has the surname 'dela Cruz' in lowercase; record 112 has birthdate '03/15/1980'; record 150 has 'Street' spelled out where the form says 'St.'; and record 175 was entered before record 160, though 160 comes first alphabetically.
1. For each of the four flagged records, state which rule was broken and the correct fix.
Read the worked answer
- Record 47 - broke rule (1): surname must be ALL CAPS. Fix: change 'dela Cruz' to 'DELA CRUZ'.
- Record 112 - broke rule (2): birthdate must be YYYY-MM-DD. Fix: change '03/15/1980' to '1980-03-15'.
- Record 150 - broke rule (3): address must match the form exactly. Fix: change 'Street' back to 'St.' as written on the form.
- Record 175 / 160 - broke rule (4): records must follow the alphabetized paper order. Fix: reorder so 160 comes before 175, then renumber if numbers are used.
Each fix is mechanical and does not require judgment beyond matching the stated rule.
2. The secretary wants to fix only the flagged records and stop. Explain why a full re-check of all 180 encoded records is the safer choice, using the evidence in the setup.
Read the worked answer
The four errors were found by a spot-check, not a full audit. Spot-checks catch a sample; they do not prove the rest are clean. The fact that four different rules were each violated at least once suggests the errors are systematic, not isolated - for example, the lowercase surname may reflect a habit applied to every 'dela Cruz'-type name, and the date format may have been wrong for a whole batch.
A full re-check of 180 records is cheap relative to the cost of a wrong birthdate or address in an official record. The correct action is to re-verify all 180 against the four rules, correct every instance, and only then continue with records 181-300 using a checklist to prevent recurrence.
3. The secretary proposes skipping the remaining 120 records and submitting what is done. Evaluate this against the task requirements.
Read the worked answer
The task is to encode 300 records. Submitting 180 leaves 40% of the work undone, and the missing records are the tail of the alphabet - meaning entire surname ranges would be absent from the spreadsheet, producing a systematically incomplete dataset, not a random sample.
This is not a judgment call: the requirement is 300 records, so the work must be completed. The correct response is to finish records 181-300, applying the same four rules, and to run the full re-check from the previous task before submission. Partial submission would misrepresent the record as complete.