Calculate GPA by course

Directions: List each course individually in Column A beginning at Line 3 of the spreadsheet. To the right of each course, place the number of credit hours under the grade earned. Each time you enter the credit hours the summary entries in Line 1 will update.

Cumulative information is calculated on Line 1 in Columns O (hours earned), P (grade points, also called quality points) and Q (grade point average). A grade of 'U' is the same as a grade of 'F' and should be entered in Column N. Grades of P, S, W, WP, WF, NG, NR, I or any grade followed by an asterisk (*) does not impact your GPA, and will not calculate on this spreadsheet.

If your browser isn't displaying the spreadsheet below, you may open a copy by clicking here.

To use this Web page interactively, you must have Microsoft® Internet Explorer 5.01 Service Pack 2 (SP2) or later and the Microsoft Office 2003 Web Components.

See the Microsoft Office Web site for more information.