Import grade

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

To import, follow the steps below:

Click on Students in the main menu
Click the Import Note Student button icon located in the upper right corner (second icon)
Click the Download Template button icon located in the upper right corner (first icon) to download the template spreadsheet
Open the downloaded file
Fill in the columns with the information, as instructed below:

id_treinamento	Enter the code of the training that will be assigned the student's grade. To check the training code, follow the steps below: Click on Trainings in the main menu Click on the On-line submenu Search for the desired training in the Research bar in the upper right corner The training code is the number displayed in the ID column.
id_aluno	Enter the student ID number. To check the student ID, follow the steps below: Click on Students in the main menu Search for the desired student in the search bar The student ID is the number displayed in the ID column.
data_matricula	Enter the day, month and year when the student was enrolled in the training, in the following format: 00/00/0000
validade_matricula	Enter the day, month and year when the training enrollment is valid, in the following format: 00/00/0000
nota	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.
enviar_email	Enter the email sending number (1 or 0), 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

Do not make any changes or deletions in the first row of the spreadsheet column, identified by the column headings.