1. Home
  2. File Center
  3. File Center - ACT
  4. OnDataSuite ACT file build/upload instructions

OnDataSuite ACT file build/upload instructions

Acquiring ACT File

As of May 2020 ACT has stopped providing districts with student assessment results via CD and has switched over to their new online ‘ACT Success’ reporting tool. This is the link to the reporting tool portal.  success.act.org/s

Step 1

Log into your ACT Success system with your username and password

Step 2

Under the Helpful Tools section, click on the blue button titled ACT Test Scores and Reports

Step 2.1 Select the ‘Student Scores (District) Roster View option

Step 2.2 Under the Roster tab select the year you wish to download and select the DISTRICT only. Do not select individual campuses. Then click the ‘Get Report’ button to run the report.

Building your ACT file

Now that you are in the ACT system you will need to build the file for import into OnDataSuite

Step 3

Click on the Options link at the top of the menu and then click on the Fields label and select ONLY the following  fields:

General Information
Test Date, Test Location, District Name, School Name, School Code

Student Information
Last Name, First Name, Middle Initial, State ID, Local ID, DOB, Grade

Continue within the Options menu and click the Scores label and select ONLY the following scores fields:

Scores
Composite, Math, Science, STEM, English, Reading, Writing, ELA

Step 4

Click the Update button at the bottom of the window to create the report and review it on your screen.

Step 5

Download the report and save it by clicking on the Download button in your menu

Once you have clicked on the Download button a pop up window will open. You must select EXCEL, then enter a Report Name, and then click the download button. You do not have to select Layout or Pages options.

After the EXCEL option has been selected a new window will pop up. Make sure that your select EXCEL and if you did not give your report a title, you may do it here.

Step 6

After you have built your report, there is an option to save your report by clicking the Save link in your options menu.  Click on the Save  button and give your report a name like in the example below.

Once you click the Save button you should see your report listed below.

Note: The next time you log into your ACT account you should now see your report listed under your ‘My Reports’ section.

ACT to OnDataSuite Accepted Field Layout

For ACT files created using the ACT Success reporting tool, OnDataSuite will accept  an Excel (.xlsx) data file formatted as listed below.
The files column values MUST be exactly in the order as shown below and the Column Header names must be exactly the same as listed below.

  • Accepted File Type: Excel (.XLSX)
  • Parser starts parsing from row 6 so the 6th row should be the first row with data in the excel file. Do not attempt to ‘clean up’ file. Leave As-Is.
  • The order of the columns is very important.
  • Format on DOB and the TEST DATE is important. Must match what is in the attached file
  • If it can not match a student via the ID columns in the file, it will look for an exact match on first name + last name + dob combo.

Excel Column |  Column Header | – Special Notes

Column A  | ACT ID
Column B  | Last Name
Column C  | First Name
Column D  | MI
Column E  | State ID
Column F  | Local ID
Column G | Test Date |- Do not format as a date. Leave as is. (Example October 2017)
Column H | Test Location
Column I   | District Name
Column J  | School Name
Column K | School Code
Column L  | DOB  | – Must be formatted as MM/DD/YYYY
Column M | Grade
Column N  | Composite Score
Column O  | Math Score
Column P  | Science Score
Column Q  | STEM Score
Column R  | English Score
Column S  | Reading Score
Column T  | Writing Score
Column U  | ELA Score

Example of complete exported file

Updated on 03/13/2024

Was this article helpful?

Related Articles

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