You can get a copy of our free GPA calculator template in Google Sheets here.
Select File > Make a copy.
A GPA (Grade Point Average) Calculator in Google Sheets helps calculate a student's GPA using grades and course credit hours. The calculator then uses these inputs to compute the GPA by multiplying each course's grade points by its credit hours, summing these, and dividing by the total credit hours.
Follow the steps below to create a GPA calculator template in Google Sheets.
In the first row of your spreadsheet, type these headings into columns A through E: "Course Name" in A1, "Credit Hours" in B1, "Grade Received" in C1, "Grade Points" in D1, and "Weighted Points" in E1. These headings will organize your data and calculation results.
Start filling in your course details row by row below the headings. Include the name of each course under "Course Name," the number of credit hours for the course under "Credit Hours," and the grade you received in "Grade Received."
In your Google Sheets document, add a new sheet by clicking the "+" at the bottom. On this new sheet, create a table that converts letter grades to grade points (e.g., A=4.0, B=3.0). Label one column as "Grade" and the adjacent column as "Grade Points." Fill in the table with the appropriate values.
Go back to your main "GPA Calculator" sheet. In the "Grade Points" column (D), use the VLOOKUP function to find the numeric grade point for each letter grade based on your conversion table. The formula in D2 would look something like =VLOOKUP(C2, Sheet2!$A$1:$B$5, 2, FALSE), assuming "Sheet2" is where your conversion table is.
Drag the fill handle down to apply this formula to all rows with course data.
In the "Weighted Points" column (E), calculate the weighted points for each course by multiplying the "Credit Hours" by the "Grade Points" for that course. The formula in E2 would be =B2*D2.
Drag this formula down the column to apply it to all your courses.
At the bottom of the "Credit Hours" column (B) and the "Weighted Points" column (E), use the SUM function to total these values. For example, if your courses are listed through row 9, you would place =SUM(B2:B9) in B10 and =SUM(E2:E9) in E10.
Divide the sum of weighted points by the sum of credit hours to find your GPA: =SUM(E2:E9)/SUM(B2:B9.
Place this formula below your totals in the GPA row.
Click on the cell containing your GPA calculation. Go to "Format" > "Number" > "Number" in the menu to set the cell to display numbers with two decimal places.
This makes your GPA easier to read and understand.
We hope that you now have a better understanding of how to create a GPA calculator in Google Sheets and use our GPA calculator Google Sheets template. If you enjoyed this article, you might also like our article on how to set up Google Sheets query coalesce or our article on how to copy and paste a drawing in Google Sheets.
