1. Home
  2. Loading TSIA2 Accuplacer Files

Loading TSIA2 Accuplacer Files

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

 The TSIA2 upload section of the file center is now operational. YOU MUST BUILD YOUR FILE EXACTLY AS SPECIFIED IN THIS SECTION OR THE FILE WILL NOT LOAD CORRECTLY. 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.

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 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. 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.

Excel ColumnField NameField Type- Example
ATest StartDate –  (Formatted as MM/DD/YYYY; ex: 01/01/2017, not 1/1/2017)
BLast NameAlpha – Doe
CFirst NameAlpha – Jane
DMiddle InitialAlpha – H
EStudent IDNumeric – Use 10-digit number. (Texas Unique ID)
(This should not be a made up number)
FBirth DateDate – (Formatted as MM/DD/YYYY; ex: 06/05/2002, not 6/5/2002)
GSite IDNumeric –  001224-005
HInst IDNumeric – 001224
ISite NameAlpha – Thomas Jefferson High School
JTSIA2 Mathematics College and Career ReadinessNumeric – Three digit number. Example: 950
KTSIA2 Mathematics DiagnosticNumeric – One digit number. Example: 6
LTSIA2 English Language Arts and Reading College and Career ReadinessNumeric – Three digit number. Example: 990
MTSIA2 English Language Arts and Reading DiagnosticNumeric – One digit number. Example: 6
NTSIA2 WritePlacerNumeric – One digit number. Example: 6
OText Analysis and Synthesis*Numeric & Alpha –  Example: 1-Basic
PContent Revision and Editing for Conventions*Numeric & Alpha –  Example: 1-Basic
QQuantitative Reasoning*Numeric & Alpha – Example: 1-Basic
RAlgebraic Reasoning*Numeric & Alpha – Example: 1-Basic
SGeometric and Spatial Reasoning*Numeric & Alpha – Example: 1-Basic
TProbabilistic and Statistical Reasoning*Numeric & Alpha – Example: 1-Basic
* NOTE: The last 6 fields were not visible during your build process in Step 2 (B). These fields are automatically generated when you create a report using the custom report method. These fields are not required fields but it is recommended that you include these for future reference and availability in future reports.If you are not seeing these extra 6 fields, please make sure you built this report following the exact steps outlined, and not the roster reports/score roster report method.

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.

TSIA2_ODS_ImportTemplate2021

TSIA2 College Board Report to OnDataSuite Visual Crosswalk

Updated on 11/03/2021

Was this article helpful?