Follow

On Demand Data Extraction Manual

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.

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

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.

Maths Standard 3 to 10 General Test=  Maths

Maths Standard 3 to 10 Number & Algebra= Number

Maths Standard 3 to 10 Measurement & Geometry = MGE

English Standard 3 to 10 Literacy= Reading

English Standard 3 to 10 Language= Spelling

English Standard 3 to 10 General= English

English Standard 3 to 10 Writing= 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

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.

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

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.

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