cts horizontal line
CTS

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


import

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

import

    • 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.

import

 

Need more help? Contact the Campus Technology Services Help Desk at 406.496.4244 or by email at CTShelpdesk@mtech.edu.

Back