Follow

On Demand Data Extraction Manual (Update for 2017)

Step 1: Please download the On Demand template from the templates section inside SPA.

Step 2: Once you have downloaded and opened the file it will look like this.

The first four columns in the spreadsheet, Year, Year_Level, Test and Test No, will need to be filled in manually. The other columns E to L are a direct copy and past form the word documents from your On Demand tests.

Please fill out the first four columns with the following information.

Column A

Column A "Year": This is the year the test was taken. For Example enter 2014

Column B: IMPORTANT NOTE

Column B "Year_Level": This is the year level that has taken the test. For Example if it was a year 7 class then you would write a 7 in that column. DO NOT enter the words Year 7. Only enter the numerical value of the year.

 

IMPORTANT NOTE

It is important to note that even if a year 7 student is given a year 8 test, you would still write "7" in this column. No matter what test you give a student you always write the actual year level they are in when they sat the test.

Column C

Column C "Test": This column is for what adaptive test they have taken.

The following is a list of the tests that you can upload into SPA and the corresponding name you need to call the test in the template.

 

Tests from (and including) 2017 onwards

Mathematics General (Standards 3 to 10)=  Maths

Mathematics Number & Algebra (Standards 3 to 10)= Number

Mathematics Measurement & Geometry (Standards 3 to 10)= MGE

Mathematics Statistics and Probability (Standards 3 to 10)= Statistics

English General (Standards 3 to 10)= English

English Reading (Standards 3 to 10)= Reading

English Language Skills (Standards 3 to 10)= Language

English Word Building (Standards 3 to 10)= Word

 

Test up to and Including 2016

Mathematics General (Standards 3 to 10)=  Maths

Mathematics Number & Algebra (Standards 3 to 10) = Number

Mathematics Measurement & Geometry (Standards 3 to 10) = MGE

English General (Standards 3 to 10) = English

English Literacy (Standards 3 to 10) = Reading

English Language (Standards 3 to 10) = Spelling

English Writing (Standards 3 to 10) = Writing

Column D: IMPORTANT NOTE

Column D "Test No" This is NOT the actual number of the test that appears on the word document.

SPA is setup to look at the growth a child over the year, between two testing periods.

In this column you would put the number "1" if the test was administered in semester 1

or a number "2" if the test was administered in Semester 2 or "1" if the test was administered in term 1,

"2" if the test was administered in term 2, "3" if the test was administered in term 3 or "4" if the test was administered in term 4.

Step 3: Open up one of your On Demand tests.

Once opened you will see a table with all the results pasted into it.

Step 3: Open up one of your On Demand tests.

3a: Highlight all the data in the table. Leaving out the First row of heading in it. So do not highlight Student Name, Student ID ect

3b: Copy and past the results into the On Demand template starting at column E

Make sure you have filled out columns A-D with the information about test test explained above. An example of what the file will look like once you have filled it out can be seen below.

Step 4: Repeat step 2-3 for all of the tests you would like to upload into SPA.

It does not matter what order you put the tests into the document. SPA will look at the file and work out where the data needs to go.  You can also put your whole school data into one document if you wish.

Step 6: Save the file keeping it in it original excel format.

Step 7: You are now ready to upload this file into SPA.

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

Comments

Powered by Zendesk