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.
Please note, you do not need to send us information about which students have left existing Literatu classes. When you prepare an import sheet, please ensure all current students appear in the listing for each class. If the class exists in Literatu, we will repopulate the class according to that information, and any students not in the class list will be removed.
COLUMN
DESCRIPTION
Class name
We suggest you import your classes so that you can assign activities and report by class groups. If you don’t want to assign or report at a class level, then simply enter the cohort name in this field (e.g. Year 7).
Teacher name
The name of the teacher of that class.
If the class has more than 1 teacher, list additional teacher details in the next rows for that class E.g.
Class name Teacher Name Teacher email etc...
Teacher email
The teacher’s email address. Teachers will login with their email address. Email is mandatory for teacher accounts.
Note: If you are using single sign-on (SSO) with linked email addresses, please use the email address that is used by your SSO provider.
Teacher password
A default password for the teacher. Please make sure it is at least 6 characters with an uppercase letter and a number. Please note, an initial password is mandatory even if teachers will be logging in using Google or Microsoft SSO.
Student name
The student’s name. Apostrophes, hyphens and spaces are allowed.
Note: Some schools prefer firstname lastname format, and some prefer lastname firstname format. Please ensure the student name is in the order your teachers expect to see it.
Student email/login ID
The student’s email address. This is our preference, and is used as the login ID.
If your students do not have school emails or are too young to login with email, then please use a login ID that is a single word plus a 2 or 3 digit number. We suggest you use the format of the first 3 characters of their first name, the first 3 characters of their surname plus a 2 digit number, e.g.
Mary Anderson - marand45
Student password
A default password for the student. Please make sure it is at least 6 characters with an uppercase letter and a number. Please note, an initial password is mandatory even if your students will be logging in using Google or Microsoft SSO.
Class subject
The subject of the class. Subject is used in reporting.
Class year
The cohort the class belongs to, using just the number (e.g. 7 for Year 7)
Gender
Optional: The gender of the student in the format of M, F or X for gender X. This is an optional field.
LBOTE
Optional: Language Background Other Than English, in the format of Y (yes) or N (no).
Before importing, please make sure there are no blank fields or incorrect data.
7ENG-A Mr Barnes
7ENG-A Mrs Adams