Loading TSIA – TSIA2 (Accuplacer)

Option 1 – OnSync – Preferred Method

Users can opt to automatically have their Accuplacer TSIA2 files pulled nightly into OnDataSuite using the OnSync method. Please follow the link below for more information on how to set this up.

https://kb.ondatasuite.com/knowledge-base/loading-tsia-accuplacer-files/

Option 2 – Manual Creation of Accuplacer TSIA2 File

TSIA2 Accuplacer- Accepted Data File Layout
This file is an Comma Separated Value format (.CSV)

Users who choose not to use the OnSync method for Accuplacer TSIA2 file upload will need to follow the directions below to create their own file for upload. It is highly recommended that you watch the instructional video under the OnDataSuite support page PRIOR to uploading your file to ensure that it has been created in the exact way necessary.

YOU MUST BUILD YOUR FILE EXACTLY AS SPECIFIED IN THIS SECTION OR THE FILE WILL NOT LOAD CORRECTLY.

TSIA2 OnDataSuite Import Template 2023
You must build your file EXACTLY as specified in this section or the file will not load correctly. Users should use the CSV template provided below to ensure that their file headers are in the correct order and have the required number of columns PRIOR to uploading into the file center.

Building your TSIA2 Accuplacer data file – Step by Step Video Instructions

To view a step by step video of how to build the TSIA2 file for import into OnDataSuite please log into your OnDataSuite account and go under the Support / Training / Training Videos section.

Where to load your TSIA2 Accuplacer File
The TSIA2 data file should be loaded into your file center under the TSIA2 location.

TSIA2 (Accuplacer)
File cannot be compressed or zipped
This file is a fixed length file provided by College Board. (CSV)
File name must contain no spaces
When naming files, only use letters, numbers, dashes or underscores
We strongly recommend Google Chrome or Mozilla Firefox while using OnDataSuite products

Where to get your TSIA2 Accuplacer data
The TSIA2 data fields required for upload into the OnDataSuite file center are derived from the College Board online reporting portal. You must have a College Board user account that allows you to build and pull reports from the Reports/Custom Report section as shown in the image below.

Building your TSIA2 Accuplacer data file – Step by Step Instructions
The following step by step instructions will show you how to build your TSIA2 Accuplacer data file. You MUST build your file using the custom report method as outlined below because it is the only option that will include the associated fields when it is created

  • Text Analysis and Synthesis
  • Content Revision and Editing for Conventions
  • Quantitative Reasoning
  • Algebraic Reasoning
  • Geometric and Spatial Reasoning
  • Probabilistic and Statistical Reasoning

Open your CollegeBoard Accuplacer report center and find the custom report location as shown in the image below

Step 1. Select fields for Report
This process will require that you pull different fields from different Field Categories available in the TSIA2 report builder.

Step 1 (A) Start by selecting ‘Basic Information’ from the Field Categories drop down

Click on the ‘Available Fields’ and use the right arrow to move each item over to the ‘Selected Fields’ box and the order as follows:

Test Start
Last Name
First Name
Middle Initial
Student ID
Birth Date
Site ID
Inst ID
Site Name

Step 1 (B) Next select ‘Test Scores’ from the Field Categories drop down

Continue to click on the ‘Available Fields’ and use the right arrow to move each item over to the ‘Selected Fields’ box and the order as follows:

***TSIA2 Mathematics College and Career Readiness
***TSIA2 Mathematics Diagnostics
***TSIA2 English Language Arts and Reading College and Career Readiness
***TSIA2 English Language Arts and Reading Diagnostics
TSIA2 WritePlacer

Step 1 (C) Added 10/23 – OPTIONAL (Example image not included below) – Users may opt to include the selection of ‘ExNum’ from the Field Categories drop down and add the field to the very end of the file. (see step 5 below for example of where the field needs to be placed)

Step 2. Filter by Criteria
Please check that your date range selection is accurately reflecting the date range you are looking for.

Step 3. Grouping and Sorting
Please skip this step in the creation of your file

Step 4. Output Format Settings
Set up the way you would like your file to be formatted as follows:

Include header in output file? YES
Date Format: (MM/DD/YYYY)
Text Delimited: Comma
File Formats: Windows
Download Format: CSV
Make available for Web Services? (Either is fine)

Save Query: After you build this report you can opt to save this query and you will not have to build it again, and it will be available from your drop down options. It may require that you update the date ranges when using this so please make sure to confirm before running.

Step 4 (A) SAVE your query and you will not have to build it again. You will have to check the associated dates each time.

Step 4 (B) SUBMIT – You will need to hit the submit button at the bottom of this report and it will generate your file to save locally.

Step 4 (C) You will need to download the file locally by clicking the download button that appears after your report has been run.

Step 5 REQUIRED. Opening File & Arranging Fields
You will need to open the file and arrange the fields in the order shown below. Due to the fact that reports derived from within the College Board report building tool can vary from user to user and are not created to follow a specific output data file format in their creation, each user uploading TSIA2 data into the file center must export their report in the College Board reporting tool to contain ONLY the following fields in the EXACT ORDER displayed below with the correct field names.

OnDataSuite Accepted TSIA2 Data File Format – All fields MUST be in the EXACT order listed below and should contain all header values even if they are not used.

TSIA2 Header Template
In most cases you should be able to arrange your new file in the order listed above and save as a CSV but if you are having issues please feel free to use the attached CSV formatted header to build your file.

Related Article: Checking for errors in uploaded TSIA files

Read this article to double check that your files loaded properly
https://kb.ondatasuite.com/knowledge-base/accuplacer-and-tsia2-checking-for-errors-and-removing-files-with-errors/

Updated on 06/10/2024

Was this article helpful?

Related Articles

Need Support?
Can't find the answer you're looking for?
Contact Support