Importing Grades — Uploading the File

import-1.png

Print Friendly, PDF & Email

To learn more about importing grades into D2L, view the following instructional video:  Grades Instructional Videos

IMPORTANT NOTE: Only Numeric, Pass/​Fail, Selectbox, and Text grade items, and the Final Adjusted Grade can be imported. The Final Calculated Grade will automatically be updated based on the imported grade data.

  1. From the top, right-​hand corner of the screen on the Navigation Bar, select Grades.
  2. Select Enter Grades.
  3. Select Import.
  4. Select Choose File (Safari and Chrome) or Browse (Firefox and IE).
  5. Navigate to the .CSV or .TXT File you wish to upload. Note: Only .CSV and .TXT file types are accepted.
  6. Select Open (PC) or Choose (Mac).
  7. Select the Checkbox next to Create new grade item when an unrecognized item is referenced”.
  8. Select Continue.
    import-1.png
  9. Review the New Grade Items to be created. Select the type of grade item to create (Numeric, Pass/​Fail, Selectbox, or Text).

    NOTE: If you have columns in your gradebook import file that you do not want created in this step, uncheck the box for that item in the Create New Grade Item column.

  10. Select Continue.
    import-2.png
  11. For each new grade item, select a Grades Category, enter the Maximum Points and select if the item Can Exceed the maximum points and if it is a Bonus (extra credit) grade item.

    NOTE: If you have created grade categories, you will select the category for each new grade item in this step.

  12. Select Continue.
    import-3.png
  13. Make Note of any Errors that are reported. If errors are detected, you may need to: 
    • Cancel the import process and edit the import file.
    • Correct any errors in the gradebook in D2L after the import process is completed.
    • Select Go Back to return to the previous step and edit the individual grade item information.
  14. If no errors occurred, select Continue.
    import-4.png
  15. Review the Gradebook Data to be imported.
  16. Select Import.
    import-5.png
  17. You will automatically be taken to the Enter Grades screen in the D2L Grades area.

NOTE: For instructions on manually entering/​modifying grades for existing grade items, please visit:



Come visit the eLearning team in TLC 427 for assistance.
If you are unable to visit in person, please contact us by email
at lcc_​elearning@​lcc.​edu, or by phone at (517) 4831839.

  • Was this Helpful ?
  • yes   no