Skip navigation, view page content (access key = C)

Begin OSU masthead and toolbar

The Ohio State University
www.osu.edu
  1. Help
  2. Campus map
  3. Find people
  4. Webmail

Ohio State University logo Office of Information Technology Technology Support Center (8help)

Carmen: Import or Export Grades [Instructor]



Import Grades:

You can import grades to your Carmen course from a well-formatted CSV (comma-separated values) file. Each files must be separated by a comma and each row by a line break. The first row in the files defines the grade items to import and the remaining rows contain the actual values; for example:

StudentId,Username,Assignment 1 Out of Grade,Assignment 2 Out of Grade
[blank],student.1,B,A
[blank],student.2,C,C
etc.

To import the CSV file:

  1. Log into Carmen as an instructor or other role that allows you to work with grades.
  2. Access the Grades tool.
  3. From the main "Grades List" page, click Import/Export button .
  4. The "Grades: Import/Export" page appears.
  5. Select Import into Grades from CSV.
  6. Click Browse button to select the CSV file to upload.
  7. Choose one of the following options.

    • Click Preview Import button to check your file for proper formatting and any errors before you copy it to your gradebook.

    • Click Express Import button to bypass error checking and proceed with uploading the file.

Note: This process may take a while for large classes.

If this process fails for any reason, please make certain your CSV file follows the format as laid out in Knowledge Base solution #2762

Export Grades:

In addition to importing grades, you also can export grades from your Carmen course to a CSV (comma-separated values) file. The first row of the exported file consists of header information for all the fields. The first field of the second and all successive rows will be each user's identifying key fields: StudentId and Username. The remaining data fields are dependent on the options you select.

To export grades to a CSV file:

  1. Log into Carmen as an instructor or other role that allows you to work with grades.
  2. Access the Grades tool.
  3. From the main "Grades List" page, click Import/Export button .
  4. The "Grades: Import/Export" page appears.
  5. Select Export to CSV from Grades.
  6. Choose which key field to export for each user: always choose Both.
  7. Choose the option for grade values to export for each user: 'Points' Grade, or 'Weighted' Grade. Avoid using Grade Scheme for Item, as it does not re-import.
  8. Choose what optional user detail fields to include: Last Name, First Name, or Email.
  9. Check the grade items to include from the list at the bottom of the page. It is best to always select Adjusted Final Grade to catch the final "#" that Carmen pastes to the end of every row.
  10. Click Export button .

Note: You also have the option of exporting grades for a single group of users (assuming you have your students divided into groups). To do this, select the desired group from the "Grades List" page and then complete Steps 3-10 above.

Get more help on this topic: Gradebook Overview



Current Record: 2368

Create Date: 03-21-2005
Last Reviewed: 06-06-2006
Please give us your feedback!
Was this document helpful?  




Home

 

return to top