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.
Select the Gradebook tool from the Tool Menu of your site.
The import file must be in .csv file format. Also, be sure to use the following conventions:
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.
For more information on importing your items into Gradebook, see How do I import grades into Gradebook?