Student Information
The List sheet is where you input the details of your students. (You can save much time and energy here if you can obtain the names, feeder schools and ethnicities from your school management software and then just copy them in.) The List sheet is divided into columns. Note the requirements for each column as shown in the table below.
| Comment |
Column Title |
Requirements |
| Compulsory |
Surname |
Any text |
| Compulsory |
Forename |
Any text |
| Optional |
Unique ID |
Any text or number unique to each student |
| Balancing Factors |
Factor |
Up to a maximum of twelve columns given over to various factors you wish to balance across your classes. For example, Ability, Special Needs, Test Scores, Ethnic Background etc. |
| Compulsory |
Feeder School |
Usually contains feeder names but can be left blank or used for other characteristics you wish to balance |
| Friendship Columns |
Friend, Friend etc |
Either names in the form of Initial SPACE Surname or Unique IDs. For more details on how to input see P. 19 |
| Keep-Away Columns |
Anti, Anti etc.> |
Either names in the form of Initial SPACE Surname or Unique IDs. For more details on how to input see P. 19 |
| Restriction Columns |
Restriction Element 1, etc. |
Indicating students and their restrictions to certain groups/classes. For example, when a student’s choice of language restricts their possible classes etc |
| Compulsory |
Class |
This column will be completed by the program but you can make manual changes after the Assign routine if you wish |
| Compulsory |
Any Problems |
This column will be completed by the program to indicate any friendship or keep-away conditions it has been unable to meet |
| Comment Columns |
No Title |
Can be used to record any extra information about students. You can add your own column headings |