COMPUTER - FORM 3 END TERM 1 EXAMS 2020

SECTION A (40 MARKS)

Answer all the questions in space provided.

1. List 4 hardware components that form a complete computer system. (2mks)
2. What do you understand by the term ‘Disk initializing’? (1mks)
3. Draw an illustration of:
   a)   Parallel cable                       (1mk)
   b)   USB port                              (1mk)
4. Explain the three parts of a task bar       (3mks)
5. Name three examples of flat-panel monitors available in market today.    (3mks)
6. List four number systems that the design and organization of a computer may depend on.     (4mks)
7. Explain the meaning of the following terms as used in computer communication          (2mks)
   a)  Modulation
   b)  Demodulation
8. Explain the 3 factors used to classify operating systems.   (3mks)
9. By using two compliment work out 31₁₀ - 17₁₀ in binary form. Show your calculations clearly.   (2mks)
10. What is the meaning of the following as used in word-processing:  (2mks)
    1. Word wrap
    2. Drop caps                                                                                                                  
11. Using the long division method convert 45₁₀ into binary.        (1mks)
12. 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)
13. a) Name four database models.     (2mks)
    b) State the work/function of the following field properties if set:     (2mks)
    1. Format
    2. Default value
14. (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)
15. In electronic mailing (e-mail), what do the following domain refer to in an e-mail address. (2mks)
    e.g. – Oketchjunior@yahoo.com
    • edu
    • org
    • gov
    • com
16. Define the word protocol.   (1mk)

SECTION B (60 Marks)

Answer question 16 and any other TWO Questions.

17. 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.
    1.            
       (2mks)
    2.              
       (2mks)
    3.              
       (2mks)
    4.  Esc       (2mks)
18. (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
    =A56*B5
    =A$5
    =4*B$6

    (d) 
    
    1. Explain the concept of distributed databases.    (2mks)
    2. State two advantages of distributed databases.  (2mks)
    (e) Outline two uses of forms in database design. (2mks)
    (f) List any two-word processor software.   (2mks)

19. (a) Explain how computers are used in the following areas:     (6mks)
    1. Law enforcement
    2. Banking
    3. A library
    (b) List three factors to be considered when purchasing a microcomputer     (3mks)

20. (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)
21. (a) Explain each of the following computer terminologies as used in data representation. (4mks)
    1. bit -
    2.  Byte    
    3. Nibble -
    4. word   -
    (b) Convert 57.4₁₀ to its Octal equivalent (2mks)
    (c) Perform the following Binary arithmetic:
    1. 11100111 + 00101110                (1mk)
    2. 10101₂ – 110₂        (2mks)     

MARKING SCHEME

SECTION A. ( 40 MKS)

1. - Input devices
   - Output devices
   - Processing devices
   - Storage devices
   - Connecting devices                                                          
2. This is the preparing of a disk to store information / data (1mk)                              
3.  
   
4. 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
5. LCD – Liquid crystal display
   EL – Electro Luminescent
   Gas – plasma
   TFT – Thin film transistor
6. - Hexadecimal  - Octals  -Decimal –Binary   (Each 1 mk x 4 = 4mks
7. a) Changing of the digital data to analog data.
   b) Changing of the analog data back to digital data.                                         
8. - 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
9.  
   

10. 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.                        
11.  
                    

12. 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)
13. a) 
    • 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.                                      
14.  
    1. - Adobe Page Maker
       - Corel Draw
       - Microsoft Publisher
       - Ventura                                                                                  
    2. 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.

15. - .edu – Educational institutional
    - .org- Non – profit making organization
    - .gov- Government institution
    -.co- Commercial institution.                                           

16. A set of rules that govern how two computers can send and receive data on the network.
17. a)- Pointing
    - Clicking
    - 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           
18. (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)
    (c)
    

    FORMULA IN C:10	FORMULA IN F:15
    = A5*B5	= D10 * E10
    = A $ 5	= D $ 5
    = 4 * B $ 6	=4 * E $ 6

    (d) (i) This is where database is created for different departments in organizations in different computers that are networked                        (2mks)
    (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
    - WordStar
    - word perfect etc.
    For Any word processor package award  1 mark             (max = 2mks).               

19. (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

20. (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

21. (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.4₁₀ to its Octal equivalent                                     (2mks)
    

    8	57	Rem
    8	7	1
    8	7	1
    2	7	7

    0.4 x 8 = 3.2 → 3
    0.2 x 8 = 1.6 → 1 = 0.31₈
    =71₈                         71.31₈
    c) Perform the following Binary arithmetic:
    i)   11100111 + 00101110    (1mk)
    
    11100111
    00101110 +
    (1) 00010101    = 100010101₂      (1 mk)
    
    ii)    10101₂ – 110+2         (1mk)
    
    10101₂
        110₂
      1111₂