COMPUTER PAPER 2 - KCSE 2019 JOINT PRE MOCK EXAMINATION NAMBALE

« Previous Topic
COMPUTER PAPER 1 - KCSE 2019 JOINT PRE MOCK EXAMINATION NAMBALE

Next Topic »
BUSINESS STUDIES PAPER 1 - KCSE 2019 JOINT PRE MOCK EXAMINATION NAMBALE

Download PDF for future reference Get on Whatsapp for 50/-

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:

Enter the data in a worksheet and save it as CD-R: \FutureTec. (16 marks)
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)
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)
Sort the worksheet in ascending order according to category. (2 marks)
Calculate the subtotals and grand total for the three types of electronic goods. (6 marks)
On a separate sheet, create a bar graph that compares sales for the three types of electronic goods. Label it appropriately. (6 marks)
Print the worksheet showing all formulae used instead of values and the graph. (4 marks)

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)