Find all School-related info fast with the new School-Specific MBA Forum

It is currently 19 Sep 2014, 01:59

Close

GMAT Club Daily Prep

Thank you for using the timer - this advanced tool can estimate your performance and suggest more practice questions. We have subscribed you to Daily Prep Questions via email.

Customized
for You

we will pick new questions that match your level based on your Timer History

Track
Your Progress

every week, we’ll send you an estimated GMAT score based on your performance

Practice
Pays

we will pick new questions that match your level based on your Timer History

Not interested in getting valuable practice questions and articles delivered to your email? No problem, unsubscribe here.

Events & Promotions

Events & Promotions in June
Open Detailed Calendar

GMAT Prep Analysis Tool

  Question banks Downloads My Bookmarks Reviews Important topics  
Author Message
32 KUDOS received
Retired Moderator
User avatar
Status: The last round
Joined: 18 Jun 2009
Posts: 1318
Concentration: Strategy, General Management
GMAT 1: 680 Q48 V34
Followers: 56

Kudos [?]: 484 [32] , given: 157

GMAT ToolKit User GMAT Tests User
GMAT Prep Analysis Tool [#permalink] New post 14 Oct 2010, 04:10
32
This post received
KUDOS
8
This post was
BOOKMARKED
Hi members, it was the end of June when I was shocked with my very first gmat prep experience. I got a 590 in that test & that very result made me realize that I had to work hard & plan more. It was that time when I decided to take leave from workplace & give some real time to the beast. After 15 days of study, I gave another shot to gmat prep & was shocked again to have a score of 710. Though I knew that 710 was partially because of my luck, I wanted to know the critical factor that made my score jumped up. I had gone through the bsd_lover’s gmat prep analysis but wanted to have a little analysis of my own. So I decided to enter my gmat prep results data in an excel file, so that I may review the details later (No wonder being a finance guy, I love Excel). It took hardly 15 minutes to enter the data in the input sheet & then I analyzed the patterns of question recurrence, mistakes sequence & % of each question type. I did the same analysis for three of my gmat prep tests & gained some very useful insight. I planned to share that stuff at the forum but couldn’t do so mainly because of the fact that I used a very rough data file, which in no way was suitable to share. I have worked on that analysis tool of mine now so that it may get the required form to be shared. So attached is that tool. I hope the said tool will help you guys in knowing the gmat question patterns & the importance of first 10-13 questions.

My Findings


1.GMAT Prep Score 630

1. I got a fantastic Q score of 50 but a poor verbal score of 25 spoiled my overall score.
2. The Q score of 50 with 7 mistakes made me realized that the Q section of the gmat test has a soft corner. :)
3. Also, the first 10 Q questions had no mistake; hence this was also a big reason for high Q score.
4. Having consistent mistakes in verbal section was the sole reason of low verbal score. It also made me clear that one can’t afford to have as many mistakes in verbal as one can in Q section.
5. I also got the pattern and count of each question type as shown in the charts below.

Image

Image


2.GMAT Prep Score 710

1. A high jump in verbal score was only because of the fact that I got the first 14 verbal questions correct. In comparison to my 630 performance I only made 5 less mistakes but got a 15 point improvement in my verbal score.
2. The quantitative drop to 47 was mainly because of consistent mistakes. The interesting point is that my 15 mistakes got me a Q score of 47 while the 15 mistakes in verbal section during my 630 experience got me a score of V25. :shock:
3. Total # of each question type was surprisingly the same as was in 630 experience.
4. The question recurrence patterns were different in comparison to the ones I saw in the case of 630.

Image

Image


How to use the tool

1. Download the attached excel sheet.
2. After taking the gmat prep & seeing the score on your screen, just note down that socre in your analysis tool or somewhere else. Don’t skip the score report screen, as when you click the “Next” button, the score report will never be available again.
3. You need to fill in the “Data Input “sheet only, the other two sheets will be updated accordingly. This will hardly take 10-15 minutes.
4. Fill in the "answer" & "question type" columns in Q & V sections along with the raw score cells of Q & V.
5. You can then go through the two analysis sheets to find the details.


Imp Note:


1. I totally agree that gmat is a CAT and the number of right & wrong answers doesn’t make much difference but still there are some points that one need to remember & the biggest of which is the importance of first 10-12 questions.
2. I am using some soft & standard chart colors of gmat club here in this post. The attached excel file has the regular chart graphics.


Edit: Version-2 of the tool added with a new analysis sheet showing the count of correct/incorrect answers of each question type.

Attachments

GMAT Prep Analysis Tool-V-2.xlsx [36.3 KiB]
Downloaded 968 times

To download please login or register as a user

GMAT Prep Analysis Tool-V-1.xlsx [27.25 KiB]
Downloaded 392 times

To download please login or register as a user


_________________

[ From 470 to 680-My Story ] [ My Last Month Before Test ]
[ GMAT Prep Analysis Tool ] [ US. Business School Dashboard ] [ Int. Business School Dashboard ]

I Can, I Will

Get the best GMAT Prep Resources with GMAT Club Premium Membership

Kaplan Promo CodeKnewton GMAT Discount CodesVeritas Prep GMAT Discount Codes
2 KUDOS received
BSchool Thread Master
avatar
Joined: 19 Feb 2010
Posts: 401
Followers: 20

Kudos [?]: 122 [2] , given: 76

GMAT Tests User
Re: GMAT Prep Analysis Tool [#permalink] New post 19 Oct 2010, 22:47
2
This post received
KUDOS
Nice work Hussain! +1

I'm uploading screen shots of my analysis for everyone to see. I took GMATPrep back on Feb 09. You can see how I bombed the Quant with so many mistakes in the first 13 questions. I also think I had more than usual DS questions. And 3 of the 4 RC had only 3 questions. I personally prefer to have more questions for each passage, to make up the reading time.

Hussain, there is a small mistake in the Verbal chart in the Analysis1 page, the range of last questions is 31-41 instead of 31-37.

A small suggestion: it would be great to see in the chart how many DS or PS were wrong, and how many SC, CR and RC were wrong. I also include this questions in my error log, but just in case if anyone wants to quickly see which type of questions had more trouble with during the test.
Attachments

Analysis2.jpg
Analysis2.jpg [ 61.43 KiB | Viewed 7222 times ]

Analysis1.jpg
Analysis1.jpg [ 60.21 KiB | Viewed 7222 times ]

2 KUDOS received
Retired Moderator
User avatar
Status: The last round
Joined: 18 Jun 2009
Posts: 1318
Concentration: Strategy, General Management
GMAT 1: 680 Q48 V34
Followers: 56

Kudos [?]: 484 [2] , given: 157

GMAT ToolKit User GMAT Tests User
Re: GMAT Prep Analysis Tool [#permalink] New post 20 Jan 2011, 09:21
2
This post received
KUDOS
1 KUDOS received
Manager
Manager
avatar
Joined: 19 Apr 2010
Posts: 216
Schools: ISB, HEC, Said
Followers: 4

Kudos [?]: 18 [1] , given: 28

GMAT Tests User
Re: GMAT Prep Analysis Tool [#permalink] New post 14 Oct 2010, 23:07
1
This post received
KUDOS
I am not able to save the XLS that you have attached. Please check
Expert Post
1 KUDOS received
Founder
Founder
User avatar
Affiliations: UA-1K, SPG-G, HH-D
Joined: 04 Dec 2002
Posts: 12191
Location: United States (WA)
GMAT 1: 750 Q49 V42
GPA: 3.5
WE: Information Technology (Hospitality and Tourism)
Followers: 2279

Kudos [?]: 8819 [1] , given: 3667

GMAT ToolKit User Premium Member CAT Tests
Re: GMAT Prep Analysis Tool [#permalink] New post 15 Oct 2010, 20:07
1
This post received
KUDOS
Expert's post
Kudos for this beautiful and very useful post!
_________________

Founder of GMAT Club

Just starting out with GMAT? Start here... | Want to know your GMAT Score? Try GMAT Score Estimator
Need GMAT Book Recommendations? Best GMAT Books

Co-author of the GMAT Club tests

Have a blog? Feature it on GMAT Club!

Get the best GMAT Prep Resources with GMAT Club Premium Membership

1 KUDOS received
Forum Moderator
Forum Moderator
User avatar
Status: doing good things...
Joined: 02 Jul 2009
Posts: 1235
Concentration: Entrepreneurship, Finance
GMAT 1: Q V
GMAT 2: 690 Q49 V35
GPA: 3.77
WE: Corporate Finance (Other)
Followers: 154

Kudos [?]: 510 [1] , given: 527

GMAT ToolKit User GMAT Tests User Premium Member Reviews Badge
Re: GMAT Prep Analysis Tool [#permalink] New post 18 Oct 2010, 20:57
1
This post received
KUDOS
I will do the same analysis and will post my results here.
_________________

Follow me, if you find my explanations useful.

Audaces fortuna juvat!

Get the best GMAT Prep Resources with GMAT Club Premium Membership

1 KUDOS received
Forum Moderator
Forum Moderator
User avatar
Status: doing good things...
Joined: 02 Jul 2009
Posts: 1235
Concentration: Entrepreneurship, Finance
GMAT 1: Q V
GMAT 2: 690 Q49 V35
GPA: 3.77
WE: Corporate Finance (Other)
Followers: 154

Kudos [?]: 510 [1] , given: 527

GMAT ToolKit User GMAT Tests User Premium Member Reviews Badge
Re: GMAT Prep Analysis Tool [#permalink] New post 19 Oct 2010, 22:59
1
This post received
KUDOS
Quote:
A small suggestion: it would be great to see in the chart how many DS or PS were wrong, and how many SC, CR and RC were wrong.


Good point cano, but i would suggest just to disclose this info just in writeen without graphs as it would be too much graph info.
_________________

Follow me, if you find my explanations useful.

Audaces fortuna juvat!

Get the best GMAT Prep Resources with GMAT Club Premium Membership

1 KUDOS received
Retired Moderator
User avatar
Status: The last round
Joined: 18 Jun 2009
Posts: 1318
Concentration: Strategy, General Management
GMAT 1: 680 Q48 V34
Followers: 56

Kudos [?]: 484 [1] , given: 157

GMAT ToolKit User GMAT Tests User
Re: GMAT Prep Analysis Tool [#permalink] New post 20 Oct 2010, 01:55
1
This post received
KUDOS
cano wrote:
Hussain, there is a small mistake in the Verbal chart in the Analysis1 page, the range of last questions is 31-41 instead of 31-37.

A small suggestion: it would be great to see in the chart how many DS or PS were wrong, and how many SC, CR and RC were wrong. I also include this questions in my error log, but just in case if anyone wants to quickly see which type of questions had more trouble with during the test.


Typo error fixed & a new analysis sheet is added showing the count of correct/incorrect answers of each question type.

Do let me know if it serves the purpose.
_________________

[ From 470 to 680-My Story ] [ My Last Month Before Test ]
[ GMAT Prep Analysis Tool ] [ US. Business School Dashboard ] [ Int. Business School Dashboard ]

I Can, I Will

Get the best GMAT Prep Resources with GMAT Club Premium Membership

1 KUDOS received
Manager
Manager
avatar
Joined: 19 Apr 2010
Posts: 216
Schools: ISB, HEC, Said
Followers: 4

Kudos [?]: 18 [1] , given: 28

GMAT Tests User
Re: GMAT Prep Analysis Tool [#permalink] New post 15 Nov 2010, 00:37
1
This post received
KUDOS
Here are my GMAT prep -1 Results I got Dismisal 550. With these result I totally baffled whether or not I will be get my target score of 700
Some of the key points

1. I got 5 wrong in first 11 question of Quant section. These mistakes in the begining are very costly. That to I got first two questions wrong.
2. I got last 2 questions wrong consequtive mistakes.
3. In total 11 mistakes. I have seen hussain posting Q47 with 15 mistakes or so. I am not sure still how got a low Q44 probably becoz of 5 mistakes in first 11
4. Lot of focus in quant goes to number properties.

Regarding verbal section this is alarm for me need to work hard on CR and SC.
Attachment:
1.JPG
1.JPG [ 55.74 KiB | Viewed 6931 times ]

Attachment:
2.JPG
2.JPG [ 57.88 KiB | Viewed 6930 times ]
Retired Moderator
User avatar
Status: I wish!
Joined: 21 May 2010
Posts: 788
Followers: 108

Kudos [?]: 225 [0], given: 33

GMAT Tests User
Re: GMAT Prep Analysis Tool [#permalink] New post 14 Oct 2010, 04:47
Hussian bhai remarkable job! I liked the excel sheet. It's amazing tool to analyse mistakes and will definitely use it.

Thank you bro! +1
_________________

RC videos rc-through-videos-99566.html
CR videos cr-through-videos-99033.html
SC videos sc-through-videos-98340.html
Quant videos quant-through-videos-102525.html

Get the best GMAT Prep Resources with GMAT Club Premium Membership

Intern
Intern
avatar
Status: Applying
Joined: 14 Oct 2009
Posts: 31
Location: California
Schools: Cornell AMBA, Kellogg, Oxford, Cambridge
Followers: 0

Kudos [?]: 14 [0], given: 4

GMAT Tests User
Re: GMAT Prep Analysis Tool [#permalink] New post 14 Oct 2010, 14:56
Wonderful. Thank you. +1
CEO
CEO
User avatar
Status: Nothing comes easy: neither do I want.
Joined: 12 Oct 2009
Posts: 2793
Location: Malaysia
Concentration: Technology, Entrepreneurship
Schools: ISB '15 (M)
GMAT 1: 670 Q49 V31
GMAT 2: 710 Q50 V35
Followers: 178

Kudos [?]: 948 [0], given: 235

GMAT Tests User Reviews Badge
Re: GMAT Prep Analysis Tool [#permalink] New post 14 Oct 2010, 15:24
With 10 mistakes in verbal I got v34 :-D - I had 4 mistakes in first 10 questions.
=> its very important to nail the first RC. :P

Its definitely worth to spend more time initially in Verbal.

Thanks Hussain.
_________________

Fight for your dreams :For all those who fear from Verbal- lets give it a fight

Money Saved is the Money Earned :)

Jo Bole So Nihaal , Sat Shri Akaal

:thanks Support GMAT Club by putting a GMAT Club badge on your blog/Facebook :thanks

Get the best GMAT Prep Resources with GMAT Club Premium Membership

Gmat test review :
670-to-710-a-long-journey-without-destination-still-happy-141642.html

Retired Moderator
User avatar
Status: The last round
Joined: 18 Jun 2009
Posts: 1318
Concentration: Strategy, General Management
GMAT 1: 680 Q48 V34
Followers: 56

Kudos [?]: 484 [0], given: 157

GMAT ToolKit User GMAT Tests User
Re: GMAT Prep Analysis Tool [#permalink] New post 14 Oct 2010, 20:04
Thanks for all the comments.

It will be great, if anyone taking the gmat prep can fill the results in input sheet & paste the snapshots of the analysis sheets on this thread. This will help all of us in having an overview of different score patterns.
_________________

[ From 470 to 680-My Story ] [ My Last Month Before Test ]
[ GMAT Prep Analysis Tool ] [ US. Business School Dashboard ] [ Int. Business School Dashboard ]

I Can, I Will

Get the best GMAT Prep Resources with GMAT Club Premium Membership

Manager
Manager
avatar
Joined: 19 Apr 2010
Posts: 216
Schools: ISB, HEC, Said
Followers: 4

Kudos [?]: 18 [0], given: 28

GMAT Tests User
Re: GMAT Prep Analysis Tool [#permalink] New post 14 Oct 2010, 23:05
Great Work Hussain +1 to you.
I will be writing GMAT prep surely will post the analysis
Retired Moderator
User avatar
Status: The last round
Joined: 18 Jun 2009
Posts: 1318
Concentration: Strategy, General Management
GMAT 1: 680 Q48 V34
Followers: 56

Kudos [?]: 484 [0], given: 157

GMAT ToolKit User GMAT Tests User
Re: GMAT Prep Analysis Tool [#permalink] New post 14 Oct 2010, 23:13
prashantbacchewar wrote:
I am not able to save the XLS that you have attached. Please check


Hi prashant, thanks for pointing the issue. Some bug was there. I have re-attached the file. Kindly do check now.
_________________

[ From 470 to 680-My Story ] [ My Last Month Before Test ]
[ GMAT Prep Analysis Tool ] [ US. Business School Dashboard ] [ Int. Business School Dashboard ]

I Can, I Will

Get the best GMAT Prep Resources with GMAT Club Premium Membership

Manager
Manager
avatar
Joined: 19 Apr 2010
Posts: 216
Schools: ISB, HEC, Said
Followers: 4

Kudos [?]: 18 [0], given: 28

GMAT Tests User
Re: GMAT Prep Analysis Tool [#permalink] New post 14 Oct 2010, 23:18
Thanks Hussain it is working now
Manager
Manager
avatar
Joined: 04 Jun 2010
Posts: 113
Concentration: General Management, Technology
Schools: Chicago (Booth) - Class of 2013
GMAT 1: 670 Q47 V35
GMAT 2: 730 Q49 V41
Followers: 11

Kudos [?]: 99 [0], given: 43

GMAT Tests User
Re: GMAT Prep Analysis Tool [#permalink] New post 14 Oct 2010, 23:55
Excellent work! Kudos!
_________________

Consider Kudos if my post helped you. Thanks!
--------------------------------------------------------------------
My TOEFL Debrief: http://gmatclub.com/forum/my-toefl-experience-99884.html
My GMAT Debrief: http://gmatclub.com/forum/670-730-10-luck-20-skill-15-concentrated-power-of-will-104473.html

Director
Director
avatar
Joined: 18 Feb 2008
Posts: 509
Location: Kolkata
Followers: 5

Kudos [?]: 59 [0], given: 66

GMAT Tests User
Re: GMAT Prep Analysis Tool [#permalink] New post 15 Oct 2010, 00:03
Great work Hussain bhai....will update as i give my gprep soon and would request others to share their exp....
Intern
Intern
avatar
Joined: 12 Oct 2010
Posts: 9
Followers: 0

Kudos [?]: 0 [0], given: 11

Re: GMAT Prep Analysis Tool [#permalink] New post 15 Oct 2010, 03:12
wow a jump from 590 to >700 is rockign . great work with the tool development. I will definitely use it . my test is on 3 rd of November .
Retired Moderator
User avatar
Status: The last round
Joined: 18 Jun 2009
Posts: 1318
Concentration: Strategy, General Management
GMAT 1: 680 Q48 V34
Followers: 56

Kudos [?]: 484 [0], given: 157

GMAT ToolKit User GMAT Tests User
Re: GMAT Prep Analysis Tool [#permalink] New post 15 Oct 2010, 19:36
radicaltp wrote:
wow a jump from 590 to >700 is rockign . great work with the tool development. I will definitely use it . my test is on 3 rd of November .


Do share your analysis with us.
_________________

[ From 470 to 680-My Story ] [ My Last Month Before Test ]
[ GMAT Prep Analysis Tool ] [ US. Business School Dashboard ] [ Int. Business School Dashboard ]

I Can, I Will

Get the best GMAT Prep Resources with GMAT Club Premium Membership

Re: GMAT Prep Analysis Tool   [#permalink] 15 Oct 2010, 19:36
    Similar topics Author Replies Last post
Similar
Topics:
6 Experts publish their posts in the topic Review of the Official GMAT Prep Tools and Packages souvik101990 1 13 Aug 2014, 13:08
1 Experts publish their posts in the topic GMAT PREP Tool Usage - Need Help nt2010 4 05 Apr 2013, 12:20
463 Experts publish their posts in the topic GMAT Prep Software Analysis and What If Scenarios Bunuel 164 21 Jan 2013, 08:18
43 Experts publish their posts in the topic GMAT Tools bb 23 31 Aug 2011, 20:00
1 Experts publish their posts in the topic Analysis of my GMAT prep progress GODSPEED 4 31 Aug 2009, 23:34
Display posts from previous: Sort by

GMAT Prep Analysis Tool

  Question banks Downloads My Bookmarks Reviews Important topics  

Go to page    1   2   3    Next  [ 52 posts ] 

Moderators: bagdbmba, WaterFlowsUp



GMAT Club MBA Forum Home| About| Privacy Policy| Terms and Conditions| GMAT Club Rules| Contact| Sitemap

Powered by phpBB © phpBB Group and phpBB SEO

Kindly note that the GMAT® test is a registered trademark of the Graduate Management Admission Council®, and this site has neither been reviewed nor endorsed by GMAC®.