Fall 2016/Winter 2017
Timetable in DCU
January 9, 2017
Fall 2017/Winter 2018 Timetable Production Schedule
2
Date Activity
December 1st DCU is open for Fall 2017/Winter 2018
data entry.
February 1st DCU is closed for data entry; Deadline
for STA forms.
April 10th Deadline to review prerequisites at the
course levelMay 2nd Fall 2017/Winter 2018 timetable
uploaded to Banner
Fall 2017/Winter 2018 Timetable Production Schedule
3
Date Activity
May 2nd – May
12thDepartmental Timetable Coordinators
review timetable and submit changes.
May 26th Timetable is published on Carleton
Central
August 31st Post room assignments on Carleton
Central + students are notified of a
time/room change via auto email
notification
DCU LINK
� Go to http://dcu.carleton.ca and login to DCU
using you network login and password.
� To log out, click on your user name in the top
right corner and select Log out
4
SES website – excellent source of
information!
5
� Timetabling Documentation:http://carleton.ca/ses/content-timetabling-administrators/
Special Timetabling Arrangement
(STA) Requests
� STA requests DID NOT roll over from last year.
� Departmental Timetabling Coordinators collect STA
information from instructors
� We suggest that the STA data collection form
(http://carleton.ca/ses/wp-content/uploads/STA-
data-collection-form.pdf) is emailed to instructors;
they complete the form and return it to the
Departmental Timetabling Coordinator
6
Special Timetabling Arrangement
(STA) Requests
� When an instructor makes an STA request, the
Departmental Timetabling Coordinator contacts the
Chair of the department to assign an appropriate
category to the request.
� Then the Departmental Timetabling Coordinator
enters the STA information, including the assigned
category, into the DCU.
�STA Examples: http://carleton.ca/ses/timetabling/preparing-for-
coordinated-timetable/examples-of-special-
timetable-arrangements/7
UTC approval required for:
�Forced times requests (except for contract
instructors)
�Off-pattern timeslot requests (note that off-
pattern scheduling arrangements affect student
timetables and room utilization).
�Departmental meeting or other
administrative/academic activities exceeding 3
hours a week
8
UTC Approval
� The proposed schedule along with the rationale
must be submitted to the University Timetabling
Committee (via memo or an email to Suzanne
Blanchard), for approval review.
� If the request is approved, the departmental
timetabling coordinator will then enter the
information into the DCU.
9
Forced times
� Approval is NOT necessary for contract instructors.
� Details regarding contract instructors should be
recorded in the Time Requirement text box on the
Component Editing screen in DCU.
10
Forced rooms
� Departmental rooms can be forced by departmental
administrators in the DCU without approval; this
information will not be purged.
11
TA Ties
� TA Ties are ties between graduate and
undergraduate courses. Teaching assistants (TAs) for
undergraduate courses are typically hired from a
pool of grad students.
� TA Ties ensure that both the graduate course and
undergraduate course are assigned to be scheduled
conflict-free.
� 2016-17 TA Ties have been rolled over into 2017-18
� SCH_TA_TIES_VALIDATION_REPORT displays TA Ties
entered into SZATTDT for a selected department in a
selected term.12
TA Ties
� All changes to TA Ties should be done in SZATTDT
form in Banner.
� SZATTDT is now open for data entry; it will be closed
on February 1, 2017.
� Please note that although we strive to fulfill all TA
Ties, in some cases it is not possible due to other
constraints imposed on courses (e.g. STA requests).
13
Course Combinations
� A course combination is a set of courses that are
required to be scheduled conflict free for a specific
number of students in a program.
� Course combinations are entered into the DCU by
departmental timetabling coordinators.
� 60 students in program X will be taking BUSI 1004,
ECON 1000 and BUSI 1800 in the Fall term
14
Course Combinations
Academic block:
BUSI 1004 A
BUSI 1800 A
BUSI 1800 A01
ECON 1000 A
ECON 1000 A01.15
Course Combination:BUSI 1004ECON 1000BUSI 1800
�Course combinations are used by the TPHi-Assignermodule to automatically create the required academicblocks which are then used in the timetabling process.
�An academic block is a set of course sections(CRNs) that need to be scheduled conflict free.
Course Combinations
� It is important to capture the program
requirements in all their variety to make sure
that students in the program get a conflict free
timetable.
� Do you have a new program? Have there been
changes for one of your old programs? Do you
wish to restructure an existing course
combination?
16
Add a New Course Combination
� When constructing a course combination, the
best starting point is the undergraduate and
graduate calendars.
� Identify the core/elective/optional courses that
are required to be conflict free with each other
so that students in a program can take them in
the same term to fulfill the program
requirements.
� It is not recommended to include more than 6
courses in a course combination. Students rarely
take more than 6 courses in a given term.
17
Course Combinations
� Course Combinations are term specific. Fall term
courses are listed in one block and winter term
courses are listed separately in another block.
� You need to know which term (fall or winter) the
courses are offered in so that you can include them
in the appropriate course combination.
� Only one section from a cross-list needs to be
recorded.
� More info on course combinations:
http://carleton.ca/ses/content-timetabling-
administrators/18
Add a New Course Combination• Start with the program requirements in the
calendar:
19
Course Combinations Template
In DCU: if you wish to use a specific course offering, e.g. AFRI
2003 A:
� Place the component under a separate section
� Specify the course section for the course under the course
combination
20
Course Combinations Template
� If there is no need to use a specific course
offering OR
� If there is only one section of the course,
LEAVE THE SECTION FIELD BLANK
21
Program Registration Report
� SCH_PROGRAM_REGISTRATION_XLS report
displays student registration in a selected term.
� Run the report to see courses in which students
in your department were registered in the
previous academic term.
� Filter the report by Major Description and (for
undergraduate programs only) by Class (U1,
U2…).
22
Student Count
� Review student count for your course
combinations
� Student count must be as realistic as possible,
although it is still a guess. Use the SZACOMB form
in Banner to realistically estimate the student
count for a course combination.
� Use REG_ENRPROG report for information on
enrolment by program (undergraduate programs
only). For example, if you have only 50 students in
the program, you should not set the student count
to 100!
23
Student Count� Use SZACOMB form in Banner to check how
many students were enrolled
� in each course of a course combination in the
previous like term and
� in all courses of a course combination at the
same time in the previous like term
� SZACOMB counts do not include students who
registered in the course initially but dropped the
course later.
� CUOL courses are excluded from the count.
24
Student Count
25
Student Count
• Enter the term, the department, select a major code
from the Major pick list and a class (year of study)
code from the Class pick list.
• Enter the courses that form the course combination.
Note that the Number of students enrolled in course
column displays the number of students in the
selected major and class enrolled in each entered
course in the selected term.
• Click on the Calculate total per Combination button
to see the number of students enrolled in all courses
of the course combination in the selected term.
26
Restructuring a Course Combination
Example 1� Note two language courses in this course combination
� This course combination claims 30 seats in SPAN1110 and
ITAL1010 for first year BUSI BIB students.
� Most likely students will not be taking both language
courses in the same term.
� It is likely that the students will be taking either SPAN1110
or ITAL1010 in the Fall term to satisfy their language
requirement.
27
Course
Combination Program ID Level
Faculty
ID
Department
ID
Faculty
ID
Depart
ment ID Course ID
Catego
ry ID
Studen
t Count
Comme
nt
BUSI BIB Block 1- BUSI BIB 1 1 7BUSI 7BUSI BUSI1004 F C 30
BUSI BIB Block 1- BUSI BIB 1 1 7BUSI 7BUSI BUSI1701 F C 30
BUSI BIB Block 1- BUSI BIB 1 1 7BUSI 8LALS SPAN1110 F C 30
BUSI BIB Block 1- BUSI BIB 1 1 7BUSI 9ECON ECON1000 F C 30
BUSI BIB Block 1- BUSI BIB 1 1 7BUSI 8LALS ITAL1010 F C 30
Restructuring a Course Combination Example 1� To reflect student demand more accurately, it is
recommended to divide the student original combination
into two smaller combination with only one language
course.
� Student count for each new course combination is
assigned proportionally (10 students are expected to take
ITAL1010, 20 students – SPAN 1110).
28
Course Combination Program ID Level Faculty ID
Department
ID Faculty ID Department ID Course ID
Category
ID
Student
Count Comment
BUSI BIB Block 1- BUSI BIB 1 1 7 BUSI 7 BUSI BUSI1004 F C 10
BUSI BIB Block 1- BUSI BIB 1 1 7 BUSI 7 BUSI BUSI1701 F C 10
BUSI BIB Block 1- BUSI BIB 1 1 7 BUSI 9 ECON ECON1000 F C 10
BUSI BIB Block 1- BUSI BIB 1 1 7 BUSI 8 LALS ITAL1010 F C 10
Course Combination Program ID Level Faculty ID
Department
ID Faculty ID Department ID Course ID
Category
ID
Student
Count Comment
BUSI BIB Block 2- BUSI BIB 1 1 7 BUSI 7 BUSI BUSI1004 F C 20
BUSI BIB Block 2- BUSI BIB 1 1 7 BUSI 7 BUSI BUSI1701 F C 20
BUSI BIB Block 2- BUSI BIB 1 1 7 BUSI 8 LALS SPAN1110 F C 20
BUSI BIB Block 2- BUSI BIB 1 1 7 BUSI 9 ECON ECON1000 F C 20
Prerequisites
� Prerequisites are not part of DCU
� Prerequisites in Banner have two
levels: course level (SCAPREQ)
and section level (SSAPREQ).
� When the new timetable is built
and uploaded to Banner, course
sections (CRNs) will ”inherit”
prerequisites stored at the course
level (SCAPREQ).29
Course level:
E.g. ECON 2400
(SCAPREQ)
Section level:
E.g. ECON 2400 A
(SSAPREQ)
Prerequisites
Prerequisites at the course level� It is important that you review your prerequisites
at the course level before the first upload, to
make sure that course sections inherit the right
prerequisites.
�For the Fall 2017/winter 2018 timetable
deadline is April 10th
� To review prerequisites stored at the course level,
run the new report SCH_COURSE_LEVEL_PREREQ
(enter the term 201730).
30
Prerequisites at the course level� To modify existing prerequisites at the course
level, go to the SCAPREQ form, enter Subject,
Course number and the term 201730, perform
Next Block and click on the Course Prerequisites
Restrictions tab.
� Note: Far Fall/Winter courses enter 201730 even if
the course is offered in the Winter!!! In this case
201630 is not the term when the course is offered,
it is the calendar “effective” term for prerequisites.
31
Prerequisites at the course level
32
� To change prerequisites at the course level click on
the Maintenance button (if enabled), select copy
restriction, make the change and save.
Prerequisites at the section level� After the first upload, any changes to prerequisites
should be done at both levels (in SCAPREQ and
SSAPREQ). At that point, changes made at the
course level will not be passed to the section level
and vice versa.
33
DCU Closure� DCU will be closed on February 1st (end of day)
� After DCU is closed for data entry, you will be able
to access DCU to view the data you had submitted
and to assign instructors.
� DCU will be locked in March and April for timetable
building. During these months administrators will
be submitting requests for instructor assignments
through SZACHRU form in Banner.
34
Invalid Primary Indicator Assignment Warning
� The warning message will appear for components
with no instructors assigned. Changes will be
saved. Ignore the message.
35
DCU Support• Email: [email protected]
• Julia Piatigorskaia: ext. 8877
• Phay Mui: ext. 8803
• Amy Resmer: ext. 3009
Documentation: http://carleton.ca/ses/content-
timetabling-administrators/
36