How to import On Demand, Victorian Curriculum or NAPLAN data

Note: The On-Demand and Victorian Curriculum data import only applies to Victorian schools.

On-Demand Data

Exporting On Demand Data

When you export On Demand data it is exported as a Microsoft Word document and must be converted into a CSV (comma delimited) file in order for XUNO to be able to process the data. Each line must contain the fields below and each test result must be on a separate line:

<yearoftest>,<yearlevel>,<testnamedescription>,<testno>,<studentcode>, <testdate>,<testscore>

  1. Export the data from your On Demand website.
  2. Open Microsoft Excel to a blank worksheet.
  3. In the first row (1), starting in the first column (A) enter the text: YEAROFTEST. Then in the next column (B) enter: YEARLEVEL. Continue entering these items each in order, each in a separate column: TESTNAMETESTNOSTUDENTCODETESTDATETESTSCORE
  4. Open the On Demand test file that you exported from your On Demand website. The file requires Microsoft Word to be able to open. Once opened you will see a table with all of the test results.
    1. Highlight all of the rows containing the Student ID, Test Date and Standard Score columns.
    2. Do not highlight the header row (the row with the text Student ID, Test Date, etc.)
    3. Copy the information to your clipboard (Ctrl + C or Apple + C).
    4. Go back to the Excel file from step 3 and click on the cell of Row 2, Column E. Then click on the Paste button to copy the information across. The information should copy into the correct columns with no blank lines. Please check your data at this point to make sure that it's correct.
  5. Still in Excel, click on the header row of Column F to highlight the entire Column F vertically.
  6. Right-click on the Column F header and choose Format Cells. Click on the Date category then choose the example 2001-03-14 from the Type list. Click OK to continue.
  7. At this point, the first four columns (YEAROFTEST, YEARLEVEL, TESTNAME and TESTNO) should still be empty. You will need to manually fill these in – remember to use the fill down option in Excel! The format of each column must be as follows:
    1. <yearoftest> – The year the test was completed (e.g. 2009, 2014). The year must be in the format: YYYY.
    2. <yearlevel> - The year level of the student at the time of the test. Must be in double digits (e.g. 09, 10, 11).
    3. <testname> – A descriptive name for the test (e.g. Maths test).
    4. <testno> - The test number of the test (e.g. Unique 4 digit test number supplied from On Demand #1234).
  8. In Excel, choose the File menu or Office menu ball, and choose Save As…, then click on Other Formats.
  9. The Save As dialog box will appear. Make sure that the file type is CSV (Comma Delimited); enter a new filename, then click Save. You may be prompted to “keep the workbook in this format” – if so click Yes.

Note: Please make sure that your <TESTDATE> column is in the format of Y-M-D (Year, Month, Date). Eg. 2016-02-11

Importing On Demand Data into XUNO

  1. Login to XUNO as an administrator.
  2. Click on the Options menu and click on Import & Export Data.
  3. Click the Import drop down list and select On Demand.
  4. Click Choose File and select the On Demand CSV file you created earlier.
  5. Choose the correct Delimiter. 
  6. Remember to select Ignore Header.
  7. Click Import to import your data.

Victorian Curriculum data

  1. Login to XUNO as an administrator.
  2. Click on Options menu then click on the Import & Export Data menu item.
  3. From the Import drop down list, choose the Victorian Curriculum (Accelerus) import option.
  4. Click Choose File and select the Victorian Curriculum XML file you saved earlier in your export procedure.
  5. Click Import to import your Victorian Curriculum data.

NAPLAN data

You must export your NAPLAN results from your state’s NAPLAN website in order to import them into XUNO. Please follow the export section relevant to your state. Import instructions can be found at the bottom of this article.

Exporting Victorian NAPLAN Data

  1. Open the NAPLAN website by clicking on the following link http://naplands.vcaa.vic.edu.au
  2. Click on the NAPLAN Data Service System Login.
  3. Click on the Extract button located on the top right menu bar.
  4. Click on the NAPLAN drop-down list and choose the calendar Year you wish to export. You cannot extract and import your AIM data due to the lack of a student ID code in the extract options.
  5. Choose which Test you would like to export (e.g. Year 3, Year 7, etc.).
  6. Select all options inside of the Study box.
  7. The Groups box will be shown. Only tick the Outcome Level Data option. All other options should be un-ticked.
  8. In the bottom left corner, under the Outcome Level Data header, tick the National Scale Student Scores option and CASES ID option. All other options should be un-ticked.
  9. Click on the Extract button to continue. When the download has finished and the dialog box appears click on the Open (or similar) button. Some browsers do not display an Open prompt and require you to find the downloaded file to open it.
  10. The download file should be opened in Microsoft Excel (or similar).
  11. You now need to change the file to a different format. In Excel, choose the File menu or Office menu ball, and choose Save As…, then click on Other Formats
  12. The Save As dialog box will appear. Make sure that the file type is CSV (Windows Comma Separated); enter a new filename, then click Save. You may be prompted to “keep the workbook in this format” – if so click Yes.

  

Importing NAPLAN Data into XUNO

  1. Login to XUNO as an administrator.
  2. From the Options menu click on the Import & Export Data menu item.
  3. Click the Import drop down list and select NAPLAN.
  4. Click Choose File and select the NAPLAN CSV file you created and saved earlier.
  5. Click Import to import your NAPLAN data.

Still need help? Contact Us Contact Us