Preparing learner report cards can take a lot of time, especially when teachers need to encode learner details, compute grades, check attendance, record observed values, and prepare printable School Form 9 or SF9 pages.
To help teachers reduce manual work, EduFilesPH is sharing a Three-Term Automated SF9 for KS2. This editable Excel template is designed to help teachers organize learner data and generate a cleaner Learner’s Progress Report Card more efficiently.
At the moment, the available version is for KS2. The Three-Term Automated SF9 versions for KS1, KS3, and KS4 will be updated soon.
This template is intended as a teacher support tool. Please review all entries carefully and follow the official school, division, and DepEd instructions for final SF9 preparation and submission.
Resource Information
| Resource Details | Description |
|---|---|
| Resource Title | Three-Term Automated SF9 |
| Available Version | KS2 |
| File Type | Excel Workbook |
| Main Use | Learner’s Progress Report Card preparation |
| School Form | SF9 / Learner’s Progress Report Card |
| Term Format | Three-Term format |
| Editable | Yes |
| Target Users | Class advisers, grade-level teachers, and school personnel preparing report cards |
| Upcoming Versions | KS1, KS3, and KS4 will be updated soon |
What Is SF9?
SF9 stands for School Form 9, also known as the Learner’s Progress Report Card. It is used to report the learner’s progress, grades, attendance, and observed values to parents or guardians.
DepEd Order No. 4, s. 2014 adopted the modified school forms for public elementary and secondary schools and identifies SF9 as the Learner’s Progress Report Card.
Because SF9 contains important learner information, teachers should always make sure that the details, grades, attendance records, and remarks are correct before printing or distributing the report card.
About This Three-Term Automated SF9 Template
This Three-Term Automated SF9 template is an editable Excel file designed to help teachers prepare report cards more efficiently.
The old version of the post describes an automated SF9 system with features such as centralized data management, grade consolidation, learner observed values, attendance monitoring, printable SF9 front and back pages, and dropdown-based learner selection.
For this updated post, the focus is the Three-Term Automated SF9 for KS2. Teachers may use it as a working template for organizing learner information and preparing report card outputs in a three-term setup.
Important Update
Please take note of the current file availability:
| Key Stage | Status |
|---|---|
| KS1 | Will be updated soon |
| KS2 | Available |
| KS3 | Will be updated soon |
| KS4 | Will be updated soon |
This post will be updated once the other key stage versions are ready.
Why This Template Is Useful for Teachers
Teachers often spend many hours preparing report cards, checking formulas, encoding learner details, and verifying grades. An automated SF9 template can help make the process more organized.
This template may help teachers:
- Encode learner information in one place
- Reduce repeated typing of learner details
- Consolidate grades more efficiently
- Prepare printable SF9 front and back pages
- Organize attendance data
- Record learner observed values
- Reduce manual computation errors
- Save time during card-giving preparation
- Keep class records and report card data more consistent
The template does not replace teacher checking and validation. It only helps automate and organize the process.
DepEd and School Forms Context
SF9 is an official school form used to communicate learner progress to parents and guardians. Because it reflects learner performance, teachers should ensure that all information is accurate and consistent with official class records and school instructions.
If the template includes honor detection or academic achievement indicators, teachers should still verify the results carefully and follow the latest instructions from the school or division.
Key Features of the Three-Term Automated SF9
1. Centralized Learner Information
The template is designed so teachers can encode important learner details in one area and use them across the workbook.
This may include:
- Learner name
- LRN
- Sex
- Birthdate
- Grade level
- Section
- Adviser information
- School details
Centralized data entry helps reduce repeated typing and lowers the chance of inconsistent learner information.
2. Grade Consolidation
The template supports grade encoding and consolidation so teachers can organize learner performance more efficiently.
Depending on the workbook setup, teachers may encode grades per term or learning area and allow the summary or SF9 pages to pull the needed information automatically.
This is helpful because manual copying of grades from class records to report cards can lead to errors if not carefully checked.
3. Three-Term Format
This updated SF9 template is designed around a three-term setup. Instead of the usual four-quarter layout described in the older post, this version should be checked and used according to the three-term structure of the uploaded workbook.
Teachers should review the term labels, grade fields, and final rating formulas before printing.
4. Learner’s Observed Values
The old automated SF9 post includes support for Learner’s Observed Values or LOV, which are connected to DepEd core values such as Maka-Diyos, Makatao, Makakalikasan, and Makabansa.
If this KS2 version includes an observed values section, teachers should fill it out based on actual observations and school guidelines.
Use only the rating codes or descriptors required by your school.
5. Attendance Monitoring
An SF9 usually includes attendance information. The automated template may help teachers organize monthly attendance data and reflect totals in the report card.
Before printing, check:
- Number of school days
- Days present
- Days absent
- Monthly attendance entries
- Final attendance totals
Attendance entries should be consistent with your official attendance records.
6. Printable SF9 Front and Back
The template is intended to help teachers prepare printable SF9 outputs. A ready printable layout can save time because teachers do not need to recreate report card formatting from scratch.
Before printing, always check:
- Page size
- Margins
- Learner name
- Grades
- Attendance
- Observed values
- Adviser and school head details
- Signatory lines
Print one test copy first before printing the whole class.
👉 Want a more advanced and fully automated version of this Three-Term Automated SF9?
🚀 We also offer Three-Term Automated SF9 with additional features designed to make grading faster, more accurate, and more insightful:
✔ Summary of Term Grades with Final Grades
✔ Consolidated Grades (Term 1–3)
✔ Daily Attendance Sheets per Term
✔ Summary of Attendance
✔ Learner Preview Card
✔ 10 Theme Colors
Kindly message us and let us know the grade level you want so we can provide the details.
Available for:
✔ Key Stage 2: Grades 4–6
✔ Key Stage 3: Grades 7–10
📢 Note: Three-Term Automated SF9 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.
Suggested Workflow for Teachers
Here is a simple workflow for using the template:
| Step | Action |
|---|---|
| Step 1 | Download and save a backup copy of the original file |
| Step 2 | Open the Excel workbook |
| Step 3 | Encode school and adviser information |
| Step 4 | Encode learner names and LRNs |
| Step 5 | Enter or paste grade data carefully |
| Step 6 | Encode attendance information |
| Step 7 | Fill out learner observed values, if included |
| Step 8 | Review computed results and summaries |
| Step 9 | Select the learner in the SF9 print page, if dropdown selection is available |
| Step 10 | Print or export the final report card after verification |
Always keep a blank original copy so you can start again if formulas or layout are accidentally changed.
What to Check Before Printing SF9
Before printing or exporting report cards, review the following:
| Item to Check | Why It Matters |
|---|---|
| Learner name and LRN | Avoids identity and record errors |
| Grade level and section | Ensures the correct class information appears |
| School year and term labels | Makes the report card consistent with the reporting period |
| Grades per learning area | Prevents incorrect learner performance reporting |
| Final grade or general average | Ensures formulas are working properly |
| Attendance totals | Should match official attendance records |
| Observed values | Should reflect actual observations |
| Remarks | Should be consistent with promotion or retention rules |
| Signatories | Ensures the report card is ready for distribution |
| Page layout | Prevents printing issues |
This checking step is very important because automation can help compute and populate data, but teachers are still responsible for validating the final output.
Common Mistakes to Avoid
| Mistake | Better Practice |
|---|---|
| Editing formula cells without backup | Save an original copy before editing |
| Pasting data over formulas | Paste only in designated input cells |
| Not checking learner names | Verify names against official records |
| Printing without test copy | Print one sample first |
| Forgetting to update school year or term | Review the header before printing |
| Relying fully on automated honor detection | Verify results manually using official guidelines |
| Using outdated data | Update grades, attendance, and observed values before printing |
| Sharing completed files publicly | Protect learner data and confidentiality |
Teacher Tips for Using Automated SF9 Templates
Here are practical tips to make the template easier to use:
- Keep a blank master copy of the file.
- Create one working copy per section.
- Avoid deleting sheets unless you understand the formulas.
- Do not rename sheets if formulas depend on sheet names.
- Use consistent learner order from your official class list.
- Review formulas after pasting large amounts of data.
- Save backups after major encoding steps.
- Export final cards as PDF when possible.
- Check the layout on the actual paper size before printing.
- Protect learner information when storing or sharing files.
These simple practices help prevent formula errors and data loss.
Download the Three-Term Automated SF9
You may download the available Three-Term Automated SF9 file below.
Upcoming files:
- KS1 – will be updated soon
- KS3 – will be updated soon
- KS4 – will be updated soon
Reminder: Please check the formulas, term labels, grade computations, and SF9 layout before using the file for official school purposes.
Frequently Asked Questions
What is the current available version?
The current available file is the Three-Term Automated SF9 for KS2.
Are KS1, KS3, and KS4 versions available?
Not yet. The Three-Term Automated SF9 for KS1, KS3, and KS4 will be updated soon.
Is this template editable?
Yes. The file is an editable Excel workbook. However, users should avoid editing formula cells unless they know how the workbook is structured.
Can this replace official SF9 procedures?
No. This is an automated support template. For official reporting and issuance of report cards, always follow your school, division, and DepEd instructions.
Does this template automatically compute grades?
The template is designed to support automated grade organization and consolidation. Teachers should still verify all formulas and outputs before printing.
Can I use this in Google Sheets?
You may try uploading the file to Google Sheets, but Excel formulas, formatting, dropdowns, and print layout may not work exactly the same. Microsoft Excel is recommended for best results.
Should I enable macros?
Only enable macros if the file requires them and you trust the file source. If the workbook works without macros, it is better to keep macro security settings unchanged.
Can I share the file with other teachers?
You may share the blog post link so other teachers can download the updated version from EduFilesPH. Please do not sell or repost the file as your own.
Related Resources
You may also check these related school forms and automated templates:
- Free Editable Attendance Sheets for SY 2026–2027
- Free Automated Summary of Nutritional Status Report Template
- Free Download Automated SF8 Learner’s Health and Nutrition Report
- Automated Summary of Grades with Ranking and Achievement
- School Forms Cover Page Templates
Important Reminder and Disclaimer
This Three-Term Automated SF9 template is provided as a free editable educational resource for teachers. It is not an official DepEd-issued file unless adopted, required, or approved by your school, district, or division.
Teachers should verify all encoded data, formulas, grades, attendance, observed values, and print layout before using the output for card-giving or official reporting.
Do not post completed SF9 files publicly. SF9 contains learner information and should be handled with confidentiality. Always follow your school’s data privacy, record management, and reporting procedures.
Final Notes
The Three-Term Automated SF9 for KS2 can help teachers save time and organize learner report card data more efficiently. It gives teachers a working Excel template for learner information, grades, attendance, observed values, and printable SF9 preparation.
Use the file carefully, keep backup copies, and check all results before printing. The KS1, KS3, and KS4 versions will be added once updated.