[Using Sakai] Random drawn quiz

[Karen Tsao]

Please try the following query. It returns the student id and the question
text:

SELECT ag.agentid student_id, pit.text question_text
FROM sam_assessmentgrading_t ag, sam_itemgrading_t ig,
sam_publisheditemtext_t pit
WHERE ag.forgrade = 1 and ag.assessmentgradingid = ig.assessmentgradingid
AND  ig.publisheditemtextid = pit.itemtextid
AND ag.publishedassessmentid = :published_assessment_id
GROUP by ag.assessmentgradingid, pit.itemtextid
ORDER BY ag. agentid,  ig.itemgradingid

Thanks,
Karen

On Mon, Mar 8, 2010 at 2:07 PM, DAVID ROLDAN MARTINEZ <
darolmar at upvnet.upv.es> wrote:

> Karen,
>
> Can you post a sample query to do this, please? For us it would be very
> useful, too.
>
> Thank you very much in advance.
>
> David
> ________________________________________
> De: sakai-user-bounces at collab.sakaiproject.org [
> sakai-user-bounces at collab.sakaiproject.org] En nombre de Karen Tsao [
> ktsao at stanford.edu]
> Enviado el: lunes, 08 de marzo de 2010 23:04
> CC: sakai-user
> Asunto: Re: [Using Sakai] Random drawn quiz
>
> Hi Greg,
>
> I think the only way is querying database directly. If you need my help
> with the queries, please let me know.
>
> Thanks,
> Karen
>
> On Mon, Mar 8, 2010 at 1:01 AM, Gregory Doyle <Gregory.Doyle at uct.ac.za
> <mailto:Gregory.Doyle at uct.ac.za>> wrote:
> Hi
> We've set up a quiz with questions randomly drawn from a question pool (25
> from 38). The instructor did not realise there would be no item analysis -
> is there anyway to determine which questions each student got?
>
> Thanks
> greg
>
>
> _______________________________________________
> sakai-user mailing list
> sakai-user at collab.sakaiproject.org<mailto:
> sakai-user at collab.sakaiproject.org>
> http://collab.sakaiproject.org/mailman/listinfo/sakai-user
>
> TO UNSUBSCRIBE: send email to
> sakai-user-unsubscribe at collab.sakaiproject.org<mailto:
> sakai-user-unsubscribe at collab.sakaiproject.org> with a subject of
> "unsubscribe"
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-user/attachments/20100308/737f557b/attachment.html