How to Compute Prelim, Midterm, and Final Grades in College Philippines

For students in the Philippines, calculating your GWA is essential for tracking academic performance, planning grades strategically, and qualifying for scholarships. This step-by-step guide will help you compute prelim, midterm, and final grades in college PH using a reliable GWA calculator online. You’ll also learn how to calculate GPA Philippines, convert a 1.75 GWA to a percentage, understand GPA equivalents, and check scholarship eligibility. By the end, you’ll confidently track your grades, maintain a competitive academic standing, and know exactly where your GWA places you for honors or scholarships. Senior High School students can also use the SHS GWA Calculator to monitor their semester performance efficiently.

GWA Calculator Philippines 2025 – How to Compute Your Grades and GPA

Most universities in the Philippines use the GWA and GPA systems to evaluate a student’s academic performance. Whether you’re using an online GWA calculator, a manual calculator, or computing GWA using formulas, it’s important to know the grade weighted average and how GWA is determined.

Compute Prelim, Midterm & Final Grades in the Philippines (1.75 GWA Example)

Requirements:

• Preliminary, Midterm, and Final Grades per subject

• Credit units for each course

Example Table:

Weighted Average Formula:

Most colleges in the Philippines assign weights: Prelim 30%, Midterm 30%, and Final 40%.

$$\text{Final Grade = (Prelim × 0.3) + (Midterm × 0.3) + (Final × 0.4)}$$

Example for Math 101:

$$(88\times 0.3)+(90\times 0.3)+(92\times 0.4)=90.2$$

Repeat for all subjects to calculate each weighted grade.

GWA Calculation Formula:

GWA=∑(Final Grade×Units) ∑Units\text{GWA} = \frac{\sum (\text{Final Grade} \times \text{Units})} {\sum \text{Units}} GWA=∑Units∑(Final Grade×Units)​

Example:

GWA=(90.2×3)+(87.2×3)+(92.8×4)+(84.2×2) 12≈89.3GWA = \frac{(90.2 \times 3) + (87.2 \times 3) + (92.8 \times 4) + (84.2 \times 2)}{12} \approx 89.3GWA=12(90.2×3)+(87.2×3)+(92.8×4)+(84.2×2)​≈89.3

This overall GWA accurately represents your academic performance.

GWA to GPA (Philippines → US):

“Once you have computed your GWA, you can calculate GPA in the Philippines to understand your academic performance on a 4.0 scale.”

Types of GWA

• Semester GWA – for a single semester

• Cumulative GWA—across multiple semesters

• Subject-level GWA – per course

Always multiply each grade by its credit units and divide by the total units to ensure accurate GWA computation.

Special Cases in GWA Computation – INC, Dropped, and Transferred Subjects

Understanding special cases ensures your GWA calculation is accurate and reflects your true academic performance. Here’s how to handle them:

1. INC (Incomplete) Grades

Incomplete grades are not counted in your GWA until they are completed. Once you finish the course, the new grade replaces the INC in your computation.

• Example:
  Math 101 was INC. Later, you received a grade of 90.
   Action: Include 90 × units in your GWA formula.

2. Dropped Subjects

Dropped subjects are generally excluded from your GWA. However, always confirm with your registrar, as some schools may have specific rules.

• Example:
  History 101 was dropped.
  Do not include its units in the total ∑Units when computing GWA.

3. Transferred Subjects

Grades from other universities can be included, but they are usually converted to your school’s specific grading scale before counting.

Example:
Science at another university scored 88%.
Convert it to your school’s scale and include its units in your GWA.

Grade Planning Tips to Reach 1.75 GWA and CHED Scholarships

Achieving a 1.75 GWA or better can help you qualify for CHED scholarships and other academic awards.

How to Plan Your Grades

To reach a target GWA (e.g., 1.75), calculate how much each remaining subject affects your average:

• Example: Current GWA is 1.85; to reach 1.75, aim for higher grades in high-unit subjects.

• Focus on high-unit courses for maximum impact.

Philippine GWA to US GPA Conversion for Grad School Applications

Converting Philippine GWA to US GPA

• Many universities abroad use a 4.0 GPA scale.

• Example Table:

• • Example: Juan has a 1.75 GWA → 3.25 GPA for grad school applications in the US

GWA Calculator Tools & Shortcuts – Excel, Google Sheets, and Online Apps

“Using Excel, Google Sheets, or an online GWA calculator, you can easily compute grades in college PH and even calculate GPA Philippines for overseas applications.”

Apps and Calculators

Computing your GWA doesn’t have to be complicated. Several online calculators allow you to input your grades and units, and they automatically calculate your GWA. Some even include an option to convert your GWA to GPA, which is helpful if you’re planning to apply to universities abroad. Search “GWA Calculator Philippines 2025” to find reliable interactive tools.

4. Excel / Google Sheets Template

For students who prefer offline computation or want to track grades over multiple semesters, a ready-to-use Excel or Google Sheets template:

• Enter your subjects, units, and grades.

• The template automatically computes weighted grades and your GWA.

• Optionally, include a GWA-to-GPA conversion table to instantly view your US GPA equivalent.

SUMPRODUCT Formula (Quick Calculation)

If you’re comfortable with formulas, Excel or Google Sheets can calculate your GWA in one line using SUMPRODUCT:

• WeightedGradeRange = column with weighted grades (or final grades if already computed)

• UnitsRange = column with credit units for each subject
  This formula saves time and ensures accuracy, especially for students with many subjects.

Optional Shortcut for GWA → GPA Conversion

Add a lookup table in your sheet:

Use VLOOKUP To convert your calculated GWA to GPA automatically: