Data Processing Paper 2, WASSCE (SC), 2019

Question 6

Table 1 shows the list of items and the quantity of the item needed by a student. The table was created on an MS Excel worksheet. Use the table to answer questions 6(a)(i) – (iv).

Table 1

ITEM	QUANTITY
TEXTBOOK	12
BIRO	5
EXERCISE	18
PENCIL	3
CALCULATOR	2
ERASPOR	2

(a)   Outline the steps to;

(i)    create a bar chart on the worksheet such that the items would be labeled on the chart
and the percentage of each item included.
(ii)   add to the table, a new:
A.    column;
B.    row.
(iii) state one function in MS Excel that can be used to determine the item with the highest quantity.

(b)   Outline the steps to add page border to a document using Art Design Tool in MS Word
application.
(c)   An MS Word document contains the phrase “WAEC Exam”. Highlight the steps to link the phrase above to the WAEC website. (http://www.waec.org.ng)

Observation

The expected answers were:

(a) Steps to

             (i) Create bar chart
                  – select the data range
                  – click on "Insert" from the menu bar
                  – select bar chart
                  – select the appropriate chart type
                  – choose the chart design that has the items and percentage

               (ii) Add new column
                      (A) –click on the column label
                            –right click and select "Insert"
                                                            OR
                            –select the column label
                            –press Ctrl + Shift + + on the keyboard
                                                            OR
                           Right click on the column label and select insert
Add new row

                      (B) –click on the row number
                            –right click and select "Insert"
                                                            OR
                             –select/click on the row number
                             –press Ctrl + Shift + + on the keyboard

                (iii) Function in MS Excel used to determine item with the highest quantity
Max Function/=MAX (cell range)

(b) Steps to add page border
–click on Page Border tab
–on the page border tab, click on Art drop down button
– select the desired Art Design
–click Ok.

OR

–click on the Design tab and click on Page Border
–click on Art drop down button
– select design of choice
–click Ok.

OR

–click on Page Layout tab and click on page border
–select page border tab on the dialog box
– select the desired Art Design
–click Ok.

OR

–click on format menu and select borders and shading
–click on page border tab
– select the desired Art Design
–click Ok.

(c) Steps to link phrase to website
–select/highlight "WAEC Exam" from the document
–click on the "Insert" tab/Right click
–click on "Hyperlink"/"Links"
–type http://www.waec.org.ng on the address field of the "Edit Hyperlink" dialog box
–click Ok.

The question tested candidates’ practical knowledge onMS Word and MS Excel applications.

The report stated that while candidates demonstrated good knowledge of the software applications, they were poor in logical presentation of the steps in carrying out the required tasks.