Skip to main content
Skip table of contents

Import students' grades in online/asynchronous training

Student grades can be entered into the system by importing them via a spreadsheet.

Instructions

  1. Click on Students in the main menu

  2. Click on the To List submenu

  3. Click the Import Note Student button icon located in the upper right corner (second icon)

  4. Click on the Download CSV template button to download the template spreadsheet

  5. Open the downloaded file

  6. Fill in the columns with the information, as instructed below:

training_id (mandatory)

Enter the ID of the training that will be assigned the student's grade.

To check the training ID, follow the steps below:

  1. Click on Trainings in the main menu

  2. Click on the Online/Asynchronous submenu

  3. Search for the desired training in the search bar

The training ID is the number displayed in the ID column.

student_id (mandatory)

Enter the ID of the student.

To check the student ID, follow the steps below:

  1. Click on Students in the main menu

  2. Click on the To List submenu

  3. Search for the desired student in the search bar

The student ID is the number displayed in the ID column.

enrollment_date

Enter the day, month and year when the student was enrolled in the training, if desired, in the following format:

00/00/0000

enrollment_validity

Enter the day, month and year when the training enrollment is valid, if desired, in the following format:

00/00/0000

grade (mandatory)

Enter the student's grade for the training.

If you assign a grade below the average, the student will be registered as failing.

If you assign a grade above the average, the student will appear as approved on his or her registration and the certificate will be available for download.

send_email

Enter the email sending number (1 or 0), if desired, where:

  • 1 to send email to the student that the enrollment has been completed, upon completion of enrollment

  • 0 to enroll the student but not email them that the enrollment has been completed

  1. Save the spreadsheet on your computer

  2. Return to the platform

  3. Click on the Import CSV button

  4. Locate and select the file

  5. Link the spreadsheet columns to the corresponding fields on the platform if the names or order are different

Example

If the grade column in your spreadsheet is named Evaluation, link that column to the grade field.

  1. Select which columns should be included in the registration

  2. Click Submit on the platform to perform the import

On the next screen, you will be able to view the report of the imported grades.

If the grade was successfully assigned, an ID will be generated for each assigned grade.

If there was an error with the grade assignment, the report will inform you of the error and the reason for the error.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.

Contact Support Close