Is there a way to export the Quiz -> Grades view?

Is there a way to export grades and the date of which the quiz was completed?
For example, going to Quiz → dropdown options → Grades gives me exactly the visual I'm looking for. but, when I click on the export button on this page, the excel file gives me a whole different format.
Answers
-
Hi @Yi Yan.L.782,
While it's not possible to export the exact "Grades" view you see on screen, with both grades and completion dates, there are two workarounds you can use:
> The simplest method is to copy the data directly from the "Grade Quiz" page and paste it into a spreadsheet like Excel. While this is a low-tech solution, it works well for small classes or when you only need to do it once.
> A more comprehensive solution is to use the Data Hub. You can find the necessary information in the Quiz Attempts dataset, which will include the completion dates and grades for each attempt.
Alternatively, you can use the Brightspace API. The GET request to the following endpoint will provide the grades and completion dates: https://docs.valence.desire2learn.com/res/quiz.html#get--d2l-api-le-(version)-(orgUnitId)-quizzes-(quizId)-attempts-.