Class_Information.csv - Detailed Course Information

File Summary:

The class information file supplies information about the courses such as title, number of hours and the professor. The Faculty ID should match the Employee ID sent in the Employee_Data.csv file. 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: 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: Spring2020-UNIV101-01; UNIV101-01-Spring2020; 022020-UNIV101-01)

Output Example with Fixed Header Row:

"Course ID"|"Title"|"Faculty ID"|"Number of Course Hours"|"Days of the Week"|"Start Time"|"End Time"|"Building"|"Room"|"Format"
"Spring2020-ART120-01"|"Art I"|"0002399"|"3"|"MWF"|"10:00 AM"|"10:50 AM"|"ART"|"314"|"Lecture"
"Spring2020-ART121-01"|"Art I"|"0002399"|"1"|"MWF"|"11:00 AM"|"12:00 PM"|"ART"|"114"|"Lab"
"Spring2020-ART321-01"|"Adv Sculpture"|"0002399"|"3"|"TR"|"10:00 AM"|"11:20 PM"|"ART"|"114"|"Lab"
"Spring2020-MK120-01"|"Intro to Marketing"|"0002234"|"3"|"MWF"|"08:00 AM"|"08:50 AM"|"MBB"|"314"|"Lecture"
"Spring2020-MK220-01"|"Marketing Research"|"0002234"|"3"|"TR"|"11:00 AM"|"12:20 PM"|"MBB"|"115"|"Lecture"
"Spring2020-MK320-01"|"Consumer Behavior"|"0002234"|"3"|"TR"|"1:00 PM"|"2:20 PM"|"MBB"|"213"|"Lecture"
"Spring2020-SP120-01"|"Spanish I"|"0002235"|"3"|"MWF"|"01:00 PM"|"02:50 PM"|"WER"|"111"|"Lecture"
"Spring2020-SP220-01"|"Spanish II"|"0002235"|"3"|"MWF"|"03:00 PM"|"03:50 PM"|"WER"|"112"|"Lecture"
"Spring2020-SP320-01"|"Spanish III"|"0002235"|"1"|"TR"|"09:00 AM"|"10:20 AM"|"WER"|"113"|"Seminar"
"Spring2020-CS120-01"|"Programming I"|"0002234"|"3"|"MWF"|"08:00 AM"|"08:50 AM"|"MBB"|"314"|"Lecture"
"Spring2020-CS120-02"|"Programming I"|"0002234,0002400"|"3"|"MWF"|"09:00 AM"|"09:50 AM"|"MBB"|"114"|"Lab"
"Spring2020-EN120-01"|"English I"|"0002237"|"3"|"TR"|"02:30 PM"|"03:50 PM"|"SRA"|"116"|"Lecture"
"Spring2020-EN220-01"|"English II"|"0002237"|"3"|"MWF"|"08:00 AM"|"08:50 AM"|"SRA"|"117"|"Lecture"
"Spring2020-EN320-01"|"English Classic Lit"|"0002237"|"3"|"TR"|"08:00 AM"|"09:20 AM"|"SRA"|"117"|"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. Please do not add a space in between the IDs. For instance,

"Course ID"|"Title"|"Faculty ID"|"Number of Course Hours"|"Days of the Week"|"Start Time"|"End Time"|"Building"|"Room"|"Format"
"Spring2020-CS120-02"|"Programming I"|"0002234,0002400"|"3"|"MWF"|"09:00 AM"|"09:50 AM"|"MBB"|"114"|"Lab"
"Spring2020-SC121-02"|"Science I-Lab"|"0002411,0002420"|"1"|"W"|"06:30 PM"|"07:30 PM"|"SCI"|"213"|"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 Spring2020-ART120-01 into Spring2020-ART120-01-p1, Spring2020-ART120-01-p2 and Spring220-ART120-01-p3 and set up 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 the Start Time and End Time fields: 10:00 AM <br> 1:00 PM.

*For TimeFree clients only: To ensure class schedules are populated correctly within TimeFree, please use the following identifiers for the Days of the Week:

• Monday - M
• Tuesday - T
• Wednesday - W
• Thursday - R
• Friday - F
• Saturday - S
• Sunday - U

(This is a basic and required file.)