meta data for this page
Class Schedule Import
Class Schedule Headers | |||
Field | Field Type | Import? | Notes |
Code | text (length: 30) | Required | Primary Key |
Name | text (length: 255) | Required | |
Department | text (length: 255) | Optional | |
Semester | text (length: 255) | Required | |
Schedule | text (length: unlimited) | Optional |
Explanation:
The class code has to be unique for each semester. If there are 2 (or more) classes with the same code, in the same semester, they will be merged.
The Name is just a friendly name that will help you visually identify the class, it's usually displayed along with the Code.
The Department is optional.
The Semester is mandatory and it must exist before you import the class file. The semesters are not automatically created to reduce to possibility of errors.
The Schedule field needs to have the following format: <days> <start>-<end> <classroom> Where:
- <days> is the list of days of the week when the class is given, without spaces.
For example: MoWeFr means that the class is given every Monday, Wednesday, and Friday. The days can be specified using the first 2 or 3 letters of the day: (Mo)nday, (Tu)esday, (We)dnesday, and so on.
- <start> is the start time of the class, in military time. For example 900 or 0900 refers to 9:00am, 1730 refers to 5:30pm.
- <end> is the end time of the class, in military time. Please note that it has to be separated from the start time using a hyphen.
- <classroom> is the name of the classroom where it's given.
Regular schedule (Recurring sessions) example:
If class is Mondays and Thursdays, from 9am to 10:30am in the classroom A-101.
MoTh 900-1030 A-101
MoWeFr 900-1030 A-101 / TuTh 1400-1530 A-101
Irregular Schedule (One-time meetings) example:
To specify the class meets July 29th, 2013 from 3pm to 5:45pm in the classroom A-101.
20130729 1500-1745 A-101
20180813 900-1030 A-101 / 20180814 1400-1530 A-201 / 20180815 1100-1230 A-203
Example:
Download the example file (.csv)