Worksheet (in sequence) / Scheduler Workbooks / Scheduler Workbooks / Content and Uses
Included / Protected / Hidden / Included / Protected / Hidden
Info & Tools / yes / yes / no / yes / yes / no /
- Link to instructions
- Various sorting and formatting tools
Lecture-Lab Schedule / yes / yes / no / yes / yes / no / Entry area for of lecture and lab courses
Additional Instructors / yes / yes / no / yes / yes / no / Entry area for additional instructors for lecture and lab courses
FldWrk-Ind Study Schedule / yes / yes / no / yes / yes / no / Entry area for field work and independent study courses
Control Data / yes / yes / yes / yes / yes / no / Information to control entry in above three worksheets:
- Year, term, scheduler
- Instructors for scheduling entry
- Other information
Rooms / yes / yes / yes / yes / yes / yes / Information to control entry of classrooms
LL Courses / yes / no / yes / yes / no / yes / Information to control entry of lecture and lab courses
FI Courses / yes / no / yes / yes / no / yes / Information to control entry of field work and independent study courses
FINAL / no / -- / -- / yes / no / yes / Compilation of all information needed to control further processing of SPHIS schedule
FIsummary / no / -- / -- / yes / no / yes / Listing of section counts for field work and independent study courses
RevCtrl / no / -- / -- / yes / yes / no / Assisted control for processing revisions to schedule
Sched by Day / no / -- / -- / yes / yes / no / Schedule of courses by day of week
Sched by Course / no / -- / -- / yes / yes / no / Schedule of courses by course ID
Sched by Instr / no / -- / -- / yes / yes / no / Schedule of courses by instructor and additional instructor
DRAFT / no / -- / -- / yes / yes / no / Listing of schedule as currently known to Registrar in registrar format
Ddups / no / -- / -- / yes / no / yes / List of duplicate courses in DRAFT
Dserial / no / -- / -- / yes / no / yes / Information extracted from DRAFT to compare with FINAL
DFsched / no / -- / -- / yes / no / yes / All information in DRAFT and FINAL with comparison data
FDcomp / no / -- / -- / yes / yes / no / Comparison of all course information in DRAFT and FINAL in registrar format (excluding classroom information)
FDdiff / no / -- / -- / yes / yes / no / Differences in course information between DRAFT and FINAL in registrar format (excluding classroom information)
- This is empty after reloading of DRAFT from ReDRAFT
CRdiff / no / -- / -- / yes / yes / no / Differences in classroom information between DRAFT and FINAL in registrar format (only for classrooms that Registrar keeps track of)
- This is empty after reloading of DRAFT from ReDRAFT
ReDRAFT / no / -- / -- / yes / yes / no /
- Revision of DRAFT based on changes to schedule in registrar format
- Copied to DRAFT after schedule and classroom changes are captured
Lists / no / -- / -- / yes / no / yes / Additional information needed to process schedules sent by Registrar:
- Days of week codes
- Instructor names used
Hashes / no / -- / -- / yes / no / yes / Specifications used for building data hash keys used in processing
DRAFT 1 / no / -- / -- / yes / yes / no / Initial draft of schedule sent by Registrar in registrar format
- Data are pre-processed into DRAFT1DataforDRAFT (which see)
Reg A to Reg G / no / -- / -- / yes / yes / no / Each dated sheet has changes to schedule sent to Registrar in registrar format and is frozen copy of the then-current FDdiff (which see)
CR A to CR G / no / -- / -- / yes / yes / no / Each dated sheet has changes to classrooms sent to Registrar in registrar format and is frozen copy of the then-current CRdiff (which see)
DRAFT1DataforDRAFT / no / -- / -- / yes / yes / no / Data from DRAFT1 pre-processed for copying to DRAFT (only once at outset)
- DRAFT1 data are translated and formatted as needed by DRAFT
- Data required by DRAFT are added
Specs / no / -- / -- / yes / yes / no / This sheet
Totals / 8 / 6 / 4 / 29 / 20 / 10
Cross-Checks / 4 tabs should be showing
All should be protected / 30 tabs should be showing
All should be protected