• Magoosh
    Magoosh
    Study with Magoosh GMAT prep

    Available with Beat the GMAT members only code

    MORE DETAILS
    Magoosh
  • 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
  • PrepScholar GMAT
    5 Day FREE Trial
    Study Smarter, Not Harder

    Available with Beat the GMAT members only code

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

    Available with Beat the GMAT members only code

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

    Available with Beat the GMAT members only code

    MORE DETAILS
    Economist 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
  • 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
  • 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
  • EMPOWERgmat Slider
    1 Hour Free
    BEAT THE GMAT EXCLUSIVE

    Available with Beat the GMAT members only code

    MORE DETAILS
    EMPOWERgmat Slider

GMAT Study Grid with per question timing and enhanced.

This topic has 1 expert reply and 1 member reply
vittalgmat Legendary Member Default Avatar
Joined
09 Apr 2008
Posted:
621 messages
Followed by:
4 members
Upvotes:
33

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.

  • +1 Upvote Post
  • Quote
  • Flag
Need free GMAT or MBA advice from an expert? Register for Beat The GMAT now and post your question in these forums!
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) !

  • +1 Upvote Post
  • Quote
  • Flag

GMAT/MBA Expert

Osirus@VeritasPrep GMAT Instructor Default Avatar
Joined
28 May 2009
Posted:
1578 messages
Followed by:
34 members
Upvotes:
128
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.

  • +1 Upvote Post
  • Quote
  • Flag
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!

Best Conversation Starters

1 Roland2rule 161 topics
2 lheiannie07 110 topics
3 ardz24 56 topics
4 LUANDATO 53 topics
5 Vincen 50 topics
See More Top Beat The GMAT Members...

Most Active Experts

1 image description Brent@GMATPrepNow

GMAT Prep Now Teacher

151 posts
2 image description Jeff@TargetTestPrep

Target Test Prep

145 posts
3 image description GMATGuruNY

The Princeton Review Teacher

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

EMPOWERgmat

111 posts
5 image description Scott@TargetTestPrep

Target Test Prep

98 posts
See More Top Beat The GMAT Experts