The IB Subject Test Results can only be imported from the Import Test Results page in the Aeries Web Version. It will not be able to be imported from Aeries Client Version.
Select the IB Subject Test Results - SY:2018-19 file layout to import IB test results that have been downloaded on or after the 2018-19 school year,
The Import Test Results page has been programmed to import only the IB Subject Results file. It is a comma delimited (.csv) file.
Using the Select Files to Load button, navigate to the IB Subject Test Results data file and select it. Click on the Load button to load the students. If the data file is not in the correct format a message will display. Should this message come up go back to the Select Files to Load button and select and load the correct file.
The Default Date for the IB Test Results is in the format 05/01/yyyy. The Testing Administration is the year.
The IB Subject Test Results data file does not include the students' Student IDs, State IDs or birth dates. The only way to match the students is by their first and last name. Select the Last Name, First Name option leaving the Verify Birth Date and Verify Name options unchecked.
The IB Subject Test Results import will add/update records to the College Entrance Test (CTS) table. After the import process has completed an email with summary information will be sent to the user that initiated the import. If any test records could not be added due to an unknown test part it will be listed in the email.
The IB test results can be viewed in the IB tab of the College Entrance Tests page.
IB Subject Test Codes and AdminCS
There are many different IB Subject Tests that students can take. To standardize the codes for these various tests Aeries added the IB Subject Test codes into a system code table during the 7/12/2019 AdminCS update. Since then just navigating to one of the following areas will update the system code table with new IB test parts when they are available in a new Aeries version:
- Import Test Results
- Administrative Functions - Update USYSGCOD (fixed codes) Table button
If a district has already added IB test codes to the Code (COD) table, there may be a discrepancy between the test codes and the test descriptions in the tables. The following query will list all of the IB test codes that are in both the Code (COD) table and in the usysGCOD table. The results of this query should be reviewed to ensure that the descriptions of the tests are the same in both tables.
--To list conflicts of IB Subject tests between usysGCOD and COD tables:
SELECT COD.SC, COD.TC, COD.FC, COD.CD, COD.DE AS [OldDesc], USYSGCOD.DE AS [NewDesc]
FROM COD INNER JOIN USYSGCOD ON USYSGCOD.TC = COD.TC AND USYSGCOD.FC = COD.FC AND USYSGCOD.CD = COD.CD
WHERE COD.SC = 0 AND COD.DEL = 0 AND USYSGCOD.DEL = 0 AND USYSGCOD.CAT = 'IB'
If a discrepancy is found in a test description, then the following query can be run against the College Test Scores (CTS) table to see if there are any student test records that use that test code. If so, then the test record may need to be deleted and re-added with the new IB test codes.
SELECT * FROM CTS WHERE CTS.NM = 'IB' and CTS.ST1 = 'xxx'
--where xxx is the IB test code that you are searching for. For example, CTS.ST1 = 'THE1'