Reference no: EM132392858 , Length: word count:1200

Capstone Project Assignment -

Overview - The purpose of this capstone project is for students to assume a senior management approach and apply project management techniques to create an integrative information technology solution to address organizational issues in order to satisfy an executive team and venture capital group. Students will critically assess existing information systems infrastructures, emerging technologies, and how enabling technologies affect organizational strategy. Deliverables 1 through 6 focus on preparing students toward the final capstone project. Skills, experience, and knowledge gained through the completion of prerequisite courses will be used throughout each deliverable. The project contents to be addressed are as follows:

1. Project Deliverable 1: Project Plan Inception. In this deliverable, you will create a project introduction that includes background information of the company, the type of business that the company is involved in, and a description of the integrative information systems that the company should have to support the business. You will also be asked to create a project plan to record tasks, subtasks, and resources, and identify the schedule of the project. Additionally, the plan will outline the planning, analysis, design, and implementation phases of your project.

2. Project Deliverable 2: Business Requirements. In this deliverable, you will create an original business requirements document for the project plan using the template provided. You will be asked to describe the detailed project including the scope, possible risks, constraints, assumptions, integration with other systems and infrastructure, and relevant terms that will be used throughout the project. You will also need to update the project plan.

3. Project Deliverable 3: Database and Data Warehousing Design. In this deliverable, you will create a database schema that supports the company's business and processes, explain and support the database schema, create database tables, normalize the database tables, create an Entity-Relationship (E-R) Diagram, and create a Data Flow Diagram (DFD). You will also be asked to create sample queries that will support the organizational reporting needs, and screen layouts that illustrate the interface that organizational users will utilize. You will need to update the project plan.

4. Project Deliverable 4: Cloud Technology and Virtualization. In this deliverable, you will support the need for the use of cloud technology and virtualization within your company, speculate on expected cost savings in hardware infrastructure, speculate on the possible reductions of human capital that can be realized from implementing cloud and virtualization technologies, create a diagram to illustrate how cloud and virtualization technology could align with the company's business processes and assist with attainment of organizational goals, provide a compelling recommendation for solution providers and partners that could help your company secure a firm competitive advantage by using cloud and virtualization technologies, and update the project plan.

5. Project Deliverable 4: Network Infrastructure and Security. In this deliverable, you will design a logical and physical topographical layout of the network, illustrate the possible placement of servers, explain rationale for the logical and physical topographical layout of the planned network, create and describe the comprehensive security policy for the organization, and update the project plan.

6. Final Project: Final Project Plan. In the final project, you will provide a high-level technical overview of the project. This includes the five (5) previous deliverables with revisions surrounding instructor feedback. All documentation will be recorded on the business requirements document revised from an earlier submission in this course. Additionally, you will submit the final project plan and create a comprehensive PowerPoint presentation for the executive team and the venture capital group. The PowerPoint presentation, along with the executive summary, will convince the group that your solution is optimal.

Project Deliverable 2: Business Requirements

This assignment consists of two (2) sections: a business requirements document and a 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 it is written for. Additionally, you may create and / or assume all necessary assumptions needed for the completion of this assignment.

Documenting the existing IT network and system is an important first step, but you, the CIO, know that capturing the needed changes can be critical to your success as an executive. You know that procuring and documenting 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 as a part of the requirements gathering process, you are to assess the needs of the company as it prepares to become a multinational organization. You must consider current and future trends and requirements; however, assumptions should be realistic and carefully considered. The needs of the organization should be documented. Later deliverables will focus on specifics of all requirements.

Section 1: Business Requirements Document

Write a four to six (4-6) page original business requirements document for the project plan using the template provided here. Note: The template can also be found in the Student Center of the online course shell.

Describe the project needs, including the following:

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

2. Speculate and give justifications for how to control scope.

3. Identify possible risks, constraints, and assumptions.

4. Describe the needed integration with other systems and infrastructure. Note: Database and Data Warehousing, Cloud Technology and Virtualization, and Network Infrastructure and Security.

5. Assess the human capital that may be needed to complete the project, ensuring that necessary skill sets are identified.

6. Speculate on possible outsourcing or offshoring needs that may be required to accomplish project.

7. Define relevant terms that will be used throughout the project.

8. Include cost projections for staffing, infrastructure, and other resources.

9. Use at least two (2) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources.

Your assignment must follow these formatting requirements:

• Use the provided Business Requirements Document template as a guide for this assignment.
• Citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.

Section 2: Revised Project Plan

Use Microsoft Project to:

1. Update the project plan (summary and detail) template, from Project Deliverable 1: Project Plan Inception, with three to five (3-5) new project tasks, each consisting of five to ten (5-10) subtasks.

The specific course learning outcomes associated with this assignment are:

• Describe the integrative functions and activities within the information systems area, including the role of the CIO and technologies managed within the organization.
• Evaluate how information technology (IT) is aligned with the strategy of the organization, and how to make appropriate choices about architecture in relationship to overall organization goals.
• Use technology and information resources to research issues in information systems.
• Write clearly and concisely about leadership issues and strategic insight of the Information systems domain using proper writing mechanics and technical style conventions.

Attachment:- Capstone Project Assignment Files.rar