cameroon gce intermediate level June 2026 ICT 3

Information and Communication Technology 3 — 0596
GENERAL CERTIFICATE OF EDUCATION BOARD
Technical and Vocational Education Examination

Exam Session June 2026
Level Intermediate Level
Specialty Name and Acronym All Specialties
Subject Title Information and Communication Technology
Subject Code No 0596
Paper No Paper 3 Gr 1
Duration One and a half hours

Instructions to Candidates

  • Answer ALL Questions.
  • You are reminded of the necessity for good English and orderly presentation in your answers.
  • Task 1, Task 2 and Task 3 are based on softcopy materials found in a folder named Candidate folder saved on the desktop of your computer. The work of all the tasks should be saved in this Candidate folder. You may be instructed by the supervisor to rename your candidate folder.

Task 1: Word Processor (30 marks)

Open task 1 from the candidate folder and change the heading of the document as follows:

  • Font face Arial Black (2 marks)
  • Font size to 18 points (2 marks)
  • Centralize the heading (3 marks)
  • Implement a double strike through on the heading (5 marks)
  • On the body of the text, centralize all sub headings and underline them (5 marks)
  • Change the body of the text to double line spacing (5 marks)
  • Change paragraph 2 and 3 into three (3) columns and justify the columns (6 marks)
  • Save the document and print page one (1) only (2 marks)

Task 2: Spreadsheet (40 marks)

Open task 2 from the candidate folder and do the following:

  • In cell M3, calculate the total coefficients for the exams (5 marks)
  • Calculate the total marks for the student EFUET CAMILLA in cell M4 (5 marks)
  • Use the auto-fill feature to determine the total marks for the other students (3 marks)
  • Determine the average for the student EFUET CAMILLA in cell N4 (5 marks)
  • Use the auto-fill feature to determine the average for the other students (2 marks)
  • In cell N64, determine the class average (5 marks)
  • Format the cells containing the average to 2 decimal places (5 marks)
  • Format the document such that the subject titles appear on all the printed pages (5 marks)
  • Add gridlines and save your work (3 marks)
  • Print page 2 only (2 marks)

Task 3: Database (30 marks)

Carefully study the database in the candidate folder and perform the following tasks:

  • In datasheet view, format the table with the font face Arial Black (5 marks)
  • Format the date of birth to short date (5 marks)
  • In datasheet view, adjust the column widths so that all the field names can be clearly seen (5 marks)
  • Create a query to display the information of all the males from the table and save it as Male (5 marks)
  • In datasheet view, sort your query in descending order of student’s name and save the changes (5 marks)
  • Change the query orientation to landscape (3 marks)
  • Print a copy of your query (2 marks)

Total: 100 marks

Looking for solutions to this question? Contact us on WhatsApp on +237693670900.

Leave a comment

Your email address will not be published. Required fields are marked *

sponsors Ads