|
Import Grades
Rules:
1) You must have a student ID that will match a student ID in your Moodle course.
2) No commas in the spreadsheet - commas create additional rows and throws off the data. Check out the example below.
Excel spreadsheet:
StudentID |
Grade1
|
Grade 2
|
Grade/3
|
Grade4
|
Grade_5
|
Grade6
|
Grade 7 10%
|
Grade 8 25%
|
Grade 9, 50%
|
Grade 10 (25%)
|
|
799000000
|
1
|
2
|
3
|
4
|
5
|
6
|
7
|
8
|
9
|
10
|
|
799000000
|
1
|
2
|
3
|
4
|
5
|
6
|
7
|
8
|
9
|
10
|
|
799000000
|
1
|
2
|
3
|
4
|
5
|
6
|
7
|
8
|
9
|
10
|
|
799000000
|
1
|
2
|
3
|
4
|
5
|
6
|
7
|
8
|
9
|
10
|
|
799000000
|
1
|
2
|
3
|
4
|
5
|
6
|
7
|
8
|
9
|
10
|
|
799000000
|
1
|
2
|
3
|
4
|
5
|
6
|
7
|
8
|
9
|
10
|
Results in Moodle:
Import preview
StudentID |
Grade1
|
Grade 2
|
Grade/3
|
Grade4
|
Grade_5
|
Grade6
|
Grade 7 10%
|
Grade 8 25%
|
"Grade 9
|
50%"
|
Grade 10 (25%)
|
|
799000000
|
1
|
2
|
3
|
4
|
5
|
6
|
7
|
8
|
9
|
10
|
|
|
799000000
|
1
|
2
|
3
|
4
|
5
|
6
|
7
|
8
|
9
|
10
|
|
|
799000000
|
1
|
2
|
3
|
4
|
5
|
6
|
7
|
8
|
9
|
10
|
|
|
799000000
|
1
|
2
|
3
|
4
|
5
|
6
|
7
|
8
|
9
|
10
|
|
|
799000000
|
1
|
2
|
3
|
4
|
5
|
6
|
7
|
8
|
9
|
10
|
|
|
799000000
|
1
|
2
|
3
|
4
|
5
|
6
|
7
|
8
|
9
|
10
|
|
Importing Grades from Excel (.CSV format) into Moodle
- To import grades in Moodle, click Grades in the Administration block. The Grader report is displayed.
- Click Import from the Grader report tabs
-
- Click Browse. The choose file dialog box is displayed. Locate the exported grades .CSV file and click Open.
- Select UTF-8 from the Encoding drop-down menu.
- Choose Comma as the Separator if importing a .CSV file.
- From the Verbose scales drop-down menu select Yes when importing grades based on a scale that includes text (“Exceptional”, “Acceptable”, “Needs Improvement”).
- Select the number of rows to preview from the Preview rows drop-down menu.
- Click Upload grades. The Import preview is displayed.
- From the Map from drop-down menu, select StudentID (Which you must have in your spreadsheet). The student ID must be able to match to a student ID in your Moodle course.
- From the Map to drop-down menu, select useridnumber.
- In the Grade item mappings section, ignore all items except for newly created grade items or modified grade items. NOTE: For newly created grade items, select new gradeitem beside the new item. For modified grades, select the existing grade item from the drop-down list.
Need more help? Contact the Campus Technology Services Help Desk at 406.496.4244 or by email at CTShelpdesk@mtech.edu.
Back |
