2. Schedule data
DescriptionThe Schedule data consists of a 12-column file which is used to automatically build each section’s schedule so that students and teachers with this section will see all the appropriate periods in the proper time slot.
Again, the following is a description of the raw information we must be able to extract from your files. Do not worry about the order or if the required data is within a combined field. i.e. “grade level” could be the “7” in the sectionID MAT101-0722 as long as you tell us where to get the information.
Format This file uses the same specifications as the teacher file (CSV)
The required information is the following (the name of the column is not important but a header should be present to avoid confusion). Again, the data can be within common fields as long as you tell us what to look for.
SectionIDA unique identifier for each section as defined in your admin system. This, like the teacher ID above, has to be unique to each section and NOT change between exports so we can update information upon a re-import. We often use a combination of the RAW “Subject code” and add the Group number. i.e. MAT722-01
TeacherIDThe teacher unique ID as defined in the Teachers export file.
Section TitleThe name of the section as it will appear in Studyo. Normally, this is extended by the Group number automatically in the app, but you may opt to combine other info here.
We recommend ensuring that these names be as short as possible for clarity.
Level The grade level this section is intended for. You can use this column to instead provide another way to group your sections, such as department name. This is optional.
Group/Section #The section’s identifier for the group. For example, in Geography 203 – 03 the 03 could represent the third group for this course. This is a way for students to quickly identify common courses when they share a same group. Sometimes, these are used with a homeroom number.
Associated groups(Optional) If you wish, you can add other group numbers separated by the slash « /» character to allow for an elective course to also appear when sorting by group #. If a student is in group 33 (or homeroom 33), any section with « 33 » in this field will also appear when sorted this way. (i.e. « 31/32/33 » for electives that may contain students from groups 31, 32 and 33)
RoomThe room for this occurrence of the course
Cycle DayThe cycle day for this occurrence of the course. i.e. (day 5). Only the digit is required.
Day of week(Optional) Supersedes the cycle day.
The day of the week for this specific occurrence of the course (0-6 with 0 representing Sunday)
Specific date(Optional) Supersedes the cycle day and Day of week.
The specific date for this occurrence of the course (YYYY/MM/DD)
PeriodThe period tag for this occurrence of the course. If you day is split into numbered periods, the digit. If your days are based or blocks, the letter for the block. Custom tags can be used if the configuration include these tags as well (i.e. « L » for a lunch period which is not counted in the number of regular periods.
Sample Schedule data for 2 sections (colors used to emphasize two sections as well as a room change for a specific period)
Single line schedules
Some School Information Systems export data in single line patterns instead of one line per section meet.
So instead of having one line for Day 1, Period 3 and a second for Day 2, Period 4, they would present something like:
or, some systems also use a system called Arrangements, which describe complex patterns using a table:
A 1-1 2-2 3-3 4-5 6-1 (this yield Pattern A-1 = Day 1 period 1)
B 1-2 2-3 3-4 5-5 6-5 (Stating just “B” would mean all these combinations
C 1-3 2-4 3-1 4-1 5-1
So a schedule entry could contain A,B2,C2-4 which could mean the following periods:
All of a = 1-1, 2-2, 3-3, 4-5, 6-1 + Only B2 (2-3) + C2 to C4 (2-4, 3-1 and 4-1)
result: 1-1, 2-2, 3-3, 4-5, 6-1, 2-3, 2-4, 3-1, 4-1