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. Dismiss Notice
  3. Visit this thread to beta-test StudySchedule.org. StudySchedule is a free nonprofit site that builds dynamic MCAT study schedules unique for your needs and timeline.
    Dismiss Notice
  4. We will be performing maintenance on the SDN forums on Friday, December 9 at 5:00 AM Eastern.
    Dismiss Notice
Dismiss Notice
Check out the new Application Assistant, where you can calculate your LizzyM score, see how you rank compared to other applicants, and see a list of schools where similar students were accepted.

An MCAT spreadsheet based on the SN2ed schedule

Discussion in 'MCAT Discussions' started by halfwaycrooks, 05.19.14.

  1. SDN is made possible through member donations, sponsorships, and our volunteers. Learn about SDN's nonprofit mission.
  1. halfwaycrooks

    halfwaycrooks This is a library 2+ Year Member

    Joined:
    02.20.14
    Messages:
    245
    MDApps:
    I found that using a spreadsheet during my studying helped me stay organized as well as motivated so I wanted to pass it onto anyone that may find it helpful.

    Spreadsheet

    Info (copied below)

    Some info:
    Find SN2ed’s schedule here

    How the spreadsheet is organized
    • There are tabs for each subject at the bottom of the spreadsheet, meaning a separate sheet for each subject.
    • Within these sheets, all subjects are organized by the content structure found in TBR except for bio.
    • Bio content is organized according to EK. This is in accordance with the SN2ed schedule.
    • This means that the content in Physics, GenChem and Ochem are all organized based on the TBR chapter structure.
    • TPRH and EK1001 content has been associated with the appropriate TBR chapter to the best of my ability.
    • For bio, I have used doctoroftha313’s post to find the appropriate TBR passages that correspond to the EK bio chapters.
    • TPRH bio passages have been associated with the corresponding EK bio chapters.

    How to use the spreadsheet
    • Go to File>>Download as…>>Microsoft excel or Save to your google drive account
    • Fill in the spreadsheet as you go through your studying
    • Enter your scores as ‘=6/7’ if you got 6 out of 7 questions right on a passage
    • The way the sheet is set up presently, if you get a certain grade (out of 100) on a passage, that cell will appear a certain color depending on the grade.
      • To change this, click on the score column>>click the down arrow that appears>>go to conditional formatting & enter your desired preferences.
      • The main purpose of this color coding is to highlight your weakest areas so by the end of content review, you know which weaknesses to eliminate first
    • The DC column is for you to enter the date you did the passage
    • There is also a DS column for the EK1001 part of each sheet for Date Started
      • This column is there because some EK1001 sections have too many questions to complete in one day (may be a good idea to save some for later etc)
    • For the full length score tab, I wanted to get as much data out of practice tests as possible
      • This is why I have a column named ‘For +1’...I found it highly motivating to see how close I was to a higher score

    Closing comments
    This is by no means complete. There is inconsistency between the TBR books as far as phases and number of passages per chapter. Taking that into consideration, the spreadsheet can be easily modified to fit your needs and preferences. Feel free to leave comments, suggestions, questions, etc.

    Best of luck,

    halfwaycrooks
     
    FriedelCrafts, namesthegame21 and NVO like this.
  2. SDN Members don't see this ad. About the ads.
  3. gribear

    gribear SDN Bronze Donor Bronze Donor

    Joined:
    02.23.15
    Messages:
    713
    Location:
    Upper MidWest
    MDApps:
    Status:
    Medical Student (Accepted)
    Well, a year and a half later...I just found this, and THIS IS AMAZING. Thank you!!!!!!
     
  4. kitkat13

    kitkat13 2+ Year Member

    Joined:
    04.05.13
    Messages:
    224
    Status:
    Pre-Medical
    Does the change in color work for you? It doesn't seem to work for me
     
  5. gribear

    gribear SDN Bronze Donor Bronze Donor

    Joined:
    02.23.15
    Messages:
    713
    Location:
    Upper MidWest
    MDApps:
    Status:
    Medical Student (Accepted)
    Hmm..no. It doesn't actually. And some of the scoring inputs are wonky too...like I input =5/6 and it changes it to 1? And will still be yellow. I like it as a template, though...will probably tweak it to make those things work and to account for my changes to the Sn2ed schedule.
     
  6. kitkat13

    kitkat13 2+ Year Member

    Joined:
    04.05.13
    Messages:
    224
    Status:
    Pre-Medical
    Yeah for me, it changes everything to 1 :p
     

About the ads

Share This Page