[samigo-team] multiple-choice scoring research

[Karen Tsao]

>
>
> 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?
>
>
Yes. I agree with what you said.

Just some thought... Has the instructor edited the published assessment and
updated the answer after the student took it?

Thanks,
Karen


> --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
> >
> >
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/samigo-team/attachments/20120829/031cd093/attachment.html