Effective Lifelong Learning Inventory - ELLI Online

Back to ELLI Administration < Data Format Information

Format of data required for registration of School/Institution, Teachers and Students for ELLI

School

We will require the Name and (if a school), DFES Number and name of LEA of the school/institution

Teachers

For each class group we require some simple data on the class teacher (who will manage students doing profiles). This data is:

  1. Teacher Title
  2. Unique Teacher Initials

Students

The table below shows the format of data required for students that will be loaded directly to the ELLI Online system. It consists of 8 columns as shown below. All columns, except col 4 (UPN), are required. The information can usually be obtained from your information management system (eg SIMS) very easily. However please take care with pupil names eg: don't include nicknames; the order should be first name, middle, surname.

Students are identified within our system by the ELLI Student ID and are identifiable to teachers because the ID is made up of the students initials and dob. Our system generates the ID automatically from the name and dob. Note that students' names are NOT retained so all data on our system is anonymous. The UPN will be essential for future data analysis but is not required for registration.

The data has to be either:

  1. a TAB separated text file, without column headings following the format of the table below. You can create this kind of file from an Excel spreadsheet file by simply saving the spreadsheet as a file of type Text (Tab delimited) (*.txt);
  2. or an Excel spreadsheet.

You can email us with the School information we require (see top of this page) and attach the student data file to the email. You should send your email to your ELLI contact person.

If you have problems with any of this, there are contact details at the Contact link on the Home Page.


  Col 1 Col 2 Col 3 Col 4 Col 5 Col 6 Col 7 Col 8
  Student Name Gender DOB UPN Year Group Class Group Teacher
Title
Unique
Teacher
Initials
Format First Middle & Last Names letter or word dd/mm/yyyy letters & digits letters or digits letters or digits letters letters
E.g. 1 Gabrielle Hardy F or female 22/01/1995   5 Acorns_04_05 Mr JN
E.g. 2 Liam Anthony Cox M or male 15/07/1991   9 Yr9 Sci_04_05 Ms PBR
Notes

This will be used to uniquely identify the student within our system

NB The name is used to generate initials and is NOT retained on our system.

No nicknames

  NB please use dd/mm/yyyy format     Registration Group or subject group
PLUS current academic year
in form _04_05
Required for:
* class group feedback
* Teacher login

Effective Lifelong Learning Inventory © 2007 University of Bristol and Lifelong Learning Foundation

This website is owned and provided by LLF UK Ltd - a company registered in England and Wales
Registration no: 4903586 VAT: GB 834 537125 Registered office: 4 Swallows Barn, Willow Green Lane, Little Leigh, Cheshire, CW8 4RE, United Kingdom