Montana Tech of The University of Montana
Get Into It! at Montana Tech
You are here: Montana Tech >> CTS >> crumbtrail

Moodle - 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

    importgrades

    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

importgrades

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

importgrades2

        • Click Upload grades. Grade import success is displayed.
        • Click Continue. The Grader report is displayed.

       

 

 

Campus Technology Services
ctshelpdesk@mtech.edu
406.496.4244



© Montana Tech • All Rights Reserved
Montana Tech of The University of Montana • 1300 West Park Street
Butte, MT 59701 • 800-445-Tech • Contact Montana Tech