Risk Determination And Decision Tree Analysis
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
i. Use the Reference Tab in the workbook to select the appropriate values from the respective tables and complete Columns B, C, D, & E
ii. Column F (Risk Score) is a calculated field already formatted
iii. Column H (Possible Safeguards) provide the safeguards you would put in place to mitigate the threat (e.g., controls, policies, etc.)
b. Occupation Analysis – Tab
i. Use the Risk Level Table and assign the appropriate value for each occupation and the corresponding threats outlined in Columns B, C, D, &E
ii. Column F (Total) is a calculated filed already formatted
iii. Complete the occupational analysis; answer the four questions after completing your occupational vulnerability assessment
c. Decision Tree Analysis – Tab
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 Worksh
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
i. Use the Reference Tab in the workbook to select the appropriate values from the respective tables and complete Columns B, C, D, & E
ii. Column F (Risk Score) is a calculated field already formatted
iii. Column H (Possible Safeguards) provide the safeguards you would put in place to mitigate the threat (e.g., controls, policies, etc.)
b. Occupation Analysis – Tab
i. Use the Risk Level Table and assign the appropriate value for each occupation and the corresponding threats outlined in Columns B, C, D, &E
ii. Column F (Total) is a calculated filed already formatted
iii. Complete the occupational analysis; answer the four questions after completing your occupational vulnerability assessment
c. Decision Tree Analysis – Tab
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.
eets (M.S. Excel Document not PDF) and upload the file using the designated link on Moodle on or before the assignment due date.