Upper primary spreadsheet data checks Kenya requires confirmed information about coordination across Grades 4 to 6. This guide gives school teams a method, an illustrative example and a check to complete before issuing an approved timetable.
Planning priorities for Upper primary
Count teacher commitments across all upper primary grades. A balanced class grid can still overload a shared teacher. Compare learning-area totals, room bookings and staff movement together.
Our illustrative arrangement involves twelve classes across three grades and a practical and ICT rooms. Replace those assumptions with actual staff, learner groups and facilities. The example does not prescribe national lesson counts, school hours or staffing ratios. Use requirements approved for your institution.
How to organise spreadsheet data checks
Standardise teacher, group and room labels before arranging lessons. Confirm duplicates describe one resource before merging. Check blanks and spelling variants. Preserve the original source records.
- Collect the current master timetable and the relevant resource records.
- Confirm the information with staff responsible for Upper primary.
- Apply the task-specific checks and record decisions affecting other groups.
- Compare updated class, teacher and room views before distributing copies.
Worked example: Upper primary spreadsheet data checks
Lab 1 and Laboratory One describe the same room but appear as separate resources. For Upper primary, consider coordination across Grades 4 to 6 alongside this problem. Check the complete school record rather than relying on one class sheet.
Agree one label, update records and review bookings that previously appeared to use different spaces. Record the action, its effective date and the person responsible for checking it. Review adjacent commitments after moving a session. If the action creates a new conflict, return to the resource records and consider another feasible arrangement.
Planning sheet headings
Copy these headings into your own register or spreadsheet. Complete one row per resource or decision. Keep supporting evidence with the approved master. These are suggested working headings; no downloadable spreadsheet is claimed on this page.
| Original label | Approved label | Duplicate decision | Reviewer |
|---|---|---|---|
| Upper primary planning item | Enter confirmed school details | Enter confirmed school details | Enter confirmed school details |
Size the checking workload
Suppose 5 affected groups each need 4 entries checked. This gives 20 group-entry checks. The calculation estimates review work only; it is not a curriculum allocation. Include more groups when a shared teacher or room connects a decision to other classes.
A useful review records both a result and its evidence. A tick without the current grid can hide a later change. Keep checked copies together and repeat the affected checks if an assignment changes after review. Do not leave a previous approval mark on a newly altered arrangement.
Acceptance check
Each real teacher, group and room has one consistent planning identity. Ask a colleague who did not arrange the grid to trace the decision through the records. They should reach the same result without relying on a verbal explanation from its author.
Common questions
Can this example replace official requirements?
No. Use the school-approved allocation and current applicable guidance. The example explains a checking method. Confirmed requirements determine what must be scheduled, including learner support arrangements.
What happens if the check fails?
Record the conflict, list affected groups and assign the decision to the appropriate school officer. Correct the relevant views and repeat the check before distributing a replacement timetable.
Who should receive an approved change?
Notify affected teaching staff and those managing shared rooms or supervision. Give families relevant routine changes through normal school channels. Keep private staffing or learner information out of public copies.
Related Upper primary planning tasks
Return to Upper primary timetable planning resources. Continue with Upper primary planning meeting agenda and Upper primary teacher availability. See Upper primary timetable information for the wider context.
Explore the timetable generator demo and current timetable plans when choosing a practical tool for the school.