[Using Sakai] Random drawn quiz [Scanned]

Tue Mar 9 10:39:41 PST 2010

Thanks Again Karen pls Help me  on how to go  about it I need
step-by-step Help on configuring the Demo default Hypersonic DATABASE to
point to MySQL. 

Kind Regards,

Calvin Mutsileng

Instructional Designer

IT Services

Vaal University of Technology

Tel no:016 950 9843 / 9753

Email: calvinmu at vut.ac.za

"Give a man a fish you feed him for the day ,But teach him how to fish
you feed him for a life time"

From: ktsao at hungs.org [mailto:ktsao at hungs.org] On Behalf Of Karen Tsao
Sent: 09 March 2010 08:35 PM
To: calvin mutsileng
Cc: DAVID ROLDAN MARTINEZ; sakai-user
Subject: Re: [Using Sakai] Random drawn quiz [Scanned]

You can edit your sakai.properties. Modify the MySQL settings section to
point to your MySQL database.

Thanks,
Karen

On Tue, Mar 9, 2010 at 9:55 AM, calvin mutsileng <calvinmu at vut.ac.za>
wrote:

Thanks Karen for your reply.

One more question ,I'm testing something using the Sakai-demo ,And I
want to configure the Demo to use MySQL Database not the default
Hypersonic ,How do I go about doing that?

Kind Regards,

Calvin Mutsileng

Instructional Designer

IT Services

Vaal University of Technology

Tel no:016 950 9843 / 9753

Email: calvinmu at vut.ac.za

"Give a man a fish you feed him for the day ,But teach him how to fish
you feed him for a life time"

From: ktsao at hungs.org [mailto:ktsao at hungs.org] On Behalf Of Karen Tsao
Sent: 09 March 2010 07:51 PM
To: calvin mutsileng
Cc: DAVID ROLDAN MARTINEZ; sakai-user

Subject: Re: [Using Sakai] Random drawn quiz [Scanned]

Yes. Let's say you want students to take 10 questions in this test. Then
10 questions will get drawn randomly from the 1000 questions .

Thanks,
Karen

On Tue, Mar 9, 2010 at 12:57 AM, calvin mutsileng <calvinmu at vut.ac.za>
wrote:

If you set-up a Test with Random draw. Suppose you have 1000 questions
in your pool ,

Do students see different Questions though it's the same Test?

Kind Regards,

Calvin Mutsileng

Instructional Designer

IT Services

Vaal University of Technology

Tel no:016 950 9843 / 9753

Email: calvinmu at vut.ac.za

"Give a man a fish you feed him for the day ,But teach him how to fish
you feed him for a life time"

From: sakai-user-bounces at collab.sakaiproject.org [mailto:
sakai-user-bounces at collab.sakaiproject.org] On Behalf Of Karen Tsao
Sent: 09 March 2010 12:52 AM
To: DAVID ROLDAN MARTINEZ
Cc: sakai-user
Subject: Re: [Using Sakai] Random drawn quiz [Scanned]

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"

Disclaimer: This message and any attachments are confidential and
intended solely for the addressee. Please notify the sender immediately
by e-mail if you have received this e-mail by mistake and delete this
e-mail from your system. Unauthorised disclosure and/or use of
information contained in this email may result in civil and criminal
liability. Neither the sender of the e-mail, nor Vaal University of
Technology shall be held liable to any party for any direct, indirect or
consequential damages, including, without limitation, loss of profit,
interruption of business or loss of information, data or software or
otherwise. No warranties are created or implied that an employee of Vaal
University of Technology and/or a contractor of Vaal University of
Technology is authorized to create and send this e-mail. 

Disclaimer:
This message and any attachments are confidential and intended solely for the addressee. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. Unauthorised disclosure and/or use of information contained in this email may result in civil and criminal liability. Neither the sender of the e-mail, nor Vaal University of Technology shall be held liable to any party for any direct, indirect or consequential damages, including, without limitation, loss of profit, interruption of business or loss of information, data or software or otherwise.
No warranties are created or implied that an employee of Vaal University of Technology and/or a contractor of Vaal University of Technology is authorized to create and send this e-mail.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-user/attachments/20100309/b1bed94d/attachment-0001.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 3479 bytes
Desc: image004.jpg
Url : http://collab.sakaiproject.org/pipermail/sakai-user/attachments/20100309/b1bed94d/attachment-0002.jpe 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 3479 bytes
Desc: image002.jpg
Url : http://collab.sakaiproject.org/pipermail/sakai-user/attachments/20100309/b1bed94d/attachment-0003.jpe 