Difference between revisions of "Format my file for importing grades into Gradebook"
(Created page with "{{Template:Rubrics}} Category:Rubrics Category:Gradebook Category:Instructor Category:Sakai 19 {{Template:Sakai Community Documentation}}") |
|||
| Line 1: | Line 1: | ||
| + | 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'''== | ||
| + | [[File:Go to Gradebook.png|frame|center]] | ||
| + | |||
| + | Select '''Gradebook''' from the Tool Menu in your site. | ||
| + | |||
| + | ==Click '''Import/Export'''== | ||
| + | [[File:Click_ImportExport..png|frame|center]] | ||
| + | |||
| + | ==Click Export Gradebook== | ||
| + | [[File:Click Export Gradebook.png|frame|center]] | ||
| + | |||
| + | ==The export will download as a .csv file== | ||
| + | [[File:The export will download as a .csv file.png|frame|center]] | ||
| + | |||
| + | ==Open the file in your preferred spreadsheet application== | ||
| + | [[File:Open the file in your preferred spreadsheet application.png|frame|center]] | ||
| + | |||
| + | ==Open the file in your preferred spreadsheet application== | ||
| + | [[File:Open_the_file_in_your_preferred_spreadsheet_application.png|frame|center]] | ||
| + | |||
| + | ==Add columns, grades, and/or feedback as needed, and save your file== | ||
| + | [[File:Add columns, grades, and-or feedback as needed, and save your file.png|frame|center]] | ||
| + | |||
| + | 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: 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== | ||
| + | [[File:Return to Gradebook - Import-Export to browse for and select your import file.png|frame|center]] | ||
| + | |||
| + | For more information on importing your items into Gradebook, see Import grades into Gradebook. | ||
| + | |||
{{Template:Rubrics}} | {{Template:Rubrics}} | ||
[[Category:Rubrics]] | [[Category:Rubrics]] | ||
Revision as of 18:25, 27 July 2020
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.
Contents
- 1 Go to Gradebook
- 2 Click Import/Export
- 3 Click Export Gradebook
- 4 The export will download as a .csv file
- 5 Open the file in your preferred spreadsheet application
- 6 Open the file in your preferred spreadsheet application
- 7 Add columns, grades, and/or feedback as needed, and save your file
- 8 Return to Gradebook > Import/Export to browse for and select your import file
- 9 More questions about the Rubrics tool?
Go to Gradebook
Select Gradebook from the Tool Menu in your site.
Click Import/Export
Click Export Gradebook
The export will download as a .csv file
Open the file in your preferred spreadsheet application
Open the file in your preferred spreadsheet application
Add columns, grades, and/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: 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
For more information on importing your items into Gradebook, see Import grades into Gradebook.
More questions about the Rubrics tool?
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
