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.
SDN members see fewer ads and full resolution images. Join our non-profit community!

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

Discussion in 'MCAT Discussions' started by Marcus Brody, Jun 2, 2008.

  1. Marcus Brody

    Marcus Brody Already has the grail. 7+ Year Member

    Jun 2, 2008
    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:

    Sample Pics:

    400% zoom

    100% zoom

    25% zoom

    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.
    Last edited: Jun 2, 2008
  2. SDN Members don't see this ad. About the ads.
  3. LikeClockWork

    LikeClockWork Guest

    Jul 23, 2007
    Wow. :eek:

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

    Kaustikos Archerize It 7+ Year Member

    Jan 18, 2008
    Always Bespin
    Better question; why DIDN'T you do it in excel? :smuggrin:

    JK. Great contribution:thumbup:
  5. Vihsadas

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

    Oct 17, 2007
    An Igloo
    :eek: (*Vihsadas stares at you blankly because he is speechless*)
  6. JA Prufrock

    JA Prufrock Serenity Now! 2+ Year Member

    Mar 31, 2008
    Yeah, it's kind of funky on excel. Ah well, looks like a useful tool for those with MW
  7. Mandarin142

    Mandarin142 2+ Year Member

    Feb 24, 2007
    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 =(
  8. Gavanshir

    Gavanshir 10+ Year Member

    Sep 25, 2005

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

    Richard Baddock 7+ Year Member

    Dec 15, 2007
    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