City Guilds Model Questions Vol1 2019 Information Technology Question 3

You have been given a plain‑text file (employees.txt) that contains the following 10 employee records, each separated by a line break and the fields separated by commas: ``` Ada Okoro,Manager,Finance,750000 Bola Adeyemi,Accountant,Finance,420000 Chinedu Nwankwo,Supervisor,Operations,380000 Dora Mensah,Clerk,Administration,210000 Emeka Obi,Technician,Operations,340000 Femi Oladipo,Analyst,Research,460000 Grace Uche,Assistant,HR,250000 Hassan Yusuf,Engineer,Maintenance,590000 Ijeoma Eze,Officer,Security,300000 James Kalu,Director,Executive,1200000 ``` Using a word‑processing application, you are required to produce a formatted employee directory with the following specifications: * Import the data into a table with appropriate column headings (Name, Position, Department, Salary). * Apply the built‑in "Heading 1" style to the table header row and ensure the header repeats on every page. * Adjust column widths so that all data are visible without truncation. * Insert a calculated field that shows the **total salary expense** and another that shows the **average salary** for the ten employees. Place these two results directly below the table. * Protect the final document so that the table and the calculated fields cannot be edited accidentally, but allow the user to add comments at the end of the document. Answer the following: a) List, in order, the steps you would take to import the data, format the table and insert the calculated fields. b) Compute the total salary expense and the average salary for the ten employees and show the numerical results you would obtain. c) Describe two different methods of protecting the document and state which method you would choose if the document is to be printed and distributed to senior management.