Download a spreadsheet with all students and question grades

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.
Answers
-
Hi,@Sue.S.4
Regarding your request, you can find below the steps to export the CSV for responses submitted by the user.
- Go to the Quizzes tool
- Click on the drop-down arrow beside your quiz
- Click on Grade
- Choose the User's tab
- 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.