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.
    Screenshot of 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
      Image shows highlighting row 1 of Excel spreadsheet.
    • Right-click on Row 1 and choose “Format Cells.”
      Image shows format cells option in Excel.
    • On the Alignment tab, change degrees to 90. Then click “OK.”
      Image shows 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.
      Image shows Grade item names.
    • From the Home tab, click Find & Select in the ribbon and then select Replace.
      Image shows 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.
      Image shows find and replace dialog box.
    • 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.
      Image displays A1 field of Excel spreadsheet.
    • From the Home tab, click Format as Table and select a style.
      Image shows table formatting in Excel.
    • A dialog box will appear. Click OK.
      Image shows table format properties in Excel.
    • 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.
      Image shows sorting table 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
    Image 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
    Image 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.
    Image 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.