DepEd’s Three-Component Grading Formula — Automated
Filipino teachers compute 1,280+ transmuted grades per subject per year. OpenEduCat automates WW/PT/QA weighting and transmutation so teachers spend zero time on the formula.
The Spreadsheet Formula Problem
Teachers maintain 3 separate class records per subject per quarter (WW, PT, QA) — most in Excel spreadsheets that are error-prone and impossible to audit
The transmutation formula (Initial Grade → Transmuted Grade) must be applied manually 160 times per subject per school year (40 students × 4 quarters)
A single formula error in one cell cascades to wrong quarterly grades, wrong SF9 entries, and parent disputes that take hours to resolve
DepEd Order No. 8, s. 2015 specifies decimal precision rules during intermediate calculations that most spreadsheet users unknowingly violate
SHS tracks have different component weight rules (Work Immersion = 100% PT) — a single spreadsheet cannot safely handle both JHS and SHS simultaneously
How Component Scoring Works in OpenEduCat
Configure Component Weights per Curriculum Level
Set WW/PT/QA weights at the curriculum level for each subject type. Core subjects use 25/50/25. Work Immersion and Research/Capstone use 0/100/0. OpenEduCat applies the correct configuration automatically per subject.
Teachers Enter Raw Scores per Component
For each assessment in WW, PT, and QA, teachers record the raw score and the highest possible score. The system computes the component percentage immediately.
System Applies DepEd Weighting Formula
Component percentages are multiplied by their assigned weights (WW×0.25 + PT×0.50 + QA×0.25) to compute the Initial Grade. Intermediate calculations retain 2 decimal places as required by DepEd Order No. 8.
Transmutation Formula Applied Automatically
The Initial Grade is transmuted using DepEd's formula: Transmuted Grade = (Initial Grade × 0.60) + 40. This ensures a 0% raw score maps to 40 (the minimum floor) and 100% maps to 100.
Grade Flows Directly to SF9 and Form 138
The Transmuted Grade for each quarter appears automatically in the SF9 report card and Form 138. No manual transfer, no re-entry, no formula re-application.
Component Weight by Subject Type
DepEd Order No. 8, s. 2015 — configured once, applied automatically
| Subject Type | Written Works | Performance Tasks | Quarterly Assessment |
|---|---|---|---|
| Core Subjects (JHS/SHS) | 25% | 50% | 25% |
| Work Immersion / Research | 0% | 100% | 0% |
| Physical Education (MAPEH sub-areas) | 20% | 60% | 20% |
| Arts / Music / Health (MAPEH) | 20% | 60% | 20% |
Frequently Asked Questions
Ready to Transform Your Institution?
See how OpenEduCat frees up time so every student gets the attention they deserve.
Try it free for 15 days. No credit card required.