Be sure to read Chapters 7, 8, & 9 in course text, Homework-05 Guideline document, and review Module 5 lecture notes. To complete this assignment you will need to download and complete the Homework-05

Harrisburg University Homework-05 ISEM 547

Risk Determination & Decision Tree Analysis

1. Review Module-5 Lecture Notes and Chapter Readings

2. Use the Risk Determination Excel Workbook, provide thoughtful and comprehensive responses to each section of the workbook tabs, and complete the following individual worksheets:

   1. Corporate Assets Risk Summary – Tab (25-Points)

      1. Use the Reference Tab in the workbook to select the appropriate values from the respective tables and complete Columns C, D, E, F, & G (Hint: use the Threat Vulnerability Reference Table; return the numerical value for the corresponding probability and impact).

1. 1. 1. Column H (Risk Score) is a calculated field already formatted

      2. Column I (Possible Safeguards) provide the safeguards you would put in place to mitigate the threat (e.g., controls, policies, etc.); provide sufficient level of detail

      3. Column J (Cost Estimates) provide cost estimates/ranges for the safeguards you would put in place to mitigate the threat; provide sufficient level of detail in the Comments Section Column K.

      4. Provide thorough summary analysis of each section

   2. Occupation Analysis – Tab (25-Points)

      1. Use the Risk Level Table provided on worksheet (Cells B25-C31) to assign the appropriate value for each occupation and the corresponding threats outlined in Columns C,D,E,& F

      2. Column G (Total) is a calculated filed already formatted

      3. Complete the occupational analysis; answer the four questions after completing your occupational vulnerability assessment; provide sufficient level of detail in your responses.

   3. Decision Tree Analysis – Tab (50-Points)

      1. Examine the Decision Tree Analysis for enterprise CRM solution approach

      2. Complete the corresponding tables for both paths and individual branches referencing the values in the decision tree diagram.

      3. Some of the data is already populated

      4. Total fields, Branch Total fields, and Value Fields are calculated fields and are already formatted

      5. Answer the question regarding which options provides the best overall value

      6. Explain your reasoning for the choice you made, response should be based on your analysis of the decision tree results.

      7. Hint: Only one of the value fields should have a negative value when finished

1. Complete the Risk Determination Worksheets (M.S. Excel Document not PDF) and upload the file using the designated link on Moodle on or before the assignment due date.