ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
UMBC PreMedical and PreDental Advising - Comprehensive GPA Calculator (template)
2
Download this Comprehensive GPA Calculator worksheet to track your GPA across multiple institiutions and to calculate separate Science and GPA trends
3
4
To protect the integrity of the formulas in this template, it is set as "read-only" for students. To use the spreadsheet for your own GPA Calculations, please make a copy to your own Google Drive or download the spreadsheet as an Excel file. To do so, click on "File" in the document menu, and then choose EITHER "Make a Copy" or "Download". Requests made to share the document will be declined.Classifying Courses for GPA Calculations
5
DisciplineDo students classify this as "Science"?Other designation?
6
All BIOL, CHEM, PHYSYes
7
All MATH, STAT
Yes for Med; Sometimes for others
8
PSYCSometimes (Neuroscience)Behavioral & Social Science (BESS) for all Non-Neuroscience courses
9
On the "Grade Calculator" tab, enter one class on each row in the LIGHT GOLD columns, along with the grade. The grade value and other calculations for the course will be automatically generated to fill the DARK GRAY columns and the GPA calculations in the DARK GOLD boxes
10
BTECSometimesBTEC Courses with a parallel Science course on Main Campus (e.g., BTEC 303 and BIOL 303, BTEC350 and STAT350, etc.) count as Science, others will be on a case-by-case basis - most likely alternates would be Engineering (ENGI) or Natural & Physcial Sciences (NPSC)
11
12
13
Designate a "year" for each course: HS = Graded college coursework taken before you graduated from High School (e.g., Dual Enrollment); FR = Courses that fall into your first 30 college credits after graduating High School; SO = Courses that fall into your second 30 credits (30-59); JR = Courses that fall in your third 30 credits (60-89 credits); SR = Courses that fall between 90 credits and the completion of your FIRST bachelor's degree; PB = Undergraduate courses taken after completing your first bachelor's degree, including those taken toward a second bachelor's degree; GR = Graduate-level courses.
14
15
16
CMSCNoComputer Science (COMP)
17
PBHLNo
Public Health --> Health Science (HEAL)
18
ENESNoEngineering (ENGI)
19
ENME, ENCHRarely (Thermodynamics)ENGI
20
Indicate the institution where you took the course. For students who have attended colleges or universities other than UMBC, this should help you ensure that all of your courses are included in your GPA calculations, even if that coursework does not appear on your UMBC transcript (including post-bacc and graduate courses taken after graduation)GESSometimes (Ecology)Natural & Physical Science (NPSC) for Physical Geo; BESS for Human Geo
21
22
For career-specific information about what "counts" as Science, see these resources:
ADEA AADSAS Course Subjects (Dental)
23
AMCAS Course Classification Guide (Medical - MD)
24
AACOMAS Course Subjects (Medical - DO)
25
Indicate which courses count toward your Science GPA (Y or N in the appropriate column). Courses that typically count as Science include anything in BIOL, CHEM, MATH, PHYS, or STAT, which is why you'll sometimes see the acronym "BCPM" used to refer to these same courses (standing for Biology, Chemistry, Physics, and Math). See the chart to the right and the links below it for other courses in other disciplines that may be eligible for inclusion.
OptomCAS Course Subjects (Optometry)
26
AACPMAS Course Subjects (Podiatry)
27
VMCAS Course Subjects (Veterinary)
28
29
30
31
If you feel that the content of a course in another discipline included 50% or more Biology, Chemistry, Physics or Math content, you can count it in your Science GPA, but you should be ready to justify your designation if asked by your centralized application serivice (e.g., AMCAS, AADSAS, etc.) or any of your schools.
32
33
34
35
36
UMBC uses a semester-system calendar, and the credits awarded for classes are calculated accordingly. If you took courses at a school that uses a quarter-system calendar, you can convert quarter-system credit hours to semester-system credit hours using the conversion factor of 1 quarter hour = 0.67 semester hours
37
38
39
40
(Example: a four-credit course on the quarter system = 4 x 0.67 = 2.68 semester hours)
41
42
Courses with grades/notations of P, W, AU, S, U, and CR (including credit awarded for qualifying AP, IB and CLEP scores) are not used in GPA calculations for Health Professions programs, but you will be asked to include those courses on your centralized/primary application. The spreadsheet formulas are set up to exclude courses with those grades/notations when calculating your GPA, so if including them in the spreadsheet will help you accurately enter all of your courses, you may include them.
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
Thank you to our friend and former UMBC colleague, Kate Fukawa-Connelly, Director of Health Professions Advising at Princeton University, for the document that served as the jumping-off point for this template!
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100