Phase 2 Roadmap

Phase 2 Roadmap

Planned dashboard modules — each pending stakeholder sign-off on the monthly XLS format before build

These five modules are scoped for Phase 2. Once a stakeholder confirms the fields and XLS column order for a module, I will build its upload flow and dashboard tab. Use this page as the format guide to review and edit in the August CIP meetings.

Capacity Building
Awaiting unified XLS format
Bashir Ahmed

Proposed monthly XLS columns

Month / YearWork AreaClusterSchoolTraining TitleLeadership TypeTrainees / TrainingAttendance HoursQualitative Notes

Leadership type taxonomy

TeacherVECMSGDECHeadmasterOthers
  • Monthly unified XLS upload of capacity-building sessions by leadership title.
  • Phase 2 sub-item: integrate School Development Plans — core indicators & implementation %.
  • Phase 2 sub-item: load BALTI-LED Annual Survey datasets 2024–2026 for leadership development.

Next: Bashir to confirm the leadership-type taxonomy and XLS column order, then I build the upload + dashboard tab.

Scholarship Tracker
Refine core data fields
Genevieve Walsh
Naila Atiqa
Bashir Ahmed

Proposed monthly XLS columns

UINStudent NameVillageEMIS Home SchoolFunding to DateMatriculationPerformance / Test RateCurrent SchoolStudiesMonth / Year
  • Track scholarship recipients against EMIS home school and current placement.
  • Common monthly XLS format using scholarship-EMIS for upload.

Next: Genevieve, Naila & Bashir to refine which fields we have vs. can track; then I build the tracker + upload.

Operational Finance
Discuss specifics
GM Satpara
Saleem Abbas

Proposed monthly XLS columns

Month / YearRegionExpense CategoryAmountTrend vs. Previous
  • Expenditures by region with monthly expense & trend analysis via XLS.
  • Phase 2 — pending specifics from finance lead.

Next: GM Satpara & Saleem to define expense categories and region breakdown; then I build the finance dashboard.

Special / Pilot Projects
Discuss operability & format
Bashir Ahmed

Proposed monthly XLS columns

Month / YearProgram NameProgram TypeBeneficiariesProgress %Qualitative Notes
  • Single monthly report summarizing pilot programs, specially-abled persons program, and one-time programs.
  • Standalone program dashboard; monthly progress uploaded as XLS.

Next: Bashir to review the format guide; then I build the standalone pilot-project tracker.

Capital Projects
Review format guide · August CIP
Wazir Ghulam Abbas

Proposed monthly XLS columns

ProjectRegion / Cluster / SchoolProgress %Cost / BudgetMilestoneWork ScheduleFlood Impact (Roads / Water Points / School Damage)
  • Project tracker by progress & cost, tailored to engineering needs — Power BI-style visualizations & trends.
  • Integrate / hyperlink flood-impact tracker for infrastructure damage; flood timeline visualization.
  • Filter by region, cluster and school; monthly and annual analysis; ability to set milestones.

Next: Wazir to review the example XLS format; develop a monthly XLS + visual project tracker for August CIP.

Example XLS format (Wazir to review)