How to update marks in the existing graded item using excel?
If you already have an existing graded item and would like to update marks in the existing graded item using excel?
- Click on the graded item header box. You will see that the header box will have a blue border to indicate it has been selected. Make sure you only select one graded item.
- Click on Re-import from Excel link on the right hand side. If you cannot see the Re-import from Excel link, make sure that you only select one graded item.
Note the following when doing re-import.
Note on input marks by non-NUS user
Non-NUS users do not have access to input marks even if they are added into the module as facilitators.
From the Gradebook main page, you can either import marks from an excel file through adding a graded item (+ ADD GRADED ITEM) or by clicking the Import from Excel option. The form and process will be the same either way.
The following instruction to import graded item from an excel file will be through clicking the Import from Excel option:
- Go to your module.
- Click Gradebook.
- Click Import from Excel.
- You will need to complete the form that appear:
- Select if the Creation Type will be by Student Number or User ID.
- Download the excel template and fill in the excel file accordingly.
- Click Attach Excel File to choose and upload your excel file.
- Fill in the Item Name.
- Fill in the Maximum Marks.
- Fill in the Description if you have any.
- Fill in the Category for this graded item. As you type, you will see previously entered category (if any) which you can click to choose that existing category if it fits your graded item. If not, the category you type will have Add new category identifier on it. Click this identifier to add the new category. A graded item can only have one category.
- Set Mark Anonymously to Yes or No depending on your requirement.
- Click the GRADING SCHEMA tab.
- If you want to apply a grading schema, untick Do not apply a grading schema for this item. A Letter Grade and Mark Range as specified in Gradebook Settings will then appear. You can adjust these accordingly.
- Click the PUBLISH SETTINGS tab.
- Specify if you want the Marks, Comments, or Analytics to be published by setting them to Yes or No accordingly.
- Click DONE.
You will see that the graded item will be created as a new column in your Gradebook and the imported marks will be shown for each students.
My import fails, so what should I do?
Please try the below suggestions.
- If your excel is protected with a password, please remove it and upload again.
- If your excel is not password protected and it still fails, please download the excel template from the LumiNUS Gradebook.
Input your marks in there, and upload the excel file.