Knowledge Management Process
Excel Assignment:
Course Project Content
You recently applied for a job at a local news media company. Your role will be managing ten helpdesk technicians. In your interview, you are provided with a tour of the IT data center. You note within your visit that the systems you will be responsible for, are cutting edge technology, and you would appreciate the opportunity to learn and grow your IT and management skills.
As you meet the IT helpdesk staff, you notice that most of the team members seem to be unmotivated and lack any general understanding of these new systems. They display no desire to learn and would prefer to have kept the old environment because “it was easy.” You note the new systems allows the company employees to track their trouble tickets and rate the resolution response of a given helpdesk technician.
After your tour, your potential new manager informs you that the helpdesk technicians do not like being rated by employee surveys and has appeared to have demotivated them in their daily task. They feel that they should be ‘judged’ by other employees in different departments.
As part of the interview process, your potential new manager states that he likes you, and wants to give you the job. However, he is hesitant because the last three managers could not manage the helpdesk technicians. So, he grants you a chance to prove you can handle the challenge with two tasks.
Task to Complete:
Demonstrate knowledge of customer information technology tracking systems, utilizing Microsoft Excel, please format a ticketing system. Identify the following fields:
• Ticket Number
• User requesting the ticket.
• Contact Number
• The issue being reported.
• Severity of the ticket
• Technician Assigned
• Resolution
Be creative and examine the example below. Enter five customer support tickets and resolutions.
• Forgot Password
• Cannot connect to internet.
• Not receiving emails
• Not sending emails
• Computer keeps freezing.