Format my file for importing grades into Gradebook

From EdTech Help

Instructors can manage grades offline in a spreadsheet and then import the file to update the course Gradebook. You can also import a file as a method for quickly creating several gradebook items at once.

The easiest way to obtain a file in the proper import format is to export your Gradebook and use that file as a template. This way it will contain all of the student information in your site, as well as any existing gradebook item information in your site.

Note: You can only update graded items that have been created within the Gradebook. Graded items that come from other tools, such as Assignments or Tests & Quizzes, cannot be updated via file import.

Go to Gradebook

Go to Gradebook.png

Select Gradebook from the Tool Menu in your site.

Click Import/Export

Click ImportExport..png

Click Export Gradebook

Click Export Gradebook.png

The export will download as a .csv file

The export will download as a .csv file.png

Open the file in your preferred spreadsheet application

Open the file in your preferred spreadsheet application.png

Open the file in your preferred spreadsheet application

Open the file in your preferred spreadsheet application.png

Add columns, grades, and/or feedback as needed, and save your file

Add columns, grades, and-or feedback as needed, and save your file.png

The import file must be in .csv file format. Also, be sure to use the following conventions:

  1. Student ID and Student Name are the first two columns and must be retained for any future imports.
  2. Gradebook Items/Assignments may include points by wrapping the points in [ ] after the title, e.g. "Assignment 1 [50]".
  3. Comments can be imported by prefixing the column with a *, e.g. "* Assignment 1".
  4. Columns that cannot be re-imported are prefixed with #.

Note: You may add new items to the gradebook by including new columns in your file. If you add any new columns without a point value in brackets, Sakai will prompt you to indicate the number of points upon import.

Return to Gradebook > Import/Export to browse for and select your import file

Return to Gradebook - Import-Export to browse for and select your import file.png

For more information on importing your items into Gradebook, see Import grades into Gradebook.

More questions about the Rubrics tool?


Sakai.png

This page is adapted from an equivalent Sakai Community help article.

The original Sakai Community help article, unedited, is available at https://sakai.screenstepslive.com/s/sakai_help