1. Hey Guest! Check out the 3 MCAT Study Plan Options listed in the 'stickies' area at the top of the forums (BoomBoom, SN2ed, and MCATJelly). Let us know which you like best.

    Also, we now offer a MCAT Test-Prep Exhibitions Forum where you can ask questions directly from the test-prep services.
    Dismiss Notice
  2. This forum is for support and discussion only. Please promote test prep materials/services (including AMAs) in the Special Offers subforum only. Thanks!
    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

Ladies and gentlemen, I present to you: the Mother of all MCAT diagnostic tools

Discussion in 'MCAT: Medical College Admissions Test' started by Marcus Brody, Jun 2, 2008.

  1. Marcus Brody

    Marcus Brody Already has the grail.
    10+ Year Member

    Joined:
    Jun 2, 2008
    Messages:
    3,116
    Likes Received:
    76
    Status:
    Attending Physician
    My EK 1001 Answer Spreadsheet. Calculates scores on each section of the EK 1001 Questions books. Lets you see which sections you performed well/poorly.

    It contains a list of all 4004 questions, each with a separate row where you indicate whether the questions was answered, answered correctly, and if you found the question difficult.

    Scores for each subject of each EK 1001 book are calculated at the top as percentage correct out of the questions that you've answered. As you answer questions, your scores will appear and reflect only the % correct out of the ones you've answered.

    You will have to zoom in to 400% to enter data, and custom zoom out to 25% to scroll far down the list. Because there are 4000 questions, the text is in size 4 font and row/column widths are mad tiny.

    To check off questions as answered and answered correctly, just delete the "1" in their respective rows and columns. To mark a question as difficult, type "1" in that column. Figure it out, you're supposed to be smart.

    Download here:
    http://rapidshare.com/files/119586786/EK_1001_template.xlr.html

    Sample Pics:

    400% zoom
    [​IMG]

    100% zoom
    [​IMG]

    25% zoom
    [​IMG]

    Misc. Notes:
    - you have to answer the first question of each book's section in order for that section's score to appear. That was done to avoid an error message from appearing when the scores are calculated without any questions answered (0/0 = ERR).
    - the columns might need to be resized after downloading.
    - don't delete or change anything in a cell that isn't white.
    - I suggest coloring the cells (questions) you've answered black so that you can easily tell which ones you've done. I also copy/paste the Red/yellow "1" in the difficult columns so I can easily find those later.
    - it's an MS spreadsheet, but it will probably work in Excel also.
    - if mods choose to delete this, it's the forums loss. :p I debated with myself about actually helping the people against whom I am competing, but decided that I'm a nice guy and hopefully Karma does exist.
     
    #1 Marcus Brody, Jun 2, 2008
    Last edited: Jun 2, 2008
  2. LikeClockWork

    Joined:
    Jul 23, 2007
    Messages:
    2,676
    Likes Received:
    5
    Status:
    Pre-Health (Field Undecided)
    Wow. :eek:

    When did you find time to study whilst doing all this?
     
  3. Kaustikos

    Kaustikos Archerize It
    10+ Year Member

    Joined:
    Jan 18, 2008
    Messages:
    12,205
    Likes Received:
    4,159
    Better question; why DIDN'T you do it in excel? :smuggrin:


    JK. Great contribution:thumbup:
     
  4. Vihsadas

    Vihsadas No summer
    Moderator Emeritus Lifetime Donor Classifieds Approved 5+ Year Member

    Joined:
    Oct 17, 2007
    Messages:
    5,472
    Likes Received:
    53
    Status:
    Medical Student
    :eek: (*Vihsadas stares at you blankly because he is speechless*)
     
  5. JA Prufrock

    JA Prufrock Serenity Now!
    2+ Year Member

    Joined:
    Mar 31, 2008
    Messages:
    329
    Likes Received:
    0
    Status:
    Pre-Medical
    Yeah, it's kind of funky on excel. Ah well, looks like a useful tool for those with MW
     
  6. Mandarin142

    2+ Year Member

    Joined:
    Feb 24, 2007
    Messages:
    57
    Likes Received:
    0
    Status:
    Pre-Medical
    This is a pretty hideous download site. The "access code" is impossible to decipher... its taken me 10 minutes to attempt to download it with no success =(
     
  7. Gavanshir

    10+ Year Member

    Joined:
    Sep 25, 2005
    Messages:
    732
    Likes Received:
    92
    Status:
    Resident [Any Field]

    they host a lot of porn, you get used to deciphering :)
     
  8. Richard Baddock

    7+ Year Member

    Joined:
    Dec 15, 2007
    Messages:
    27
    Likes Received:
    8
    Status:
    Pre-Medical
    I wish I had Microsoft Works. This doesn't look very good in Excel, but would probably be very useful if I had Works. Thanks for making this though, I might try to use it at school.
     

Share This Page