Read more about GPA options supported in Cialfo here before proceeding.
This article explains how to upload GPAs for multiple students at once using the GPA uploader. If you need to enter or update the GPA for a single student instead, see How to Enter or Update a Student's GPA.
Why is having Grades/ GPA data useful?
GPA is essential for plotting Scattergram data points. Without any GPA values, the student's applications will not show up on any scattergram even if they have a confirmed application result and an SAT or ACT score.
Prerequisite: Determine which type of GPA you are uploading
By default, there are 4 GPA options seen within each student's Grades section of their Profile. Each school typically makes use of up to 2 GPA options, the remaining unused options can also be turned off from view on the Configuration page.
Things to take note of:
1. Estimated GPA - Generally, this is more for schools that do not have their own GPA conversion scale. This is auto-calculated from subject scores entered for the student, based on a 4 point scale, and cannot be overwritten by an uploader.
2. GPA (4.0) - for unweighted GPA values going up to a maximum of 4.00
3. Weighted GPA (5.0) - for weighted GPA values going up to a maximum of 5.00
4. School GPA - any GPA values on an unrestricted scale, up to 3 decimal points
Step 1 - Navigate to find the GPA uploaders
Click on Bulk Upload from the Account Settings
Click on "Import Student Data".
Step 2(a) - Prepare your data file
At this point, you should have your data file ready. If you don't have one and would like to use a template, click Import Users to open the select file page. From there, click here to download the available templates and fill them in before proceeding.
Step 2(b) - Prepare your data file
(a) Enter the student identifier (Recommended: Student Email)
The Student Identifier is used to match each GPA value to the correct student. Ensure that the identifier you provide already exists in the student's Cialfo profile.
(b) Enter the student identifier and the corresponding GPA values you want to upload.
(c) Save the file in .XLS format as an Excel 97–2003 Workbook before uploading it to Cialfo.
Step 3 - Upload your data file
Click the upload box, then browse for and select the file you want to upload, or drag and drop it into the upload box.
Make sure the file is saved in one of the following supported formats: .csv, .xls, or .xlsx.
b. Configuring the type of data of the uploader
From the Uploader drop-down list, select GPA.
Choose the Date Format from the drop-down menu (Day-Month-Year, Month-Day-Year, or Year-Month-Day) to match the date format used in your file. Then click Next Step.
c. Map the data fields to the corresponding file column
Map all mandatory fields before proceeding. Mandatory fields are marked with an asterisk (*).
Ensure each mandatory field is mapped to the corresponding column in your file. For non-mandatory fields that do not contain data, select Ignore this column from the corresponding drop-down menu.
d. Preview and Confirm
Review the data to ensure it is ready for upload. If any errors are detected, correct them before proceeding. Once everything looks correct, confirm the data and continue with the upload.
This section distributes the data as :
Errors:
If the file contains any errors, they will be displayed in the Errors section. For example, if a student email address does not match any existing student in Cialfo, an error will be shown.
New:
All the new entries which does not contain any error will show up in this section.
Existing & Update :
If the data for the particular student is already updated on the platform in that case that data will populate in this section. Please turn on the toggle key for "Update the data for the existing entries" if you want to update the data of the entries that are already saved in the system and click on "Finish Import".
Step 4 - Troubleshooting GPA upload errors
Why am I seeing the "Invalid Student Identifier" error?
The Invalid Student Identifier error occurs when the system cannot find a student with the identifier you provided. Verify that the student identifier exists and matches the information stored in the student's Cialfo profile.
Why am I seeing the "Invalid GPA" error?
The GPA value must be within 1.0 to 4.0, maximum to 2 decimal places. If you are trying to upload a GPA value outside of the acceptable range "Invalid GPA" error will show up.
Why am I seeing the "Invalid Weighted GPA" error?
The weighted GPA value must to be within 1.0 to 5.0, maximum to 2 decimal places. If you are trying to upload a GPA value outside of the acceptable range you will see an "Invalid Weighted GPA" error.
Need Help?
Our Client Support team is available via Live Chat 24 hours a day, Monday through Friday, so you can get help anytime during the work week through Chat with Cialfo.
If you're unable to find a solution in our help articles or need further assistance, you can contact the Cialfo Support team via Live Chat or email us at [email protected].