Blank FY- 27 EMDP2_GPA_Calculator_v3 (EMDP2) DO NOT OPEN IN GOOGLE SHEETS.xlsx

	A	B	C	D	E	F	G	H	I
1	EMDP2 GPA CALCULATOR
2	DOWNLOAD THIS DOCUMENT TO OPEN AND COMPLETE IN EXCEL ONLY. DO NOT COMPLETE IN GOOGLE SHEETS, it will not work properly in Google Sheets. Please put in all of your coursework information. To be totally accurate enter every grade for all courses even if the class was repeated. If the course is P/F or S/NS, leave the transcript grade and credit hour cells BLANK. Also check the boxes to the right if apply to the coursework listed, do not edit greyed out boxes or Data sections, these will automomatically populate.
3	Freshman Classes (Enter Class Name and Catalog Number)		Transcript Grade	Credit Hours on Transcript	AMCAS Weight Grade Point Conversion	AMCAS Calculated Hours	Quality Points	Check box if Biology, Chemistry, Physics, or Math Class (BCPM)	Check box if class is based on the quarter system
4								x	FALSE
5								FALSE	FALSE
6								FALSE	FALSE
7								FALSE	FALSE
8								FALSE	FALSE
9								FALSE	FALSE
10								FALSE	FALSE
11								FALSE	FALSE
12								FALSE	FALSE
13								FALSE	FALSE
14								FALSE	FALSE
15								FALSE	FALSE
16								FALSE	FALSE
17								FALSE	FALSE
18								FALSE	FALSE
19								FALSE	FALSE
20								FALSE	FALSE
21								FALSE	FALSE
22								FALSE	FALSE
23								FALSE	FALSE
24
25	Freshman Year Data	Total Semester Hours	Total Freshman Quality Points	AMCAS Freshman GPA	Running Overall GPA	BCPM Semester Hours	BCPM Quality Hours	Freshman BCPM GPA	Running BCPM GPA
26				#N/A	#N/A			#DIV/0!	#DIV/0!
27
28		OA Hours	OA Quality Points	Freshman OA GPA	Running OA GPA
29		0		#N/A	#N/A
30
31	Sophomore Classes (Enter Class Name and Catalog Number)		Transcript Grade	Credit Hours on Transcript	AMCAS Weight Grade Point Conversion	AMCAS Calculated Hours	Quality Points	Check box if Biology, Chemistry, Physics, or Math Class (BCPM)	Check box if class is based on the quarter system
32								FALSE	FALSE
33								FALSE	FALSE
34								FALSE	FALSE
35								FALSE	FALSE
36								FALSE	FALSE
37								FALSE	FALSE
38								FALSE	FALSE
39								FALSE	FALSE
40								FALSE	FALSE
41								FALSE	FALSE
42								FALSE	FALSE
43								FALSE	FALSE
44								FALSE	FALSE
45								FALSE	FALSE
46								FALSE	FALSE
47								FALSE	FALSE
48								FALSE	FALSE
49								FALSE	FALSE
50								FALSE	FALSE
51								FALSE	FALSE
52
53	Sophomore Year Data	Total Semester Hours	Total Sophomore Quality Points	AMCAS Sophomore GPA	Running Overall GPA	BCPM Semester Hours	BCPM Quality Hours	Sophomore BCPM GPA	Running BCPM GPA
54				#N/A	#N/A			#N/A	#N/A
55
56		OA Hours	OA Quality Points	Sophomore OA GPA	Running OA GPA
57		0		#N/A	#N/A
58	Junior Classes (Enter Class Name and Catalog Number)		Transcript Grade	Credit Hours on Transcript	AMCAS Weight Grade Point Conversion	AMCAS Calculated Hours	Quality Points	Check box if Biology, Chemistry, Physics, or Math Class (BCPM)	Check box if class is based on the quarter system
59								FALSE	FALSE
60								FALSE	FALSE
61								FALSE	FALSE
62								FALSE	FALSE
63								FALSE	FALSE
64								FALSE	FALSE
65								FALSE	FALSE
66								FALSE	FALSE
67								FALSE	FALSE
68								FALSE	FALSE
69								FALSE	FALSE
70								FALSE	FALSE
71								FALSE	FALSE
72								FALSE	FALSE
73								FALSE	FALSE
74								FALSE	FALSE
75								FALSE	FALSE
76								FALSE	FALSE
77								FALSE	FALSE
78								FALSE	FALSE
79
80	Junior Year Data	Total Semester Hours	Total Junior Quality Points	AMCAS Junior GPA	Running Overall GPA	BCPM Semester Hours	BCPM Quality Hours	Junior BCPM GPA	Running BCPM GPA
81				#N/A	#N/A			#N/A	#N/A
82
83		All Other Hours	All Other Quality Points	All Other Junior GPA	Running All Other GPA
84		0		#N/A	#N/A
85
86	Senior Classes (Enter Class Name and Catalog Number)		Transcript Grade	Credit Hours on Transcript	AMCAS Weight Grade Point Conversion	AMCAS Calculated Hours	Quality Points	Check box if Biology, Chemistry, Physics, or Math Class (BCPM)	Check box if class is based on the quarter system
87								FALSE	FALSE
88								FALSE	FALSE
89								FALSE	FALSE
90								FALSE	FALSE
91								FALSE	FALSE
92								FALSE	FALSE
93								FALSE	FALSE
94								FALSE	FALSE
95								FALSE	FALSE
96								FALSE	FALSE
97								FALSE	FALSE
98								FALSE	FALSE
99								FALSE	FALSE
100								FALSE	FALSE