Note: Chapter 5 of the required textbook may be helpful in the completion of the assignment.
The audit planning process directly affects the quality of the outcome. A proper plan ensures that resources are focused on the right areas and that potential problems are identified early. A successful audit first outlines the objectives of the audit, the procedures that will be followed, and the required resources.
Choose an organization you are familiar with and develop an eight to ten (8-10) page IT infrastructure audit for compliance in which you:
Define the following items for an organization you are familiar with:
Scope
Goals and objectives
Frequency of the audit
Duration of the audit
Identify the critical requirements of the audit for your chosen organization and explain why you consider them to be critical requirements.
Choose privacy laws that apply to the organization, and suggest who is responsible for privacy within the organization.
Develop a plan for assessing IT security for your chosen organization by conducting the following:
Risk management
Threat analysis
Vulnerability analysis
Risk assessment analysis
Explain how to obtain information, documentation, and resources for the audit.
Analyze how each of the seven (7) domains aligns within your chosen organization.
Align the appropriate goals and objectives from the audit plan to each domain and provide a rationale for your alignment.
Develop a plan that:
Examines the existence of relevant and appropriate security policies and procedures.
Verifies the existence of controls supporting the policies.
Verifies the effective implementation and ongoing monitoring of the controls.
Identify the critical security control points that must be verified throughout the IT infrastructure, and develop a plan that includes adequate controls to meet high-level defined control objectives within this organization.
Use at least three (3) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources.
Your assignment must follow these formatting requirements:
Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
Include a cover page containing the title of the assignment, the student?s name, the professor?s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.
The specific course learning outcomes associated with this assignment are:
Describe the parameters required to conduct and report on IT infrastructure audit for organizational compliance.
Describe the components and basic requirements for creating an audit plan to support business and system considerations
Develop IT compliance audit plans
Use technology and information resources to research issues in security strategy and policy formation.
Write clearly and concisely about topics related to information technology audit and control using proper writing mechanics and technical style conventions.
Grading for this assignment will be based on answer quality, logic / organization of the paper, and language and writing skills, using the following rubric.
Points: 200
Term Paper: Planning an IT Infrastructure Audit for Compliance
Criteria
Unacceptable
Below 60% F
Meets Minimum Expectations
60-69% D
Fair
70-79% C
Proficient
80-89% B
Exemplary
90-100% A
1. Define the following items for an organization you are familiar with: a) Scope; b)Goals and objectives; c)Frequency of the audit; d) Duration of the audit.
Weight: 5%
Did not submit or incompletelydefined the following items for an organization you are familiar with: a) Scope; b) Goals and objectives; c) Frequency of the audit; d) Duration of the audit.
Insufficiently defined the following items for an organization you are familiar with: a) Scope; b) Goals and objectives; c) Frequency of the audit; d) Duration of the audit.
Partially defined the following items for an organization you are familiar with: a) Scope; b) Goals and objectives; c) Frequency of the audit; d) Duration of the audit.
Satisfactorily defined the following items for an organization you are familiar with: a) Scope; b) Goals and objectives; c) Frequency of the audit; d) Duration of the audit.
Thoroughly defined the following items for an organization you are familiar with: a) Scope; b) Goals and objectives; c) Frequency of the audit; d) Duration of the audit.
2. Identify the critical requirements of the audit for your chosen organization and explain why you consider them to be critical requirements.
Weight: 10%
Did not submit or incompletelyidentified the critical requirements of the audit for your chosen organization and did not submit or incompletelyexplained why you consider them to be critical requirements.
Insufficientlyidentified the critical requirements of the audit for your chosen organization and insufficientlyexplained why you consider them to be critical requirements.
Partiallyidentified the critical requirements of the audit for your chosen organization and partiallyexplained why you consider them to be critical requirements.
Satisfactorilyidentified the critical requirements of the audit for your chosen organization and satisfactorilyexplained why you consider them to be critical requirements.
Thoroughlyidentified the critical requirements of the audit for your chosen organization and thoroughly explained why you consider them to be critical requirements.
3. Choose privacy laws that apply to the organization, and suggest who is responsible for privacy within the organization.
Weight: 5%
Did not submit or incompletelychose privacy laws that apply to the organization, and did not submit or incompletelysuggested who is responsible for privacy within the organization.
Insufficiently chose privacy laws that apply to the organization, and insufficiently suggested who is responsible for privacy within the organization.
Partially chose privacy laws that apply to the organization, and partially suggested who is responsible for privacy within the organization.
Satisfactorily chose privacy laws that apply to the organization, and satisfactorily suggested who is responsible for privacy within the organization.
Thoroughly chose privacy laws that apply to the organization, and thoroughly suggested who is responsible for privacy within the organization.
4. Develop a plan for assessing IT security for your chosen organization by conducting the following: a) Risk management; b) Threat analysis; c) Vulnerability analysis; d) Risk assessment analysis.
Weight: 20%
Did not submit or incompletelydeveloped a plan for assessing IT security for your chosen organization by conducting the following: a) Risk management; b) Threat analysis; c) Vulnerability analysis; d) Risk assessment analysis.
Insufficientlydeveloped a plan for assessing IT security for your chosen organization by conducting the following: a) Risk management; b) Threat analysis; c) Vulnerability analysis; d) Risk assessment analysis.
Partiallydeveloped a plan for assessing IT security for your chosen organization by conducting the following: a) Risk management; b) Threat analysis; c) Vulnerability analysis; d) Risk assessment analysis.
Satisfactorilydeveloped a plan for assessing IT security for your chosen organization by conducting the following: a) Risk management; b) Threat analysis; c) Vulnerability analysis; d) Risk assessment analysis.
Thoroughlydeveloped a plan for assessing IT security for your chosen organization by conducting the following: a) Risk management; b) Threat analysis; c) Vulnerability analysis; d) Risk assessment analysis.
5. Explain how to obtain information, documentation, and resources for the audit.
Weight: 5%
Did not submit or incompletely explained how to obtain information, documentation, and resources for the audit.
Insufficiently explained how to obtain information, documentation, and resources for the audit.
Partially explained how to obtain information, documentation, and resources for the audit.
Satisfactorily explained how to obtain information, documentation, and resources for the audit.
Thoroughly explained how to obtain information, documentation, and resources for the audit.
6. Analyze how each of the seven (7) domains aligns within your chosen organization.
Weight: 5%
Did not submit or incompletelyanalyzed how each of the seven (7) domains aligns within your chosen organization.
Insufficientlyanalyzed how each of the seven (7) domains aligns within your chosen organization.
Partiallyanalyzed how each of the seven (7) domains aligns within your chosen organization.
Satisfactorilyanalyzed how each of the seven (7) domains aligns within your chosen organization.
Thoroughlyanalyzed how each of the seven (7) domains aligns within your chosen organization.
7. Align the appropriate goals and objectives from the audit plan to each domain and provide a rationale for your alignment.
Weight: 5%
Did not submit or incompletelyaligned the appropriate goals and objectives from the audit plan to each domain and did not submit or incompletelyprovided a rationale for your alignment.
Insufficiently aligned the appropriate goals and objectives from the audit plan to each domain and insufficiently provided a rationale for your alignment.
Partially aligned the appropriate goals and objectives from the audit plan to each domain and partially provided a rationale for your alignment.
Satisfactorily aligned the appropriate goals and objectives from the audit plan to each domain and satisfactorily provided a rationale for your alignment.
Thoroughly aligned the appropriate goals and objectives from the audit plan to each domain and thoroughly provided a rationale for your alignment.
8. Develop a plan that: a) Examines the existence of relevant and appropriate security policies and procedures; b) Verifies the existence of controls supporting the policies; c) Verifies the effective implementation and ongoing monitoring of the controls.
Weight: 20%
Did not submit or incompletelydeveloped a plan that: a) Examined the existence of relevant and appropriate security policies and procedures; b) Verified the existence of controls supporting the policies; c) Verified the effective implementation and ongoing monitoring of the controls.
Insufficiently developed a plan that: a) Examined the existence of relevant and appropriate security policies and procedures; b) Verified the existence of controls supporting the policies; c) Verified the effective implementation and ongoing monitoring of the controls.
Partially developed a plan that: a) Examined the existence of relevant and appropriate security policies and procedures; b) Verified the existence of controls supporting the policies; c) Verified the effective implementation and ongoing monitoring of the controls.
Satisfactorily developed a plan that: a) Examined the existence of relevant and appropriate security policies and procedures; b) Verified the existence of controls supporting the policies; c) Verified the effective implementation and ongoing monitoring of the controls.
Thoroughly developed a plan that: a) Examined the existence of relevant and appropriate security policies and procedures; b) Verified the existence of controls supporting the policies; c) Verified the effective implementation and ongoing monitoring of the controls.
9. Identify the critical security control points that must be verified throughout the IT infrastructure, and develop a plan that includes adequate controls to meet high-level defined control objectives within this organization.
Weight: 15%
Did not submit or incompletely identified the critical security control points that must be verified throughout the IT infrastructure, and did not submit or incompletely developed a plan that includes adequate controls to meet high-level defined control objectives within this organization.
Insufficiently identified the critical security control points that must be verified throughout the IT infrastructure, and insufficiently developed a plan that includes adequate controls to meet high-level defined control objectives within this organization.
Partially identified the critical security control points that must be verified throughout the IT infrastructure, and partially developed a plan that includes adequate controls to meet high-level defined control objectives within this organization.
Satisfactorily identified the critical security control points that must be verified throughout the IT infrastructure, and satisfactorily developed a plan that includes adequate controls to meet high-level defined control objectives within this organization.
Thoroughly identified the critical security control points that must be verified throughout the IT infrastructure, and thoroughly developed a plan that includes adequate controls to meet high-level defined control objectives within this organization.
10. 3 references
Weight: 5%
No references provided
Does not meet the required number of references; all references poor quality choices.
Does not meet the required number of references; some references poor quality choices.
Meets number of required references; all references high quality choices.
Exceeds number of required references; all references high quality choices.
11. Clarity, writing mechanics, and formatting requirements
Weight: 5%
More than 8 errors present
7-8 errors present
5-6 errors present
3-4 errors present
Previous answers to this question
This is a preview of an assignment submitted on our website by a student. If you need help with this question or any assignment help, click on the order button below and get started. We guarantee authentic, quality, 100% plagiarism free work or your money back.
Get The Answer TA2: Preparation assignment for Decision Support
Note: Chapter 5 of the required textbook may be helpful in the completion of the assignment.
The audit planning process directly affects the quality of the outcome. A proper plan ensures that resources are focused on the right areas and that potential problems are identified early. A successful audit first outlines the objectives of the audit, the procedures that will be followed, and the required resources.
Choose an organization you are familiar with and develop an eight to ten (8-10) page IT infrastructure audit for compliance in which you:
Define the following items for an organization you are familiar with:
Scope
Goals and objectives
Frequency of the audit
Duration of the audit
Identify the critical requirements of the audit for your chosen organization and explain why you consider them to be critical requirements.
Choose privacy laws that apply to the organization, and suggest who is responsible for privacy within the organization.
Develop a plan for assessing IT security for your chosen organization by conducting the following:
Risk management
Threat analysis
Vulnerability analysis
Risk assessment analysis
Explain how to obtain information, documentation, and resources for the audit.
Analyze how each of the seven (7) domains aligns within your chosen organization.
Align the appropriate goals and objectives from the audit plan to each domain and provide a rationale for your alignment.
Develop a plan that:
Examines the existence of relevant and appropriate security policies and procedures.
Verifies the existence of controls supporting the policies.
Verifies the effective implementation and ongoing monitoring of the controls.
Identify the critical security control points that must be verified throughout the IT infrastructure, and develop a plan that includes adequate controls to meet high-level defined control objectives within this organization.
Use at least three (3) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources.
Your assignment must follow these formatting requirements:
Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
Include a cover page containing the title of the assignment, the student?s name, the professor?s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.
The specific course learning outcomes associated with this assignment are:
Describe the parameters required to conduct and report on IT infrastructure audit for organizational compliance.
Describe the components and basic requirements for creating an audit plan to support business and system considerations
Develop IT compliance audit plans
Use technology and information resources to research issues in security strategy and policy formation.
Write clearly and concisely about topics related to information technology audit and control using proper writing mechanics and technical style conventions.
Grading for this assignment will be based on answer quality, logic / organization of the paper, and language and writing skills, using the following rubric.
Points: 200
Term Paper: Planning an IT Infrastructure Audit for Compliance
Criteria
Unacceptable
Below 60% F
Meets Minimum Expectations
60-69% D
Fair
70-79% C
Proficient
80-89% B
Exemplary
90-100% A
1. Define the following items for an organization you are familiar with: a) Scope; b)Goals and objectives; c)Frequency of the audit; d) Duration of the audit.
Weight: 5%
Did not submit or incompletelydefined the following items for an organization you are familiar with: a) Scope; b) Goals and objectives; c) Frequency of the audit; d) Duration of the audit.
Insufficiently defined the following items for an organization you are familiar with: a) Scope; b) Goals and objectives; c) Frequency of the audit; d) Duration of the audit.
Partially defined the following items for an organization you are familiar with: a) Scope; b) Goals and objectives; c) Frequency of the audit; d) Duration of the audit.
Satisfactorily defined the following items for an organization you are familiar with: a) Scope; b) Goals and objectives; c) Frequency of the audit; d) Duration of the audit.
Thoroughly defined the following items for an organization you are familiar with: a) Scope; b) Goals and objectives; c) Frequency of the audit; d) Duration of the audit.
2. Identify the critical requirements of the audit for your chosen organization and explain why you consider them to be critical requirements.
Weight: 10%
Did not submit or incompletelyidentified the critical requirements of the audit for your chosen organization and did not submit or incompletelyexplained why you consider them to be critical requirements.
Insufficientlyidentified the critical requirements of the audit for your chosen organization and insufficientlyexplained why you consider them to be critical requirements.
Partiallyidentified the critical requirements of the audit for your chosen organization and partiallyexplained why you consider them to be critical requirements.
Satisfactorilyidentified the critical requirements of the audit for your chosen organization and satisfactorilyexplained why you consider them to be critical requirements.
Thoroughlyidentified the critical requirements of the audit for your chosen organization and thoroughly explained why you consider them to be critical requirements.
3. Choose privacy laws that apply to the organization, and suggest who is responsible for privacy within the organization.
Weight: 5%
Did not submit or incompletelychose privacy laws that apply to the organization, and did not submit or incompletelysuggested who is responsible for privacy within the organization.
Insufficiently chose privacy laws that apply to the organization, and insufficiently suggested who is responsible for privacy within the organization.
Partially chose privacy laws that apply to the organization, and partially suggested who is responsible for privacy within the organization.
Satisfactorily chose privacy laws that apply to the organization, and satisfactorily suggested who is responsible for privacy within the organization.
Thoroughly chose privacy laws that apply to the organization, and thoroughly suggested who is responsible for privacy within the organization.
4. Develop a plan for assessing IT security for your chosen organization by conducting the following: a) Risk management; b) Threat analysis; c) Vulnerability analysis; d) Risk assessment analysis.
Weight: 20%
Did not submit or incompletelydeveloped a plan for assessing IT security for your chosen organization by conducting the following: a) Risk management; b) Threat analysis; c) Vulnerability analysis; d) Risk assessment analysis.
Insufficientlydeveloped a plan for assessing IT security for your chosen organization by conducting the following: a) Risk management; b) Threat analysis; c) Vulnerability analysis; d) Risk assessment analysis.
Partiallydeveloped a plan for assessing IT security for your chosen organization by conducting the following: a) Risk management; b) Threat analysis; c) Vulnerability analysis; d) Risk assessment analysis.
Satisfactorilydeveloped a plan for assessing IT security for your chosen organization by conducting the following: a) Risk management; b) Threat analysis; c) Vulnerability analysis; d) Risk assessment analysis.
Thoroughlydeveloped a plan for assessing IT security for your chosen organization by conducting the following: a) Risk management; b) Threat analysis; c) Vulnerability analysis; d) Risk assessment analysis.
5. Explain how to obtain information, documentation, and resources for the audit.
Weight: 5%
Did not submit or incompletely explained how to obtain information, documentation, and resources for the audit.
Insufficiently explained how to obtain information, documentation, and resources for the audit.
Partially explained how to obtain information, documentation, and resources for the audit.
Satisfactorily explained how to obtain information, documentation, and resources for the audit.
Thoroughly explained how to obtain information, documentation, and resources for the audit.
6. Analyze how each of the seven (7) domains aligns within your chosen organization.
Weight: 5%
Did not submit or incompletelyanalyzed how each of the seven (7) domains aligns within your chosen organization.
Insufficientlyanalyzed how each of the seven (7) domains aligns within your chosen organization.
Partiallyanalyzed how each of the seven (7) domains aligns within your chosen organization.
Satisfactorilyanalyzed how each of the seven (7) domains aligns within your chosen organization.
Thoroughlyanalyzed how each of the seven (7) domains aligns within your chosen organization.
7. Align the appropriate goals and objectives from the audit plan to each domain and provide a rationale for your alignment.
Weight: 5%
Did not submit or incompletelyaligned the appropriate goals and objectives from the audit plan to each domain and did not submit or incompletelyprovided a rationale for your alignment.
Insufficiently aligned the appropriate goals and objectives from the audit plan to each domain and insufficiently provided a rationale for your alignment.
Partially aligned the appropriate goals and objectives from the audit plan to each domain and partially provided a rationale for your alignment.
Satisfactorily aligned the appropriate goals and objectives from the audit plan to each domain and satisfactorily provided a rationale for your alignment.
Thoroughly aligned the appropriate goals and objectives from the audit plan to each domain and thoroughly provided a rationale for your alignment.
8. Develop a plan that: a) Examines the existence of relevant and appropriate security policies and procedures; b) Verifies the existence of controls supporting the policies; c) Verifies the effective implementation and ongoing monitoring of the controls.
Weight: 20%
Did not submit or incompletelydeveloped a plan that: a) Examined the existence of relevant and appropriate security policies and procedures; b) Verified the existence of controls supporting the policies; c) Verified the effective implementation and ongoing monitoring of the controls.
Insufficiently developed a plan that: a) Examined the existence of relevant and appropriate security policies and procedures; b) Verified the existence of controls supporting the policies; c) Verified the effective implementation and ongoing monitoring of the controls.
Partially developed a plan that: a) Examined the existence of relevant and appropriate security policies and procedures; b) Verified the existence of controls supporting the policies; c) Verified the effective implementation and ongoing monitoring of the controls.
Satisfactorily developed a plan that: a) Examined the existence of relevant and appropriate security policies and procedures; b) Verified the existence of controls supporting the policies; c) Verified the effective implementation and ongoing monitoring of the controls.
Thoroughly developed a plan that: a) Examined the existence of relevant and appropriate security policies and procedures; b) Verified the existence of controls supporting the policies; c) Verified the effective implementation and ongoing monitoring of the controls.
9. Identify the critical security control points that must be verified throughout the IT infrastructure, and develop a plan that includes adequate controls to meet high-level defined control objectives within this organization.
Weight: 15%
Did not submit or incompletely identified the critical security control points that must be verified throughout the IT infrastructure, and did not submit or incompletely developed a plan that includes adequate controls to meet high-level defined control objectives within this organization.
Insufficiently identified the critical security control points that must be verified throughout the IT infrastructure, and insufficiently developed a plan that includes adequate controls to meet high-level defined control objectives within this organization.
Partially identified the critical security control points that must be verified throughout the IT infrastructure, and partially developed a plan that includes adequate controls to meet high-level defined control objectives within this organization.
Satisfactorily identified the critical security control points that must be verified throughout the IT infrastructure, and satisfactorily developed a plan that includes adequate controls to meet high-level defined control objectives within this organization.
Thoroughly identified the critical security control points that must be verified throughout the IT infrastructure, and thoroughly developed a plan that includes adequate controls to meet high-level defined control objectives within this organization.
10. 3 references
Weight: 5%
No references provided
Does not meet the required number of references; all references poor quality choices.
Does not meet the required number of references; some references poor quality choices.
Meets number of required references; all references high quality choices.
Exceeds number of required references; all references high quality choices.
11. Clarity, writing mechanics, and formatting requirements
Weight: 5%
More than 8 errors present
7-8 errors present
5-6 errors present
3-4 errors present
Previous answers to this question
This is a preview of an assignment submitted on our website by a student. If you need help with this question or any assignment help, click on the order button below and get started. We guarantee authentic, quality, 100% plagiarism free work or your money back.
Get The Answer Leave a Reply
TA2: Preparation assignment for Decision Support
TA2: Preparation assignment for Decision Support
The goal of this assignment is to prepare you for completing the next tutorial assignment (#3) on pivot tables and decision support as assigned by your instructor.
This assignment itself is fairly easy. You are essentially going to do Exercise #3 (“Filtering SecureIT data”) on pages 14 & 15 of Plug-in module T3 (“Problem Solving
Using Excel 2013”) – HOWEVER you will complete this with some required enhancements to the assignment, as specified below.
You will complete this exercise with several adjustments:
As you do parts 1 through 5, you will label each worksheet as per the specifications listed below
Two additional parts on Pivot tables have been added as an additional challenge, also to be listed in labeled worksheets
Before submission, you will arrange the worksheets in a specific sequence that has been listed below.
In completing this problem, you will need to know to reorder and rename worksheets within your spreadsheet file and how to insert and delete new worksheets. If you
feel unskilled or rusty with these skills in MS Excel, we suggest that you review Plug-in T2 and/or your course materials for MIS 100 (or just look this up online or
in the University library resource of Lynda.com).
Obviously, you should read through this Plug-in T3 carefully PRIOR TO attempting this assignment and you should work through the examples provided. To assist you in
working through the examples in the Plug-in modules, here is a link to download T3_ProblemSolving_Data, the spreadsheet file that provides the examples used for
illustration on this module.
When you are done, you will submit the spreadsheet file (containing the appropriately labeled and ordered worksheets) by uploading it to the appropriate dropbox.
Instructions:
Open up the T3_Employee_Data spreadsheet file that I have posted here. Save this spreadsheet on your computer under the following name: firstname_lastname_TA2 (where
firstname is your first name & lastname is your last name).
Turn to problem #3 (“Filtering SecureIT data”) on pages 14 & 15 of plug-in module T3.
First do part 1. Do this by copying the data from the source worksheet (“employee data”) into a new worksheet that you will label “Sort”. Perform the required data
sorting operation on the list as specified in part 1 of this exercise (i.e. sorted by last name and hire date). After you have done this, rename the worksheet “Sort”.
Next do part 2. Do this by copying the data from the source worksheet (“employee data”) into a new worksheet that you will label “custom sort”. Perform the required
data sorting operation on the list as specified in part 2 of this exercise (i.e. using the custom list sorting parameter of Marketing, Human Resources, Management, and
Engineering). After you have done this, rename the worksheet “Custom Sort”.
Next do part 3. Do this by copying the data from the source worksheet (“employee data”) into a new worksheet that you will label “filter”. Perform the required
filtering operation on the list as specified in part 3 of this exercise (i.e. using a filter to display only those employees in the Engineering department with a
clearance of Top Secret). After you have done this, rename the worksheet “Filter”.
Next do part 4. Do this by copying the data from the source worksheet (“employee data”) into a new worksheet that you will label “custom filter”. Perform the required
filtering operation on the list as specified in part 3 of this exercise (i.e. using a custom display only those employees born between 1960 & 1969, inclusive [HINT:
Think of >= and <=], as well as when the dates when a year begins & ends] ). After you have done this, rename the worksheet “Custom Filter”.
Next do part 5. You will create a pivot table which totals salaries by department. When creating this Pivot table, choose the option to insert the pivot table into
into a new worksheet. After you have created an appropriate pivot table, name the worksheet “SumSalary”.
PART 6 (ASSIGNMENT ADDITION #1): Create a Pivot table that tabulates the number of employees by department & gender. Name the worksheet for this “Employees by
DeptGender”. HINT: What data element do you need to COUNT in order to generate this pivot table? It would obviously have to be a data element whose value was
different (unique, like a database table key) for every row in the table in order to insure an appropriate tabulation of employees by department). After you have
created this pivot table, name the worksheet “Employees by DeptGender”.
PART 7 (ASSIGNMENT ADDITION #2): Finally, go back to the worksheet named “Employees by DeptGender”. Find the cell that displays the number of female employees in the
management department. Click on this to reveal the audit trail of raw data (employee records) that was used in calculating this tally. Use conditional formatting to
display in red (or brown) the hire dates of those female employees in management who were hired after 1/1/1993. Rename the worksheet upon which this audit trail has
appeared “Data: Fs in Mgmt”.
Finally, you must re-order your worksheets in the following sequence and titles (and eliminate any extra work sheets that are not needed!):
Employee Data (i.e. the raw data you started with)
Sort
Custom Sort
Filter
Custom Filter
SumSalary
Employees by DeptGender
Data: Fs in Mgmt
Save your work (probably a good idea after completing each step)!
Previous answers to this question
This is a preview of an assignment submitted on our website by a student. If you need help with this question or any assignment help, click on the order button below and get started. We guarantee authentic, quality, 100% plagiarism free work or your money back.
Get The Answer