How to Use the TSU GWA Calculator Spreadsheet
A step-by-step guide for tracking grades, calculating each semester, and monitoring cumulative GWA at Tarlac State University.
Keeping track of your grades can become stressful, especially when every subject has a different number of units. You may know your individual grades but still wonder: What is my GWA this semester? Which courses have the biggest effect on it? Am I still within my target grade or possible Latin-honor range?
Many students calculate their GWA manually using a phone calculator, scattered notes, screenshots from student portals, or separate spreadsheets. This makes it easy to forget a subject, use the wrong number of units, include a course that should not be counted, or make a small arithmetic mistake. It also becomes difficult to monitor your progress from freshman year to graduation.
The TSU GWA Calculator places your subjects, units, grades, semester results, and cumulative result in one organized spreadsheet. Instead of repeating the formula every time a grade is released, enter the required information and let the spreadsheet perform the weighted calculations.
Open the TSU GWA Calculator Template
Before you start#
- Open the calculator and select File → Make a copy. Work only on your personal copy so the original template remains unchanged.
- Prepare the official university grade for each completed subject. Enter grade points such as 1.00, 1.25, 1.50, 1.75, and 2.00 - not percentage grades such as 90 or 95.
- Confirm the correct units for every subject. A three-unit course affects your GWA more than a one-unit course.
- Use the Computer Science worksheet if your subjects follow the Bachelor of Science in Computer Science prospectus included with the project. Students from other programs should use the general GWA template.
- Do not delete, move, or overwrite cells that contain formulas. Enter information only in the fields intended for student input.
View the Bachelor of Science in Computer Science program prospectus
Choose the correct worksheet#
The workbook contains four tabs. Choosing the correct one first will make the rest of the process easier.
Computer Science GWA Calculator Template#
Use this tab if you are a Bachelor of Science in Computer Science student whose curriculum matches the prospectus used in the workbook. The subjects, course codes, semester groupings, and units are already listed from freshman to senior year. You mainly need to enter your instructor, if desired, and your official university grades.
GWA Calculator Template#
Use this tab if your program is not preloaded or if you want a blank multi-year calculator. Enter your own program name, subject details, units, and university grades while keeping the existing semester structure and formulas.
Grade Calculator Template#
Use this tab to estimate a subject grade before your final university grade is released. It can track attendance, quizzes, assignments or activities, examinations, and other grading components for both midterms and finals.
Grading System#
Use this tab as a reference. It shows the College of Computer Studies and university grading scales labeled “as of 2019,” including grade points, quality descriptions, letter grades, and the GWA ranges listed for Latin honors. You normally do not need to edit this tab.
How to use the Computer Science GWA Calculator#
Open your calculator copy
Open the Computer Science GWA Calculator Template tab in your copied workbook.
Find the correct term
Find your current year level and semester. Courses are grouped under Freshman, Sophomore, Junior, and Senior.
Verify each course
Check the course acronym, descriptive title, and units against your registration form or official curriculum.
Add the instructor if useful
Type your instructor’s name in the Instructor column if you want a more complete record. This field is optional and does not affect the calculation.
Enter official grade points
Enter the official grade point for each completed subject in the University Grade column. For example, enter 1.50 - not 93 or 93%.
Check the automatic labels
After you enter a grade, the Quality and Letter Grade columns should fill automatically.
Check the weighted value
The Units × GWA column automatically multiplies the subject’s units by the grade point.
Review the semester totals
At the final course row of each semester, check Total Units, Σ (Units × GWA), and Semester GWA.
Review the cumulative summary
After entering all relevant completed grades, review the cumulative summary near the bottom of the worksheet.
What each important column means#
| Column | What it means |
|---|---|
| Units | The academic weight of the course. |
| University Grade | The numerical TSU grade point you enter, such as 1.00, 1.25, 2.00, or 3.00. |
| Quality | A description such as Excellent, Very Good, Good, Satisfactory, Passing, or Failure. |
| Letter Grade | The corresponding letter equivalent shown by the grading reference. |
| Units × GWA | The weighted value of one subject. |
| Semester GWA | The weighted result for that semester. |
| Cumulative or Alumnus GWA | The combined weighted result across the configured curriculum. |
How the spreadsheet calculates your result#
The calculator does not use a simple average because subjects do not always have equal units. It follows this weighted formula:
GWA or GWA = Σ (Course Units × University Grade) ÷ Σ Counted Course Units
Each subject contributes in proportion to its number of units.
For example, a three-unit subject has three times the weight of a one-unit laboratory subject. This is why entering the correct units is just as important as entering the correct grades.
Remember that lower values are better on the TSU grading scale used in the workbook. A result closer to 1.00 is better than a result closer to 3.00.
The current Computer Science worksheet has fixed semester and curriculum unit totals. For the most meaningful cumulative result, enter all grades that belong in the calculation and verify the counted units. If you have only entered one semester, rely on that semester’s GWA rather than treating the bottom cumulative summary as an official current GWA.
The first-year formulas are configured to exclude NSTP from the counted GWA units. Always compare the workbook with the latest official TSU policy and your academic record.
How to use the general GWA Calculator Template#
Open the general template
Make a personal copy of the workbook and open the GWA Calculator Template tab.
Name your program
Replace [Input your Program] with the name of your academic program.
Enter course details
Under the correct year level and semester, enter the course acronym, course name, professor, and units.
Enter the grade point
Enter the official numerical grade point in the University Grade column.
Keep unused rows intact
Leave unused course rows blank. Do not delete or rearrange rows because the semester formulas depend on their current positions.
Read the automatic results
Read the automatic quality, letter grade, weighted value, total units, and Semester GWA.
Validate the cumulative result
Review the cumulative result only after confirming that all subjects and counted units are complete.
How to use the Grade Calculator Template#
This worksheet estimates a grade from your class performance. Because instructors may use different grading systems, check your syllabus before entering any weights.
Identify the subject
Enter the subject name and acronym for each course you want to track.
Record attendance
In the Midterms section, check the attendance box for every week you attended.
Add quiz scores
Enter your quiz scores in the available quiz-number columns, then enter the total possible quiz score.
Add activity scores
Enter your assignment, seatwork, or activity scores and the total possible score.
Add the examination
Enter the examination score and its total possible score.
Use other components only when needed
Use the Others section only if your instructor includes another component, such as a project, recitation, laboratory output, or participation.
Set the weights
Enter the percentage weight for attendance, quizzes, assignments, examinations, and other components. The component weights for the grading period should total 100%.
Repeat for finals
Repeat the same process in the Finals section.
Review the estimate
Review the Final Grade section. It averages the midterm and final results, then shows the university GWA, quality, and letter grade.
How to understand your results#
- Semester GWA tells you how you performed during one semester.
- Cumulative GWA combines the weighted results of multiple semesters or the configured curriculum.
- Quality and Letter Grade help you interpret the numerical grade point.
- The workbook lists 1.00-1.20 for Summa Cum Laude, 1.21-1.45 for Magna Cum Laude, and 1.46-1.75 for Cum Laude.
- Latin-honor ranges in the spreadsheet are only a quick reference. The university may also require residency, minimum grades, conduct, or other qualifications that this calculator does not evaluate.
Common mistakes to avoid#
- Entering a percentage such as 95 in the University Grade column instead of its official grade point.
- Using a simple average and ignoring course units.
- Editing formula cells, lookup tables, course units, or semester totals accidentally.
- Deleting or moving rows in the general template.
- Forgetting to check whether a course should be counted in the official GWA.
- Using assessment weights that do not match the instructor’s syllabus or do not total 100%.
- Treating incomplete, dropped, or not-yet-released subjects as regular numerical grades.
- Assuming the calculator’s result is already the same as the registrar’s official record.
Tips for keeping your grades organized#
- Rename your copied file clearly, such as “Juan Dela Cruz - BSCS GWA Tracker.”
- Update the spreadsheet whenever an official grade is released instead of waiting until the end of the academic year.
- Keep a copy of your registration form or curriculum beside the spreadsheet so you can verify subject units.
- Use separate copies if you want to test possible grades without changing your actual record.
- Do not place sensitive student information in a publicly shared copy.
- Compare the final result with your official portal or registrar-issued grades.
Frequently asked questions#
Frequently asked questions
Can students from other programs use the calculator?
Yes. Use the GWA Calculator Template and enter your own program, subjects, and units. Do not use the preloaded Computer Science tab unless its curriculum matches yours.
Can I enter raw percentages in the GWA worksheet?
No. The University Grade column expects the official numerical grade point. Use the Grade Calculator Template if you need to estimate a grade from raw scores and percentage-based components.
What should I do with an INC or dropped subject?
Do not force it into the numerical grade field. Leave it unresolved in your personal tracker and follow the university’s official rules or registrar guidance for how it should affect your academic record.
Why is my GWA different from a simple average?
The spreadsheet uses a weighted average. Subjects with more units have a larger effect on the result.
Does the calculator guarantee that I qualify for Latin honors?
No. It can show where your numerical GWA falls within the reference ranges, but it cannot evaluate every official eligibility requirement.
Final reminder#
The TSU GWA Calculator is designed to help you understand and monitor your academic progress without repeatedly doing the calculations by hand. Used correctly, it can keep your subjects and grades organized, show which courses have the greatest effect on your GWA, and help you set realistic goals for the next semester.