File Summary:
The class information file supplies information about the courses such as title, number of hours and the professor. It may contain one term or multiple terms. 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.
Formatting Note: This file has a set header row and specific formatting. The file name, column names, and column order should be exactly as indicated in the description (capitalization included). If you are unable to fill a field with data, please still include a placeholder.
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: Fall20XX-UNIV101-01; UNIV101-01-Fall20XX; 0120XX-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" "Fall20XX-ART120-01"|"Art I"|"0002399"|"3"|"MWF"|"10:00 AM"|"10:50 AM"|"ART"|"314"|"Lecture" "Fall20XX-ART121-01"|"Art I"|"0002399"|"1"|"MWF"|"11:00 AM"|"12:00 PM"|"ART"|"114"|"Lab" "Fall20XX-ART321-01"|"Adv Sculpture"|"0002399"|"3"|"TR"|"10:00 AM"|"11:20 PM"|"ART"|"114"|"Lab" "Fall20XX-MK120-01"|"Intro to Marketing"|"0002234"|"3"|"MWF"|"08:00 AM"|"08:50 AM"|"MBB"|"314"|"Lecture" "Fall20XX-MK220-01"|"Marketing Research"|"0002234"|"3"|"TR"|"11:00 AM"|"12:20 PM"|"MBB"|"115"|"Lecture" "Fall20XX-MK320-01"|"Consumer Behavior"|"0002234"|"3"|"TR"|"1:00 PM"|"2:20 PM"|"MBB"|"213"|"Lecture" "Fall20XX-SP120-01"|"Spanish I"|"0002235"|"3"|"MWF"|"01:00 PM"|"02:50 PM"|"WER"|"111"|"Lecture" "Fall20XX-SP220-01"|"Spanish II"|"0002235"|"3"|"MWF"|"03:00 PM"|"03:50 PM"|"WER"|"112"|"Lecture" "Fall20XX-SP320-01"|"Spanish III"|"0002235"|"1"|"TR"|"09:00 AM"|"10:20 AM"|"WER"|"113"|"Seminar" "Fall20XX-CS120-01"|"Programming I"|"0002234"|"3"|"MWF"|"08:00 AM"|"08:50 AM"|"MBB"|"314"|"Lecture" "Fall20XX-CS120-02"|"Programming I"|"0002234,0002400"|"3"|"MWF"|"09:00 AM"|"09:50 AM"|"MBB"|"114"|"Lab" "Fall20XX-EN120-01"|"English I"|"0002237"|"3"|"TR"|"02:30 PM"|"03:50 PM"|"SRA"|"116"|"Lecture "Fall20XX-EN220-01"|"English II"|"0002237"|"3"|"MWF"|"08:00 AM"|"08:50 AM"|"SRA"|"117"|"Lecture" "Fall20XX-EN320-01"|"English Classic Lit"|"0002237"|"3"|"TR"|"08:00 AM"|"09:20 AM"|"SRA"|"117"|"Lecture" ...
(10 total fields)
Special Cases
Multiple Faculty Per Course
If you have multiple faculty who 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 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" "Fall2024-CS120-02"|"Programming I"|"0002234,0002400"|"3"|"MWF"|"09:00 AM"|"09:50 AM"|"MBB"|"114"|"Lab" "Fall2024-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 and set up the class lists so that the co-teachers 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 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. The same formattig rule is true for a course that meets in different locations during those times and days.
*For TimeFree and Present clients only: To ensure class schedules are populated correctly within TimeFree and events are created successfully in Present, 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 foundational / basic and required file.)
Comments
0 comments
Please sign in to leave a comment.