Wrong Answer Error Analysis Excel Sheet?

[FirstAndFinal]

I've read a lot of discussion in which people recommend logging which answers you got wrong, why you got them wrong, etc. so that you can identify trends and strengthen your weak spots. I was wondering if anyone has an excel sheet that's set up to log this sort of information. I've searched and found a few documents that are helpful but not quite what I'm looking for (e.g. allows you to choose why you got it wrong but nowhere to log what you answered and what the answer should have been...or even what the question was).

Even if you haven't made one or don't want to share it, do you have insight on how best to set it up? Would you type out the question or just reference it (e.g. FL#2, BS, Q#2)? What if it has figures? Would you include your answer and what the right answer was? What about answers that you got right but that you just guessed on or got right for the wrong reason? Would you log only FL questions or all questions you do throughout your studies? How would you sort it out to look for trends?

Ahh, so many questions! I hope there are some Excel wizards out there who have thought this through already.

---

Members don't see this ad.

 

[dmf2682]

Why don't you take a screen shot and paste it in as an image?

 

[danny89]

I have the word document version of that. The excel version would be helpful.

 

[premedstudenttt]

I took a different approach for the excel portion. When you get your AAMC results from a practice test it breaks down the questions you got wrong by topic. So I would copy those results into an excel sheet. If I missed a high % of the questions regarding waves two exams in a row, I would make an adjustment.

This was extremely helpful to improve content gaps. However, not so useful for test taking or logic errors.

I more than happy to show you the output for this. It was extremely accurate for me.

I am unfamiliar with the word document you are referring to, but I am an excel wizard. If you pm with the word document, I can more than likely transform it to an excel sheet.

 

[ReadyToRumble]

Um, I think we're all for danny89 and premedstudenttt collaborating and posting the finished results for everyone to use 😀