Importing and exporting grades

You can enter grades in another application and import them into Learning Environment using a CSV or TXT file. You can also create new grade items through an import file by adding a column to the file.

The import file must follow a standard format; use the Grades sample import file as a reference point. We recommend that you set up your grade book in Learning Environment even if you want to enter grades in a CSV or TXT file. You can then use the Export Grades option to create an appropriately structured file.

Table of contents

1. Grades import file format
2. Import grade items
3. Export grade items to a CSV or Excel file
4. Export grades by group or section to a CSV or Excel file

Grades import file format

Field	Description	Example
Username	A unique name for identifying a user in 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 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 they received. E.g., 44 points out of a possible 50 points.	44
<Item> Grade Symbol	Selectbox grade items should be labeled the grade item name followed by “Grade Symbol”. Users’ grades should be a pre-existing grade scheme symbol. E.g., “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. E.g., 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. E.g., _ / 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 “#”.	#
7.x legacy grade items
<Item> Out Of Grade	In the 7.x version of Learning Environment, Numeric and Pass/Fail grade items were labeled the grade item name followed by “Out Of Grade”. These grade items can still be imported.	44
<Item> Grade Symbol String	In the 7.x version of Learning Environment, Text and Selectbox grade items were labeled “<Item> Grade Symbol String”. These grade items can still be imported. If a 7.x import file contains a Selectbox grade item, you must create a new grade item to replace it.	Very Good

Back to top

Import grade items

1. On the Enter Grades page, click Import.
2. Click Browse.
3. Locate the file you want to import and click Open.
4. Select Create new grade item when an unrecognized item is referenced if you want to be able to create new grade items from the import file.
5. Click Continue.
6. If you are creating new grade items:
   1. Select the Create New Grade Item check box beside each of the items you want to create.
   2. Select a grade item Type.
   3. Click Continue.
   4. Fill in the grade items’ properties. See Creating a grade item for more information.
   5. Click Continue.
7. View error and warning messages associated with the import, and click Continue.

   Note  Fields with errors are not imported.

8. Preview your import and click Import.

Back to top

Export grade items to a CSV or Excel file

1. On the Enter Grades page, click Export.
2. Select All users from the Export Grade Items For drop-down list, as well as the Key Field you want to use to identify users.
3. Select the Grade Values and User Details you want to export.
4. Select the Grade Items you want to export.
5. Click Export to CSV or Export to Excel.
6. A pop-up window will appear. Click on your file's link to download it. Click open. Save the file to your computer.

Back to top

Export grades by group or section to a CSV or Excel file

1. On the Enter Grades page, click Export.
2. Select the group or section you want to export from the Export Grade Items For drop-down list, as well as the Key Field you want to use to identify users.
3. Select the Grade Values and User Details you want to export.
4. Select the Grade Items you want to export.
5. Click Export to CSV or Export to Excel.
6. A pop-up window will appear. Click on your file's link to download it. Click open. Save the file to your computer.

Note  Grade items that contain French characters do not display correctly in Microsoft Excel. Do not correct the characters in the CSV file if you want to import the file back into Learning Environment. Use Notepad if you want characters to display correctly.

Back to top

See also

• Creating a grade item