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
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.
Then enter your username and password for your account. Then Click Log In
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
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.)