THE PRESIDENT’S OFFICE REGIONAL ADMINISTRATION AND LOCAL GOVERNMENT

KILIMANJARO REGIONAL COMMISSIONER’S OFFICE FORM TWO MOCK EXAMINATION

 398 COMPUTER APPLICATION WITH CAD

Tuesday 16^th, September, 2025 pm Time: 2:30 Hours

INSTRUCTIONS:

1. This paper consists of sections A,B,and C.
2. Answer ALL questions in ALL sections. 
3. Cell phones are not allowed in the examination room.

 SECTION A (15 marks)

 1. Choose the most correct answer for each of the following questions and write its letter in the box provided.

i. Computers are electronic devices that accept instruction process input and produce:

1. Information.
2. Data.
3. Program.
4. Systems software.

ii. Folder are needed to:

1. Organize files.
2. Create files.
3. Create document. 
4. Move files

iii. In spread sheets the features that specify common instructions for calculation are:

1. Formulas.
2. Formats.
3. Recalculation.
4. Consolidation

iv. When using a word processor, the command that is used to reinsert text into a document are:

1. Cut. 
2. Paste. 
3. Copy.
4. Merge

v. Examples of hardware which are used to store data externally are: 

1. Mouse and CD.
2. Diskette and speaker.
3. Keyboard and mouse.
4. Floppy Diskette and Compact Disk.

vi. A device that converts images on a page to electronic signals that can be stored in a computer is a:

1. Monitor. 
2. Scanner. 
3. Plotter.
4. Pos.

vii. One of the following devices is not a permanent storage device:

1. Floppy disk.
2. Hard disk. 
3. Scanner.
4. Compact disk

viii. In excel, if a number in a cell is too wide for the cell to displayed it will be indicated by the error .

1. ! No ##. 
2. ######. 
3. #Ref
4. #DIV/0!.

ix. The function of a keyboard in a computer is: 

1. To process data given to computer.
2. To output data processed by CPU.
3. To accept data from the user to the computer.
4. To accept information and processed them to output.

x. The smallest item of data is:

1. A word
2. A bit 
3. A byte
4. A character

ANSWERS:

2. Match the following functions of the computer storages in List A with their corresponding storage name in List B by writing the letter of the correct option below the item number in the table provided.

ANSWERS:

SECTION B (70 MARKS)

Answer all questions in this section

3. Look carefully at the print dialogue box below and answer the questions that follows

1. What is the name of printer selected?
2. What range of paper will be printed?
3. How many each of paper will be printed?
4. Write down the steps required to reach the stage shown on the snapshot

4. a. Explain the functions of the following parts of the Central Processing Unit (CPU)

1. CU 
2. ALU 

b. The most important software on a computer is the Operating System (OS). An OS is system software that carries out the computer’s essential functions. What are the five functions of operating system?

5. (a) The First generation of computers used Vacuum tube technology, punched cards for data input, paper tape for output, machine language for writing programs, and magnetic tapes and drums for external storage. Outline five (6) Characteristics of firstgeneration computers.

 b) Anything entered into a computer is referred as input, list four types of inputs devices that can be used to entered data into a computer.

6. (a) Computers and other accessories have to be kept in a clean and conducive environment to function properly. Explain the effects of dust, humidity and temperature on computers and other accessories three points

b) Describe the function of the following keys as used in Microsoft words.

i. Enter key or Return  key:

ii. Caps lock key;

c. Most pieces of electrical and electronic equipment are designed to operate properly and within their specifications if the voltage supply varies within ±10% of normal value. However, some sensitive devices such as computers, refrigerators, televisions, and washing machines require stable incoming voltage for them to operate properly. Explains two undesirable effects of power fluctuations

7. (a) See carefully the following snapshot then answer the questions below

1. What is the font style and size of the worksheet?
2. Write the reference of an active cell.
3. What formula required to find the total amount.
4. Write the formula required to find the maximum amount 

(b). Suppose the numbers 500, 600 and 400 have been entered in cells whose references are A1, B1 and C1 respectively. By using cell references write a formula that will

1.  Give the product of 500 and 400
2.  Give the average of 500, 600 and 400 . 

 8. A company stores a stock list of Jeans in a computer file. Several records are shown in the diagram.

1. Write down data type for location code field
2. Which field would be used as a key field?
3. Differentiate between Select query and Action query.
4. Which ITEM CODE(s) will be listed if the following search condition is ‘input’?

(SELL ($)>300) and (color= “B”)

5. Write down a search condition to list all the Jeans which are not white that sell at less than $400.

9. (a) What is a computer Security?

(b) How can a computer virus propagate itself across multiple devices on a network 4 points

 (c) Give four advantages of protecting information system . 

SECTION C (15 MARKS)

Answer only one question in this section

10.Discuss the major differences between electronic data processing and non-electronic data processing. In your answer highlight aspect such as speed, accuracy, cost, speed and reliability. Provide real-life examples of where each method used

11.Communication through e-mail requires a person to register (sign up) on an electronic program offered freely or through charged services by a particular website.

In an e-mail account, a person can create, save, and receive information electronically. Explain three advantages and three disadvantages of electronic mail (e-mail).