About Course
Programme purpose
Strengthen school financial controls using Excel for budgets, cashbooks, payment schedules, procurement analysis and Board reporting.
Learning route
- Excel foundations for bursar work
- Budget and vote-book controls
- Capitation and fee reconciliation
- Procurement and payment analysis
- Financial dashboards and Board reports
- Audit-ready documentation
Tutor LMS covers methods; the Analytics Lab verifies working files and professional outputs.
Excel training for School Bursars in Kenya
This DatalytIQs course focuses on practical Excel capability for the work context of school bursars in Kenya. The curriculum provides a structured learning pathway for spreadsheet use and information handling relevant to school administrative and financial-support work.
Who this course is for
- School bursars
- School accounts and finance staff
- Administrative staff working with school records
- Education-sector personnel who use Excel
- School staff strengthening spreadsheet skills
What you will explore
- Explore Workbook design and controls.
- Explore School receipts, payments and ledgers.
- Explore Budgeting and capitation tracking.
- Explore Procurement and asset controls.
- Explore Reporting, audit and management information.
- Explore Professional evidence checkpoint.
Course curriculum
The current Tutor LMS curriculum contains the following learning areas and activities.
Workbook design and controls
- Set up secure, structured workbooks for school finance
- Use tables, naming, protection and document-control conventions
- Quiz: Excel for School Bursars — Theory Check
School receipts, payments and ledgers
- Record transactions using consistent account codes
- Reconcile cashbooks, ledgers and supporting documents
Budgeting and capitation tracking
- Build budget-versus-actual reports and variance analysis
- Track capitation, enrolment assumptions and restricted funds
Procurement and asset controls
- Maintain procurement trackers and commitment registers
- Track assets, stock and supplier documentation
Reporting, audit and management information
- Prepare committee-ready financial summaries and dashboards
- Build audit trails and exception reports
Professional evidence checkpoint
- Submit a protected school-finance workbook, reconciliation and finance-committee report in the Analytics Lab
Learning with DatalytIQs
DatalytIQs Academy connects structured learning with applied analysis, evidence-based thinking and professional practice. Use the course curriculum and learning activities as your primary pathway through this course.
Course Content
Workbook design and controls
-
Set up secure, structured workbooks for school finance
-
Use tables, naming, protection and document-control conventions
-
Excel for School Bursars — Theory Check
School receipts, payments and ledgers
Budgeting and capitation tracking
Procurement and asset controls
Reporting, audit and management information
Professional evidence checkpoint
Student Ratings & Reviews
