Standard SpreadSheet to track your Performance

[This topic has 3 member replies]
Free $100 Amazon.com Gift Card - Buy a GMAT course using a Beat The GMAT discount code between Mar 8-22 and get a $100 Amazon.com Gift Card. Learn more!
Post New Topic   Post Reply

manishhemnani
Just gettin' started!

Default Avatar

Joined: 15 Jun 2006
Posts: 10

Thanks given: 0
Thanked 0 times in 0 posts
Location: Mumbai, India

Topic: Standard SpreadSheet to track your Performance
PostThu Jun 15, 2006 11:50 am

Hi Guys, Very Happy

This is my first post on BeatTheGmat. Just got myself registered.

Hey Eric, i read your blog, 80 days of preparation. It was really helpful in drawing my strategy to Beat the Gmat (am sure i will) Twisted Evil

Coming back to the subject, to make life little easy, i have designed an Excel Sheet to track the performance as a whole (accuracy, speed, mistake, type of mistake etc.) at a shot.

You can keep record of your speed, confidence level, accuracy, and the type of mistake you made (if u made any). You can do your analysis and work on weaknesses. There is also an eliminator to help you answering by elimination method

I was answering 1000 SC (can be used for CR or any other type of questions) and thought of making this. The ideas are borrowed from various resources (suggestions by Eric Eric on his blog, and by Ursula mentioned on her blog)

Its fairly simple to use. Just read the comments on the column heads (you read comments by placing the pointer of the mouse on the respective cell and comment appears).You just have to fill in the data and you can see your success rate on the top left corner.

I have filled-in few entries to help you out a bit.

One important point to keep in mind, DO NOT WRITE IN THE 'ACCURACY' COLUMN, as it has a formula, which, on its own, checks if your answer was wrong ot right, and your accuracy rate is calculated on this.

So guys, use this as you performance tracker. If you find this ca be made better, let me know and i shall incoeporate the suggestions made by you.

Do let me know if it is helpful (for me, it certainly is)

Cheers....

Manish
Attachments
This post contains an attachment. You must be logged in to download/view this file. Please login or register as a user.

_________________
When the GOING gets TOUGH, the TOUGH gets GOING
Back to top
View user's profile Send private message
beatthegmat
Founder



Joined: 13 Feb 2006
Posts: 5172

Thanks given: 63
Thanked 407 times in 218 posts
Location: California

GMAT Score: 720

PostFri Jun 16, 2006 5:45 pm

Hi Manish:

Welcome to the Beat The GMAT! Forum. Thanks very much for sharing your incredible spreadsheet with the community! I sure would have liked to have something like this when I was preparing for the GMAT.

Thanks again and all the best!

_________________
Eric
Founder of Beat The GMAT

http://www.facebook.com/beatthegmat
http://www.twitter.com/beatthegmat
http://www.twitter.com/ericbahn
Back to top
View user's profile Send private message Visit poster's website
wildrebel
Moderator

Default Avatar

Joined: 27 Jun 2006
Posts: 40

Thanks given: 0
Thanked 0 times in 0 posts

PostTue Jun 27, 2006 3:46 am

Hey Manish,

Brilliant work! Wanted to make something like this myself, but you just made it perfectly!

I modified it a bit so that people (like me) with lower resolution monitors don't get lost scrolling. I split the panes and refroze them so that the Date, Question Number and Horizontal Headings stay static.

Thanks again! Will help me a lot!

Nonedone

_________________
"Outside of a dog, a book is a man's best friend. Inside of a dog, it's too dark to read."
- Groucho Marx
Back to top
View user's profile Send private message
gmatjandro
Just gettin' started!

Default Avatar

Joined: 12 Jul 2007
Posts: 3

Thanks given: 0
Thanked 0 times in 0 posts

PostSat Jul 14, 2007 9:19 pm

Hi All,

I am new to this forum. Last week I downloaded the grid and modified to practice questions from OG 11. OG 11 has 800 questions, 240 PS , 160 DS, 130 RS, 130 CR, 130 SC.
I am doing 15+10+12+10+10 from each.
It will give me 56 question to do in 100 mins. In the end it will provide me %age score for each section and commulative score also.

Each section have different color code in accordance of difficulty level for me. SC is most difficult for me so i put it in pinkish red color. same apply for other section.

When you score the questions put 1 in the correct column and put formula 1-correct in the wrong column. Wrong column will turn red so when you come back to this sheet later you can quickly see which questions you answered wrong. Also put the first question number in the right column and all other will automatically updated.
If you have any questions or suggestions let me know.
Attachments
This post contains an attachment. You must be logged in to download/view this file. Please login or register as a user.
Back to top
View user's profile Send private message
Display posts from previous:   

Post New Topic   Post Reply All times are GMT - 7 Hours
Page 1 of 1
 
Most Active Members in Last 30 Days
1. harsh.champ 461 posts
2. shashank.ism 366 posts
3. thephoenix 323 posts
4. kstv 320 posts
5. gmatmachoman 261 posts
Most Active Experts in Last 30 Days
1. lunarpower
Manhattan GMAT Teacher
87 posts
2. Stuart Kovinsky
Kaplan GMAT Teacher
60 posts
3. Lisa Anderson
Stacy Blackman Consulting
54 posts
4. Testluv
Kaplan GMAT Teacher
49 posts
5. Bryant@VeritasPrep
Veritas Prep
41 posts