Team Assignment 1 (due: in email midnight of 5/26; and to present --if selected-- on 6/1)

Submit workbook solution to william.leigh@bus.ucf.edu by midnight 5/26 as attachment. Submit your presentation powerpoint file as a second attachment. Include only these two attachments. Include in the email message the team number followed by the names of the team members who participated in the development of the solution and a second list of those team members who did not participate in the development of the solution (presence on this non-participation list will have the same effect on the grade as a class absence). Designate the team leader in the list of team members. Copy the submission email to all members of the team.

By midnight 5/27 you will receive a grade via email reply (reply all). That reply may include a request to present your system in class on 6/1. The teams submitting the very best solutions will be asked to present. If you are not asked to present or you choose not to present if asked, then your presentation delivery grade will be zero. One to three team members may present -- present the powerpoint file that you submitted (you may continue to improve it after submission) and do a live demonstration of your solution. Initial presentation should be limited to 15 minutes. Then answer questions for as long as there are any.

The very best submissions (the ones selected for presentation) will be sent to all class members by the instructor through the class email group.

Use Nurse Scheduling DSS Version 1.0 as a basis system. You will modify this base system. Call your solution "Nurse Scheduling DSS Version 2 Team NN" (where NN is your team number).

Modifications needed:

Allow no more than N shifts to be scheduled in one week for any nurse. N is to be entered by the user as a user input. Test with values of 5 and 6 for N.

Provide a paper form for nurses to fill out showing their personal preference shift block-outs for each day of the coming month. The information from these forms is to be entered into the system and used for day by day scheduling.

If a nurse guarantees not to block-out  (by personal preference) one shift on any day for a month then the hospital guarantees at least 12 assignments to that shift in the month. For example, a nurse may choose to guarantee no block-outs for shift 2 and in return the hospital guarantees that that nurse will be scheduled to shift 2 at least 12 times in the month. The nurse has to explicitly note that the option is selected -- not blocking out the shift is not sufficient to receive the guarantee. The DSS user must realize when too many nurses have selected this option, making it impossible to schedule complete coverage for the month. Iif too many nurses elect this option for a shift then give priority to nurses with seniority in the hospital. The system should aid the operator in accomplishing all of these functions.

Update the system documentation for your changes and additions.

Document that you executed at least 5 distinct tests of the new version -- in 5 new worksheets named "Test1" to "Test5" show the inputs and the outputs generated for 5 sets of input values. Explain in narrative how you tested for the new week and month constraints (in a worksheet entitled "special testing explained".)

Report any errors in the existing system or in the new version system on the worksheet provided.