4,200 forms in six days: the speed-versus-accuracy call
The NSQF cell of a government-aided senior secondary school in Hisar must key 4,200 paper registration forms into the state portal's spreadsheet template within six working days before the board deadline. You are one of three data entry operators, but two have been pulled into examination duty, leaving you alone for seven hours a day. In a timed test you typed 32 words per minute at 94 per cent accuracy. At the end of day two you have completed 1,150 records, and the supervisor's random check of 200 forms found 11 errors - transposed day and month in dates of birth, first and last names swapped, and three duplicated roll numbers. The supervisor still wants 700 records a day and has offered no extra staff, but has agreed to any change in method you can justify. Printing paper is rationed and the lab has only one working printer.
1. Is the supervisor's 700-records-per-day target achievable with the current method? Support your answer with arithmetic from the setup and propose a concrete alternative plan.
Read the worked answer
Arithmetic first. 4,200 records over 6 days needs 700 per day. Actual output is 1,150 in 2 days, i.e. 575 per day, a shortfall of 125 records (about 22 per cent). Quality is also below the timed test: 61 errors in 1,150 records is roughly 5.3 per cent, against the 6 per cent implied by 94 per cent accuracy - so the error rate has not improved with practice, it has drifted.
Errors are not free. At roughly 1.5 minutes to locate and correct each one, 61 corrections cost about 90 minutes, nearly a fifth of a working day. Promising 700/day would push error rates higher, because speed and accuracy trade off on free-text keying of dates and names.
Defensible counter-proposal:
- Work in batches of 100 with a 30-minute verification pass at the end of each batch.
- Stop typing dates and roll numbers freehand - use drop-down lists and data validation.
- Report a realistic 600/day in writing, with a daily error log, rather than agreeing silently and missing both targets.
2. Name the three error types seen in the check and describe the specific spreadsheet or keying controls that would have prevented each.
Read the worked answer
1. Transposed day and month in date of birth. Cause: free typing of a date in an unpredictable format. Control: a Date-typed column with data validation restricted to a range (for example 01-01-2005 to 31-12-2010) and a stated entry format; the cell then rejects 25/14/2008 because month 14 does not exist.
2. First and last names swapped. Cause: one free-text name field. Control: split into First Name and Last Name columns in the template, so the operator has a fixed slot for each; a single name field cannot be validated.
3. Duplicated roll numbers. Cause: no uniqueness rule. Control: custom data validation on the roll number column, formula like =COUNTIF($A$2:$A$5000,A2)=1, which blocks a second entry of the same number as it is typed.
Supporting controls: a Verified column (0/1) filled only after the batch check, conditional formatting to highlight blanks and outliers, and keying the roll number twice is unnecessary if the validation rule is in place - validation at entry is cheaper than correction after the fact.
3. The supervisor also wants operators to sit longer to catch up. Explain what you would advise about posture and screen work, and how you would cut paper use without weakening the check.
Read the worked answer
Longer sitting is the wrong lever: beyond about an hour of unbroken keying, error rates and neck-shoulder complaints both rise, and rework costs more than the extra minutes gain. Instead:
- Chair height so feet rest flat and forearms are roughly level with the desk; wrists straight, not bent up at the keyboard.
- Monitor top at or slightly below eye level, about an arm's length away, to reduce neck flexion.
- A 10-minute break from keying each hour, with the 20-20-20 habit (every 20 minutes, look at something 20 feet away for 20 seconds).
- Home-row discipline: correct finger placement keeps speed up without looking down, cutting the head-bobbing that causes neck strain.
Green-IT angle for paper: proofread on screen, use Print Preview, never print the whole register to check one page. Print only the exception list of failed validation and the final signed summary, double-sided. Where a paper copy is unavoidable, reprint a single corrected page rather than the full set.