Blackboard Gradebook Issues

Blackboard Learn Grade Center How To's

How do I format the Learn PeopleSoft ID column to upload to PeopleSoft?

The PeopleSoft ID contains 7 digits. When the downloaded gradebook is opened in Microsoft Excel, the leading zeroes in the student IDs are sometimes lost making the ID shorter than 7 digits. In order to be uploaded into the gradebook or into PeopleSoft, the leading zeroes are needed to make the ID 7 digits.

If the leading zeroes are missing, when you try to upload a file to the gradebook, you will get this error message:

“Failed to import the following row(s) due to User Not Enrolled in Section.”

To avoid this problem, follow these steps to download the gradebook.

  1. In your course, go to the Teach tab
  2. Under Instructor Tools, click on Grade Book
  3. Click on Export to Spreadsheet
    • Specify Columns to Export
    • Specify as Tab-delimited
    • Specify Character Set as Unicode(UTF-8)
    • Click on Export
  4. Rename the file while keeping the .txt extension and save it on your computer.

To access this .txt file later, follow these steps.

  1. Start Excel
  2. Go to File and Open
  3. Select the .txt file from your computer
  4. In the Text Import Wizard, select Delimited and click Next
  5. Under Delimiters, check Tab and click Next
  6. Click the top of User ID column to highlight it
  7. Under the Column data format, select Text
  8. Click Finish
  9. Make changes to grades, and save as a .txt file. When prompted to replace the existing file, click Yes.
  10. If you want to re-open the file in Excel, go back to step 2 to preserve the leading zeroes.
  11. When importing into the Blackboard Grade Book, browse for the updated .txt file. Make sure that TAB is selected as the separator.

If you have already downloaded the file and lost the leading zeroes, follow these steps.

  1. Open the file in Excel
  2. Highlight the column containing PeopleSoft IDs
  3. Right click and select Format Cells...
  4. On the Number tab, under Category, scroll to the bottom of the list and select Custom
  5. In the Type box, enter 7 zeroes as 0000000
  6. Click OK
  7. Save the file
  8. Make changes to grades, and save as a .txt file. When prompted to replace the existing file, click Yes.
  9. When importing into the Blackboard Grade Book, browse for the updated .txt file. Make sure that TAB is selected as the separator.

To load grades into PeopleSoft from the Blackboard Learn Grade Center, you will need to remove the h at the end of the number.

  1. Open the file in Excel
  2. Highlight the column containing PeopleSoft IDs
  3. Press CTRL+F and click on the Replace tab
  4. For Find What, enter the letter h.
  5. For Replace with, leave blank.
  6. Click on Replace All.
  7. If you have lost the leading zeroes, follow the steps above to replace them.