Question Three

(a) Using a suitable software package, Load the file S5 ICT Results.xls that shows End of Year 2023 Promotional ICT results for S.5 students of Bologna Sec Sch. Save it as your name and personal number.                           (01 mark)

b) Use a suitable formula to find the marks of students in S850/1 and S850/2 out of 40 and 60 respectively.                                                                  (02 marks)

c) Format the titles to appear like the ones below. (02 marks)

d) Use a suitable function to calculate find the values of:

(i)  Total                                                                                 (01 mark)

(ii)  Grade (a student gets an O for total marks 50 and above of F for total marks less than 50)                                                                         (02 marks)

(iii)  Position                                                                           (02 marks)

(iv) Second Highest mark in each paper                                   (02 marks)

(v)  Third Lowest mark in each paper                                      (02 marks)

e) Using the name, S850/2 out of 60 and the percentage marks of both papers, insert an appropriate column graph in a new sheet named Graph.                             (03 marks)

(f) Using the above chart convert the S850/2 out of 60 into a line graph. (02 marks)

e) Add all borders, your name and personal number as footer on sheet1 and print.                                                                                                                     (01 mark)