COMPUTER - FORM 3 END TERM 1 EXAMS 2020

Share via Whatsapp

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 3110 - 1710 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 4510 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.

  1. 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.            
      comp17ci(2mks)
    2.              
      comp17cii(2mks)
    3.              
      comp17ciii(2mks)
    4.  Esc       (2mks)
  2. (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)
  1. (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)
  1. (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)
  2. (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.410 to its Octal equivalent (2mks)
    (c) Perform the following Binary arithmetic:
    1. 11100111 + 00101110                (1mk)
    2. 101012 – 1102        (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.  
    compans3
  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.  
    compans9
  1. 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.                        
  2.  
    compans11                
  1. 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)
  2. 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.                                      
  3.  
    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.
  1. - .edu – Educational institutional
    - .org- Non – profit making organization
    - .gov- Government institution
    -.co- Commercial institution.                                           
  1. A set of rules that govern how two computers can send and receive data on the network.
  2. 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           
  3. (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).               
  1. (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
  1. (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
  1. (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)

    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.318
    =718                         71.318
    c) Perform the following Binary arithmetic:
    i)   11100111 + 00101110    (1mk)

    11100111
    00101110 +
    (1) 00010101    = 1000101012      (1 mk)

    ii)    101012 – 110+2         (1mk)

    101012
        1102
      11112



Download COMPUTER - FORM 3 END TERM 1 EXAMS 2020.


Tap Here to Download for 50/-




Why download?

  • ✔ To read offline at any time.
  • ✔ To Print at your convenience
  • ✔ Share Easily with Friends / Students


Join our whatsapp group for latest updates
Read 3581 times Last modified on Thursday, 06 February 2020 13:48
.
Subscribe now

access all the content at an affordable rate
or
Buy any individual paper or notes as a pdf via MPESA
and get it sent to you via WhatsApp

 

What does our community say about us?

Join our community on:

  • easyelimu app
  • Telegram
  • facebook page
  • twitter page
  • Pinterest