br Home » computer studies paper 1

computer studies paper 1

[pl_row] [pl_col col=12] [pl_text]

Name…………………………………………………………………  Index No…………………/………

School:  ………………………………………SCHOOL          Candidate’s signature………….

                                                                                                                Date………………………………..

451/1

COMPUTER STUDIES

Paper 1

(THEORY)

JUNE 2015

FORM FOUR MID TERM EXAM

Time 2 ½ HOURS

Kenya Certificate of Secondary Education (K.C.S.E)

INSTRUCTIONS TO CANDIDATES

  1. Write your name, school and index number in the spaces provided above.
  2. Sign and write date of examination in the spaces provided above.
  3. This paper consists of TWO sections A and B.
  4. Answer ALL questions in section A.
  5. Answer question 16 and any THREE questions from section B
  6. ALL answers should be written on spaces provided on the question paper
  7. This paper consists of 12 printed pages
  8. Candidates should check the question paper to ascertain that all pages are printed as indicated and that no questions are missing.

FOR EXAMINERS USE ONLY

SECTION QUESTION  
A 1 – 15  
    B 16  
17  
18  
19  
20  
  TOTAL MARKS  

This paper consists of 12 printed pages.

Candidates should check the question paper to ensure that all

pages are printed as indicated  and no questions are missing

SECTION A (40 MARKS)

Attempt ALL questions from this section

I.          a)         Describe the term primary memory                                                                         (1mark)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

(b)        Give two examples of volatile memory                                                                     (1 mark)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

2.         A company uses CAD package to design houses.

(a)        State what the letters CAD stand for                                                                                     (1 mark)

………………………………………………………………………………………………………………….

(b)        Explain two ways in which CAD may benefit the company                                                 (2 marks)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

3.         (a)        Explain the difference between data security and data privacy                                 (1 mark)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

(b)        Who is a hacker?                                                                                                         (1 mark)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

…………………………………………………………………………………………………………………

4.         A computing company has several PCs attached to a network in an office building. The manager would like to add Internet access for all PCs.

(a)        State two items of hardware that would be needed to connect the network of PCs to the Internet                                                                                                                         (1 mark)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

 (b)       the manager is concerned that employees may access inappropriate material on the Internet. Explain two ways how this can be prevented                                                  (2 marks)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

5.         Explain the significance of the following disk management activities;

(a) Disk compression                                                                                                               (1 mark)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

(b) Disk clean up                                                                                                                     (1 mark)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

6.         For each of the following computer professionals, state two roles they may perform in an organization.

(a)        Software engineer                                                                                                       (2 marks)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

(b)        Computer programmer                                                                                                (2 marks)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

7.         (a)        Differentiate between special purpose and embedded computers, giving an example of each

(2 marks)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

(b)        Give two reasons why solid state storage media are being preferred today.            (1 mark)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

8.         Kitale Club placed an order for pool game requirements. Part of the order is shown below:

  A B C D E
1 VAT 20%      
2          
3 Item Price ($) VAT Number Cost
4 Cue stick 470   5  
5 Balls 400   3  
7 Table 2510   2  
8          

(a)        A formula using both types of cell reference is to be entered in cell C4 to calculate the amount of VAT. Write down the formula                                                                                   (1 mark)

…………………………………………………………………………………………………………………

(b)        Write an expression that would be used to calculate the amount spent of cue sticks (2 marks)

…………………………………………………………………………………………………………………..

9.         State two areas where virtual reality is used.                                                                          (1 mark)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

10.       Employees such as data input staff, who use computers for long periods each day, are in the danger of damaging their health.

(a)        State two damaging effects that might arise from extensive use of computers         (1 mark)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

(b)        For each of the effects stated in 10(a) above, state one measure that the employer could take to reduce the risk of damage to employees                                                                     (2 marks)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

11.       (a)        Explain the term real time processing                                                                         (1 mark)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

…………………………………………………………………………………………………………………

(b)        State two applications of real-time processing                                                           (1 mark)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

(c)        In which situation would you prefer batch over real time processing?                      (1 mark)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

12.       (a)       State two types of power protection devices often used in a computer laboratory   (I mark)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

(b)        For each of the above named devices, state the nature of protection they offer       (1 mark)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

13.       GUI uses windows, icons, menus and pointers. State what each of these is and give an example of each.                                                                                                                                      (4 marks)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

14.       Kimani was instructed by this teacher, while typing a Microsoft Word document, to replace all the occurrences of the word Ms with Microsoft. Highlight the steps to do this                          (3 marks)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

15.       Explain the purpose of program compilation before testing                                                   ( 2marks) ……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

SECTION B (60 MARKS)

Attempt question 16 and any OTHER THREE questions

16.       (a)        Draw a flowchart to compute the result of the formula:

                              Where m =0                                                                                          (5marks)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

 (b)       Write a pseudocode that would be used to solve the problem above                       (4 marks)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

(c)        Define the following terms

i)          Pseudocode                                                                                                     (1 mark)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

ii)         Algorithm                                                                                                        (1 mark)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

(d)       State four advantages of structured programming                                                     (4 marks)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

17.       (a)        Compute the values of X in the following expressions:

i)          24.3510 = x2                                                                                         (3 marks)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

ii)         6A13H =X10                                                                                         (2 marks)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

iii) 7468 = XH                                                                                                   (3 marks)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

(b)        Using two’s complement compute the following:

(+36)10 + (-25)10                                                                                                                                              (5 marks)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

(c)        Perform the following binary arithmetic, giving your answer in decimal notation;

11101.11 +111.011                                                                                         (2 marks)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

18.       The rock band, Bubble Spiders has a large fan club run by the band’s manager. A database is to be used to store the details of the members of the fun club. Part of the database file is shown below

MemberID LastName FirstName HouseNo PostCode FeePaid DateJoined
PS0025 Amos James 56 00100 Y 26/01/2009
PS0030 Okoth Mike 11 00032 Y 07/02/2009
PS0003 Jane Anne 3 00001 Y 03/11/2008
PS0017 Wairimu Grace 56 00180 Y 05/01/2009
PS0018 Jelimo Pauline 17 00420 Y 04/01/2009
PS0012 Wasike John 123 06006 Y 29/12/2008
PS009 Njuguna Peter 56 32456 Y 18/12/2018
PS0032 Mudavadi Silas  19 41000 N 11/02/2009
PS0020 Kimani Andrew 5 30200 N 14/01/2009
PS0024 Wanja Mercy 33 80008 Y 26/01/2009

(a)        Give the most appropriate data type for the following fields;                                   (4 marks)

i)          MemberlD

……………………………………………………………………………………………………………………

ii)         PostCode

……………………………………………………………………………………………………………………

iii)        FeePaid

…………………………………………………………………………………………………………………

iv)        DateJoined

……………………………………………………………………………………………………………………

(b)        With reason, state the most appropriate key field                                                      (2 marks)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

(c)        which field can be an appropriate primary key.

                                                            (1 mark)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

ii)         Explain how to set a primary key.                                          (2 marks)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

(d)       Design a query that can be used to return details of members who joined in 2009   (3 marks)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

(e)        Giving reason, state the type of database used to hold the above records                 (2 marks)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

(f)        The database above was certainly created using a database management system.

Explain what is meant by database management system                                           (1 mark)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

19.       When a system analyst is given a problem, the solution is developed in a number of stages. Two of the stages are design and analysis;

(a)        List three other stages                                                                                                (3 marks)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

(b)        State three tasks that will be completed in the analysis stage                                    (3 marks)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

(c)        Describe three design tools available to a systems developer                                    (3 marks)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

(d)       Apart from the design stage, system analyst decides on the software package that will help solve the problem. State three software options available                                                                    (3 marks)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

(e)        (i)         Explain the term system changeover.                                                             (1 mark)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

(ii)        By providing relevant reason(s) state the most suitable changeover strategy that could be applied in moving from manual to electronic exam processing system          (2 marks)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

20.       In a busy local office of a large motoring insurance company, there are ten workstations linked to each other by a LAN. The system is controlled by a powerful file server itli a hard disk of 300 GB which is accessible by all workstations. The file server has also a tape streamer attached to it. Each workstation has its own dot matrix printer and there arc two laser printers linked to the network. Word processing software capable of mail merging and with spell check facility is also installed in the network.

(a)        What is meant by the term LAN?                                                                               (1 mark)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

(b)        Apart from the file server, name two other server types that the insurance firm is likely to acquire in future                                                                                                  (2 marks)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

…………………………………………………………………………………………………………………

(c)        The file server has 300 GB HDD. Give three advantages of using the hard disk as a storage medium                                                                                                                        (3 marks)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

(d)       Give one weakness of most  manual system as compared to computerized ones                                                                                                                                              (I mark)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

(e)        The spell cheek facility will support two types of dictionaries. Briefly explain the salient features of these dictionaries                                                                                            (2 marks)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

(f)        Give two disadvantages of each of the following printers:                                       (4 marks)

i)          Do matrix

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

ii)         Laser printer

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

(g)        By giving one advantage and one limitation, make a choice of the network topology you will recommend to this motoring insurance company.                                                      (2 marks)

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………

END  
[/pl_text] [/pl_col] [/pl_row]