AEP Tips 2 (including MD 715)

1. AEP Tips 2 (including MD 715) Mike Gautier How To Series

2. Reduce The Jumble Of Numbers This was done away with 20 years ago in MD 714 White women are severely under represented in professional and administrative categories as well in grades 9-15 when compared with their overall representation in the NCLF. Exactly where is the UR, you can’t create Action items for any one area if the range is too broad How To Series

3. Reduce The Jumble Of Numbers For FY 2002 the population decreased from 1,989 in FY 2001 to 2,005 in FY 2002, a net loss of 16. Of those, men totaled 1,450 (72.3%) and women 555 (27.7%). Minorities increased by 14 in FY 2002 for a total of 412 or 20.5 percent of the workforce, with 270 men (13.5%) and 142 women (7.1%). Once again women fell below the CLF of 45.7 percent, as well as losing 3 positions in FY 2002. TOO WORDY AND HARD TO UNDERSTAND AND TAKES TOO MUCH EFFORT EASIER TO READ How To Series

4. ADARAND Extract  ”For example, if an agency or office sought to determine whether it had an under representation of African-American engineers, it would not compare the percentage of African-American engineers that it employed with the percentage of African-Americans in the civilian labor force generally, or with the percentage of African-Americans in a "professionals" category of which engineers may be only a part. Since engineers posses unique qualifications not shared by the population or professionals at large, the comparison should be between the percentage of African-American engineers employed by the agency or office and the percentage of African-American engineers in the civilian labor force. “ DOJ How To Series

5. Data That Makes Sense How To Series

6. COMPARISON OF WORKFORCE TO CLF BY GRADEWhite Men How To Series

7. MD 715 Data • Keep the presentation simple • Reduce the technical and increase the readability • Focus on the model program • The data tables are there to support conclusions – they are not the reason for the report • Most of the data doctrine is unchanged from the past 30 years • This is not a historical report • You don’t have to add every moment in the organization’s history • Special emphasis supports EEO, not the social calendar How To Series

8. MD 715 Data • The 462 narrative • Is there a connection between issues and data • If the issues are management directed reassignment there should be corresponding data in DCPDS that shows that they happened • If the data is there, it can be aggregated by RNO, gender and disability • How does the organization address issues strategically not how many pieces of paper you processed • How much money is spent of cases • How much time does it take to close cases • What does the agency do to resolve cases • What are the metrics How To Series

9. MD 715 Data • Data goes left to right and up and down • Left to right shows populations within a line item • Within GS 15’s what is the population • With a pay band what is the distribution of the population • Up and down shows population distributions of the group • Where are white men most populated by grade How To Series

10. Doing the Data tables • The data tables are an appendix not the report • Validates action items in form I (“Table B3 shows…..”) • Use tables in the Executive Summary (form E) to summarize the data tables • Don’t use the Executive Summary to describe the rewrite the data (don’t “the percentage increase was 12.5% for WM, 7% for WF, 9.2% for BM …..”) • Use references to the data tables (“Table A-2 shows the serviced population, the largest of which is MEDCOM”) How To Series

11. Participation Rates Summed Across (Most GS 13 Employees are White Men) How To Series

12. Participation Rates Summed Down (Most White Men are GS 12 and 13) How To Series

13. The 462 and MD 715 • EEO is one program with three main parts • MD 715 (AEP) • Complaints Process Management • Program Evaluation • EEO is not complaints processing with a casual interest in MD 715 • EEO is not doing stats all day and glancing at complaint issues every now and then How To Series

14. The 462 and MD 715 • Look at the 462 and identify key areas • Issues and basis • Resolution • Timeliness • Resources • The task is to “cross walk” the 462 and the database to determine a nexus of elements How To Series

15. The 462 and MD 715 • Look at part IV • Use the issues raised and see if there is a corresponding statistical aspect • If there are a lot of promotion issues – check the promotion rosters to see if there is an increasing trend • If there are issues about evaluations, see if there is a corresponding aspect in the profiles of evaluations How To Series

16. The 462 and MD 715 • Look at MD 715 - efficiency • What is the median processing time for formals • How much was paid in settlements • Did the counselors get the training required • What is the percentage of employees filing complaints (use distinct count) How To Series

17. EEO Profile Total Distribution of EEO ComplainantsAll Career Programs How To Series

18. The 462 and MD 715 • Look at MD 715 - efficiency • What is the demographic profile of complainants • Are complaints coming from a few organizations and if so… is that significant (it may not be) How To Series

19. Data Tables Techno Speak • Don’t get twisted over 5 CFR definitions • Understand the underlying question being asked • Keep data filters simple • Remember – EEO covers all US employees regardless of what 5 CFR says about their status How To Series

20. Data Tables tenants • If you want to see all the organizations locally, the query should have the fields cmd and cmd desc, CCPO-ID and CCPO-ID DESC • The condition will be CCPO-ID = • This will pull all organizations in that CCPO-ID How To Series

21. The pivot table gives you the tenant listing How To Series