Follow

ACER- Exporting PAT Online Testing

Instructions on how to export ACER online tests and import them into your SPA account.

In this manual we are going to learn how to export your ACER PAT Online testing data into an excel spread sheet ready to be uploaded into SPAstandard on the SPAplatfrom. Please Note, that if you have been using SPA for a few years, in steps 5 and 6 there are some new instructions that will make downloading your PAT data much faster!

Step 1: Login to your ACER OARS account

Step 1: Login to your ACER OARS account

You first need to login to your OARS account from the ACER website. If you have a link saved to your favourites you can go directly there.

If not then you can follow this link https://oars.acer.edu.au/clients/search and search for your school. Search for your school name and click the link to take you to the login screen.

Once there you will need to click the Login button

Once there you will need to click the Login button

Then enter your username and password for your account. Then Click Log In

Then enter your username and password for your account. Then Click Log In

Step 2: Once you have logged in you will be taken to this screen. From here click the Reports Button and select Standard

Step 3: Select the test you would like to export

Step 4: Select Group Report

Step 5: Select report constraints (NOTE CHANGES TO THIS STEP as of SEPTEMBER 2017)

1- Select Test number

2- Select test period

3-  Click Generate Report

Step 6: Download Report (NOTE CHANGES TO THIS STEP as of SEPTEMBER 2017)

1- Click Compare Candiate results to Year Level.  You can now choose any year level at this point, it will make no difference to the data we import into SPA. This is because the file you are exporting, now includes students from multiple year levels. It does make the percentile rank and stannine score columnns incorrect, but as these columns are not imported into SPA, only the raw score and scale score, just choose any year level and move on to step 2-downloading the file.

2 Click download and Select Table (Excel File)

Step 7: Download File

Step 7: Download File

1- Name the file. We recommend something like "2017 PatM Sem 2 Test 1"

2- Make sure all check boxes are checked

3- Click Export Report

The file will now be downloaded to your computer

1- Click on Change Report

This will take you back to Step 5: Select report constraints and you can start on the next file. Repeat Steps 5 -7 until all you exported all your test data.

Step 10: Make sure Unique ID numbers are correct

1- Make sure your students Id numbers are in the Unique Id. You may need to copy and paste them from the Username column or hand fill in students who are missing a Unique Id.

**Please note, from September 2017, it is no irrelevant what is ins cell A9 (Norms), as we will now be reading the year level each studnet is in, from the year level column.

Step 11: Uploading your data.

Once you have done all of the above you just need to save the file and proceed to the uploading section of SPA and upload the file as usual.

1- Login to SPAplatform

2- Go to Import

3- Go to Import Data

4- Then either click browse or drag and drop your files to upload your data.  (You can highlight all the files you want to upload and uploaded them all at once.)

Your Data Is now ready to view

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk