Some scenarios may require importing grades into your course. These situations might occur when you cannot view all students in your gradebook or when you need to upload grades from the Vector Reports, such as those used in IDS 1100 courses.
It is recommended to create a backup of the CSV file you will generate in the following steps. If you are updating an existing grade item with grades, you can refer to the CSV if mistakes occur.
- From the course navbar, click Grades. Then, click the Manage Grades tab. If you are preparing to import specialized reports, such as Vector Reports, you will need to create a new grade item. To do this, click the New button and then select Item, which will allow you to configure the gradebook item according to your specific requirements and preferences. In this example, an item named "Sample Import Item" is created in the gradebook.
- From the “Grades” page of your course, click the Enter Grades tab. Next, click the Export button to generate a CSV.
- From the "Export Grades" page, configure the CSV file to specify the grade item or items you intend to update. For the “Key Field” option, it is recommended to select Both for the student ID number and username. When selecting the “Grade Value,” choose the Points Grade option. For the “User Detail” section, select all available fields to help identify students.
- Under the "Choose Grades to Export" header, locate the grade item you wish to add or modify and then click the Export to CSV button. When preparing to export the selected item, it is important to use the CSV export option rather than the "Export to Excel" button, as Brightspace does not support XLSX file imports.
- After initiating the export, a progress page will appear, indicating when the CSV file is ready for download. Click the Download button to retrieve the file. It is recommended to save a second copy for backup purposes, particularly when updating an existing graded item.
- Open the CSV and locate the column with the header name corresponding to the grade item you intend to update. Enter the desired point total for each student, leaving blank the cells for students whose grades should remain unchanged, such as the user tspartan01 in the below example. It is important to modify only the specific grade item column intended for update; changing other columns will result in an import failure.
- After updating the grade item or items with the point values, save the CSV file.
- Next, navigate to the Enter Grades tab within your gradebook, select the Import button, and then click the Choose File button on the subsequent "Import Grades" page to initiate the file selection process.
- Upload your CSV.
- The "Item Creation" option can remain unselected, as the gradebook item was previously created during step one. Click Continue.
- The subsequent page displays potential errors and warnings; however, if only point values were updated for an existing assignment, no errors should occur.
- The next page provides an overview of the import changes, allowing for a final review before completion. (Compare the step 6 image with the step 12 image. Both match, but note that the user, tspartan01, is not included in the image below; this is because the grade is not changing). After reviewing the import preview and confirming that the grades align with your intended changes, click the Import button.
- Upon completion of the import process, you will be redirected to the "Enter Grades" page within your gradebook.
- The grades are successfully imported into the course.