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

It is currently 23 Jul 2016, 14:56
GMAT Club Tests

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

[HOW TO] GMATPrep 2012: obtain exam logs, timing, AWA essay.

  new topic post reply Question banks Downloads My Bookmarks Reviews Important topics  
Author Message
7 KUDOS received
Intern
Intern
avatar
Joined: 06 Aug 2012
Posts: 19
Concentration: General Management, Healthcare
GMAT 1: 720 Q49 V39
GPA: 4
Followers: 2

Kudos [?]: 21 [7] , given: 6

[HOW TO] GMATPrep 2012: obtain exam logs, timing, AWA essay. [#permalink]

Show Tags

New post 08 Nov 2012, 18:24
7
This post received
KUDOS
12
This post was
BOOKMARKED
Hi all,

Many of us have been seeking to obtain exam logs once you exit the test on the new GMAT Prep software (2.1.279) which is based on Adobe Air. The software does NOT let you see the info once you exit the test review screen. Here's how to get the question numbers, your answer choices, timing per question etc. Importantly, this is the only way (to my knowledge) of recovering the text of your AWA essay which you wrote during each practice test.

GMATPrep 2012 saves a file called ‘preptool.vb’ in the following (hidden) directory:
C:\Users\[replace this with your name]\AppData\Roaming\GMATPrep\Local Store\

This ‘preptool.vb’ file is the log and can be opened using a SQL viewer/editor. I used 'SQLite Database Browser 2.0' (google it - no URLs allowed, yet!)
1. Open the file with SQLite browser.
2. Click on the 'browse data' tab then select the 'table' of interest. The exam log is saved under 'used_items'.
3. Export the data (File>Export>table as CSV file). You can also browse the data without exporting.
4. Open the CSV file with Excel and you have everything you need. Answer choices and timing for each question.

Sections are numbered as: 1. AWA, 2. Quantitative, 3. Verbal, 4. IR. Peculiarly, questions are numbered from '0' not '1'. Quant questions numbers are prefixed with '187:', verbal with '188:' and IR with '211:'. Time is displayed in seconds.

Finally, the log contains the data from both tests. I haven't tried ‘re-setting’ the tests to see if the program keeps adding data to the same 'preptool.vb' file so you should copy this file to another location before re-setting (just in case it does delete your first two attempts).

There are other potentially useful data in the other tables but I haven't got round to exploring them yet.

Enjoy! I hope this helps :-)

PS. the (hidden) question pool is listed in C:\Program Files (x86)\GMATPrep2012\pack0\pack0.db
PPS. there is a (hidden) file, intriguingly called 'scoring.db', in C:\Program Files (x86)\GMATPrep2012\
Intern
Intern
avatar
Joined: 06 Aug 2012
Posts: 19
Concentration: General Management, Healthcare
GMAT 1: 720 Q49 V39
GPA: 4
Followers: 2

Kudos [?]: 21 [0], given: 6

Re: [HOW TO] GMATPrep 2012: obtain exam logs, timing, AWA essay. [#permalink]

Show Tags

New post 08 Nov 2012, 18:33
As a reminder, the available versions of the 'official' GMAT software are:

1. PowerPrep - oldest (quite out of date?)
2. GMATPrep v1.
3. GMATPrep v2.
4. GMATPrep 2012 (with IR; current version: 2.1.279).

By the way, the questions in GMATPrep v2 and GMATPrep 2012 are identical as far I can see. There is already a guide on how to obtain logs from the older version(s) but nothing on the new, Adobe Air-based version as far as I can find.
Expert Post
Founder
Founder
User avatar
Affiliations: AS - Gold, HH-Diamond
Joined: 04 Dec 2002
Posts: 13932
Location: United States (WA)
GMAT 1: 750 Q49 V42
GPA: 3.5
Followers: 3391

Kudos [?]: 19959 [0], given: 4313

GMAT ToolKit User Premium Member CAT Tests
Re: [HOW TO] GMATPrep 2012: obtain exam logs, timing, AWA essay. [#permalink]

Show Tags

New post 08 Nov 2012, 18:57
Expert's post
Thank you. Very interesting and helpful!
I will add it to my GMAT Prep thread - gmat-prep-power-prep-official-free-gmat-tests-77548.html
_________________

Founder of GMAT Club

US News 2008 - 2017 Rankings progression - New!
Just starting out with GMAT? Start here...
Need GMAT Book Recommendations? Best GMAT Books

Co-author of the GMAT Club tests

GMAT Club Premium Membership - big benefits and savings

Expert Post
MBA Section Director
User avatar
Joined: 19 Mar 2012
Posts: 3335
Location: India
GPA: 3.8
WE: Marketing (Energy and Utilities)
Followers: 1327

Kudos [?]: 9813 [0], given: 1846

Re: [HOW TO] GMATPrep 2012: obtain exam logs, timing, AWA essay. [#permalink]

Show Tags

New post 09 Nov 2012, 11:14
Expert's post
Intern
Intern
avatar
Joined: 06 Aug 2012
Posts: 19
Concentration: General Management, Healthcare
GMAT 1: 720 Q49 V39
GPA: 4
Followers: 2

Kudos [?]: 21 [0], given: 6

Re: [HOW TO] GMATPrep 2012: obtain exam logs, timing, AWA essay. [#permalink]

Show Tags

New post 09 Nov 2012, 11:28
@bb
Thanks for all you've done here - I have benefited immensely from your contributions - this is my little 'thank you' to the community.

@souvik101990
I haven't managed to open the question pool database, yet. I only managed to discover to unwrap the software one day before my real GMAT (which was yesterday!). We'll get there soon I'm sure :wink:
However, the questions in this version (2012) seem identical to those in GMATPrep v2. I think someone already retrieved/compiled those questions (or was this GMATPrep v1?).
Intern
Intern
avatar
Joined: 22 May 2012
Posts: 14
Concentration: Leadership, Other
GMAT 1: 660 Q49 V31
WE: Engineering (Computer Software)
Followers: 0

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

Re: [HOW TO] GMATPrep 2012: obtain exam logs, timing, AWA essay. [#permalink]

Show Tags

New post 30 Dec 2012, 11:06
Very insightful. Thank you. Kudos awarded :)
Intern
Intern
avatar
Joined: 21 Jan 2013
Posts: 40
Concentration: General Management, Leadership
GPA: 3.82
WE: Engineering (Computer Software)
Followers: 0

Kudos [?]: 2 [0], given: 65

GMAT ToolKit User
Re: [HOW TO] GMATPrep 2012: obtain exam logs, timing, AWA essay. [#permalink]

Show Tags

New post 22 May 2013, 06:42
this looks pretty useful. any idea how do i locate this file on mac?
_________________

--

Consider +1 Kudos if you find my post useful

Manager
Manager
avatar
Joined: 17 Mar 2014
Posts: 166
Location: United States
Concentration: Entrepreneurship, Leadership
GPA: 3.97
Followers: 5

Kudos [?]: 12 [0], given: 72

GMAT ToolKit User Reviews Badge
Re: [HOW TO] GMATPrep 2012: obtain exam logs, timing, AWA essay. [#permalink]

Show Tags

New post 12 Oct 2014, 05:55
How to locate log files on MAC? Did not see any posts for MAC.
_________________

KUDOS!!!, I need them too :)

Intern
Intern
avatar
Joined: 08 Jan 2015
Posts: 2
Followers: 0

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

Re: [HOW TO] GMATPrep 2012: obtain exam logs, timing, AWA essay. [#permalink]

Show Tags

New post 18 Jan 2015, 22:55
You can find the MAC files here: ~/Library/Preferences/GMATPrep/Local Store

To get to this directory, open a Finder, press Shift-CMD-G and copy and page the address above in the box. On MAC, the filename is preptool.db (not pretool.vb).
Intern
Intern
avatar
Joined: 01 Apr 2015
Posts: 3
Followers: 0

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

Re: [HOW TO] GMATPrep 2012: obtain exam logs, timing, AWA essay. [#permalink]

Show Tags

New post 28 Jun 2015, 03:02
In used items I foung only a couple of sentences from my essay. Are there any other tables I can look at?
Intern
Intern
avatar
Joined: 05 Dec 2014
Posts: 4
GMAT 1: 620 Q45 V31
Followers: 0

Kudos [?]: 1 [0], given: 16

Reviews Badge
Re: [HOW TO] GMATPrep 2012: obtain exam logs, timing, AWA essay. [#permalink]

Show Tags

New post 20 Mar 2016, 10:54
Any inputs.How to access it on MAC?



kkma2000 wrote:
Hi all,

Many of us have been seeking to obtain exam logs once you exit the test on the new GMAT Prep software (2.1.279) which is based on Adobe Air. The software does NOT let you see the info once you exit the test review screen. Here's how to get the question numbers, your answer choices, timing per question etc. Importantly, this is the only way (to my knowledge) of recovering the text of your AWA essay which you wrote during each practice test.

GMATPrep 2012 saves a file called ‘preptool.vb’ in the following (hidden) directory:
C:\Users\[replace this with your name]\AppData\Roaming\GMATPrep\Local Store\

This ‘preptool.vb’ file is the log and can be opened using a SQL viewer/editor. I used 'SQLite Database Browser 2.0' (google it - no URLs allowed, yet!)
1. Open the file with SQLite browser.
2. Click on the 'browse data' tab then select the 'table' of interest. The exam log is saved under 'used_items'.
3. Export the data (File>Export>table as CSV file). You can also browse the data without exporting.
4. Open the CSV file with Excel and you have everything you need. Answer choices and timing for each question.

Sections are numbered as: 1. AWA, 2. Quantitative, 3. Verbal, 4. IR. Peculiarly, questions are numbered from '0' not '1'. Quant questions numbers are prefixed with '187:', verbal with '188:' and IR with '211:'. Time is displayed in seconds.

Finally, the log contains the data from both tests. I haven't tried ‘re-setting’ the tests to see if the program keeps adding data to the same 'preptool.vb' file so you should copy this file to another location before re-setting (just in case it does delete your first two attempts).

There are other potentially useful data in the other tables but I haven't got round to exploring them yet.

Enjoy! I hope this helps :-)

PS. the (hidden) question pool is listed in C:\Program Files (x86)\GMATPrep2012\pack0\pack0.db
PPS. there is a (hidden) file, intriguingly called 'scoring.db', in C:\Program Files (x86)\GMATPrep2012\
Intern
Intern
avatar
Joined: 20 Jan 2016
Posts: 12
Followers: 0

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

CAT Tests
Re: [HOW TO] GMATPrep 2012: obtain exam logs, timing, AWA essay. [#permalink]

Show Tags

New post 07 May 2016, 14:35
BalajiVarma wrote:
Any inputs.How to access it on MAC?



kkma2000 wrote:
Hi all,

Many of us have been seeking to obtain exam logs once you exit the test on the new GMAT Prep software (2.1.279) which is based on Adobe Air. The software does NOT let you see the info once you exit the test review screen. Here's how to get the question numbers, your answer choices, timing per question etc. Importantly, this is the only way (to my knowledge) of recovering the text of your AWA essay which you wrote during each practice test.

GMATPrep 2012 saves a file called ‘preptool.vb’ in the following (hidden) directory:
C:\Users\[replace this with your name]\AppData\Roaming\GMATPrep\Local Store\

This ‘preptool.vb’ file is the log and can be opened using a SQL viewer/editor. I used 'SQLite Database Browser 2.0' (google it - no URLs allowed, yet!)
1. Open the file with SQLite browser.
2. Click on the 'browse data' tab then select the 'table' of interest. The exam log is saved under 'used_items'.
3. Export the data (File>Export>table as CSV file). You can also browse the data without exporting.
4. Open the CSV file with Excel and you have everything you need. Answer choices and timing for each question.

Sections are numbered as: 1. AWA, 2. Quantitative, 3. Verbal, 4. IR. Peculiarly, questions are numbered from '0' not '1'. Quant questions numbers are prefixed with '187:', verbal with '188:' and IR with '211:'. Time is displayed in seconds.

Finally, the log contains the data from both tests. I haven't tried ‘re-setting’ the tests to see if the program keeps adding data to the same 'preptool.vb' file so you should copy this file to another location before re-setting (just in case it does delete your first two attempts).

There are other potentially useful data in the other tables but I haven't got round to exploring them yet.

Enjoy! I hope this helps :-)

PS. the (hidden) question pool is listed in C:\Program Files (x86)\GMATPrep2012\pack0\pack0.db
PPS. there is a (hidden) file, intriguingly called 'scoring.db', in C:\Program Files (x86)\GMATPrep2012\



Here is a guide to getting all the times from the GMATprep software.
1. Download "sqlitebrowser" or an equivalent software for navigating databases. Install the program
2. Navigate to the folder that contains database by:
a) opening Finder
b) clicking on Go, and then "Go to Folder..."
c) type in "~/Library/Preferences/GMATPrep"
3. Click on the "Local Store" folder and select "Make Alias" (we need to do this step because the database browsing app, mentioned in step 1, won't allow you to enter an address)
4. Drag this alias to your desktop
5. Open sqlitebrowser and click on "Open Database" (second button from the left)
6. Navigate to your desktop and click double click on the Alias folder you just created and navigate to the "Local Store" folder (if you followed the instructions above correctly you should be here already). Now select "preptool.db" and click open.
7. Now select "Used_Items" in the window on the right (scroll down, I'm not 100% sure if this step is necessary). From the menu bar, click on "File", then "Exports", and then "Table(s) as CSV file" (see attached screenshot).
8. Open the file with excel
9. take some time to understand what it and you're all set!

Extra notes:
1. its easy to find your sessions because they are all numbered
2. Question numbering starts from 0 (i.e. question 3 will be number 2 in the CSV file)
3. All times are in seconds, you can easily convert it to minutes and seconds (google search it)
4. I like using conditional formatting for the times. So that you can see the where you went wrong.
Attachments

Screen Shot 2016-05-07 at 5.33.15 PM.png
Screen Shot 2016-05-07 at 5.33.15 PM.png [ 870.12 KiB | Viewed 532 times ]

Intern
Intern
avatar
Joined: 14 Dec 2015
Posts: 7
Followers: 0

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

Re: [HOW TO] GMATPrep 2012: obtain exam logs, timing, AWA essay. [#permalink]

Show Tags

New post 16 Jul 2016, 00:44
very useful, thank you!
Re: [HOW TO] GMATPrep 2012: obtain exam logs, timing, AWA essay.   [#permalink] 16 Jul 2016, 00:44
    Similar topics Author Replies Last post
Similar
Topics:
Experts publish their posts in the topic How to review GMATPrep exam? flower07 2 28 Jan 2014, 14:15
Experts publish their posts in the topic GMATPREP exam : how to review TGC 2 29 Sep 2013, 10:04
Experts publish their posts in the topic How much time between the AWA essays? bb 2 26 Jan 2012, 08:43
GMATPrep -- AWA Essays R2I4D 0 20 May 2010, 15:04
GMATPrep Exam - Not enough time I3igDmsu 5 31 May 2009, 09:10
Display posts from previous: Sort by

[HOW TO] GMATPrep 2012: obtain exam logs, timing, AWA essay.

  new topic post reply Question banks Downloads My Bookmarks Reviews Important topics  

Moderators: bagdbmba, WaterFlowsUp



GMAT Club MBA Forum Home| About| 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®.