Categories
Computer

Maranda Computer studies past papers

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

School…………………………………………………………………Candidate’s signature………….

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

451/2

COMPUTER STUDIES

Paper 2

(PRACTICAL)

July / August 2012

Time 2 ½ HOURS

MARANDA POST MOCK- 2012

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

451/2

COMPUTER STUDIES

Paper 2

(PRACTICAL)

July / August 2012

Time 2 ½ HOURS

INSTRUCTIONS TO CANDIDATES

1.         Type your name, school and index number at the top right hand corner of each printout

2.         Sign and write date of examination in the spaces provided above

3.         Write your name and index number on the removable storage medium

4.         Passwords should not be used while saving on the removable storage

5.         Answer ALL questions

6.         All questions carry equal marks

7.         ALL answers MUST be saved in the removable storage

8.         Make a printout of the answer sheets provided

9.         Hand in all the printout at the removable storage.

This paper consists of 8 printed pages.

Candidates should check the question paper to ensure that all

pages are printed as indicated and no questions are missing

1.         The following data is an extract of data obtained from Chai company records. Study the data and answer the questions that follow.

Area Producer id Name Quantity delivered (kg) Gross pay Transport cost Deduction Net pay
101B 115 John Kamau 4562        
79A 145 Mathew B 1254        
79A 012 Kanuga Symon 235        
79A 561 Ann Wangige 8954        
101B 016 Joseph Kaitano 9658        
20Z 123 Namachanja Esther 7895        
20Z 458 Kerobo Betty 456        
101B 654 Flo Ngina 421        
20Z 758 Mary Nguriareng’ 7895        

a)         Enter the data shown above into a spreadsheet giving it an appropriate title centre and bolded across the worksheet. Save the workbook as CHAT 001. And rename the worksheet as June records                                                                                                                   (10 marks)

b)         Copy the data to a new worksheet and add the details of producer James Kirega of area 1O1B, id 452 with quantity of produce of 2,700kg in an appropriate row.                               (1 mark)

c)         Insert borders after every cell and every row.                                                                        (2marks)

d)         Use a function to calculate the gross pay for the producer with id number 115 given that the price per KG of the produce is Sh.41 .00                                                                      (2 marks)

e)         Use the formula for gross pay obtained for producer John Kamau to calculate the gross pay for all the farmers                                                                                                            (2 marks)

f)         Use if function to Calculate transport cost for all the producers given that transport is charged per Kg is as follows                                                                                                    (5 marks)

AREA Price per kg
101B 5.00
20Z 3.50
 79A 4.00

g)         Insert the value 20% in cell E14. Using absolute cell referencing calculate Deductions given that the deduction is 20% of the cost.                                                                         (4 marks)

h)         Using a function calculate the net pay given that Net pay is Gross pay — deductions and transport cost                                                                                                                  (4marks)

i)          Format the columns containing currency values to currency with 2 decimal places and prefix Ksh. Rename the worksheet PRODUCE PAY and save it as CHAI 002                         (3marks)

j)          Arrange the records in ascending order of the producer id                                         (2 marks)

k)         By applying suitable filter condition, display records for all producers except those from area 79A. Save it as CHAT 003                                                                                      (4 marks)

1)         Use subtotals function to calculate subtotals for the quantity delivered, gross pay and net pay from each area.                                                                                                        (3 marks)

m)        Create an embedded pie chart showing the total quantity of produce delivered for each area the chart should have the following details.)

a.         Chart title Area Total produce delivered

b.         Legend Position Right

Save it as CHART 1                                                                                       (5marks)

n)         Print CHAT 001, CHAI 002, and CHART 1 in landscape orientation.                   (3 marks)

2.         TechBit Computer College and Consultancy centre have set up a special advertising campaign to market its course. As a DTP expert, you have been appointed to assist the marketing team in designing a brochure. The rear page of the brochure is given in the next sheet

The fonts, borders and graphics used should be relevant to the publication as may be available in your software

(a)        Prepare a publication with the following specifications:

i)          Paper size set to A, landscape                                                                                     (2 marks)

ii)         Set margins to 10mm (0.4”) all round                                                                         (2 marks)

iii)        Set the publication to be in three columns measuring 88mm, 84mm and 93mm respectively

 (2 marks)

iv)        Set the space between columns to 6mm                                                                     (2 marks)

(b)        Key in the text as shown in columns 1-3 in the sample provided. Save your work as

sample 1                                                                                                                      (8 marks)

(c)        In column (title pane), format the various items as follows:

i)          Set the transparency of the fill colour to 25%                                                (2 marks)

ii)         Bold and italicize the mission statement heading                                           (2 marks)

iii)        Italicize and centre the mission statement                                                     (2 marks)

iv)        Set the vertical alignment of the text box bearing the words The Best College for You to middle                                                                                                 (1 mark)

v)         Apply blue and green fill to stars on your left and right respectively as shown in the sample                                                                                                             (3 marks)

vi)        Place the clipart and word art appropriately as shown in column 3 of the sample.

 (4 marks)

vii)       Save your work as sample 2                                                                            (1 mark)

(d)       In column I (Liaison offices), format the text as follows;

i)          Apply shadow to the title Liaison Offices and set the font size to 20           (2 marks)

ii)         Apply double underline to each of the telephone numbers                            (2 marks)

iii)        Set the colour of the names of the buildings to blue                                      (2 marks)

iv)        Insert the footer: Registration and enquiries at our head office                      (1 mark)

v)         Apply blue outline to the textbox bearing the title Liaison Offices             (1 mark)

(e)        Create a mailing coupon as it appears in column 2                                                     (2 marks)

(f)        Format the mailing coupon as follows:

i)          Bolden and centre the address as shown in the sample                                  (2 marks)

ii)         Draw and enter Place stamp here caption at the top right corner                 (2 marks)

iii)        Save your work as sample 3                                                                            (1 mark)

(g)        Print Sample 1, Sample2 and Sample 3                                                                      (3 marks)

END  
Categories
Computer

Best computer studies paper 2

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

School:                SEC 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