300585 - Systems Analysis & Design Workshop 7 Workshops will run to cover the practical aspects of the topic each week with two workshop case studies that runs across the whole semester and some other examples time to time. The workshop runs in two parts  Workshop slides  Workshop questions o This document contains two parts o Part A contains two case studies and questions that are to be done in workshop with the help of tutor ( to be done in Group of 2 students). Task 1 of this part would always refer to Willow brook Case study and rest of the tasks may relate to a continuous (UWS Transport Management System) or some additional case studies o Part B contains questions and tasks related to case studies that individual

students need to answer in their own time and submit as a part of Portfolio(s) as per the due dates given in the Learning guide. Part A: Workshop work to be done during the workshop Task 1

Willow brook School is a small private school that has retained your services as a systems analyst to assist in the development of a new information system for the school's administrative needs. Background

After presenting the system requirements document to Willow brook, the staff has approved

your recommendations for a new computer system. Last workshop we began the design phase of the SDLC and designed UIs for Michelle. This system for school would contain components such as students, staff, classrooms, after-care, payments and any other area that may be recognized in sprint review to be included in a working system. This workshop we would design user interface including screens and forms for inputs, navigation and reports for outputs. Please review the documentation you prepared during the systems analysis phase such as mind

maps, user stories, and process diagrams and design these user interfaces for Willow brook. Questions: Go through the reading slides for workshop in the readings section and attempt the following 1. Create a switchboard design with appropriate control buttons that lead to system component student. Please make sure that you consider any other area you think should

be in a working system of your own design related to workflow related to UI for Michelle to enter & edit student details and generate reports. 2. Prepare storyboards that show lower-level menus including data entry screens. Allow

Michelle to add, update, or delete student. Suggest context-sensitive and specific help and feedback for the proposed screens. 3. Suggest at least six types of data validation rules for three data entry screens created in part 2 above. Task 2

Case Study UWS Transport management information system Fact-Finding Summary Students travelling to UWS using the OPAL card system have the following options. The first is students arriving from Parramatta by bus getting off at the University Bus stop. Second is the using the train and getting off at Rydal mere station and walking to the university. It was understood that while Rydalmere is the closest station to the university, it is not effective to

collect data from students because students may travel to the station and not travel to the university and hence making them ineligible for the travel concession. To overcome this challenge Dean suggested to have an Opal reader at the University main entrance which would then make it easier to track students travelling to the university and this would solve the problem of identifying legitimate students eligible for concession.

The System requires capturing every detail of the student and his corresponding opal card. Opal card is linked to students using the student ID. The current system maintains only the student information and relevant information relating to enrolled subjects. Combining the new fields from the Opal database to the existing student

records can lead to data issues and potentially cause errors. Catherine wanted the Student Opal information and Student Information to be linked by the student id , such that she is able to track attendance. The new fields which are to be maintained by the system are as a follows 1. Student ID

2. Student name 3. OPAL card number 4. No of Trips made in this week 5. No of trips to the university 6. Total Travel Cost

7. Travel cost eligible for concession – Yes /No field subject to concession conditions met 8. History of each trip 9. Date and Time of travel

10. Mode of travel – Bus or Train 11. No Tap off registered Catherine laid down the conditions for the concession to be given to the students. A summary monthly report is generated for the administrative department from this spreadsheet summarizing fee collections from the OPAL card to the University. All travel exceeding 40 dollars are only eligible for travel concession. Travel must be between a Monday and a Friday and all trips beyond the 8 trips is not considered for travel concession. Students must have attended at least one class on the date of travel else they are not eligible for travel concession.

Catherine has indicated that the most useful new feature that could be added to the system would be the ability to generate one bill per student, listing each student's charges separately, and an overall total. Also useful would be the ability to generate a receipt at the time payments are recorded. The concession receipt should contain student id and Opal details and amount of concession and should be approved by admin team. On Friday midnight Catherine wants the system to generate each student's bill for the week to be

emailed once generated. Questions: Go through the reading slides for workshop in the readings section and attempt the following 1. Create a switchboard design with control buttons that lead to system components student and Opal card. Components may include a user login screen to the New Information

system and further into the student records where the student details, Course enrolled, OPAL card details are stored and any other area you think should be in a working UWS Transport management system design.

2. Prepare storyboards that show lower-level menus including data entry screens. Allow a user to add, update, or delete records in each area of student, Opal card and course. Suggest context-sensitive and specific help and feedback for the proposed screens. 3. Design the student weekly bill with all characteristics of report design. 4. Would you include data validation in the bill? Justify your answer

5. Is there a need for an exception report here? Can this required data be generated in other report? Part B: Portfolio exercises to be included in Portfolio submissions Please note that Task1 of Part B is a continuing case study Task 1

On the Spot Courier Services As On the Spot Courier Services continues to grow, Bill discovers that he can provide much better services to his customers if he utilizes some of the technology that is currently available. Previously, customers were able to either call On the Spot and request a package pickup or visit the company's Web site to schedule a pickup. Once customers logged in, they could go to a Web page that allowed them to enter information about each package, including "deliver to"

addresses, size and weight category information, and type of service requested. On the Spot provided "three hour," "same day, and overnight" services. To facilitate customer self-service, On the Spot didn't require exact weights and sizes, but there were predefined size and weight

categories from which the customer could choose. Questions: Go through the reading slides for workshop in the readings section and attempt the following 1. Create a story board of the customer login screen and the next page which contains the

following for pickup details Name Address Pickup

Schedule Pickup with enter time facility Size of Package Weight of package

2. For the login and pick up screen, suggest three data validation criterion. Task 2 Ocean Sound College

Ocean Sound College is a liberal arts college located on the West Coast. You are the systems analyst assigned from the college IT department to conduct the systems analysis phase of the

development of a new listing system for the school's housing office. The college has requested for a detailed report to be generated on a monthly basis on the student attendance for each month for each class. Report should include default student information such as name , class , age , followed by number of days attended and class attended percentage of student out of total sessions. For example if a student has attended 6 out of 10 then his attendance is 60%. Design a sample report with all characteristics of report design.

Questions: Go through the reading slides for workshop in the readings section and attempt the following 1. Design the requested report with all characteristics of report design. 2. Would you include data validation in the report? Justify your answer 3. Is there a need for an exception report here? Can this required data be given in a other report?