TEST OF PRACTICAL KNOWLEDGE QUESTION (a) Use the information in the spreadsheet below to answer questions 5(a) i-v. A B C D E F G H I 1 S/N NAME SEX MATHEMA...
Assessment:WAEC SSCE - Data Processing - 2016Subject:Data Processing
(a) Use the information in the spreadsheet below to answer questions 5(a) i-v.
A
B
C
D
E
F
G
H
I
1
S/N
NAME
SEX
MATHEMATICS
ENGLISH
BIOLOGY
ECONOMICS
TOTAL
AVERAGE
2
1
Ada
F
72
65
80
55
272
68
3
2
Bola
M
48
52
60
44
204
51
4
3
Paul
M
65
70
58
67
260
65
5
4
Chika
F
55
49
62
58
224
56
6
5
Dele
M
80
78
85
74
317
79.25
7
6
Femi
M
40
45
50
42
177
44.25
8
7
Vera
F
68
72
66
70
276
69
9
8
Grace
F
58
60
55
63
236
59
10
9
Halima
F
75
68
70
72
285
71.25
11
10
Etta
F
62
58
64
60
244
61
(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 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 5(b) i-vii.
Microsoft PowerPoint window; the arrow labelled I points to the Slide Show view button on the status bar.
(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 labelled I. (vi) Write the keyboard shortcut that would also perform the function labelled I. (vii) Mention three functions that can be performed by the Insert button.
This question tests two practical skills: writing spreadsheet formulas/functions in a program such as Microsoft Excel, and identifying the parts of a presentation program (Microsoft PowerPoint) from a screenshot. The exact cell addresses depend on the layout of the spreadsheet supplied in your paper, so match the column and row letters below to the actual positions of the names and subjects in your sheet.
Part (a): spreadsheet formulas
(i) Total score in Mathematics. A total is a sum of a column (or row) of marks. If the Mathematics scores for all candidates run from cell C2 to C7, the formula is \( =SUM(C2:C7) \). Every spreadsheet formula must begin with an equals sign.
(ii) Paul's average of four subjects (two possible formulas). Suppose Paul's four subject marks are in cells B2, C2, D2 and E2. You may use the dedicated function \( =AVERAGE(B2:E2) \), or compute it manually as \( =(B2+C2+D2+E2)/4 \). Both give the same result.
(iii) Highest score in English. The function that returns the largest value in a range is MAX, for example \( =MAX(D2:D7) \).
(iv) Vera's total in all subjects, result in H8. Click the cell H8, type an equals sign, then use the SUM function on Vera's row of subject marks, e.g. type \( =SUM(B8:G8) \) and press Enter. The total appears in H8.
(v) Pass/fail on an average pass mark of 60. Use the IF function to test Etta's average. If Etta's average is in cell I6, then \( =IF(I6>=60,\text{"Passed"},\text{"Failed"}) \). The condition returns "Passed" when the average is 60 or more, otherwise "Failed".
Part (b): the application in the diagram
(i) The application shown is a presentation program, Microsoft PowerPoint (the give-away is the slide, slide pane and the Insert tab).
(ii) One use: to design and deliver a slide show for lectures, seminars or business presentations.
(iii) To launch from a desktop shortcut: point to the PowerPoint shortcut icon on the desktop and double-click it (or right-click and select Open).
(iv) Default slide: the Title slide (containing a title and subtitle placeholder).
(v) and (vi) depend on the specific part labelled I in your diagram; a very common labelled control is Save, whose keyboard shortcut is Ctrl + S. Read the label in your paper before answering.
(vii) Three functions of the Insert tab: insert a picture/image, insert a table, and insert a new slide (also shapes, charts, header and footer, or a text box).
Examination reminder: every spreadsheet entry that computes a value must start with \( = \), and you must quote a cell range (like C2:C7) not the words. Because the actual cell addresses come from the printed sheet, always substitute the real column letters and row numbers shown in your question.
This question tests two practical skills: writing spreadsheet formulas/functions in a program such as Microsoft Excel, and identifying the parts of a presentation program (Microsoft PowerPoint) from a screenshot. The exact cell addresses depend on the layout of the spreadsheet supplied in your paper, so match the column and row letters below to the actual positions of the names and subjects in your sheet.
Part (a): spreadsheet formulas
(i) Total score in Mathematics. A total is a sum of a column (or row) of marks. If the Mathematics scores for all candidates run from cell C2 to C7, the formula is \( =SUM(C2:C7) \). Every spreadsheet formula must begin with an equals sign.
(ii) Paul's average of four subjects (two possible formulas). Suppose Paul's four subject marks are in cells B2, C2, D2 and E2. You may use the dedicated function \( =AVERAGE(B2:E2) \), or compute it manually as \( =(B2+C2+D2+E2)/4 \). Both give the same result.
(iii) Highest score in English. The function that returns the largest value in a range is MAX, for example \( =MAX(D2:D7) \).
(iv) Vera's total in all subjects, result in H8. Click the cell H8, type an equals sign, then use the SUM function on Vera's row of subject marks, e.g. type \( =SUM(B8:G8) \) and press Enter. The total appears in H8.
(v) Pass/fail on an average pass mark of 60. Use the IF function to test Etta's average. If Etta's average is in cell I6, then \( =IF(I6>=60,\text{"Passed"},\text{"Failed"}) \). The condition returns "Passed" when the average is 60 or more, otherwise "Failed".
Part (b): the application in the diagram
(i) The application shown is a presentation program, Microsoft PowerPoint (the give-away is the slide, slide pane and the Insert tab).
(ii) One use: to design and deliver a slide show for lectures, seminars or business presentations.
(iii) To launch from a desktop shortcut: point to the PowerPoint shortcut icon on the desktop and double-click it (or right-click and select Open).
(iv) Default slide: the Title slide (containing a title and subtitle placeholder).
(v) and (vi) depend on the specific part labelled I in your diagram; a very common labelled control is Save, whose keyboard shortcut is Ctrl + S. Read the label in your paper before answering.
(vii) Three functions of the Insert tab: insert a picture/image, insert a table, and insert a new slide (also shapes, charts, header and footer, or a text box).
Examination reminder: every spreadsheet entry that computes a value must start with \( = \), and you must quote a cell range (like C2:C7) not the words. Because the actual cell addresses come from the printed sheet, always substitute the real column letters and row numbers shown in your question.
