I was bored and decided to create a spreadsheet breaking out all of the answer keys that have been posted here. It assigns a "confidence level" to all questions based on how many individuals selected a particular answer. If you input your answers (Just clear mine and put in yours), it will break down how many you have correct or incorrect in each of the applicable categories.
Feel free to improve on it if you want, or if something amazing happens, I will update it as necessary.
I cannot attach it to this post so just go to the following link and download it.
http://www.ottrack.com/downloads/AnswerKey.xlsx
IhaveNoHook said
Nov 7, 2011
doesnt work bro
unborn said
Nov 7, 2011
Well I guess i figured out who made the ottrack program. Good job with this.
Gamblor said
Nov 7, 2011
unborn wrote:
Well I guess i figured out who made the ottrack program. Good job with this.
Thanks. Yeah, I needed to use something to host the file and the OT track server seemed as good a place as any.
IhaveNoHook wrote:
doesnt work bro
It should. Make sure you are using Excel 2007 or 2010. If you are still using 2003, install the 2007 compatability pack and it should work fine.
Bmoc09 said
Nov 7, 2011
nice breakdown, thanks
NYPD231 said
Nov 7, 2011
Wow- I thought I had no life.
Just kidding, thanks for the effort.
I think the next thing would be trying to figure out which questions are the low/moderate ones. I have absolutely not idea which is which, but I think you could guess which ones they are based on the old threads with the arguments about the "controversial" questions.
-- Edited by NYPD231 on Monday 7th of November 2011 03:53:50 AM
sgtmcvengeance said
Nov 7, 2011
Well done. I trust you got more of the math questions correct than I did.
72 (60, 4, 8) by your system. Hope that works.
NYG37 said
Nov 7, 2011
Nice, does it add youre answers to the rest of list when it calculates ? Can this somehow be centralized ?
-- Edited by NYG37 on Monday 7th of November 2011 04:04:42 AM
NYPD231 said
Nov 7, 2011
So I have 6 wrong that are marked as "high." The other 10 marked wrong are either low or moderate. Then some that I had originally marked as correct that are now showing as low or moderate. What are there, 25 low or moderate total? I don't know how to interpret that. I think I'm giving up and just waiting for the 28th. Careful, this chart might make it on to the next LT's test.
CRS said
Nov 7, 2011
Nice Job! Thanks..........
outat20 said
Nov 7, 2011
Pretty Impressive
nycop80 said
Nov 7, 2011
this is amazing, job well done, i hope this is as close to accurate as it can get before the real key is out,
Gamblor said
Nov 7, 2011
It is based on the 25 or so answer keys posted on this site. The way it determines the confidence level is by looking at the most selected answer and comparing it to the next highest. If the highest is at least double the next highest, it gets a high confidence rating. A moderate rating requires at least a 1.5x over the next highest answer. A low rating is everything lower than 1.5x.
Tomorrow I will see if I can match up some of the questions to the ratings. As for centralizing, I can do that in Excel, but it is overly complicated. It would be easier to just build a database where people can input their scores. I will look into it and if I have time, I will see what I can do.
nycop80 said
Nov 7, 2011
Gamblor you are amazing, thank you for taking the time to do this,
Turtle said
Nov 7, 2011
Gamblor:
Kudos for your work. We need to protest "Low Confidence" answers with cogent argument. Consequently, most people will benefit.
Keep up the good work.
BXCOPPER33 said
Nov 7, 2011
Thanks
hollar said
Nov 7, 2011
I cannot open or find the file
Doc22 said
Nov 7, 2011
either can i
OnTheFence said
Nov 7, 2011
Nice work; I'm going to make special note of the following to see what was up for the protest. About 18 questions based on your chart break down for possible double answers (bad), and another 8 appear to be all over the place, possible bad questions for a throw out.
Bad questions? 25- a/c/d 37- b/c/d 50- a/b/c 56- a/b/d 58- b/c/d 64 a/b/c/d/ = w t f ? 68- a/c/d 83- a/b/d
It should help narrowing down the problem questions and possible bad answers. Thanx.
NextLtTest said
Nov 8, 2011
64 a/b/c/d/ = w t f ?
7 questions with four answers on the last Capt. Exam.
BertMan said
Nov 8, 2011
for the noobs who cant view the file
download link http://imageshack.us/photo/my-images/406/143y.jpg/
download link http://imageshack.us/photo/my-images/411/4486.jpg/
download link http://imageshack.us/photo/my-images/545/87100.jpg/
NYPD231 said
Nov 8, 2011
For all the threads about the judgement questions, 19 of the 25 moderate/low questions are from the patrol guide portion.
HB said
Nov 8, 2011
This chart is nice and all but doesnt prove anything
Rudy said
Nov 8, 2011
Almost as confusing as the nine squad chart I heard about. There is a moderately high chance I got a low score. Can anyone wait for the answer key in 3 weeks.
18and1 said
Nov 8, 2011
Just wait until the 28th. All these answer keys and spread sheets will make you insane. My Sgt's test final answer key was 15 off of the rising star/academy key.
nycop80 said
Nov 8, 2011
It really isn't that hard to understand the chart
occbsux said
Nov 9, 2011
Thanks for all the hard work. I am right on the cusp, 67 according to this, many of the low confidence answers I have wrong, so hopoefully I pick up a few.
stiggityone said
Nov 16, 2011
65/75 on the "high confidence". Should be fine.
PatrolGuideismyBible said
Nov 16, 2011
There only are 75 total "high confidence" which is what makes this answer key all over the place. I hope its accurate, it would give me an 80 (64hc,8mc,8lc) raw score, I would take that in a second with this brutal test.
Nypdblue said
Nov 16, 2011
Who s to even say the high confidence answers are even right. This is the one test where you really can't go by this master key because the questions were that off the wall . This wasn't an open book test like that 2011 sgt test
I was bored and decided to create a spreadsheet breaking out all of the answer keys that have been posted here. It assigns a "confidence level" to all questions based on how many individuals selected a particular answer. If you input your answers (Just clear mine and put in yours), it will break down how many you have correct or incorrect in each of the applicable categories.
Feel free to improve on it if you want, or if something amazing happens, I will update it as necessary.
I cannot attach it to this post so just go to the following link and download it.
http://www.ottrack.com/downloads/AnswerKey.xlsx
Thanks. Yeah, I needed to use something to host the file and the OT track server seemed as good a place as any.
Wow- I thought I had no life.
Just kidding, thanks for the effort.
I think the next thing would be trying to figure out which questions are the low/moderate ones. I have absolutely not idea which is which, but I think you could guess which ones they are based on the old threads with the arguments about the "controversial" questions.
-- Edited by NYPD231 on Monday 7th of November 2011 03:53:50 AM
Well done. I trust you got more of the math questions correct than I did.
72 (60, 4, 8) by your system. Hope that works.
Nice, does it add youre answers to the rest of list when it calculates ? Can this somehow be centralized ?
-- Edited by NYG37 on Monday 7th of November 2011 04:04:42 AM
Nice Job! Thanks..........
Tomorrow I will see if I can match up some of the questions to the ratings. As for centralizing, I can do that in Excel, but it is overly complicated. It would be easier to just build a database where people can input their scores. I will look into it and if I have time, I will see what I can do.
Kudos for your work. We need to protest "Low Confidence" answers with cogent argument. Consequently, most people will benefit.
Keep up the good work.
either can i
Nice work; I'm going to make special note of the following to see what was up for the protest.
About 18 questions based on your chart break down for possible double answers (bad), and another 8 appear to be all over the place, possible bad questions for a throw out.
Bad questions?
25- a/c/d
37- b/c/d
50- a/b/c
56- a/b/d
58- b/c/d
64 a/b/c/d/ = w t f ?
68- a/c/d
83- a/b/d
Bad/Double Answers?
4- c/d
18- c/d
19- b/d
21- c/d
24- a/d
26- a/c
28- c/d
29- a/b
35- a/b
41- c/d
46- a/b
52- a/b
60- a/d
77- b/c
85- a/c
89- b/c
90- b/c
100- a/c
It should help narrowing down the problem questions and possible bad answers. Thanx.
7 questions with four answers on the last Capt. Exam.
download link http://imageshack.us/photo/my-images/406/143y.jpg/
download link http://imageshack.us/photo/my-images/411/4486.jpg/
download link http://imageshack.us/photo/my-images/545/87100.jpg/