Do a-d

Ticket # 5 ON Date_Submitted Date_Opened Date_Closed Type Reporting Employee_Name 1 11/1/20 11/1/20 11/3/20 New Dency Jenkins 2 11/2/20 11/3/20 11/6/20 Repeat Nick Lyons 3 11/5/20 11/6/20 11/7/20 New Robert Michaels 4 11/5/20 11/6/20 11/10/20 New Randy Immons 5 11/11/20 11/12/20 11/14/20 Repeat Dency Jenkins 6 11/13/20 11/14/20 11/16/20 New Molly Tanner 7 11/14/20 11/17/20 11/18/20 Repeat Dency Jenkins 11/20/20 11/20/20 11/21/20 New Rich Miller 11/21/20 11/23/20 11/24/20 New 11/21/20 11/22/20 11/25/20 Repeat Molly Tanner 11/24/20 11/25/20 11/28/20 New Randy Immons 12 11/25/20 11/25/20 11/27/20 New Glenda Abbot 13 11/26/20 11/27/20 11/28/20 Repeat Robert Michaels 14 11/28/20 11/29/20 11/30/20 Repeat Glenda Abbot 15 11/28/20 11/29/20 11/30/20 New Rich Miller Reporting_Employee_Division Wagons & Carts Dolls & Action Figures Robotic Toys Sleds & Toboggans Wagons & Carts Dolls & Action Figures Wagons & Carts Robotic Toys Dolls & Action Figures Dolls & Action Figures Sleds & Toboggans Wagons & Carts Robotic Toys Wagons & Carts Robotic Toys Technician_Name Rob Owens Dennis Rivers Rob Owens Anita Jenkins Rob Owens Anita Jenkins Rob Owens Dennis Rivers Dennis Rivers Anita Jenkins Rob Owens Dennis Rivers Rob Owens Dennis Rivers Anita Jenkins Problem_System Production Scheduling Accounts Payable Order Entry Sales Quota Computation Production Scheduling Customer Service Production Scheduling Payroll Budgeting Customer Service Sales Quota Computation HR Forecasting Order Entry HR Forecasting Budgeting Problem_Description Network Fault Master Update Error Log-in Error Reporting Error Network Fault Database Access Error Network Fault Reporting Error Master Update Error Database Access Error Log-in Error Reporting Error Log-in Error Reporting Error Master Update Error Nick Lyons 8991 Suppose you have just been appointed manager of a help desk with an IS department. You have been there for just a week, and you are amazed to find only limited data to help you manage your employees. In fact, the only data kept concerns the processing of particular issues, called Tickets. The following data are kept: Ticket#, Date_Submitted, Date_Opened, Date_Closed, Type (new or repeat), Reporting_ Employee_Name, Reporting_Employee_Division, Technician_Name_Problem_System, and Problem_Description. You can find sample Ticket data in the Excel file Ch11Ex01_U11e.xlsx. As a manager, you need information that will help you manage. Specifically, you need information that will help you learn who are your best- and worst- performing technicians, how different systems compare in terms of number of problems reported and the time required to fix those problems, how different divisions compare in terms of problems reported and the time required to fix them, which technicians are the best and worst at solving problems with particular systems, and which technicians are best and worst at solving problems from particular divisions. a. Use Access, Excel, or a combination of the two to produce the information you need using the data in the Excel file Ch11Ex01_U11e.xlsx. In your answer, you may use queries, formulas, reports, forms, graphs, pivot tables, pivot charts, or any other type of Access or Excel display. Choose the best display for the type of information you are producing. b. Explain how you would use these different types of information to manage your department. c. Specify any additional information that you would like to have produced from this data to help you manage your department. d. Use Access, Excel, or a combination to produce the information in part c