Question 5
(a) Use the information in the spreadsheet below to answer questions 5(a) i-v
(i) Write the formula to calculate the total score in Mathematics.
(ii) Write two spreadsheet formulas to calculate Paul’s average score in the four subjects.
(iii) What spreadsheet function can be used to determine the highest score in English?
(iv) Outline the procedure for calculating Vera’s total score in all the subjects and give the result in cell H8.
(v) If the minimum pass mark is an average score of 60, write a formula to determine if Etta passed or failed.
(b)Use the diagram below to answer questions 5(b) i-vii
(i) What is the name of the application shown in the diagram?
(ii) State one use of the application mentioned in 5 (b) (i).
(iii) Outline the procedure to launch the application from its shortcut on the desktop.
(iv) After launching the application, what is the name of the slide that appears by default?
(v) Identify the part labeled I.
(vi) Write the keyboard shortcut that would also perform the function of the part labeled I.
(vii) Mention three functions that can be performed by the insert button.
Observation
The expected answers were:
(a) (i) =SUM(D2,D3,D4,D5,D6,D7,D8,D9,D10,D11)
OR
=(D2+D3+D4+D5+D6+D7+D8+D9+D10+D11)
OR
=SUM (D2:D11)
OR
=SUM (D11:D2)
(ii) =AVERAGE (D4:G4)
OR
= (D4+E4+F4+G4)/4
OR
=AVERAGE (D4, E4,F4,G4)
OR
=SUM (D4:G4)/4
OR
=SUM(D4,E4,F4,G4)/4
(iii) Max Function.
OR
=MAX(E2:E11)
(iv) Click on cell H8
Type “=SUM(D8:G8)”
Press “Enter”
OR
Click on D8
Hold down the Mouse and stop at H8/ Highlight D8 to H8
Click on Summation icon on the Menu Bar
OR
Click on H8
Type “=SUM (D8, E8,F8,G8)
Press “Enter”
OR
Click on H8
Type =SUM (D8:G8)
Press Enter
(v) =IF(I11> 59, “PASSED”, “FAILED”)
OR
=IF(I11>= 60, “PASSED”, “FAILED”)
(b) (i) MS PowerPoint
(ii) Presentation
(iii) Double-click on the icon
OR
Right-click on the icon
Select open
(iv) Title Slide
(v) Slide Show View Icon/Slide Show Icon/ Slide Show
(vi) F5
(vii)
- -Insert Shapes
- -Insert Textbox
- -Insert WordArt
- -Insert Comment
- -Insert Video
- -Insert Symbols
- Sound
- Table
- Clipart
- Equation
- New Slide
- Pictures
- Header/Footer
- Date & Time
- Text Box
- Smileys etc.
There was poor response to the questions signifying candidates’ lack of practical knowledge.