[Building Sakai] Samigo swapping published assessments id's

[Ashley Willis]

Karen & Paul,
Thanks for the replies. Something related the 2 quizzes in Samigo, I am 
not sure if she was viewing or editing them simultaneously or maybe some 
of the settings are causing an issue. I don't know why it picked Quiz 5 
out of all the other assessments she published during that time frame 
but it seems like there may be a clue there.

We ended up changing the SAM_ASSESSMENTGRADING_T.PUBLISHEDASSESSMENTID 
in our test system and everything looked ok so we made the change in 
production this morning.

I will let you know if we discover anything else.

Thanks again,
Ashley Willis
Teaching and Learning Developer, UNC Chapel Hill



On 3/28/12 7:35 PM, Paul Dagnall wrote:
> 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 
> <mailto: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 <mailto: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
>         <mailto: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
>         <mailto:sakai-dev-unsubscribe at collab.sakaiproject.org> with a
>         subject of "unsubscribe"
>
>
>
>     _______________________________________________
>     sakai-dev mailing list
>     sakai-dev at collab.sakaiproject.org
>     <mailto: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
>     <mailto: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/20120329/91bdbb1b/attachment.html