Grades | How to import grades to Brightspace from Digital Examination (ANS)
Importing grades into Brightspace needs to be done through a .csv file with specific formatting. The export from ANS can be done in an excel but not with the formatting that Brightspace requires. Therefore, in this article you will find a step-by-step guide and a template file we prepared to assist you in this process.
This article will show you how to:
Prepare the files
To start you need to:
1. Download the Excel file from Digital Examination (ANS)
- Follow the step-by-step instructions on this Exporting results from Ans document
- Select Student ID on the Export results section. Student Name and E-mail are optional
- Click Export
We will refer to this file as the "ANS File".
The export will be sent to you by e-mail.
2. Download a file from Brightspace
- Create a Grade Item in the Gradebook in Brightspace for your Digital Examination (ANS) grade
- Export the Excel file from the Brightspace Gradebook as a template for the correct Brightspace settings
- Select only the corresponding Grade Item you created in step 4
- Click on Export to CSV
We will refer to this file as the "Brightspace File".
3. Download our Grades Transfer Template Excel
Click the link below to download our template file:
We will refer to this file as the "Transfer File".
Add data to the Transfer Template
Open the Brightspace File and:
- Copy the complete list, including the titles for the columns
Open the Transfer File and:
- Go to the first worksheet tab (1 Brightspace Export)
- Paste the rows you copied in step 8, including the titles. To do so, click on the A1 cell and then Ctrl+V
Open the ANS File and:
- Copy (at least) the columns Student ID, Mark and Points. If you selected the Student Name and Email when exporting from ANS you can also copy them.

Go back to the Transfer File and:
- Go to the second worksheet tab (2 Ans)
- Paste the rows you copied in step 11. If you did not select Student Name and Email when exporting from ANS, you can leave these columns empty

Save the document as a .csv file
In the Transfer File:
- Click on the third tab (3 Brightspace import)
- Select all the rows under the last student (click on the row number and press Ctrl + Shift + Down arrow)
- Right-click on these selected extra rows
- Delete them (these contain formulas that would cause problems when importing the file into Brightspace)
If your file has more than 500 students, you will need to drag the formulas on the 3 Brightspace Import tab down to match the number of students in your course
Then, save the document by clicking on File and:
- Click on Save As
- Select the type of file "CSV (Comma delimited) (*.csv)"
- Click on Save
- On the pop-up window, click on Ok
Finally, your file is ready to be imported into Brightspace.
Import the .csv file into Brightspace
Click on this link to see how to import grades in Brightspace:
Now you know how to import grades to Brightspace from Digital Examination (ANS)!
Related topics
Want to know more about Grades in Brightspace?
Please visit:
0 Comments
Add your comment