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/ErrorLogIt'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