Page tree
Skip to end of metadata
Go to start of metadata

The Exam Item Analysis report returns the questions that were associated   with an exam at run time. Exams can be randomized, their questions drawn from   a pool. The report accounts for randomization and pools.

 

Report NameExam Item Analysis (CSV)
REPORT_NAME_IDExamItemAnalysisCSV
REPORT_ID240
CATEGORY_IDContent
GROUP_IDUserExamItemAnalysis
WORKFLOW_IDRun Exam Item Analysis Report
TYPEBIRT /PRD
USER_TYPEAdmin
SHOW_IN_MENUYes
DMN_IDPUBLIC

 

ExamDetails
SELECT qe.question_id 
       AS 
       qe_question_id, 
       qe.question_name 
       AS qe_question_name, 
       qe.question_no, 
       qe.question_stem, 
       qe.question_type_id, 
       qe.version, 
       qe.revision, 
       qe.last_edit_date, 
       qe.last_presented, 
       qe.is_active, 
       qe.choices_randomized, 
       qe.point_value, 
       qe.is_web_reviewable, 
       qe.enable_crossdomain, 
       qe.content_wrapper_url, 
       qe.content_wrapper_type, 
       qe.proxlet_url, 
       qe.feedback, 
       qe.import_date, 
       qe.last_upd_user, 
       qe.last_upd_tstmp, 
       m.question_name 
       AS m_question_name, 
       m.description, 
       m.dmn_id, 
       m.objective_id, 
       m.created_by, 
       m.created_date, 
       m.keywords, 
       m.lst_upd_usr, 
       m.lst_upd_tstmp, 
       cnt.question_id 
       AS cnt_question_id, 
       cnt.exam_name 
       AS cnt_exam_name, 
       cnt.description 
       AS cnt_exam_desc, 
       cnt.learners 
       AS cnt_exam_learners, 
       cnt_qe.learners 
       AS cnt_qe_responses, 
       pkg_exam.Get_question_stem (pkg_tool.Get_clob_from_blob 
                                   (qe.question_data)) AS 
       question_object, 
       y.responses, 
       y.choicexml, 
       y.responsetype, 
       y.distractor 
       AS y_question_object 
FROM   pa_cbt_question qe, 
       pa_cbt_question_metadata m, 
       (SELECT x.question_id, 
               x.exam_name, 
               c.description, 
               Count (DISTINCT b.stud_id) AS learners 
        FROM   pa_cbt_stud_exam_question x, 
               pa_cbt_stud_cpnt b, 
               pa_cbt_exam_def c 
        WHERE  c.exam_name = x.exam_name 
               AND x.stud_cpnt_id = b.stud_cpnt_id 
        /** and x.exam_name in [ExamNameSearch]          and [security: pa_cbt_exam_def c]    */ 
        GROUP  BY x.exam_name, 
                  x.question_id, 
                  c.description) cnt, 
       TABLE (pkg_exam.Get_question_responses (cnt.exam_name, cnt.question_id)) 
       y, 
       (SELECT c.question_id, 
               Count(*) AS learners 
        FROM   pa_cbt_stud_exam_question c 
        WHERE  1 = 1 
        /** and c.exam_name in [ExamNameSearch] */ 
        GROUP  BY c.question_id) cnt_qe 
WHERE  qe.question_id = cnt.question_id 
       AND qe.question_name = m.question_name 
       AND cnt_qe.question_id = qe.question_id 
  • No labels