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)

  1. Follow the step-by-step instructions on this Exporting results from Ans document
  2. Select Student ID on the Export results section. Student Name and E-mail are optional
  3. 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

  1. Create a Grade Item in the Gradebook in Brightspace for your Digital Examination (ANS) grade
  2. Export the Excel file from the Brightspace Gradebook as a template for the correct Brightspace settings
  3. Select only the corresponding Grade Item you created in step 4
  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:

Grades_ANS_to_BS_Transfer_Template.xlsx

We will refer to this file as the "Transfer File".

Add data to the Transfer Template

Open the Brightspace File and:

  1. Copy the complete list, including the titles for the columns

Open the Transfer File and:

  1. Go to the first worksheet tab (1 Brightspace Export)
  2. 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:

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

  1. Go to the second worksheet tab (2 Ans)
  2. 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:

  1. Go to the third tab (3 Brightspace import)
  2. Select all the rows under the last student (click on the row number and press Ctrl + Shift + Down arrow)
  1. Right-click on these selected extra rows
  2. Click on Delete (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:

  1. Click on Save As
  2. Select the type of file "CSV (Comma delimited) (*.csv)"
  3. Click on Save
  4. On the pop-up window, click on Ok

Finally, your file is ready to be imported into Brightspace.

Import the .csv file into Brightspace

Import the Template file you prepared in the previous section following this other article: How to Import Grades into the Gradebook

 

Now you know how to import grades to Brightspace from Digital Examination (ANS)!

Want to know more about Grades in Brightspace?

Please visit: 

0 Comments

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.