risk analysis and threat assessment
rebdeoilw24
SpreadsheetInstructions.docxFor the risk assessment spreadsheet, following are a few pointers to get you started.
The spreadsheet has multiple tabs that will show at the bottom of the window; in this assignment, you will focus on the ones labeled Threat List, Probability, Vulnerability, Impact, and Risk Rating.
1. Consider and do research on the location you are assigned to come up with a list of at least 10 hazards that could occur in that location (use a mix of natural and human-caused hazards).
2. On the Threat List tab, type those 10 hazards (one per row) in the yellow shaded area (rows/cells B7 through B29).
3. Move to the Probability tab. (Your list of hazards/threats should have auto-populated from the Threat list page.) Review the probability rating scale near the top of the Probability worksheet/page and, doing additional research as needed, estimate the probability or likelihood of each hazard from 1 to 5; enter your estimated rating (use numerals, not words) for each hazard in the yellow box next to the corresponding hazard.
4. Select the Vulnerability tab. (Again, your list of hazards should already appear.) Review the vulnerability rating scale and explanation at the top of the page/worksheet, and, doing additional research as needed, estimate vulnerability in the location to each of the hazards. Type your rating from 1 to 5 in the yellow box next to each hazard.
5. Select the Impact tab, review the Impact rating guidance and follow a similar process to enter impact ratings (1 to 5) for each hazard.
6. Move to the Risk Rating tab. If you have entered ratings for the location's 10 hazards in the designated spaces on the previous tabs, The spreadsheet should calculate an overall risk rating for each hazard. If it doesn't appear to work properly, give me a call and let's talk through what you are seeing. Save your spreadsheet with all team members' last names or initials in the filename.
