|
Author |
Message |
|
TAGS:
|
|
|
Retired Moderator
Status: The last round
Joined: 18 Jun 2009
Posts: 1295
Kudos [?]:
1173
[33]
, given: 157
Concentration: Strategy, General Management
|
GMAT Prep Analysis Tool [#permalink]
Show Tags
 14 Oct 2010, 05:10
33
This post received
KUDOS
18
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 6301. 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.   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.  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.   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.
_________________
[ 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
GMAT Club Premium Membership - big benefits and savings
|
Kudos [?]:
1173
[33]
, given: 157
|
|
|
|
Retired Moderator
Status: I wish!
Joined: 21 May 2010
Posts: 784
Kudos [?]:
465
[0], given: 33
|
Re: GMAT Prep Analysis Tool [#permalink]
Show Tags
14 Oct 2010, 05: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
_________________
http://drambedkarbooks.com/
|
Kudos [?]:
465
[0], given: 33
|
|
|
|
Intern
Status: Applying
Joined: 14 Oct 2009
Posts: 30
Kudos [?]:
78
[0], given: 4
Location: California
Schools: Cornell AMBA, Kellogg, Oxford, Cambridge
|
Re: GMAT Prep Analysis Tool [#permalink]
Show Tags
14 Oct 2010, 15:56
Wonderful. Thank you. +1
|
Kudos [?]:
78
[0], given: 4
|
|
|
|
CEO
Status: Nothing comes easy: neither do I want.
Joined: 12 Oct 2009
Posts: 2771
Kudos [?]:
1815
[0], given: 235
Location: Malaysia
Concentration: Technology, Entrepreneurship
GMAT 1: 670 Q49 V31 GMAT 2: 710 Q50 V35
|
Re: GMAT Prep Analysis Tool [#permalink]
Show Tags
14 Oct 2010, 16:24
With 10 mistakes in verbal I got v34  - I had 4 mistakes in first 10 questions. => its very important to nail the first RC.  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
 Support GMAT Club by putting a GMAT Club badge on your blog/Facebook
GMAT Club Premium Membership - big benefits and savings
Gmat test review :
http://gmatclub.com/forum/670-to-710-a-long-journey-without-destination-still-happy-141642.html
|
Kudos [?]:
1815
[0], given: 235
|
|
|
|
Retired Moderator
Status: The last round
Joined: 18 Jun 2009
Posts: 1295
Kudos [?]:
1173
[0], given: 157
Concentration: Strategy, General Management
|
Re: GMAT Prep Analysis Tool [#permalink]
Show Tags
14 Oct 2010, 21: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
GMAT Club Premium Membership - big benefits and savings
|
Kudos [?]:
1173
[0], given: 157
|
|
|
|
Manager
Joined: 20 Apr 2010
Posts: 209
Kudos [?]:
89
[0], given: 28
Schools: ISB, HEC, Said
|
Re: GMAT Prep Analysis Tool [#permalink]
Show Tags
15 Oct 2010, 00:05
Great Work Hussain +1 to you.
I will be writing GMAT prep surely will post the analysis
|
Kudos [?]:
89
[0], given: 28
|
|
|
|
Manager
Joined: 20 Apr 2010
Posts: 209
Kudos [?]:
89
[1]
, given: 28
Schools: ISB, HEC, Said
|
Re: GMAT Prep Analysis Tool [#permalink]
Show Tags
15 Oct 2010, 00:07
1
This post received
KUDOS
I am not able to save the XLS that you have attached. Please check
|
Kudos [?]:
89
[1]
, given: 28
|
|
|
|
Retired Moderator
Status: The last round
Joined: 18 Jun 2009
Posts: 1295
Kudos [?]:
1173
[0], given: 157
Concentration: Strategy, General Management
|
Re: GMAT Prep Analysis Tool [#permalink]
Show Tags
15 Oct 2010, 00: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
GMAT Club Premium Membership - big benefits and savings
|
Kudos [?]:
1173
[0], given: 157
|
|
|
|
Manager
Joined: 20 Apr 2010
Posts: 209
Kudos [?]:
89
[0], given: 28
Schools: ISB, HEC, Said
|
Re: GMAT Prep Analysis Tool [#permalink]
Show Tags
15 Oct 2010, 00:18
Thanks Hussain it is working now
|
Kudos [?]:
89
[0], given: 28
|
|
|
|
Manager
Joined: 04 Jun 2010
Posts: 110
Kudos [?]:
292
[0], given: 43
Concentration: General Management, Technology
Schools: Chicago (Booth) - Class of 2013
GMAT 1: 670 Q47 V35 GMAT 2: 730 Q49 V41
|
Re: GMAT Prep Analysis Tool [#permalink]
Show Tags
15 Oct 2010, 00: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
|
Kudos [?]:
292
[0], given: 43
|
|
|
|
Senior Manager
Joined: 18 Feb 2008
Posts: 497
Kudos [?]:
122
[0], given: 66
Location: Kolkata
|
Re: GMAT Prep Analysis Tool [#permalink]
Show Tags
15 Oct 2010, 01:03
Great work Hussain bhai....will update as i give my gprep soon and would request others to share their exp....
|
Kudos [?]:
122
[0], given: 66
|
|
|
|
Intern
Joined: 12 Oct 2010
Posts: 9
Kudos [?]:
0
[0], given: 11
|
Re: GMAT Prep Analysis Tool [#permalink]
Show Tags
15 Oct 2010, 04: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 .
|
Kudos [?]:
0
[0], given: 11
|
|
|
|
Retired Moderator
Status: The last round
Joined: 18 Jun 2009
Posts: 1295
Kudos [?]:
1173
[0], given: 157
Concentration: Strategy, General Management
|
Re: GMAT Prep Analysis Tool [#permalink]
Show Tags
15 Oct 2010, 20: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
GMAT Club Premium Membership - big benefits and savings
|
Kudos [?]:
1173
[0], given: 157
|
|
|
|
Founder
Joined: 04 Dec 2002
Posts: 15368
Kudos [?]:
27179
[1]
, given: 5001
Location: United States (WA)
|
Re: GMAT Prep Analysis Tool [#permalink]
Show Tags
15 Oct 2010, 21:07
Kudos for this beautiful and very useful post!
_________________
Founder of GMAT Club
GMAT Club's Special offer for Student Loans only through Aug 31 - New!
Just starting out with GMAT? Start here... or use our Daily Study Plan
Co-author of the GMAT Club tests
|
Kudos [?]:
27179
[1]
, given: 5001
|
|
|
|
Director
Status: Impossible is not a fact. It's an opinion. It's a dare. Impossible is nothing.
Affiliations: University of Chicago Booth School of Business
Joined: 26 Nov 2009
Posts: 961
Kudos [?]:
860
[0], given: 36
Location: Singapore
Concentration: General Management, Finance
Schools: Chicago Booth - Class of 2015
|
Re: GMAT Prep Analysis Tool [#permalink]
Show Tags
15 Oct 2010, 22:51
Am I correct? 1. Verbal depletes the score faster than the Quant. 2. more than 10 mistakes in Verbal. Astalavista Baby!. Do the gmat again ! Ohh what a CAT 3. Initial 15 questions matter the most in both sections. 4. Final 7 questions matter the least in both sections.
|
Kudos [?]:
860
[0], given: 36
|
|
|
|
Retired Moderator
Status: The last round
Joined: 18 Jun 2009
Posts: 1295
Kudos [?]:
1173
[0], given: 157
Concentration: Strategy, General Management
|
Re: GMAT Prep Analysis Tool [#permalink]
Show Tags
16 Oct 2010, 01:33
My input shown below in colors. nusmavrik wrote: Am I correct? 1. Verbal depletes the score faster than the Quant. Correct2. more than 10 mistakes in Verbal. Astalavista Baby!. Do the gmat again ! Ohh what a CAT Absolutely Correct 3. Initial 15 questions matter the most in both sections. Correct4. Final 7 questions matter the least in both sections. Here I disagree a bit. Final 7 questions does matter but not too mcuh. But one cant ignore the importance. We should always try to give equal attention to the last 5-10 questions. _________________
[ 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
GMAT Club Premium Membership - big benefits and savings
|
Kudos [?]:
1173
[0], given: 157
|
|
|
|
Director
Status: Impossible is not a fact. It's an opinion. It's a dare. Impossible is nothing.
Affiliations: University of Chicago Booth School of Business
Joined: 26 Nov 2009
Posts: 961
Kudos [?]:
860
[0], given: 36
Location: Singapore
Concentration: General Management, Finance
Schools: Chicago Booth - Class of 2015
|
Re: GMAT Prep Analysis Tool [#permalink]
Show Tags
16 Oct 2010, 04:38
Thanks Hussain15 ! It makes a lot of sense. And awesome work on the excel.
|
Kudos [?]:
860
[0], given: 36
|
|
|
|
Intern
Joined: 19 Dec 2009
Posts: 41
Kudos [?]:
76
[0], given: 52
|
Re: GMAT Prep Analysis Tool [#permalink]
Show Tags
16 Oct 2010, 08:04
+1 Kudos, helpful.
|
Kudos [?]:
76
[0], given: 52
|
|
|
|
Ms. Big Fat Panda
Status: Three Down.
Joined: 09 Jun 2010
Posts: 1917
Kudos [?]:
2144
[0], given: 210
Concentration: General Management, Nonprofit
|
Re: GMAT Prep Analysis Tool [#permalink]
Show Tags
16 Oct 2010, 09:53
Excellent analysis! Good job! +1
|
Kudos [?]:
2144
[0], given: 210
|
|
|
|
Senior Manager
Status: Not afraid of failures, disappointments, and falls.
Joined: 20 Jan 2010
Posts: 292
Kudos [?]:
250
[0], given: 260
Concentration: Technology, Entrepreneurship
WE: Operations (Telecommunications)
|
Re: GMAT Prep Analysis Tool [#permalink]
Show Tags
17 Oct 2010, 02:43
Kudos! Nice tool, thanks for sharing and definitely gonna use it when time comes for practicing CATs.
_________________
"I choose to rise after every fall"
Target=770
http://challengemba.blogspot.com
Kudos??
|
Kudos [?]:
250
[0], given: 260
|
|
|
|
|
Re: GMAT Prep Analysis Tool
[#permalink]
17 Oct 2010, 02:43
|
|
|
|
|
Go to page
1 2 3
Next
[ 52 posts ]
|
|
|
|
|
|
|
|
8
