[Building Sakai] Samigo swapping published assessments id's

[Paul Dagnall]

Ashley
We had this happen to us once. We never figured out how it occurred, and it
hasn't happened since. Here's how I fixed it.

Note: In our case, some assessments which already had submissions received
bonus submissions from this mix up. For this reason I needed to used dates
to differentiate the two groups.

update SAM_ASSESSMENTGRADING_T set PUBLISHEDASSESSMENTID = <the right one>
where (SUBMITTEDDATE > TO_DATE('16-MAR-2011 00:00:00', 'DD-MON-YYYY
HH24:MI:SS')) and (PUBLISHEDASSESSMENTID = <the wrong one>)

After this, we didn't have any other abnormal side effects.

Hope this helps.

Paul Dagnall
Application Developer & Administrator
University of Dayton


On Wed, Mar 28, 2012 at 5:31 PM, Karen Tsao <ktsao at stanford.edu> wrote:

> Hi Ashley,
>
> Do you know if the instructor had multiple published assessments open in
> different windows/tabs when she edited them? This is just my wild guess. I
> don't know what would be the cause of your issue. If you get more
> information, please do let me know.
>
> I think updating the published assessment id in sam_assessmentgrading_t
> should work. Although I am not sure if this action will cause any other
> issue, but I think you can always revert the id back, right?
>
> Thanks,
> Karen
>
>
> On Wed, Mar 28, 2012 at 8:31 AM, Ashley Willis <ashley_willis at unc.edu>wrote:
>
>> We have encountered a strange scenario at UNC with Samigo and published
>> assessments. We have an instructor that published "Quiz 5" around
>> 2/10/12. It was a timed (33min) test. Students took and submitted the
>> test with no issues and it was due and retracted on 2/14.
>>
>> The instructor published "Quiz 7" on 3/16/12 (33 min timed), due and
>> retracted on 3/19/12. Students apparently took and submitted Quiz 7
>> according to the events table and the grades were recorded correctly in
>> gradebook for Quiz 7.
>>
>> However when the students look at their submissions in Test & Quizzes,
>> they see 2 submissions for Quiz 5. One of them clearly should be Quiz 7,
>> the dates and scores match but the title is wrong. FWIW, the erroneous
>> entry is bold and marked "Recorded".
>>
>> The Instructor only sees 9 submissions for Quiz 7, there are roughly
>> ~152 submissions missing. In sam_assessmentgrading_t, the submissions
>> for Quiz 7 are showing up with the publishedassessmentId for Quiz 5 and
>> they are marked late even though they were submitted on time according
>> to Quiz 7 settings. It seems as though somehow Samigo associated Quiz 7
>> with Quiz 5 when the students submitted their tests.
>>
>> Some background, it is possible the instructor removed/edited Quiz 7
>> after it was published and then republished. I don't see evidence of
>> that in the events table but she was not able to recall. I do see
>> several edits to the test before it was published though. Also, she is
>> using timed assessments, but for Quiz 7 she also selected Automatic
>> Submission. The tests all appear to be manually submitted and we have
>> let the instructor know not to select both options next time but we are
>> not sure if that would have somehow caused an issue.
>>
>> Clearly we want to figure out what happened, but in the meantime we were
>> wondering if it is possible to change the publishedassessmentId in
>> sam_assessmentgrading_t to the published id for Quiz 7 without causing
>> any other issues. The intention is to fix the view for the students so
>> they see the submission for Quiz 7 in T&Q instead of 2 submissions for
>> Quiz 5.
>>
>> TIA for any help!
>> Ashley Willis
>> Teaching and Learning Developer, UNC Chapel Hill
>>
>>
>>
>> _______________________________________________
>> sakai-dev mailing list
>> sakai-dev at collab.sakaiproject.org
>> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>>
>> TO UNSUBSCRIBE: send email to
>> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
>> "unsubscribe"
>>
>
>
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to
> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
> "unsubscribe"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20120328/7bcea2bb/attachment.html