Teachers, Administrators and EA/TAs in the schools will be listed in a teacher table in the schools. As such they can be identified by a school:userid approach. For example a teacher in a school called St Mary's might be stmary:fredflintstone.
Other School Division staff not associated with a school, would be stored in a single table listing their userid, name, agency (if not central office), and phone, email, and designation (psychologist, etc.)
We have divided educational expectations into different "subjects", some of which are traditional subjects; some are not. Each subject may be broken down into smaller subcategories. Each subject area and subcategories are given a unique number. The subject areas are given 100's (or larger) and subcategories are numbered within that range. For example, if Communication was 100 then "Language - Expressive" might be 108. If Reading was 300, then "Grade 1" could be a subcategory with 305.
This simple system is very similar to an accounting system with its different categories of accounts.
Each particular task or outcome will then have a unique category tag as well as a unique number within that category. For example, if grade 1 reading was 305, then the second expectation, "Retell the content in random order", would be identified by 305-2 (or using a mnemonic system, Read-Gr1-2, if Reading (300) has a mnemonic of "Read" and 305 has a mnemonic of "Gr1".
When setting up an evaluation program for students, these particular learning outcomes are added to a student evaluation record for each subject. (S)he will then be evaluated throughout the year on that basis.
Evaluation records are added for each student in an evaluation master table (evalmst). There will be one record for each of the (currently) 14 categories (subjects) of objectives.
Using the "subject" metaphor, there could be up to 14 records in the evaluation master for each student; one for each "subject". Each of those subject records can have up to 32 objectives from that subject area.
When evaluations are done each term, a student and a subject are chosen. If a record for this term already exists, its values are read. If no record exists for this term, a new one is created. Values and commentary are entered for this record and then it is stored.
Evaluations:
Choose enter evaluations. All student listed, with options to add evaluations to existing ones or edit existing ones (all listed).
If Add, a new blank record with values for subject displayed for entry. If Edit, an existing record may be changed.
Report cards will be generated for this student and all evaluation records for this and previous terms will be read and used to create a simple report card.
[ Back to Top ]Special - A table of student data.
id - record id
lastname - char(40) - student lastname
firstname - char(40) - student firstname
birthdate - date - birthdate
studnum - integer - division student number
provnum - varchar(12) - provincial student number
desdate - date - date of designation
ddpflvl - char(6), - ddpf level
designation - char(60) - designation
grade - char(6) - grade placement
school - char(60) - school (Name and code)
sex - char(1) - gender of student
medical - text - description of medical condition.
medication - text - medication required.
equip - text - required equipment for student.
adapt - text - school physical adaptations required by this student.
Personnel - a table listing central office staff and other agency personnel not located in a school database.
id - record number
UserID - a short field identifying this person.
Lastname
Firstname
JobTitle
Agency
Phone
Email
Team - a table listing the members of each team. There will be one record for each team member for each student. The entire table will therefore hold all team listings.
id
studnum - number of the student whose team this member is on.
userid - userid and school/agency identifying this person.
jobtitle - role
phone - redundant contact info
email - redundant contact info
Assess - A table listing assessments done on students.
id - record id
student - char(255) - student name(number)
category - char(255) - matching category from assesscat.
reqdate - date requested.
resdate - date completed.
comment - text - commentary.
CatAssess - a table of assessment categories.
id - record id
category - char(255) - text specifying category
CatSubject - a table listing subject categories (nominally subjects) like reading, math.
id - record id
catid - int - subject category id,
category - char(255) subject description,
mnemonic - char(64) - short description
Subject - a table listing subject categories and objectives for students.
id - record id
catnum - integer - a number specifying the category of this
objective
category - text - a word or phrase describing category of this
objective
idnum - int - a number for this objective/expectation.
grade - char(8) - possibly the grade of the expectation
(some subjects)
description - description of the objective/expectation
commentcodes - char(255) - codes linking to a comment table.
EvalMst - evaluation master record for students; one per student per subject.
id - record id
studnum - integer - the student number
subnum - integer - the subject number
method - text - a brief description of the teaching techniques used.
responsible - text - who is responsible for implementing this
subject.
obj1, obj2, ... obj32 - objectives/expectations. - text
- contain text description of the subject and idnum (105-8).
Eval - evaluation records for students; one per student per subject per term. Thus each student will have many eval records for each term of the year. For each subject there will be one evalmst record and upto 4 eval records.
Note: First fields common with the master; only term and commentary extra.id - record id
studnum integer - the student number
subnum integer - matches subject in EvalMst table.
obj1, obj2, ... obj32 - char(16) objective results
term - the term number for this record.
comments - text; a long text field for commentary