Instructions:

This is an exercise to practice some of the steps in creating a Loss Expectancy Chart. You should read ALL the instructions of this assignment before getting started.

Step 1: For each of the following "Frequency of Occurrence" rates, give the numerical number that would be used in a calculation for an annualized loss expectancy calculation. You are calculating the Annual Rate of Occurrence for each of the frequencies listed. Copy all 10 of the rates into your submission document and show the ARO next to them in that document. An incident that happens 1 time per week An incident that happens 1 time per month An incident that happens 1 time per year An incident that happens 1 time per decade An incident that happens 1 time per quarter An incident that happens 1 time every six months An incident that happens 1 time every 20 years An incident that happens 1 time every 15 years An incident that happens 1 time per century An incident that happens 1 time every 45 days.

Step 2: For each of the following threat and cost pairs, calculate the annualized loss expectancy for the threat on each of the 10 frequency numbers you created in step 1. You use a spreadsheet when creating the calculated numbers. Mistakes made by the Software Engineering Team, $2,000 per incident Electrical Spike that destroys equipment in the Networking Closet, $1,250 per incident An employee vandalizes the Research data forcing new data collection, $5,000 per incident Fire Destroys a outbuilding on the organization's main facility, $200 per incident Anonymous defaces the Organization's home page, $759 per incident At this point, there should be a 5 by 10 grid showing the 5 events by the 10 frequencies annualized loss expectancies.

Step 3: Analyze the data you just created and write up a paragraph style interpretation of the numbers. The questions you should answer in this analysis include: What happens as the frequency of occurrence goes beyond one time per year? What happens as the frequency of occurrence gets closes the happening every day? Mathematically, what type of relationship exists between the frequency of occurrence and the annualized loss expectancy? justify your position (yes, you may need to research math terms to determine the relationship)

Step 4: Now visualize the data. They say a picture is worth a thousand words. Create a graph for each of the 5 Incidents listed. That is 1 incident per graph. Graph the Annual Loss Expectancy on the Y (up and down) axis and the Frequency of Occurrence on the X axis (Left to Right). Put the Frequency that happens the most often on the left side and proceed out to the right with the frequencies getting smaller. You might need to rearrange your data if you did not read this step before making the spreadsheet. Your graphs should show some of the incidents as Line Graphs and others as Column Graphs for a good view on how different they may look. Do not use a Pie Charts, Bar Graphs, or any of the other options available. Those type of charts are not appropriate for this data set.

Step 5: Write up comments on what the visualization of the data shows you and compare it to the write up of the data you did in step 3. NOTES: You should do steps in order to experience the full learning opportunity of the assignment. Steps 2, and 4 should be in an Spreadsheet file. Microsoft Excel is the preferred choice. It does need to be able to be opened in Microsoft Excel for grading. No course header is needed on the spreadsheet file. Steps 1, 3 and 5 will be in a Word Submission document complete with the Course Header. Label each of the write-ups in the word document with the appropriate step number. Both files should be zipped into a single zip file for submitting to the dropbox.

The spelling and grammar are important in any written assignment and should be checked. When complete, upload the zip file to the dropbox