# Importing NAPLAN Data

NAPLAN data has a different format in each state in Australia, and some states have different formats for education systems within the state.  These instructions are an overview and do not cover every state and system in detail. In the drop-downs, please select the state and system that applies to you and follow the prompts on the screen.&#x20;

{% hint style="info" %}
As of 2021, **Victorian** NAPLAN data is split across the VCAA NAPLAN data service (outcome and question level data) and the ACARA SSSR extract. The fragmented nature of the data means that you will need to import data from **both** sources. Please read on for details.&#x20;
{% endhint %}

{% hint style="warning" %}
Before you import your data, please ensure all of your students have been added to Literatu.
{% endhint %}

### Importing your NAPLAN data:

1\. Open your browser and go to www.literatu.com

2\. Login with your Community Administrator account

3\. When you login to your new Insights or Ledger community, you may see the NAPLAN import view by default.  If you don't, go to [https://www.literatu.com/naplan/importv2](https://www.literatu.com/naplan/importv2) or click the hamburger menu at the top left of your Literatu screen and choose **Import NAPLAN data** from the menu.

4\. Choose whether your school has a paper or online test export. Victorian schools that have done the Online test from 2021 will need to select Paper to import the VCAA Outcome Level/Question Level data. Then, re-run the importer and choose Online for the ACARA SSSR data.&#x20;

5\. Choose your state from the dropdown and the format if there is a choice, and click Continue. All formats have a sample you can download and check against your exports.  For Online imports of ACARA SSSR data, choose Aus as the state.&#x20;

![](https://681421800-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MQQGsjkQYY0g5yk0IFZ%2F-MZzbN6aD2o9WDflzByj%2F-MZzdKLpUW3SQliUCGfh%2Fimage.png?alt=media\&token=b80bda9a-3ec1-428b-a38d-1d5a56ad0096)

6\.   On the next screen (below), **please ensure you read any instructions in blue. They are important and vary by state/system.** &#x20;

Some states will see a field titled **NAPLAN Test Year;** enter the NAPLAN test year that you are importing (e.g. 2022). Then, browse or drag-and-drop your import files for the test year into the Import window. A single test year may have a number of files to import - select all of them at once. &#x20;

The files will be uploaded and you should see the test year and grade appear to the right of the Import box. Click **Continue** at this point.&#x20;

![](https://681421800-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MQQGsjkQYY0g5yk0IFZ%2F-MZzbN6aD2o9WDflzByj%2F-MZze3ljZawFBhB0iQ9n%2F2021-05-06_13-10-39.jpg?alt=media\&token=2092e486-cd3e-4f56-b59e-8b8e3658f270)

7\. You will see a **validation screen** which will show every student being imported, their bands, scaled scores and raw scores by domain.  It's normal to see blanks cells here and there where the student did not sit a test. With the exception of Victoria (ref below), no other columns should be blank. If they are, please don't proceed with the import. Instead, email support\[ at ] literatu.com to organise sending your data to us. If the data looks OK, click Continue.

{% hint style="warning" %}
**Victorian Schools:** If you are importing VCAA Outcome and Question level data for 2021 onward and have done the Online test, the Reading Questions, Language Questions and Numeracy Questions columns will be blank.&#x20;

If you are importing ACARA SSSR data,  you will not see any scaled scores and the Writing Questions column will be blank. Both of these are OK - the data is incomplete in each data service but we will merge it to form a complete data set. Continue with the import.&#x20;
{% endhint %}

8\. The next step involves joining the incoming data to the students you have loaded into Literatu. &#x20;

The importer will match as many names as possible automatically. But, where we are unable to reliably match a name, we will rely on you to match. For example, a student might be Alexander James Smith in your NAPLAN data, but Alex Smith in Literatu.&#x20;

These unmatched students names from the NAPLAN export will appear beside the closest "fuzzy" match we could find. We use a fuzzy match to try and pick up as many variations as possible.  If we have fuzzy-matched the incorrect student, click Search and choose the correct one.&#x20;

If you have not loaded all students into Literatu, you can run the name match later as a separate process.&#x20;

Please keep in mind, not ever student will be able to be matched. For example, if you are importing history, a number of the students in the NAPLAN export may have left the school and so can't be matched.&#x20;

9\. When you have finished matching students, click **Import** the Import button to import the data. &#x20;

10\. Victorian schools will see the option to merge data in the importer. When you have finished importing VCAA Outcome/Question level and ACARA SSSR data, re-run the importer, check the '**I have finished importing all VCAA and SSSR data**' box and then click the **Go to Cleanup step**. This will merge the data.&#x20;

<figure><img src="https://681421800-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MQQGsjkQYY0g5yk0IFZ%2Fuploads%2FR4QooYshDaKVSBxHmQRO%2F2022-10-13_10-38-08.jpg?alt=media&#x26;token=524125ee-9f3c-48f9-9a43-0510bcea0031" alt=""><figcaption></figcaption></figure>

### Troubleshooting

Please check the following if you have any issues:

* Ensure your files are un-edited&#x20;
* Ensure your import files are saved in the format specified by the importer
* If your import format requires certain values are present in the filename, make sure the filename matches the requirement.&#x20;
* Check the field names in the spreadsheet for corruption (more common than you'd think). For example:

![](https://681421800-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MQQGsjkQYY0g5yk0IFZ%2F-MZznOK5fUEE7YOZm5WP%2F-MZzo8nXZABwW8Ow8CeQ%2Fimage.png?alt=media\&token=6d3ce744-9216-49fd-b7ae-aeb06a38c0db)

If you still have issues, please email a description of the problem to support\[ at ]literatu.com along with the files or a secure link to access them. &#x20;
