[samigo-team] multiple-choice scoring research

[Karen Tsao]

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/5f2cf56d/attachment.html