I've been meaning to go back and work on this a bit - I'm glad someone forked it! One suggestion - I would add back in the GPA portion with the conversion tables - the reason I went out and made a calculator in the first place is most of the schools I've attended give out numerical grades not letter grades, and none of the other options out there had that.
Sent from my iPad using SDN mobile
I've been meaning to go back and work on this a bit - I'm glad someone forked it! One suggestion - I would add back in the GPA portion with the conversion tables - the reason I went out and made a calculator in the first place is most of the schools I've attended give out numerical grades not letter grades, and none of the other options out there had that.
Sent from my iPad using SDN mobile
Thanks for the feedback! I added the table back and made a note in the instructions.
I really like this new version; it is so beautiful. How do I make one of the years longer? My sophomore year is very long because I switched schools. S0 basically I want sophomore year to be like 30 cells long. Any help anyone?
Just FYI - it doesn't matter what you decide (or your school decided I should say), AMCAS sets a number of credits for each year and that's how they figure it out. So credits 1-12 (I don't remember the exact numbers I'm just throwing fake #'s out) is freshman, 12-24 is soph, etc.
But just insert a line and drag down any formulas
Sent from my iPad using SDN mobile
I really like this new version; it is so beautiful. How do I make one of the years longer? My sophomore year is very long because I switched schools. S0 basically I want sophomore year to be like 30 cells long. Any help anyone?
The yellow column (which uses a formula) automatically figures that out for you. However, if you want to assign the Classification yourself, you can override the formula by typing in the classification in the yellow column. And Make sure to use the correct spelling and capitalization of letters as seen on the graph.
Just FYI - it doesn't matter what you decide (or your school decided I should say), AMCAS sets a number of credits for each year and that's how they figure it out. So credits 1-12 (I don't remember the exact numbers I'm just throwing fake #'s out) is freshman, 12-24 is soph, etc.
But just insert a line and drag down any formulas
Sent from my iPad using SDN mobile
From the 2014 instruction manual p.38
Freshman (FR): 0-32 semester hours
Sophomore (SO): 31-64 semester hours
Junior (JR):61-96 semester hours
Senior (SR):91+ semester hours
Thank you Maverick and Ayjaystudent!!
I totally forgot about the credit number assigned p year. I will keep this in mind and NOT change the cells' formulas.
Excellent tool! I do have a recommendation, though.
If I'm remembering correctly, AACOMAS includes many more classes in their sGPA calculation (Nursing classes, for example). It might be beneficial to have a column in addition to BCPM that allows for AACOMAS science courses to be marked.
Thanks again for the excellent tool!
-LD
Just copy the sheet and have an aacomas and an Amcas sheet - then just put x's in any classes that fall into bcpm. You'll want two anyway to keep straight the differing gpas due to retakes
Sent from my iPhone using SDN mobile
Simple enough. Thanks Mavric!
Sent from my SAMSUNG-SGH-I337 using SDN mobile
Excellent tool! I do have a recommendation, though.
If I'm remembering correctly, AACOMAS includes many more classes in their sGPA calculation (Nursing classes, for example). It might be beneficial to have a column in addition to BCPM that allows for AACOMAS science courses to be marked.
Thanks again for the excellent tool!
-LD
Thanks for the recommendation! I just found out that Math courses don't count towards AACOMAS Science GPA calculation, but it does count for AMCAS.
For this reason, I have updated the Calculator. There is now a separate column for AMCAS BCPM and AACOMAS BCP.
Feel free to use it and let me know if you have new feedback/concerns.
Reactions: 1 usersI also just want to add that if you're using a grading system that uses "pluses" or "minuses" and you had a B+, you'll probably get an incorrect result. The original Excel File from 2014 (which the current spreadsheet was based from) is assigning 3.5 as a value for B+. It should be 3.3. This was brought to my attention by one user. I have now updated the Spreadsheet to reflect the conversion from AMCAS's pdf file.
Feel free to download if your grading system was using plus/minuses. Otherwise, your grades should have been fine.
Reactions: 1 userGraduate work stays the same as it is. It never gets combined with undergraduate GPA and it has its own section.
The reason there's an undergraduate calculator is because it's very common for Pre-meds to take undergraduate classes from multiple institutions. Aggregating them with a calculator helps in the process.
Well it was improved just in time
Its sad that they stopped allowing grade replacement so suddenly. It crushes so many people
Reactions: 1 usersJust FYI - it doesn't matter what you decide (or your school decided I should say), AMCAS sets a number of credits for each year and that's how they figure it out. So credits 1-12 (I don't remember the exact numbers I'm just throwing fake #'s out) is freshman, 12-24 is soph, etc.
But just insert a line and drag down any formulas
Sent from my iPad using SDN mobile
Do you know how college courses taken while at high school factor into this? Would those be the official starting point for the AMCAS freshman year? I know that they have a row dedicated to high school.
EDIT: Nevermind. I guess I'll use the EXCEL to do HS first then add cells for freshman to fit in.
"2. Other Courses
Many high school students take other types of college-level courses either independently or through special programs offered by their high school. Courses may be physically taken at the high school or at a college, depending on the program, but should be listed on the application under the name of the college.
You must contact the college involved to determine transcript availability prior to completing the application. If a transcript from the college is available, it must be forwarded to AMCAS and courses must be listed in the Course Work section of your application. If letter grades and credit hours are listed on the college transcript, these courses will be included in AMCAS GPA calculations, even if they have not been transferred to the primary undergraduate school or used towards a degree. These courses do not require any Special Course Type, unless otherwise appropriate. The Year in School for such courses is "High School".
If a transcript is not available from the college, do not send high school transcripts to AMCAS. Instead, the registrar’s office of the college should forward an official letter with an AMCAS Transcript Request Form attached indicating that no transcript is available due to institutional policies. The Transcript Request Form can be found in the Transcript Requests section of the application."
