Question 1 Report

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

Worker	Wage/day(#)
Edeh	1500
Usman	1750
Steven	1200
Ololade	650
Comfort	897
Joe	2371

(a) Copy and paste table title "Workers' Wages" on the same sheet. Format this new table as follows:
(i) Title the new table as SALARIES
(ii) Sort the table in alphabetical order
(iii) Calculate average wage of workers per day

(iv) Calculate the max and min wages paid to the workers from the SALARIES

(b) Insert a bar chart for data in 2a

(c) Save workbook with your full name in the folder created

(d) Print and submit

Answer

This is a spreadsheet (e.g. Microsoft Excel or LibreOffice Calc) practical task. The steps below reproduce the original table, create the required SALARIES table, apply the sorting and calculations, and insert the bar chart.

Step 1 – Original table (\"Workers' Wages\")

Enter the data exactly as given. Type the title in cell A1, the headings in row 2, and the records below.

Workers' Wages
Worker	Wage/day (₦)
Edeh	1500
Usman	1750
Steven	1200
Ololade	650
Comfort	897
Joe	2371

Step 2 (a) – Create and format the SALARIES table

Select the original table, press Ctrl + C to copy, click an empty cell (e.g. D1) and press Ctrl + V to paste a copy on the same sheet.

(i) Rename the title: click the pasted title cell and type SALARIES.
(ii) Sort in alphabetical order: select the Worker and Wage/day columns of the copy, then use Data → Sort → Column: Worker → A to Z. The names re-order and each wage stays with its owner.

After sorting, the SALARIES table looks like this:

SALARIES
Worker	Wage/day (₦)
Comfort	897
Edeh	1500
Joe	2371
Ololade	650
Steven	1200
Usman	1750

Step 2 (a)(iii)–(iv) – Calculations

Assuming the six wages occupy cells E3:E8, enter these formulae in empty cells below the table:

Statistic	Formula	Result (₦)
Average wage/day	`=AVERAGE(E3:E8)`	1394.67
Maximum wage	`=MAX(E3:E8)`	2371
Minimum wage	`=MIN(E3:E8)`	650

Verification of the average:

\[ \text{Average} = \frac{897 + 1500 + 2371 + 650 + 1200 + 1750}{6} = \frac{8368}{6} = 1394.67 \]

Step 2 (b) – Insert the bar chart

Select the Worker and Wage/day columns of the SALARIES table, then choose Insert → Chart → Column/Bar. The chart plots each worker's daily wage:

graph — Bar chart of each worker's daily wage from the sorted SALARIES table; Joe is highest (2371), Ololade lowest (650).

The tallest bar belongs to Joe (₦2371, the maximum) and the shortest to Ololade (₦650, the minimum), which agrees with the MAX and MIN results above.

Step 2 (c)–(d) – Save, print and submit

Save: choose File → Save As, open the folder you created, type your full name as the file name and click Save (.xlsx).
Print: choose File → Print (Ctrl + P), select the printer and click Print, then submit the printout.

Read lesson note on Spreadsheet Package (JAMB)

Read lesson note on Word Processing Package (JAMB)

Answer Details

This is a spreadsheet (e.g. Microsoft Excel or LibreOffice Calc) practical task. The steps below reproduce the original table, create the required SALARIES table, apply the sorting and calculations, and insert the bar chart.

Step 1 – Original table (\"Workers' Wages\")

Enter the data exactly as given. Type the title in cell A1, the headings in row 2, and the records below.

Workers' Wages
Worker	Wage/day (₦)
Edeh	1500
Usman	1750
Steven	1200
Ololade	650
Comfort	897
Joe	2371

Step 2 (a) – Create and format the SALARIES table

Select the original table, press Ctrl + C to copy, click an empty cell (e.g. D1) and press Ctrl + V to paste a copy on the same sheet.

(i) Rename the title: click the pasted title cell and type SALARIES.
(ii) Sort in alphabetical order: select the Worker and Wage/day columns of the copy, then use Data → Sort → Column: Worker → A to Z. The names re-order and each wage stays with its owner.

After sorting, the SALARIES table looks like this:

SALARIES
Worker	Wage/day (₦)
Comfort	897
Edeh	1500
Joe	2371
Ololade	650
Steven	1200
Usman	1750

Step 2 (a)(iii)–(iv) – Calculations

Assuming the six wages occupy cells E3:E8, enter these formulae in empty cells below the table:

Statistic	Formula	Result (₦)
Average wage/day	`=AVERAGE(E3:E8)`	1394.67
Maximum wage	`=MAX(E3:E8)`	2371
Minimum wage	`=MIN(E3:E8)`	650

Verification of the average:

\[ \text{Average} = \frac{897 + 1500 + 2371 + 650 + 1200 + 1750}{6} = \frac{8368}{6} = 1394.67 \]

Step 2 (b) – Insert the bar chart

Select the Worker and Wage/day columns of the SALARIES table, then choose Insert → Chart → Column/Bar. The chart plots each worker's daily wage:

The tallest bar belongs to Joe (₦2371, the maximum) and the shortest to Ololade (₦650, the minimum), which agrees with the MAX and MIN results above.

Step 2 (c)–(d) – Save, print and submit

Save: choose File → Save As, open the folder you created, type your full name as the file name and click Save (.xlsx).
Print: choose File → Print (Ctrl + P), select the printer and click Print, then submit the printout.

Read lesson note on Spreadsheet Package (JAMB)

Read lesson note on Word Processing Package (JAMB)

Spreadsheet Package

Word Processing Package

View Answer

Question 2 Report

using a graphic application software, create a student identity card with the heading as "CITY COMPUTER COLLEGE - NIGERIA"

(a) Size of the card is 31/2" x 11/2"

(b) Insert "flyer pagoda" or any other graphic from the template as logo beside the heading.

(c) Format the card using the following:

background fill - 20% black; heading font type - Bernard MT Condensed, size 14 (ii) pt, colour white

(iii) write the statement, "this card identities" below the heading using Bookman Old style, 8 pt and in italics;

(iv) write the statements below under name:
Name

Admission Number - Font: Times New Roman

Year of Admission Size: 11 pt

Signature

Line - Hairline

(d) Print and submit. (e) Save file with your full name in the folder created der Name:

Answer

```html Student Identity Card Practical Question

Test of Practical Knowledge Question

Task: Using a graphic application software such as Microsoft Publisher, CorelDRAW, Adobe Illustrator, or Canva, create a student identity card.

The identity card must meet the following requirements:

Use the heading: “CITY COMPUTER COLLEGE - NIGERIA”.
Set the card size to 3½ inches × 1½ inches.
Insert a Flyer Pagoda, or any other suitable graphic from the template, as a logo beside the heading.
Include spaces for the student photograph, name, registration number, class, date of birth, and signature.

Steps for Creating the Student Identity Card

Open the graphic application software.
Create a new blank document or publication.
Set the page/card size to 3.5 inches wide and 1.5 inches high.
Draw a rectangle with a border and apply a suitable background colour, such as light blue, white, or cream.
Insert a logo graphic, such as the Flyer Pagoda, at the top-left side of the card.
Add the heading “CITY COMPUTER COLLEGE - NIGERIA” beside the logo using bold, clear text.
Create a rectangular photo area on the right side of the card and label it PHOTO.
Add student information fields such as name, registration number, class, date of birth, and signature.
Align all objects neatly, save the work, and print the completed card if required.

Sample Student Identity Card Layout

Note: Replace the sample lines and photo area with the actual student details and passport photograph when producing the final identity card.

```

Read lesson note on Graphics (WAEC)

Answer Details

```html Student Identity Card Practical Question

Test of Practical Knowledge Question

Task: Using a graphic application software such as Microsoft Publisher, CorelDRAW, Adobe Illustrator, or Canva, create a student identity card.

The identity card must meet the following requirements:

Use the heading: “CITY COMPUTER COLLEGE - NIGERIA”.
Set the card size to 3½ inches × 1½ inches.
Insert a Flyer Pagoda, or any other suitable graphic from the template, as a logo beside the heading.
Include spaces for the student photograph, name, registration number, class, date of birth, and signature.

Steps for Creating the Student Identity Card

Open the graphic application software.
Create a new blank document or publication.
Set the page/card size to 3.5 inches wide and 1.5 inches high.
Draw a rectangle with a border and apply a suitable background colour, such as light blue, white, or cream.
Insert a logo graphic, such as the Flyer Pagoda, at the top-left side of the card.
Add the heading “CITY COMPUTER COLLEGE - NIGERIA” beside the logo using bold, clear text.
Create a rectangular photo area on the right side of the card and label it PHOTO.
Add student information fields such as name, registration number, class, date of birth, and signature.
Align all objects neatly, save the work, and print the completed card if required.

Sample Student Identity Card Layout

Note: Replace the sample lines and photo area with the actual student details and passport photograph when producing the final identity card.

```

Read lesson note on Graphics (WAEC)

Graphics

View Answer

Question 3 Report

Using a word processing package, create a college time table format titled "COLLEGE TIME TABLE" for 7 subjects (English, Maths, Biology, Chemistry, Physics, Civic Education and Computer Studies), for 5 days with minimum of 45minutes duration. Lunchtime is 40minutes, lesson in the college have a minimum of 5 periods/week.

(a) Format the "COLLEGE TIME TABLE" using the following:
(i) The title of the table should be aligned centre, bold and underline;
(ii) Use table design style of any type
(iii) Days of the week should be bold

(b) Save your work with your full name in the folder created.
(c) print and submit your work

Answer

Answer Details

None

Read lesson note on Word Processing Package (JAMB)

Word Processing Package

View Answer






Press & Hold to Drag Around
Click Here to Close

WAEC SSCE - Computer Studies - 2017 (Practical)

Step 1 – Original table (\"Workers' Wages\")

Step 2 (a) – Create and format the SALARIES table

Step 2 (a)(iii)–(iv) – Calculations

Step 2 (b) – Insert the bar chart

Step 2 (c)–(d) – Save, print and submit

Step 1 – Original table (\"Workers' Wages\")

Step 2 (a) – Create and format the SALARIES table

Step 2 (a)(iii)–(iv) – Calculations

Step 2 (b) – Insert the bar chart

Step 2 (c)–(d) – Save, print and submit

Test of Practical Knowledge Question

Steps for Creating the Student Identity Card

Sample Student Identity Card Layout

Test of Practical Knowledge Question

Steps for Creating the Student Identity Card

Sample Student Identity Card Layout