[samigo-team] multiple-choice scoring research

[Karen Tsao]

Hi Sam,

It returns lots results from our production db.

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.

Thanks,
Karen

On Wed, Aug 29, 2012 at 10:28 AM, Sam Ottenhoff <ottenhoff at longsight.com>wrote:

> I am doing some research into a scoring discrepancy issue with simple
> 1 point multiple choice questions in a 3-part random draw assessment.
> The problem is that I can't replicate the issue (the students can).
>
> Can anyone run this query against a production db and tell me if they
> get results for it?  I believe this query should just look for item
> responses from students on multiple-choice questions where the student
> answered correctly but did not receive the correct points.
>
> Thanks,
> Sam
>
>
> 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
> _______________________________________________
> samigo-team mailing list
> samigo-team at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/samigo-team
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/samigo-team/attachments/20120829/2b8a367f/attachment.html