Homework # 5 Risk Determination & Decision Tree Analysis
1. Review Module-5 Lecture Notes and Chapter Readings
2. Use the Risk Determination Excel Workbook and complete the following worksheets:
a. Corporate Assets Risk Summary – Tab (25-Points)
i. 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).
Threat Vulnerability Work Table
ii. Column H (Risk Score) is a calculated field already formatted
iii. 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
iv. 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.
v. Provide thorough summary analysis of each section
b. Occupation Analysis – Tab (25-Points)
i. 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
ii. Column G (Total) is a calculated filed already formatted
iii. Complete the occupational analysis; answer the four questions after completing your occupational vulnerability assessment; provide sufficient level of detail in your responses.
c. Decision Tree Analysis – Tab (50-Points)
i. Examine the Decision Tree Analysis for enterprise CRM solution approach
ii. Complete the corresponding tables for both paths and individual branches referencing the values in the decision tree diagram.
iii. Some of the data is already populated
iv. Total fields, Branch Total fields, and Value Fields are calculated fields and are already formatted
v. Answer the question regarding which options provides the best overall value
vi. Explain your reasoning for the choice you made, response should be based on your analysis of the decision tree results.
vii. Hint: Only one of the value fields should have a negative value when finished
3. 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.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.Read more
Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.Read more
Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.Read more
By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.Read more