Instructors can manage grades offline in a spreadsheet and then import the file to update the course Gradebook. An offline file in the proper import format can be used as a method for quickly creating several Gradebook items at once.
To obtain a file in the proper import format, export the Gradebook and use that file as a template. This way, the file will contain all of the student information in your site, as well as any existing Gradebook item data in your site.
NOTE: Only graded items that have been created within the Gradebook can be updated. Graded items that come from other tools, such as Assignments or Tests & Quizzes, cannot be updated via file import.
Go to Gradebook.
Select Gradebook from the Tool Menu.
Select Import/Export.
Select Import/Export from the actions menu.
Select Export Gradebook.
Select the Export Gradebook button.
The export will download as a .csv file.
The file will download in your browser as a .csv file.
Open the file in your preferred spreadsheet application.
Open the file in your preferred spreadsheet application, such as Microsoft Excel.
Add columns, grades, or feedback as needed, and save your file.
The import file must be in .csv file format. Also, be sure to use the following conventions:
- Student ID and Student Name are the first two columns and must be retained for any future imports.
- Gradebook Items/Assignments may include points by wrapping the points in [ ] after the title (e.g., Assignment 1 [50]).
- Comments can be imported by prefixing the column with a * (e.g., * Assignment 1).
- Columns that cannot be re-imported are prefixed with #.
NOTE: New items may be added to the gradebook by including new columns in the .csv file. If any new columns are added 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.
Select the Browse button to select your .csv file for import.
Choose the file and select Continue.
Select Continue.
After choosing the .csv file from your computer, the file name will appear to the right of the Browse button (highlighted for emphasis). Select Continue.
For more information on importing grade items into Gradebook, see How do I import grades into Gradebook?