DepEd Official Automated MLESF Summary Matrix Consolidator for Elementary, JHS, SHS, and Large Schools

The Department of Education (DepEd) Planning Service releases the Official Automated MLESF Summary Matrix Consolidator (Excel File) for the School Year 2021-2022.

The Automated MLESF Summary Matrix Consolidator was conceptualized and developed by Sir Wedzmer Briz Munjilul. He is also the Head Teacher I of Sta. Ana Central Elementary School, Schools Division of Davao City.

For more info on the MLESF, please read the DepEd Official Automated MLESF Summary Matrix Consolidator for the School Year 2021-2022

Download the Official Automated MLESF Summary Matrix Consolidator for Elementary, JHS, SHS, and Large Schools Version 3.1 (Excel Files)

Automated MLESF Summary Matrix Consolidator for Large Schools

Automated MLESF Summary Matrix Consolidator for Junior High School (JHS)

Automated MLESF Summary Matrix Consolidator for Senior High School (SHS)

Automated MLESF Summary Matrix Consolidator for Elementary

Automated MLESF Summary Matrix Consolidator Instructions

1. Only 1 answer is required, just select one (1) applicable combination if more than 1 condition is appropriate.
2. The total column must be equal with the number of respondents per grade level (validation apply).
3. Total column per grade level must not exceed to 5000.

*For Prospective Adviser

1. Review all MLESF for Accuracy/completeness
2. For question with posisble multiple answers, select applicable combination as listed/grouped in this form
3. Submit to Grade Level Enrollment Chair (GLEC) if any or to School Enrollment Focal Person (SEFP).

For Grade Level Enrollment Chair (if any)

1. Review all Summary Matrix submitted by advisers, check for accuracy/completeness
2. Prepare a Summary Matrix with totality for all items/questions of all sections
3. Submit the Accomplished Summary Matrix (Grade level) to School Enrollment Focal Person (SEFP)

For School Enrollment Focal Person (SEFP)

1. Review all Grade Level Summary Matrix submitted by GLEC, check for accuracy/completeness
2. Prepare a Summary Matrix with totality for all items/questions of all Grade Levels
3. Submit the Accomplished Summary Matrix (School level) to School Head for review and approval and then to LIS System Administrator

For LIS System Administrator

1. Review the School Level Summary Matrix validate the correctness of enrollment count vis-à-vis the number of respondents
2. Login to LIS and click the QC Folder available in the Dashboard
3. Input total count for each table as appeared in the Summary Matrix. May use the assigned code as appopriate for easy reference.

For LARGE SCHOOLS with MORE THAN 4 SECTIONS per grade level

1. Before using the Automated MLESF Summary Consolidator for Large School Excel File, the Grade Level Enrollment Chair will use the automated MLESF Summary Consolidator for Small School. The Grade Level Enrollment Chair will just rename the following tabsheets into the names of each section where the prospective adviser will encode his/her consolidated data.
2. The accomplished Summary Matrix MLESF tabsheet will be ready for forwarding to School Enrollment Focal person for encoding in the Automated MLESF Summary Consolidator for Large School File