GMAT Error Log

Attaching an error log that I made on Google Spreadsheet. With me using different machines at different places (work, home etc.), I thought a Google Doc will help me keep track of all of it in one single place. So, here it is : https://bit.ly/ErrorLog

It's a Google Spreadsheet with View only permission. Please login with your Google accounts and select the option make a copy to have your own copy in Google Drive. The one that I am sharing is not editable.

Quick notes:

1. Use the "Quant Error Log" and "Verbal Error Log" sheets to enter quant and verbal error data. Since these are questions that you got wrong, your answer / OA doesn't make a lot of sense. However, if you think you should have it, feel free to add them.

2. Fields Topic, Difficulty, Reason for failure and Remarks are indexed. ie., if you want to add a new value to it other than what shows up in the combo box, add it in the appropriate column in the sheet "Master Table". I have indexed remarks because often we label questions with standard tags, such as stumped, too long, attempt retry etc. Having an indexed field for the same will make it handy for analytics / filters. For other remarks you can always use remarks 2.

3. Use the Quant insights and verbal insights sheets for quant and verbal dashboard. They show the following:

• Top reasons for failure
  
• Weak topics : Top topics on which you commit mistakes. Will help you understand where you must focus
  
• Errors over days : Plots errors made day wise. This may not be an accurate metric if you don't practice uniform number of problems over time, but might help.
  
• Errors by difficulty : Share of errors graded by question difficulty. May not be useful if you're adding questions from sources other than gmatclub here.
  
• Errors by problem type : Whether you must focus on SC/CR/RC/PS/DS.

4. There is an optional accuracy sheet that you could use. This will require the aggregate of number of problems that you solved each day in quant and verbal. Given this input, and the error data that we already have, the sheet will graph you your daily accuracy rate in Quant and Verbal. Ideally, this should be a positive slope line

You could go one level further and get question details by topic for correct answers as well. But then, I realized that once the task of entering data into error log becomes cumbersome, you stop using it. So, wanted to keep the data entry part as minimal as possible. Even the accuracy part is completely up to individual's preference. But personally, I feel happy realizing that I've solved this many problems today, at the end of the day so thought I might as well keep track of it.

Please try this and let me know your feedback, especially issues.

and yea, press kudos if you liked it! Thanks

Hi bb,

I remember that you've mentioned in one of the error log posts(can't find out which one despite several keywords on google and GMATClub!) that you used a simple word document for these errors, printed a stack and revised this. I find it better to do so rather than using a digital version. Can you please share how you structured your doc error logs with us? It may benefit those who don't fancy using an excel and would rather refer to a bundle of notes.

Many thanks for this!

bb,

I remember that you've mentioned in one of the error log posts(can't find out which one despite several keywords on google and GMATClub!) that you used a simple word document for these errors, printed a stack and revised this. I find it better to do so rather than using a digital version. Can you please share how you structured your doc error logs with us? It may benefit those who don't fancy using an excel and would rather refer to a bundle of notes.

Thanks in advance.

Yes, i just printed out the questions i got wrong and I would review them every week in a stack. I would review them and identify what error I made, why I made it, and in the quant case, knew how to solve a similar question. I was not solving the question every time - that would be silly as I knew the answers by heart but what I was reviewing was why I made the error, and how to spot it again (verbal) as well as how to solve similar question (logic/formual behind it) for quant. It was not a big stack - perhaps 20-30 sheets. I did not use every mistake I made - only the ones I would benefit from remembering/knowing/keeping fresh.

Does anyone knows how to add completed time in error log automatically in excel ?

bb Can we use the error log to record error in the GMAT club quizzes? I have noticed that my notes/error logs for questions in the forum are not in the same place as those for general forum questions.

ThankS!

Entering data for each question you do is tiresome and takes up a lot of time...

Thanks to GMATClub for allowing us to download our error log in excel format...
But
There's no way to delve into accuracy of sub topics ...

Here's a decent Error log (inspired by Spoilt 's GMATClub_Error_Log V3.0) that uses GMATClub Error Log's data format
It would be really helpful if someone can add charts/graphs or beautify the attached.


Thank you!

Steps to use:
1. Download your error log from GMATClub
2. Copy the data
3. Paste it in the first sheet of the attached error log
4. Change defined Range(s) by heading to Formulas > Define Name

Range Name | Range
CorrectR =GMAT_Error_Log!$F$2:$F$[Last Row Number without brackets]
DiffR =GMAT_Error_Log!$I$2:$I$[Last Row Number without brackets]
SubTypeR =GMAT_Error_Log!$K$2:$K$[Last Row Number without brackets]
TypeR =GMAT_Error_Log!$B$2:$B$[Last Row Number without brackets]

Thank you so much for putting this together!
I will link to this post from the Forum Quiz Topic as well

https://gmatclub.com/forum/forum-quiz-m ... 57144.html