1. Dismiss Notice
  2. Download free Tapatalk for iPhone or Tapatalk for Android for your phone and follow the SDN forums with push notifications.
    Dismiss Notice
Dismiss Notice
Visit Interview Feedback to view and submit interview information.

School Selection Spreadsheet

Discussion in 'Pre-Medical - MD' started by Depakote, May 10, 2008.

  1. Depakote

    Depakote Pediatric Anesthesiologist
    Rocket Scientist Physician Moderator Emeritus Lifetime Donor Classifieds Approved 10+ Year Member

    Joined:
    Nov 2, 2004
    Messages:
    20,812
    Likes Received:
    99
    Status:
    Attending Physician
    Last year I made a spreadsheet that helped me organize my thoughts when I was deciding between some schools.

    I've adapted it to help those of you that might still be deciding which offers to decline and those of you that might be getting off of waitlists in the coming weeks.

    Here is how you use the sheet and interpret the results:

    First. Take the criteria and put them in the order most important to you. Add any that you need.

    Then give the schools subjective grades. If one school did particularly well in that area, give the school positive number, if the school did particularly poorly give it a negative number. For me, the rankings are a bit relative in that I had been to both schools prior to filling out the form, and if both were exactly tied, I gave both 0's. However, if both did well in an area, I would give both positive numbers, b/c a good performance in one area could outweigh a poor performance in another (e.x. all had good medical mission opportunities but School A got a better score, b/c I liked their's better and that point for Schools B and C could counteract something that I didn't like another area). The color coding was an after thought to make everything a little easier to understand.

    Once you have the values totaled, use the sum function to total your raw score.

    Now the spreadsheet should automatically calculate an adjusted score in the adjusted columns. This score is weighted by the value of the importance of each criteria (so curriculum is more important than gym and gets more weight in the adjusted score). The adjusted score will then be the one you want to look at if you are using this spreadsheet.

    The multiplication factor is not entirely arbitrary, but it's not totally scientific.

    the formula is y=1/(.25x)

    This gives you a decreasing multiplier that looks something like this:

    [​IMG]

    I played with the values and this seemed to give a good decreasing scale across ~20 criteria. It gives good strong points to the most important criteria by heavilly weighting them and then levels off at the later criteria.

    If you're making major changes, you'll want to check to be sure that you haven't thrown off any of the calculations. If you don't have any experience with Excel, you might want to get some help with this.

    Anyway, a lot of this was just gut reaction when assessing certain aspects of the schools. Go with what you think works... let me know if you have specific questions. Good luck.

    Disclaimer: This is just a tool to help you make decisions. I pretty much found that the spreasheet just confirmed what I was thinking all along. If you disagree with what the spreadsheet says or wishing the results came out different, that's probably you making your decision right there.


    Here is the spreadsheet and an example spreadsheet on how you might apply it:
     

    Attached Files:

    Xzu, amerepedestrian and Sunbodi like this.
  2. Note: SDN Members do not see this ad.

  3. Depakote

    Depakote Pediatric Anesthesiologist
    Rocket Scientist Physician Moderator Emeritus Lifetime Donor Classifieds Approved 10+ Year Member

    Joined:
    Nov 2, 2004
    Messages:
    20,812
    Likes Received:
    99
    Status:
    Attending Physician
    I'll give this a bump
     
  4. zpiff

    zpiff Spaceman
    10+ Year Member

    Joined:
    Dec 6, 2007
    Messages:
    450
    Likes Received:
    0
    Status:
    Medical Student
    Thanks! I was trying to make something to this effect last night so I'll definitely take a look at this!
     
  5. Depakote

    Depakote Pediatric Anesthesiologist
    Rocket Scientist Physician Moderator Emeritus Lifetime Donor Classifieds Approved 10+ Year Member

    Joined:
    Nov 2, 2004
    Messages:
    20,812
    Likes Received:
    99
    Status:
    Attending Physician
    going ahead and sticking this lest it get buried in X v. Y threads.

    feel free to ignore if you don't find it useful.
     
  6. Ella Shepherd

    Ella Shepherd Screen. Stage. Studio.
    2+ Year Member

    Joined:
    Nov 4, 2007
    Messages:
    409
    Likes Received:
    0
    Status:
    Pre-Medical
    Stickied. :) Very helpful, thanks! :D
     
  7. Doc Henry

    Doc Henry blowin' in the wind
    10+ Year Member

    Joined:
    Feb 4, 2007
    Messages:
    933
    Likes Received:
    3
    MDApps:
    Status:
    Pre-Medical
    This looks like a good tool. I couldn't help myself from guessing about A, B, C and I had A=DMU B=AZCOM?? C=PCOM/CCOM. On the charts page I found out I was pretty much right about DMU and CCOM because it went from saying "A and C" to the real names. No such luck on B though, still just said B. In any event, thanks for the useful tool! I can only hope I'll br lucky enough to use it next year
     
  8. Depakote

    Depakote Pediatric Anesthesiologist
    Rocket Scientist Physician Moderator Emeritus Lifetime Donor Classifieds Approved 10+ Year Member

    Joined:
    Nov 2, 2004
    Messages:
    20,812
    Likes Received:
    99
    Status:
    Attending Physician
    Ah, thought I had taken all the original school info out, guess I missed some. :laugh:

    Anyway, since you saw I'll go ahead and say that School B was KCUMB.

    edit: the original spreadsheets also had columns for OMM and dress-codes.
     
  9. Depakote

    Depakote Pediatric Anesthesiologist
    Rocket Scientist Physician Moderator Emeritus Lifetime Donor Classifieds Approved 10+ Year Member

    Joined:
    Nov 2, 2004
    Messages:
    20,812
    Likes Received:
    99
    Status:
    Attending Physician
    I've revised and streamlined the spreadsheet.

    If you used the other-one, there really isn't a functional difference. This one just has it all in one place.
     

    Attached Files:

  10. lucybug

    2+ Year Member

    Joined:
    Jun 7, 2007
    Messages:
    46
    Likes Received:
    0
    Status:
    Pre-Medical
    This is great! I am glad to see others love excel just as much as I do.
     
  11. Depakote

    Depakote Pediatric Anesthesiologist
    Rocket Scientist Physician Moderator Emeritus Lifetime Donor Classifieds Approved 10+ Year Member

    Joined:
    Nov 2, 2004
    Messages:
    20,812
    Likes Received:
    99
    Status:
    Attending Physician
    unstuck.

    feel free to bump as needed.
     
  12. Depakote

    Depakote Pediatric Anesthesiologist
    Rocket Scientist Physician Moderator Emeritus Lifetime Donor Classifieds Approved 10+ Year Member

    Joined:
    Nov 2, 2004
    Messages:
    20,812
    Likes Received:
    99
    Status:
    Attending Physician
  13. chad5871

    Physician Moderator Emeritus 10+ Year Member

    Joined:
    Apr 6, 2006
    Messages:
    5,276
    Likes Received:
    10
    MDApps:
    Status:
    Resident [Any Field]
    That is so classic! I just sat here for five minutes watching that over and over again! :laugh:
     
  14. paradocs we are

    paradocs we are In love with you
    2+ Year Member

    Joined:
    Apr 2, 2007
    Messages:
    4,737
    Likes Received:
    0
    Status:
    Medical Student
    How fitting for the 2-7AM crew thread.
     
  15. pianola

    pianola MS2
    7+ Year Member

    Joined:
    May 23, 2008
    Messages:
    6,072
    Likes Received:
    14
    Status:
    Medical Student
    WOW...yeah, that's all I have to say. :thumbup:
     
  16. ButImLETired

    ButImLETired Prodigal member
    Moderator Emeritus 5+ Year Member

    Joined:
    May 27, 2008
    Messages:
    3,281
    Likes Received:
    73
    Status:
    Resident [Any Field]
    Bumping since it's already come up...
     
  17. amerepedestrian

    Joined:
    Sep 21, 2017
    Messages:
    232
    Likes Received:
    205
    Status:
    Pre-Medical
    Using this and finding very helpful 9 years later. This should be a bulletin post!
     
    Sunbodi likes this.
  18. Lawper

    Lawper In 3D
    Rocket Scientist Gold Donor 2+ Year Member

    Joined:
    Jun 17, 2014
    Messages:
    14,002
    Likes Received:
    36,225
    I actually recommend everyone to use @voteknope spreadsheet

    voteknope's School Selection Spreadsheet

    The thread is found in Essential SDN Wisdom sticky.
     
  19. amerepedestrian

    Joined:
    Sep 21, 2017
    Messages:
    232
    Likes Received:
    205
    Status:
    Pre-Medical
    Hmm...What makes you prefer that one to the one in this thread? I prefer the color-coding aspect of this one, but I guess the weighting system is more arbitrary/possibly not as useful.
     
  20. Lawper

    Lawper In 3D
    Rocket Scientist Gold Donor 2+ Year Member

    Joined:
    Jun 17, 2014
    Messages:
    14,002
    Likes Received:
    36,225
    It's more current and changes can be made more readily. This thread is pretty much obsolete.
     

Share This Page