Reading the file I uploaded and answer 3 questions. 250 words for each question. 1. In the world of Human Resources, the acronym "KSA" stands for Knowledge, Skills, and Abilities. Assessors apply it t

1 © Gerrard 2016 – amd Atha 2016/2017 /2018 /19 Assignment 1 E x ce l 23 6 2 – Assig n me n t 1 STUDENT DATA FILES FOR HOME AND LAB USE The files are on the Learning Hub (Chapters in the Content area). They can also be downloaded from the publisher’s website www.pearsonhighered.com/exploring (noted in the textbook cover) . The files w e will use in class will be in the Session file for that week. There may also be files needed from the Chapters noted above. ASSIGNMENTS Use these instructions for ALL your assignments. PLEASE ASK IF YOU NEED CLARIFICATION. Submit the complete assignment to the assignment drop box in the Learning Hub www.learn.bcit.ca Prior to submitting:  All submitted assignments must be in good presentation order. Treat your work as if you are pre senting to a current or potential employer or client. Marks will be deducted from the overall assignments for submissions not in a presentable format.  Presentation format means it is suitable for distribution to an audience both on -screen and in print form . Use print preview to show what your assignment will look like. Each previewed page must not have any text, tables or charts cut off or orphaned. Orphan rows and columns must be fixed prior to submission.  Ensure all assignments are placed in the order o f the exercises stated and the sheets are labelled accordingly. No additional sheets or files should be included. This will facilitate more timely feedback.  Email of assignments will not be accepted. No exceptions. Only assignments submitted to the cor rect Learning Hub drop box will be marked. No printing is required.  Assignments are due as per the date in the drop box in the Learning Hub and on the course outline. All assignments must be completed individually. Late assignments, if accepted, may onl y be considered for marking with penalty unless otherwise previously agreed upon.  Check the course outline for % associated with your assignments.  Additional exercises from the textbook or instructor may be added to assignments as required for the needs of the class. Additional work will be announced at the end of each session. Please ensure you are present to note additional work assignments. 2 © Gerrard 2016 – amd Atha 2016/2017 /2018 /19 Assignment 1 Ass ignm ent 1A 1. Open e05 b2 games .xlsx and save it as Yourname_Assignment _1A. 2. Click on the Salary Data tab. C opy this worksh eet three times. You will now have four w orkshe ets with the same data. Eas iest way is to hold down t he CTRL key and drag the sh eet and release . This will copy the worksh eet. 3. Rena me the second sheet to By Depa rtment and Title; the third she et By Gen der and t he fourth My Pivot. Chang e the tab colour of all four sh eets to blue. 4. In the Salary Data worksheet, sort by Performance and subtotal the salary by Performance. 5. In the By Depart ment and Title worksheet, sort by department and title and then calculate the average salary by subt otalling by department and title. 6. In the Gender worksheet, do a count of the number of salaries paid by gender using a subtotal. 7. Using the data from the My Pivot work sheet crea te your own p ivot table in the same worksheet to show the salar ies for each depa rtment by title a nd gen der. 8. Copy the My Pivot worksheet twice . Ren ame one of the new worksheets as Pivot Chart and the second one as Formatted Pivot . 9. In the Pivot Chart worksh eet, crea te a p ivo t chart and then use the ch art filters to limit the ch art to the Animation, Art, Game Design and Produ ction departments by gen der. Change the Y Axis to thousands. The pivot chart work s just like the ordinary charts with the exception of the filters. 3 © Gerrard 2016 – amd Atha 2016/2017 /2018 /19 Assignment 1 10 . In the Formatted Pivot worksheet, complete the followin g: a. C hang e the rep ort layout to Tabu lar form. b. Chang e the style to Pivot Style Med ium 15. c. Chang e to summarize by Avera ge Sal ary. d. Insert a slicer for Depa rtment and select Animation. 11 . Save the file . Ass ign m ent 1B 1. Complete the Caps tone Exercise at the end of Cha pte r 6 Page 451 . The requ ired file for Assignment 1B, e06c1Manufacturing , is included in the Chapter 6 folder in the content area in the Learning Hub . 2. Save yo ur file as Yourname_ Ass ign ment 1B_ C.xlsx . There’s more………..flip over the page….. 4 © Gerrard 2016 – amd Atha 2016/2017 /2018 /19 Assignment 1 Ass ignm ent 1C 1. Open Studio .xlsx. This is not the same as the one from the Chapter . Copy the Loan wo rksheet to your Yourname_ Ass ign ment 1B_C workb ook. Rena me the works heet as Ass ign ment 1C. 2. Complete the worksh eet by: a. Enteri ng the Beginn ing Ba lance in B13 by referenci ng the In pu t Area. b. Enteri ng the Monthly Payment in C13 by referenci ng the Inpu t Area. c. Calc ulating the Inte rest Paid, Principal Red uction and Ending Bala nce in row 13 . d. Calc ulating the C umulati ve Intere st and Cumulative Principle . e. Auto fill ing the bal an ce of the tab le. 3. Save the file to the Yourname_ Ass ign ment 1B_C workb ook. Ens ure all r equ ired files are uploaded to the Learning Hub . There are two files to be su bmitted: Yourname_Assignment 1A and Yourname_Assignment 1B_C Please ensure the files are named correctly. Other files (i.e. jpg, png, docx) will not be reviewed/marked.