[Contrib: Evaluation System] In which table individual response's options are stored

[Aaron Zeckoski]

The responses to individual questions are stored in eval_answers. The
response to an individual evaluation is stored in eval_response. For
example:

Aaron, Becky and Carl are taking an evaluation which has 3 items
assigned. Aaron answers 2 items and Becky answers all 3 and Carl does
not even take it.
There will be 2 (1+1+0) entires in eval_response and 5 (2+3+0) entries
in eval_answer as a result of these actions.

I am not sure how to answer the question any more clearly than this.
If you are still confused then try telling us what you are trying to
accomplish.

-AZ


On Mon, Mar 30, 2009 at 11:26 AM, Santhanam V <santhanam at aims.amrita.edu> wrote:
> Dear Stephen & Aaron,
>
>     Thanks for your replies.
>
>     What i meant was that where the user's response to a question/option is stored. I have found out that the user's reponse is stored in "EVAL_ANSWER" table's NUM_ANSWER field.
>
> Thanks for your time.
>
> With Regards
> Santhanam
>
>
> Aaron Zeckoski wrote at Mon Mar 30 14:54:11 IST 2009:
>>If you mean ther answers to a multiple answer question then they are
>>still stored in the answer table itself.
>>-AZ
>>
>>
>>On Mon, Mar 30, 2009 at 8:11 AM, Stephen Marquard
>><stephen.marquard at uct.ac.za> wrote:
>>> Hi Santhanam,
>>>
>>> What do you mean by "response options"? If you mean answers to questions, those are in EVAL_ANSWER. EVAL_RESPONSE has one entry per evaluation submission.
>>>
>>> The questions are defined in EVAL_ITEM and EVAL_TEMPLATEITEM.
>>>
>>> Regards
>>> Stephen
>>>
>>> Stephen Marquard, Learning Technologies Co-ordinator
>>> Centre for Educational Technology, University of Cape Town
>>> http://www.cet.uct.ac.za
>>> Email/IM/XMPP: stephen.marquard at uct.ac.za
>>> Phone: +27-21-650-5037 Cell: +27-83-500-5290
>>>
>>>
>>>>>> Santhanam V <santhanam at aims.amrita.edu> 2009/03/30 08:54 AM >>>
>>> Dear Friends,
>>>     I am trying to follow the work flow of Evaluation's survey.
>>>
>>>     I could observe that the responses are stored in "eval_response" & "eval_answer" tables.
>>>
>>>    But i could not find where the each individual response's option are stored. Can any one please kindly tell me, in which table/field, the individual response's option are stored ?
>>>
>>> Thanks In Advance
>>> With Regards
>>> Santhanam
>>>
>>> ---------------------------------------------------
>>> Amrita Institute of Medical Sciences, Cochin, India
>>>
>>>
>>>
>>> _______________________________________________
>>> evaluation mailing list
>>> evaluation at collab.sakaiproject.org
>>> http://collab.sakaiproject.org/mailman/listinfo/evaluation
>>>
>>> TO UNSUBSCRIBE: send email to evaluation-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"
>>>
>>> _______________________________________________
>>> evaluation mailing list
>>> evaluation at collab.sakaiproject.org
>>> http://collab.sakaiproject.org/mailman/listinfo/evaluation
>>>
>>> TO UNSUBSCRIBE: send email to evaluation-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"
>>>
>>
>>
>>
>>--
>>Aaron Zeckoski (aaronz at vt.edu)
>>Senior Research Engineer - CARET - Cambridge University
>>[http://bugs.sakaiproject.org/confluence/display/~aaronz/]
>>Sakai Fellow - [http://aaronz-sakai.blogspot.com/]
>>
>
> ---------------------------------------------------
> Amrita Institute of Medical Sciences, Cochin, India
>
>
>
>



-- 
Aaron Zeckoski (aaronz at vt.edu)
Senior Research Engineer - CARET - Cambridge University
[http://bugs.sakaiproject.org/confluence/display/~aaronz/]
Sakai Fellow - [http://aaronz-sakai.blogspot.com/]