[samigo-team] multiple-choice scoring research

[Sam Ottenhoff]

Thanks Karen.  Can anyone else report out results?

Karen, do you agree that the students in all of these results should
have received the result from SAM_PUBLISHEDANSWER_T.SCORE instead of a
0 in all of these cases?

--Sam

On Wed, Aug 29, 2012 at 3:14 PM, Karen Tsao <ktsao at stanford.edu> wrote:
> Yeah. I missed that JOIN. I think your query should get the correct one.
>
> Karen
>
>
> On Wed, Aug 29, 2012 at 12:05 PM, Sam Ottenhoff <ottenhoff at longsight.com>
> wrote:
>>
>> > I am not sure if I understand your query correctly. But the
>> > sa.ISCORRECT=1
>> > doesn't mean the student answers the question correctly, it means that
>> > choice is the correct answer for that multiple choice question. We
>> > verify
>> > whether student's answer is correct online and then save the score into
>> > db.
>> > There is no column representing the correctness of student's answer.
>>
>> Yeah, my thinking was to get the correct answer from the
>> SAM_PUBLISHEDANSWER_T table first... and then to JOIN it to the
>> student's response table (SAM_ITEMGRADING_T).  Don't we know the
>> student answered correctly because of that JOIN?
>>
>> select spi.ITEMID, sa.ANSWERID, si.PUBLISHEDANSWERID, spi.SCORE,
>> si.AUTOSCORE
>> from SAM_ITEMGRADING_T AS si
>> INNER JOIN SAM_PUBLISHEDANSWER_T AS sa ON si.PUBLISHEDANSWERID=sa.ANSWERID
>> INNER JOIN SAM_PUBLISHEDITEM_T AS spi ON si.PUBLISHEDITEMID=spi.ITEMID
>> WHERE sa.ISCORRECT=1 AND si.AUTOSCORE=0 AND sa.SCORE > 0 AND
>> spi.TYPEID=1 AND spi.PARTIAL_CREDIT_FLAG=0
>
>