Computer Studies Paper 3, WASSCE (SC), 2017

Question 2

 

As the account clerk of an organization, you are to prepare the table as shown below using a spreadsheet application.

WORKER

WAGE PER DAY (N)

EDEH

1,500.00

USMAN

1,750.00

STEVEN

1,200.00

OLOLADE

650.00

COMFORT

897.50

JOE

2,371.20

 

  1. Copy and paste table title “Workers’ Wages” on the same sheet. Format this new table as follows:
  2. title the new table as “SALARIES”;
  3. sort the table in alphabetical order;
  4. calculate average wage of workers per day;
  5. calculate the maximum and minimum wages paid to the workers from the table “SALARIES”
  6. Insert a bar chart for the data in 2 (a)
  7. Save workbook with your full name in the folder created.
  8. Print and submit.

 

Observation

 

 


 

 

 


 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


 

The question tested candidates’ skill on using a spreadsheet application to perform some computations and insert a graph.
Majority of the candidates demonstrated proficiency on the use of spreadsheet application.