Ticket #:

596-6755603

Date Created:

9/22/2008 3:55 PM EDT

Priority:

High

Summary:

screwy quiz results

Details:

Hi,

A professor is having issues with a quiz that most of her students had taken. When she goes into "view, grade, or delete submissions" a few grades come up, there there is nothing else (screenshot 1). When I click to view on any grade I get an error (screenshot 2).

Is there anyway to grab these grades? The prof is pretty peeved right now.

The class is: ENG112_075003 Fall 2008; ENGLISH COMPOSITION II WITH SPEECH

Thank you in advance.

Mike Sullivan
Coordinator, Distance Learning
Mercer County Community College

Comment(s):

Hi, Mike. I spent some time this morning digging into this assessment with another analyst. We found that the errors are a result of Quiz 1 not being able to find the database records it's looking for to deliver questions. After looking at the responses in the database we determined that the records Quiz 1 is looking for are associated with the Quiz 3 assessment. Unfortunately, we were not able to determine how this happened. Because the records for Quiz 1 are so intertwined with Quiz 3 now, it is not possible to fix Quiz 1. We also found that Quiz 3 seems to be unaffected by any of this. We do have queries to retrieve the student responses for Quiz 1. This query will show you some basic information about the submissions, including a response_id which you will need to ins! ert into the second query to retrieve the students' answers:

select lsn_responses.response_id, accounts.last_name+', '+accounts.first_name as name, lsn_responses.user_id, lsn_responses.grade, lsn_responses.date_submitted from lsn_responses
join accounts on accounts.username = lsn_responses.user_id
where parent_id = 'B56BFD30C2774DFFB106952A952C68EA'
order by date_submitted desc

Here is the second query, which will return students' answers to the assessment's questions (remember to insert the response_id from the first query):

select qti_delivered_questions.sequence, qti_questions.type, qti_questions.question_text, qti_delivered_questions.points_possible, qti_delivered_questions.points_awarded, qti_persisted_answers.value as student_response from qti_questions
join qti_delivered_questions on qti_delivered_questions.question_id = qti_questions.question_id
join qti_persisted_answers on qti_persisted_answers.delivered_id = qti_delivered_questions.delivered_id
where qti_persisted_answers.delivered_id in (select delivered_id from qti_delivered_questions where attempt_id in (select attempt_id from qti_assessment_attempt where response_id = 'Insert response_id'))
order by qti_delivered_questions.sequence

During our research we also found that the assessment titled, "Evaluate this Course and Instructor" is also broken. This assessment will either need to be recreated or recopied from whatever source it came from. I hope this helps, if you run into any trouble with the queries or have any further questions, please let us know. Thank you for your patience while we worked through this.

Brad

ANGEL Support