How to Use:
I have a question and an answer for those who aren't sure. It would definitely be helpful for anyone who has used/created the
error log (I am just referring to the "winner"
error log for this particular post) to provide a quick insight on how they have demonstrated to use the excel. I just downloaded it and here's my take.
Simply put as you take practice exams, and check your answers as you get answers wrong you can enter them into the
error log. All of the categories are pretty self explanatory, and as you build the data the graphs automatically update to give you a visual representation of how you are doing. However, taking this approach I have a big question about the columns "Choice" and "OA".
It appears that the answer you chose should go under "choice" makes sense. I'm not sure what OA stands for, but it appears it refers to the correct/actual answer? Do I have that right? If you play around with the data, it appears that way, as if you mark both colums with the same letter, the visual graphs change too (Ex. For any questions under "Area" noted as arithmetic, if you set the "choice" to a different answer than "OA" you'll notice the graph goes to 0.
HOWEVER, if this is an
error log, then can someone who has used it explain why you would put an entry of something you got the answer CORRECT to on the
error log? It certainly provides good stats, but would mean you'd have to go put the entry in for every question. If that's what you are supposed to do, then ok, but can someone clarify? Or does "OA" stand for something else?
LASTLY, what is confusing is that I would think the "#" column would correspond exactly to the number of the question on that particular test ("source"). Is that correct? If so its a little misleading that the numbers in that column are sequential, it would make more intuitive sense if they were random. (not criticizing of course, just looknig for clarity).
Thanks for the help, and thanks for an awesome and very clever (once clarified)
error log.