MASSACHUSETTS INSTITUTE OF TECHNOLOGY Sloan School of Management 15.565 – INTEGRATING INFORMATION SYSTEMS: TECHNOLOGY, STRATEGY, AND ORGANIZATIONAL FACTORS CP0 -- COMPUTER PROJECT INTRODUCTION Placement Assistance System (PAS)Operational Scenario and General Overview Functional Overview As an MIT student, it would be nice to have a Placement Assistant System (PAS) to help decide on potential companies and prepare for interviews. There are many distributed sources for vital information. e.g., open company positions, interview dates, Alumni working in the company, contact information for relevant alumni, company industry and location information, stock performance, and current news (see range of sources below). The student is limited by the distributed nature of this information. The goal of this project is to integrate several of these sources using a web browser front-end interface to make it easier for the student make better and more informed decisions. The PAS application is to be modular so it can be scaled according to individual needs and to make it easier to incorporate new information sources. Although we will define the basic functional overview and most of the project will be along the same lines, we would like you to come up with ideas on what information should be incorporated and other technologies that might further enhance such a project. Note 1: CP1 should be done individually. All other parts (CP2-CP7) should be done in groups of 2 or 3 students. Please turn in the list of names of the students in your group by Lecture #7. If you need help forming a group, contact your TA. Note 2: A simple demonstration version of such a PAS can be found at http://coin.mit.edu/15.565/demo/PAS.asp (… and shown on the following two pages). - 1 -Industry(selectTelecomm)Geography(select all)Select acompanyPlacement Assistant System (PAS) Demonstration – User Interfacehttp://coin.mit.edu/15.565/demo/PAS.asp• Select industries and geographic regions of interest• Select from identified target companiesPlacement Assistant System (PAS) Demonstration – User Interface http://coin.mit.edu/15.565/demo/PAS.asp • Select industries and geographic regions of interest • Select from identified target companies Geography (select all) Industry (select Telecomm) Select a compan y - 2 -Information Located, Extracted and Displayed• Company information• Recruiting dates and company contacts• Employees currently enrolled at Sloan asstudents• Employees and Chairman info from Web• Headline info extracted in real-time from WebInformation Located, Extracted and Displayed • Company information • Recruiting dates and company contacts • Employees currently enrolled at Sloan as students • Employees and Chairman info from Web • Headline info extracted in real-time from Web Operational scenario We will assume that MIT wants to design and deploy the Placement Assistant System (PAS) for Sloan students who are actively pursuing their job search. This will involve evaluating the networking infrastructure within these buildings and its connectivity to the Internet, integrating recruiting databases and alumni databases into a front end, and incorporating real time news and stocks quotes from web sites. The final interface is through a web browser. The overall proposed architecture is shown on the next page. - 3 -- 4 -Proposed architecture INTERNET CDO office recruiting informationCDO office recruiting information Financial informationFinancial information Web sourcesWeb sources Sloan s tud ents DBSloan students DB Access overview d atabaseAccess overview database (dat abase backed web site)(database backed web site) Web BrowserWeb Browser InterfaceInterface Detailed Compan y per formanceDetailed Company performance CandidateCandidate looking for a joblooking for a job This project consists of 7 steps (referred to as CP1 through CP7): CP1 - PAS Goals / Concept write up CP2 - Local Area Network (LAN) design and evaluation CP3 - Wide Area Network (WAN) design and evaluation CP4 - Database Design and Relational Connectivity (using ACCESS, EXCEL, and Web) CP5 - View Integration and Logical Connectivity design and simple ASP CP6 - Integrating using a database backed web site, more complex ASP CP7 - Final PAS application using ASP and Web Wrapper technology CP4 Access Excel Web CompanyDatabase Student Database Internet / WAN CP3 CP2 MIT t CP5 Over view Database Simple ASP Browser CP6 CP7 Other Databases Web Web Wrapper Technology Final PAS ASP More Complex ASP …. Sloan School CP1 LAN neCP1 - Goals / Conceptual Write up Your first step is to describe the features and functionality of an ideal Placement Assistant System you would like to use as an MIT student when you start your recruiting, and the reasons for your requirements. (As we will be following specific fixed guidelines in the most of the remaining parts, not all your ideas will be implemented in the project. Nonetheless, you will have chances for creativity towards the final steps of the project. ) CP2 - Local Area Network In this step, you analyze a portion of the MIT local area network (LAN) and determine how best to extend the network. The Network is qualitatively and quantitatively evaluated using the IEEE Model 1 and Model 2 guidelines for multi-segment networks. This exercise teaches how to evaluate networks when they are expanded based on the IEEE Model 2 configurations. CP3 - Wide Area Network In this part, you examine and understand the MIT-Sloan wide area network (WAN) via the Internet architecture in terms of network components, topology, IP addresses, and trace routes. Ping and tracert utilities will be used for this purpose. You will also assess some Internet sources in terms of connectivity and network speed issues from within the MIT campus network. The learning focus for this part of the exercise is: • Understand network architecture issues. i.e., distinctions, limitations, and types. • Evaluate a working model based on some attributes e.g., network viability, delay times. • Understand network topology diagrams. • Bandwidth requirements, transfer of data i. e. Protocol, Error Correction, etc. • Understand issues with connectivity with the Internet. CP4 - Database Design and Relational Connectivity (using Access, Excel, and Web) This part will involve using an existing database and creating a new database by linking data sources seamlessly across Access, Excel, and external web sources. The