• Economist Test Prep
    Free Trial & Practice Exam

    Available with Beat the GMAT members only code

    Economist Test Prep
  • Magoosh
    Study with Magoosh GMAT prep

    Available with Beat the GMAT members only code

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

    Available with Beat the GMAT members only code

    Kaplan Test Prep
  • Veritas Prep
    Free Veritas GMAT Class
    Experience Lesson 1 Live Free

    Available with Beat the GMAT members only code

    Veritas Prep
  • EMPOWERgmat Slider
    1 Hour Free

    Available with Beat the GMAT members only code

    EMPOWERgmat Slider
  • Target Test Prep
    5-Day Free Trial
    5-day free, full-access trial TTP Quant

    Available with Beat the GMAT members only code

    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

    e-gmat Exclusive Offer
  • Varsity Tutors
    Award-winning private GMAT tutoring
    Register now and save up to $200

    Available with Beat the GMAT members only code

    Varsity Tutors
  • PrepScholar GMAT
    5 Day FREE Trial
    Study Smarter, Not Harder

    Available with Beat the GMAT members only code

    PrepScholar GMAT

GMAT Practice Grid - Use this to analyze your errors

This topic has 14 expert replies and 62 member replies
Goto page Previous
schinge4 Newbie | Next Rank: 10 Posts Default Avatar
17 Jul 2014
1 messages
1 times
Post Thu Jul 17, 2014 2:49 am
Hey guys,

the macros of the versions posted here in the comments do not seem to work on my excel for Mac. Could anyone possibly upload a mac compatible version?

Many thanks in advance!!! Smile

Thanked by: Royalbacon
Need free GMAT or MBA advice from an expert? Register for Beat The GMAT now and post your question in these forums!
anmol730 Newbie | Next Rank: 10 Posts
07 Sep 2015
1 messages
Post Tue Oct 06, 2015 7:32 pm
I am unable to add more questions, like limit is limited to 40Qs.

Any workaround for this?

beatthegmat wrote:
Here is a practice grid to help you work through your practice problem sets. I can't emphasize enough how important this grid was in helping me to identify where I was weak and prepare tactically.

When you open this spreadsheet, you will notice the following fields:

  • Start time
  • Question number
  • Answer choices (a, b, c, d, e)
  • Feeling on question (slow, not sure)
  • Result (correct, wrong, careless error, concept error)
  • Notes

Here is how you can use this spreadsheet to analyze your strengthes and weaknesses:

I would try doing forty problems each day of a certain type. For example, I would do forty SC questions, or forty PS questions--I wouldn't mix up problem types. I would give myself a time limit to answer the forty questions, usually an hour. I wouldn't take any breaks, I would just try to answer all the questions consecutively in the time I gave myself.

I would keep a clock nearby and write down the time after every 10 questions in the "Start Time" field to get a sense of how I was keeping pace. I would use this grid to mark off my answer choice, and if a problem was particularly difficult for me, I would sometimes mark the "Slow" or "Not sure" fields so that I could remember that a particular question was hard.

After I had gone through the 40 problems, I would go back and use the answer key to check off questions that were correct or wrong on my grid. If I got something wrong, I would try to classify what kind of error it was in my mind. If it was a stupid error that I shouldn't have made, I would check off "Careless error." If the answer was wrong because I didn't understand it fundamentally, I would check off "Concept error."

Additionally, for each of the 40 questions, I would try to classify the type of problem in the "Notes field." For example, if I were doing a set of 40 math problem solving questions, I would write down the topic being tested, like "Algebra," or "Combinations," or "Arithmetic."

I know that this seems like a really tedious method, but believe me, it helped my preparation dramatically--why?

By using this grid with many problem sets, I was able to identify patterns and see where my strengthes and weaknesses were. For example, perhaps I would notice that I consistently get every Algebra problem correct--this would indicate that I wouldn't need to devote much prep time to studying Algebra because my skills there were solid. On the other hand, I may realize that I got a lot of errors with permutation problems. I see that I mark off "Concept error" here consistently, so I know that I should devote more time to studying and practicing permutations. Just as one more example, perhaps I notice that I get a lot of errors with arithmetic problems, but most of these errors are careless. I would know that I need to slow down more when I do these problems because I'm likely doing them too fast, which tends to promote carelessness.

With regard to marking off time every ten questions, this is helpful to do because you can strategize your time more efficiently for the real test. Maybe you notice that you take a lot of time with RC questions, but breeze through SC questions. Knowing this will help you figure out how to allot your time when you are attacking the verbal section on the GMAT.

Just to reiterate, the grid is a tactical method for practicing/studying for the GMAT. I used it a lot to identify where I could improve. Also, I liked to save my grids so that I could go back and review my errors over and over again.

Here's one last handy tip: when you are reviewing your errors, don't look immediately at the explanations in the answer key. Try to solve the question again to see if you can get the right answer yourself before looking at the explanation. You will learn more solving something yourself than being told how to solve it.

This grid was one of my secrets to scoring well on the GMAT. So now you know!

Best Conversation Starters

1 lheiannie07 116 topics
2 ardz24 64 topics
3 swerve 63 topics
4 LUANDATO 62 topics
5 M7MBA 57 topics
See More Top Beat The GMAT Members...

Most Active Experts

1 image description Brent@GMATPrepNow

GMAT Prep Now Teacher

170 posts
2 image description EconomistGMATTutor

The Economist GMAT Tutor

129 posts
3 image description Rich.C@EMPOWERgma...


122 posts
4 image description GMATGuruNY

The Princeton Review Teacher

121 posts
5 image description Scott@TargetTestPrep

Target Test Prep

118 posts
See More Top Beat The GMAT Experts