Leo User Guide

Import Individual Assignment Grades into the Gradebook

Updated on

This article will show you how to upload/import a spreadsheet of grades into the Gradebook.

Step 1: Setting up spreadsheet headers
  • Row 1 should be for column headers only.
  • Header column names are: ID, Last Name, First Name, Numeric Score, Alpha Score, Comments, and Incomplete Status. The column headers are required and are case sensitive.
  • Input data staring in Row 2.

NOTE: Entering data in every column except ID,  is optional. The spreadsheet will still upload correctly if these fields are left blank - it will indicate that no grade/comment has been recorded yet.

Step 2: Prepare your spreadsheet for import

When you are ready to upload, ensure that the spreadsheet is in .csv format.

NOTE: Your spreadsheet must be in .csv format in order for the system to accept it. If you are using Microsoft Excel, click File, select Save As..., then select .csv from the Save as type: drop-down menu.

Step 3: Access the Course Gradebook

Path: Home > Courses > [Course Screen] > Assessment > Gradebook

Step 4: Locate Assignment
  1. Locate the assignment for which you would like to import grades.
  2. Click the options icon (gear wheel).
  3. Choose Import.
Step 5: Browse for .csv file
  • Click Choose File and browse for the saved .csv file.
Step 6: Select User ID Source

NOTE: You can always click individual scores in the Gradebook to edit them, even after you have uploaded a spreadsheet of scores.

Previous Article Setting Percentages in the Gradebook
Next Article Gradebook Score Entry