CIS 498 Project

Project Deliverable 1 Template

Project Plan Inception

Project Background.  You have been made the Chief Information Officer and Chief Technology Officer (CIO / CTO) of an innovative e-Commerce start-up company that a venture capital group has funded. The CEO has given you sixty (60) days to deliver an information technology project plan in anticipation of the company locating to a new facility. Since this is a start-up company, there is currently no building or technology infrastructure to support the business. All information technology (hardware and software) must be implemented in either a hosted solution, on-site solution or a hybrid model. The CEO is expecting you to integrate different technologies from different partners and incorporate industry best practices in connection with the development of technological systems. The new facility is a two-story stand-alone building. The company currently consists of ten (10) employees with revenues of $5 million but is expected to grow to thirty (30) employees with revenue of $30 million over the next two (2) years.

This assignment consists of two (2) sections: a project introduction and a Gantt chart or project plan. You must submit both sections as separate files for the completion of this assignment. Label each file name according to the section of the assignment for which it is written. Additionally, you may create and / or assume all necessary assumptions needed for the completion of this assignment.

Section 1.  Write a two to four (2-4) page original business requirements document for the project plan using the template provided.

Your assignment must follow these formatting requirements:

• Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format.
• Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.
• Label each section of your paper according to the template below:

1.      Cover/Title Page

2.      Background information of the company. 

3.      The type of business in which the company is involved.

4.      A description of the information systems that the company should have to support the business. 

A.    Databases

      B.  System Analysis

      C.  Security

            D.  Networking

            E.  Computer Infrastructure

            F.  Human Computer Interactions

            G.  Web design

5.      Work Cited:  At least two (2) quality resources in this assignment.

Section 2.

Use Microsoft Project or an open source alternative, such as Open Project, to:

1. Create a detailed Gantt chart or project plan (summary and detailed) template. The Gantt chart or project plan should:

1. 1. Record all tasks, subtasks, resources, and time related to the project.

1. 1. Outline the planning, analysis, design, and implementation phases.

1. 1. Develop in accordance with the systems development life cycle (SDLC).

Project Deliverable 2 Template

Business Requirements Document

Project Background.  Procuring quality business requirements is an important step toward the design of quality information systems. Completion of a quality requirements document allows user needs and expectations to be captured so that infrastructure and information systems can be designed properly. Using the requirements document provided in the course shell, you are to speculate on the needs of the company. You must consider current and future requirements; however, assumptions should be realistic and carefully considered.

This assignment consists of two (2) sections: a business requirements document and a Gantt chart or project plan. You must submit both sections as separate files for the completion of this assignment. Label each file name according to the section of the assignment for which it is written. Additionally, you may create and / or assume all necessary assumptions needed for the completion of this assignment.

Section 1.  Write an eight to ten (8-10) page original business requirements document for the project plan using the template provided.

Your assignment must follow these formatting requirements:

• Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format.
• Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.
• Label each section of your paper according to the template below:

6.      Cover/Title Page

7.      Describe the scope and analyze how to control the scope. 

8.      Identify possible risks, constraints, and assumptions.

9.      Describe the integration with other systems and infrastructure.  NOTE:  Database and interface design, security, and networking should be considered.

10.  Define relevant terms that will be used throughout project.

11.   Work Cited:  At least two (2) quality resources in this assignment.

Section 2.

Use Microsoft Project or an open source alternative, such as Open Project, to:

D.      Update the Gantt chart or project plan (summary and detail) template, from Project Deliverable 1:  Project Plan Inception, with all the project tasks. 

Project Deliverable 3 Template

Database and Programming Design

Project Background.  One (1) of the main functions of any business is to transform data into information. The use of relational databases has gained recognition as a standard for organizations and business transactions. A quality database design makes the flow of data seamless. The database schema is the foundation of the relational database. The schema defines the tables, fields, relationships, views, indexes, and other elements. The schema should be created by envisioning the business, processes, and workflow of the company.

This assignment consists of two (2) sections: a design document and a revised Gantt chart or project plan. You must submit both sections as separate files for the completion of this assignment. Label each file name according to the section of the assignment for which it is written.  Additionally, you may create and / or assume all necessary assumptions needed for the completion of this assignment.

Section 1.  Write a five to ten (5-10) page design document using the template provided in which you.

Your assignment must follow these formatting requirements:

• Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format.
• Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.
• Include charts or diagrams created in MS Visio or Dia as an appendix of the design document. All references to these diagrams must be included in the body of the design document.
• Label each section of your paper according to the template below:

1. Cover/Title Page
2. Create a database schema that supports the company’s business and processes.
3. Explain and support the database schema with relevant arguments that support the rationale for the structure. Note: The minimum requirement for the schema should entail the tables, fields, relationships, views, andindexes.
4. Create database tables with appropriate field-naming conventions. Then, identify primary keys and foreign keys, and explain how referential integrity will be achieved.
5. Normalize the database tables to third normal form (3NF).
6. Create an Entity-Relationship (E-R) Diagram through the use of graphical tools in Microsoft Visio or an open source alternative such as Dia. Note: The graphically depicted solution is not included in the required page length but must be included in the design document appendix.
7. Explain your rationale behind the design of your E-R Diagram.
8. Create a Data Flow Diagram (DFD) through the use of graphical tools in Microsoft Visio or an open source alternative such as Dia. Note: The graphically depicted solution is not included in the required page length but must be included in the design document appendix.
9. Explain your rationale behind the design of your DFD.
10. Create at least two (2) sample queries that will support the organizational reporting needs.
11. Create at least two (2) screen layouts that illustrate the interface that organizational users will utilize.
12. Work Cited:  At least two (2) quality resources in this assignment.

Section 2.

Use Microsoft Project or an open source alternative, such as Open Project, to:

1. Update the Gantt chart or project plan (summary and detail) template, from Project Deliverable 2: Business Requirements, with all the project tasks.

Project Deliverable 4 Template

Infrastructure and Security

Project Background.  The last section of the project plan will present the infrastructure in accordance with the parameters set forth at the outset of the project. The network solution that is chosen should support the conceived information system and allow for scalability. The network infrastructure will support organizational operations; therefore, a pictorial view of workstations, servers, routers, bridges, gateways, and access points should be used. In addition, access paths for Internet access should be depicted. A narrative should be included to explain all the nodes of the network and the rationale for the design. Lastly, using the Confidentiality, Integrity and Availability (CIA) Triangle, define the organizational security policy. CIA is a widely used benchmark for evaluation of information systems security.

This assignment consists of two (2) sections: an infrastructure document and a revised Gantt chart or project plan. You must submit both sections as separate files for the completion of this assignment. Label each file name according to the section of the assignment for which it is written. Additionally, you may create and / or assume all necessary assumptions needed for the completion of this assignment.

Section 1.  Write a five to ten (5-10) page infrastructure document using the template provided in which you:

Your assignment must follow these formatting requirements:

• Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
• Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.
• Include charts or diagrams created in MS Visio or Dia as an appendix of the infrastructure document. All references to these diagrams must be included in the body of the infrastructure document.
• Label each section of your paper according to the template below:

1. 1. Cover/Title Page
   2. Design a logical and physical topographical layout of the planned network through the use of graphical tools in Microsoft Word or Visio, or an open source alternative such as Dia. Note: The graphically depicted solution is not included in the required page length.
   3. Illustrate the possible placement of servers including access paths to the Internet and firewalls. Note: Facility limitations, workstations, printers, routers, switches, bridges and access points should be considered in the illustration.
   4. Explain the rationale for the logical and physical topographical layout of the planned network.
   5. Create a comprehensive security policy for the company that will:

                                                              i.      Protect the company infrastructure and assets by applying the principals of CIA. Note: CIA is a widely used benchmark for evaluation of information systems security, focusing on the three core goals of confidentiality, integrity and availability of information. 

                                                            ii.      Address ethical aspects related to employee behavior, contractors, password usage, and access to networked resources and information.

1. 1. Work Cited:  At least two (2) quality resources in this assignment.

Section 2.

Use Microsoft Project or an open source alternative, such as Open Project, to:

1. Update the Gantt chart or project plan (summary and detail) template, from Project Deliverable 3: Database and Programming Design, with all the project tasks.

Final Project Deliverable Template

Project Plan

Project Background.  You are now in the final stage of the project plan development. All previous documentation will be combined into one (1) document that will serve as the statement of work for the project. Your goal is to have the project approved by the executive team and the venture capital group. The project plan is very detailed which is appropriate to accomplish the monumental task of implementation. However, the executive team is only interested in a ten (10) minute summation. Therefore, you also must create a compelling executive summary that is supported by your detail that convinces the executive group that your solution is optimal.

This assignment consists of three (3) sections: a written project plan, a revised Gantt chart or project plan, and a project plan PowerPoint presentation. You must submit the three (3) sections as separate files for the completion of this assignment. Label each file name according to the section of the assignment for which it is written. Additionally, you may create and / or assume all necessary assumptions needed for the completion of this assignment.

While taking all business and project parameters into consideration, make quality assumptions to support the following requirements.

Section 1.  Write an eight to ten (8-10) page executive summary in which you provide a high-level technical overview of your project where you address the following:

Your assignment must follow these formatting requirements:

• Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
• Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.
• Include charts or diagrams created in MS Visio and MS Project as appendix of the Word document. Make reference of these files in the body of the Word document.
• Label each section of your paper according to the template below:

1. 1. Cover/Title Page
   2. Describe the scope of the project and control measures.
   3. Describe the goals and objectives of the project.
   4. Give a detailed, realistically estimated cost analysis of the entire project.
   5. Relate the value of the project plan solution to the competitive advantage that information technology will afford your organization.
   6. Provide all aspects of the information technology implementation into the project plan.
   7. Work Cited:  Use at least five (5) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources.

Section 2.

Use Microsoft Project or an open source alternative, such as Open Project, to:

1. Update the Gantt chart or project plan (summary and detail) template, from Project Deliverable 4: Infrastructure and Security, with all the project tasks.

Section 3.

Additional to your detailed executive summary you must present your findings to the executive team and the venture capital group that, along with the executive summary, will convince the group that your solution is optimal.

1. Create a ten to fifteen (10-15) slide PowerPoint presentation in which you:
   1. Illustrate the concepts from your written report in Section 1 of this assignment.
   2. Create bulleted speaking notes for your presentation to the executive board in the Notes section of the PowerPoint. Note: You may create or assume any fictitious names, data, or scenarios that have not been established in this assignment for a realistic flow of communication.
   3. Use a professional technically written style to graphically convey the information.