Sakai KB home

Using Sakai 2.8 Tests & Quizzes, how do I view or export participant scores and answers to individual questions?

To view student scores and answers to individual questions in Tests & Quizzes:

  1. In the menubar of the relevant site, click Tests & Quizzes.

  2. On the Assessments page, under "Published Assessments", find the pertinent assessment. Next to its title, click  --Select Action-- , and then click Scores. By default, the Total Scores screen will open, displaying a table with the following information for each participant:

    • Name
    • User ID
    • Role
    • Submit Date (the date the participant submitted the assessment)
    • Score

      Note: Unsubmitted assessments will show a single dash ( - ) in the "Adjustment" column. The tool will not automatically send a score of zero to the gradebook when a student does not take an assessment. To enter a score for an unsubmitted assessment, type a value in the "Adjustment" column, and then click Update to save your changes.

    • Adjustment (a field for you to enter an adjustment that will be added to the Score; click Update to save your changes)
    • Final Score (the participant's final score, calculated by adding the Score and Adjustment values)
    • Comment for Student (a text box in which you can type comments that will appear when participants view their submitted tests; click Update to save your changes)

      Note: In addition to providing feedback in the comment text boxes, you can attach files on the Questions page or on a student's individual submission page.

    Note: By default, the information on the Total Scores screen is sorted alphabetically by participant name. To sort the information using another column, click the name of the column. If you created sections using the Section Info tool, you can use the drop-down list near the top of the screen to choose to view information for a particular section only. If you allowed multiple submissions, you can use the drop-down list near the top of the screen to view only the submission with the highest score.

  3. To see the questions on the test, and your participants' answers to each, near the top of the screen, click Questions. Navigate through questions by clicking the question links near the top of the screen. This can allow you to quickly compare how all students answered a specific question.

    Note: For Short Answer/Essay questions, you can view the entire response on the question page (rather than just the first few words with a link) by changing the drop-down option from Responses Pop-Up to Responses Inline.

  4. To see the total number of submissions, the total score possible, and statistical information (such as the mean, median, mode, and range of the scores), near the top of the screen, click Statistics.

    Beneath the cumulative information, each question is listed with a histogram showing the number of students who selected a particular response.

  5. To see information about student performance on each item, click Item Analysis. Here you can see:

    • A column labeled "N", showing the number of students who were presented with this question.

    • The percentage who got the question correct among the whole group, the upper 27% of test takers, and the lower 27%.

    • An index labeled "Discrim", which measures how well an item is able to distinguish between students who perform well and those who perform poorly on the test as a whole. A score of 1 represents perfect discrimination (i.e., all the top students got it correct and all the lowest students missed it), a score of 0 represents an equal number of top performers and low performers who answered correctly, and a negative score means that more low performers than top performers answered correctly.

      Note: For any question with more than one response, the discrimination index measures the difference between students who got the entire question correct and those who did not.

    • The number of students who skipped the question.

  6. To export all assessment responses in Excel format, click Export.

  7. To see only the ungraded questions on the test, and your participants' answers to each, near the top of the screen, click Ungraded.

Also see:

Last modified on August 29, 2013.