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 [ 870.12 KiB | Viewed 11931 times ]