Forum .LRN Q&A: Re: Tables related with exam answers and grades

2: Re: Tables related with exam answers and grades (response to 1)

Posted by Emmanuelle Raffenne on 05/20/11 11:59 AM

Hi Irma,

Answers are stored in the evaluation_answers table:

  Table "public.evaluation_answers"
     Column     |  Type   | Modifiers
----------------+---------+-----------
 answer_id      | integer | not null
 answer_item_id | integer |
 party_id       | integer | not null
 task_item_id   | integer |
 comment        | text    |
 comments       | text    |
Indexes:
    "evaluation_answers_pkey" PRIMARY KEY, btree (answer_id)
    "evaluation_answers_tid_index" btree (party_id, task_item_id)
Foreign-key constraints:
    "evaluation_answers_answer_id_fkey" FOREIGN KEY (answer_id) REFERENCES cr_revisions(revision_id)
    "evaluation_sans_aiid_fk" FOREIGN KEY (answer_item_id) REFERENCES cr_items(item_id)
    "evaluation_sans_pid_fk" FOREIGN KEY (party_id) REFERENCES parties(party_id)
    "evaluation_sans_tid_fk" FOREIGN KEY (task_item_id) REFERENCES cr_items(item_id)

4: Competency project at tecDigital (response to 2)

Posted by Irma Gamez on 05/21/11 06:30 AM

Hi Emmanuelle. I´m working in a competency project and I`m a little bit lost :S I really need some help with tables.
I need to find the student´s answers to surveys/questionaries, a query with the users, their answers and thier average. Then, I want to relate each question or document (for tasks) to a competence.
Than you very much.

6: Re: Competency project at tecDigital (response to 4)

Posted by Emmanuelle Raffenne on 05/23/11 10:02 AM

Hi Irma,

I have been at TEC-digital in february but I don't think we met. Feel free to email me in spanish, ask Mario for my email address.

7: Re: Competency project at tecDigital (response to 6)

Posted by Irma Gamez on 05/24/11 04:51 PM

Muchas gracias. Le pediré su correo.
Otra pregunta: ¿el contenido que corresponde a un curso se guarda en las tablas acs_ o cr_? Es que necesito referenciar cada lección/capítulo/unidad de aprendizaje de un curso a un bloque de competencias.
Saludos.

8: Re: Competency project at tecDigital (response to 7)

Posted by Emmanuelle Raffenne on 05/24/11 08:20 PM

Hola Irma,

Entiendo que se refiere a cursos SCORM, manejados por los paquetes lors y lorsm, o IMS-LD, manejados por el paquete imsld. El contenido de ambos se guarda en el file-storage, que a su vez, hace uso del content repository.

No obstante, recomendaría asociar las competencias al objeto de aprendizaje que es el que aporta la información relevante del mismo, y no al contenido almacenado en el content repository.

9: Re: Competency project at tecDigital (response to 8)

Posted by Irma Gamez on 05/29/11 04:45 AM

Buenas noches, como ha estado. Todavía no consigo su correo. Quisiera saber cómo se manejan las evaluaciones en el paquete imsld. En las tablas no encuentro dónde se guardan calificaciones, ni veo que se relacionan con las tablas evaluation. Muchas gracias.