Versions Compared

Old Version 3

changes.mady.by.user Mike French (Unlicensed)

Saved on

compared with

New Version 4

changes.mady.by.user Mike French (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Calendar Generation

...

Both joint and vertical class architectures require each session to be associated with two or more cohorts or cohort schedule records. Examples of the record creation are described below:

  •  Insert screenshots from my ERD's from vertical and composite classes from the PosiEd 1 programme (Mike to review which diagrams are best: refer Lucidchart)

Base Calendar

The Base Calendar object requires an entry for each day of the year for each grade level.

Where all Grade Levels have the same rules i.e. a normal school day or a holiday, etc., then a single Base Calendar record can satisfy the requirements of all grade levels.

If, for example, Year 7-10 have one type of activity on the day e.g. a normal school day; and say Year 11-12 have an exam day, then 2 separate records will be created. The first pertaining to Year 7-10 and the 2nd pertaining to Year 11-12 each with the respective Day Type coding.

To create a calendar for a single Course Offering, we need the following:

  • The Course Offering must be allocated against a Term. This term will specify the Start Date and End Date range

  • The Course Offering must include one or more Course Offering Schedule records. This may have been populated from EDVAL, each will designate a specific Day Number e.g. 1 for the 1st day and Period which will be linked to the Time Block i.e. Start and End Time

  • A fully populated Base Calendar, this defines the grade level assigned to the particular Course Offering which days have each respective timetable

Once all of these have been defined, we can generate calendar events for the course offering through the following process:

  • Retrieve the Start and End Date through the Term associated with the Course Offering

  • Retrieve the Year Level from the Course Offering

  • For each Course Offering Schedule record, retrieve the Day Number and Time Block i.e. Start and End Time

  • Retrieve from the Base Calendar object all records that are between the Start Date and End Date and of the same Grade Level and with the same Day Number

  • Create Session and Cohort Session entries for each Day and Time Block range linking it to the Course Offering

  • Repeat for the next Course Offering schedule