Class_Information.csv - Detailed Course Information

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 fields 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

 

Special Cases

Multiple Faculty Per Course

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 into ART120-01-p1,ART120-01-p2 and 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.

Non-Parallel Course Schedules

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 theStart Time and End Time fields: 10:00 AM <br> 1:00 PM.

(This is a basic and required file.)