Advanced Three-Term E-Class Record for Key Stage 1 Grades 1–3
Teachers, here is the Advanced Three-Term E-Class Record for Key Stage 1 Grades 1–3 from EduFilesPH. This paid version was created for teachers who need a more automated and organized Excel-based class record with added tools for learner viewing, test result analysis, grade classification, attendance tracking, and Student View customization.
This Advanced E-Class Record is designed to help teachers save time in encoding scores, summarizing grades, preparing individual learner records, analyzing assessment results, and monitoring learner attendance in one workbook.
About the Advanced E-Class Record
The Advanced Three-Term E-Class Record is an editable Excel file designed for Key Stage 1 teachers. It includes the regular three-term class record sheets, plus advanced tools that make the file more useful for monitoring learner performance, preparing individual learner records, analyzing test results, and tracking attendance.
Basis of This E-Class Record
This Advanced E-Class Record was created based on the available policy briefer on classroom assessment, grading system, and awards and recognition. The file follows the assessment components in the briefer, including Written / Oral Works, Product / Performance Tasks, and Summative Tests and Term Examination.
For Key Stage 1, the file also considers the descriptive grading system for Grades 1 to 3, including the descriptors Advancing, Benchmarking, Connecting, Developing, and Emerging.
Resource Information
| Resource Title | Advanced Three-Term E-Class Record for Key Stage 1 Grades 1–3 |
|---|---|
| File Type | Editable Excel File |
| Grade Level | Grades 1, 2, and 3 |
| Key Stage | Key Stage 1 |
| School Year | SY 2026–2027 |
| Format | Advanced Three-Term E-Class Record |
| Availability | Paid EduFilesPH Resource |
| Created by | EduFilesPH |
What You Can See Inside the File
- GUIDE – instructions on how to use the file.
- INPUT DATA – for school information, class details, teacher information, and learner names.
- TERM1, TERM2, and TERM3 – class record sheets for the three terms.
- SUMMARY OF GRADES – summarizes term grades, final grades, descriptors, and remarks.
- NewStudentView – individual learner viewing sheet with theme selector.
- PrintLIR – printable Learner’s Individual Record.
- TRA – Test Result Analysis sheet.
- AT1, AT2, and AT3 – Mini-SF2 attendance tracker sheets for the three terms.
Input Data Sheet where teachers can encode school information, class details, and learners’ names.
Advanced Features Included
Automated Learner’s Individual Record
The file can automatically pull the record of a selected learner, making it useful for parent or student viewing while helping prevent other learners’ records from being shown.
Theme Selector for Student View
The Student View includes 10 theme color options to make the learner viewing sheet more presentable and customizable.
Automated Test Result Analysis
The TRA sheet helps teachers prepare assessment summaries such as MPS, Mean, Median, Standard Deviation, and other test result data.
Grade Classification Tool
The file includes a classification tool for summarizing learners based on their level of progress and achievement.
Mini-SF2 Attendance Tracker
The workbook includes attendance tracker sheets for Term 1, Term 2, and Term 3 to help monitor daily learner attendance.
Summary of Term Grades
The Summary of Grades sheet automatically gathers learners’ term grades and displays the final grade, descriptor, and remark.
Automated Learner’s Individual Record with 10 Theme Colors
One of the main features of the advanced version is the Automated Learner’s Individual Record. Teachers can select a learner and view the individual record in a cleaner Student View format.
The Student View includes 10 theme color options: Classic Blue, Forest Green, Royal Purple, Teal Breeze, Sunset Orange, Monochrome Gray, Rose Blush, Maroon Red, Golden Mustard, and Midnight Navy.
Automated Learner’s Individual Record with 10 theme color options for Student View.
Main Class Record Features
- Editable Excel format
- Designed for Key Stage 1 or Grades 1–3
- Three-term grading setup
- Separate sheets for Term 1, Term 2, and Term 3
- Automatic pulling of learner names from the input sheet
- Automatic computation of scores and weighted scores
- Automatic generation of term grades
- Letter grade and descriptor assignment
- Summary of grades across the three terms
- Printable Learner’s Individual Record
- Test Result Analysis tool
- Mini-SF2 attendance tracker
- Theme selector for Student View
Three-Term Class Record sheet with automatic computation of scores and grades.
Automated Test Result Analysis
The Test Result Analysis sheet is designed to help teachers organize assessment results. It includes areas for learner scores, percentage scores, number of examinees, highest possible score, Mean Percentage Score, Mean, Median, and Standard Deviation.
Test Result Analysis sheet for generating useful assessment data such as MPS, Mean, Median, and SD.
Mini-SF2 Attendance Tracker
The advanced workbook includes attendance tracker sheets for the three terms. Teachers may mark absences and allow the sheet to summarize present and absent days for each learner.
Mini-SF2 Attendance Tracker for monitoring daily learner attendance.
Level of Progress and Achievement
The file uses the following descriptors for learner progress:
- A – Advancing
- B – Benchmarking
- C – Connecting
- D – Developing
- E – Emerging
The Grade Classification Tool helps summarize the number of learners according to their level of progress and achievement.
Grade Classification Tool showing learners’ level of progress and achievement.
Summary of Term Grades
The Summary of Term Grades sheet collects the term grades from Term 1, Term 2, and Term 3. It also displays the final grade, descriptor, and remark of each learner in one organized sheet.
Summary of Term Grades with final grade, descriptor, and remarks.
How to Get the Advanced E-Class Record
👉 Interested in this Advanced Three-Term E-Class Record?
🎨 Theme Selector – 10 color themes for Student View
📊 Test Result Analysis (TRA) – MPS, Mean, Median, and SD
📈 Grade Classification – Level of Progress and Achievement
📅 Mini-SF2 – learner attendance monitoring
Who Can Use This File?
- Grade 1 teachers
- Grade 2 teachers
- Grade 3 teachers
- Key Stage 1 advisers
- Subject teachers handling primary grade subjects
- Teachers who need learner-level viewing records
- Teachers who prepare test result analysis reports
- Teachers who want a Mini-SF2 attendance tracker inside the same workbook
Teacher Tip
Frequently Asked Questions
Is this the official DepEd E-Class Record?
No. This is not the official DepEd E-Class Record. This is an independently created EduFilesPH template designed to help teachers organize grades and related records under the three-term setup.
Is this Advanced E-Class Record free?
No. This advanced version is a paid EduFilesPH resource because it includes additional automated tools such as Learner’s Individual Record, Test Result Analysis, Grade Classification Tool, Mini-SF2, and Theme Selector.
How can I get the Advanced E-Class Record?
You may message EduFilesPH through Messenger using the link or QR code provided in this post. Kindly indicate the grade level and subject you need.
What makes this different from the free version?
The advanced version includes additional tools such as Learner’s Individual Record, Student View, Test Result Analysis, Grade Classification Tool, Mini-SF2 attendance tracker, and theme selector.
Can this be used for Grades 1–3?
Yes. This file is designed for Key Stage 1 or Grades 1–3.
Does the file automatically compute grades?
Yes. The file contains formulas that help compute scores, weighted scores, term grades, descriptors, final grades, and remarks.
Can I print individual learner records?
Yes. The workbook includes a printable Learner’s Individual Record sheet that can be used for learner or parent viewing.
Does it include attendance tracking?
Yes. The file includes Mini-SF2 attendance tracker sheets for Term 1, Term 2, and Term 3.
Terms of Use
This Advanced Three-Term E-Class Record for Key Stage 1 Grades 1–3 is a paid EduFilesPH teacher resource.
- You may download, use, and modify this file for your own class and school use after purchase or authorized access.
- You may not re-upload or redistribute this file to other websites, Google Drive links, Facebook groups, or other platforms.
- You may not resell this file or include it in another paid bundle without permission.
- You may not remove or alter the EduFilesPH credits inside the file.
If you would like to recommend this resource to other teachers, please share the official blog post link instead.
Final Notes
This Advanced Three-Term E-Class Record for Key Stage 1 Grades 1–3 was created to help teachers save time and manage class records more efficiently. With its added automation tools, teachers can record scores, summarize grades, generate individual learner records, analyze assessment results, and monitor attendance in one workbook.
Looking for a simpler version? You may also check the free basic version of our Three-Term E-Class Record for Key Stage 1.