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:

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

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

(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

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.

Soma maelezo ya somo kwenye Spreadsheet Package (JAMB)

Soma maelezo ya somo kwenye Word Processing Package (JAMB)