SecureWorks, Inc. is a small computer security contractor that provides computer security

analysis, design, and software implementation for the U$.$S$.$ government and commercial

clients. SecureWorks competes for both private and U$.$S$.$ government computer security

contract work by submitting detailed bids outlining the work the company will perform if

awarded the contracts. Because all of the work involves computer security, a highly sensitive

area, almost all of SecureWorks tasks require access to classified material or company

confidential documents. Consequently, all of the security engineers $($simply known as

$$engineers$$ within the company$)$ have U$.$S$.$ government clearances of either secret or top

secret. Some have even higher clearances for the $2$ percent of SecureWorks work that

involves so$-$called black$-$box security work. Most of the employees also hold clearances

because they must handle classified documents.

Leslie Mamalis is SecureWorks$$s human resources $($HR$)$ manager. She maintains all

employee records and is responsible for semiannual review reports, payroll processing,

personnel records, recruiting data, employee training, and pension option information. At the

heart of an HR system are personnel records. Personnel record maintenance includes

activities such as maintaining employee records, tracking cost center data, recording and

maintaining pension information, and absence and sick leave record keeping. Although most

of this information resides in sophisticated database systems, Leslie maintains a basic

MBIS$4001$ Information Systems Applications in Business @ Australian Institute of Higher Education, Sydney

employee worksheet for quick calculations and ad hoc report generation. Because

SecureWorks is a small company, Leslie can take advantage of Excel$$s excellent list

management capabilities to satisfy many of her personnel information management needs.

Leslie has asked you to assist with a number of functions $($she has provided you with a copy

of her trusted personnel data file$)$: