Instructions:

Part 1: The job advertisement is now closed and below are two tables. Please consolidate the data from both tables to one table with the subject headers sorted alphabetically in order of: 1) Last name; 2) First Name; 3) ID; 4) Title 5) Ethnic Data; sort them in the order of the subject titles are arranged and identify any errors or missing information. Once completed, please save your Excel spreadsheet

Part 2: The hiring manager would like to know if there is a diverse pool of candidate in comparison to the King County population. Please write a short summary of your analysis based on the data provided in comparison to the King County population.

Name	ID	Ethnic Data
Amy Lee	123943	White
Jennifer Kirk	123794	White
Casey Williams	123645	White
Brock Brown	123496	White
Pamela James	123347	White
Katie Jenkins	123198	Black
Tara Cole	123497	White
Linda Nguyen	123498	Asian
Maureen Anderson	123499	White
Lily Sharpe	123500	White
Casey Wilson	123501	Hispanic
Daniel Hernandez	165782	Hispanic
Ray Walker	146875	Black
Kristi Collins	259860	White
Ariana Gonzalez	259861	Hispanic
Michael Smith	259862	White
Jane Dean	259863	White
David Henderson	259864	White
Mia Pham	259865	Asian
Carey Wang	259866	Asian
Patty Cooks	259867	White
Melanie Fong	111222	Asian
Corey Brown	254872	White

Name	Title
Kristi Collins	Actng Tech III
Michael Smith	Admin Spec I
Maureen Anderson	Admin Support Asst
Casey Wilson	Admin Support Asst
Jennifer Kirk	Counselor
Casey Williams	Counselor
Brock Brown	Counselor
Linda Nguyen	Counselor
Pamela James	G&C Spec, Sr
Ray Walker	G&C Spec, Sr
Jane Dean	G&C Spec, Sr
Daniel Hernandez	G&C Spec, Sr
Katie Jenkins	HS Coordinator
Amy Lee	HS Prgm Supv, Sr
Tara Cole	Program Intake Rep
Lily Sharpe	Public Relations Specialist
David Henderson	RN Consultant
Ariana Gonzalez	Strat Advsr I