Q：How to Import Grades from a Spreadsheet?
Q：Excel is a software familiar to many teachers. How can grades be imported using Excel?
Preparation time
3 minutes
Difficulty
Easy
Directions
A：Teachers can batch import student grades from a spreadsheet. Below are the column specifications and operational steps:
1. Input grades in the spreadsheet with the following columns:
- username: Account
- Grade item 1: Grade
- Grade item 2: Grade
2. In the grade page, select "Import" from the dropdown menu, then choose "Paste from spreadsheet".
Path: Course Management > Gradebook setup
3. After copying the contents from the spreadsheet, paste them into the "Data" field, click "Upload grades".
4. Set the fields for "identifying users by" and "grade item mappings".
5. The import success and results screen.
Related instructional videos for this feature
