SECTION A (40 MARKS)
Answer all the questions in space provided.
- List 4 hardware components that form a complete computer system. (2mks)
- What do you understand by the term ‘Disk initializing’? (1mks)
- Draw an illustration of:
a) Parallel cable (1mk)
b) USB port (1mk)
- Explain the three parts of a task bar (3mks)
- Name three examples of flat-panel monitors available in market today. (3mks)
- List four number systems that the design and organization of a computer may depend on. (4mks)
- Explain the meaning of the following terms as used in computer communication (2mks)
- Explain the 3 factors used to classify operating systems. (3mks)
- By using two compliment work out 3110 - 1710 in binary form. Show your calculations clearly. (2mks)
- What is the meaning of the following as used in word-processing: (2mks)
- Word wrap
- Drop caps
- Using the long division method convert 4510 into binary. (1mks)
- a) Differentiate between a formula and a function as used in Excel (2mks)
b) What is the effect of the following function: =COUNTIF(A10:E10, “eggs”). (1mk)
c) Explain the meaning of legends as used in Excel. (1mk)
- a) Name four database models. (2mks)
b) State the work/function of the following field properties if set: (2mks)
- Default value
- (a) List any 4 examples of DTP software available in the market today. (2mks)
(b) What is the difference between the pasteboard and printable area? (2mks)
- In electronic mailing (e-mail), what do the following domain refer to in an e-mail address. (2mks)
e.g. – Oketchjunior@yahoo.com
- Define the word protocol. (1mk)
SECTION B (60 Marks)
Answer question 16 and any other TWO Questions.
- a) Describe any three mouse techniques/skills (3mks)
b) List four key groupings on a computer keyboard citing two examples in each. (4mks)
c) Name and explain the function of the following key symbols.
- Esc (2mks)
- (a) Differentiate between a formula and a function as used in Excel. (2mks)
(b) What is the effect of the following function?
COUNTIF (A5:D5,” orange”). (2mks)
(c) The first column in the table below contains the formula stored in all C10 of a spreadsheet. Enter the formula as they would appear when copied to cell F15 of the same spreadsheet.
FORMULA IN C10
FORMULA IN F15
- Explain the concept of distributed databases. (2mks)
- State two advantages of distributed databases. (2mks)
(f) List any two-word processor software. (2mks)
- (a) Explain how computers are used in the following areas: (6mks)
- Law enforcement
- A library
- (a) Identify three advantages of using computers in banking (3mks)
(b) Define the term ‘computer laboratory’ (2mks)
(c) List down three safety precautions one should observe when entering a computer laboratory (3mks)
(d) List down four functions of the uninterruptible Power Supply (UPS) (4mks)
- (a) Explain each of the following computer terminologies as used in data representation. (4mks)
- bit -
- Nibble -
- word -
(c) Perform the following Binary arithmetic:
- 11100111 + 00101110 (1mk)
- 101012 – 1102 (2mks)
SECTION A. ( 40 MKS)
- - Input devices
- Output devices
- Processing devices
- Storage devices
- Connecting devices
- This is the preparing of a disk to store information / data (1mk)
- Start button- this is on the extreme left end with a word start together with a Microsoft logo. It is used to access programs as well as shut down the computer.
Task Manager – this is the middle part of the bar which displays any task / program that is running
System tray- this is the right most part which bears the system clock
- LCD – Liquid crystal display
EL – Electro Luminescent
Gas – plasma
TFT – Thin film transistor
- - Hexadecimal - Octals -Decimal –Binary (Each 1 mk x 4 = 4mks
- a) Changing of the digital data to analog data.
b) Changing of the analog data back to digital data.
- - Number of people / users it can support at a given time
- Number of tasks / activities it can run at a given time
- The kind of interface it presents to the user
- i) Automatic carry over to the next line of a word that does not fit at the end of a line hence avoiding breaking up of words
ii) A feature used to enlarge the first letter of a paragraph so that it drops to cover 2 to more lines in the paragraph.
- a) A formular is constituted / constructed by the user while a function is a ready to use formular that comes with the program .
b) It counts the number of occurrences of the word “Eggs” in the range A10 to E10.
c) This is a key which explains the colour used in charts what it means. (Clear explanation 1mk)
- Flat files
- Hierarchical model
- Network model
- Relational model
- Object oriented model
b) Format- determines the order information appears on the screen / printed. .
Default value- a value that appears automatically in the datasheet or form if nothing is entered by the user.
- - Adobe Page Maker
- Corel Draw
- Microsoft Publisher
- A paste board is a large blank area where you place text and any graphical objects for the purpose of rearranging them neatly before placing them on the printable area.
A printable area looks like a page surrounded by margins found on the pasteboard. Any text or object found / placed here will be printed out.
- - Adobe Page Maker
- - .edu – Educational institutional
- .org- Non – profit making organization
- .gov- Government institution
-.co- Commercial institution.
- A set of rules that govern how two computers can send and receive data on the network.
- a)- Pointing
- Double clicking
- Drag and drop
b) Group Example
Function Keys F1, F5
Number Keys 1, 9
Alphabet Keys A, Z
Special Keys Esc, Enter
Screen Keys Pg up, scroll lock
Numeric key pad Num Lock, 1
b) i) Enter – Used to execute commands
- Used to move the cursor/ insertion point to the next line
ii) Shift - Used to access the uppercase characters.
- Used together with direction keys to select/ highlight characters or cells
iii) Tab – Used to move the cursor/ insertion point to tab points(settings) / from field to field
iv) Escape – Used to quit/ exit certain operations
- (a) Functions are predefined formula that can be used quickly instead of having to create a new one each time a calculation has to be carried out. (1mk)
- Formulas are user defined mathematical expressions that create relationship between cells and return a value in chosen cells. (1mk)
(b) It counts the number of occurrences of the word “oranges” in the range A5: DB.(2mks)
FORMULA IN C:10
FORMULA IN F:15
= D10 * E10
= A $ 5
= D $ 5
= 4 * B $ 6
=4 * E $ 6
(ii) - Searching of items is fast. (1mk)
- No interference of other departments data (1mk)
(e) - used to enter data into tables.
- Display data from tables and queries.
(f) - Ms word
- word perfect etc.
For Any word processor package award 1 mark (max = 2mks).
- (a) e- banking is the use of computerised systems in processing of customer transaction, cheque clearance and processing, electronic funds transfer and other related activitiesP 1
e- learning is a process where lessons and lecturers are presented from a central site and the presentation is transmitted to remote conference terminals or displayed on TV screens, or even through the internet
(b) List three factors to be considered when purchasing a microcomputer (3 mks)
- Type of processor
- Processing speed
- Amount of main memory (RAM)
- Storage capacity of the hard disk
- Cost of the computer
- Speed of output devices
- Number of users who can access the computers at the same time
- (a) Identify three advantages of using computers in banking (3 mks)
- Speed and accuracy
- Easy to access information
- Easy to update records
- Requires less space for storage
- Improves data security and privacy
(b) Define the term ‘ computer laboratory’ ( 2mks)
- A computer laboratory is a room that has been specially prepared to facilitate installation of computers, and provide a safe conducive environment for teaching & learning of Computer studies.
(c) List down three safety precautions one should observe when entering a computer laboratory
- Avoid smoking or exposing computers to dust
- Avoid carrying foods & drinks/ beverages to the computer room
- Avoid unnecessary movements as you may accidentally knock the peripheral devices
- Only authorized people should enter the computer room
- Computers users should be trained on how to use computers frequently
- Computer illiterates should not be allowed to operate the computers
- collect any waste papers which might be lying in the computer room & put them into the dustbin
- Shut the door of the computer room properly
(d) List down four functions of the uninterruptible Power Supply (UPS) (4 mks)
- It prevents sudden power surges that might destroy the computer
- It supplies power to the Computer during blackouts and brownouts
- It provides stable (clean) power supply
- Alerts the user of power loss (by beeping)
- Allows the user to save his/ her work, and switch off the system using the correct
- (a) Explain each of the following computer terminogies as used in data representation.
i) bit - The smallest binary unit, ‘0’ or ‘1’
ii) Byte - A group/collection of 8 bits used to represent a character.
iii) Nibble - a group of four binary digits usually representing a numeric value.
iv) word - The total number of bits that a single register of a particular machine can hold
b) Convert 57.410 to its Octal equivalent (2mks)
0.2 x 8 = 1.6 → 1 = 0.318
c) Perform the following Binary arithmetic:
i) 11100111 + 00101110 (1mk)
(1) 00010101 = 1000101012 (1 mk)
ii) 101012 – 110+2 (1mk)