10-20. EXCEL APPLICATION: Citywide Community College
The IT Department at Citywide Community College developed a computer security incident response plan that requires users to provide information for each security incident. The IT managers inventoried the major components of the college’s computer systems and created a spreadsheet to track the equipment by manufacturer, model number, and serial number. They decided to confine the list to major computer components, and they do not try to track keyboards, mice, and so forth. The managers then created a spreadsheet to track systems security incident facts including information about the department reporting the incident, target-specific information (host machine name, etc.), source-specific information (source IP address), and information about the type of security incident or attack. The IT managers asked you to use the data provided in the CCC Security spreadsheet, Ch10Ex01, to identify (1) the department reporting the highest number of security incidents and (2) the most prevalent type of intrusion. Use the “countif” function to count the number of security incidents in which the computer system was compromised. Use a memo format to submit a summary of your findings to the IT department.
10-21. ACCESS APPLICATION: Citywide Community College
Chris Hermann, IT manager at Citywide Community College, is working with two spreadsheets to manage computer security incident reporting. One spreadsheet tracks the major components of the college’s computer systems, and the other spreadsheet tracks security incident facts. To provide for better reporting capabilities, Chris wants you to set up an Access database that tracks college departments, computer systems, and security incidents. Download the spreadsheet Ch10Ex02 and import the worksheets to create the database shown in Figure 10.25. Create a report that lists the number of security incidents reported by each department. Create a second report that lists the number of attacks in which the system was compromised for the department having the greatest number of security incidents. What other reports would Chris find useful?
Figure 10.25 Citywide Community College security database.
