COMPUTER PAPER 2 - KCSE 2019 JOINT PRE MOCK EXAMINATION NAMBALE

Share via Whatsapp
  1. FutureTech Company Ltd deals with sales of three types of electronic goods namely television sets, radio systems and DVD players. Below is a table showing details of April 2013 sales.

    FutureTech Company Ltd.

    Sales as per 30th April 2013

    Category Code

    Type

    Item Description

    Unit Price

    Sold

    Sub-Total

    Tax

    Net Amount

    TV001

    TV

    21” LG TV

    16000

    8

         

    TV003

    TV

    38”Samsung TV

    60000

    2

         

    RD001

    Radio

    JVC 3CD Changer

    21000

    12

         

    DV001

    Radio

    Philips DVD

    Player

    5500

    6

         

    TV004

    TV

    14” JVC TV

    11000

    22

         

    DV002

    Radio

    LG DVD Player

    6200

    18

         

    TV005

    TV

    21” Sony TV

    15800

    14

         

    DV003

    DVD

    Sony DVD Player

    4500

    20

         

    RD002

    Radio

    Panasonic Radio

    3200

    30

         

    RD003

    Radio

    Samsung Radio Player

    4700

    8

         

    TV007

    TV

    14” ZEC TV

    8200

    4

         

    DV001

    Radio

    Panasonic DVD Player

    6500

    16

         
                   

    Tax Rates

    TV

    15%

         

    DVD

    12%

         

    Radio

    8%

         

    Required:
    1. Enter the data in a worksheet and save it as CD-R: \FutureTec. (16 marks)
    2. Format the worksheet as follows:
      1. Center the Title across columns. (2 marks)
      2. The text should be Arial, 18 points, bold and centered within a box.    (2 marks)
      3. Column Headings to be wrapped within the cells and centered horizontally and vertically.       (2 marks)
      4. The Unit Price to be in two decimals and currency prefix Ksh. (4 marks)
    3. Use appropriate cell references to calculate:
      1. The Subtotal, rounded to two decimals places. (2 marks)
      2. The TAX is based on the type of the item. Use the rates given in the table above to calculate tax payable on each item sold.              (2 marks)
      3. The Net Amount, which is the subtotal less tax. (2 marks)
    4. Sort the worksheet in ascending order according to category. (2 marks)
    5. Calculate the subtotals and grand total for the three types of electronic goods.      (6 marks)
    6. On a separate sheet, create a bar graph that compares sales for the three types of electronic goods. Label it appropriately.          (6 marks)
    7. Print the worksheet showing all formulae used instead of values and the graph.         (4 marks)
  2.  HIGH SEASONS is a holiday resort firm. It has several branches all over the world. In order to keep track of its employees, a database to organize employee information is required.
    1. Create a database file and save it as SEASONS in the removable storage provided.      (2 marks)
      1. Create a table containing the following fields: (4 marks)
        Field Name                                    Field Type
        EmployeeNo.                                  AutoNumber
        Date of Birth                                  Date/Time
        Grade                                              Text                                                    
      2. Make the field Employee No. the primary key and save the table as
        EMPLOYEES.                                                                                           (3 marks)
    2.  
      1. Create a form based on the EMPLOYEES table and save it as
        EMPLOYEESFORM.                                                                                   (4 marks)
      2. Use the form to enter the records below:                                                  (6 marks)
        EmployeeNo.                   Date_of_Birth            Grade
        1                                  5/15/1960                    G
        2                                  4/28/1978                    H
        3                                  10/30/1972                  R
        4                                  12/5/1975                    H
        5                                  2/28/1974                    G
        6                                  1/3/1970                      G
        7                                  11/24/1956                  H
        8                                  3/10/1984                    G
        9                                  4/4/1956                      S
        10                                  8/11/1964                    R
    3. Modify the EMPLOYEES table by adding two new fields:                         (2 marks)
      Field Name                             Field Type
      Salary(Shs)                              Currency
      Address                                   Text
    4.  
      1. Create another table containing the following fields: (2 marks)
        Field Name                                    Field Type
        HouseID                                         AutoNumber
        Number of Rooms                          Number
        Location                                         Text
        Rent                                                Currency
      2.  
        1. Make the field HouseID the primary key and save the table as HOUSES.( 2 marks)
        2. Create a relationship that enforces referential integrity. (4 marks)
    5.  
      1. Create a query and save it as EMPLOYEESQUERY based on the
        EMPLOYEES table that would display all the employee’s in
        Grade H, R and their salaries.                                                                    (4 marks)
      2. Sort the records in the EMPLOYEESQUERY in alphabetical of
        Grade field.                                                                                               (3 marks)
    6.  
      1. Create a columnar report with portrait orientation from the
        EMPLOYEESQUERY. Save the report as EMPLOYEESREPORT.     (4 marks)
      2. Enter a function to compute the salaries grand total displayed in the report.            (3 marks)
    7. Insert a header EMPLOYEES IN GRADE H AND R in the report having font size 20pts to the left of the page.                                    (2 marks)
    8. Print the EMPLOYEES Table, HOUSES Table, EMPLOYEESFORM, EMPLOYEESQUERY and EMPLOYEESREPORT.                                 (5 marks)

 

Join our whatsapp group for latest updates

Download COMPUTER PAPER 2 - KCSE 2019 JOINT PRE MOCK EXAMINATION NAMBALE.


Tap Here to Download for 50/-




Why download?

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


Get on WhatsApp Download as PDF
.
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