Skip to main content

Security Analysis | Excel Exercise | Download Now

A Technology Budget

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 work by submitting detailed bids outlining the work the company will perform if awarded the contracts. Because all of the work involved 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% 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 is SecureWorks’ human resources (HR) manager. She maintains all employee records and is responsible for semiannual review reports, payroll processing, personal, 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 abscense/sick leave record keeping. Although most of theis information resides in sophisticated database systems, Leslie maintains a basic 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:

Instructions

  1. Open Chapter4SecurityAnalysis.xlsx.
  2. Save the spreadsheet as Chapter4SecurityAnalysis.xlsx_Last Name.xlsx. (Replace “Last Name” with your last name.)
  3. Create a new worksheet tab and name it Sort.
  4. Copy the table from the Security Analysis sheet into Sort. 
  5. Use Excel’s Sorting functions (Sort & Filter  Custom Filter) to sort the employee list in ascending order by department, then by last name, then by first name. (Each of these will be a new level in the custom sort.)
  6. Create a new worksheet tab and name it Auto Filter.
  7. Copy the table from the Security Analysis sheet into Auto Filter. 
  8. Using Excel’s AutoFilter feature, create a custom auto filter that will display all employees whose birth data is greater than or equal to 1/1/1965 and less than or equal to 12/31/1975.
  9. Create a new worksheet tab and name it Subtotal.
  10. Copy the table from the Sort sheet into Subtotal. 
  11. Using the subtotal feature, create a sum of the salary for each department. You know you are correct if you end up with 1 subtotal per department.
  12. Create a new worksheet tab and name it Formatting.
  13. Copy the table from the Security Analysis sheet into Formatting. 
  14. Using the Salary Column, change the font color to red if the cell value is greater than or equal to 55000. You must use the conditional formatting feature to complete this step. If you do not, it will be considered cheating. Cheaters get 0s. 
  15. Save and submit the file to your instructor.

Product Images

Download Now

Buy now

Comments

Popular posts from this blog

The Zoo Management System - entity relationship diagram & MS Access Database

Zoo Management System - Project Details: You are the employee of a big, worldwide working Zoo Management Company. Your company is responsible for the Zoo management. Your boss thinks it would be a great idea to store all data for each Zoo in a brand new self-developed ZOO Management System. Up to now, the ZOO management company has maps of each ZOO available. Your boss knows that you took a course in introduction on an ERP system, so he asks you if you could help designing such a system. Each ZOO must have the same organizational structure, which should look like this: Each Zoo has a Zoo-Address. Each Zoo has many visitors (Visitor Ticket Process (VTP). Many Zoo-Attractions belong to a Zoo. Module 1: Entity Relationship Diagram Design a ER (entity-relationship) diagram for your ZOO Management System. Use the information provided below with the entities and its attributes. Put the entities in the correct relationship to each other (organizational structure). Module 2: DB Implem...

EIT Knowledge and Innovative Community Scholarships has been announced

Admission Criteria To qualify for our programmes, applicants need to fulfill the admission requirements based on previous studies, English proficiency and relevant documentation. Previous Studies: A Completed Bachelor’s Degree In order to be admitted into a KIC InnoEnergy MSc programme, you must have completed a Bachelor’s degree encompassing a minimum of 180 ECTS credits or equivalent academic qualifications from an internationally recognized university. Please note that admissions depend on the specific BSc degree you hold for entry into the MSc programme you are interested in. Conditional Acceptance – Undergraduate Students in Final Year Students in their final year of undergraduate education may also apply and if expected to qualify, receive a conditional offer. If you have not completed your studies, please include a written statement from your university’s administration office (or equivalent department), confirming that you are enrolled in the final year of your study programme ...

Human Physiology by Stuart Ira Fox [PDF] (12th edition) free download