Term Project Every two weeks project discussion in the class and update. Part 1: Presentations are due Week 11, Week 12 project presentations in the class. If you ready earlier you can present earlier. Exact dates will be determined ir the later of the sernester. Part 1: Project presentation: The goal of the project: Provide Planning, Analysis and Design of the information systems application. What needs to be done: Provide solution to one af the problems described below. You will wark in Tearn of 3-4 students and deliver presentation and presentation material to the class. Each tearn will select one theme to present. Your deliverable for this part is a PowerPoint presentation in front of the class. We will discuss it in the class in a greater detail. Please select your team and a team leader. Once you've selected your team, please e-mail mkleban@asa.edu with the following information: Subject line: CIS-220 Presentation team-Leader's Name 5ubject Body: List all term members and topic of your presentation. Plesse select at least 2 topics. Grading breakdown: A. 10 points - Prajert organization: Following submittal directians and presertation norganization B. 10 points -Group work. How wel group worked together, conflicts, resolutions, etc... That grade defived from instuctor's obscrvation correlates to the course and project, knowledge of content D. 10 points - Psst presentation questions. How well studert answer post presertation quastions, knowledge about class material and project. E. 10 points-presertation skills. How wel student articulates material to others, oral skils, ctc... ASA COLLEGE CIS220-5ysterns analysis and Design Instructor: Maksim Kleban Medical Difice af Eduardo Gornex is seeking help from Informational Systems analyst to design an Elcctronic medical record system for his small medical practice, Currently, all paticnts' records lept in a hard copy at storage facility, When paticnt makes an apgointment to see Dr. Gomer, Office requests recond from a facility. It takes 24 hours to get a physical copy of the record, plus facility charges $15 per record they deliver. If Ur. Gomez needs record sooner he has to pay a double fee ($30) to bring record from the facility within 1 hour. Dr, Gomez has only ono computer in the office which is primarily used for running billing program. All appointment scheduling is done on praper by two people. Due to handwriting issues sometimes it is not possible to read next patients name and time of appointment. Therefore in many instances Dr. Gomez doesn't know who is coming to sec him and he has to order deliwery of many unnecessary records and pay moncy for records he doesn't need in the nffice. On awerage Dr. Gomer sees about 30 patients a day, hut usually due to ditficulty in understanding handwriting he orders 45 records a day. Also, sometimes test results are not added and reviewed on time, since the records is not in office, In result when patients test results are not normal, it takes ahout 2448 hours for patient to know about it. Since doctor necds patient record in prder to evaluate patient's health. Ur. Gomez is planning to open second location, which is going to be far from storage facility. Storage facility can't deliver records that far. Therefone Dr. Gomez wants to create information system which will help him facilitate record access and appointment tracking at his two locations. Dr. Gomez is planning to open second location, which is going to be far from storage facility. Storage. facility can't deliver recards that far. Therefore. Dr. Gomer wants to create information system which will help him facilitate record access and appointment tracking at his two locations. Systems Analyst needs to deliver plan, analysis and basic design for implementation to solve Dr. Gomer problem. Theme 2 - Travel and leisure: Hotel Reservation System The new hotel brand Jennifer's Hotel chain is opening 55 hotels all over the United States. Therefore Jenniler's hulel is louking Ior help of Systerris Anslyst to design hotel's rourn buokirg arid rrarketirig systems. It is expected that they will have visitors not only from United States, but from all over the world. Due to high value af euro they want to rnarket to Eurapean Urian courtries which riostly speak English, 5panish, Fitench and Greek. Also in additivri to selling holel accornrodation, the systerr must provide useful information and drive sales of local entertainment facilities such as movie theaters, shows, local tnurs, museums and other specialty stores. It is expected that all hotel staff will he computer literate and be available for trairing. The same systern must be used at all chain's locations. Systems Analyst needs to deliver plan, analysis and basic design for implementation. A5A COLLEGE CIS220 - 5ysterns analysis and Design Instructor: Maksim Kleban Interim Inc. is a staffing consulting compery. Interim provides temporary staffing for large and small companies in New York State. Currently each temporarily assigned employee must submit weekly tirnesheets through rnail to rnain office which is located in Brooklyri, NY. After tirnesheets received iri main office, data entry person enters timesheet into the system. Then tata entry person prints a report and sends it in hard copy to accounting, depertment. At accounting it gets revieved by staff accounting clerk and check is written. After that the check goes into mailing room, it mailed directly to an pluyee. It takes about 3 days to receive a timesheet for the working week from an employee who works far from Rrooklyn. Then it takes ahout 24 hours for data entry person to enter timesheet in a computer and produce a report tor accounting department. Depends pro a tacklog it takes 2448 hours to approve the tirnesheet arnd issue a check. After check gets to mail room it ther rnailed back to the empluyer. On average it takes 3 deys for an employee to receive a check. So from mailing timesheet to receiving a cherk it takes about 11 days. During those days employee dosen't know at what phase his timesheet. Interim Inc is laoking for help of Systerns Analyst to create tyramic application to create better efficiency in handling payments to employees, Systems Analyst necds to deliver plan, analysis and basic design for implementation to solve Interim inc. problem Theme 4: Ecommerce - Intemet driven sales Markaff Electrorics, Inc is a local electronic store in Milford, PA. It sells electronics to lacal residerits for more than 10 years. The owner of the store wants to expand business and stant selling electronics online. For that he would like to open an intemet store to accept orders through internet from all over United States. Owner of the store is computer literate and have working pc in his store, but never vpet aled tusiness urilirie. 5ysterns Arialyst needs to deliver plari, analysis and besic design for implementation for desired ecommerce solustinn. 5ysterns Aralyst netets to deliver plari, aralysis arnd besic desigri for implemeritation for desired ecommeree solustion. Theme S: Warchouse solutions General Wher Warehouse Corporation, provide warehouse solutions for different businesses around New York City. Warehouse provides supplies storage to different companies by following guidelines below: - Once supplics owner buys supplies it shipped directly to warchouse and warehouse clerk notifies supplies nwner over the phone what supplies were delivered. Clerk should write everythirg dowr on a paper and issue inwoice for storing such items. The inwoice should be issued on monthly basis bascd on the number of supplies stored by the warchouse. - Once supplies owner needs supplies, they have to call to the warehouse and request it. The warehouse clerk writes everything down on a paper and packs supplies. The written paper Page 3 af 5 ASA COLLEGE CIS220 - Systems analysis and Design Instruactnr: Maksim Klrban stored in a file cabinet for the record keeping. Also, the warehouse clerk should update the currently stored supplics list, for proper billing. If there are no supplies left, the clerke necds to call supplies owner and notify that there are no supplies left. - After supplies pasked warehouse clerk should call to the Delivery Cornpariy to pick up supplies. Delinery Company delivers it to the supplies aviner. - Dnce supply owner recciwcs supplies he has to issue paymcnt for deliwery of the itcms to warehouse with check mailed via USP5. After such payment received the warehouse routes - Nfter supplies pecked warehouse clerk should call to the Delivery Company to pick up supplies. Delivery Company delivers it to the supplies owner. - Drice supply awrer receives supplies he has to issue payrnent for delivery af the iterns to warchouse with chock mailed wia USPS, After such payment received tho warehouse routes cherk to the deliwery company. Also since cverything is paper hased, the Warehouse should keep all copies of checks and docurnents in case there will be any dispute hetween inwolved parties. Bascd on the information above it was concluded that such way of running business is outdated, wastes a lot of time, space and facilitate creation many mistakes. The warehouse would like to utilize computer systems for tracking and distributine supplies. Systems Analyst needs to deliver plan, analysis and basic design for implementation for desired tracking and distributing systern. Theme 6 The restaurant "Greek an I ncal" plans to expand and open 6 new restaurants. The nwner would like to rreatea systern where he could get into the emplayee payroll system from ary lacation and see who is currerily working and at the erid of the veek to see how much moriey he should pay to his ernployees. Also, he would like to hawe a tracking system to see how much supplies he necris to bey in order to pperate restaurant. He wants to see supplies inventory daily and be able to see contact information for the suppliers of the products which runs short. Systems Analyst needs to deliwer plan, analysis and basic design forimplementation for desired payroll and supply management system ASA COLLEGE ClS220 - Systems analysis and Design Instruactor: Maksim Klchan I he real estate office "Fortune Homes Real tastate" looking to build system to track its potential buyers leads and neods. Right now each real estate agent has a list of its scllers and their properties. When Buyers initially contact the office and asks about the properties they have for sale, office secretary start. calling to each agent and ask what properties they have for sale and all related information. It takes 34 days before Buyers hears back from the interested agent with properties to show, within 34 days of waiting "Fortune Homes Rcal Estate "can lose clicnts. It was determincd that Information Systems must. be created where agents can share information about their properties with other agents and office secretary. Whenever potential buyer contacts the office, office secretary can ask buyer forthe property specifications and based on that find an agent with the property that fits needs of a client. This information must be transmitted to the client as soon as possible. 5ystems Analyst needs to deliver plan, analysis and basic design for implementation for desired information marlagerrient systemi Theme 8 Construction Company "Russat Hazmat Inc" is a construction company which perform apartment renovations. "Russat Hazmat Inc" have ahout 150 employees who simultanenusly wark on different projects. At the end of each week Manager of the "Russat Harrnat Int." calling each corstruction team and asks therri for the status of the workand wheri they expect to corriplete the work. He riends this Canstructibn Comparly "Russat Haxmat Inc:" is a constructian cornparly which perform apartmerit ienovations. "Russal Hacmal. Inc" have about 150 ernployees who sirnul tanedusly work on dilferent projects. At the end of each week Manager of the "Russat Harnat Inc. N calling each construction team and asks them for the status of the work and when they expect to complete the work. He needs this inforroation to prepare proper bills for the clients and then he has to make sure that client receives and pays the bill. If client does not pey within 14 deys, he has to re-subrnit the bill. After 30 days of unpaid bill he can start collecting, interest on the bill amount. This is very time consuming, and manual process, which takes a lot of tirne and errars. Sometirnes tails are not sent on tirne which is delay payrnents. "Russat Hacrnat Inc:" warits to hire Systerns Aralyst to help thern built the sof tware which can do client and billing management in the most cfficicnt way. Systems Analyst needs to deliver plan, analysis and basic design forimplementation for desired client and billing management saftware