Navigate to School Info > Imports and Exports > Import Test Results
Select the TSIA2 Test Results - SY:2022/23 file layout to import the TSIA2 assessment results
When the TSIA2 file layout is selected, the system will add/update the appropriate codes for the test sections and parts in the Code (COD) table. TSIA2 test parts have a 7.00 in the N1 field of the COD table. This query can be used to view the test parts and their descriptions: LIST COD TC FC CD DE N1 IF TC = CTS AND N1 = 7
The Import Test Results page has been programmed to accept a comma delimited (.csv) file for the TSIA2 test results. The TSIA2 test results file should include the following fields, required fields are identified:
Field Name | Required for Import | Saved to CTS field (ST# - part name, SC#-part score) |
---|---|---|
Last Name | Required | |
First Name | Required | |
Middle Initial | ||
Birth Date | Required | |
Student ID | Required | CTS.PID |
Supplemental Student ID | Required | |
Site Name | ||
Branching Profile | Required | CTS.ST1, CST.SC1 |
Test Start | Required | CTS.DT |
TSIA2 English Language Arts and Reading College and Career Readiness | Required | CTS.ST2, CTS.SC2 |
TSIA2 English Language Arts and Reading Diagnostic | Required | CTS.ST3, CTS.SC3 |
Text Analysis and Synthesis | Required | CTS.ST7, CTS.SC7 |
Content Revision and Editing for Conventions | Required | CTS.ST8, CTS.SC8 |
TSIA2 WritePlacer | Required | CTS.ST6, CTS.SC6 |
TSIA2 Mathematics College and Career Readiness | Required | CTS.ST4, CTS.SC4 |
TSIA2 Mathematics Diagnostic | Required | CTS.ST5, CTS.SC5 |
Quantitative Reasoning | Required | CTS.ST9, CTS.SC9 |
Algebraic Reasoning | Required | CTS.ST10, CTS.SC10 |
Geometric and Spatial Reasoning | Required | CTS.ST11, CTS.SC11 |
Probabilistic and Statistical Reasoning | Required | CTS.ST12, CTS.SC12 |
Using the Select Files to Load button, navigate to the TSIA2 data file and select it. Click on the Upload file(s) and create temp data link to load the students. If the data file is not in the correct format a message will display. If this occurs go back to the Select Files to Load button and select and load the correct file.
The Default Date for the TSIA2 test results is the oldest date in the file. The Testing Administration is the year of the oldest date in the file. NOTE: We do not recommend updating the Default Date or Testing Administration, especially when importing test records from prior administrations.
The TSIA2 test results include the student's Unique ID, Student ID, Name and Birthdate. Unique ID and/or Student ID are good matching criteria to begin with.
The Edit button to the left of the test record can be used to manually match test records to students that may not have been matched during the match process or that may have been matched to an incorrect student. Please see the Import Test Results article for detail instructions on how to do this.
Click on the Print Unmatched Students button to print a report listing any student that were not able to be matched.
Once as many students as possible have been matched click on the Update Test Tables button.
The TSIA2 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.
The TSIA2 test results can be viewed in the TSIA2 tab of the College Entrance Tests page. Click on the More Info link to display the detailed test scores.
The Print button will bring up a selection of tests that can be printed for the student. Selecting the TSIA2 test will produce the following report:
The same report can be run for all students in a school from View All Reports > College Entrance Tests. This report is only available at the School level, it cannot be run from the District.