Copy of gpa-calculator
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
GPA Calculator
2
http://www.vertex42.com/ExcelTemplates/gpa-calculator.html© 2010 Vertex42 LLC
3
4
Instructions:
5
1) Update the GPA Table according to your school's grading scale.
6
2) Enter the Course, Grade, and Credit Hours for each course.
7
3) The Points are calculated based on the GPA Table, so if you insert rows, make sure
8
to copy the formula for the Points.
9
10
Cumulative GPA 3.090
11
Total Credit Hours 17.5
12
GPA Table
13
CourseGradeCreditsPointsGradePoints
14
A+4.3
15
Semester 1A4
16
English 1D0.50.5A-3.7
17
AK StudiesC0.51B+3.3
18
Ancient CivC0.51B3
19
Algebra 1C0.51B-2.67
20
Integrated ScienceC0.51C+2.3
21
PEA0.52C2
22
Math WorkshopA0.52C-1.7
23
Credits:3.5D+1.3
24
Semester GPA:2.429D1
25
Semester 2D-0.7
26
Algebra1 B0.51.5F0
27
ScienceB0.51.5
28
Math WorkshopA0.52
29
Food PrepB0.51.5
30
Lifetime fitnessA0.52
31
0
32
0
33
Credits:2.5
34
Semester GPA:3.400
35
Cumulative GPA:2.833
36
Semester 3
37
English CompA-0.51.85
38
Ancient CivB+0.51.65
39
GeometryB-0.51.335
40
Earth ScienceA-0.51.85
41
Culinary ArtsA0.52
42
Math LabA0.52
43
0
44
Credits:3
45
Semester GPA:3.562
46
Cumulative GPA:3.076
47
Semester 4
48
English Comp-A0.50
49
GeometryB0.51.5
50
Earth ScienceB+0.51.65
51
Culinary ArtsA0.52
52
Bussiness AppC-0.50.85
53
0
54
0
55
{42}Credits:2.5
56
Semester GPA:2.400
57
Cumulative GPA:2.929
58
59
CourseGradeCreditsPoints
60
61
Semester 5
62
Comparitive LitA-0.51.85
63
Ak HistoryB0.51.5
64
Algebra 2C+0.51.15
65
Applied ScienceA-0.51.85
66
PhysicsB+0.51.65
67
ArtA-0.51.85
68
0
69
Credits:3
70
Semester GPA:3.283
71
Cumulative GPA:3.002
72
Semester 6
73
Comparitive LitB0.51.5
74
Ak HistoryA-0.51.85
75
Algebra 2B-0.51.335
76
Applied ScienceA0.52
77
PhysicsA-0.51.85
78
ArtA0.52
79
0
80
Credits:3
81
Semester GPA:3.512
82
Cumulative GPA:3.090
83
Semester 7
84
0
85
0
86
0
87
0
88
0
89
0
90
0
91
Credits:0
92
Semester GPA:
93
Cumulative GPA:3.090
94
95
0
96
0
97
0
98
0
99
0
100
0
Loading...
Main menu