For the complete documentation index, see llms.txt. This page is also available as Markdown.

4. Uploading Quiz Attempts

Export a quiz’s Attempt Details report from Brightspace as a CSV and upload it to bring students’ attempts into TimelyGrader.

The quiz and its questions come across when you import it, but Brightspace doesn’t let TimelyGrader import students’ attempts. Instead, you export an Attempt Details report from Brightspace as a CSV and upload it to the quiz in TimelyGrader. The file brings in each student’s answers, and TimelyGrader matches every row to a student and question for you.

The upload has four steps: Before you import, Export, Upload and Check. You set up the report in Brightspace once per quiz; after that, you only export and upload.

Starting the upload

1

Open the quiz

On the Quizzes page, click the quiz. Until you upload, its status line reads No submissions uploaded.

2

Click Upload Submissions

In the right sidebar, under Final Submission Grading & Feedback, click Upload Submissions. The Upload Submissions from Brightspace dialog opens on Before you import. Cancel closes it without changing anything.

Step 1: Set up the report in Brightspace

Create this report once per quiz, then export it whenever you want to bring in attempts. In Brightspace:

1

Open Setup Reports

Open your Brightspace course and go to Quizzes. Click the dropdown arrow next to the quiz and select Setup Reports, then click Add Report.

2

Name the report

Enter a name, such as TG Attempt Details.

3

Choose Attempt Details

Under Report Type, select Attempt Details. This includes student identifiers and their answer to each question, by attempt.

4

Include the Org Defined ID

Turn on Include Org Defined ID. This gives TimelyGrader a second way to match students. Attempt duration is optional.

5

Release the report to yourself

Set the release time to Immediately. Under Release Report To, select Instructor, or the role you use in this course.

6

Save

Click Save, then Save and Close if it shows. Back in TimelyGrader, click I’ve set it up.

You only do this once per quiz. Next time, start from Export.

Step 2: Export the CSV

Do this once students have submitted. You can repeat it later to bring in new attempts. In Brightspace:

1

Open the report

In Quizzes, open the quiz’s dropdown and select View Reports, then click TG Attempt Details.

2

Choose the date range

Set From and To dates if you only want a date range. Leave them blank to export every attempt.

3

Generate and download the CSV

Click Generate CSV. When it finishes, open the bell (Updates), select Export finished, and download the file. Back in TimelyGrader, click I’ve downloaded the CSV.

Export step of the Upload Submissions from Brightspace window

The file is named after your report, for example TG Attempt Details.csv.

Step 3: Upload the CSV

1

Choose the file

Click Choose the CSV file and select the file you downloaded from Brightspace. Only a .csv file is accepted. To pick a different file, click the file name again.

2

Click Upload

Click Upload. It stays disabled until you’ve chosen a file. Students are matched by Org Defined ID, then by name.

Step 4: Check before importing

1

Wait for the check

TimelyGrader reads the file and matches students and questions, showing its progress.

2

Review the summary

Check before importing shows:

  • Submissions in file

  • Students matched, out of the students in the roster

  • Questions found

  • Already imported (skipped)

If every row matched, it says Every row matched a student. Otherwise it lists the rows that couldn’t be matched, with the reason for each.

Check before importing summary

Rows that couldn’t be matched are skipped. Fix them in Brightspace and upload again; nothing already imported is changed.

3

Import the attempts

Click Import [number] Attempts. The dialog closes and the sidebar shows Preparing submissions… while the attempts are processed. When they’re ready, the sidebar shows the last upload (file name and number of attempts added), and Attempt Status shows how many attempts are Pending review and how many are Completed.

4

Start grading

Click Start Reviewing to open the first attempt awaiting review. See Grading a Quiz Attempt.

FAQ

It says “This file isn’t a CSV.”

Download the report again from Brightspace and upload the .csv file.

Some rows couldn’t be matched.

A row is skipped when it has no Org Defined ID and no student with that name is in the course roster. Brightspace preview attempts (for example, “Test Student”) are skipped too, because they aren’t real students. Fix the rows in Brightspace and upload again; nothing already imported changes.

Fewer students matched than I expected.

Check that Include Org Defined ID is turned on in the report setup. It gives TimelyGrader a second way to match students besides their name.

A student submitted after I uploaded.

Export the CSV again and use Upload Additional Submissions. See Uploading Additional Quiz Attempts.

An auto-graded score looks wrong.

Fix it in D2L. TimelyGrader only shows those scores, so the total on screen matches your gradebook.

Was this helpful?