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

US News 2003, 2004, 2005 Med Rankings on Excel

Discussion in 'Pre-Medical - MD' started by exmike, Apr 14, 2004.

  1. exmike

    exmike NOR * CAL
    10+ Year Member

    Joined:
    May 19, 2003
    Messages:
    4,206
    Likes Received:
    10
    Status:
    Fellow [Any Field]
    I think some of you stats / rankings lovers will get a kick out of this. I put the last three years of US News rankings into an excel sheet. Now you guys dont have to ask for it or buy it. You can notice some interesting trends between the years. Sorting by category produces some interesting results too. ENJOY!

    U.S. News 2003, 2003, 2005 Rankings on Excel

    p.s. Each Year is on a different sheet, so you can tab through the three sheets.
     
  2. You're just trying to get more Karma points!

    Hey I already paid for these, dammit... but this won't open on my computer I don't know why.
     
  3. Oh, nevermind, now it opens.

    :clap: :clap:
     
  4. Tezzie

    Tezzie b*witched
    7+ Year Member

    Joined:
    Sep 8, 2003
    Messages:
    1,209
    Likes Received:
    0
    Great post Mike :thumbup: !

    I would have given you a karma point but it seems i've given out too many already!
     
  5. Samus Aran

    Physician Moderator Emeritus 15+ Year Member

    Joined:
    Apr 10, 2003
    Messages:
    6,795
    Likes Received:
    26
    Status:
    Fellow [Any Field]
    Does anyone know if the GPA reported for each school is their average science or overall GPA?
     
  6. exmike

    exmike NOR * CAL
    10+ Year Member

    Joined:
    May 19, 2003
    Messages:
    4,206
    Likes Received:
    10
    Status:
    Fellow [Any Field]

    Its the overall GPA
     
  7. Tezzie

    Tezzie b*witched
    7+ Year Member

    Joined:
    Sep 8, 2003
    Messages:
    1,209
    Likes Received:
    0
    Overall Misty!
     
  8. Samus Aran

    Physician Moderator Emeritus 15+ Year Member

    Joined:
    Apr 10, 2003
    Messages:
    6,795
    Likes Received:
    26
    Status:
    Fellow [Any Field]
    Thank God for that... :laugh:
     
  9. Thank you very much!

    Karma for you! :)
     
  10. noclouds

    noclouds Member
    7+ Year Member

    Joined:
    Mar 6, 2004
    Messages:
    30
    Likes Received:
    0
    thanks for sharing the data and putting it all into excel! :)

    just one thing though --- where are the 2004 and 2005 columns for "% of class getting top 3 residency choices"?

    or why has US news stopped gathering that data? :confused:

    thanks again!!
     
  11. 10minutes

    10minutes M.D.Candidate
    5+ Year Member

    Joined:
    Apr 10, 2004
    Messages:
    250
    Likes Received:
    2
    Whoa, I didn't know my school has faculty/student ratio- 1.5. That's great. We also have a high residency point. Cool!
     
  12. Scooby Doo

    Scooby Doo IEatShavedPussyCats
    10+ Year Member

    Joined:
    Jul 9, 2001
    Messages:
    3,797
    Likes Received:
    1
    Top 3 residency is total crap...don't even pay attention to it...it's a skewed process that doesn't matter. Almost everyone at every school will get their top 3 b/c u aren't interviewed unless you have a decent chance..and if the school is going to guide you as to where you can apply....top choices are only based on where you interview...hence, every school is like 80 to 90%...a total waste of research for anyone.... btw, Rankings matter...but not to the extent that a #4 school is any better than a # 9 school....Go based on how you felt about the school, the environment, the rank, etc etc....in whatever order you have to do it...
     
  13. CalBeE

    7+ Year Member

    Joined:
    Dec 14, 2003
    Messages:
    2,062
    Likes Received:
    1
    Mike,

    What happened to your med school predictions? Are they no longer valid? :(

    How do you have so much time to do stuff like that? Sometimes I feel that I got so busy that I rarely have time to eat at all...
     
  14. Spitting Camel

    Spitting Camel Anteater for Life!
    7+ Year Member

    Joined:
    Nov 6, 2003
    Messages:
    1,847
    Likes Received:
    1
    Isn't the 1.5 ratio small? BU only has 1.8 faculty to each student. Some schools have 6,7 or 8 faculty for every student... hmmm... Am I analyzing this wrong? :confused:
     
  15. snapdad

    snapdad Rock and Roll Doctor
    10+ Year Member

    Joined:
    Oct 31, 2003
    Messages:
    607
    Likes Received:
    0
    Status:
    Non-Student
    Very very cool. Thanks! :thumbup:
     
  16. FrankMD

    FrankMD Ophthalmologist Wanna Be
    10+ Year Member

    Joined:
    Jul 14, 2001
    Messages:
    169
    Likes Received:
    0
    Status:
    Fellow [Any Field]
    this is great! thanks!
     
  17. Spitting Camel

    Spitting Camel Anteater for Life!
    7+ Year Member

    Joined:
    Nov 6, 2003
    Messages:
    1,847
    Likes Received:
    1
    What's great is your screen name! I LOVE it! :laugh: :clap: :laugh: Every School I have ever gone to has been blue and gold! I've been a Crusader, Monarch, Baron, Anteater, and now Boston(?) Does anyone know their colors? If they're not blue and gold, I may have to withdraw... What's their mascot, anyway?
     
  18. 10minutes

    10minutes M.D.Candidate
    5+ Year Member

    Joined:
    Apr 10, 2004
    Messages:
    250
    Likes Received:
    2
    Maybe you are right, shoot! :(
     
  19. exmike

    exmike NOR * CAL
    10+ Year Member

    Joined:
    May 19, 2003
    Messages:
    4,206
    Likes Received:
    10
    Status:
    Fellow [Any Field]
    Hehe, i thought noone was looking at them anymore, so i took them down. want them back up?


    And i have a lot of free time now. I dont worry much about my ms program anymore. man i cant wait to start med school!
     
  20. dhooppi

    dhooppi Member
    7+ Year Member

    Joined:
    Feb 16, 2004
    Messages:
    51
    Likes Received:
    0
    you da man!!!
     
  21. Eyecon82

    Eyecon82 Senior Member
    7+ Year Member

    Joined:
    Nov 3, 2003
    Messages:
    450
    Likes Received:
    2
    Thanks man...that was very thoughtful of you! Can someone please tell me what this karma thing is all about? isn't karma supposed to be a bad thing?
     
  22. pekq

    pekq Gunner
    7+ Year Member

    Joined:
    Jan 26, 2004
    Messages:
    360
    Likes Received:
    2
    Is it accurate to calculate total faculty based on fac/stu ratio multiplied by total students? I am trying to calculate the NIH/Fac ratio as some ppl have said that US News should consider it as a factor. According to preliminary analysis, UCSD would get quite a boost if this was factored in.
     
  23. jjmack

    jjmack Senior Member
    15+ Year Member

    Joined:
    Mar 2, 2003
    Messages:
    823
    Likes Received:
    11
    Status:
    MD/PhD Student, Resident [Any Field]
    That is an interesting idea, but it would be better if there were some way to only factor in fac who do research. I'm not totally certain, but think some fac at schools with larger hospitals are almost totally clinical.

     
  24. CalBeE

    7+ Year Member

    Joined:
    Dec 14, 2003
    Messages:
    2,062
    Likes Received:
    1
    Karma is a Neutral term, like "Temperature", or "History". It's basically a record of what you have done in the past, whether in this life, or in your past life (i.e. Changing your screen name won't erase your past!). Hence you can earn BAD or GOOD karma for your actions.
     
  25. exmike

    exmike NOR * CAL
    10+ Year Member

    Joined:
    May 19, 2003
    Messages:
    4,206
    Likes Received:
    10
    Status:
    Fellow [Any Field]

    Maybe you should forward that idea to US News so they can change the methodolgy and throw the rankings world into turmoil.
     
  26. med9812

    med9812 New Member

    Joined:
    Apr 15, 2004
    Messages:
    3
    Likes Received:
    0
    Awesome work! Any chance you have the complete list of Pediatrics ranks for each year? (or at least for 2005?) Thanks!

    :) :)
     
  27. jlee9531

    jlee9531 J,A,S
    10+ Year Member

    Joined:
    Nov 25, 2002
    Messages:
    5,470
    Likes Received:
    8
    Status:
    Attending Physician
    and now i see why mike is the top karma getting on the entire site of sdn... ;)
     
  28. pekq

    pekq Gunner
    7+ Year Member

    Joined:
    Jan 26, 2004
    Messages:
    360
    Likes Received:
    2
    If they did that, Harvard would lose #1 and washu would replace them :eek:
    There's no way US News would ever do anything that'd displace Harvard from #1 cause Harvard bribes them with acceptances ;)
     
  29. RAwe

    RAwe Senior Member
    10+ Year Member

    Joined:
    Feb 17, 2004
    Messages:
    111
    Likes Received:
    0


    Way to go Exmike...Thanx :clap:
     
  30. jjmack

    jjmack Senior Member
    15+ Year Member

    Joined:
    Mar 2, 2003
    Messages:
    823
    Likes Received:
    11
    Status:
    MD/PhD Student, Resident [Any Field]
    I would love to watch the wash u bashers find a way to bash them on having too much funding per PI.

     
  31. pekq

    pekq Gunner
    7+ Year Member

    Joined:
    Jan 26, 2004
    Messages:
    360
    Likes Received:
    2
    Maybe a better gauge of quality of research would be ratio of publication in a prestigious journal (eg. C/N/S) to # of PI. Then Harvard would probably retain first place. Again, UCSD would shoot up.
     
  32. eyeful

    eyeful Member
    7+ Year Member

    Joined:
    Jan 30, 2004
    Messages:
    45
    Likes Received:
    0
    excellent. thanks.
     
  33. Mr Reddly

    Mr Reddly Snowglobe!
    7+ Year Member

    Joined:
    Jan 14, 2004
    Messages:
    900
    Likes Received:
    1
    OMFG!!! You put a Macro Virus in there!!! Now I have to detox my labtop!!! Ooooooh Big Time Negative Karma points for you mister!!!











    ...(j/k) :D
     
  34. why do they rank a diff number of schools each year?
     
  35. klooless

    klooless Senior Member
    7+ Year Member

    Joined:
    Nov 29, 2003
    Messages:
    175
    Likes Received:
    0
    For 2005, you have Stanford at #9. However, it's actually tied at #8 with Columbia (rather than Columbia being tied at #7 with U Mich).
     
  36. Scooby Doo

    Scooby Doo IEatShavedPussyCats
    10+ Year Member

    Joined:
    Jul 9, 2001
    Messages:
    3,797
    Likes Received:
    1
    Fuk stanfurd
     
  37. klooless

    klooless Senior Member
    7+ Year Member

    Joined:
    Nov 29, 2003
    Messages:
    175
    Likes Received:
    0
    Any particular reason, or are you just feeling hostile?
     
  38. Scooby Doo

    Scooby Doo IEatShavedPussyCats
    10+ Year Member

    Joined:
    Jul 9, 2001
    Messages:
    3,797
    Likes Received:
    1
    Go BEARS! :)
     
  39. klooless

    klooless Senior Member
    7+ Year Member

    Joined:
    Nov 29, 2003
    Messages:
    175
    Likes Received:
    0
    gotcha..... ;)
     

Share This Page