• Module 2 Unit 2













    Objective: Enable MoE staff and partners to confidently use digital tools for collecting, managing, and communicating EiE data, even in low-resource settings.

    Unit 2: Microsoft Office Applications for EiE Work

    • Word: Creating formatted forms, meeting notes, and reports
    • Excel: Entering EiE data, creating tables, generating charts
    • Hands-on: Develop a school monitoring checklist in Word & track entries in Excel

◄School Monitoring Checklist and Data Collection InstrumentLicence►

Module Unit Activity

  • Module Unit Activity

    • Task

      Using Excel, calculate key EiE indicators from the dataset provided.

      Dataset Example

      School Enrolled Learners School-Age Population Teachers Qualified Teachers
      A 420 500 12 7
      B 315 410 9 5
      C 510 600 14 10


      Instructions

      Using Excel formulas, calculate:

      • Gross Enrolment Rate (GER)
      • Pupil–Teacher Ratio (PTR)
      • Percent of Qualified Teachers


      Deliverable

      Upload:

      • Completed Excel spreadsheet
      • A short interpretation of what the data shows
◄School Monitoring Checklist and Data Collection InstrumentLicence►