In an uber globalized market of today, companies are faced with challenges in each and every step of their business. Our analytics and research services are geared towards giving those companies that extra edge over

cis499_student_guide_1128.pdf

Home >Computer Science homework help >In an uber globalized market of today, companies are faced with challenges in each and every step of their business. Our analytics and research services are geared towards giving those companies that extra edge over

CIS 499 – Information Systems Capstone

© 2012 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written permission of Strayer University.

CIS 499 Student Version 1128 (1159 8-30-2012) Final Draft Page 1 of 32

(Prerequisite: To be taken last or next to last)

COURSE DESCRIPTION

This course is the capstone course for the Bachelor of Information Systems program. The course takes a senior management approach to examine issues in managing the information systems function in organizations and how information systems integrate, support, and enable various types of organizational capabilities. Topics include developing an intellectual framework to critically assess existing information systems infrastructures, emerging technologies, and how enabling technologies affect organizational strategy.

INSTRUCTIONAL MATERIALS

Required Resources

Cortada, J. (2009). How societies embrace Information Technology. Hoboken, NJ: John Wiley & Sons, Inc.

Lane, D. (2011). The Chief Information Officer's Body of Knowledge. Hoboken, NJ: John Wiley & Sons, Inc. Microsoft Office, Microsoft Visio, and Microsoft Project or their equivalents such as OpenOffice, Dia, and Open Project are required. Tutorials for Microsoft Office 2010 can be found on Microsoft’s support site, located at http://office.microsoft.com/en-us/support/training-FX101782702.aspx.

Supplemental Resources

Association for Computing Machinery Website. (2012). General format. Retrieved from http://www.acm.org/

National Security Agency – Central Security Service Website. (2009). General format. Retrieved from

http://www.nsa.gov/

The Committee on National Security Systems Website. General format. Retrieved from http://www.cnss.gov/

COURSE LEARNING OUTCOMES

1. Describe the various functions and activities within the information systems area, including the role of IT management and the CIO, structuring of IS management within an organization, and managing IS professionals within the firm.

2. Evaluate an organization through the lens of non-IT senior management in deciding how information systems enable core and supportive business processes as well as those that interface with suppliers and customers.

3. Describe the economic factors of information systems at the enterprise level.

4. Summarize how information systems represent a key source of competitive advantage for organizations.

5. Develop information systems-related activities to maximize the business value within and outside the organization.

6. Demonstrate an understanding of existing and emerging information technologies, the functions of IS, and its impact on the organizational operations.

7. Evaluate the issues and challenges associated with information systems integration.

http://office.microsoft.com/en-us/support/training-FX101782702.aspx

http://www.acm.org/

http://www.nsa.gov/

http://www.cnss.gov/

CIS 499 – Information Systems Capstone

CIS 499 Student Version 1128 (1159 8-30-2012) Final Draft Page 2 of 32

8. Describe how strategic decisions are made concerning acquiring IS resources and capabilities including the ability to evaluate the different sourcing options.

9. Evaluate the ethical concerns that information systems raise in a global context.

10. Use technology and information resources to research issues in information systems.

11. Write clearly and concisely about strategic issues and practices in the information systems domain using proper writing mechanics and technical style conventions.

WEEKLY COURSE SCHEDULE

The standard requirement for a 4.5 credit hour course is for students to spend 13.5 hours in weekly work. This includes preparation, activities, and evaluation regardless of delivery mode.

Week Preparation, Activities, and Evaluation Points

1 Preparation

 Reading(s), from Cortada

o Chapter 1: Introducing the Big Picture

 Reading(s), from Lane

o Chapter 1: Collaboration and Teamwork

Activities

 Discussions

Evaluation

 None

2 Preparation

 Reading(s), from Cortada

o Chapter 2: How Computers Spread Around the World So Fast

 Reading(s), from Lane

o Chapter 8: Strategic Alignment

Activities

 Discussions

Evaluation

 Project Deliverable 1: Project Plan Inception

110

3 Preparation

 Reading(s), from Cortada

o Chapter 3: How Governments Leverage Information Technologies to Improve Their National Economies

 Reading(s), from Lane

o Chapter 9: Developing an IT Strategy

Activities

 Discussions

Evaluation

 None

4 Preparation

CIS 499 – Information Systems Capstone

CIS 499 Student Version 1128 (1159 8-30-2012) Final Draft Page 3 of 32

 Reading(s), from Cortada

o Chapter 4: How Managers and Officials Decide What Technology to Use

 Reading(s), from Lane

o Chapter 10: Competitive Applications of Technology

Activities

 Discussions

Evaluation

 Project Deliverable 2: Business Requirements

110

5 Preparation

 Reading(s), from Lane

o Chapter 12: Information Technology Portfolio Management

o Chapter 13: A Beginner’s Guide to the Software Development Life Cycle

o Chapter 14: Office of the CIO

o Chapter 21: Service Management

Activities

 Discussions

Evaluation

 Project Deliverable 3: Database and Data Warehousing Design

110

6 Preparation

 Reading(s), from Cortada

o Chapter 5: Adding Up the Results So Far: Do We Now Live in the Information Age?

 Reading(s), from Lane

o Chapter 15: Requirements

o Chapter 16: Project Risk Management

o Chapter 17: Project Cost Estimation

Activities

 Discussions

Evaluation

 None

7 Preparation

 Reading(s), from Cortada

o Chapter 6: An Expanding Role for Scientists and Engineers

o Chapter 7: Looking Down the Road into the Twenty-First Century

 Reading(s), from Lane

o Chapter 18: Managing Project Quality

o Chapter 20: Compliance

o Chapter 22: Balancing IT’s Workload

Activities

 Discussions

CIS 499 – Information Systems Capstone

CIS 499 Student Version 1128 (1159 8-30-2012) Final Draft Page 4 of 32

Evaluation

 Project Deliverable 4: Analytics, Interfaces, and Cloud Technology

110

8 Preparation

 Reading(s), from Lane

o Chapter 23: Outsourcing and Offshoring

o Chapter 24: Information Technology Portfolio Management

o Chapter 25: Strategic Information Security Management

 e-Activity

o Use the Internet to research onshoring and insourcing. Take note of the advantages to both. Be prepared to discuss.

Activities

 Discussions

Evaluation

 Project Deliverable 5: Infrastructure and Security

110

9 Preparation

 Reading(s), from Lane

o Chapter 26: From Vision to Reality: Implementing Information Security

Activities

 Discussions

Evaluation

 None

10 Preparation

 Reading(s), from Cortada

o Chapter 27: Business Continuity Planning

Activities

 Discussions

Evaluation

 Project Deliverable 6: Project Plan

250

11 Preparation

 Reading(s): None

Activities

 Discussions

Evaluation

 None

CIS 499 – Information Systems Capstone

CIS 499 Student Version 1128 (1159 8-30-2012) Final Draft Page 5 of 32

GRADING SCALE – UNDERGRADUATE

Assignment Total Points % of

Grade

Project Deliverable 1: Project Plan Inception 110 11%

Project Deliverable 2: Business Requirements 110 11%

Project Deliverable 3: Database and Data Warehousing Design 110 11%

Project Deliverable 4: Analytics, Interfaces, and Cloud Technology 110 11%

Project Deliverable 5: Infrastructure and Security 110 11%

Project Deliverable 6: Project Plan

Faculty Note: This deliverable is comprehensive in nature requiring revisions to all previous deliverables. The completed project will be due in Week 10.

250 25%

Participation (20 discussions worth 10 points apiece)

Note: Week 11 discussions are not graded.

200 20%

Totals 1,000 100%

Points Percentage Grade

900 – 1,000 90% – 100% A

800 – 899 80% – 89% B

700 – 799 70% – 79% C

600 – 699 60% – 69% D

Below 600 Below 60% F

Writing Assignments

The objective of the School of Information Systems’ writing assignments is to promote attitudes and skills that will improve a student’s ability to communicate in writing, develop research skills and documentation techniques, and encourage critical analysis of data and conclusions specific to the course learning outcomes in the information systems and technology domain.

CIS 499 – Assignments and Rubrics

CIS 499 Student Version 1128 (1159 8-30-2012) Final Draft Page 6 of 32

Capstone Project 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, speculation upon outsourcing and offshoring opportunities, identification of skilled information systems personnel need for project, specific types of data that the company collects, and a description of the integrative information systems that the company should have to support the business. You will also 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.

Submission Requirements

o Project Introduction (MS Word)

o Project Plan (MS 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 in the student resource section of the online course shell. You will be asked to describe the detailed project including the scope, possible risks, constraints, and assumptions, integration with other systems and infrastructure, and relevant terms that will be used throughout project. You will also need to update the project plan.

Submission Requirements

o Business Requirements Document (MS Word)

o Revised Project Plan (MS Project)

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.

Submission Requirements

o Design Document (MS Word)

o Revised Project Plan (MS Project)

4. Project Deliverable 4: Analytics, Interfaces, and Cloud Technology. In this deliverable, you will support the need for the use of analytics and cloud technology within your company, create a workflow diagram to illustrate how analytics and cloud technology could align with the company’s business processes, create screen layouts that illustrate the interface that organizational users will utilize, and give a recommendation for partners that could help your company secure a firm advantage by using analytics and cloud technology. You will need to update the project plan.

CIS 499 – Assignments and Rubrics

CIS 499 Student Version 1128 (1159 8-30-2012) Final Draft Page 7 of 32

Submission Requirements

o Design Document (MS Word)

o Revised Project Plan (MS Project)

5. Project Deliverable 5: Infrastructure and Security. In this deliverable, you will design a logical and physical topographical layout of the computing network, illustrate the possible placement of infrastructure components such as 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.

Submission Requirements

o Infrastructure Document (MS Word)

o Revised Project Plan (MS Project)

6. Project Deliverable 6: 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.

Submission Requirements

o Written Project Plan (MS Word)

o Revised Business Requirements Document (MS Word)

o Project Plan PowerPoint Presentation (MS PowerPoint)

o Finalized Project Plan (MS Project)

CIS 499 – Assignments and Rubrics

CIS 499 Student Version 1128 (1159 8-30-2012) Final Draft Page 8 of 32

Project Deliverable 1: Project Plan Inception

Due Week 2 and worth 110 points

This assignment consists of two (2) sections: a project introduction 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.

You are a newly appointed Chief Information Officer (CIO) of a $25 million dollar data collection and analysis company that has been operating less than two (2) years. It is expected to grow by 60% over the next eighteen (18) months. Your company currently collects data using Web analytics and combines it with operational systems data. Web analytics is an increasingly important part of most business marketing plans. Your company is looking for ways to leverage the collected data but wants to ensure that the information technology infrastructure will support the expected growth that the company is anticipating. The Chief Executive Officer (CEO) has given you sixty (60) days to deliver a comprehensive information systems project plan to address the organizational growth that the company is experiencing. The company will be expanding from one (1) floor to three (3) floors within six (6) months. Since this is a relatively new company, there is currently limited technology infrastructure to support the business. All information technology (hardware and software) must be redesigned to meet organizational needs. The solution should 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 and cost-effective solutions in connection with the development of technological systems. In addition, the CEO is extremely interested in cloud computing technologies and Software-as-a-Service (SaaS) but is leery of security issues that may be associated. However, he is sure that you will implement proper security protocols. The company currently consists of twenty (20) employees of which four (4), including yourself, are dedicated to the IT organization.

Section 1: Project Introduction

1. Write a four to six (4-6) page project introduction that documents the current state of the organization, expands upon the information given above, and includes the following:

a. Background information of the company.

b. Details regarding the type of business that the company is engaged in.

c. A description of current outsourcing and offshoring activities.

d. Identification of current skilled information systems personnel in position and responsibilities.

e. The specific types of data that the company collects.

f. A description of the information systems that the company currently has to support the business. The description at a minimum should include the following:

i. Operational Systems and Databases

ii. Analytics and Interfaces

iii. Infrastructure and Security

g. The use of 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:

 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.

CIS 499 – Assignments and Rubrics

CIS 499 Student Version 1128 (1159 8-30-2012) Final Draft Page 9 of 32

 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.

Section 2: Project Plan

Use Microsoft Project to:

2. Create a project plan (summary and detailed) using Microsoft Office Project. The project plan should:

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

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

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

The specific course learning outcomes associated with this assignment are:

 Describe the various functions and activities within the information systems area, including the role of IT management and the CIO, structuring of IS management within an organization, and managing IS professionals within the firm.

 Use technology and information resources to research issues in information systems.

 Write clearly and concisely about strategic issues and practices in the information systems domain using proper writing mechanics and technical style conventions.

Grading for this assignment will be based on answer quality, logic / organization of the paper, and language and writing skills, using the following rubric.

Points: 110 Project Deliverable 1: Project Plan Inception

Criteria

Unacceptable

Below 60% F

Meets

Minimum

Expectations

60-69% D

Fair

70-79% C

Proficient

80-89% B

Exemplary

90-100% A

Section 1: Project Introduction

1a. Include background information of the company.

Weight: 10%

Did not submit or incompletely included background information of the company.

Insufficiently included background information of the company.

Partially included background information of the company.

Satisfactorily included background information of the company.

Thoroughly included background information of the company.

1b. Include details regarding the type of business that the company is engaged in.

Weight: 10%

Did not submit or incompletely included details regarding the type of business that the company is engaged in.

Insufficiently included details regarding the type of business that the company is engaged in.

Partially included details regarding the type of business that the company is engaged in.

Satisfactorily included details regarding the type of business that the company is engaged in.

Thoroughly included details regarding the type of business that the company is engaged in.

1c. Include a description of current outsourcing and offshoring activities. Weight: 5%

Did not submit or incompletely included a description of current outsourcing and offshoring

Insufficiently included a description of current outsourcing and offshoring activities.

Partially included a description of current outsourcing and offshoring activities.

Satisfactorily included a description of current outsourcing and offshoring activities.

Thoroughly included a description of current outsourcing and offshoring activities.

CIS 499 – Assignments and Rubrics

CIS 499 Student Version 1128 (1159 8-30-2012) Final Draft Page 10 of 32

activities.

1d. Include identification of current skilled information systems personnel in position and responsibilities.

Weight: 5%

Did not submit or incompletely included identification of current skilled information systems personnel in position and responsibilities.

Insufficiently included identification of current skilled information systems personnel in position and responsibilities.

Partially included identification of current skilled information systems personnel in position and responsibilities.

Satisfactorily included identification of current skilled information systems personnel in position and responsibilities.

Thoroughly included identification of current skilled information systems personnel in position and responsibilities.

1e. Include the specific types of data that the company collects.

Weight: 5%

Did not submit or incompletely included the specific types of data that the company collects.

Insufficiently included the specific types of data that the company collects.

Partially included the specific types of data that the company collects.

Satisfactorily included the specific types of data that the company collects.

Thoroughly included the specific types of data that the company collects.

1fi. Include a description of the information systems that the company currently has to support the business, including operational systems and databases.

Weight: 10%

Did not submit or incompletely included a description of the information systems that the company currently has to support the business, including operational systems and databases.

Insufficiently included a description of the information systems that the company currently has to support the business, including operational systems and databases.

Partially included a description of the information systems that the company currently has to support the business, including operational systems and databases.

Satisfactorily included a description of the information systems that the company currently has to support the business, including operational systems and databases.

Thoroughly included a description of the information systems that the company currently has to support the business, including operational systems and databases.

1fii. Include a description of the information systems that the company currently has to support the business, including analytics and interfaces. Weight: 5%

Did not submit or incompletely included a description of the information systems that the company currently has to support the business, including analytics and interfaces.

Insufficiently included a description of the information systems that the company currently has to support the business, including analytics and interfaces.

Partially included a description of the information systems that the company currently has to support the business, including analytics and interfaces.

Satisfactorily included a description of the information systems that the company currently has to support the business, including analytics and interfaces.

Thoroughly included a description of the information systems that the company currently has to support the business, including analytics and interfaces.

1fiii. Include a description of the information systems that the company currently has to support the business, including infrastructure and security.

Weight: 5%

Did not submit or incompletely included a description of the information systems that the company currently has to support the business, including infrastructure and security.

Insufficiently included a description of the information systems that the company currently has to support the business, including infrastructure and security.

Partially included a description of the information systems that the company currently has to support the business, including infrastructure and security.

Satisfactorily included a description of the information systems that the company currently has to support the business, including infrastructure and security.

Thoroughly included a description of the information systems that the company currently has to support the business, including infrastructure and security.

CIS 499 – Assignments and Rubrics

CIS 499 Student Version 1128 (1159 8-30-2012) Final Draft Page 11 of 32

1g. 2 references

Weight: 5%

No references provided

Does not meet the required number of references; all references poor quality choices.

Does not meet the required number of references; some references poor quality choices.

Meets number of required references; all references high quality choices.

Exceeds number of required references; all references high quality choices.

Section 2: Project Plan

2a. Create a project plan (summary and detailed) using Microsoft Office Project, recording all tasks, subtasks, resources, and time related to the project.

Weight: 10%

Did not submit or incompletely created a project plan (summary and detailed) using Microsoft Office Project, recording all tasks, subtasks, resources, and time related to the project.

Insufficiently created a project plan (summary and detailed) using Microsoft Office Project, recording all tasks, subtasks, resources, and time related to the project.

Partially created a project plan (summary and detailed) using Microsoft Office Project, recording all tasks, subtasks, resources, and time related to the project.

Satisfactorily created a project plan (summary and detailed) using Microsoft Office Project, recording all tasks, subtasks, resources, and time related to the project.

Thoroughly created a project plan (summary and detailed) using Microsoft Office Project, recording all tasks, subtasks, resources, and time related to the project.

2b. Create a project plan (summary and detailed) using Microsoft Office Project, outlining the planning, analysis, design, and implementation phases. Weight: 10%

Did not submit or incompletely created a project plan (summary and detailed) using Microsoft Office Project, outlining the planning, analysis, design, and implementation phases.

Insufficiently created a project plan (summary and detailed) using Microsoft Office Project, outlining the planning, analysis, design, and implementation phases.

Partially created a project plan (summary and detailed) using Microsoft Office Project, outlining the planning, analysis, design, and implementation phases.

Satisfactorily created a project plan (summary and detailed) using Microsoft Office Project, outlining the planning, analysis, design, and implementation phases.

Thoroughly created a project plan (summary and detailed) using Microsoft Office Project, outlining the planning, analysis, design, and implementation phases.

2c. Create a project plan (summary and detailed) using Microsoft Office Project developed in accordance with the systems development life cycle (SDLC).

Weight: 10%

Did not submit or incompletely created a project plan (summary and detailed) using Microsoft Office Project developed in accordance with the systems development life cycle (SDLC).

Insufficiently created a project plan (summary and detailed) using Microsoft Office Project developed in accordance with the systems development life cycle (SDLC).

Partially created a project plan (summary and detailed) using Microsoft Office Project developed in accordance with the systems development life cycle (SDLC).

Satisfactorily created a project plan (summary and detailed) using Microsoft Office Project developed in accordance with the systems development life cycle (SDLC).

Thoroughly created a project plan (summary and detailed) using Microsoft Office Project developed in accordance with the systems development life cycle (SDLC).

3. Clarity, writing mechanics, and formatting requirements

Weight: 10%

More than 8 errors present

7-8 errors present

5-6 errors present

3-4 errors present

0-2 errors present

CIS 499 – Assignments and Rubrics

CIS 499 Student Version 1128 (1159 8-30-2012) Final Draft Page 12 of 32

Project Deliverable 2: Business Requirements

Due Week 4 and worth 110 points

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.

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. Your company, which is a data-collection and analysis company that has been operating less than two (2) years, is seeking to create a repository for collected data beyond standard relational databases. Your ten (10) terabyte data warehouse is expected to grow by 20% each year. You are mindful of data warehousing best practices which will aid you immensely in your requirements gathering effort. 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.

Section 1: Business Requirements Document

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

a. Describe the project including the following:

i. Describe and define the scope of the project.

ii. Speculate as to how to control the scope.

iii. Identify possible risks, constraints, and assumptions.

iv. Describe the relationship and integration between systems and infrastructure. Note: Database and Data Warehousing, Analytics, Interfaces and Cloud Technology, and Infrastructure and Security should be considered.

v. Speculate upon potential outsourcing or offshoring needs.

vi. Identify and justify the necessary resources including staffing that are necessary.

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

b. 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:

Section 2: Revised Project Plan

Use Microsoft Project to:

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

CIS 499 – Assignments and Rubrics

CIS 499 Student Version 1128 (1159 8-30-2012) Final Draft Page 13 of 32

The specific course learning outcomes associated with this assignment are:

 Evaluate an organization through the lens of non-IT senior management in deciding how information systems enable core and supportive business processes as well as those that interface with suppliers and customers.

 Use technology and information resources to research issues in information systems.

 Write clearly and concisely about strategic issues and practices in the information systems domain using proper writing mechanics and technical style conventions.

Grading for this assignment will be based on answer quality, logic / organization of the paper, and language and writing skills, using the following rubric.

Points: 110 Project Deliverable 2: Business Requirements

Criteria

Unacceptable

Below 60% F

Meets

Minimum

Expectations

60-69% D

Fair

70-79% C

Proficient

80-89% B

Exemplary

90-100% A

Section 1: Business Requirements Document

1ai. Describe and define the scope of the project.

Weight: 10%

Did not submit or incompletely described and defined the scope of the project.

Insufficiently described and defined the scope of the project.

Partially described and defined the scope of the project.

Satisfactorily described and defined the scope of the project.

Thoroughly described and defined the scope of the project.

1aii. Speculate as to how to control the scope.

Weight: 15%

Did not submit or incompletely speculated as to how to control the scope.

Insufficiently speculated as to how to control the scope.

Partially speculated as to how to control the scope.

Satisfactorily speculated as to how to control the scope.

Thoroughly speculated as to how to control the scope.

1aiii. Identify possible risks, constraints, and assumptions. Weight: 10%

Did not submit or incompletely identified possible risks, constraints, and assumptions.

Insufficiently identified possible risks, constraints, and assumptions.

Partially identified possible risks, constraints, and assumptions.

Satisfactorily identified possible risks, constraints, and assumptions.

Thoroughly identified possible risks, constraints, and assumptions.

1aiv. Describe the relationship and integration between systems and infrastructure.

Weight: 10%

Did not submit or incompletely described the relationship and integration between systems and infrastructure.

Insufficiently described the relationship and integration between systems and infrastructure.

Partially described the relationship and integration between systems and infrastructure.

Satisfactorily described the relationship and integration between systems and infrastructure.

Thoroughly described the relationship and integration between systems and infrastructure.

1av. Speculate upon potential outsourcing or offshoring needs.

Weight: 15%

Did not submit or incompletely speculated upon potential outsourcing or offshoring needs.

Insufficiently speculated upon potential outsourcing or offshoring needs.

Partially speculated upon potential outsourcing or offshoring needs.

Satisfactorily speculated upon potential outsourcing or offshoring needs.

Thoroughly speculated upon potential outsourcing or offshoring needs.

CIS 499 – Assignments and Rubrics

CIS 499 Student Version 1128 (1159 8-30-2012) Final Draft Page 14 of 32

1avi. Identify and justify the necessary resources including staffing that are necessary.

Weight: 10%

Did not submit or incompletely identified and justified the necessary resources including staffing that are necessary.

Insufficiently identified and justified the necessary resources including staffing that are necessary.

Partially identified and justified the necessary resources including staffing that are necessary.

Satisfactorily identified and justified the necessary resources including staffing that are necessary.

Thoroughly identified and justified the necessary resources including staffing that are necessary.

1avii. Define relevant terms that will be used throughout project. Weight: 10%

Did not submit or incompletely defined relevant terms that will be used throughout project.

Insufficiently defined relevant terms that will be used throughout project.

Partially defined relevant terms that will be used throughout project.

Satisfactorily defined relevant terms that will be used throughout project.

Thoroughly defined relevant terms that will be used throughout project.

1b. 2 references

Weight: 5%

No references provided

Does not meet the required number of references; all references poor quality choices.

Does not meet the required number of references; some references poor quality choices.

Meets number of required references; all references high quality choices.

Exceeds number of required references; all references high quality choices.

Section 2: Revised Project Plan

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

Weight: 5%

Did not submit or incompletely updated the project plan from Project Deliverable 1: Project Plan Inception, with three to five (3-5) new project tasks each consisting of five to ten (5- 10) sub-tasks.

Insufficiently updated the project plan from Project Deliverable 1: Project Plan Inception, with three to five (3- 5) new project tasks each consisting of five to ten (5- 10) sub-tasks.

Partially updated the project plan from Project

Deliverable 1: Project Plan Inception, with three to five (3- 5) new project tasks each consisting of five to ten (5- 10) sub-tasks.

Satisfactorily updated the project plan from Project

Deliverable 1: Project Plan Inception, with three to five (3- 5) new project tasks each consisting of five to ten (5- 10) sub-tasks.

Thoroughly updated the project plan from Project

Deliverable 1: Project Plan Inception, with three to five (3- 5) new project tasks each consisting of five to ten (5- 10) sub-tasks.

3. Clarity, writing mechanics, and formatting requirements

Weight: 10%

More than 8 errors present

7-8 errors present

5-6 errors present

3-4 errors present

0-2 errors present

CIS 499 – Assignments and Rubrics

CIS 499 Student Version 1128 (1159 8-30-2012) Final Draft Page 15 of 32

Project Deliverable 3: Database and Data Warehousing Design

Due Week 5 and worth 110 points

This assignment consists of two (2) sections: a design document and a revised 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.

One of the main functions of any business is to be able to use data to leverage a strategic competitive advantage. This feat hinges upon a company’s ability to transform data into quality information. The use of relational databases is a necessity for contemporary organizations; however, data warehousing has become a strategic priority due to the enormous amounts of data that must be analyzed along with the varying sources from which data comes. Since you are now the CIO of a data-collection company which gathers data by using Web analytics and operational systems, you must design a solution overview that incorporates data warehousing. The executive team needs to be clear about what data warehousing can provide the company.

Section 1: Design Document

1. Write a four to six (4-6) page design document in which you:

a. Support the need for data warehousing within your company and elaborate on the best practices that the company will adhere to.

b. Create a schema that supports the company’s business and processes. 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, and indexes.

c. Create an Entity-Relationship (E-R) Diagram relating the tables of your database schema 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. Explain your rationale behind the design of your E-R Diagram.

d. Create a Data Flow Diagram (DFD) relating the tables of your database schema 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.

e. Illustrate the flow of data including both inputs and outputs for the use of a data warehouse. The diagram must map data between source systems, data warehouses and specified data marts. The diagram should map data between source systems, data warehouses, and specified data marts. Note: The graphically depicted solution is not included in the required page length.

Your assignment must follow these formatting requirements:

 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.

CIS 499 – Assignments and Rubrics

CIS 499 Student Version 1128 (1159 8-30-2012) Final Draft Page 16 of 32

Section 2: Revised Project Plan

Use Microsoft Project to:

2. Update the project plan from Project Deliverable 2: Business Requirements, with three to five (3- 5) new project tasks each consisting of five to ten (5-10) sub-tasks.

The specific course learning outcomes associated with this assignment are:

 Summarize how information systems represent a key source of competitive advantage for organizations.

 Develop information systems-related activities to maximize the business value within and outside the organization.

 Use technology and information resources to research issues in information systems.

 Write clearly and concisely about strategic issues and practices in the information systems domain using proper writing mechanics and technical style conventions.

Grading for this assignment will be based on answer quality, logic / organization of the paper, and language and writing skills, using the following rubric.

Points: 110 Project Deliverable 3: Database and Data Warehousing Design

Criteria

Unacceptable

Below 60% F

Meets

Minimum

Expectations

60-69% D

Fair

70-79% C

Proficient

80-89% B

Exemplary

90-100% A

Section 1: Project Introduction

1a. Support the need for data warehousing within your company and elaborate on the best practices that the company will adhere to.

Weight: 20%

Did not submit or incompletely supported the need for data warehousing within your company; did not submit or incompletely elaborated on the best practices that the company will adhere to.

Insufficiently supported the need for data warehousing within your company; insufficiently elaborated on the best practices that the company will adhere to.

Partially supported the need for data warehousing within your company; partially elaborated on the best practices that the company will adhere to.

Satisfactorily supported the need for data warehousing within your company; satisfactorily elaborated on the best practices that the company will adhere to.

Thoroughly supported the need for data warehousing within your company; thoroughly elaborated on the best practices that the company will adhere to.

1b. Create a schema that supports the company’s business and processes. Explain and support the database schema with relevant arguments that support the rationale for the structure.

Weight: 20%

Did not submit or incompletely created a schema that supports the company’s business and processes. Did not submit or incompletely explained and supported the database schema with relevant arguments that support the rationale for the

Insufficiently created a schema that supports the company’s business and processes. Insufficiently explained and supported the database schema with relevant arguments that support the rationale for

Partially created a schema that supports the company’s business and processes. Partially explained and supported the database schema with relevant arguments that support the rationale for the

Satisfactorily created a schema that supports the company’s business and processes. Satisfactorily explained and supported the database schema with relevant arguments that support the rationale for

Thoroughly created a schema that supports the company’s business and processes. Thoroughly explained and supported the database schema with relevant arguments that support the rationale for

CIS 499 – Assignments and Rubrics

CIS 499 Student Version 1128 (1159 8-30-2012) Final Draft Page 17 of 32

structure. the structure. structure. the structure. the structure.

1c. Create an Entity- Relationship (E-R) Diagram relating the tables of your database schema through the use of graphical tools in Microsoft Visio or an open source alternative such as Dia. Explain your rationale behind the design of your E-R Diagram. Weight: 15%

Did not submit or incompletely created an Entity- Relationship (E- R) Diagram relating the tables of your database schema through the use of graphical tools in Microsoft Visio or an open source alternative such as Dia. Did not submit or incompletely explained your rationale behind the design of your E-R Diagram.

Insufficiently created an Entity- Relationship (E-R) Diagram relating the tables of your database schema through the use of graphical tools in Microsoft Visio or an open source alternative such as Dia. Insufficiently explained your rationale behind the design of your E-R Diagram.

Partially created an Entity- Relationship (E- R) Diagram relating the tables of your database schema through the use of graphical tools in Microsoft Visio or an open source alternative such as Dia. Partially explained your rationale behind the design of your E-R Diagram.

Satisfactorily created an Entity- Relationship (E-R) Diagram relating the tables of your database schema through the use of graphical tools in Microsoft Visio or an open source alternative such as Dia. Satisfactorily explained your rationale behind the design of your E-R Diagram.

Thoroughly created an Entity- Relationship (E-R) Diagram relating the tables of your database schema through the use of graphical tools in Microsoft Visio or an open source alternative such as Dia. Thoroughly explained your rationale behind the design of your E-R Diagram.

1d. Create a Data Flow Diagram (DFD) relating the tables of your database schema through the use of graphical tools in Microsoft Visio or an open source alternative such as Dia.

Weight: 15%

Did not submit or incompletely created a Data Flow Diagram (DFD) relating the tables of your database schema through the use of graphical tools in Microsoft Visio or an open source alternative such as Dia.

Insufficiently created a Data Flow Diagram (DFD) relating the tables of your database schema through the use of graphical tools in Microsoft Visio or an open source alternative such as Dia.

Partially created a Data Flow Diagram (DFD) relating the tables of your database schema through the use of graphical tools in Microsoft Visio or an open source alternative such as Dia.

Satisfactorily created a Data Flow Diagram (DFD) relating the tables of your database schema through the use of graphical tools in Microsoft Visio or an open source alternative such as Dia.

Thoroughly created a Data Flow Diagram (DFD) relating the tables of your database schema through the use of graphical tools in Microsoft Visio or an open source alternative such as Dia.

1e. Illustrate the flow of data including both inputs and outputs for the use of a data warehouse. The diagram must map data between source systems, data warehouses, and specified data marts.

Weight: 15%

Did not submit or incompletely illustrated the flow of data including both inputs and outputs for the use of a data warehouse. Did not submit or incompletely mapped data between source systems, data warehouses, and specified data marts.

Insufficiently illustrated the flow of data including both inputs and outputs for the use of a data warehouse. Insufficiently mapped data between source systems, data warehouses, and specified data marts.

Partially illustrated the flow of data including both inputs and outputs for the use of a data warehouse. Partially mapped data between source systems, data warehouses, and specified data marts.

Satisfactorily illustrated the flow of data including both inputs and outputs for the use of a data warehouse. Satisfactorily mapped data between source systems, data warehouses, and specified data marts.

Thoroughly illustrated the flow of data including both inputs and outputs for the use of a data warehouse. Thoroughly mapped data between source systems, data warehouses, and specified data marts.

Section 2: Revised Project Plan

2. Update the project Did not submit or Insufficiently Partially Satisfactorily Thoroughly

CIS 499 – Assignments and Rubrics

CIS 499 Student Version 1128 (1159 8-30-2012) Final Draft Page 18 of 32

plan from Project Deliverable 2: Business Requirements, with three to five (3-5) new

project tasks each consisting of five to ten (5-10) sub-tasks.

Weight: 5%

incompletely updated the project plan from Project Deliverable 2: Business Requirements, with three to five (3-5) new project

tasks each consisting of five to ten (5-10) sub- tasks.

updated the project plan from Project Deliverable 2: Business Requirements, with three to five (3-5) new project tasks each consisting of five to ten (5-10) sub- tasks.

updated the project plan from Project Deliverable 2: Business Requirements, with three to five (3-5) new project tasks each consisting of five to ten (5- 10) sub-tasks.

3. Clarity, writing mechanics, and formatting requirements

Weight: 10%

More than 8 errors present

7-8 errors present

5-6 errors present

3-4 errors present

0-2 errors present

CIS 499 – Assignments and Rubrics

CIS 499 Student Version 1128 (1159 8-30-2012) Final Draft Page 19 of 32

Project Deliverable 4: Analytics, Interfaces, and Cloud Technology

Due Week 7 and worth 110 points

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 it is written for. Additionally, you may create and / or assume all necessary assumptions needed for the completion of this assignment.

Large companies have been using the power of business analytics for quite a while now. Your company desires to get in on the action; company executives believe that using advanced data analysis will enable the company to make smarter decisions and improve business performance. Business analytics gives companies the ability to look at past realizations and performance as well as set up new expectations and performance goals. Analytics-as-a-Service is a new delivery model that uses cloud technology to provide business insights without enormous infrastructure enhancements. The executive team has heard great things about analytics and cloud technology but is apprehensive because they are unfamiliar with the look and feel of the technology. The executive team is interested in your recommendations and eagerly awaiting your forward-thinking viewpoint.

Section 1: Design Document

1. Write a four to six (4-6) page design document in which you:

a. Support the need for the use of analytics and cloud technology within this company.

b. Create a workflow diagram to illustrate how analytics and cloud technology could align with the company’s business processes. Note: The graphically depicted solution is not included in the required page length but must be included in the design document appendix.

c. Create three to five (3-5) screen layouts that illustrate the interface that organizational users will utilize. Note: The graphically depicted solution is not included in the required page length but must be included in the design document appendix.

d. Give one (1) recommendation for solution providers that could help your company secure a firm advantage by using analytics and cloud technology.

Your assignment must follow these formatting requirements:

 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.

Section 2: Revised Project Plan

Use Microsoft Project to:

2. Update the project plan from Project Deliverable 3: Database and Data Warehousing Design, with three to five (3-5) new project tasks each consisting of five to ten (5-10) sub-tasks.

CIS 499 – Assignments and Rubrics

CIS 499 Student Version 1128 (1159 8-30-2012) Final Draft Page 20 of 32

The specific course learning outcomes associated with this assignment are:

 Demonstrate an understanding of existing and emerging information technologies, the functions of IS, and its impact on the organizational operations.

 Use technology and information resources to research issues in information systems.

 Write clearly and concisely about strategic issues and practices in the information systems domain using proper writing mechanics and technical style conventions.

Grading for this assignment will be based on answer quality, logic / organization of the paper, and language and writing skills, using the following rubric.

Points: 110 Project Deliverable 4: Analytics, Interfaces, and Cloud Technology

Criteria

Unacceptable

Below 60% F

Meets

Minimum

Expectations

60-69% D

Fair

70-79% C

Proficient

80-89% B

Exemplary

90-100% A

Section 1: Design Document

1a. Support the need for the use of analytics and cloud technology within this company.

Weight: 20%

Did not submit or incompletely supported the need for the use of analytics and cloud technology within this company.

Insufficiently supported the need for the use of analytics and cloud technology within this company.

Partially supported the need for the use of analytics and cloud technology within this company.

Satisfactorily supported the need for the use of analytics and cloud technology within this company.

Thoroughly supported the need for the use of analytics and cloud technology within this company.

1b. Create a workflow diagram to illustrate how analytics and cloud technology could align with the company’s business processes.

Weight: 25%

Did not submit or incompletely created a workflow diagram to illustrate how analytics and cloud technology could align with the company’s business processes.

Insufficiently created a workflow diagram to illustrate how analytics and cloud technology could align with the company’s business processes.

Partially created a workflow diagram to illustrate how analytics and cloud technology could align with the company’s business processes.

Satisfactorily created a workflow diagram to illustrate how analytics and cloud technology could align with the company’s business processes.

Thoroughly created a workflow diagram to illustrate how analytics and cloud technology could align with the company’s business processes.

1c. Create three to five (3-5) screen layouts that illustrate the interface that organizational users will utilize. Weight: 20%

Did not submit or incompletely created three to five (3-5) screen layouts that illustrate the interface that organizational users will utilize.

Insufficiently created three to five (3-5) screen layouts that illustrate the interface that organizational users will utilize.

Partially created three to five (3- 5) screen layouts that illustrate the interface that organizational users will utilize.

Satisfactorily created three to five (3-5) screen layouts that illustrate the interface that organizational users will utilize.

Thoroughly created three to five (3-5) screen layouts that illustrate the interface that organizational users will utilize.

1d. Give one (1) recommendation for solution providers that could help your company secure a

Did not submit or incompletely gave one (1) recommendation for solution providers that

Insufficiently gave one (1) recommendation for solution providers that could help your

Partially gave one (1) recommendation for solution providers that could help your

Satisfactorily gave one (1) recommendation for solution providers that could help your

Thoroughly gave one (1) recommendation for solution providers that could help your

CIS 499 – Assignments and Rubrics

CIS 499 Student Version 1128 (1159 8-30-2012) Final Draft Page 21 of 32

firm advantage by using analytics and cloud technology.

Weight: 20%

could help your company secure a firm advantage by using analytics and cloud technology.

company secure a firm advantage by using analytics and cloud technology.

Section 2: Revised Project Plan

2. Update the project plan from Project Deliverable 3: Database and Data Warehousing Design, with three to five (3-5) new project tasks each consisting of five to ten (5-10) sub- tasks.

Weight: 5%

Did not submit or incompletely updated the project plan from Project Deliverable 3: Database and Data Warehousing Design, with three to five (3-5) new project tasks each consisting of five to ten (5-10) sub-tasks.

Insufficiently updated the project plan from Project Deliverable 3: Database and Data Warehousing Design, with

three to five (3- 5) new project tasks each consisting of five to ten (5-10) sub-tasks.

Partially updated the project plan from Project Deliverable 3: Database and Data Warehousing Design, with three to five (3- 5) new project tasks each consisting of five to ten (5-10) sub-tasks.

Satisfactorily updated the project plan from Project Deliverable 3: Database and Data Warehousing Design, with

three to five (3- 5) new project tasks each consisting of five to ten (5-10) sub-tasks.

Thoroughly updated the project plan from Project Deliverable 3: Database and Data Warehousing Design, with

three to five (3- 5) new project tasks each consisting of five to ten (5-10) sub-tasks.

3. Clarity, writing mechanics, and formatting requirements

Weight: 10%

More than 8 errors present

7-8 errors present

5-6 errors present

3-4 errors present

0-2 errors present

CIS 499 – Assignments and Rubrics

CIS 499 Student Version 1128 (1159 8-30-2012) Final Draft Page 22 of 32

Project Deliverable 5: Infrastructure and Security

Due Week 8 and worth 110 points

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 it is written for. Additionally, you may create and / or assume all necessary assumptions needed for the completion of this assignment.

The infrastructure which encompasses the network solution and security considerations is a major consideration for your company. Considering that the company will be expanding from one (1) floor to three (3) floors in the very near future you, as the CIO, are responsible for the design of the infrastructure and security protocols. You have been tasked with designing a network that is stable, redundant, and scalable. In addition, speed and reliability are important considerations. Assumptions should be drawn regarding network usage in relationship to network services and resources. All the established criteria that were set at the onset should be adhered to within your plan. 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. Additionally, the security of the network should be in the forefront of your design because protecting your data is a primary consideration.

Section 1: Infrastructure Document

1. Write a four to six (4-6) page infrastructure document in which you:

a. Justify and support the relationship between infrastructure and security as it relates to this data-collection and analysis company.

b. Present the rationale for the logical and physical topographical layout of the planned network.

c. Design a logical and physical topographical layout of the current and 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.

d. Illustrate the possible placement of servers including access paths to the Internet, intrusion detection systems (IDS), and firewalls. Note: Facility limitations, workstations, databases, printers, routers, switches, bridges, and access points should be considered in the illustration.

e. Create and describe a comprehensive security policy for this data-collection and analysis company that will:

i. Protect the company infrastructure and assets by applying the principals of confidentiality, integrity, and availability (CIA). Note: CIA is a widely used benchmark for evaluation of information systems security, focusing on the three (3) 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.

Your assignment must follow these formatting requirements:

CIS 499 – Assignments and Rubrics

CIS 499 Student Version 1128 (1159 8-30-2012) Final Draft Page 23 of 32

 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.

Section 2: Revised Project Plan

Use Microsoft Project to:

2. Update the project plan from Project Deliverable 4: Analytics, Interfaces, and Cloud Technology, with three to five (3-5) new project tasks each consisting of five to ten (5-10) sub-tasks.

The specific course learning outcomes associated with this assignment are:

 Develop information systems-related activities to maximize the business value within and outside the organization.

 Demonstrate an understanding of existing and emerging information technologies, the functions of IS, and its impact on the organizational operations.

 Evaluate the issues and challenges associated with information systems integration.

 Use technology and information resources to research issues in information systems.

 Write clearly and concisely about strategic issues and practices in the information systems domain using proper writing mechanics and technical style conventions.

Grading for this assignment will be based on answer quality, logic / organization of the paper, and language and writing skills, using the following rubric.

Points: 110 Project Deliverable 5: Infrastructure and Security

Criteria

Unacceptable

Below 60% F

Meets

Minimum

Expectations

60-69% D

Fair

70-79% C

Proficient

80-89% B

Exemplary

90-100% A

Section 1: Infrastructure Document

1a. Justify and support the relationship between infrastructure and security as it relates to this data- collection and analysis company.

Weight: 15%

Did not submit or incompletely justified and supported the relationship between infrastructure and security as it relates to this data-collection and analysis company.

Insufficiently justified and supported the relationship between infrastructure and security as it relates to this data-collection and analysis company.

Partially justified and supported the relationship between infrastructure and security as it relates to this data-collection and analysis company.

Satisfactorily justified and supported the relationship between infrastructure and security as it relates to this data-collection and analysis company.

Thoroughly justified and supported the relationship between infrastructure and security as it relates to this data-collection and analysis company.

1b. Present the rationale for the logical and physical topographical layout of the planned network.

Weight: 20%

Did not submit or incompletely presented the rationale for the logical and physical topographical layout of the

Insufficiently presented the rationale for the logical and physical topographical layout of the planned

Partially presented the rationale for the logical and physical topographical layout of the planned

Satisfactorily presented the rationale for the logical and physical topographical layout of the planned

Thoroughly presented the rationale for the logical and physical topographical layout of the planned

CIS 499 – Assignments and Rubrics

CIS 499 Student Version 1128 (1159 8-30-2012) Final Draft Page 24 of 32

planned network. network. network. network. network.

1c. Design a logical and physical topographical layout of the current and planned network through the use of graphical tools in Microsoft Word or Visio, or an open source alternative such as Dia. Weight: 15%

Did not submit or incompletely designed a logical and physical topographical layout of the current and planned network through the use of graphical tools in Microsoft Word or Visio, or an open source alternative such as Dia.

Insufficiently designed a logical and physical topographical layout of the current and planned network through the use of graphical tools in Microsoft Word or Visio, or an open source alternative such as Dia.

Partially designed a logical and physical topographical layout of the current and planned network through the use of graphical tools in Microsoft Word or Visio, or an open source alternative such as Dia.

Satisfactorily designed a logical and physical topographical layout of the current and planned network through the use of graphical tools in Microsoft Word or Visio, or an open source alternative such as Dia.

Thoroughly designed a logical and physical topographical layout of the current and planned network through the use of graphical tools in Microsoft Word or Visio, or an open source alternative such as Dia.

1d. Illustrate the possible placement of servers including access paths to the Internet, intrusion detection systems (IDS), and firewalls.

Weight: 15%

Did not submit or incompletely illustrated the possible placement of servers including access paths to the Internet, intrusion detection systems (IDS), and firewalls.

Insufficiently illustrated the possible placement of servers including access paths to the Internet, intrusion detection systems (IDS), and firewalls.

Partially illustrated the possible placement of servers including access paths to the Internet, intrusion detection systems (IDS), and firewalls.

Satisfactorily illustrated the possible placement of servers including access paths to the Internet, intrusion detection systems (IDS), and firewalls.

Thoroughly illustrated the possible placement of servers including access paths to the Internet, intrusion detection systems (IDS), and firewalls.

1ei. Create and describe a comprehensive security policy for this data collection and analysis company that will protect the company infrastructure and assets by applying the principals of confidentiality, integrity, and availability (CIA).

Weight: 10%

Did not submit or incompletely created and described a comprehensive security policy for this data collection and analysis company that will protect the company infrastructure and assets by applying the principals of confidentiality, integrity, and availability (CIA).

Insufficiently created and described a comprehensive security policy for this data collection and analysis company that will protect the company infrastructure and assets by applying the principals of confidentiality, integrity, and availability (CIA).

Partially created and described a comprehensive security policy for this data collection and analysis company that will protect the company infrastructure and assets by applying the principals of confidentiality, integrity, and availability (CIA).

Satisfactorily created and described a comprehensive security policy for this data collection and analysis company that will protect the company infrastructure and assets by applying the principals of confidentiality, integrity, and availability (CIA).

Thoroughly created and described a comprehensive security policy for this data collection and analysis company that will protect the company infrastructure and assets by applying the principals of confidentiality, integrity, and availability (CIA).

1eii. Create and describe a comprehensive security policy for this data-collection and analysis company that will address ethical aspects related to employee behavior,

Did not submit or incompletely created and described a comprehensive security policy for this data- collection and analysis company

Insufficiently created and described a comprehensive security policy for this data- collection and analysis company that

Partially created and described a comprehensive security policy for this data- collection and analysis company that

Satisfactorily created and described a comprehensive security policy for this data- collection and analysis company that

Thoroughly created and described a comprehensive security policy for this data- collection and analysis company that

CIS 499 – Assignments and Rubrics

CIS 499 Student Version 1128 (1159 8-30-2012) Final Draft Page 25 of 32

contractors, password usage, and access to networked resources and information.

Weight: 10%

that will address ethical aspects related to employee behavior, contractors, password usage, and access to networked resources and information.

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

Section 2: Revised Project Plan

2. Update the project plan from Project Deliverable 4: Analytics, Interfaces, and Cloud Technology, with three to five (3-5) new project tasks each consisting of five to ten (5-10) sub-tasks.

Weight: 5%

Did not submit or incompletely updated the project plan from Project Deliverable 4: Analytics, Interfaces, and Cloud Technology, with three to five (3-5) new project tasks

each consisting of five to ten (5- 10) sub-tasks.

Insufficiently updated the project plan from Project Deliverable 4: Analytics, Interfaces, and Cloud Technology, with three to five (3-5) new project tasks each consisting of five to ten (5-10) sub- tasks.

Partially updated the project plan from Project Deliverable 4: Analytics, Interfaces, and Cloud Technology, with three to five (3-5) new project tasks each consisting of five to ten (5- 10) sub-tasks.

Satisfactorily updated the project plan from Project Deliverable 4: Analytics, Interfaces, and Cloud Technology, with three to five (3-5) new project tasks each consisting of five to ten (5- 10) sub-tasks.

Thoroughly updated the project plan from Project Deliverable 4: Analytics, Interfaces, and Cloud Technology, with three to five (3-5) new project tasks each consisting of five to ten (5- 10) sub-tasks.

3. Clarity, writing mechanics, and formatting requirements

Weight: 10%

More than 8 errors present

7-8 errors present

5-6 errors present

3-4 errors present

0-2 errors present

CIS 499 – Assignments and Rubrics

CIS 499 Student Version 1128 (1159 8-30-2012) Final Draft Page 26 of 32

Project Deliverable 6: Project Plan

Due Week 10 and worth 250 points

This assignment consists of three (4) sections: a written project plan, revised business requirements document, project plan PowerPoint presentation, and a finalized project plan. You must submit the four (4) 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.

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

Section 1: Written Project Plan

You are now in the final stage of the project plan development. All previous documentation should be combined into one document that will serve as the statement of work for the project. Your goal is to have the project approved by the executive team. The project plan should be very detailed, which is designed to accomplish the monumental task of implementation; however, the executive team is only interested in a 30-minute summation. Therefore, you also must create a compelling executive summary that is supported by your detail that convinces the executive team that they should move forward with your solution.

1. Develop a thirty to forty (30-40) page project plan in which you:

a. Write a five to ten (5-10) page executive summary that provides a high-level technical overview of your project in which you:

i. Describe the scope of the project and control measures.

ii. Describe the goals and objectives of the project.

iii. Include a high-level overview of all project deliverables.

iv. Give a detailed, realistically estimated cost analysis of the entire project, including human capital.

v. Relate the value of the project plan solution to the competitive advantage that information technology will afford your organization.

vi. Recommend solution providers who can assist with development and implementation.

b. Combine all previous documentation for Project Deliverables 1-5 in which you:

i. Provide all aspects of the information technology implementation into the project plan.

ii. Revise the documentation based on feedback from the earlier evaluation of your deliverable.

c. Use at least five (5) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources.

Section 1 of this assignment must follow these formatting requirements:

CIS 499 – Assignments and Rubrics

CIS 499 Student Version 1128 (1159 8-30-2012) Final Draft Page 27 of 32

 Include charts or diagrams created in MS Visio or Dia as an appendix of the project plan. All references to these diagrams must be included in the body of the project plan.

Section 2: Revised Business Requirements Document

2. Document all revisions made to the written project plan in the Document Control section of the business requirements document from Project Deliverable 2: Business Requirement. Note: This documentation must outline the revisions made to the previous deliverables required in Section 1: Written Project Plan.

Section 3: Project Plan PowerPoint Presentation

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.

3. Create a ten to fifteen (10-15) slide PowerPoint presentation in which you:

a. Illustrate the concepts from your executive summary in Section 1 of this assignment.

b. 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.

c. Use a professional technically written style to graphically convey the information.

Section 4: Finalized Project Plan

Use Microsoft project to:

4. Finalize your project plan from Project Deliverable 5: Infrastructure and Security to include all necessary changes in assumptions, tasks, and / or subtasks.

The specific course learning outcomes associated with this assignment are:

 Develop information systems-related activities to maximize the business value within and outside the organization.

 Demonstrate an understanding of existing and emerging information technologies, the functions of IS, and its impact on the organizational operations.

 Evaluate the issues and challenges associated with information systems integration.

 Use technology and information resources to research issues in information systems.

 Write clearly and concisely about strategic issues and practices in the information systems domain using proper writing mechanics and technical style conventions.

Grading for this assignment will be based on answer quality, logic / organization of the paper, and language and writing skills, using the following rubric.

Points: 250 Project Deliverable 6: Project Plan

Criteria

Unacceptable

Below 60% F

Meets

Minimum

Expectations

60-69% D

Fair

70-79% C

Proficient

80-89% B

Exemplary

90-100% A

Section 1: Written Project Plan

1ai. Describe the scope of the project

Did not submit or incompletely

Insufficiently described the

Partially described the

Satisfactorily described the

Thoroughly described the

CIS 499 – Assignments and Rubrics

CIS 499 Student Version 1128 (1159 8-30-2012) Final Draft Page 28 of 32

and control measures.

Weight: 5%

described the scope of the project and control measures.

scope of the project and control measures.

1aii. Describe the goals and objectives of the project.

Weight: 5%

Did not submit or incompletely described the goals and objectives of the project.

Insufficiently described the goals and objectives of the project.

Partially described the goals and objectives of the project.

Satisfactorily described the goals and objectives of the project.

Thoroughly described the goals and objectives of the project.

1aiii. Include a high- level overview of all project deliverables. Weight: 5%

Did not submit or incompletely included a high- level overview of all project deliverables.

Insufficiently included a high- level overview of all project deliverables.

Partially included a high- level overview of all project deliverables.

Satisfactorily included a high- level overview of all project deliverables.

Thoroughly included a high- level overview of all project deliverables.

1aiv. Give a detailed, realistically estimated cost analysis of the entire project, including human capital.

Weight: 5%

Did not submit or incompletely gave a detailed, realistically estimated cost analysis of the entire project, including human capital.

Insufficiently gave a detailed, realistically estimated cost analysis of the entire project, including human capital.

Partially gave a detailed, realistically estimated cost analysis of the entire project, including human capital.

Satisfactorily gave a detailed, realistically estimated cost analysis of the entire project, including human capital.

Thoroughly gave a detailed, realistically estimated cost analysis of the entire project, including human capital.

1av. Relate the value of the project plan solution to the competitive advantage that information technology will afford your organization.

Weight: 5%

Did not submit or incompletely related the value of the project plan solution to the competitive advantage that information technology will afford your organization.

Insufficiently related the value of the project plan solution to the competitive advantage that information technology will afford your organization.

Partially related the value of the project plan solution to the competitive advantage that information technology will afford your organization.

Satisfactorily related the value of the project plan solution to the competitive advantage that information technology will afford your organization.

Thoroughly related the value of the project plan solution to the competitive advantage that information technology will afford your organization.

1avi. Recommend solution providers who can assist with development and implementation.

Weight: 5%

Did not submit or incompletely recommended solution providers who can assist with development and implementation.

Insufficiently recommended solution providers who can assist with development and implementation.

Partially recommended solution providers who can assist with development and implementation.

Satisfactorily recommended solution providers who can assist with development and implementation.

Thoroughly recommended solution providers who can assist with development and implementation.

1bi. Combine all previous documentation for Project Deliverables 1-5 in which you provide all aspects of the information technology implementation into the project plan.

Weight: 5%

Did not submit or incompletely combined all previous documentation for Project Deliverables 1-5 in which you provide all aspects of the information technology

Insufficiently combined all previous documentation for Project Deliverables 1- 5 in which you provide all aspects of the information technology implementation

Partially combined all previous documentation for Project Deliverables 1- 5 in which you provide all aspects of the information technology implementation

Satisfactorily combined all previous documentation for Project Deliverables 1- 5 in which you provide all aspects of the information technology implementation

Thoroughly combined all previous documentation for Project Deliverables 1- 5 in which you provide all aspects of the information technology implementation

CIS 499 – Assignments and Rubrics

CIS 499 Student Version 1128 (1159 8-30-2012) Final Draft Page 29 of 32

implementation into the project plan.

into the project plan.

1bii. Combine all previous documentation for Project Deliverables 1-5 in which you revise the documentation based on feedback from the earlier evaluation of your deliverable.

Weight: 5%

Did not submit or incompletely combined all previous documentation for Project Deliverables 1-5 in which you revise the documentation based on feedback from the earlier evaluation of your deliverable.

Insufficiently combined all previous documentation for Project Deliverables 1- 5 in which you revise the documentation based on feedback from the earlier evaluation of your deliverable.

Partially combined all previous documentation for Project Deliverables 1- 5 in which you revise the documentation based on feedback from the earlier evaluation of your deliverable.

Satisfactorily combined all previous documentation for Project Deliverables 1- 5 in which you revise the documentation based on feedback from the earlier evaluation of your deliverable.

Thoroughly combined all previous documentation for Project Deliverables 1- 5 in which you revise the documentation based on feedback from the earlier evaluation of your deliverable.

1c. 5 references

Weight: 5%

No references provided

Does not meet the required number of references; all references poor quality choices.

Does not meet the required number of references; some references poor quality choices.

Meets number of required references; all references high quality choices.

Exceeds number of required references; all references high quality choices.

Section 2: Revised Business Requirements Document

2. Document all revisions made to the written project plan in the Document Control section of the business requirements document from Project Deliverable 2: Business Requirement.

Weight: 5%

Did not submit or incompletely documented all revisions made to the written project plan in the Document Control section of the business requirements document from Project Deliverable 2: Business Requirement.

Insufficiently documented all revisions made to the written project plan in the Document Control section of the business requirements document from Project Deliverable 2: Business Requirement.

Partially documented all revisions made to the written project plan in the Document Control section of the business requirements document from Project Deliverable 2: Business Requirement.

Satisfactorily documented all revisions made to the written project plan in the Document Control section of the business requirements document from Project Deliverable 2: Business Requirement.

Thoroughly documented all revisions made to the written project plan in the Document Control section of the business requirements document from Project Deliverable 2: Business Requirement.

Section 3: Project Plan PowerPoint Presentation

3a. Create a ten to fifteen (10-15) slide PowerPoint presentation in which you illustrate the concepts from your executive summary in Section 1 of this assignment.

Weight: 10%

Did not submit or incompletely

created a ten to fifteen (ten to fifteen (10-15)) slide PowerPoint presentation in which you illustrated the concepts from your executive summary in Section 1 of this assignment.

Insufficiently created a ten to fifteen (10-15) slide PowerPoint presentation in which you illustrated the concepts from your executive summary in Section 1 of this assignment.

Partially created a ten to fifteen (10-15) slide PowerPoint presentation in which you illustrated the concepts from your executive summary in Section 1 of this assignment.

Satisfactorily created a ten to fifteen (10-15) slide PowerPoint presentation in which you illustrated the concepts from your executive summary in Section 1 of this assignment.

Thoroughly created a ten to fifteen (10-15) slide PowerPoint presentation in which you illustrated the concepts from your executive summary in Section 1 of this assignment.

CIS 499 – Assignments and Rubrics

CIS 499 Student Version 1128 (1159 8-30-2012) Final Draft Page 30 of 32

3b. Create a ten to fifteen (10-15) slide PowerPoint presentation in which you create bulleted speaking notes for your presentation to the executive board in the Notes section of the PowerPoint. Weight: 10%

Did not submit or incompletely created a ten to fifteen (10-15) slide PowerPoint presentation in which you created bulleted speaking notes for your presentation to the executive board in the Notes section of the PowerPoint.

Insufficiently created a ten to fifteen (10-15) slide PowerPoint presentation in which you created bulleted speaking notes for your presentation to the executive board in the Notes section of the PowerPoint.

Partially created a ten to fifteen (10-15) slide PowerPoint presentation in which you created bulleted speaking notes for your presentation to the executive board in the Notes section of the PowerPoint.

Satisfactorily created a ten to fifteen (10-15) slide PowerPoint presentation in which you created bulleted speaking notes for your presentation to the executive board in the Notes section of the PowerPoint.

Thoroughly created a ten to fifteen (10-15) slide PowerPoint presentation in which you created bulleted speaking notes for your presentation to the executive board in the Notes section of the PowerPoint.

3c. Create a ten to fifteen (10-15) slide PowerPoint presentation in which you use a professional technically written style to graphically convey the information.

Weight: 5%

Did not submit or incompletely created a ten to fifteen (10-15) slide PowerPoint presentation in which you used a professional technically written style to graphically convey the information.

Insufficiently created a ten to fifteen (10-15) slide PowerPoint presentation in which you used a professional technically written style to graphically convey the information.

Partially created a ten to fifteen (10-15) slide PowerPoint presentation in which you used a professional technically written style to graphically convey the information.

Satisfactorily created a ten to fifteen (10-15) slide PowerPoint presentation in which you used a professional technically written style to graphically convey the information.

Thoroughly created a ten to fifteen (10-15) slide PowerPoint presentation in which you used a professional technically written style to graphically convey the information.

Section 4: Finalized Project Plan

4. Finalize your project plan from Project Deliverable 5: Infrastructure and Security to include all necessary changes in assumptions, tasks, and / or subtasks.

Weight: 15%

Did not submit or incompletely finalized your project plan from Project Deliverable 5: Infrastructure and Security to include all necessary changes in assumptions, tasks, and / or subtasks.

Insufficiently finalized your project plan from Project Deliverable 5: Infrastructure and Security to include all necessary changes in assumptions, tasks, and / or subtasks.

Partially finalized your project plan from Project Deliverable 5: Infrastructure and Security to include all necessary changes in assumptions, tasks, and / or subtasks.

Satisfactorily finalized your project plan from Project Deliverable 5: Infrastructure and Security to include all necessary changes in assumptions, tasks, and / or subtasks.

Thoroughly finalized your project plan from Project Deliverable 5: Infrastructure and Security to include all necessary changes in assumptions, tasks, and / or subtasks.

5. Clarity, writing mechanics, and formatting requirements

Weight: 10%

More than 8 errors present

7-8 errors present

5-6 errors present

3-4 errors present

0-2 errors present

CIS 499 – Student Notes

CIS 499 Student Version 1128 (1159 8-30-2012) Final Draft Page 31 of 32

Weekly Course Schedule

The purpose of the course schedule is to give you, at a glance, the required preparation, activities, and evaluation components of your course. For more information about your course, whether on-ground or online, access your online course shell.

The expectations for a 4.5 credit hour course are for students to spend 13.5 hours in weekly work. This time estimate includes preparation, activities, and evaluation regardless of the delivery mode.

Instructional Materials

In order to be fully prepared, obtain a copy of the required textbooks and other instructional materials prior to the first day of class. When available, Strayer University provides a link to the first three (3) chapters of your textbook(s) in eBook format. Check your online course shell for availability.

Review the online course shell or check with your professor to determine whether Internet-based assignments and activities are used in this course.

Instructional materials are obtained through the university’s virtual bookstore and can be accessed through iCampus: http:bookstore.mbsdirect.net/strayer.htm. Courses with Internet-based assignments and activities on publisher sites may require the purchase of onetime access codes. When purchasing used textbooks, a separate access code purchase will be necessary.

Discussions

Students taking this course online are required to post their discussions to a weekly thread in the online course shell. Respond to at least two (2) other students’ posts to earn full credit for each discussion. As it is always possible that you could lose your work due to unforeseen circumstances, you should routinely save your work in a separate file before posting in the course discussion area.

Professors hold discussions during class time for on-ground students. Check with your professor if any additional discussion participation is required in the online course shell outside of class hours.

Tests

Tests (quizzes, midterm and final exams, essay exams, lab tests, etc.) are available for student access and completion through the online course shell. Check the online course shell to determine how you are expected to take the tests.

 Online students are to complete the test by Sunday midnight the week the test is due.

 On-ground students are to complete the tests after the material is covered and before the next class session.

Assignments

A standardized performance grading rubric is a tool your professor will use to evaluate your written assignments. Review the rubric before submitting assignments that have grading rubrics associated with them to ensure you have met the performance criteria stated on the rubric.

Grades are based on individual effort. There is no group grading; however, working in groups in the online or on-ground classroom is acceptable.

Assignments for online students are always submitted through the online course shell. On-ground professors will inform students on how to submit assignments, whether in paper format or through the online course shell.

http://bookstore.mbsdirect.net/strayer.htm

CIS 499 – Student Notes

CIS 499 Student Version 1128 (1159 8-30-2012) Final Draft Page 32 of 32

Resources

The Resource Center navigation button in the online course shell contains helpful links. Strayer University Library Resources are available here as well as other important information. You should review this area to find resources and answers to common questions.

Technical support is available for the following:

 For technical questions, please contact Strayer Online Technical Support by logging in to your

iCampus account at https://icampus.strayer.edu/login and submitting a case under “Student

Center,” then “Submit Help Ticket.” If you are unable to log in to your iCampus account, please

contact Technical Support via phone at (877) 642-2999.

 For concerns with your class, please access the Solution Center by logging in to your iCampus

account at https://icampus.strayer.edu/login and submitting a case under “Student Center,” then

“Submit Help Ticket.” If you are unable to log in to your iCampus account, please contact the IT

Help Desk at (866) 610-8123 or at mailto:[email protected].

TurnItIn.com is an optional online tool to assess the originality of student written work. Check with your professor for access and use instructions.

The Strayer Policies link on the navigation bar in the online course shell contains academic policies. It is important that students be aware of these policies.

https://icampus.strayer.edu/login

mailto:[email protected]