The class information file supplies information about the courses such as title, number of hours and the professor. The Days of the Week column is the days that the course is offered, such as MWF or TR for Tuesday/Thursday. The Format column is the type of the class. This is generally one of Lecture or Lab, however all ﬁelds after Faculty ID are treated as strings and can contain any information you desire including HTML for formatting or links.
Please note that Course ID should be unique for each instance of the course, rather than using the catalog course number. It is fairly common to append the term code and section number to the catalog number to create a unique id (example: Fall2017-UNIV101-01; UNIV101-01-Fall2017; 012017-UNIV101-01)
Course ID|Title|Faculty ID|Number of Course Hours|Days of the Week|Start Time|End Time|Building|Room|Format ART120-01|Art I|F0009|3|MWF|10:00 AM|10:50 AM|ART|314|Lecture ART121-01|Art I|F0009|1|MWF|11:00 AM|12:00 PM|ART|114|Lab ART321-01|Adv Sculpture|F0009|3|TR|10:00 AM|11:20 PM|ART|114|Lab MK120-01|Intro to Marketing|F0002|3|MWF|08:00 AM|08:50 AM|MBB|314|Lecture MK220-01|Marketing Research|F0002|3|TR|11:00 AM|12:20 PM|MBB|115|Lecture MK320-01|Consumer Behavior|F0002|3|TR|1:00 PM|2:20 PM|MBB|213|Lecture
If you have multiple faculty that teach a single course, you may supply all of their IDs in the
Faculty ID column separated by commas. For instance,
Course ID|Title|Faculty ID|Number of Course Hours|Days of the Week|Start Time|End Time|Building|Room|Format ART120-01|Art I|F0009,F0010,F0014|3|MWF|10:00 AM|10:50 AM|ART|314|Lecture ART121-01|Art I|F0009,F0035|1|MWF|11:00 AM|12:00 PM|ART|114|Lab
Upon import, we will create distinct courses for each faculty. Each course that has multiple faculty will have a
-p# appended to it where the
# sign is a specific number starting at 1. So, the above would split
ART120-01-p3 and setup the class lists appropriately so that the faculty/TAs will be able to see their rosters and have the appropriate permissions.
If you have courses that have different start/end times depending on the day, you can insert some simple HTML to allow this information to display properly within the system. In the
Days of the Week field insert a line break tag in between the days with different start times:
MW <br> F. Then follow the same pattern for both the
Start Time and
End Time fields:
10:00 AM <br> 1:00 PM.
(This is a basic and required file.)