Blog
Big News for DepEd ICT Coordinators & e-SAT Facilitators: The e-SAT Consolidation Tool is NOW AVAILABLE!
Calling all School ICT Coordinators, e-SAT Focal Persons, and RPMS Implementers!
We are thrilled to announce that the official e-SAT Consolidation Tool for SY 2025-2026 has been released and is now ready for download!
This powerful Excel-based tool automates the aggregation and analysis of your teachers’ Electronic Self-Assessment Tool (e-SAT) responses—saving you hours of manual encoding and ensuring accurate, real-time insights for school-based training planning.
Why You Need This Tool (Immediately):
| ✅ Feature | ✅ Benefit |
|---|---|
| Auto-imports e-SAT PDF data | No more copy-pasting! Just extract and drop. |
| Generates summary dashboards | Visualize strengths & training needs per KRA in seconds. |
| Identifies school-wide priorities | Data-driven LAC sessions & IPPD alignment. |
| Exports clean reports | Ready for School Head, PSDS, and Division submission. |
| 100% DepEd-aligned | Uses official RPMS indicators and weighting system. |
Who Should Download It?
- School ICT Coordinators
- e-SAT Submission Facilitators
- RPMS Coordinators
- School Heads & Master Teachers overseeing consolidation
🔗 DOWNLOAD YOUR COPY NOW:
👉 Click here to download the e-SAT Consolidation Tool v1.0 (Excel) (File size: 298kb | Updated: November 11, 2025)
Quick Start Guide (Few Steps):
INSTRUCTIONS
To consolidate all e-SAT of Beginning Towards Proficient, Proficient, Highly Proficient, and Distinguished Teachers per SCHOOL, do the following:
Step 1: Download the eSAT Consol file.
DO NOT open in Google Drive/Onedrive. This is a macro-enabled file that requires to be opened in Microsoft Excel.
Step 2: Create a folder for your school containing all the e-SAT of teachers.
Note: There should only be ONE consolidation per school.
Move the eSAT Consol in the same location as the created folder (NOT inside the created folder).
Step 3: Open the eSAT Consol.
Enable Macros. Click Enable Editing and Enable Content.
Step 4: Click the button CONSOLIDATE e-SAT.
Step 5: SELECT the folder where the e-SAT files are stored. DO NOT double-click / open the folder.
Click “OK” to start the process of consolidation.
Step 6: Wait for the consolidation to finish. Once the consolidation is done, a prompt will indicate that the files (e-SAT) were successfully consolidated. You may now explore the other sheets to view consolidated report of e-SAT data of teachers.
Step 7: Save and rename your file by adding the name / initials of your school at the end.
Example: eSAT Consol-NEES
Pro Tips:
- Train your e-SAT submitters to name files correctly: LASTNAME_FirstName_eSAT_SY2025-2026.pdf
- Run a test consolidation with 2–3 samples before full rollout.
- Schedule a school LAC session to present the dashboard—teachers love seeing their data in action!
