Case Study Analysis: Recruitment and Hiring PracticesThis case study analysis assesses the following outcomes:MT203-2: Examine the recruitment and selection process.PC-4.3: Apply concepts of multiculturalism and diversity to become an agent of change.You have read about recruiting and selection processes used in various companies as well as practiced with some of those concepts. Now you will apply your understanding of these concepts to a case scenario and then address the checklist items.To assist you with this and other case studies in this class, a document entitled “Case Study Analysis,” is in Course Documents and can be downloaded for your reference. This document, and many other invaluable writing resources, can also be found at the Writing Center.Case Scenario:A Silicon Valley recruiting firm recruits artificial intelligence (AI) and technology personnel. The recruits workplace could be located anywhere the company operates, depending on their skills and expertise, although the tendency is to hire in-country nationals in each respective country. The company uses technology-oriented magazines, the company website, and social media to recruit the candidates they need for their clients. They started up about a year ago and went from 3 recruiters to 50 overnight. Their recruiters are hired for their charm, communication skills, and industry expertise, however most of the recruiters graduated from Ivy League colleges in the U.S. and most are white males. Lately recruiting numbers have been slowing down drastically while general demand in the marketplace by employers for AI and technology personnel for the coming year is up 300%.The current recruiting practice involves hiring people via their website recruitment area. The potential candidate merely attaches their resume and includes a short note to the recruiter. These resumes are then screened using a data mining program looking for certain criteria and terminology in their resumes. Once screened, those candidates getting through the initial screening are then auto-contacted by email to tell them they need to complete the question/quiz accessed on the website using a particular password. If they pass this second screening they are given an individual interview via the company’s online conference room. Once completed, the final candidates are finally sent to the potential employer for the final interview and selection.Now however, the president is getting complaints from the EEO Commission and the Technology firms that they need to be hiring a more diverse workforce and that there are no ADA candidates, and the number of minorities and women is almost nil. He is now worried about losing clients and potential lawsuits as a result of their recruiting and selection processes. The company needs to address a diverse client base. Their clients are Northern European, African American, Indian, and Hispanic.Checklist: As the HR specialist of the company, you are tasked with overhauling the selection and hiring process to address the following:Identify problems with the potential candidate characteristics.Analyze the company’s recruitment and selection process and problems.What multicultural and diversity planning concepts would you apply at the company to make a positive change?Describe how you would make that positive change happen.Requirements:Complete a 2–3 page paper (not including the title and reference pages).Answer each checklist question thoroughly.Demonstrate your understanding of the information presented in the weekly reading assignments by defining terms, explaining concepts, and providing detailed examples to illustrate your points.Include at least two references from your reading assignments, or other academic sources, to reinforce and support your own thoughts, ideas, and statements using APA citation style. You can access help with APA by going to Course Resources and accessing the “APA Style Central” resources in Academic Tools.

For this question, review the Virgin America short case study at the end of Chapter 5. Prior to 2016, Virgin America was consistently rated as one of the top U.S. airlines. It served 20 destinations out of its main hub in San Francisco. Known for its leather seats, cocktail-lounge-style lighting, on board Wi-Fi, in-seat power outlets for electronics devices, full-service meals, and spacious legroom, the key competitive issue the company has been facing is that it is a niche player in a much larger industry where low-cost carriers such as Southwest Airlines and Jet Blue are putting constant pressure on prices and crowding out routes with multiple flights a day. After reviewing the full case, please answer the following questions. What was Virgin America’s segmentation strategy? Whom did it serve?Regarding its core segment, what did Virgin America offer its customers?Using the Porter model, which generic business-level strategy was Virgin America pursuing?What actions, taken at the functional level, enabled Virgin America to implement its strategy?

help with the project. I dont have any idea how to do this. Open the tblLocation table, and then delete the Downtown record (LocationID 335). Save and close the tblLocation table. (Hint: if a message warning that you are about to delete 1 record appears, click Yes.)Create a new query in Design View based on the tblClient table. Add the FirstName, LastName, BirthDate, and Gender fields, in that order, to the query. Save the query as qryClientBirthday, run it, and then close it. Create a new query in Design View based on the tblClient, tblBilling, and tblTrainer tables. Save the query as qryClientsAndTrainers, and then do the following:Add the LastName field from the tblClient table to the query.Add the LastName field from the tblTrainer table to the query.Add the StartDate, EndDate, Sessions, and Amount fields, in that order, from the tblBilling table to the query. Save and run the query, and then close it.Create a new query in Design View that uses the tblTrainer table, and then do the following: Add the LastName, Specialty, Certification, HireDate, and Minors fields, in that order, to the query design. Add criteria to the Certification field to select records that contain the value NASM. Save the query as qryTrainerNASM, run it, and then close it.In the Navigation pane, copy the qryTrainer query and paste it in the navigation pane, rename the copied query as qryTrainer2015, open it in Design view, and then do the following: Add criteria to the HireDate field to select records with contracts that begin on or after January 1, 2015. Hide the TrainerID field so it does not appear in the query results but remains in the query design. (Hint: Make sure you hide this field in Design View, not in Datasheet View.)Save and run the query, and then close it.In the Navigation pane, copy the qryTrainer query and paste it in the navigation pane, rename the copied query as qryTrainerNSCAMinors, open it in Design view, and then do the following: Add criteria to the query to select records with the Certification field value NSCA-CPT and the Minors field value Yes.Sort the records in ascending order by the LastName field.Move the Minors field so it appears to the right of the Certification field in the query design.Save and run the query, and then close it.In the Navigation pane, copy the qryTrainer query and paste it in the navigation pane, rename the copied query as qryTrainerNATAOrMinors, open it in Design view, and then do the following:Add criteria to the query to select records with the Certification field value NATA or records that indicate that the trainer accepts clients who are minors. Save and run the query, and then close it. Open the qryTrainerBilling query in Datasheet View. Change the font size for the datasheet to 12 pt.With the qryTrainerBilling query still open in Datasheet View, add a total row to the query datasheet. In the total row, use the SUM function to total the values in the Amount field, and use the AVG function to average the values in the Sessions field. Widen the Sessions field to display the result in the total row (approximate width 18.8) Save and close the qryTrainerBilling query.Create a new query in Design View that is based on the tblBilling and tblClient tables, and then do the following:Add the ClientID and LastName fields from the tblClient table to the query.Add the Sessions and Amount fields from the tblBilling table to the query.Add a total row to the design grid, and group the query results by the LastName field values.In the total row, use the SUM aggregate function to calculate the sum of the Amount field values. Set the caption of the Amount field to Total Amount. (Hint: Do not type the period.)In the total row, use the SUM aggregate function to calculate the sum of the Sessions field values. Set the caption of the Sessions field to Number of Sessions. (Hint: Do not type the period.)Save the query as qryClientTotals. Run the query, and then close it. Open the qryClientBilling query in Design View and update it as described below:Add a calculated field with the title SessionCost to the end of the query that calculates the cost per session. The formula will calculate the Amount field value divided by the Sessions field value. (Hint: The division symbol is the / symbol.) Use Cost per Session for the calculated field’s caption property.Format the SessionCost field as currency.Move the SessionCost field to the left of the FirstName field.Sort the records first in descending order by the SessionCost field values, and then in ascending order by the LastName field values.Save and run the query, and then close it.