In many countries, academic transcripts typically include two GPA (Grade Point Average) calculations: one per semester and another for the entire study program. In some cases, the GPA is computed only upon program completion. If your transcript lacks a pre-calculated GPA, the admissions office will compute one for you. Please be aware that the RSM Admissions Office will have the final say on whether your GPA is sufficient or not.
- In column A, input your earned grades.
- In column B, enter the credits earned for each course.
- Once you've entered all grades and credits, use the following formulas in the spreadsheet:
In cell B5 =SUM(B1:B4); In column C =SUM(A1*B1), =SUM(A2*B2) etc; In cell C5 =SUM(C1:C4)/B5 This last answer is your GPA.
When a course does not have a grade, but only “pass” or “fail”, this course can not be used in the GPA calculation.