Exporting Grades from C4Elink & Importing Into Moodle

Exporting Grades from C4Elink & Importing into Moodle

If you wish to export grades from C4ELink and import them into your school's Moodle system, you can do so by following the process below.

Export Grades from C4Elink Course Site: 

1. Access the 'Gradebook' option from your course menu bar.
2. From the dropdown menu options, select 'Export' > 'Excel spreadsheet.'
3. You will be presented with a list of graded items to export. Uncheck any items that you do not wish to include in your export.
   • Notes:
     • You can choose to export grade category totals and/or specific quizzes, exams, or assignments by checking or unchecking the items.
     • By default, grades will be exported as 'Real' numbers. If desired, you can choose to adjust the export format to Percentage or Letter at the Grade export display types prompt within the Export format options section. This will depend on how you have configured your Moodle gradebook.
4. Click the 'Export' button when you are ready to export the data.

Import Grades into Moodle:

You can import grades into your Moodle system by pasting from a spreadsheet or by importing from a CSV file. Both methods will be described below.

Regardless of the approach that you choose, we recommend that you, first, export any existing Moodle grades to an excel spreasheet as a backup prior to importing any grade into your Moodle system.

Backing Up Grades in Moodle:

1. Access the course gradebook.
2. From the dropdown menu options, select 'Export' > 'Excel spreadsheet.'
3. Leave all items checked.
4. Click 'Export.'
5. Save this file on your device.

Grade Import Option 1: Paste From Spreadsheet

 Preparing New Grades for Import:

1. Verify that all user names, email addresses, and assignment titles are identical to those in your Moodle course.
2. Verify that grades to be imported do not exceed assignments' max grades.
3. Remove any blank or unnecessary columns.

 Importing Grades into Moodle: 

1. Access the Gradebook.
2. From the dropdown menu, select 'Paste from spreadsheet' under the 'Import' options.
3. From your spreadsheet, copy all rows and columns with data (making sure to include column titles:
4. Paste into the 'Data' field on C4ELink:
   
   
5. Click 'Import Grades.'
6. Review the 'Import preview' and confirm all data is displaying correctly.
7. In the 'Identify user by' pane, set both 'Map from' and 'Map to' fields to email. This will match-up and identify users based on their email addresses.
8. Below 'Grade item mappings,' map each assignment with its corresponding assignment item in C4ELink:
   
9. Click 'Upload grades.' You should see a green 'Grade import success' message. If you receive an error, you will need to review all data imported and ensure it matches the information in your C4Elink course.

Grade Import Option 2: CSV File

Preparing New Grades for Import:

The file you initially exported from C4Elink must be saved on your device as a .csv file type. Please understand that the file contents must meet very specific formatting requirements for import into your Moodle system. Please note that students' names/email addresses and assignment titles in this file must be identical to what exists in your Moodle course shell. Please note, it might be helpful to first export grades from your Moodle course (remembering to save it as a .csv file) to obtain the correct formatting.

The required columns and order are as follows:

• First Name - Must match user's first name in Moodle.
• Last Name - Must match user's last name in Moodle.
• ID number - This column can be left blank, but the column heading must be present.
• Institution - This column can be left blank, but the column heading must be present.
• Department - This column can be left blank, but the column heading must be present.
• Email address - This column will be used to map users.
• Assignments - You will need a new column for each assignment you wish to import. The title must be identical to the titles in your Moodle course.

 To prepare your .csv spreadsheet for importing, you will need to do the following:  

1. Confirm that all required columns are present and in the correct order.
2. Verify that all user names, email addresses, and assignment titles are identical to those in your Moodle course.
3. Verify that grades to be imported do not exceed assignments' max grades.
4. Remove any blank or unnecessary columns as needed, depending on which assignments you need to import grades for. For example, if you are only importing grades for a specific quiz or assignment, you may remove all other assignment columns.
5. Remove any category or course totals.

 The finalized .csv file should look similar to the following sample: 

Importing Your Modified .CSV File Into Moodle:  

1. Access the Gradebook.
2. From the dropdown menu, select 'CSV file' under the 'Import' options.
3. Drag and drop your modified .csv file.
4. Ensure the 'Comma' radial is selected.
5. Click 'Upload grades.'
6. Review the 'Import preview' and confirm all data is displaying correctly.
7. In the 'Identify user by' pane, set both 'Map from' and 'Map to' fields to email. This will match-up and identify users based on their email addresses.
8. Below 'Grade item mappings,' map each assignment with its corresponding assignment item in C4ELink:
   
   
9. Click 'Upload grades.' You should see a green 'Grade import success' message. If you receive an error, you will need to review all data imported and ensure it matches the existing information in your C4Elink course.