Citywide Community College

Solutions to Application Exercises
10-20. Excel Application: Citywide Community College

Louis has 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 Louis.

Students will use the mode function to determine the department reporting the highest number of security incidents and the most prevalent type of intrusion and the
“countif” function to count the number of security incidents in which the computer system was compromised.

? The Campus Bookstore had the highest number of security incidents.
? The most prevalent type of intrusion was an unauthorized connection.
? There were 19 security incidents in which the computer system was compromised.

10-21. Access Application: Citywide Community College

Download the spreadsheet Ch10Ex02 and import the worksheets to create the database shown in Figure 10-23. 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 Louis find useful?

Students should produce an Access database with three tables by importing data from the Excel file named Ch10Ex02. Reports on incidents by department and compromises
by department would appear approximately as below.

find the cost of your paper