Download a spreadsheet with all students and question grades

Sue.S.4
Sue.S.4 Posts: 80 🧭

Is there a way to download a spreadsheet with all students (row by row) and then their grade for each question.

Here's a specific example to show you need for report - we are trying to ascertain which students' responses may have been missed when grading. We have 1501 questions and 40 students.

We are wanting a spreadsheet with 40 rows (1 for each student) and then the 150 questions as columns - just showing a grade or blank for ungraded questions. The blank cells we can then go in and grade, knowling all students have been marked on every question.

Thank you in anticipation.

Tagged:

Answers

  • Hi,@Sue.S.4

    Regarding your request, you can find below the steps to export the CSV for responses submitted by the user.

    1. Go to the Quizzes tool
    2. Click on the drop-down arrow beside your quiz
    3. Click on Grade
    4. Choose the User's tab
    5. Click on Export to CSV or Excel

    This will give you the user details along with responses submitted for each question and the score received for each question.

    I hope this finds you useful.