Print Grades

Exporting grades to Excel allows you to print the Grades data legibly on as few pages as possible. There are various ways the grades export spreadsheet might be formatted. This article provides one example.

Exporting D2L Gradebook to Excel

  1. Select the course in D2L.
  2. Click Grades in the navbar.
  3. From Enter Grades, click on Export.
    Indicates Export option on Enter Grades page
  4. See Export Grades for more information.

Formatting the Exported D2L Gradebook from Excel

  1. Format Column Headings
    • Highlight Row 1
      Indicates highlighting row 1 of Excel spreadsheet.
    • Right-click on Row 1 and choose “Format Cells.”
      Identifies format cells option in Excel.
    • On the Alignment tab, change degrees to 90. Then click “OK.”
      Identifies cell alignment formatting options in Excel.
  2. Shorten the names so the header row is not too high.
    • In our example, we will remove "Scheme Symbol" from the column headers.
      IdentifiesGrade item names.
    • From the Home tab, click Find & Select in the ribbon and then select Replace.
      Identifies Find & Replace function in Excel.
    • On the Replace tab, enter the text you want to replace and leave the "Replace with:" field blank.
    • Click Replace All.
      Indicates find and replace dialog box and Identifies Replace All button
    • Click Close.
  3. Arrange spreadsheet in alphabetical order.
    • Click on field A1 in the top left of the spreadsheet and click "CTRL + A" to highlight all of the data.
      Identifies A1 field of Excel spreadsheet.
    • From the Home tab, click Format as Table and select a style.
      Indicates table formatting button in Excel and Identifies chosen table format.
    • A dialog box will appear. Click OK.
      Identifies OK button
    • Text in column header row can be centered and the columns can be made more narrow for easier legibility.
    • Use the dropdown in whichever column you wish to sort by and select Sort A to Z.
      Identifies sorting table & Indicates  data by last name.

Printing the Exported D2L Gradebook from Excel

  1. Select the Page Layout tab. 
  2. Click on Margins and set to Narrow
  3. Click on Orientation and select “Landscape.”
  4. Click on Print Titles. Click on Header/Footer tab. Then click on [Custom Header] button
  5. Enter your Name, Course Number and Course Section Number and semester in the Left Section and click [OK] to save changes.
  6. Click on Sheet tab
  7. Click on the icon for Rows to Repeat at Top
    Shows location for adding repeating rows at top of spreadsheet in Excel.
    Click on Row to highlight the row. The selected row information will appear in the Page Setup – Rows to repeat at top box. Click on the red arrow to close and save the selection.
  8. Click on the icon for Columns to Repeat at Left
    Shows location to repeat columns on left of spreadsheet.
    Click on Columns A, B, and C to highlight the columns. The selected columns information will appear in the Page Setup – Columns to repeat at left box. Click on the red arrow to close and save the selection.
    Shows rows and columns repeating settings.
  9. Click OK.
  10. Save the Gradebook to your computer and print copies as needed.
NOTE: Some departments allow emailing of a PDF. If this is the case in your department, select the option to Save As, PDF.