Usually the gradebook allows teachers to edit students' grades by graded item or by user (student) using Single View. However, grades can also be added in bulk based on empty grades or percentage scores. This article will demonstrate the process of posting grade items to the gradebook in bulk.
1) Access your course and turn edition on.
2) On the left side of the screen, in the Administration block, click on Class Administration, then click on Gradebook Setup.
3) Assuming that you have previously specified the gradebook categories and have given them relevant weights, from the Gradebook Setup drop-down menu at the top of the screen select Export > Open Document Spreadsheet.
4) In the Grade items to be included section, you will be prompted to choose the grade items to be included in the spreadsheet. Tick those that you wish to upload the grade items for.
5) In the Export format options you can specify further file settings. In this section, you can indicate, whether you wish to include feedback in the export, exclude suspended users (i.e. only include students in the export whose enrolment is active and has not been suspended), specify the display types of the exported grades, and the decimal points of grade exports.
6) Once you have indicated all settings that apply, click on Download at the bottom of the screen, which will trigger an Excel file download.
It is best practice to import only spreadsheets that were derived from exports from the MyPlace Gradebook.
7) Open the Excel file you downloaded and insert the grades into the relevant columns and rows, corresponding with each assignment's and student's details, respectively.
Remember to save the created file in a .csv format to ensure a smooth data import.
8) Once you are finished, go back to MyPlace and from the same drop-down menu select import CSV file.
9)
