1. Download free Tapatalk for iPhone or Tapatalk for Android for your phone and follow the SDN forums with push notifications.
    Dismiss Notice
Dismiss Notice

Interview Feedback: Visit Interview Feedback to view and submit interview information.

Interviewing Masterclass: Free masterclass on interviewing from SDN and Medical College of Georgia

Dismiss Notice
Hey Texans—join us for a DFW meetup! Click here to learn more.

AMCAS GPA Calculator (Revised)

Discussion in 'Pre-Medical - MD' started by FeralisExtremum, Jan 1, 2009.

  1. FeralisExtremum

    FeralisExtremum SDN Gold Donor
    Gold Donor Classifieds Approved 10+ Year Member

    Joined:
    May 17, 2008
    Messages:
    2,910
    Likes Received:
    3,205
    Status:
    Dental Student
    Hey everyone,

    I'm sure a lot of you have seen the excel sheet file many use for calculating their AMCAS GPA. It's incredibly useful, but unfortunately, the file is locked from editing and the GPA scale couldn't be modified, which left those of us not using the +/- system at a disadvantage. I went ahead and unlocked the file, so the GPA/weight value portion is now freely editable.

    Attached, you will find the updated excel file. Be sure to press 'Enable macros' for the file to function properly. All credit goes to Johnny Eguizabal, who created the original file.

    NOTE: the sheet is currently defaulted for A= 4.0, B+ = 3.5, C+ = 2.5 These values can be modified at the very bottom of the sheet, and should be done before calculating one's GPA to avoid miscalculation. If you don't know what system your school uses, see pages 3-4 of this document: http://www.aamc.org/students/amcas/2009conversionguide.pdf
     

    Attached Files:

    #1 FeralisExtremum, Jan 1, 2009
    Last edited: Jan 1, 2009
  2. Note: SDN Members do not see this ad.

  3. Slowpoke

    Slowpoke I haz cheezburger
    10+ Year Member

    Joined:
    Sep 15, 2008
    Messages:
    1,701
    Likes Received:
    30
    Status:
    Medical Student
    Woah, good stuff, thanks!
     
    ScienceJunky likes this.
  4. EP123

    2+ Year Member

    Joined:
    Sep 3, 2008
    Messages:
    48
    Likes Received:
    0
    Status:
    Pre-Medical
    What are quality points?
     
  5. FeralisExtremum

    FeralisExtremum SDN Gold Donor
    Gold Donor Classifieds Approved 10+ Year Member

    Joined:
    May 17, 2008
    Messages:
    2,910
    Likes Received:
    3,205
    Status:
    Dental Student
    FYI, if the stuff is in a gray column, there's no need to touch it (automatically calculated via formula).

    I'm pretty sure quality points are just the end result of your semester hours * your grade in that class. For instance, if I pulled an A in a course that was 4 credits, I earned a 4.0 GPA * 4 credit hours = 16 'quality points'. If I had gotten a B in that same course, 3.0 GPA * 4 credit hours = 12 'quality points'. I think AMCAS (or possibly just GPA calculation in general) uses your "earned" quality points over your "potential" quality points for GPA calculation. In the aforementioned example of a B, I earned 12/16 potential quality points, which = .75. .75 (or 75%) of a potential 4.0 gpa = a 3.0, which explains which a person with all B's would have a 3.0 GPA. Long story short...it lets people calculate GPA's of varying grades.
     
  6. premedsoccergod

    2+ Year Member

    Joined:
    Dec 24, 2008
    Messages:
    18
    Likes Received:
    0
    Status:
    Pre-Medical
    holy crap this is awesome. thanks so much
     
  7. MD021

    7+ Year Member

    Joined:
    Dec 17, 2008
    Messages:
    65
    Likes Received:
    0
    Status:
    Pre-Medical
    I have a few questions about the spreadsheet:
    1.) How come B+ grades are listed at 3.5? Shouldn't it be a 3.3?
    2.) Do they really use such rounded numbers when converting quarter to semester? Like shouldn't a 4 unit class be 2.666.. rather than 2.7 and therefore they would wait till the end to multiply it by 2/3?
     
  8. premedsoccergod

    2+ Year Member

    Joined:
    Dec 24, 2008
    Messages:
    18
    Likes Received:
    0
    Status:
    Pre-Medical
    wait wtf. it says B+ = 3.5. shouldn't it be 3.3?
     
  9. FeralisExtremum

    FeralisExtremum SDN Gold Donor
    Gold Donor Classifieds Approved 10+ Year Member

    Joined:
    May 17, 2008
    Messages:
    2,910
    Likes Received:
    3,205
    Status:
    Dental Student
    At my school, a B+ is a 3.5, and I left the sheet defaulted towards the A/B+/B/C/C+/D etc system. The problem with the original sheet was that these values for each grade weren't editable, so now you can change the value of each letter grade to the system used at your school.

    As for the conversion of quarter to semester, I believe the answer is yes, they do use such rounded numbers as can be seen here on the AMCAS official conversion guide: http://www.aamc.org/students/amcas/2009conversionguide.pdf
     
    #8 FeralisExtremum, Jan 1, 2009
    Last edited: Jan 1, 2009
  10. premedsoccergod

    2+ Year Member

    Joined:
    Dec 24, 2008
    Messages:
    18
    Likes Received:
    0
    Status:
    Pre-Medical
    well med school b+ is 3.3 and c+ is 2.3 so i think this would be more accurate:

    medschool.ucsf.edu/postbac/pdf/AMCAS%20GPA_Calculator%20Version%204%20Final.xls
     
  11. FeralisExtremum

    FeralisExtremum SDN Gold Donor
    Gold Donor Classifieds Approved 10+ Year Member

    Joined:
    May 17, 2008
    Messages:
    2,910
    Likes Received:
    3,205
    Status:
    Dental Student
    No, when your AMCAS GPA is calculated, it is done by consideration of your school's system. If you look at the link I posted above on pages 3-4 (http://www.aamc.org/students/amcas/2009conversionguide.pdf), you can see that a school with a +/- system uses a completely different value for "+" grades than schools with "half-step" grading (such as mine). Consider what your school does and apply accordingly in the calculator.
     
  12. MD021

    7+ Year Member

    Joined:
    Dec 17, 2008
    Messages:
    65
    Likes Received:
    0
    Status:
    Pre-Medical
    lol ok,
    using the rounded units raises my gpa by .01 yayyy!
     
  13. premedsoccergod

    2+ Year Member

    Joined:
    Dec 24, 2008
    Messages:
    18
    Likes Received:
    0
    Status:
    Pre-Medical
    1 question, if you get an F or D in a class and you retake the course, you put both of the grades on the application right? and it averages, it doesn't replace it right?
     
  14. FeralisExtremum

    FeralisExtremum SDN Gold Donor
    Gold Donor Classifieds Approved 10+ Year Member

    Joined:
    May 17, 2008
    Messages:
    2,910
    Likes Received:
    3,205
    Status:
    Dental Student
    Correct, there is no replacing with AMCAS. Just input both grades as if they were from separate classes.
     
  15. rayden001

    5+ Year Member

    Joined:
    Feb 19, 2007
    Messages:
    130
    Likes Received:
    0
    Status:
    Pre-Medical
    To what decimal point does AMCAS report one's GPA? Is it 2 or 3 dp? Would a 3.695 be reported as such or would it be 3.7?
     
  16. ProtonatedAlchy

    2+ Year Member

    Joined:
    May 14, 2009
    Messages:
    235
    Likes Received:
    0
    Status:
    Pre-Medical
    so B+ is 3.5? What is an A-, also 3.5?
     
  17. FeralisExtremum

    FeralisExtremum SDN Gold Donor
    Gold Donor Classifieds Approved 10+ Year Member

    Joined:
    May 17, 2008
    Messages:
    2,910
    Likes Received:
    3,205
    Status:
    Dental Student
    That depends on your school. Click the link in the first post to figure out what system your school uses.
     
  18. ProtonatedAlchy

    2+ Year Member

    Joined:
    May 14, 2009
    Messages:
    235
    Likes Received:
    0
    Status:
    Pre-Medical
  19. Samchik

    7+ Year Member

    Joined:
    May 21, 2008
    Messages:
    76
    Likes Received:
    0
    Status:
    Pre-Medical
    I have a question regarding Number of Unit Hours on Transcript:

    I have the following format of transcript:

    [​IMG]


    What numbers should I use for Number of Unit Hours in excel worksheet?
    Thanks in advance!
     
  20. mfrick

    2+ Year Member

    Joined:
    Aug 14, 2008
    Messages:
    32
    Likes Received:
    0
    Status:
    Pre-Medical
  21. This is good stuff. My school though reports +/- etc on transcript, but it gives same quailty point for them. So B+, B, B- each get 3.0, so how does it fit in here ,as I see they should be like 3.3,3.0, 2.7 etc by spreadsheet?
     
  22. A Deep Breath

    A Deep Breath ASA Member
    7+ Year Member

    Joined:
    Feb 3, 2010
    Messages:
    13
    Likes Received:
    8
    Status:
    Medical Student
    If anyone else is having a problem with certain grades producing an error in Google Docs, I found a solution.

    You need to add a FALSE to the end of the VLOOKUP parameters in the "AMCAS Weight" column.

    For example, cell C129 needs to go from:
    =IF(B129="",0.0,VLOOKUP(B129,$A$346:$B$361,2.0))

    to:
    =IF(B129="",0.0,VLOOKUP(B129,$A$346:$B$361,2.0,FALSE))

    You can then paste this cell into all of the others in the "AMCAS Weight" column.
     
  23. apumic

    apumic Oracle of the Sheet
    7+ Year Member

    Joined:
    Jan 1, 2007
    Messages:
    3,970
    Likes Received:
    7
    Status:
    Medical Student
    There seem to be some issues with people's understandings of how GPAs are calculated according to AMCAS, so here are the basic rules (they're actually pretty simple):


    • NO grade replacements (input all courses, including repeats, as separate course entries)
    • 1 quarter hr = 0.67 semester hrs
    • Your GPA pts are calculated as follows:
      • If your school does not list +/- grades, use 4.0/3.0/2.0/1.0/0.0
      • If your school lists only +/null grades (i.e., A/B+/B/C+/etc.), use the half-step scale: 4.0/3.5/3.0/etc.
      • If your school lists +/- grades (regardless of how they are used in the school's own calculations), use 4.0/3.7/3.3/3.0/etc.
    • BCPM courses are defined by content not department (at least 50% of the course content must be BCPM -- so "Bioethics" in the Bio Dept is probably not BCPM, whereas Physiological Psychology probably is BCPM)
      • Caveat: if you list something as BCPM or not BCPM, you will probably get the benefit of the doubt (unless it's obviously incorrect) -- esp. if it's offered by a BCPM dept (and you list it as BCPM)
     
  24. aurora001

    Joined:
    Sep 15, 2010
    Messages:
    6
    Likes Received:
    0
    .
     
    #23 aurora001, Oct 1, 2010
    Last edited: Oct 6, 2010
  25. cluster

    Joined:
    Jan 31, 2011
    Messages:
    32
    Likes Received:
    0
    Status:
    Non-Student
    How do I use the Excel sheet if I received a bunch of transfer credits (26 in total) from an international institution?

    I graduated with a BS in Electrical Engineering from Michigan. I was awarded 26 transfer credits when I enrolled at Michigan and these credits almost completely account for my Freshman year. No grade is reported next to them on my transcript other than a letter initial indicating that it is a transfer credit. As a result I finished my BS in 3 years.

    1. Do I just start completing the excel sheet from the Sophomore year onward?

    2. Does the AMCAS require any transcript from the international institution?

    Thanks,
    ~cluster

    P.S. On a different note. I am contemplating switching careers from engineering to medicine. I plan on starting the HCP program at Harvard Ext. this Fall 2011. If there are any career changers, please get in touch. If you will be enrolling in the HCP program this Fall, even better.
     
  26. owenpg

    7+ Year Member

    Joined:
    Mar 10, 2011
    Messages:
    14
    Likes Received:
    0
    Status:
    Pre-Medical
    Hey everyone, thanks a bunch for the gpa calculating help! I was wondering what I should do if I did my undergraduate degree at a UC on the quarter system and then my post-bac will be at a cal state on the semester system. Should I use the given values for grades if the two schools have two different values? Thanks for your help!
     
  27. xstudent2013

    2+ Year Member

    Joined:
    Mar 27, 2010
    Messages:
    14
    Likes Received:
    0
    Status:
    Pre-Health (Field Undecided)
    I don't get it. How when I put in junior grades after putting in freshman and sophomore grades, even if I put in all A's for junior year, it doesn't show my junior gpa to be a 4.0? I can't enable Macros :/ Is that why it's weird or is it suppose to be like that because of the quality points or whatever?
     
  28. aviendhae

    Joined:
    Aug 12, 2011
    Messages:
    90
    Likes Received:
    0
    MDApps:
    Status:
    Pre-Medical

    Actually, just for reference because I know these posts are older, that depends on your school. We use the forgiveness policy. Which basically means I can retake a course and use my new shiny A to replace my old F. No average. The old grade still shows up on your transcripts, but it is not calculated for your GPA. We can use this policy up to three times. If we just retake the course and don't apply for forgiveness, then yes, it will just average out.

    It also works with amnesty, which means your old grades are wiped and not counted towards your GPA. However they too show up on your transcript. Amnesty is not something you can do unless you have been out of school for a long time. Again, depends on your school.
     
  29. aSagacious

    Moderator Emeritus 7+ Year Member

    Joined:
    Nov 16, 2010
    Messages:
    8,141
    Likes Received:
    59
    Status:
    Resident [Any Field]
    Sorry, but this is incorrect. AMCAS doesn't care what your school policy is, it averages both the retake and the original course regardless.

    From p. 36 of AMCAS Instruction Manual
     
  30. aviendhae

    Joined:
    Aug 12, 2011
    Messages:
    90
    Likes Received:
    0
    MDApps:
    Status:
    Pre-Medical
    So basically I should give up on applying to med school? If they take it all into account, then I'm looking at a <1.0 gpa.
     
  31. aSagacious

    Moderator Emeritus 7+ Year Member

    Joined:
    Nov 16, 2010
    Messages:
    8,141
    Likes Received:
    59
    Status:
    Resident [Any Field]
    AACOMAS (for DO schools) participates in grade replacement, whereas AMCAS (for MD schools) does not. Sorry.
     
  32. aviendhae

    Joined:
    Aug 12, 2011
    Messages:
    90
    Likes Received:
    0
    MDApps:
    Status:
    Pre-Medical
    Thanks :) Better to know this now than later on in my UG years.
     
  33. desi0chick

    7+ Year Member

    Joined:
    Sep 6, 2009
    Messages:
    160
    Likes Received:
    19
    Status:
    Medical Student
    I'm still a bit confused. What's the difference between "Running overall gpa" and "Running all other gpa" Which one do medical schools look at..?
     
  34. aSagacious

    Moderator Emeritus 7+ Year Member

    Joined:
    Nov 16, 2010
    Messages:
    8,141
    Likes Received:
    59
    Status:
    Resident [Any Field]
    Both. You have:
    - a BCPM GPA (for your math and science courses)
    - a cumulative GPA (for everything taken since high school, including college courses taken during high school)
    - an 'all-others' GPA, which is simply the average of the courses not included in the BCPM calculation

    ...they are all listed side by side on your application.
     
  35. gettheleadout

    Moderator Emeritus 7+ Year Member

    Joined:
    Jun 22, 2010
    Messages:
    11,815
    Likes Received:
    2,779
    Status:
    Medical Student
    Does anybody know how to get the visual basic macros (used for calculating BCPM GPA separately) to work in Office for Mac 2008? I know visual basic macros are unsupported, but I couldn't get them to carry over into Google Docs either and I don't have an older/newer version of Office for Mac. :(
     
  36. paul411

    paul411 ANES
    7+ Year Member

    Joined:
    May 27, 2010
    Messages:
    1,617
    Likes Received:
    31
    Status:
    Resident [Any Field]
    The macros toggle the value of the cell between TRUE and FALSE. So you can manually enter in "TRUE" in the formula bar for the cell with the checkbox that you want to check as BCPM. It gives the same result. You might want to change the formatting of the "Biology, Chemistry, Physics, or Math Class (BCPM) (Check Box if Yes)" column to be able to see the text.
     
  37. gettheleadout

    Moderator Emeritus 7+ Year Member

    Joined:
    Jun 22, 2010
    Messages:
    11,815
    Likes Received:
    2,779
    Status:
    Medical Student
    While that's a great workaround, I ended up downloading OpenOffice and checking the boxes in there, and after saving the file and reopening it in Excel the check boxes seem to be working without a hitch. :shrug: I hate Microsoft.

    But thanks Paul, still loving (and slightly modifying ;)) your MDApps code by the way. :)
     
  38. mcatmcatmcat

    Joined:
    Mar 11, 2012
    Messages:
    6
    Likes Received:
    0



    I have a similar question!!! If i took science classes at 2 different universities, are those grades both incorporated into the same BCPM gpa?
     
  39. aSagacious

    Moderator Emeritus 7+ Year Member

    Joined:
    Nov 16, 2010
    Messages:
    8,141
    Likes Received:
    59
    Status:
    Resident [Any Field]
    Yes.
     
  40. circulus vitios

    7+ Year Member

    Joined:
    Jul 18, 2008
    Messages:
    6,257
    Likes Received:
    1,631
    I did one year at a local college that used a strange grading scale, A/B+/B/B-/etc. I think. Basically there was no A-. They changed this grading scale and I can't find any old course catalogs. I don't mean to brag like a douchebag, but I never made anything other than an A or a B+. So for me, the system most closely matches "ABCD/F with Halfstep Grades" on this page https://www.aamc.org/students/download/181676/data/amcas_grade_conversion_guide.pdf

    My GPA is dead on when I compare the GPA the college gave me and the GPA following that scale would give me. Could I get AMCAS to verify my GPA with that system, even though it isn't truly accurate?
     
  41. jsabb12

    5+ Year Member

    Joined:
    Mar 15, 2011
    Messages:
    5
    Likes Received:
    0
    What if I took a class pass/fail? meaning i got 0 quality points, but i passed.

    also, would you consider "thermodynamics of biomolecular systems" a bcpm? I am in the biomedical engineering department and all most all my classes deal with biological applications, so does that make them bcpm?

    also, do AP transfer credits count??

    thanks!
     
    #40 jsabb12, Mar 15, 2012
    Last edited: Mar 15, 2012
  42. DAPI

    5+ Year Member

    Joined:
    Mar 29, 2011
    Messages:
    1,603
    Likes Received:
    14
    MDApps:
    Status:
    Medical Student
    I would not recommend that. If you order an official transcript form the school and send it to yourself there will be an interpretation section or something similar printed on the back of each page of the transcript. It will tell you what kind of system the school uses. I would use whatever it says as that is what AMCAS and the school you matriculate into will see.
     
  43. DAPI

    5+ Year Member

    Joined:
    Mar 29, 2011
    Messages:
    1,603
    Likes Received:
    14
    MDApps:
    Status:
    Medical Student
    1) It just means its not worth any GPA points
    2) You can list it as BCMP if you like and AMCAS will confirm or deny it. You can then submit some kind of petition if you really want it to BCMP and they will decide after that again.
    3) Not sure on AP, but I think if the institution granting your degree accepts them as official credits and they are listed on your official transcript they count in AMCAS, but some specify school may not accept them as pre-reqs.
     
  44. Panliz

    Joined:
    Mar 2, 2012
    Messages:
    27
    Likes Received:
    0
    Status:
    Pre-Pharmacy
    Sorry I am still confused.... So if grade appears on my transcript is in a 4.0 scale (I.e. 3.9, 3.8, 3.7 etc) Do I count 3.8 as A or A-?:oops:
     
  45. Midifelder10

    5+ Year Member

    Joined:
    Mar 15, 2009
    Messages:
    365
    Likes Received:
    1
    Status:
    Non-Student
    My school gives 4.0 for A, A+ and A- and 3.0 for B, B+ and B-. They distinguish between letter grades but not so between number grades. What would AMCAS consider i.e. A- as 3.7 or the 4.0 which the school has given.
     
    BlueCircle likes this.
  46. ld1208

    Joined:
    Aug 30, 2012
    Messages:
    14
    Likes Received:
    0
    Status:
    Pre-Medical
    Are summer courses worth fewer semester hours? AMCAS listed my two summer courses as only 3 hrs each, as opposed to the 4 hrs they assign to normal courses. If the institution (Upenn) at which I took my summer courses says their courses are worth the same number of credit units as a normal course, why is AMCAS counting them as only 3 hrs?
     
  47. astronomical

    5+ Year Member

    Joined:
    Dec 13, 2012
    Messages:
    17
    Likes Received:
    0
    Status:
    Pre-Medical
    Does Business Statistics (BUS-101), Statistics for Economists (ECON-101), count as a your BCPM? These two courses are quite similar to Statistics under (MATH-101).
     
  48. astronomical

    5+ Year Member

    Joined:
    Dec 13, 2012
    Messages:
    17
    Likes Received:
    0
    Status:
    Pre-Medical
  49. Hemorrage

    Hemorrage Ambrose
    Bronze Donor Classifieds Approved 5+ Year Member

    Joined:
    Sep 4, 2011
    Messages:
    1,570
    Likes Received:
    233
    Status:
    Medical Student
    Amcas usually verifies by department number. Regardless of if your class is statistics for monkeys or statistics for engineers, if its listed under "MATH" or "MA" or any other variant it will count as BCPM, otherwise its unlikely.
     
  50. Political

    2+ Year Member

    Joined:
    Nov 23, 2010
    Messages:
    351
    Likes Received:
    0
    Does the BPCM gpa count cross listed courses as well? For instance I took two courses in advanced symbolic logic under the philosophy department but they are cross listed as MAT 275 and MAT 375 as well
     
  51. Hemorrage

    Hemorrage Ambrose
    Bronze Donor Classifieds Approved 5+ Year Member

    Joined:
    Sep 4, 2011
    Messages:
    1,570
    Likes Received:
    233
    Status:
    Medical Student
    Yes if you can prove to them it was the same class
     

Share This Page