About the ads

  1. Check out PREMED.me!
    Offers FREE service to help premeds manage their applications and MCAT study calendars and identify schools to target.

Legitimate, Free, SDN matriculant data spreadsheet

Discussion in 'Pre-Medical Allopathic [ MD ]' started by DrTroll, Jun 19, 2011.

  1. SDN is a nonprofit organization. Services are made possible through the generous support of SDN members and sponsors. Thank you.
  1. DrTroll

    DrTroll

    Joined:
    Jul 16, 2010
    Messages:
    250
    Location:
    TX
    Status:
    Pre-Medical
    SDN 2+ Year Member

    SDN Members don't see this ad. (About Ads)
    Hey guys, this originally was aSagacious's idea, I'm just starting a new thread to get some more attention and help as suggested by the cat.

    The original LizzyM spreadsheet is banned because of objections from AAMC, so aSagacious suggested we started a "legitimate, free, SDN matriculant data spreadsheet." with data published by schools.

    He/she got the ball rolling by setting the format and the first 20 schools, and I got the data for Texas schools that I can find.

    If you would like to help, please insert data into the spreadsheet if you can, or you can state your willingness to insert the data after it's posted.

    Please also link to the source of data to legitimatize it.

    Thanks!


    Edit: Thanks to everybody that's been helping out, we got so many schools done within 24 hours, let's keep it up!

    And here is the Link to Google doc spreadsheet version:
    http://is.gd/sdn_med_matriculant_data (thanks to paul411 for setting it up)

    If anyone wants to use the "Chances" feature (which predicts how well you'll do at a school based on your "LizzyM Score") download your own copy of the spreadsheet and enter your stats.

    If you would like to contribute, please message paul411 for access permission. (public edit feature disabled due to trolls keeping messing up the data)
    Last edited: Jun 19, 2011
  2. flatearth22

    flatearth22

    Joined:
    Sep 23, 2007
    Messages:
    1,870
    Location:
    NorCal --> Flyover Country
    Status:
    Medical Student
    SDN 5+ Year Member
    Here's an idea:

    why don't we just post directly from the latest MSAR (will take a lot of time and work) BUT instead of copying it number for number why don't we "fudge" the numbers by a common factor (ie - multiply them all by 1.1 or something). That way it isn't copyright. The individual person who downloads it can then apply a function to the entire excel sheet to reverse the 1.1 multiplying factor. Basically, what we post IS NOT the MSAR. People do stuff similar to "copyrighted" Youtube videos (speed it up, slow it down) in order for them not to get taken down and then the user can download them and then reverse the effect to get the original.
  3. eugenierose

    eugenierose Princess Popsicle

    Joined:
    Nov 23, 2010
    Messages:
    77
    SDN 2+ Year Member
    b/c you can do the same thing with data from the websites?
  4. aSagacious

    aSagacious Send in the clowns Moderator Emeritus

    Joined:
    Nov 16, 2010
    Messages:
    8,123
    Status:
    Medical Student
    SDN 2+ Year Member
    A- That is a bad idea
    B- Again, the MSAR posts ACCEPTED applicant data, what people have been recently asking for is MATRICULANT data

    Good idea. I've updated my entries with sources.

    Attached Files:

  5. Narmerguy

    Narmerguy SDN Senior Moderator

    Joined:
    Jul 14, 2007
    Messages:
    6,630
    SDN 7+ Year Member
    Eh, let's just try to make this as legit as possible so there's no more song and dance about this spreadsheet.

    I'm doing the last 5-7.

    Some things I'm already noticing: Yeah, lot's of schools post their matriculant data but sometimes students like myself care more about accepted student data. However, not all schools post matriculant, some post accepted. Would a spreadsheet where both of these #'s are being used be appropriate?
  6. gettheleadout

    gettheleadout custom title blank Moderator

    Joined:
    Jun 22, 2010
    Messages:
    11,184
    Status:
    Pre-Medical
    SDN 2+ Year Member
    Even though it would be double the amount of work to complete, I agree with Narmerguy that some people may be looking for different information and slots for both Accepted and Matriculant data would be useful.

    flatearth, that's essentially intent to break copyright. It's pretty obvious.
  7. PressPforPi

    PressPforPi

    Joined:
    Mar 9, 2011
    Messages:
    422
    Status:
    Pre-Medical
    My biggest thanks to everyone who contributes data. People like you are the reason SDN is so useful as a resource. Oh, and thanks for adding the DO schools as well. Much appreciated!
    naijacardriodoc likes this.
  8. Narmerguy

    Narmerguy SDN Senior Moderator

    Joined:
    Jul 14, 2007
    Messages:
    6,630
    SDN 7+ Year Member
    Well sadly I flatout haven't seen a school that provides both yet. I also agree that we probably should provide both, but it's pretty darn difficult to find on their website. I've inserted comments into the MCAT total column to indiciate whether this was for matriculating or accepted students.

    There's going to have to be some serious quality control at the end and sadly some reworking as with multiple sources of info we may be getting different flavors of information.

    Attached Files:

  9. Ride Big Sky

    Ride Big Sky relax a little

    Joined:
    Aug 16, 2007
    Messages:
    399
    Location:
    local farmers market
    SDN 5+ Year Member
    Seriously, just pick up a copy of the MSAR. Trying to get a spreadsheet like this will introduce way too many variables to be worth it. Some schools post matriculants/accepted students numbers, some give ranges, some only give partial information ie: no in state vs. out of state numbers, some may have data that's a few years old. It simply makes more sense to go to the library or advisors office and spend some time flipping through pages to get an accurate idea.
  10. RogueUnicorn

    RogueUnicorn rawr.

    Joined:
    Jul 15, 2009
    Messages:
    9,251
    Status:
    Medical Student
    SDN 5+ Year Member
    +1. just plop down on the msar + usnes you cheapskates
  11. aSagacious

    aSagacious Send in the clowns Moderator Emeritus

    Joined:
    Nov 16, 2010
    Messages:
    8,123
    Status:
    Medical Student
    SDN 2+ Year Member
    Ok, here's another update (working on the bottom, since they require scrolling to keep track of headers).

    Attached Files:

  12. Gnomes

    Gnomes

    Joined:
    Dec 29, 2008
    Messages:
    139
    Location:
    Long Island
    Status:
    MD/PhD Student
    SDN 5+ Year Member
    I must be missing something here.

    In the United States, to copyright something, it has to be original or creative in some way. You can't copyright the data in a telephone directory, for example:
    http://en.wikipedia.org/wiki/Feist_Publications_v._Rural_Telephone_Service

    Why would you be able to copyright statistics about medical school applicants?

    Unless you sign an NDA when you get the AAMC's handbook, how could they have any grounds to object to someone posting numerical data from it?
  13. NYR56

    NYR56

    Joined:
    Nov 16, 2008
    Messages:
    633
    Location:
    Long Island
    Status:
    Medical Student
    SDN 5+ Year Member
    First of all, why would anyone care about matriculant data? Accepted data is far more valuable and gives people an idea of what they need to be accepted. If you pick what school you go to based on average matriculant MCAT/GPA, you're retarded.

    This is what I was thinking. It's BS the AAMC claims that data is copyrighted. Anyone can claim they have a copyright, but you don't have to listen to them just because they say that. Unfortunately SDN doesn't want to go against what the AAMC wants.
  14. Narmerguy

    Narmerguy SDN Senior Moderator

    Joined:
    Jul 14, 2007
    Messages:
    6,630
    SDN 7+ Year Member
    Someone contact the pre-law forum.


    He has a point...
    Last edited: Jun 19, 2011
  15. aSagacious

    aSagacious Send in the clowns Moderator Emeritus

    Joined:
    Nov 16, 2010
    Messages:
    8,123
    Status:
    Medical Student
    SDN 2+ Year Member
    Hmm, these clearly seem to suggest that transcription of a handful of data columns from the MSAR or US News is completely legal, as they are not copyright-able collections of data.
  16. MeowMeowCAT

    MeowMeowCAT

    Joined:
    Nov 27, 2010
    Messages:
    2,235
    Status:
    Pre-Pharmacy
    SDN 2+ Year Member
    If you are worried about copyright just spread the way the other excel spreadsheet was. Post here, someone will repost somewhere else, here it will get locked by a mod, but by that time you have the spreadsheet being posted elsewhere, and before you know it the spreadsheet is "Google-able" and forever online.

    Just play dumb, pretend not to be aware that you are doing a bad thing, and before you know it the spreadsheet is accessible and no one gets in trouble.
  17. mauberley

    mauberley radiating prestige

    Joined:
    Apr 13, 2009
    Messages:
    4,542
    Location:
    Urbs in Horto
    Status:
    Medical Student
    SDN 5+ Year Member
    Setting aside the discussion of whether the claim to copyright is valid, I would suspect that if you (personally) want to challenge it in court, you're more than welcome to, if you provide your own resources. I'd be hard pressed to think of a reason why SDN would want pitch in its own resources to fight that battle.
  18. Gnomes

    Gnomes

    Joined:
    Dec 29, 2008
    Messages:
    139
    Location:
    Long Island
    Status:
    MD/PhD Student
    SDN 5+ Year Member
    Indeed, I would think that "all medical schools in the US and Canada" is a very obvious selection of schools to cover for the intended audience, and that applicant GPA/MCAT would be equally obvious pieces of data to include about these schools. The case for originality could be bolstered, perhaps, by organizing the data in some reasonable way different from the AAMC's.
  19. Avoidthetiger

    Avoidthetiger roar

    Joined:
    Dec 29, 2008
    Messages:
    1,543
    Status:
    Medical Student
    SDN 2+ Year Member
    I don't know if this is legit... but I made a spreadsheet out of the Eduers data last summer -- well after first using the LizzyM spreadsheet (which helped me narrow down schools that where in my range). The data is from 2007... maybe 2009... but it just helped me get a general idea.

    I was interested not only in average MCAT and GPA, but also percent of applicants interviewed (which eduers tells you - breakdown of women, IS, OSS, minorities - it's pretty cool). Reach schools tended to interview more students compared to "my good chance" schools... so i made a mishmash list based on my chances of being interviewed. I know I am a good interviewer... so even with lower numbers, if given the chance - I knew I could rock it.

    After making my list, I verified it over with the MSAR. My schools pre-med department had a copy which they let me borrow (without leaving), so I am sure most schools can let you do the same.

    Just my 2cents.
  20. aSagacious

    aSagacious Send in the clowns Moderator Emeritus

    Joined:
    Nov 16, 2010
    Messages:
    8,123
    Status:
    Medical Student
    SDN 2+ Year Member
    If it were in Excel, organization would go out the window because you could readily sort by any data column (state, alphabet, MCAT, GPA... none of which are uncommon).
  21. Gnomes

    Gnomes

    Joined:
    Dec 29, 2008
    Messages:
    139
    Location:
    Long Island
    Status:
    MD/PhD Student
    SDN 5+ Year Member
    Well, I tend to agree, but on the face of it, the copyright claim seems to ludicrous that you should be able to get it dismissed with prejudice if they actually sued. I very much doubt they'd have to fight anything in court. I mean, it fits very neatly into the Feist v Rural template.

    AAMC must know that it's strictly bluffing; a quick consultation with an IP lawyer should confirm this theory. If someone sent me a cease-and-desist letter over it, I'd try to get a declaratory judgment against them in my own jurisdiction.
  22. raltima07

    raltima07

    Joined:
    Jan 24, 2011
    Messages:
    2,804
    Status:
    Pre-Medical
    SDN 2+ Year Member

    It is google-able atm no?
  23. MeowMeowCAT

    MeowMeowCAT

    Joined:
    Nov 27, 2010
    Messages:
    2,235
    Status:
    Pre-Pharmacy
    SDN 2+ Year Member
    What? :sleep:
  24. Swiss Medical

    Swiss Medical

    Joined:
    Apr 23, 2011
    Messages:
    455
    Location:
    Dallas
    Status:
    Pre-Medical
    NCPA hSDN Member hSDN Alumni
    Excellent idea guys! But I already have the msar....
  25. LifeTake2

    LifeTake2

    Joined:
    Nov 30, 2010
    Messages:
    912
    Status:
    Pre-Medical
    SDN 2+ Year Member
    I know pre-meds are a bit neurotic (I'm one) but grow up a bit. The content of the MSAR is copyrighted, and yes they would fight and win to protect it.

    They own the underlying data, they spend the $$ to collect, process and manipulate it. Unless you collect the data from the schools and store/process it yourself you are violating their copyright and will lose.

    Ultimately, spend the $ and by a copy of the MSAR, or do your own research and quit pretending to be lawyers.
  26. Catalystik

    Catalystik Providing Herd Protection SDN Advisor

    Joined:
    Sep 4, 2006
    Messages:
    20,545
    Physician Faculty SDN 7+ Year Member
    Like maybe having a matriculant Lizzy M number for the first column [MCAT score + (cGPA X 10)] and perhaps including an OOS matriculant rate? Including the DO schools is a great idea, too.
  27. Gnomes

    Gnomes

    Joined:
    Dec 29, 2008
    Messages:
    139
    Location:
    Long Island
    Status:
    MD/PhD Student
    SDN 5+ Year Member
    That might be fair and just, but it's not the law. The supreme court explicitly considered and rejected your rationale:

    http://en.wikipedia.org/wiki/Sweat_of_the_brow

    Courts in some other parts of the world do agree with your reasoning, as had a few in the US before Feist v Rural. Yours is not a rationally untenable position by any means, but there are other equally viable positions to take on the matter, and it is one of those, not yours, that has been chosen by the supreme court.
  28. FIREitUP

    FIREitUP

    Joined:
    Jul 31, 2007
    Messages:
    2,390
    Location:
    TBL
    Status:
    Medical Student
    SDN 7+ Year Member
    Gives the applicant an idea of what kind of student matriculates there; i.e., a school can overaccept people with high stats like crazy and skew their numbers. Matriculated data lets us know how the school ends up after all those students with high stats withdraw. Plus, with matriculated data you aren't over-representing people with high stats, since each person gets one data point. With accepted data, students with high numbers are accepted all over the place and their numbers are taken into account numerous times.
  29. mauberley

    mauberley radiating prestige

    Joined:
    Apr 13, 2009
    Messages:
    4,542
    Location:
    Urbs in Horto
    Status:
    Medical Student
    SDN 5+ Year Member
    Sure, that would be a fine plan if it was important enough to you to even do that. My personal quick cost-benefit analysis (no lawyers needed), were I in SDN's shoes, would say it's preferable to comply with any C&D requests rather than challenge them.

    Okay.
  30. RogueUnicorn

    RogueUnicorn rawr.

    Joined:
    Jul 15, 2009
    Messages:
    9,251
    Status:
    Medical Student
    SDN 5+ Year Member
    you're a pre-frosh with an msar? :laugh::thumbup:

    but srsly, i still don't understand this obsession; the relative cost for these data is extremely small. the absolute cost is also quite low.
  31. mauberley

    mauberley radiating prestige

    Joined:
    Apr 13, 2009
    Messages:
    4,542
    Location:
    Urbs in Horto
    Status:
    Medical Student
    SDN 5+ Year Member
    Principles, man.
  32. Ride Big Sky

    Ride Big Sky relax a little

    Joined:
    Aug 16, 2007
    Messages:
    399
    Location:
    local farmers market
    SDN 5+ Year Member
    Seriously here people. You can spend tons of time compiling a set of data that is most likely flawed due to the differences in reporting from one school to the next, you can argue over a bunch of laws that nobody here actually knows (stop pretending to be lawyers already! wiki isn't the equivalent of a law degree), OR you could just look it up in the MSAR quick and easy at the library or pre med office.
  33. Doc of the Walk

    Doc of the Walk

    Joined:
    Nov 9, 2010
    Messages:
    630
    Location:
    Funkytown, Virginia
    Status:
    Pre-Medical
    I am honestly not surprised. You aren't even close to applying, why did you get one?
  34. Swiss Medical

    Swiss Medical

    Joined:
    Apr 23, 2011
    Messages:
    455
    Location:
    Dallas
    Status:
    Pre-Medical
    NCPA hSDN Member hSDN Alumni
    It was a gift for the newest one, but I also have two previous editions to project my anticipated school list. :)
  35. paul411

    paul411 Dr. Mantis Toboggan

    Joined:
    May 27, 2010
    Messages:
    1,601
    Location:
    Texas
    Status:
    Medical Student
    SDN 2+ Year Member
    We need a Google Docs version of this for collaborative editing.
  36. NickNaylor

    NickNaylor Daisy the Dog

    Joined:
    May 22, 2008
    Messages:
    13,557
    Location:
    Chicago, IL
    Status:
    Medical Student
    SDN Published Author SDN 5+ Year Member
    Was going to suggest this exact thing.

    Whoever has the latest version: upload it to Google docs, set it to be shared with anyone with the link, and post the link here. That'll make it much easier for people to contribute and not repeat work.
  37. Elpenor

    Elpenor

    Joined:
    Oct 14, 2009
    Messages:
    489
    Status:
    Pre-Health (Field Undecided)
    SDN 2+ Year Member
    I feel bad for people who didn't get the old school selector excel before it got taken down
  38. paul411

    paul411 Dr. Mantis Toboggan

    Joined:
    May 27, 2010
    Messages:
    1,601
    Location:
    Texas
    Status:
    Medical Student
    SDN 2+ Year Member
    Google Docs spreadsheet: http://is.gd/sdn_med_matriculant_data

    Publicly editable. Add any contributions here so people don't repeat work.

    Tip for finding official school data:
    Google search something like this:
    Code:
    site:[I]med-school.edu[/I] mcat gpa
    Where med-school.edu is the official domain of the medical school whose data you are looking for. This will search only the school's website for pages/documents containing the keywords "mcat" and "gpa"
    Last edited: Jun 19, 2011
  39. Narmerguy

    Narmerguy SDN Senior Moderator

    Joined:
    Jul 14, 2007
    Messages:
    6,630
    SDN 7+ Year Member
  40. WeAreNotRobots

    WeAreNotRobots MS4

    Joined:
    Nov 11, 2008
    Messages:
    1,039
    Location:
    CA
    Status:
    Medical Student
    SDN 5+ Year Member
    Why not just copy all the msar data you want into a spreadsheet and fudge each statistic by +/- 0.01 or 0.02. Here's the catch...each person that contributes a portion of the data decides how to "encrypt" the data, but no one ever tells anyone else how they adjusted the numbers. That way it is a completely unique set of data with an encryption code that no single person knows. All the data would have a very tiny degree of error, but still be entirely useful and pretty accurate.

    :)
  41. Gnomes

    Gnomes

    Joined:
    Dec 29, 2008
    Messages:
    139
    Location:
    Long Island
    Status:
    MD/PhD Student
    SDN 5+ Year Member
    I continue to be totally unimpressed by that argument. This is not a complex case.

    Tell me, if you see this in your neighbors' kid, are you going to refrain from bringing it to their attention because you're not a physician yet? Or worse, because you're not an ophthalmologist? Or because you're not the world's foremost expert on retinoblastoma?

    Of course, if I got the C&D, I'd consult a lawyer, but that should be obvious. Likewise with the suspected retinoblastoma, I'd say something along the lines of "Gee, that could be a retinoblastoma, I think you should see a doctor right away," not "I think your child has a retinoblastoma. I'll take that sucker out with a dinner fork for $50, what do you say, Bob?"

    I would love to hear a legal argument for the data being protected that isn't specifically refuted by current case law.

    Anyway, some of us have graduated and are separated from our pre-med office by several thousand miles.
  42. Narmerguy

    Narmerguy SDN Senior Moderator

    Joined:
    Jul 14, 2007
    Messages:
    6,630
    SDN 7+ Year Member
    FWIW I've already bought the MSAR guidebook :laugh: This isn't out of a personal need for the information.
  43. raltima07

    raltima07

    Joined:
    Jan 24, 2011
    Messages:
    2,804
    Status:
    Pre-Medical
    SDN 2+ Year Member
    _
    Last edited: Jun 19, 2011
  44. Long Way to Go

    Long Way to Go

    Joined:
    Jan 2, 2011
    Messages:
    532
    Location:
    Far from where I should be
    Status:
    Pre-Medical
    SDN 2+ Year Member
    @Gnomes: Feel free to do that if you want, but I'm not spending a couple of days of my life finding and hiring a lawyer, traveling to district court, and fighting the motions. I have better things to do with my life, and I imagine that's the attitude of most people here.
  45. aSagacious

    aSagacious Send in the clowns Moderator Emeritus

    Joined:
    Nov 16, 2010
    Messages:
    8,123
    Status:
    Medical Student
    SDN 2+ Year Member
    +1. I'm helping with data collection so I can add it as an 'altruistic activity' on my primary :D.

    *sarcastic*
  46. RogueUnicorn

    RogueUnicorn rawr.

    Joined:
    Jul 15, 2009
    Messages:
    9,251
    Status:
    Medical Student
    SDN 5+ Year Member

    right, because when the AAMC attorneys go fact-finding, there's no way they'll happen on your post in this completely private thread in the not most visible premedical forum on the internet. stop thinking like kids and understand the implications of your actions here. if you are going to plug in the data i sure as hell wouldn't go posting the MSAR, regardless of how you'll oh-so-cleverly hide the data; the AAMC has demonstrated before they will protect their publications. use publicly available stuff, and nothing more. i doubt any of you are using ip obfuscating tech and even dynamic ip can be traced back to you. and on the off chance this does blow up, sdn is not going to protect you.
  47. aSagacious

    aSagacious Send in the clowns Moderator Emeritus

    Joined:
    Nov 16, 2010
    Messages:
    8,123
    Status:
    Medical Student
    SDN 2+ Year Member
    :ninja:
  48. paul411

    paul411 Dr. Mantis Toboggan

    Joined:
    May 27, 2010
    Messages:
    1,601
    Location:
    Texas
    Status:
    Medical Student
    SDN 2+ Year Member
    :thumbup:

    Adding "LizzyM score" to the Google Docs version (http://is.gd/sdn_med_matriculant_data)
  49. paul411

    paul411 Dr. Mantis Toboggan

    Joined:
    May 27, 2010
    Messages:
    1,601
    Location:
    Texas
    Status:
    Medical Student
    SDN 2+ Year Member
    Let's just add publicly available (and verifiable) data posted by the schools and include the source URL.
  50. Narmerguy

    Narmerguy SDN Senior Moderator

    Joined:
    Jul 14, 2007
    Messages:
    6,630
    SDN 7+ Year Member
    While I somewhat agree that we shouldn't use that approach, let's not pretend that users will have their IP addresses looked up and used to prosecute them. This has close to no precedent in any instance not involving mass p2p sharing of songs, games, and videos.

Share This Page


About the ads