FEMA 452: Risk AssessmentAvailable at: http://www.fema.gov/plan/prevent/rms/rmsp452.shtm Unit Objectives Explaindatabase install process, if not already installed Identify where to save photos, maps, drawings, plans, etc. to interface with database Explaininformation required for database to function within each screen, how to move between screens, and switch between assessment tool operating mode and master database operating mode Explainbenefit and approaches to setting priorities on identified vulnerabilities Explainhow to use database to produce standard reports and search database for specific information FEMA 452: Risk Assessment Text Box: Assessment Tool Mode Database Structure Import Assessments Conduct Assessment Exchange Files, Pictures, Data Manage Program Text Box: Assessment Tool ModeStore / Analyze Data Text Box: Master Database Mode Structural EngineerLead AssessorCost EngineerPhy. Sec. SMEInfrastructure Engineer Open DatabaseFEMA Master Assessment Database V3 Login to Database Assessment Operating Mode •Create and name assessment•Enter the Facility or COOP assessment forms•Empty database•Switch to Master Database Mode Facility Information Date CreatedCI-BCCI-BC2/2/2007 Facility Information Date CreatedDate Created Facility Information Date Created Facility Information Facility Information Date CreatedDate Created Facility Information Facility Information Facility Information Facility Information Facility Information Facility Information Load Information Open a second window with existing data Load Information Open a second window with existing data Load Information Load Information Assessment Tool Restore from tray at bottom of screen Assessment Tool Assessment Tool Assessment Tool Add Team Members Add Team Members Add Team Members Team Members Team Members Add Point of Contact Add Point of Contact Add Photos Add Photos Add Photos Add Photos Add Photos Add Photos Add GIS Images Add GIS Images Add GIS Images Add GIS Images Add GIS Images Add GIS Images * Same as photos and GIS images Add Miscellaneous Files Add Miscellaneous Files Threat Matrices CI-BC02/02/2007Functions Threat Rating1-10Asset Value1-10Vulnerability Rating1-10Low risk (1-60) Medium risk (61-175) High risk (> 175) ThreatsCritical Functions Matrix Threat Rating1-10 Asset Value1-10 Vulnerability Rating1-10 CI-BC02/02/2007Functions Low risk (1-60) Medium risk (61-175) High risk (> 175) ThreatsCritical Functions Matrix Threat Matrices Threat Rating1-10 Asset Value1-10 Vulnerability Rating1-10 Threats Critical Infrastructure Matrix Low risk (1-60) Medium risk (61-175) High risk (> 175) InfrastructureCI-BC02/02/2007 Threat Rating1-10 Asset Value1-10 Vulnerability Rating1-10 Threats Critical Infrastructure Matrix CI-BC02/02/2007Infrastructure Low risk (1-60) Medium risk (61-175) High risk (> 175) Checklists Site Checklist Site Checklist CI-BCCOOPCI-BCCOOP Site Checklist CI-BCCOOPCI-BC Site Checklist CI-BCCOOPCI-BC Checklists All launch similar checklists with places to enter observations and recommendations / remediatons Executive Summary Executive Summary Tab Vulnerabilities Vulnerabilities and Recommendations Vulnerabilities and Recommendations Vulnerabilities and Recommendations The assessment team members to combine their data into one database file on one computer at the end of the assessment. Assessment Team Import Function Lead AssessorAssessment Team Vuln/RecChecklistItem 3-2ChecklistSection 7•Establish a link to a team member’s database•Open the remote database•Import Observation, Recommendation/Remediation, or Vulnerability entries Import Assessments Import Assessments Import Assessments Import Assessments Import Assessments Import Assessments CI-BCCI-BC2/2/2007COOP FacilityC:\Temp\CI-BC\Assessment_2007-02-02 Import Assessments Assessment Team Import Function Assessment Team Import Function Assessment Team Import Function CI-BCCI-BC Close Assessment Tool Empty Database Switch to Master Database Switch to Master Database Switch to Master Database Master Database Mode View Checklists CI-BCCI-BC2/2/2007Assessment_2007-02-02\ View Checklists Reports CI-BCCI-BC2/2/2007Assessment_2007-02-02\ Reports Reports CI-BCCI-BCCI-BC Reports Reports Cooperville Information Co. (CI-BC) CI-BCCI-BCCI-BCCI-BC Reports Reports Threat Matrix Threat Matrix Other Reports Other Reports CI-BCCI-BC2/2/2007Assessment_2007-02-02\ Other Reports Other Reports Other Reports Other Reports CI-BCCI-BC2/2/2007Assessment_2007-02-02\ Master Database Vulnerability Assessment Checklist Search Vulnerability Assessment Checklist Search Hazardville Information CompanyFacility Tier 1 Vulnerability AssessmentChecklist Search Vulnerability Assessment Checklist Search Hazardville Information CompanyFacility Tier 1 Vulnerability Assessment Checklist Search Master Database Master Database Master Database Master Database: Erasing One or All Assessments Master Database: Erasing One or All Assessments Master Database: Import Function Master Database: Import Function Master Database: Import Function Master Database: Import Function Master Database: Import Function Master Database: Import Function Master Database: Import Function Master Database: Import Function Master Database: Import Function Master Database: Import Function Master Database: Import Function Master Database: Import Function Master Database: Manage User Accounts Master Database: Manage User Accounts Master Database: Manage User Accounts Master Database: Manage User Accounts Master Database: Manage User Accounts Summary Text Box: Installation, as appropriate, and opening of database Filing of GIS Portfolio, Miscellaneous, and Photos to link with the database and importing the database in the two operating modes Moving about the database software and between the Assessmen