LAB

  

Questions

1) Summarize what you’ve done in this lab as if you are explaining it to your CEO or another important non-technical person.

2) Given that you have learned the names of the SDLC phases, which SDLC phases have you seen/used in this lab? You may write what you did, what you saw in the Azure cloud environment & Azure DevOps menus. 

Computer Science CSS 215

 

Instructions

Read the information below, then complete the designated tasks with your team.

Millennium Health

Doctor Johnson and Doctor Diaz recently decided that their practice needs a modern information system to support its business and health information management needs. The new system would replace a mix of paper-based and legacy systems. Dr. Johnson asked you to design an information system that could support the clinic’s current operations and future growth.

In your first meeting, Dr. Johnson provided an overview of the clinic’s business processes and staff members. He described the staff as follows:

  • Sheila Logan, office manager.
  • Support staff reporting to Sheila are:
    • Fred Brown — human resources and employee benefits.
    • Ricky Flemming reports directly to Fred and works with payroll, tax reporting, and profit distribution among the associates.
    • Aisha Fox is responsible for the maintenance of patient medical records.
    • Zane Ricardo handles accounts receivables.
    • Deb Baldwin is the insurance billing specialist.
    • Min-ji Park is responsible for managing appointments. Her duties include reminder calls to patients and preparing daily appointment lists.
    • Clare Kline is concerned primarily with ordering and organizing office and medical supplies.

After studying this information, you start to prepare for your next meeting with Dr. Johnson.

Tasks:

  1. Use the background information to create a business profile for Millennium Health. The profile should include an organization chart of the office staff. You can create the chart using Microsoft Word or a similar program, or you can draw it by hand. In Word, click the Insert tab on the Ribbon, then Smart Art, then Organization Chart.
  2. Identify six business processes that Millennium Health performs and explain who has primary responsibility for each process.
  3. Describe the systems development method you plan to use and explain the pros and cons of using this method.
  4. At the bottom of the document, list team members and explain each member’s contribution to the above tasks.  If you worked together on all tasks, then list the date and time of the meeting, how you met (Zoom, etc.), and the review process of the final document.  

Risk Assessment Executive Summary

 Compile a 750- to 1,250-word executive summary to be submitted to the executive committee. Within the summary:

  1. Briefly summarize the scope and results of the risk assessment.
  2. Highlight high-risk findings and comment on required management actions.
  3. Present an action plan to address and prioritize compliance gaps.
  4. Present a cost/benefit analysis.
  5. Explain the risks involved in trying to achieve the necessary outcomes and the resources required to address the gaps.

Refer to “CYB-650 Executive Summary Scoring Guide,” prior to beginning the assignment to become familiar with the expectations for successful completion. 

Case Study

Your paper must be APA-formatted, 1200 to 1500 words, double-spaced, 12-point font size in Times New Roman.

 Please read and follow the Phoenix document for more detailed instructions. Attached below.

https://store.hbr.org/product/the-phoenix-project-remediation-of-a-cybersecurity-crisis-at-the-university-of-virginia/UV7351

Exp19_Excel_Ch03_CapAssessment_Movies

Exp19_Excel_Ch03_CapAssessment_Movies

  

Project Description:

You are an assistant manager at Premiere Movie Source, an online company that enables customers to download movies for a fee. You need to track movie download sales by genre. You gathered the data for April 2021 and organized it in an Excel workbook. You are ready to create charts to help represent the data so that you can make a presentation to your manager later this week.

Steps to Perform:

   

Step

Instructions

Points    Possible

 

1

Start   Excel. Download and open the file named Exp19_Excel_Ch03_CapAssessment_Movies.xlsx.   Grader has automatically added your last name to the beginning of the   filename.

0

 

2

You want to create a pie chart to show the   percentage each category contributes to the monthly movie downloads.
 

  Select the ranges A5:A10 and F5:F10. Create a pie chart and move it to a   chart sheet named April Pie Chart.

6

 

3

The   chart needs a descriptive title that is easy to read.
 

  Type April   2021 Downloads by Genre as the chart title, apply bold, 18 pt font size, and Black, Text   1 font color.

5

 

4

Percentage and category data labels will provide   identification information for the pie chart.
 

  Add category and percentage data labels in the Inside End position. Remove   value data labels and the legend. Apply 14 pt font size and Black, Text 1   font color.

5

 

5

You   want to focus on the comedy movies by exploding it and changing its fill   color.
 

  Explode the Comedy slice by 7% and apply Dark Red fill color.

 

4

 

6

A best practice is to include Alt Text for   accessibility compliance.
 

  Add Alt Text: The pie chart shows percentage of downloads by genre   for April 2021.   (including the period)

2

 

7

Next   you want to create a combo chart to depict the monthly totals and percentages   by category.
 

  Display the Data sheet, select the ranges A4:A10 and F4:G10, and then create   a Clustered Column – Line on Secondary Axis combo chart.

4

 

8

You want to position the chart below the data   source.
 

  Cut the chart and paste it in cell A13. Change the height to 3.5″ and the width to 6″.

5

 

9

Change   the combo chart title to April 2021 Downloads. Apply Black, Text 1 font color to the chart   title.

3

 

10

Axis titles will help distinguish the number and   percentage of downloads.
 

  Add a primary value axis title and type Number of Downloads. Add a secondary value axis   title and type Percentage of Monthly Downloads. Apply Black, Text 1 font color   to both value axis titles.

6

 

11

Now   that you added an axis title for each vertical axis, you can remove the   legend and format the secondary value axis to display whole percentages.
 

  Remove the legend for the combo chart. Display 0 decimal places for the   secondary value axis.

 

1

 

12

You want to add some color to the plot area for the   combo chart.
 

  Apply Light Gradient – Accent 1 gradient fill color for the plot area.

5

 

13

A best   practice is to include Alt Text for accessibility compliance.
 

  Add Alt Text: The combo chart shows the number and percentage of   downloads by genre for April 2021. (including the period).

2

 

14

To provide a visual summary of the weekly totals   for each genre, you will insert sparklines.
 

  Select the range B5:E11. Insert Line Sparklines in the range H5:H11. Apply   Black, Sparkline Style Dark #4

10

 

15

Displaying   the markers helps identify the specific points on the sparklines. You will   also change the high point to a different color to stand out.
 

  Show the high point and markers for the sparklines. Change the high point   marker color to Red.

5

 

16

Your last major task is to create a bar chart for   weekly downloads.
 

  Select the range A4:E10. Create a stacked bar chart. Move the chart to new   chart sheet. Type Weekly Downloads for the sheet name. Apply Style 8 chart style.

14

 

17

Add a   chart title above the bar chart and type April 2021 Weekly Downloads by Genre

4

 

18

Increasing the font size will make the chart   elements easier to read.
 

  Apply 11 pt font size to the category axis, value axis, and the legend for   the bar chart.

6

 

19

Because   the largest value is less than 9,000, you can reduce the maximum bound in the   chart. In addition, you want to display the category labels in the same order   that they are in the worksheet.
 

  Change the maximum bounds for the value axis to 9000 and set the Major Units to 500 for the bar chart. Use the Axis   Options to format the category axis so that the category labels are in   reverse order in the bar chart.

5

 

20

Although the bar chart displays major gridlines,   minor gridlines could improve the appearance.
 

  Add primary minor vertical gridlines to the bar chart.

0

 

21

A best   practice is to include Alt Text for accessibility compliance for the bar   chart.
 

  Add Alt Text: The stacked bar chart shows downloads by each week for   each genre.   (including the period).

4

 

22

Insert a footer with Exploring Series on the left, the sheet name   code in the center, and the file name code on the right on all the sheets.   Change to Normal view.

4

 

23

Save   and close Exp19_Excel_Ch03_CapAssessment_Movies.xlsx.   Exit Excel. Submit the file as directed.

0

Factors to consider before initiating of an IT project

  

Before you begin this assignment, be sure you have read the Case Study and all assignments for this class, especially Stage 4: Final System Report.

Purpose of this Assignment

This assignment gives you the opportunity to use industry-standard methodologies for analyzing a business situation, initiating a project, and determining various aspects of feasibility of an IT project.  This assignment specifically addresses the following course outcomes to enable you to:

· plan, build, and maintain systems that meet organizational strategic goals by demonstrating the use of enterprise architecture and applying enterprise governance principles and practices

· effectively communicate with stakeholders to determine, manage, and document business requirements throughout the SDLC

Assignment

The results of your systems analysis and design work in this class will be documented in a Final System Report. The purpose of the Report is to inform management of your system proposal and gain approval to proceed with the project. The Report will be developed and submitted in stages, which will be compiled at the end of class into the Final System Report. Review the outline of the Final System Report in the Stage 4 Assignment description. Note that it contains the analysis of the problem(s) and requirements, and proposes what kind of a system solution is needed. It does not propose a specific solution, but it does recommend why and how the organization should acquire the solution.

The first step in the analysis process is to create a Preliminary Investigation Report (PIR). The PIR documents the system planning phase of the System Development Life Cycle (SDLC).  During the planning phase, the opportunities presented or problem(s) to be solved with an information technology system are identified, investigation into the current situation occurs, and various feasibility aspects of implementing a system are analyzed. This results in a recommendation for further action with estimated costs and schedule, and a list of benefits. Once it is completed and approved, the PIR becomes the major source document for use to begin the systems analysis phase.

To start, read the case study carefully. The case study tells you that the executives at Precision Electronics Parts, Inc., have identified a need to replace the current customer billing and payment system and re-engineer the associated processes. As you review the case study, list the most important relevant business problems and identify the information presented that you will need to complete the sections of the Preliminary Investigation Report shown below.  All of the information you need to complete the projects in this class is not provided in the case study. In the discussion area of the classroom, there is a discussion titled “Case Study Interview Questions” where you can pose questions about the case study, as if you were interviewing the people in the case study organization. Any information that you need that is not included in the case study should be asked about in this discussion. Responses from the faculty member on behalf of the case study organization will be available for everyone in the class. 

Using the case study and the outline and resources listed below, develop your Preliminary Investigation Report. Approximate lengths for each section are provided as a guideline; be sure to provide all pertinent information. References in brackets are to the two e-textbooks (by authors Jawahar and Conger) used in this class and the page on which the explanatory information begins.

I. Introduction (1 paragraph)

a. Brief statement of the problem or system

b. Name of person or group who initiated the investigation

c. Name of person or group who performed the investigation

II. Problem to be solved – The basis of the system request, including an explanation of major problems or opportunities (1 paragraph)

III. Findings 

a. Scope of proposed system (1 paragraph describing the system boundaries – what is included, perhaps where it stops)

b. Constraints (1 paragraph, including a short list of constraints) [Jawahar, p. 61]

c. Fact Finding – significant findings and conclusions (1 paragraph with more than one finding and conclusion to be drawn; source is the case study and responses to questions posed in the Case Study Interview Questions discussion)

d. Current Costs – cost of current system (1 short paragraph; source is the case study and responses to questions posed in the Case Study Interview Questions discussion)

IV. Feasibility Analysis: This is not a complete Feasibility Report; instead it is a discussion of whether and how the proposed systems is technically, financially and organizationally feasible. Describe what aspects of the organization in the case study and the proposed system make it technically, financially and organizationally feasible. [Jawahar, p. 65] 

a. Technical Feasibility (1 paragraph)

b. Financial Feasibility (1 paragraph)

c. Organizational/Behavioral Feasibility (1 paragraph)

V. Recommendation for further action 

a. An estimate of how long it would take to implement the system and have it available for use, and a rough cost estimate for the entire project (short paragraph with estimated time and cost)

b. Expected benefits – tangible (with estimated quantification) and intangible benefits (introductory paragraph and list of tangible (quantified) and intangible benefits) [Conger, p. 148]

Submitting Your Assignment

Submit your document via your Assignment Folder as Microsoft Word document, or a document that can be ready using MS Word, with your last name included in the filename. 

Use the Grading Rubric below to be sure you have covered all aspects of the assignment.

GRADING RUBRIC:

  

Criteria

90-100%

Far Above Standards

80-89%

Above Standards

70-79%

Meets Standards

60-69%

Below Standards

< 60%

Well Below Standards

Possible Points

 

Introduction

9-10 Points

The introduction   includes the statement of the problem, who initiated and who conducted the   investigation, and is clear, logical, derived from the Case Study, and   demonstrates a sophisticated level of writing. 

8 Points

The introduction   includes the statement of the problem, who initiated and who conducted the   investigation, and is clear, logical, derived from the Case Study, and   demonstrates a clear understanding of the course concepts. 

7 Points

The introduction   includes the statement of the problem, who initiated and who conducted the   investigation; is adequate, and is derived from the Case Study. 

6 Points

The background for   the business case is not clear, logical and/or derived from the Case Study.   It may not include the statement of the problem, who initiated and who   conducted the investigation.

0-5 Points

Introduction is   not included, or demonstrates little effort.

10

 

Description   of Problem

9-10 Points

The basis of the system request, including   an explanation of major problems or opportunities is provided, and is clear,   specific, and logical, appropriate to the Case Study and demonstrates a   sophisticated level of writing. 

8 Points

The basis of the system request, including   an explanation of major problems or opportunities is provided, and is clear,   specific, and logical, appropriate to the Case Study and demonstrates   effective writing. 

7 Points

The basis of the   system request, including an explanation of major problems or opportunities   is provided, and is adequate and appropriate to the Case Study. 

6   Points

The basis of the system   request is unclear, too general, and/or not appropriate to the Case   Study. It may not provide an explanation of major problems or opportunities.

0-5 Points

Description of Problem   is not submitted, or demonstrates little effort.

10

 

Findings

18-20 Points

Findings include   scope, constraints, fact finding results and conclusions, and current system   costs, and is   clear, specific, and logical, appropriate to the Case Study and demonstrates   a sophisticated level of writing.

16-17 Points

Findings include   scope, constraints, fact finding results and conclusions, and current system   costs, and   is clear, specific, and logical, appropriate to the Case Study and   demonstrates effective writing.

14-15 Points

Findings include   scope, constraints, fact finding results and conclusions, and current system   costs, and   is adequate and appropriate to the Case Study.

12-13 Points

Findings may not   include scope,   constraints, fact finding results and conclusions, and current system costs.

0-11 Points

Findings are not provided,   or demonstrates little effort.

20

 

Feasibility   Analysis

27-30 Points

Feasibility   Analysis correctly and convincingly explains the technical, economic and   organizational/ behavioral feasibility of the proposed system. Demonstrates a   sophisticated level of writing.

24-26 Points

Feasibility   Analysis correctly explains the technical, economic and organizational/   behavioral feasibility of the proposed system. Is appropriate to the case study and   demonstrates effective writing.

21-23 Points

Feasibility   Analysis explains the technical, economic and organizational/ behavioral   feasibility of the proposed system. Is   appropriate to the case study.

18-20 Points

Feasibility   Analysis may not explain the technical, economic and organizational/   behavioral feasibility of the proposed system.

0-17 Points

Feasibility   Analysis is not included, or demonstrates little effort.

30

 

Recommend-ation

18-20 Points

Recommendation is   clear, convincing, and includes estimated time and cost, and tangible and   intangible benefits. Demonstrates a   sophisticated level of writing.

16-17 Points

Recommendation is   clear, and includes estimated time and cost, and tangible and intangible   benefits. Is appropriate to the case   study and demonstrates effective writing. 

14-15 Points

Recommendation   includes estimated time and cost, and tangible and intangible benefits. Is   appropriate to the case study.

12-13 Points

Recommendation may   not include estimated time and cost, and/or tangible and intangible benefits.

0-11 Points

Recommend-ation is   not included or demonstrates little effort.

20

 

Format

9-10 Points

Submission   reflects effective organization and sophisticated writing; follows   instructions provided; uses correct structure, grammar, and spelling;   presented in a professional format; any references used are appropriately   incorporated and cited using APA style.

8 Points

Submission   reflects effective organization and clear writing; follows instructions   provided; uses correct structure, grammar, and spelling; presented in a   professional format; any references used are appropriately incorporated and   cited using APA style.

7 Points

Submission is   adequate, is somewhat organized, follows instructions provided; contains   minimal grammar and/or spelling errors; and follows APA style for any   references and citations. 

6 Points

Submission is not   well organized, and/or does not follow instructions provided; and/or contains   grammar and/or spelling errors; and/or does not follow APA style for any   references and citations. May demonstrate inadequate level of writing.

0-5 Points

Document is   extremely poorly written and does not convey the information.

10

 

TOTAL Points   Possible

100

Design Document

A design document consists of various elements including a style guide and navigation structure. Creating the style guide is one of the more creative aspects of a mobile application. As the style guide is created this week, you want to establish the colors and fonts that will be used throughout the mobile application. These design and style choices should directly reflect the purpose of the mobile app and appeal to the target audience. This style guide should help ensure that the visual aspects of the website will be consistent regardless of the page users will be on in the site. Each style guide would consist of a proposed set of color swatches with their hexadecimal color code to ensure that the exact same colors are being used throughout the entire design of the mobile application. The style guide package would also consist of the font specifications that will be used within the app. The fonts should be selected for the buttons, navigation and the text at the minimum. These fonts should be displayed using the actual font and size that you are proposing. The mobile application navigation should provide the information about the navigation process between the various screens. The information that should be created in this visual diagram should be presented in a flowchart. The flowchart should list all the planned main screens and identify how the pages are going to be linked together. Note that some of your screens are universally accessible such as the home screen whereas other screens may only be accessible based on specific criteria. This flowchart will provide a blueprint for the mobile navigation designating how the various screens will be connected.

Questions to answer

 

1. Problem Solving: Your Turn: There are problems listed below you can solve by working by yourself. Use books, manuals, online help, the Internet, and other resources. Some problems are easier than others. As you work on these tasks, make some brief notes that describe your experience. Do some metacognition about your problem-solving approach.

RESEARCH and Find answers to problems below:

  #2, A user gets an error message: “Error Loading Kernel. You must reinstall Windows.” 
What is the likely cause of this message? Do you really have to reinstall Windows to fix the problem? (write comments to the user in at least 70 words minimum).

  #3, Sometimes users will call with MS Suite questions. A user calls who uses MS Excel often selects the “Shrink-to-Fit” feature in MS WORD to force a memo that is a little too long to fit on a single page. He wants to know if Excel has a similar feature that will force a Worksheet to FIT on a single page without overlapping to a second page.
Is there a Shrink-to-Fit feature in Excel? If so, how is it used? (explain to the user – minimum 70 words)

and #5. Use the operating system utilities on your PC to document the following information.
For each question, indicate which tool you used to find the information.

   a. What model of the processor is in your system?

   b. What type of bus architecture is used?

   c. How much total memory does your system have?

   d. Is the subdirectory C:NET in the search path?

   e. How is the environment variable TEMP defined?

   f. For the mouse on your system, what are the IRQ address and the device version?

   g. What is the size of the primary hard drive? How much free space is available on it?

SUBMIT using WORD (file extension –  .doc OR .docx ).