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

Yi Yan.L.782
Yi Yan.L.782 Posts: 29 Analytics Builder Transition
edited September 22 in Higher Ed / Postsecondary

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.

image.png
Tagged:

Answers

  • Vivek.V.2277
    Vivek.V.2277 Posts: 18 🤝🏼 image

    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-.