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.