An Electronic Class Record, or ECR, is one of the most useful tools teachers need when recording learner scores, computing grades, checking learner progress, and preparing class records.
For SY 2026–2027, many teachers are preparing for the Three-Term School Calendar and the revised classroom assessment and grading system. Because of this, EduFilesPH is sharing a free Three-Term Electronic Class Record designed to help teachers organize scores and grade records in a cleaner and more convenient Excel file.
This ECR is intended to help teachers save time in recording Written/Oral Works, Product/Performance Tasks, Summative Tests, Term Examination, Initial Grades, Transmuted Grades, descriptors, and other grade-related information.
The workbook is protected to prevent accidental changes to formulas, computation areas, and important sheet structures. Teachers can encode data in the editable sections, while protected areas help preserve the accuracy and structure of the file.
If you notice any error, inconsistency, formula issue, or mismatch while using the file, please message or contact EduFilesPH so we can review the concern and update the template when needed. Your feedback helps us improve the ECR and make it more useful for teachers.
Resource Information
Resource Type: Electronic Class Record
File Format: Microsoft Excel file
School Year: SY 2026–2027
Calendar Structure: Three-Term School Calendar
Main Use: Recording learner scores, computing grades, and preparing class records
Recommended Users: Teachers, subject teachers, class advisers, and school personnel handling grades
Automation Type: Formula-based Excel template
Formula Protection: Protected with password to prevent accidental formula changes
About This Three-Term Electronic Class Record
The Free Three-Term Electronic Class Record for SY 2026–2027 is designed to help teachers manage class records in a more organized way. Instead of preparing separate manual computations, teachers can use this Excel-based template to encode learner scores and generate grade-related outputs inside one structured workbook.
Depending on the version or subject file, the ECR may include sheets for learner information, score entry, assessment components, term grades, transmuted grades, descriptors, summaries, and printable records.
This template is helpful for teachers who want a more convenient way to manage grading records while still keeping the file simple enough for regular Excel users.
Why This ECR May Be Useful for Teachers
A well-prepared Electronic Class Record can help reduce repetitive work during grading periods. It can also make score encoding, grade checking, and record preparation more organized.
This ECR may help teachers:
- encode learner names and class information;
- record scores by assessment component;
- organize grades across Term 1, Term 2, and Term 3;
- compute grades using built-in formulas;
- reduce repetitive manual computations;
- view Initial Grades and Transmuted Grades;
- include descriptors for easier grade interpretation;
- prepare cleaner grade records;
- save time during grade submission periods;
- reduce accidental editing through protected formula areas; and
- keep class records in one structured workbook.
Key Features of the ECR
This Three-Term Electronic Class Record includes teacher-friendly features that may support easier grade recording.
Possible features may include:
- Three-Term grade recording structure;
- subject-based assessment component setup;
- editable learner list;
- editable school, grade level, section, subject, and teacher information;
- score entry areas for assessment results;
- automated grade computation;
- Initial Grade and Transmuted Grade support;
- descriptor-based grade interpretation;
- protected formula and computation areas;
- cleaner Excel layout;
- printable class record sections;
- subject-specific versions; and
- user-friendly format for teachers.
Protected Workbook Notice
The workbook is protected to prevent accidental damage to formulas, linked cells, computation sheets, and important formatting.
Teachers should encode only in the editable input areas. Formula cells, hidden computation areas, protected sheets, and important structures should not be modified or unlocked.
If you find any error, inconsistency, formula issue, or mismatch, please contact EduFilesPH instead of trying to edit the protected formulas. This allows us to review the concern properly and release an updated version if needed.
Basis of the ECR
This ECR was developed with reference to the Policy Briefer on the Revised Guidelines on Classroom Assessment, Grading System, and Awards and Recognition for the K to 12 Basic Education Program.
The Policy Briefer explains that assessment is part of teaching and learning. It also discusses formative assessment, summative assessment, assessment components, component weights, grade transmutation, descriptors, intervention, and grade validation.
Types of Summative Assessment
The ECR is designed around the major summative assessment components used for grade computation.
| Type of Summative Assessment | Description | Number Per Term |
|---|---|---|
| Written / Oral Works (WWs) | Written or spoken response tasks such as essays, journals, written reports, structured presentations, and similar outputs | Minimum of 3 and maximum of 5 |
| Product / Performance Tasks (PTs) | Tasks that measure how learners apply what they learned, such as projects, portfolios, investigations, and similar outputs | Minimum of 2 and maximum of 3 |
| Summative Tests and Term Examination (STs & TE) | Assessments given at key points of the term, including summative tests and the term examination | STs are administered twice per term, plus the Term Examination |
Weight Distribution by Learning Area
Teachers should choose the correct ECR file or subject setup based on the learning area or subject group.
| Learning Area / Subject Group | WWs | PTs | STs–TE |
|---|---|---|---|
| Araling Panlipunan, English, Filipino, Mathematics, Science, GMRC / Values Education | 20% | 50% | 30% |
| EPP / TLE and MAPEH | 20% | 60% | 20% |
| SHS Core Subjects and Other SHS Academic Electives | 20% | 50% | 30% |
| SHS Field Exposure, Arts Apprenticeship, Creative Production and Innovation | 15% | 70% | 15% |
| SHS Arts, Sports, Health and Wellness Electives | 20% | 60% | 20% |
| SHS Research Electives and Design and Innovation | 40% | 60% | — |
| SHS TechPro Electives | 15% | 65% | 20% |
| SHS Work Immersion | 20% | 80% | — |
Adjusted Transmutation Table for SY 2026–2027
For SY 2026–2027, the adjusted transmutation table is used to convert Initial Grades into Transmuted Grades.
| Initial Grade | Transmuted Grade | Initial Grade | Transmuted Grade |
|---|---|---|---|
| 99.50 – 100.00 | 100 | 77.00 – 77.99 | 79 |
| 97.50 – 99.49 | 99 | 76.00 – 76.99 | 78 |
| 96.00 – 97.49 | 98 | 75.00 – 75.99 | 77 |
| 95.00 – 95.99 | 97 | 73.00 – 74.99 | 76 |
| 94.00 – 94.99 | 96 | 70.00 – 72.99 | 75 |
| 93.00 – 93.99 | 95 | 68.00 – 69.99 | 74 |
| 92.00 – 92.99 | 94 | 66.00 – 67.99 | 73 |
| 91.00 – 91.99 | 93 | 64.00 – 65.99 | 72 |
| 90.00 – 90.99 | 92 | 62.00 – 63.99 | 71 |
| 89.00 – 89.99 | 91 | 60.00 – 61.99 | 70 |
| 88.00 – 88.99 | 90 | 58.00 – 59.99 | 69 |
| 87.00 – 87.99 | 89 | 56.00 – 57.99 | 68 |
| 86.00 – 86.99 | 88 | 54.00 – 55.99 | 67 |
| 85.00 – 85.99 | 87 | 52.00 – 53.99 | 66 |
| 84.00 – 84.99 | 86 | 50.00 – 51.99 | 65 |
| 83.00 – 83.99 | 85 | 48.00 – 49.99 | 64 |
| 82.00 – 82.99 | 84 | 46.00 – 47.99 | 63 |
| 81.00 – 81.99 | 83 | 43.00 – 45.99 | 62 |
| 80.00 – 80.99 | 82 | 40.00 – 42.99 | 61 |
| 79.00 – 79.99 | 81 | 25.00 – 39.99 | 60 |
| 78.00 – 78.99 | 80 | 0.00 – 24.00 | 60, default minimum |
Grade Descriptors and Instructional Response
The ECR may also include descriptor-based grade interpretation to help teachers understand learner performance more clearly.
| Numerical Grade | Descriptor | General Description | Instructional Response |
|---|---|---|---|
| 90–100 | Advancing / Namumukod-tangi | Consistently demonstrates skills and understanding that meet or exceed standards with independence and excellence | Provide enrichment opportunities and encourage leadership or peer mentoring |
| 80–89 | Benchmarking / Napamamalas | Demonstrates expected grade-level skills and understanding competently and independently | Encourage deeper application, transfer of learning, and increased independence |
| 75–79 | Connecting / Natutungo | Shows developing competence toward standards but requires minimal guidance | Provide guided practice to strengthen consistency and mastery |
| 65–74 | Developing / Napauunlad | Demonstrates emerging skills but requires additional support and practice | Provide targeted remediation and scaffolded instruction |
| 0–64 | Emerging / Nasisimula | Does not yet demonstrate foundational skills and understanding and requires intensive support | Implement structured and sustained intervention programs |
How to Use This ECR Template
- Download the Excel file from the download section.
- Open the file using Microsoft Excel.
- Read the instructions or reminders inside the workbook.
- Save a backup copy before encoding learner data.
- Choose the correct ECR file for your grade level or subject.
- Encode the school name, teacher name, grade level, section, subject, and other class details.
- Enter learner names carefully.
- Encode scores only in the editable input areas.
- Do not attempt to unlock, unprotect, delete, or modify protected formula areas.
- Check the generated grades, descriptors, and summaries.
- Contact EduFilesPH if you notice any error, inconsistency, or formula issue.
- Save your working file using a clear file name for easy tracking.
Important Excel Reminders
Before using the file, it is best to prepare a clean working copy. This helps protect your records and prevents accidental loss of data.
Here are some helpful reminders:
- Keep one blank copy of the file as your original backup.
- Duplicate the file before entering learner data.
- Use Microsoft Excel for best compatibility.
- Encode only in the editable input areas.
- Formula cells and important computation sections are protected.
- Do not attempt to unprotect or modify protected sheets.
- Do not delete hidden rows, hidden columns, or computation sheets.
- If something does not look right, contact EduFilesPH for checking.
- Watch for updated versions in case improvements are released.
Teacher Tip
Use this ECR as a tool to make grade recording easier and more organized. Before using it for actual class records, try encoding sample data first so you can understand how the sheets work.
Once you are familiar with the file, create a separate working copy for your class. This helps you avoid mixing test data with actual learner records.
Preview of the File
Below is a preview of the Three-Term Electronic Class Record template. The actual file may contain additional sheets, formulas, tables, descriptors, or printable sections depending on the version provided.
Policy Briefer Reference
You may also view the Policy Briefer used as one of the references for the development of this ECR.
Optional Advanced ECR Version
👉 Want a more advanced and fully automated version of this E-Class Record?
🚀 We also offer an Advanced Electronic Class Record (ECR) with additional features designed to make grading faster, more accurate, and more insightful:
📌 Learner’s Individual Record (LIR) – for student/parent viewing
📊 Test Result Analysis (TRA) – MPS, Mean, Median, and SD
📈 Grade Classification – Level of Progress and Achievement
📅 Mini-SF2 – Student’s Attendance Monitoring
Kindly message us and let us know the subject you want so we can provide the details.
Available for:
✔ Key Stage 2: Grades 4–6 (All subjects)
✔ Key Stage 3: Grades 7–10 (All subjects)
✔ Key Stage 4: Core, Other Acad Electives, TechPro, Etc.
📢 Note: ECRs for KS1 (Grades 1–3) and SHS will be available soon. Stay updated through our Facebook Page.
📲 Tap or scan the QR code to message us now.
Important Reminder
This Three-Term Electronic Class Record is shared to help teachers save time in preparing grading records. Please review the file, encode only in the editable areas, and check the generated outputs before using them for school records.
The formula cells and important computation areas are protected with a password to prevent accidental changes. If you notice any error, inconsistency, formula issue, or mismatch, please message or contact EduFilesPH so we can review the concern and release an updated version when needed.
Please do not repost, resell, or claim this file as your own. You may share the official EduFilesPH post link instead so other teachers can access the original source.
Frequently Asked Questions
Is this Electronic Class Record free?
Yes. This post provides a free Three-Term Electronic Class Record template for teachers.
Is this ECR editable?
The input areas are editable. Teachers may encode learner names, class details, scores, and other allowed information in the editable sections.
Can I edit the formulas?
No. The formula cells and important computation areas are protected with a password to prevent accidental changes and preserve the structure of the template. If you find any error, inconsistency, or formula issue, please contact EduFilesPH so we can review and update the file if needed.
Why is the workbook protected?
The workbook is protected to prevent accidental changes to formulas, computation areas, hidden sheets, and important structures. This helps keep the file stable while teachers encode data in the allowed input areas.
Can I use this for SY 2026–2027?
Yes. This ECR is prepared for SY 2026–2027 and follows a three-term structure.
Does this ECR compute grades automatically?
Yes. The file includes built-in formulas for grade computation, depending on the version or subject file provided.
Can I use this in Google Sheets?
Microsoft Excel is recommended. Some formulas, formatting, protection settings, or workbook features may not work the same way in Google Sheets.
What should I do before encoding actual learner data?
Save a backup copy first. Then test the file using sample learner names and scores to understand how the workbook works.
What should I do if I find an error or inconsistency?
Please message or contact EduFilesPH. Include the subject file, grade level, screenshot if possible, and a short explanation of the issue so we can check it properly.
Is this the official DepEd E-Class Record?
No. This is not the official DepEd-issued E-Class Record. It is a supplementary teacher resource created by EduFilesPH for easier grade recording and computation.
Is this ready for official submission?
This file is a template and support tool. Teachers should still follow their school’s official instructions for grade submission, validation, and reporting.
Can I share this file with other teachers?
You may share the official EduFilesPH post link. Please do not repost, resell, or claim the file as your own.
Download the Free Three-Term Electronic Class Record
You may download the free Three-Term Electronic Class Record for SY 2026–2027 using the button below. Please make sure to review the file, encode only in the editable areas, and contact EduFilesPH if you notice any issue.
Disclaimer
EduFilesPH shares educational templates and resources to help teachers and school personnel. The files are provided as supplementary tools and should be used with proper checking and school guidance.
This Electronic Class Record is not the official DepEd-issued E-Class Record. It is a modified and enhanced version created for teacher convenience, based on available references and designed to support easier grade recording.
The workbook contains protected formula and computation areas to help prevent accidental changes. If users notice any error, inconsistency, formula issue, or mismatch, they are encouraged to contact EduFilesPH so the concern can be reviewed and addressed in future updates.
EduFilesPH is not officially affiliated with the Department of Education unless clearly stated. Always refer to official DepEd issuances, school instructions, grading policies, and division or regional guidelines when preparing official class records and grade-related documents.