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

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

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

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 Column	Field Name	Field Type- Example
A	Test Start	Date – (Formatted as MM/DD/YYYY; ex: 01/01/2017, not 1/1/2017)
B	Last Name	Alpha – Doe
C	First Name	Alpha – Jane
D	Middle Initial	Alpha – H
E	Student ID	Numeric – Use 10-digit number. (Texas Unique ID) (This should not be a made up number)
F	Birth Date	Date – (Formatted as MM/DD/YYYY; ex: 06/05/2002, not 6/5/2002)
G	Site ID	Numeric – 001224-005
H	Inst ID	Numeric – 001224
I	Site Name	Alpha – Thomas Jefferson High School
J	TSIA2 Mathematics College and Career Readiness	Numeric – Three digit number. Example: 950
K	TSIA2 Mathematics Diagnostic	Numeric – One digit number. Example: 6
L	TSIA2 English Language Arts and Reading College and Career Readiness	Numeric – Three digit number. Example: 990
M	TSIA2 English Language Arts and Reading Diagnostic	Numeric – One digit number. Example: 6
N	TSIA2 WritePlacer	Numeric – One digit number. Example: 6
O	Text Analysis and Synthesis*	Numeric & Alpha – Example: 1-Basic
P	Content Revision and Editing for Conventions*	Numeric & Alpha – Example: 1-Basic
Q	Quantitative Reasoning*	Numeric & Alpha – Example: 1-Basic
R	Algebraic Reasoning*	Numeric & Alpha – Example: 1-Basic
S	Geometric and Spatial Reasoning*	Numeric & Alpha – Example: 1-Basic
T	Probabilistic 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