ICTT Exam Past-paper Answers

 July 2022

1.

i) MS Word has various features to offer to the users, list down four (04) features that are available in MS Word? 

Home

Insert

Page Layout

Reference

Review

ii) What is the difference between formulas and functions in MS Excel?

formula

When a user types an equals sign in a cell, they are starting to create a formula.

Examples of a formula include:

=4+3

=A3+C9

=B7+B8-(4*2)+1

function

When a user types an equals sign followed by a predefined set of letters (or clicks on the Fx button in the formula bar), a function begins to be implemented.

=SUM(A3:A27)

=AVERAGE(F4:F8)

iii)What are the functions of the Search Engines? Give two examples for Search Engines?

helps people find the information they are looking for online using keywords or phrases.

A search engine is a large database of internet resources like web pages, images, programs among other things resources and information.

iv)What are the benefits of using BCC in email?

Protecting Email Address Privacy

For security and privacy reasons, it is best to use the Blind Carbon Copy (BCC) feature when sending an email message to a large number of people. When you place email addresses in the BCC field of a message, those addresses are invisible to the recipients of the email.

v)Why we use slide master in PowerPoint?

1. Keep their presentation design consistent.
2. Make changes to all slides at once.
3. Customize the overall look easily.
4. Maintain their brand's appearance.
5. Edit multiple slides effortlessly.
6. 2)
7. i)Briefly explain difference between Primary and Foreign keys used in MS Assess database.
8. 
   
   
   
   

3

i)Explain briefly, differences between Vector and Raster Graphic?

ii)What are the software that can be used to create raster and vector graphics?

Raster :-Photoshop , GIMP, Corel PaintShop Pro

Vector:- Adobe Illustrator, CorelDraw, and InkScape

4

i)What is the role of the operating system in the computer system?

Manage s the computer's memory and processes ,as well as all of  its software and hardware.

ii)Give two different operating systems currently used in the computer systems

Microsoft Windows ,macOS,Linux

5

i)List two network topologies with simple diagram?

Star Topology:

• In a star topology, each device is connected directly to a central hub or switch.
• All communication between devices must pass through the central hub.
• This topology is easy to set up and troubleshoot, and if one connection fails, it doesn't affect the rest of the network.
• However, it requires more cabling than other topologies and the central hub represents a single point of failure.
  
  
  

Bus Topology:

• In a bus topology, all devices are connected to a single backbone cable, also known as a bus.
• Each device communicates directly with the bus.
• Data transmitted by one device travels along the bus and is received by all other devices on the network.
• This topology is easy to set up and requires less cabling than other topologies.
• However, if the backbone cable fails, the entire network can be affected.
  
  
  

Ring Topology:

• In a ring topology, each device is connected to two other devices, forming a closed loop or ring.
• Data travels in one direction around the ring, passing through each device until it reaches its destination.
• This topology provides equal access to all devices and does not require a central hub.
• However, if one device or connection fails, it can disrupt the entire network.
  
  
  

Mesh Topology:

• In a mesh topology, each device is connected to every other device in the network, creating multiple paths for data transmission.
• This topology provides redundancy and fault tolerance, as data can be rerouted if one connection fails.
• Mesh networks are highly scalable and can support large numbers of devices.
• However, they require a significant amount of cabling and configuration, making them complex and costly to implement.
  
  
  

Tree Topology:

• In a tree topology, devices are arranged hierarchically in a tree-like structure.
• A central root node connects to one or more secondary nodes, which in turn connect to additional nodes or branches.
• This topology combines aspects of both star and bus topologies, offering scalability and ease of management.
• However, if the central root node fails, it can disrupt communication to all connected nodes beneath it.
  
  
  

ii)What is an IP address?

6

Write the HTML codes to create this web page with following features. 

• Should have title for the web page. 
• Main heading align to center of the page. 
• Horizontal line should display after the heading. 
• Add image (Crypto.jpg) to the web page. 
• Image title should display when the mouse pointer on top of the image. 
• When click on the “Read More” hyperlink, page should be opened in new tab.

<html>

<head>

<Title>Cryptocurrency</Title>

<head>

<body>

<h1><u>The Basic Abut Cryptocurrency</u></h1>

<p>The most popular type of cryptocurrencies such as Botcoin,Litecoin and Ethereum</p>

<img src="kid.jpg" alt="crypto" width="500" Height="500">

<a href="url" style="text-align:right;">Read more</a>

</body>

</html>

8

i)What is called array in computer programing?

An array is a collection of items of same data type stored at contiguous memory locations.

 

ii)What Is the Software Development Life Cycle (SDLC)?

The Software Development Life Cycle (SDLC) is a structured process used by software development teams to plan, design, develop, test, deploy, and maintain software applications.

Planning

Feasibility Study

Analysis

Design

Implementation

Testing

Deployment

Maintenance