Question: please help :( Suppose you have just been appointed manager of a help desk with an IS department. You have been there for just a

please help :(
 please help :( Suppose you have just been appointed manager of
a help desk with an IS department. You have been there for

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_U12e.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_U12e.xisx. 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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!