Before you can use Literatu in your school, we need to load teacher and student accounts and link them to classes. We call that process on-boarding.

The first step to on-boarding is to identify your 'single source of truth' for your class roster data – ie, your classes and the teachers and students in those classes. Whichever method you use to on-board can also be used to update data, such as movements between classes, or to add new staff and students.

Literatu offers direct sync with Edval, Microsoft Teams and Google Classroom. If none of those are in use at your school, you can export the class, teacher and student information from your student information or timetabling system.

Or, students and teachers can self-enrol using your school's unique keys. To use keys, your teachers and students need to be able to access their email, as the process involves activating their account by clicking a link we will send when they register.

Jump to the instructions which suit your school's context by clicking a link below.

My school uses Edval.

My school uses Google Classroom

My school holds class information in Microsoft Teams

I can export a CSV containing class, teacher and student information from my SIS or timetabling system

I want to use self-service teacher and student registration

I want to add my class and students by keying in the details

CSV extracts of teachers, students and classes can be done from OneSchool. OneSchool produces the following files:

• Class

• Student

• Timetable

Once the files are exported they can be uploaded to Literatu:

1. Open a web browser and go to www.literatu.com.

2. Login with your community administrator account.

3. Click the hamburger menu at the top left of the screen, and select Manage -> Import school data.

4. Choose OneSchool format as the import format

5. On the import screen, either drag-and-drop your file(s) onto the upload frame, or click ‘Browse files’ to locate them.

6. Click Next to proceed. The importer will validate your file(s). If any issues are encountered, you will see a message and the import will not proceed. Please send your files to support@literatu.com in this case.

7. If the format is OK you will see a summary & detailed view of the data we are about to import. Please check this screen and make sure the information is correct. You can cancel at this point if needed.

8. Click ‘Import data’ to start the import.

9. You will see a confirmation when done.

Creating teacher accounts

In order to do a Google classroom sync, teachers need to be registered and logged in to Literatu so that they can authorise Literatu with Google. For this reason, teacher accounts need to be created in Literatu first.

The easiest way to add teacher accounts is to email a registration link for teachers to self-enrol. Click the link below to see these instructions.

Email a teacher registration link

Once registered in Literatu, each teacher can sync their classes by following the instructions below.

1. Login to https://www.literatu.com by clicking 'Login with Google' and using the Google account linked to your Classroom data.

2. Click the main menu. The location of your menu depends on which Literatu apps you are running:

1. Choose Sync with Google from the menu

2. Choose the Google Classroom class you'd like to sync using the dropdown beneath the 'Select your google course' heading

3. In the 'Select your Literatu class' drop-down, choose 'New Literatu Class' to create a class in Literatu with the same name as your Google class. If you wish to pair with an existing Literatu class, choose that class in the dropdown instead.

4. Click the 'Link these two' button to populate the Literatu class with student accounts from Google Classroom.

5. Once pairing is complete your students can login to Literatu using Google SSO, by clicking 'Login with Google'

To sync your classes and students directly from Literatu to Microsoft Teams, follow these steps:

1. Login to Literatu with your Microsoft account

2. Click the hamburger menu at the top left of the screen and select 'MS Teams Sync'

3. Click the 'Scribo to teams' button.

4. Choose the class you'd like to sync to Teams from the 'Select your Scribo Class' dropdown.

5. Click 'Push to Teams'. A Team will be created containing the students in the class.

6. You can refresh (re-sync) the class at any time by clicking the blue sync icon between the class pairings.

To sync your classes and students directly from Microsoft Teams to Literatu, follow these steps:

1. Login to Literatu with your Microsoft account

2. Click the hamburger menu at the top left of the screen and select 'MS Teams Sync'

3. Choose the class you'd like to sync from the 'Sync from Teams to Scribo' dropdown.

4. Enter the subject and the year (cohort) for the class and click 'Sync to Scribo'. Your class and student information will be transferred.

Your students will be able to login with their Microsoft accounts as soon as the sync is complete.

4. You can refresh (re-sync) the class at any time by clicking the blue sync icon between the class pairings.

The first step to preparing the import CSV is to export the following information from your student information or timetabling system. You can download a sample import template below.

Introduction

Information is intended to flow from Edval to Literatu: the list of students & teachers and their class memberships. These communications happen when triggered by desktop Edval.

Desktop Edval

You will need a login and a password from literatu. Send an email to team@literatu.com with ‘Edval login request’ in the subject, or click here to launch your email client.

You can configure Edval to “sync on save” which means Edval will send the data to Literatu every time you save your changes. This gives you the equivalent situation of Literatu “pulling” data from Edval.

Before sending student and teacher data, please ensure all accounts have an email address associated. Sync will not work for accounts which don't have emails.

Step 1:

In Edval, select ‘File > Sync with system > Configuration’. In the “System” tab, select “Literatu”:

Step 2:

Fill out the configuration information:

Literatu will give you the username and password that you require. This configuration information is stored in the .etz file, so you’ll need to save the file for this to be remembered.

Step 3:

Trigger a sync by selecting ‘File > Sync with system > Sync now’(or using the keyboard shortcut ESC ctrl-K).

Click on the “Manual” tab of this dialog, and select the following:

1. Students

2. Teachers

3. Classes

4. Class memberships

Please make sure you send all 4, or we will be missing critical data. Please don’t send any other data.

Troubleshooting

If you have any issues with the integration between Edval and Literatu, please check the following:

1. Your teachers and students have email addresses

2. You have tried a manual sync

3. You have chosen to sync students, teachers, classes and class memberships together, and have sent no other data types.

If you are still having issues, please send the following to Edval support:

1. The .etz file

2. The “debug.txt” file. This is the transcript of all communication between Edval and Literatu. To get it, tick the “Create support log file” checkbox on the sync dialog. This checkbox was recently moved from the “Manual” tab to be below the tab collection. If you do a sync after ticking this, then the “debug.txt” file will pop up in Notepad.

3. Proceed with the sync and send the resulting files to Edval

4. Please also send an example of the issue (e.g. a student code, or class code that shows the problem in question) that will allow us to recreate the problem.

Many student information systems offer a Microsoft School Data Sync (SDS) export of teacher, student and class setup. These files are usually used to update Microsoft Teams, but Literatu can also use these files to set up your classes, teachers and students.

Student information systems that offer SDS exports include Synergetic, Canvas, Compass and many more. For a full list, please go to https://sds.microsoft.com/ and click ‘Supported SISes’ on the top menu.

Please export the following files to use in the import.

• Section.csv

• Student.csv

• Teacher.csv

• Studentenrolment.csv

• Teacherroster.csv

Once the files are exported they can be uploaded to Literatu:

1. Open a web browser and go to www.literatu.com.

2. Login with your community administrator account.

3. Click the hamburger menu at the top left of the screen, and select Manage -> Import school data.

4. Choose Microsoft School Data Sync format as the import format

5. On the import screen, either drag-and-drop your file(s) onto the upload frame, or click ‘Browse files’ to locate them.

6. Click Next to proceed. The importer will validate your file(s). If any issues are encountered, you will see a message and the import will not proceed. Please send your files to support@literatu.com in this case.

7. If the format is OK you will see a summary & detailed view of the data we are about to import. Please check this screen and make sure the information is correct. You can cancel at this point if needed.

8. Click ‘Import data’ to start the import.

9. You will see a confirmation when done.

Each school has a link that teachers can use to register directly into the school. To find and email the link for your school, follow these steps:

1. Open a web browser and go to www.literatu.com.

2. Login with your community administrator or teacher account.

3. Click the setup icon at the top right.

4. Click the 'Manage Teachers' icon in the side menu, then the blue 'Invite Teacher' button.

5. Enter the email addresses of the teachers you wish to invite separated by a comma and click "Send Email". If you wish to send a plain text email using your own email system and contact list, click the option to use your email provider.

Literatu supports a 'self-service' link based model which uses links to allow teachers to register directly into their school, and students to register into their school and classes.

Link based registration is ideal for schools who don't use Google Classroom, Microsoft Teams or Edval and who can not generate an import spreadsheet from their SIS.

Before choosing this method, please note:

• You can use this method of registration to onboard your teachers, or your students, or both.

• Teachers must be registered and have at least 1 class created in order to be able to invite students via a link. Instructions for quick manual class creation are below.

• This process sends an emailed invitation. So, teachers and students must be able to receive an email at that address.

Each class has a link that students can use to register a new account in literatu, and also to enrol into new classes. To email a class link to students, follow these steps:

1. Open a web browser and go to www.literatu.com.

2. Login with your community administrator or teacher account.

3. Click the setup icon at the top right.

4. On the 'My Classes' tab, click the student count beside the class you'd like to add students to, then click the 'Invite students'. button.

5. Enter the email addresses of the students you wish to invite separated by a comma and click "Send Email". If you wish to send a plain text email using your own email system and contact list, click the option to use your email provider.

Once you have prepared the spreadsheet, you can import it by following the instructions below.

• Open a web browser and go to www.literatu.com.

• Login with your community administrator account.

• Click the hamburger menu at the top left of the screen, and select Import school data which is under the Manage heading

• On the initial screen, take note of the message which tells you how many student licenses you have available. You will not be able to import more than this. Please contact us at support@literatu.com if you need more licenses.

• To proceed, select the 'Other CSV' option on this page.

• On the import screen, either drag-and-drop your CSV file onto the upload frame, or click ‘Browse files’ to locate it. When you have done this, click Next.

• Match your spreadsheet headings with the fields in the drop-downs. If you have used our sample, this will happen automatically.

• Click Next to proceed. The importer will validate your file. If any issues are encountered, you will see a message and the import will not proceed.

• If the format is OK you will see a detailed view of the data we are about to import. Please make sure the information is correct. You can cancel at this point if needed.

• Click ‘Import data’ at the bottom of the validation screen to start the import.

• You will see a confirmation when done.

Open the admin screen

To remove students from a class:‌

1. Open a web browser and go to www.literatu.com.

2. Login with your community administrator or teacher account.

3. Click the setup icon at the top right.

‌

4. Click the student count button beside the class you'd like to remove students from. You can remove students from classes you are not a teacher of, from the 'Join Class' tab.‌

5. Click the 'Remove from class' button beside the student you wish to remove from the class.

To login on computer or tablet, make sure you know your login and password and follow these instructions:

• Open your favourite browser

• Go to https://www.literatu.com

Login with username and password

• If you have been given a username and password, enter the username into the 'E-mail/Username' field and the password into the 'Password' field

• Click Login

Login with Microsoft O365 Single Sign-on

• If you have been asked to login with your Microsoft O365 school account, click the 'Microsoft' icon.

• You will see the Microsoft login screen which is where you login with your Microsoft O365 username and password.

• Once you have logged in there, you will be logged into Literatu automatically.

Login with Google Single Sign-on

• If you have been asked to login with your Google school account, click the 'Google' icon.

• You will see the Google login screen which is where you login with your Google account.

• Once you have logged in there, you will be logged into Literatu automatically.

Open the admin screen

You can use Literatu admin screens to add teachers and edit their details. To manage teachers using Literatu admin:

1. Open a web browser and go to www.literatu.com.

2. Login with your community administrator account. Users with a teacher role can only invite other teachers to register using a link.

3. Click the setup icon at the top right.

Adding a new teacher

1. On the admin screen, click the 'Manage Teachers' icon in the left menu.

2. Click the green 'Add Teacher' button

3. Enter the teacher's name, their role (teacher or community administrator), their school email address and a strong password.

4. Click the green tick to save the account. The teacher can now login to Literatu.

Editing a teacher account

1. On the admin screen, click the 'Manage Teachers' icon in the left menu.

2. Click the 'Edit Teacher' pen icon beside the teacher you wish to edit.

3. Edit the teacher's name, role, email or password.

4. Click the green tick to save your edits.

Archiving a teacher account

When teachers leave the school, their account can be archived.

1. On the admin screen, click the 'Manage Teachers' icon in the left menu.

2. Click the red 'Archive Teacher' icon beside the teacher you wish to archive.

3. Their account is archived. The teacher will not be able to login, though assets they created such as activities and rubrics will still be available to the school.

Open the admin screen

You can use Literatu admin screens to add classes, edit their details and remove empty classes. To manage classes using Literatu admin:

1. Open a web browser and go to www.literatu.com.

2. Login with your community administrator or teacher account.

3. Click the setup icon at the top right.

Adding a new class

1. On the admin screen, click the green 'Add class' button.

2. Enter the class name, the year (grade) and the subject.

3. Click the green tick to save the class details.

4. You can now add students to the class using one of the following methods:

a) Email an invitation to your students which they can use to join your class using a link.

b) You can also add students to your class by searching for them if they are already in your school, or by keying in their details.

To use either of these methods, click the student count button beside the class you just created.

Search for students by typing a student name into the search bar. Or, click "+New Student" to key in student names, login IDs and passwords for small classes.

Editing class details

1. On the admin screen, locate the class you wish to edit by scrolling or searching.

2. Click the pen icon beside the class.

3. Edit the class name, the year or the subject and click the green tick to save the class details.

Archiving Classes

Archiving a class removes it from the active school view. Archived classes can be unarchived if teachers ever need to access information from that class. To archive a class:

1. On the admin screen, locate the class you wish to delete by scrolling or searching.

2. Click the archive class icon beside the class you wish to archive.

3. Click OK on the confirmation. The class is archived.

Deleting empty classes

Only classes that contain no students can be deleted. To delete an empty class:

1. On the admin screen, locate the class you wish to delete by scrolling or searching.

2. Click the red trash icon beside the class.

3. Click OK on the delete confirmation.The class is deleted.

Open the admin screen

You can use Literatu admin screens to add students and edit their details. To manage students using Literatu admin:

1. Open a web browser and go to www.literatu.com.

2. Login with your community administrator or teacher account.

3. Click the setup icon at the top right.

Adding a new student

1. On the admin screen, click the 'Manage Students' icon in the left menu.

2. Click the green 'Add Student' button

3. Enter the student name, their unique login ID or email address (must be > 6 characters) and a strong password.

4. Click the green tick to save the account.

Archiving a student account

When students leave the school individually, their account should be archived. To archive a student:

1. On the admin screen, click the 'Manage Students' icon in the left menu.

2. Click the red 'Archive Student' icon beside the student you wish to archive.

3. Their account is archived. The student will not be able to login.

Archiving students no longer in classes

In the student tab of the Admin screen, you will see a count of students that no longer belong to any classes. These students typically belong to leaving grades (e.g. years 6 or 12), but may also be students that have left the school individually.

You can archive these accounts in bulk. To do this:

1. On the admin screen, click the 'Manage Students' icon in the left menu.

2. Note the message at the top of the section which shows a count of students not in classes. Y

3. Click on the count to filter the student list to these students only. Here, you can check the accounts that are about to be archived.

4. Click 'Archive these students'. Their account will be archived. The students will be removed from the school's license count, and will not be able to login.

Time to close off one year and start the next? Here's a checklist you can follow which outlines the process followed by many of our schools.

If you have questions or would like to discuss other options, please email support@literatu.com.

Click on any step to open instructions in a new tab.

• Archive the past year's classes.

Sync classes and student / teacher accounts if you use one of these systems to manage the data

• If your school uses Edval, run a sync

• If your school uses Google Classroom, run a sync

• If your school uses Microsoft Teams, run a sync

If you use CSV imports, extract your student, teacher and class data for the new year

• Using Literatu CSV format

• Using OneSchool

• Using a Microsoft School Data Sync enabled SIS

Open the admin screen

To add students to a class using Literatu admin:

1. Open a web browser and go to www.literatu.com.

2. Login with your community administrator or teacher account.

3. Click the setup icon at the top right.

4. Click the student count button beside the class you'd like to add students to. You can add students to classes you are not a teacher of, from the 'Join Class' tab.

5. Click the 'Add student' button at the top of the slide out panel and start typing the student's name into the 'Type student name' box. We will return a list of matching students as you type. Simply click the student from that list, and they will be added to the class. The short video below shows this process.

Follow these instructions if you use an email address to login, and you have forgotten your password and need to create a new one.

1. Open your browser and navigate to www.literatu.com

2. Click the I forgot my password link

3. Enter your email address in the Password Reset screen and click Submit.

4. If the email address is associated with an account, the instructions for resetting your password will be emailed to you. It may take a couple of minutes for the email to arrive. If you have not received it within 10 minutes, please check your spam folder.

5. Click the password reset link in the email and enter your new password.

Archived students and teachers To un-archive a student or teacher account:

1. Open a web browser and go to www.literatu.com.

2. Login with your community administrator account.

3. Click the hamburger menu at the top left of the screen, and select Manage -> Archived Accounts https://www.literatu.com/communities/archived-account

4. Locate the account to un-archive.

5. Click the blue Un-archive button. The student or teacher will be restored to their previous classes, and will be able to login again.

Open the admin screen

To join or leave a class using Literatu admin:

1. Open a web browser and go to www.literatu.com.

2. Login with your community administrator or teacher account.

3. Click the setup icon at the top right.

Leaving a class

1. Locate the class you wish to leave in the class list.

2. Click the Leave Class icon. You will be removed as a teacher of that class.

Joining a class

1. Click the Join Class tab

2. Find the class you wish to join by using Search at the top of the page.

3. Click the Join Class icon. The class will appear in your My Classes tab.

At the beginning of a new year, it is a good idea to archive your past year classes. This removes them from the schools view, but still allows them to be unarchived if a teacher ever needs information from that class.

To archive ALL classes in the school, follow these instructions:

1. Open a web browser and go to www.literatu.com.

2. Login with your community administrator account.

3. Click the cog at the top right of the screen. You will see this:

1. Click 'Archive all classes'

2. You will be able to name the archived classes to make them easier to find. In the naming popup, we will suggest the year and month of archive, though you can change this.

1. Click 'Go' when you are ready to archive. Your classes will be archived and available in the Archived Classes tab.

The manage students using Literatu's Admin. To change the password for a student or a teacher:

1. Open a web browser and go to www.literatu.com.

2. Login with your community administrator or teacher account. Note, only community administrators can reset teacher passwords.

3. Click the setup icon at the top right.

4. Click Manage Students or Manage Teachers on the left menu and find the account using search.

6. Click the Reset Password icon

7. Type in the new password and click the green tick to save the entry.

The Literatu Insights Dashboard and the Learning Ledger take external data and display them in class-centric dashboards.

The Explorer Insights Dashboard focuses on the most common diagnostic tests run in Australia - NAPLAN, Allwell, 'standard' PAT*, AGAT and MYAT. This data flows to Ledger as well, if your school is running it.

The Learning Ledger is a holistic view of any student data that your school is interested in showing. Diagnostic data from the Explorer flows to Ledger automatically. From there, schools can add on report card data, GPA, attendance summaries, student goals, learning engagement and so on. If the data is available in a repeatable, exportable format from any other system (including Excel), we can write a recipe for it. Once the recipe is written the data can be imported as needed by the school or by us. The Ledger can also accept automatic xAPI postings from compliant systems, once set up.

The following sections contain instructions about exporting some of the more common data sources and importing them into Explorer or Ledger.

Preparing for your initial Allwell upload

The Explorer and Ledger combines results for current & previous years to show longitudinal progress for students and the school as a whole. This is why we need a few years of Allwell reporting data to get schools started.

As a rule of thumb, we need as many years of history as the school wishes to see in growth. As a minimum we suggest 4 years, however we can import data as far back as 2013.

Obviously, we need data for all tested cohorts and domains.

Exporting the Alphanumeric and Skills Profile reports

Login to your Allwell reporting system and export the following files, which are used by the Literatu importer. Please don't rename or edit the files in any way:

• Alphanumeric Report as a CSV file.

• All maths and reading Skills Profile Student Summary With Questions reports. If they are generated in '.xlsx' format, please save in '.xls' format. Please do not edit the contents or headings in the files themselves.

Samples of these can be downloaded below.

Please contact the test provider if you need instructions or assistance with the export.

Importing Allwell Data

To load new Allwell tests, follow the steps below:

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

3. Select Allwell from the dropdown menu

4, Drag and drop or use Browse to upload the Alphanumeric report first. Once this is uploaded, upload the Maths and/or Reading Skill Profiles, in XLS format.

5. The files will be uploaded and validated. You will the validated list of files in the import queue, where:

File is the name of the file being imported

Test is the short name of the test as it will appear in the Diagnostic Explorer dropdown.

Domain is the test domain, which is defaulted from the import file. You should not need to change this

Cycle Year is the year in which the test was completed, which is defaulted from the import file. You should not need to change this.

Year is the grade/cohort level of the students in the test. If one Group Report contains more than one year, you will see a row of detail for each year.

Progress and Status, which refer to the upload and validation status of each file. If you do not see a green tick in each row, there was an issue uploading and validating the file. Please check that the file is in the correct format. If you can not find the issue, please email the file to support@literatu.com.

Actions. Click the eye icon to preview the file contents. Click the red bin to delete the file from the import queue.

Please ensure all of the information is correct and make any edits required.

6. When you are ready to upload your data, click 'Continue to import'.‌

7. The next step of the import is name matching; ie matching the students in the Allwell Reports to students accounts in Literatu.‌

Because Allwell data rarely contains an email address or SIS ID, Literatu matches students by name. We automatically match students where we can. Any students we cannot reliably match appear in a validation screen where you can select the correct student from a dropdown.‌

If a student does not have a literatu account, their data will be imported in a limited way. They will appear in the Zone of Proximal Development report only. When their Literatu account is loaded and their names are matched, the data will appear in all Diagnostic Explorer reports, in Insights dashboard and in Ledger (if licensed).‌

8. Click 'Import all files above' to complete the import. A progress bar will track the import and you will see a confirmation message when the import is complete.‌

Editing & deleting import batches

To edit the test name, cycle date or to delete imported files:‌

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

2. Login with your Community Administrator account, and go to Diagnostic Explorer in your Insights menu.

3. Select 'Import PAT Data' from the ribbon menu on the right or go directly to

‌

3. Click 'Manage my Imports' at the top of the screen.‌

4. To change the test name, click the name in the grid and edit. Click 'Save Changes' when you have finished.‌

5. To change the cycle date, click the date in the Cycle column and enter the new value in the popup. Click 'Save Changes' when you have finished.‌

Preparing for your initial PAT upload

The Explorer and Ledger combines results for current & previous years to show longitudinal progress for students and the school as a whole. This is why we need a few years of PAT reporting data to get schools started.

As a rule of thumb, we need as many years of history as the school wishes to see in growth. As a minimum we suggest 4 years, however we can import data as far back as 2013.

Obviously, we need data for all tested cohorts and domains.

Downloading the Group Reports from ACER OARS

Please export the 'Group Report' format directly from your ACER OARS system to import into Literatu. We need un-edited files.

The following screen animation shows where to find the Group Report. Please contact your ACER support representative if you have additional questions.

Importing PAT Data

The PAT importer updates the Diagnostic Explorer, Insights and Ledger (if licensed) as part of the import process. To load new PAT tests, follow the steps below:

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

3. Select PAT / AGAT from the dropdown menu

4. Drag and drop the Group Report files into the 'Drag your files here' frame, or click to open the file explorer. You can load a number of Group Report files at the same time. They can be different domains (e.g Maths and Comprehension).

5. The files will be uploaded and validated. You will the validated list of files in the import queue, where:

File is the name of the file being imported

Test is the short name of the test as it will appear in the Diagnostic Explorer dropdown.

Domain is the test domain, which is defaulted from the import file. You should not need to change this

Cycle Year is the year in which the test was completed, which is defaulted from the import file. You should not need to change this.

Year is the grade/cohort level of the students in the test. If one Group Report contains more than one year, you will see a row of detail for each year.

Progress and Status, which refer to the upload and validation status of each file. If you do not see a green tick in each row, there was an issue uploading and validating the file. Please check that the file is in the correct format. If you can not find the issue, please email the file to support@literatu.com.

Actions. Click the eye icon to preview the file contents. Click the red bin to delete the file from the import queue.

Please ensure all of the information is correct and make any edits required.

6. When you are ready to upload your data, click 'Continue to import'.

7. The next step of the import is name matching; ie matching the students in the Group Reports to students accounts in Literatu.

Because PAT data rarely contains an email address or SIS ID, Literatu matches students by name. We automatically match students where we can. Any students we cannot reliably match appear in a validation screen where you can select the correct student from a dropdown.

If a student does not have a literatu account, their data will be imported in a limited way. They will appear in the Zone of Proximal Development report only. When their Literatu account is loaded and their names are matched, the data will appear in all Diagnostic Explorer reports, in Insights dashboard and in Ledger (if licensed).

8. Click 'Import all files above' to complete the import. A progress bar will track the import and you will see a confirmation message when the import is complete.

The following screen grab shows the import process.

Editing & deleting import batches

To edit the dropdown name, cycle date or to delete imported files:

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

3. Click 'Manage my Imports' at the top of the screen.

4. To change the test name, click the name in the grid and edit. Click 'Save Changes' when you have finished.

5. To change the cycle date, click the date in the Cycle column and enter the new value in the popup. Click 'Save Changes' when you have finished.

The following screen grab shows the process to rename a test and change the cycle date.

New Schools: How many years of data should you export?

The Explorer and Ledger combines results for current & previous years to show longitudinal progress for students and the school as a whole. This is why we need a few years of NAPLAN reporting to build that view.

As a rule of thumb, we need as many years of history as the school wishes to see in growth. As a minimum we suggest 4 years for a primary school or high school, and 7 years for a K-12. However, we can import data as far back as 2013.

Exporting your data

The Literatu NAPLAN importer relies on exports downloaded from your state/system NAPLAN reporting application. Unfortunately, we can not give you exact instructions for each reporting system as we don't have access to them. However, we do have samples of the file formats we expect in the NAPLAN Import routine.

Your school would have been sent these in your on-boarding Data email as well. Please contact support [ at ] literatu.com if you need another copy of the email.

As a general rule:

• Please do not edit the exported file contents at all (e.g. adding columns, grouping, totals etc). We rely on completely un-edited data.

• Please do not change the filenames, with the exception of prefixing or suffixing to show the domain and year level, if needed (e.g. GP7, SP7 etc).

• Please ensure you export the data for all tested year levels, domains and calendar test years.

Victorian Schools

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.

From the VCAA data service, please export the student outcome level and student question level data. Additionally, please export each domain and year level from the ACARA SSSR reporting suite.

Exporting data from ACARA SSSR

1. Open the ACARA report suite and navigate to the School Item Report tab.

2. Choose the first Domain and Year Level you will export.

3. Click export. Leave all of the boxes in the popup checked and click Export as CSV.

4. When the file downloads to your computer, add a prefix to the filename it so you can track what you have exported. Otherwise leave the filename as is E.g:

Save SSSR Extract - BEST SCHOOL - SYDNEY CAMPUS (12345) - 2022-08-02.csv as

GP7-SSSR Extract - BEST SCHOOL - SYDNEY CAMPUS (12345) - 2022-08-02.csv … and so on.

5. Choose the next domain for that cohort and continue exporting until all 5 domains are exported. Then, export the data for the next year level.

The Learning Ledger is a holistic view of every student in your school. You can import almost any data that is important to your school community. Examples of data sources commonly imported include NAPLAN, PAT, Allwell, AGAT, CogAT, semester grades, effort, teacher comments, GPA, attendance summaries, student goals, summative and formative activities, learning engagement and wellness.

Adding a data source to Ledger is as simple as sending us a sample of the data you wish to have imported. We will write an import recipe based on the data which you will be able to use to import data via a simple drag-and-drop interface whenever needed. We can also import your data for you.

About Recipes

Ledger is completely dynamic which allows us to take almost any data your school wants to see. In order for a data source to be added to the Ledger, all that needs to happen is that we need to create an import recipe. The recipe simply tells the Ledger importer:

• Which columns to import from your spreadsheet and which to ignore

• How to choose the data to import based on repeatable criteria (e.g. only import rows where the data in the 'Final Results' column = 'Yes')

• What name to give the fields we import on screen

• How to group the data in the timeline

• How to group the data in the Profiler and Mixer

Once the recipe is written the data can be imported as needed, either by you or by us.

In order to add a new recipe to the ledger:

• Send an export of the data to us containing real values which adheres to the data guidelines below.

• Let us know which fields you would like imported, and what you would like them to be called. We will contact you if we have questions.

• We will create a new recipe for that data source and import the spreadsheet you have sent us.

• Once the data is imported, we will contact you so that you can take a look and let us know if any changes are needed.

• Once the recipe is agreed, it is available in the Ledger Import for your school. You can import data as required. We can also import data for you.

Providing Data for Recipe Creation

When adding a new data source to Ledger, the first data set you send us acts as a blueprint which sets the format for all future imports. The first step to adding a data source is sending us an export of the data. Before sending, please make sure it adheres to the following:

• The data is repeatedly exportable in a CSV, XLS or XLSX format.

• The data is going to be consistent. We create an import recipe based on the field names in the first export. These field names should not change.

• The data needs to be complete. Data should only be imported once it has been finalised. For example, please don't send semester grades that are still being finalised.

• The data needs to be consolidated. Any necessary data consolidations or calculations need to have been done before data is imported. We can do selective imports where we only import data where a field contains a certain value (e.g. only import rows where the data in the 'Final Results' column = 'Yes'). However, we don't do calculations or at import time.

When you are ready to send your data, please send to your Literatu representative.

When data is imported, it needs to be 'connected' to student accounts in Literatu. This allows the data to follow the student to form the data picture for the class, cohort and school.

Literatu matches the imported data to Literatu students by name for PAT / Allwell and NAPLAN data because these data exports do not reliably contain any other unique identifying feature such as email address or SIS ID. For Ledger imports we prefer to use unique identifiers where possible, though can fall back to name if your school data sources don't support any of these.

During any import, we will attempt to match names automatically wherever we can. However, there will always be a set of names we are unable to find a perfect match for.

When your data import is complete, we suggest you check for un-matched students. To do this:

1. Login to Literatu with your admin account

2. Click the hamburger menu which is on the top left of your Literatu screen.

3. Select 'Name Matching' from the menu

4. Choose a data source to match (NAPLAN, PAT or Ledger)

5. Choose a calendar year to match. This should be the calendar year corresponding to the data you just imported, e.g. 2021

6. Choose the name format in your imported data and in Literatu by completing the options sentences. For example, if your PAT data appears on screen in 'first name, last name' format but your Literatu data is in 'last name, first name' format, your options sentences would be:

   • Names in PAT are in [First Name + Last Name] format.

   • Names in Literatu are in [Last Name + First Name] format.

7. When you select the name formats, Literatu will add any perfect matches to the 'Perfect Matches' tab.

8. The Fuzzy Matches' tab will show all partial matches or un-matched students. Please check each of these. Fuzzy matches are done using an algorithm which will try and match the surname, then the first name as closely as possible. Some fuzzy match suggestions may be close and some may not be.

9. If Literatu has fuzzy-matched a student incorrectly, click Search to clear the match and search for the correct student.

10. If a student is no longer at your school and therefore doesn't have a Literatu account, ensure the checkbox beside their name is unchecked.

11. Where the checkbox is ticked on update, Literatu will match the data to the selected student. If the checkbox is unchecked, the match will not happen even if there is a fuzzy match present.

12. When all matches have been completed, click the blue 'Update Data' button.

13. Matches only need to be done once per data source. Literatu will remember the matches for that data source going forward. For example, if Lex Smith in PAT is matched to Alexander James Smith in Literatu, we will automatically match the student when new PAT data is imported.

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.

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 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.

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.

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

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.

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.

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.

8. The next step involves joining the incoming data to the students you have loaded into Literatu.

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.

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.

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

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.

9. When you have finished matching students, click Import the Import button to import the data.

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.

Troubleshooting

Please check the following if you have any issues:

• Ensure your files are un-edited

• 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.

• Check the field names in the spreadsheet for corruption (more common than you'd think). For example:

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.

As of the date of writing this, NSW and ACT NAPLAN data has not been made available in the 'NAPLAN Export' section of Scout. However, a new report has been made available in the general section which contains the underlying detailed student data which we can use to populate Insights and Ledger.

We have written an interim importer for this data, as we have no clear direction as to when the 'NAPLAN Export' data will be made available.

Exporting Data

1. Login to Scout, and choose the general NAPLAN reporting app for your state.

1. Choose Student Proficiency Standards from the side menu.

2. Hover your mouse directly over the right hand side of the table and click the 3 dots which are displayed on hover.

3. Choose 'export'

1. In the Export selection, choose 'Summarized Data' and click Export. These exports contain only the achievement data per student. Next, you will need to export the question level data per domain.

2. To do this, in the left menu, choose 'School Item Analysis'

1. At the top of the reporting page, select the first domain. NOTE: You will need to follow these instructions for every domain.

1. Scroll down to the 'Student Item Map' report, and float your mouse over the top right of the table to reveal the mini-menu and click the 3 dots.

1. Choose Export Data. In the export, choose Summarized Data, and click Export.

1. Save the file ensuring you include one of these domain descriptors in the file name:

   1. 'GP' for grammar and punctuation

   2. 'SP' for spelling

   3. 'RD' for reading

   4. 'NM' for numeracy

2. Repeat for all 4 domains.

3. Now, export the writing data. In the left menu, choose 'School Item Analysis Writing'

1. Clear the selections for the following fields using the eraser which becomes visible above each of the fields when you hover:

   1. Which Assessment?

   2. Which Criteria?

   3. Text version

Note - if you don't clear these selections, you will be missing data.

1. Scroll down to the table at the end of the page which has a heading 'Click on the chart above the filter the results below', then hover your mouse directly over the right hand side of the table and click the 3 dots which are displayed on hover, then export the data as you have done for the previous domains.

Importing the 2023 data

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

2. Login with your Community Administrator account

3. Go to 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. For 'Test Type', choose online.

5. For the ACT and NSW, please choose NSW from the 'State' dropdown.

6. In the 'NAPLAN Data Format' field, choose Format 3 - (SCOUT 2023)

1. On the next screen, enter the NAPLAN test year that you are importing (2023). Then, browse or drag-and-drop your exported files into the Import window.

2. The files will be uploaded and you should see the test year and grade appear to the right of the Import box. Click Continue.

3. You will see a validation screen which will show the data for every student being imported. If the data looks OK, click Continue and your data will be imported.

1. The next step involves joining the incoming data to the students you have loaded into Literatu.

   The importer will match as many names as possible automatically. Where we are unable to reliably match a name, we will rely on you to match using the Name Matching routine, detailed via the link below.

Name Matching

To import data into Ledger, prepare your spreadsheet then:

1. Login to Literatu with a Community Admin account.

2. Click the hamburger menu on the top left, then choose Import Ledger Data

3. In the 1. Select your recipe dropdown, choose the recipe that corresponds to the data you wish to import

4. In the 2. Select your file(s) area, you will see the field names Ledger is expecting. Check that your spreadsheet matches these, then upload the spreadsheet.

5. If your spreadsheet does not match the field names, you will see an error. Please edit your sheet and ensure it matches the expected format. Otherwise, continue the import by answering any questions which appear in section 3. Import your data. These will vary depending on the recipe.

6. Click Import data. The import will proceed. Ledger will attempt to match the incoming data with students loaded in Literatu. Any students we cannot find a match for will need to me manually 'name matched'. This is described in the next section.

If you have issues importing, please contact support[at]literatu.com and send a copy of the data you are trying to add.

Due to changes in reporting in Scout and the absence of a clean export since 2022, a 2 step import is necessary to surface NAPLAN data down to question level.

The first step involves importing data from SSSR. Since SSSR data does not include scaled scores, a second import is necessary. The entire import process should only take 5 – 10 minutes to complete.

Importing SSSR 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 or click the hamburger menu at the top left of your Literatu screen and choose Import NAPLAN data from the menu.

4. In the first screen, choose 'Online' as the Test Type and click the 'Continue' button at the bottom right of the screen.

5. Choose 'Aus' as the state, and 'Format 1 - ACARA' as the 'NAPLAN Data Format', and click Continue.

6. Enter the import date in the 'NAPLAN Test Year' field, then drag-and-drop or browse, and add the SSSR files ONLY into the Import window, then click Continue.

1. We will read the data and show a summary of the test years and grades found. If either are incorrect / missing, please send or share the data with support@literatu.com. If the summary is correct, click 'Continue'.

7. You will see a validation screen which will show every student being imported, their proficiencies and raw scores by domain. It's normal to see blanks cells where the student did not sit a test. However, if you see blank columns, please don't proceed with the import. Instead, email or share the data with support@literatu.com. If the data looks OK, click Continue.

Your data will be imported. Please note, this can take several minutes to complete.

When the SSSR import has completed, restart the import process to add the scaled score data from Scout.

Import Scaled score data

1. Open each XLSX file downloaded from Scout and save the data in CSV format.

2. Restart the import, this time choosing:

   1. Online as the test type

   2. Aus as the state

   3. 'Backfill Scaled Scores' in the 'NAPLAN Data Format' dropdown

   4. 2024 as the NAPLAN test year.

   5. Drag-and-drop the scaled score CSV files into the Import window

Then proceed with the import as outlined above. The data will be joined to your SSSR data to complete the full NAPLAN picture for each student.

Name Match

When the import is complete, choose the Name Match option on the success pop-up.

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

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.

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

Troubleshooting

Please check the following if you have any issues:

• Ensure your files are un-edited

• Ensure your import files are saved in the format specified

• Check the field names in the spreadsheet for corruption (more common than you'd think). For example:

If you still have issues, please email a description of the problem to support@literatu.com along with the files or a secure link to access them.

Remember, you can always send your data to lidija@literatu or support@literatu, and we will do the import for you, free of charge.

One of the features of Ledger is that it is an immutable record of a student's learning journey within a school. However, you may occasionally find that imported data has been matched to the incorrect student in Literatu. Or, you may wish to remove an individual student entry completely. To do this:

1. Login to Literatu with a Community Admin account

2. Click this URL: https://www.literatu.com/ledger/#/ledger/student?action=manage

3. Search for the student, then locate the entry you wish to manage in the timeline. You will see 2 additional icons.

   1. The first will un-match the entry. The entry will no longer appear in the timeline of the selected student, and you will be able to re-match the data to the correct student in Name Matching.

   2. The second will completely remove the entry. Please note, deleting the entry can not be reversed.

Registering a new teacher or student account using an invitation link

1. Open a web browser.

2. Click the registration link in your invitation email, or copy and paste it into your browsers address bar.

3. Choose the option you'd like to register with:

• To SSO using your Google email address, click the Google box. Google will manage your login to literatu so you don’t have to remember another password.

• To SSO using your Microsoft email address, click the Microsoft box. Microsoft will manage your login to literatu so you don’t have to remember another password.

• If you don't use either of these, click Email to register with an email address and password.

4. Continue registering using the help below.

Using links to join a class as a student

Students with a Literatu account can also quickly join additional classes using the class access link.

To join a class as a student using the link:

1. Open a browser and go to https://www.literatu.com

2. Login with your student account

3. Click the class link in the invitation email or copy and paste it into the browser address bar, and press enter.

4. You will see a confirmation message that you have been joined to the class.