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

The Automated MLESF Summary Matrix Consolidator is a set of Excel files for School Year 2021-2022 that helps schools total the answers from the Modified Learner Enrollment and Survey Form (MLESF). The article credits the DepEd Planning Service with the release. There are separate files for Elementary, Junior High School (JHS), Senior High School (SHS), and Large Schools. This page lists the Version 3.1 files and explains, role by role, how advisers, enrollment chairs, focal persons, and LIS administrators use them.

The consolidator was conceptualized and developed by Wedzmer Briz Munjilul, Head Teacher I of Sta. Ana Central Elementary School, Schools Division of Davao City. To learn about the form itself, see the Automated Modified Learner Enrollment and Survey Form (MLESF) for SY 2021-2022.

On this page 5 sections

Download the consolidator files (Version 3.1)

Choose the file that matches your school or level:

• Elementary: Download the Elementary consolidator
• Junior High School (JHS): Download the JHS consolidator
• Senior High School (SHS): Download the SHS consolidator
• Large Schools: Download the Large Schools consolidator

You can preview the spreadsheets below before downloading.

General rules for filling out the summary matrix

1. Give only one answer. If more than one condition applies, select the one applicable combination.
2. The total column must equal the number of respondents per grade level. The file validates this.
3. The total column per grade level must not exceed 5,000.

How the consolidation works, step by step

The data moves upward in this order: prospective adviser, then Grade Level Enrollment Chair (GLEC, if the school has one), then School Enrollment Focal Person (SEFP), then School Head, then LIS System Administrator.

Prospective adviser

1. Review all MLESF from your learners for accuracy and completeness.
2. For questions that may have more than one answer, select the applicable combination as listed or grouped in the form.
3. Submit to the Grade Level Enrollment Chair, if any, or to the School Enrollment Focal Person.

Grade Level Enrollment Chair (if any)

1. Review all summary matrices submitted by advisers for accuracy and completeness.
2. Prepare a summary matrix with totals for all items and questions across all sections.
3. Submit the accomplished grade-level summary matrix to the School Enrollment Focal Person.

School Enrollment Focal Person

1. Review all grade-level summary matrices submitted by the GLECs for accuracy and completeness.
2. Prepare a summary matrix with totals for all items and questions across all grade levels.
3. Submit the accomplished school-level summary matrix to the School Head for review and approval, then to the LIS System Administrator.

LIS System Administrator

1. Review the school-level summary matrix and check that the enrollment count matches the number of respondents.
2. Log in to the LIS and click the QC Folder on the dashboard.
3. Enter the total count for each table as it appears in the summary matrix. You may use the assigned codes for easy reference.

Large schools with more than four sections per grade level

1. Before using the Large Schools file, the Grade Level Enrollment Chair first uses the automated MLESF summary consolidator for small schools. The GLEC renames its tab sheets to the names of each section, and each prospective adviser encodes his or her consolidated data in the tab for that section.
2. The accomplished Summary Matrix MLESF tab sheet is then forwarded to the School Enrollment Focal Person, who encodes it in the Large Schools consolidator file.

Frequently asked questions