Module 04 Content
- As part of XYZ’s normal auditing processes, the process of validating the employees of XYZ is very important. One element that is important is to find a particular group or organizational unit where all employees can be found. In this case, all the employees are granted access to XYZ’s VPN network. Therefore, this becomes the most consistent location of users, and accomplishes a secondary audit.
You will be provided an Active Directory Users and computers query based on the distinguished name of the VPN user group. You will also be provided an employee census report from HR detailing the existing and terminated employees. Taking this information, you will combine the two data pieces to determine variants. You will then need to complete an audit checklist provided as well. If an element within the checklist has no information to include, the proper response in these cases is to note, “no exceptions found”.
Use the following documents to complete this part of your project:
- Employee Census
- Employee Census.xlsx
- Audit Checklist
- Audit Checklist.docxBe sure to look at all the tabs on the Employee Census document and use VLOOKUP to perform your analysis. After you complete your audit on the census, complete the Audit Checklist. Finally, submit both your updated Employee Census and Audit Checklist.
Submit your completed assignments by following the directions linked below. Please check the Course Calendar for specific due dates.
Save your assignments as a Microsoft Word and Mircrosoft Excel document. (Mac users, please remember to append the “.docx” and “xlsx” to the filename.) The name of the file should be your first initial and last name, followed by an underscore and the name of the assignment, and an underscore and the date. An example is shown below: