File format for importing grades

The import file must follow a standard format. We recommend that you set up your grade book in iLearn Learning Environment even if you want to enter grades in a CSV or TXT file. That way, you can use the Export Grades option to create an appropriately structured file.

The file format is as follows:

Field

Description

Example

Username

A unique name for identifying a user in iLearn Learning Environment.

You must provide a username or org defined ID (or both).

Frank.Catcher

Org Defined ID

A unique number for identifying a user in iLearn Learning Environment.

You must provide a username or org defined ID (or both).

20067930

<Item> Points Grade

Numeric and Pass/Fail grade items should be labeled the grade item name followed by Points Grade.

Users' grades should be the Points Grade the learner received.

For example, 44 points out of a possible 50 points.

44

<Item> Grade Symbol

Select box grade items should be labeled the grade item name followed by Grade Symbol.

Users' grades should be a pre-existing grade scheme symbol.

For example, Very Good, Merit, or 3.5.

Very Good

<Item> Text Grade

Text grade items should be labeled the grade item name followed by Text Grade.

Users' grades can be any text value. Text grade items do not count towards users' final grades.

Perfect Attendance!

Adjusted Final Grade Numerator

The total points a user achieved in a course. You can enter a user's percentage grade (without the % sign) if you enter the denominator as 100.

For example, 84 points out of 100 points or 230 points out of 285 points.

84

Adjusted Final Grade Denominator

 

 

The total possible points available in a course. Enter 100 if you want to record users' percentage grades.

For example, _ / 100 points available or _ / 285 points available.

100

End-of-Line Indicator

The last column must be labeled End-of-Line Indicator so the system knows when the next set of data begins.

The end of each users' line should be indicated with the pound key #.

#

NOTES

  • If you enter a grade value that is greater than the value for the grade item, the grade is capped at the value unless you select the Can Exceed check box when setting up the grade item.
  • Do not import other options, such as a user's first name, email, or weighted grade.
  • To improve performance when importing grades for large classes, only import grade items that have changed and import by group or section when possible.