[ Main ]

PPP/IEP Data Overview

Personnel Identification

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.)

"Subjects" and Evaluation

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 Workflow

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:

  1. Choose enter evaluations. All student listed, with options to add evaluations to existing ones or edit existing ones (all listed).

  2. 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 ]

Table Structures

In general we will link to other information in the school's database for contact information, etc. [ Back to Top ]