How to Compute GWA Scholastic Rating (Excel Template)

One of the requirements in applying as a DepEd teacher is the General Weighted Average (GWA) indicated in the Official Transcript of Records. Unfortunately, not all universities and colleges include it in the TOR. Hence, additional computation would be necessary.

Deped Teacher Ranking Process

Some DepEd District Offices compute the GWA themselves, while others ask teacher-applicants to return to their respective colleges and have the GWA computed by the school registrar.

To save some time, one can compute the GWA using this formula:

1. Multiply the subject grade by the corresponding credit units.
2. Add the total number of ratings in step 1.
3. Divide the sum of all the ratings to the total number of units earned.

Note: In some Transcript of Records, units enclosed in parentheses are not included in the computation of the GWA. (e.g. Music, PE, NSTP or CAT)

Below is a downloadable Excel template for the computation of GWA.

GWA Excel Template