1 / 20

Custom Tools for Waitlist and Scheduling

Northwest DUG – Session 128. Custom Tools for Waitlist and Scheduling. Presenter: Sylvia Mossey, Centre for Education Information. Objectives. Identify AnswerNet documents that contain fixes for problems in these two areas Demonstrate custom tools. Miscellaneous Scheduling.

stacy
Download Presentation

Custom Tools for Waitlist and Scheduling

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Northwest DUG – Session 128 Custom Tools for Waitlist and Scheduling Presenter: Sylvia Mossey, Centre for Education Information

  2. Objectives • Identify AnswerNet documents that contain fixes for problems in these two areas • Demonstrate custom tools

  3. Miscellaneous Scheduling • Conflicts with same start and end times • Can’t rebuild section meeting dates in the past • Difficult to find an available room

  4. Conflict with same start and end times(AnswerNet doc #981.52)THE PROBLEM: When you use MSCH or SOFF to set up an event or class and you try to schedule it with an END TIME that's the same as the START TIME for an already established event, it shows a conflict.  When you schedule an event with a START TIME that is the same as the END TIME of an already established event, it DOESN'T show a conflict. Example: If there is a class that is from 10-11 and one from 11-12 and you rebuild them both, you will only get a conflict message on the 10-11 class. The 11-12 class will build without a problem.

  5. Conflict with same start and end times(AnswerNet doc #981.52)SOLUTION: AE CORE.INSERTS I_SUBR.CHECK.BOOK.CALENDAR Locate and comment out this line: 0355: *       IF V.CALS.START.TIME LE V.EVENT.END.TIME THEN Add this line: 0356: IF V.CALS.START.TIME LT V.EVENT.END.TIME THEN COMPILE S.CHECK.CALENDAR in the CORE toolkit. Note that other subroutines use this insert too.  You should compile all of these to pick up the changes in the insert:CORE\S.BOOK.CALENDAR CORE\S.CHECK.CALENDAR CORE\S.GET.RESOURCES, ST\S.BUILD.SEC.SCHEDULES ST\S.CHECK.FAC.SCHEDULES ST\S.CHECK.SEC.SCHEDULES ST\S.CHK.CONFLICT

  6. Can’t rebuild section meeting dates in the past (AnswerNet doc #147.918)PROBLEM: If the first line of meeting dates on SOFF starts in the past and you try to Rebuild Meeting Dates, you will get a message “Check entries in schedule print times, meeting dates not built” even if other lines contain future meeting dates. +------------------------------------------------------------------------------+ | 2 Schedule Print Times | | Instr Meth Bldg * Room St Time End Time Days of Week St Date End Date | | Room Assign Ind Frequency | | 1: Lecture CBA 276 08:30AM 03:30PM MTuThF 04-23-01 05-17-01 | | Weekly | | 2: Lecture CBA 211 08:30AM 03:30PM F 05-18-01 05-18-01 | | Weekly | | 3 Rebuild Meeting Dates: 4 * Actual Meeting Times: | +------------------------------------------------------------------------------+

  7. Can’t rebuild section meeting dates in the past (AnswerNet doc #147.918)SOLUTION: AE CORE.INSERTS I_SUBR.BOOK.CALENDAR Comment out the line show below (around line 33) IF X.DATE GE DATE() THEN and also comment out the corresponding END statement right after the GOSUB PRINT.DEBUG.SCHED (around line 56) Access CORE in the toolkit and GEN the process S.BOOK.CALENDAR.

  8. Difficult to find an available roomVAVR versus XVAR +------------------------------------------------------------------------------+ | 06-24-01 18:06 VIEW AVAILABLE ROOMS VAVR | |==============================================================================| | 1 Date Available.: 06-24-01 | | 2 Start/End Times: | +------------------------------------------------------------------------------+ | 3 Building Name Room Capacity Primary Usage | | 1: | | 2: | | 3: | | 4: | | 5: | | 6: | | 7: | | 8: | | 9: | | 10: | |aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa|

  9. Difficult to find an available roomVAVR versus XVAR +------------------------------------------------------------------------------+ | 06-24-01 18:09 VIEW AVAILABLE ROOMS XVAR | |==============================================================================| | Begin End 7 Locations.......: 1: | | 1 Dates..........: 06-24-01 8 Buildings.......: 1: | | 2 Start/End Times: 9 Room Types......: 1: | | 3 Room Capacity..: 10 Room Usages.....: 1: | | 11 Room Categories.: 1: | | 4 Duration.........: 12 Room Characteristics: 1: | | 5 Meetings per Week: 13 Equipment Type......: 1: | | 6 Days of the Week.: 1: 14 Search Now..: | +------------------------------------------------------------------------------+ | 15 * Building Name Room Capacity Primary Usage | | 1: | | 2: | | 3: | | 4: | |aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa|

  10. XVAR - Features • Ability to search using: • Date range • Time range • Duration • Number of meetings per week • Days of the week • Ability to limit search by: • Room capacity • Location • Building • Room Type, Usage, Categories and Characteristics • Equipment Type • Detail on room to BRCS or RMSM

  11. XVAR – Sample Search • Classroom (coded as category 110) • Room for at least 40 people • In the Young building • Between June 1 – 30th • Two meetings per week • Weekdays only (Mon – Fri) • Two hour booking • Anytime between 9 am and 3 pm

  12. Course Waitlist • Waitlist data not showing on STWM • Can’t waitlist for multiple sections of a course • Difficult to manage waitlist using CWLM

  13. Waitlist data not showing on STWM (AnswerNet doc #1924.56)PROBLEM: If a student puts themselves onto several waitlists through WebAdvisor - one of the records may not show on STWM or on My Schedule on WebAdvisor. This will only happen when the Rating, Status Date and Status Time on more than one WAIT.LIST record for a student are identical.

  14. Waitlist data not showing on STWM (AnswerNet doc #1924.56)SOLUTION: In ST.INSERTS S.GET.WAITLIST: 217: **      LOCATE X.FLD IN XL.SORTED.LIST<1,1> BY "AR" SETTING XX ELSE 218: **         INS X.FLD BEFORE XL.SORTED.LIST<1,XX> 219: **         INS V.WAIT.LIST.ID BEFORE AL.WAIT.LIST.ID<1,XX> 220: **      END 221:       LOCATE X.FLD IN XL.SORTED.LIST<1,1> BY "AR" SETTING XX THEN 222:          INS X.FLD BEFORE XL.SORTED.LIST<1,XX> 223:          INS V.WAIT.LIST.ID BEFORE AL.WAIT.LIST.ID<1,XX> 224:       END 225: ELSE 226:          INS X.FLD BEFORE XL.SORTED.LIST<1,XX> 227:          INS V.WAIT.LIST.ID BEFORE AL.WAIT.LIST.ID<1,XX> 228: END Comment out the first locate and replace with the second locateto ensure that all the WAIT.LIST records get added.

  15. Can’t waitlist for multiple sections of a coursePROBLEM: The policy at many of the institutions in B.C. is to allow students to waitlist in multiple sections of a course. Colleague’s default behavior is to allow a student to waitlist in only one section of a course.

  16. Can’t waitlist for multiple sections of a courseSOLUTION: If you have access to the Tool-Kit. Edit the ST subroutine S.REG.STU.WAITLIST and around line 45, change three lines: V.WAIT.LIST.ID = "" A.INDEX = "WAIT.COURSE":@FM:"WAIT.STUDENT" A.OPER = "EQ":@FM:"EQ" A.VALUE = V.SEC.COURSE:@FM:A.STUDENTS.ID CALL S.GET.INDEX(V.WAIT.LIST.ID,"WAIT.LIST",A.INDEX,A.OPER,A.VALUE) V.WAIT.LIST.ID = "" A.INDEX = "WAIT.COURSE":@FM:"WAIT.STUDENT”:@FM:”WAIT.COURSE. SECTION” A.OPER = "EQ":@FM:"EQ“:@FM:”EQ” A.VALUE = V.SEC.COURSE:@FM:A.STUDENTS.ID:@VM:A.CS.ID CALL S.GET.INDEX(V.WAIT.LIST.ID,"WAIT.LIST",A.INDEX,A.OPER,A.VALUE)

  17. Difficult to manage waitlists using CWLMCWLM versus XWLM +------------------------------------------------------------------------------+ | 06-24-01 20:51 COURSE WAITLIST MANAGEMENT CWLM | | Course Name: ENGL-101 Title: English Composition | |==============================================================================| | Status Pref Home | | 1 * Current Waitlist Rating Stat Date Sect Telephone | | 1: 244557 Peter Pan 0 A 06-04-01 002 | | 2: 0244561 Bart Simpson 0 A 06-04-01 003 | | 3: 0244547 Big Bird 0 A 06-06-01 001 | | 4: 0244558 Captain Hook 0 A 06-09-01 001 | | 5: 0244551 Scooby Doo 0 A 06-11-01 004 | | 6: 0244554 Bugs Bunny 0 A 06-12-01 003 | |------------------------------------------------------------------------------| | Status Enrolled Enrolled | | 2 Previous Waitlist Stat Date Section Term | | 1: 0244550 Duck, Donald Enrol 06-24-01 002 2001F | | 2: 0244559 Mulder, Fox Dropp 06-18-01 | |aa Controller Current Waitlist aaaaaaaaaaaaaaaaaaaaaaaaaaa Value 1/17 aaaaaaaa|

  18. Difficult to manage waitlists using CWLMCWLM versus XWLM +------------------------------------------------------------------------------+ | 06-24-01 20:50 COURSE WAITLIST MANAGEMENT XWLM | | Course Name: ENGL-101 Title: English Composition | |==============================================================================| | Status Status Preferred Home | | 1 * Current Waitlist Rating Stat Date Time Term Sect Telephone | | 1: Peter Pan 0 A 06-04-01 06:57PM 2001F 002 | | 2: Bart Simpson 0 A 06-04-01 08:08PM 2001F 003 | | 3: Big Bird 0 A 06-06-01 06:50PM 2001F 001 | | 4: Captain Hook 0 A 06-09-01 06:57PM 2001F 001 | | 5: Scooby Doo 0 A 06-11-01 06:52PM 2001F 004 | | 6: Bugs Bunny 0 A 06-12-01 06:54PM 2001F 003 | +------------------------------------------------------------------------------| | Status Preferred Enrolled | | 2 Previous Waitlist Stat Date Term Sect Term Sect | | 1: Duck, Donald E 06-24-01 2001F 002 2001F 002 | | 2: Mulder, Fox D 06-18-01 2001F 003 | |aa Controller Current Waitlist aaaaaaaaaaaaaaaaaaaaaaaaaaa Value 1/17 aaaaaaaa|

  19. XWLM - Features • Additional LookUps by Student and Section • Search by Student capability after records displayed • Ability to modify Status Time • Ability to modify student’s preferred section (section must be full) • Ability to modify status of student on previous waitlist • Previous waitlist section shows original preferred term and section

  20. Questions

More Related