TOPSpro Export CASAS Test Data

This article describes how to copy prior test results from SiD records to the student’s TOPSpro record.

Run the SiD report called Student TOPSPro Test Data

1. Go to the SiD Reports tab, Assessments section. Select the TOPSpro Export CASAS Test Data report.
2. Change the date range and other filters as desired
3. In the CASAS Vendor Code and CASAS Agency filters, type your ABE program’s assigned numbers. (If you don't know these numbers, see Obtain TOPSpro Vendor Code below.)
4. Choose an option from the Change Old Test Dates to 7/1/(CurrentProgramYear) menu. Selecting “yes” will adjust test dates to force TOPSpro/CASAS eTESTING to recommend the correct next test form.
5. Click View Report

The body of the report will show the most recent CASAS tests in each subject.

If you chose Change Old Test Date to 7/1/(CurrentProgramYear), SiD will change the test dates prior to this program year to the first date of this program year. For example, the 23-24 program year, the report will change tests dated before 7/1/23 to “7/1/23.”

Export the report results from SiD as an Excel spreadsheet

Click the Export button on the report and choose Excel as the file type.

Open and confirm data in the Excel file

1. Open the Excel file you saved. If you get a message about being in Protected View, click the Enable Editing button. 
   
2. Look at Sheet 1 of downloaded file and confirm the report date range and other filters. If you need to make changes, rerun the report from SiD.
3. Delete Sheet 1. You will now only have Sheet 2, which has no headers.

Save the Excel file as CSV file

1. Under the File menu, click Save As…
2. Choose where you want the CSV file to be created.
3. Use a file name that makes sense to you, using the word “Test.”
4. Save as type: CSV (Comma delimited) (*.csv).
5. Click Save.
6. Close the Excel file. Do not open the CSV file.

Upload CSV data into TOPSpro

Follow these instructions for using the TOPSpro 3rd Party Import Wizard: https://drive.google.com/file/d/1lhrtq3ubqY8Jk-BiTQW6ssd_Jqj2Itcu/view

...

Obtain TOPSpro Vendor Code – One-time procedure

The first time you run the TOPSpro Export CASAS Test Data report, you might not know your TOPSpro Agency ID or Vendor ID. Ask your program manager for the name of the person who has TOPSpro and CASAS eTest permissions. They will have the Agency ID number, and likely the Vendor ID number.

If your program staff doesn’t have a Vendor ID code, someone from your program must contact CASAS to request it. This one-time process is usually completed by the data manager or a staff person who has taken the coordinator training.

How to request a Vendor ID code

1. From SiD, run the Export CASAS Test Data report. Temporarily use the number 1 in the Vendor ID filter.
2. Export the report results as an Excel file.
3. In the Excel file, go to Sheet 2. Clear the contents of the Vendor Code column.
4. Delete Sheet 1. Then save the file as a CSV.
5. Send the unopened CASAS Test Data CSV file to [e-mail].

CASAS will return your file with the Vendor Code populated. Remember your Vendor Code for future SiD imports into TOPSpro.