Overview
Opening and Saving an Excel SpreadsheetIn this step, you will be opening and saving an Excel spreadsheet.
Download the Technology Template. Note: There are four worksheets or tabs in this Excel spreadsheet. Take a few minutes to review the spreadsheet in its entirety. The four worksheet titles and the purpose of each worksheet are as follows.
- IT Help Desk Data—contains the data to be analyzed
- Data Legend—provides information about the data.
- Statistical Analysis—used in conjunction with Excel functions to determine the average number of days the tickets are open, the distribution of the requester's seniority, the type and severity of the problem, the assigned priority level, and the end user satisfaction level. The missing information may then be filled in as it is calculated.
- QR Analysis Essay—provides essay questions to answer after you perform your analysis using Excel and Cognos. Answers should be entered directly inside each box.