1 Download and open the file named EXP19_Ch04_Cap_TechSupport.xlsx. Grader has automatically added your last name to the beginning of the filename. 2 Freeze Panes so the first row containing column headings (Row 5) on the SupportCalls worksheet will remain static when scrolling. Ensure that Rows 1-4 are visible. 3 Convert the data to a table, name the table SupportCalls, and apply the Gold, Table Style Medium 12. 4 Remove duplicate records. 5 Add a new column to the table named Duration. 6 Create a formula using unqualified structured references to calculate the days required to resolve the incident (Date Resolved – Date Created). 7 Add a total row to display the Average days required to resolve an issue. 8 Sort the table by Agent Name in alphabetical order, add a second level to sort by Description, and create a custom sort order as follows: Won't power on, Virus, Printing Issues, Software Update, Forgotten Password. Add a third level to sort by Duration smallest to largest. (Mac users, to create the custom list, from the Excel menu, click Preferences. In the dialog box, click Custom Lists.) 9 Filter the table to only display closed incidents as indicated in the status column. 10 Use Quick Analysis to apply Data Bars conditional formatting to the Duration column (range I6:I85). Mac users, on the Home tab, click Conditional Formatting, and under Solid Fill, click Blue Data Bar. 11 Create a new conditional format that applies Red fill and bold font to incident (range A6:A85) that required 30 or more days to resolve. 12 Change page breaks so page 2 begins with the Computer ID column (column E). 13 Set the print scale to 85%. 14 Add a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side. 15 Save and close the workbook. Submit the workbook as directed.

n the Case for this module, you will be conducting a personal evaluation of your team for the 101 Tips exercise. In reality, you have been assessing the team all the way through the course, but in this Case you are going to condense your analysis into a format that will become the basis for an action plan for continuous improvement and team learning in the SLP for this module. So review your SLPs, Cases and Discussion forums from Modules 1-3, and for each question on the left side of the table, answer yes or no and list appropriate actions for improvement on the right side. The finished table should be about 3-5 pages. Assignment ExpectationsYou will turn in just the table for this Case, but be sure that the presentation is professional. For example, make sure page breaks do not break up text, and align the answers in the right-hand cells with the related question on the left.The following form is adapted from table 8.1: Actions for growth and improvement. In Nemiro, J. E. (2004). Creativity in Virtual Teams: Key Components for Success. Pfeifer, San Francisco: CA. p. 281.Team ProcessAssessment and ImprovementDesign: Are there adequate opportunities for idea generation, development, finalization and closure, and evaluation? Is there an appropriate balance of periods for the team to work together, work apart, and then work together again? Is the chosen leadership structure optimal for guiding the team in its path toward creative results? Climate: Does the team have adequate procedures and forums for establishing task connection? Does the team have ways to build and maintain interpersonal connection? Are the appropriate team and management conditions and competencies present? Resources: Does the team have an agreed-upon personalized communication plan in place to specify the communication tools used, the frequency of the use of those tools, and the purpose for which they are used? Does the team make relevant use of collaboration tools? Norms and Procedures: Does the team have agreed-upon communication norms that guide its communication behavior? Does the team have an agreed-upon set of norms to assist in the management and accomplishment of the team project and tasks? Continuous Improvement: Does the team have procedures in place for capturing knowledge for later assessment and learning? Does the team set aside adequate time to actively review and assess its work and subsequently learn from this assessment?below is exactly how the paper should goContinuous Improvement The purpose of this paper is to …This paper will answer the question, “…”In order to provide an answer to this question we will examine the following issues. First, …Second, …Finally, …Team ProcessesAssessment and ImprovementDesign: Are there adequate opportunities for idea generation, development, finalization and closure, and evaluation? Is there an appropriate balance of periods for the team to work together, work apart, and then work together again? Is the chosen leadership structure optimal for guiding the team in its path toward creative results? Climate: Does the team have adequate procedures and forums for establishing task connection? Does the team have ways to build and maintain interpersonal connection? Are the appropriate team and management conditions and competencies present?Resources: Does the team have an agreed-upon personalized communication plan in place to specify the communication tools used, the frequency of the use of those tools, and the purpose for which they are used? Does the team make relevant use of collaboration tools?Norms and Procedures: Does the team have agreed-upon communication norms that guide its communication behavior? Does the team have an agreed-upon set of norms to assist in the management and accomplishment of the team project and tasks?Continuous Improvement: Does the team have procedures in place for capturing knowledge for later assessment and learning? Does the team set aside adequate time to actively review and assess its work and subsequently learn from this assessment?Summary and Conclusion The purpose of this paper is to …This paper will answer the question, “…”In order to provide an answer to this question we will examine the following issues. First, …Second, …Finally, …References