• Economist Test Prep
    Free Trial & Practice Exam
    BEAT THE GMAT EXCLUSIVE

    Available with Beat the GMAT members only code

    MORE DETAILS
    Economist Test Prep
  • Kaplan Test Prep
    Free Practice Test & Review
    How would you score if you took the GMAT

    Available with Beat the GMAT members only code

    MORE DETAILS
    Kaplan Test Prep
  • Target Test Prep
    5-Day Free Trial
    5-day free, full-access trial TTP Quant

    Available with Beat the GMAT members only code

    MORE DETAILS
    Target Test Prep
  • Magoosh
    Magoosh
    Study with Magoosh GMAT prep

    Available with Beat the GMAT members only code

    MORE DETAILS
    Magoosh
  • Veritas Prep
    Free Veritas GMAT Class
    Experience Lesson 1 Live Free

    Available with Beat the GMAT members only code

    MORE DETAILS
    Veritas Prep
  • PrepScholar GMAT
    5 Day FREE Trial
    Study Smarter, Not Harder

    Available with Beat the GMAT members only code

    MORE DETAILS
    PrepScholar GMAT
  • EMPOWERgmat Slider
    1 Hour Free
    BEAT THE GMAT EXCLUSIVE

    Available with Beat the GMAT members only code

    MORE DETAILS
    EMPOWERgmat Slider
  • Varsity Tutors
    Award-winning private GMAT tutoring
    Register now and save up to $200

    Available with Beat the GMAT members only code

    MORE DETAILS
    Varsity Tutors
  • e-gmat Exclusive Offer
    Get 300+ Practice Questions
    25 Video lessons and 6 Webinars for FREE

    Available with Beat the GMAT members only code

    MORE DETAILS
    e-gmat Exclusive Offer

GMAT Study Grid with per question timing and enhanced.

This topic has 2 member replies
vittalgmat Legendary Member Default Avatar
Joined
09 Apr 2008
Posted:
621 messages
Followed by:
4 members
Thanked:
33 times

GMAT Study Grid with per question timing and enhanced.

Post Tue Apr 20, 2010 9:45 pm
Hi Folks,
I have attached an updated version of the GMAT Practice Grid (excel spreadsheet) that is found in this forum. I have enhanced it a lot! This has been long overdue. Enjoy, good luck and send me your comments.

Here is the list of enhancements. You can consider this to be the user manual as well !! Smile
1. There are two version of the GMAT Study Grid. The one attached here is a individual timing grid. Each question is individually timed and the timer stops after *each question*. So this grid is very useful when u are plowing along practicing for GMAT and you very well know that u cannot get 75 minutes of undisturbed chunk of time but u can get many chunks of 3 minute windows.. (while working in the office for example).
2. Start and Stop buttons start and stop the entire test.
3. Clear all will clear all the answers.. Try it.
4. The field next to "type" currently shows RC. keep clicking on this to cycle thru RC, SC, Math etc.
5. There are columns marked slow, not sure. You can click on these or at times the spreadsheet automatically does it for u.
6. Correct and Wrong columns are obvious. Click on the cell in Wrong column.. to cycle from A thru E. These are supposed to be the correct answers.
7. U can write a quick note on a particular question in Notes.
8. There is a clickable set of columns marked "contenders". Some times while answering a question we will have more than 1 contenders and cannot choose.. These columns are used to mark them. For example. in a particular SC question, I think both A and C are correct. But I will have to choose one of these as my final answer. So I will choose C as my final answer but I can now click A as my contender.
9. Review column will automatically get filled when a parcicular question is wrong or u took more than thestandard time for that question.
10. The final column called "Passage" is used for RC questions where u can choose a particular question as the passage. ie. u have finished 5 questions and now 6th question involves an RC passage. Double click the passage cell corresponding to 6. You will see the row 6 duplicated below the current question 6. Now the first of the duplicated rows can time the passage. Here. after u have read the passage.
11. On the top you will see a bunch of statistics.. like avg time taken per question. etc.
12. There are many not-so-obvious features such as the per question timer will change its color depending on whether the question was solved within the time limit or went beyond.
13. There are little Red triangles above some cells. Hover your mouse over them to see more features.
14. The question numbers need not start from 1. U can go to a question number and type a number and type return. Automatically all numbers below that are re-ordered.



Now for the known bugs.
1. Since this is an individual timing sheet. The overall "time left" field does not work properly, especially when there are pauses between questions. Example: let us say u solved 5 quesitions in a sequence and then you were interrupted for 30 minutes. later you came back and did 20 more. In this scenario, the "time left" field does not take care of the 30 min interruption.
So you either ignore it or you can help me solve this bug and send me your fix. I am very busy right now so cant devote time to fix this. As such, this timer does not hinder your progress and utility of this spreadsheet.
2. Dont use the "Pause" button. The timers will go out of whack. Since individual questions are timed here, there is no need to use Pause button.
Attachments

This post contains an attachment. You must be logged in to download/view this file. Please login or register as a user.

Need free GMAT or MBA advice from an expert? Register for Beat The GMAT now and post your question in these forums!

GMAT/MBA Expert

Osirus@VeritasPrep GMAT Instructor Default Avatar
Joined
28 May 2009
Posted:
1578 messages
Followed by:
34 members
Thanked:
128 times
GMAT Score:
760
Post Wed Apr 21, 2010 7:02 am
Thanks for this. This should be helpful

_________________
http://www.beatthegmat.com/the-retake-osirus-blog-t51414.html

Brandon Dorsey
GMAT Instructor
Veritas Prep

Buy any Veritas Prep book(s) and receive access to 5 Practice Cats for free! Learn More.

Enroll in a Veritas Prep GMAT class completely for FREE. Wondering if a GMAT course is right for you? Attend the first class session of an actual GMAT course, either in-person or live online, and see for yourself why so many students choose to work with Veritas Prep. Find a class now!
gmatiyer Newbie | Next Rank: 10 Posts Default Avatar
Joined
24 Apr 2010
Posted:
7 messages
Followed by:
1 members
Post Wed Sep 01, 2010 8:22 pm
Hi Vittal!
Thanks for the excellent practice tool. It works like a charm. I noticed a couple of things - "Time for Each Question" does not adjust the total time. The timer just sticks to the initial value. i also noticed that even though the "Passage?" column is marked, the timer does not run the full 4 minutes for the passage. Nonetheless, an awesome tool!
Thanks,
gmatiyer

P.S. Geaux Tigers (As a fellow LSU grad, I have to mention this) !

Best Conversation Starters

1 LUANDATO 153 topics
2 lheiannie07 87 topics
3 Roland2rule 75 topics
4 AAPL 62 topics
5 ardz24 60 topics
See More Top Beat The GMAT Members...

Most Active Experts

1 image description EconomistGMATTutor

The Economist GMAT Tutor

166 posts
2 image description GMATGuruNY

The Princeton Review Teacher

130 posts
3 image description Jay@ManhattanReview

Manhattan Review

128 posts
4 image description Rich.C@EMPOWERgma...

EMPOWERgmat

121 posts
5 image description Brent@GMATPrepNow

GMAT Prep Now Teacher

99 posts
See More Top Beat The GMAT Experts