Importing Grades — Preparing the File


Print Friendly, PDF & Email

NOTE: Grade Categories must be created within D2L. If you wish to have your grade items organized into categories, it is recommended that you create the Grade Categories prior to importing. For instructions on creating Grade Categories, please visit Creating Grade Categories and Items.


Working from a spreadsheet file, such as Excel, follow the steps below:

  1. Column 1: OrgDefinedID (The Student’s Banner or X Number)
  2. Column 2: Username

    NOTE: Files can be imported using OrgDefinedID and/​​or Username columns. Only one column is required.

  3. Grade Item Columns should contain the name of the item followed by:
    • For Numeric or Pass/​​Fail Grade Items — Points Grade (Example: Essay 1 Points Grade)
    • For Selectbox Grade Items — Grade Symbol (Example: Essay 1 Grade Symbol)
    • For Text Grade Items — Text Grade (Example: Comments Text Grade)
      Grade item columns
  4. If using the Final Adjusted Grade (Not Required), the following columns should be included:
    • Adjusted Final Grade Numerator
    • Adjusted Final Grade Denominator
  5. The LAST column must be called End-​​of-​​Line Indicator and the value for each row in that column must be a hash/​pound sign (#). Last column must be called End-​of-​Line Indicator with each row having a hash/pound sign (#).
  6. Files must be saved as .CSV or .TXT files.

NOTE: Only Numeric, Pass/​​Fail, Selectbox, 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. Below are sample files for Importing Grades with or without the Final Adjusted Grade Column:

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