Advanced level 2025 Centre regional mock guide ICT 2
Advanced level 2025 Centre regional mock guide ICT 2
1. (i) A university uses a computerized student management system to manage student records.
(a) Explain the process of data validation in the student management system and its importance. (2 marks)
(b) State two data capture techniques that can be used to record students data. (2 marks)
(ii)
(a) Convert 580.2510 to binary (2marks)
(b) Evaluate 1112 x 1012 (2marks)
(c) Evaluate 1011011+ 111112 (2 mark)
(iii) A company uses video conferencing for internal meetings.
(a) List THREE hardware devices that can be used in video conferencing and explain their roles. (3 marks)
(b) State TWO advantages of video conferencing for remote teams. (2 marks)
(c) Identify and explain two factors that influence the quality of video and audio during a video conference.
(2 marks)
2. (i) (a) Discuss the effects of malware on a school computer network. (2 marks)
(b) Describe TWO methods that can be used to prevent malware infections in a school network. (2 marks)
(c) State and explain TWO ergonomic problems related to prolonged use of computers. (2 marks)
(ii) (a) Define the term data integrity in database systems. (2 marks)
(b) Explain THREE advantages of a relational database over a flat file system. (3 marks)
(c) A school is designing a database to store teacher information. State and explain TWO principles from the
Data Protection Act that the school must follow. (2 marks)
(iii) Compare the advantages and disadvantages of Laser and Dot Matrix printers. (4 marks)
3. (i) (a) Explain the function of a router in a computer network. (2 marks)
(b) Describe the role of a hub in a network and how it differs from a switch. (2 marks)
(ii) Outsourcing is commonly used in businesses for software development.
(a) List THREE factors a business should consider when choosing an outsourcing company. (3 marks)
(b) State TWO disadvantages of outsourcing software development. (2 marks)
(iii) Write in full and state the functions of the following components in a computer system:
(a) RAM (2 marks)
(b) GPU (2 marks)
(c) PSU (2 marks)
(d) HDD (2 marks)
