Importing Grades from Opscan into
Blackboard Vista

You can now upload grades from Optical Mark Reading (Opscan) into your Blackboard Vista course.

This is a five step process:

  1. Save the Excel file you receive from Opscan as a Comma Delimited .CSV file.
    NOTE: Make sure that the Total_Points column contains the data you want to upload. If the column does not contain the correct values, call the Help Center at 7-3100.
  2. Export your Blackboard Vista Grade Book as a Comma Delimited .CSV file.
  3. Open the web site for the conversion. The web address is:
    https://its-fctel01.uncc.edu/opscan/convert_opscan.php
    Upload both files into the Convert Opscan Results for Blackboard script.
  4. Save the combined file as a Comma Delimited .CSV file.
  5. Upload the new Comma Delimited .CSV file into Blackboard Vista.

Note: The following situations will require that you manually enter grades:

  1. Students with duplicate first and last names will not be included in the resulting Excel file. For example, you have two students with the name John Smith, their grades will not be converted. You need to manually add their grades into the Blackboard Vista Grade Book.
  2. If no match is found for a studnets first and last name, he or she will not be included in the resulting Excel file. You need to manually add that grade into the Blackboard Vista Grade Book.

Step 1: The Opscan Excel File

You received two files from Opscan, an Adobe Acrobat Reader file, .PDF, and an Excel file, .XLS. You will only work with the .XLS file during this process.

  1. Open the Excel file you received from Opscan (not illustrated).
  2. Save the file as a Comma Delimited .CSV file.
    If you are using Office 2003, choose File, Save As. The Save As dialog box is displayed.
    If you are using Office 2007, click the Office button and choose Save As. The Save As dialog box is displayed.
  3. In the "Save as type" drop-down list, select CSV (Comma delimited) (*.csv)
  4. Click Save. The Microsoft Office Excel warning box is displayed.
  5. Click OK. A second Microsoft Office Excel warning box is displayed.




  6. Click Yes. The spreadsheet is displayed.
    NOTE: Make sure that the Total_Points column contains the data you want to upload into Blackboard Vista. If the column does not contain the correct values, call the Help Center at 7-3100.
  7. Close the file. A Microsoft Office Excel warning box is displayed.
  8. Click No. The file closes.


 

Step 2: Export the Blackboard Vista Grade Book

Next, log into your Blackboard Vista course and open the Grade Book.

  1. In the Grade Book, select the Members tab.
  2. Click Export to Spreadsheet. The Export to Spreadsheet screen is displayed.






  3. Keep all the default settings and click Export. The File Download dialog box is displayed.





















  4. Click Save. The Save As dialog box is displayed.














  5. In the "Save in" drop-down list, select the folder where you want to save the file.
  6. In the "File name" text box, type a name for the file.
    Note: The file will be saved as a Comma Delimited .CSV file.
  7. Click Save.







  8. If the File Download dialog box is displayed, click Close (not illustrated). The Export to Spreadsheet screen is displayed.
  9. Click Cancel to return to the Grade Book (not illustrated).

Step 3: Add a Column

If you want to use this quiz grade in a calculation, you must ensure that it is a numeric column.

  1. Select the Grades tab (not illustrated).
  2. Click the Create Column ActionLinks drop-down list (not illustrated).
  3. Select Numeric. The Numeric Column screen is displayed (not illustrated).
  4. In the "Column label" text box, type a name for the column.
  5. In the "Alignment" drop-down list, select the alignment for the column.
  6. In the "Decimals" drop-down list, select the number of decimals for the column.
  7. In the "Maximum value" text box, type the maximum grade a student can receive.
  8. Click Save. The column is created and positioned at the end of the table.

Step 4: Use the Script

Once the two Comma Delimited .CSV files are created, you are ready to use the script.

  1. Click here to open the script link. The Convert Opscan Results for Blackboard screen is displayed.
  2. In the "NinerNET ID" and "Password" text boxes, enter your NinerNET credentials.
  3. Click Login. A screen to upload files is displayed.







  4. Next to the "Choose the opscan results as a CSV file" text box, click Browse. The Choose File dialog box is displayed.








  5. In the "Look in" drop-down list, navigate to the folder where you saved the Opscan Comma Delimited .CSV file.
  6. In the file area, select the file.
  7. Click Open. The screen to upload files is displayed.












  8. Next to the "Choose your roster as a csv file" text box, click Browse. The Choose File dialog box is displayed.








  9. In the "Look in" drop-down list, navigate to the folder where you saved the Blackboard Vista Comma Delimited .CSV file.
  10. In the file area, select the file.
  11. Click Open. The screen to upload files is displayed.













  12. Click Upload Files. The results screen is displayed.






  13. Click the here link to display the results screen.





  14. Click Open. The results file is opened (not illustrated). NOTE: The column with the test results is named "Score."
  15. Rename the column with the column name you created in Step 3 (not illustrated).
  16. Save the file as a Comma Delimited .CSV file (not illustrated).
    If you are using Office 2003, choose File, Save As. The Save As dialog box is displayed.
    If you are using Office 2007, click the Office button and choose Save As. The Save As dialog box is displayed.
  17. In the "Save in" drop-down list, navigate to the folder where you want to save the file (not illustrated).
  18. In the "File name" text box, type the name of the file (not illustrated).
  19. Verify that the "Save as type" drop-down list is set to CSV (Comma delimited) (*.csv) (not illustrated).
  20. Click Save. The file is saved to the folder you specified (not illustrated).
  21. Close the file (not illustrated). A Microsoft Office Excel warning dialog box is displayed.
  22. Click Yes (not illustrated) . Another Microsoft Office Excel warning dialog box is displayed.
  23. Click No (not illustrated). The file is closed.


Step 5: Upload the Combined File into Blackboard Vista

Now that you have the quiz grades in a Comma Delimited .CSV file, you can upload it into Blackboard Vista.

  1. Access your Blackboard Vista Grade Book (not illustrated).
  2. If necessary, select the Grades tab.
  3. Click Import from Spreadsheet. The Import File screen is displayed.










  4. Click Browse (not illustrated). The Choose File dialog box is displayed.

  5. In the "Look in" drop-down list, navigate to the folder where you saved your Comma Delimited .CSV file.
  6. Select the file you want to upload.
  7. Click Open. The Blackboard Vista Import File screen is displayed.










  8. In the "Separator" drop-down list, verify that Comma is selected.
  9. In the "Select Character Set" drop-down list, verify that Unicode (UTF - 8) is selected.
  10. Click Upload. The Import File screen is displayed.









  11. Click Import. The data is imported.










  12. The columns not imported are displayed. Click OK (not illustrated).


  13. The new grades are in your Grade Book.




 
Page Maintained By: ctl@uncc.edu

Your screens may look different depending upon your configuration.

University of North Carolina at Charlotte