| | | |
Teacher | | This table is required before any class, student or timetable data can be used. It is also used to create/update teacher accounts. |
|
ID | | Required unique identifier - can be text or numeric. Could even be a login name. Is used to identify timetable data with a teacher |
|
Login name | | Required. Will be the login name used for this teacher |
|
Name 1 | | Optional. Up to 3 parts of a name can be identified. STEARsoft will put these together to produce a readable name for each teacher. |
|
Name 2 |
|
Name 3 |
|
Password | | Optional. If given will set the password for each teacher as defined in your database. Otherwise passwords will default to being blank. |
|
Email | | Optional. If given will import email addresses for each teacher. Email addresses can make password management easier. |
|
Hotsync | | Optional. If synchronising with a Palm Handheld device, this is the identifier used. |
|
Filter | | Optional. Can be used to select a group of teachers. For example, the field might be current? and the match might be 1. |
|
| | | |
Timetable | | An optional table, but required to import any class, student or timetable data. |
|
Teacher ID | | Required unique identifier which must match the ID of a teacher. |
|
Class ID | | Required unique identifier which must match the ID of a Class. This is used to allocate classes to teachers. |
|
Period ID | | Optional unique identifier. If given, must match the ID of a Period (time of day). Used with Day ID to specify when a class is taught. |
|
Room ID | | Optional. Name of a room or unique identifier that must match the ID of a Room. |
|
Day ID | | Optional unique identifier. If given, must match the ID of a Day. Used with Period ID to specify when a class is taught. |
|
| | | |
Student | | This table is optional. If used, it requires the Class-Student, Class and Timetable tables and imports student data to classes. |
|
ID | | Required unique identifier - can be text or numeric. It is used to identify students when allocating them to classes using the Class-Student table. |
|
First name | | Required. |
|
Surname | | Required. Family name. |
|
House ID | | Optional. Must match with an ID in House data to allocate each student to a house. Often used for pastoral grouping. |
|
Preferred name | | Optional. Can be used to identify a nick-name, middle or other name the student is usually called. |
|
School Role No. | | Optional, but strongly recommended, numeric value (32-bit unsigned integer). When used, STEARsoft matches registration data using this value to identify suspicious absence and to match sign in/out data. |
|
Year group | | Optional, but recommended. This is helpful when searching for, or identifying, students. |
|
Form ID | | Optional. Must match with an ID in Form data to allocate each student to a form. Often used for pastoral grouping. |
|
DOB | | Optional date, or text in date (xx/xx/xxxx) format. The student's Date of Birth. When using a Palm Handheld, students are highlighted in your register when it is their birthday. |
|
You can identify the same field more than once in a table. For example you can use a Surname field to be the login name as well as part of a teacher name, or the school role number to also be the unique ID for a student. This applies to IDs when using text too; you can use the name field in your table to also be the unique ID in tables like House, Form, Period etc. You must remember that the ID is used to match data from one table to another though.