Computer Studies Paper 2 Questions and Answers - Bunamfan Cluster Pre Mock Exam 2022

Share via Whatsapp

Instructions To Candidates

  • Indicate your name and index number at the top right corner of each printout.
  • Write your name and index number on the CD-RW storage medium provided
  • Write the name and version of the software used for each question attempted in the answer sheet.
  • Answer both questions
  • All questions carry equal marks
  • Passwords should not be used while saving in the CD-RW storage medium provided.
  • All answers must be saved in your CD-RW storage medium provided
  • Make a printout of the answers on the answer sheets provided.
  • Arrange your printouts and staple them together.
  • Hand in all the printouts and the CD- RW storage medium used.
  • This paper consists of 5 printed pages.
  • Candidates should check the question paper to ascertain that all the printed pages are printed as indicated and no questions are missing.


Questions

QUESTION 1 - SPREADSHEET
A Company in Mombasa sells computer spare parts to its customers. The Company wishes to work out the pay details for its employees.

EMPLOYEE NAME YEARS
WORKED
BASIC PAY
(KSHS)
DEPARTMENT SALES
(KSHS)
HOURS OF
OVERTIME
Rukenya Kwena  5  24 000  ADMIN  16 000  10
Billy Lucas 13 28 000  SALES  25 000  11
 Lilian Okoth  7  17 000  MARKETING  22 000  12
 Evans Ondieki  11  18 000  SALES  12 000  15
 Geoffrey Mutuma  15  26 000  ACCOUNTS  11 000  22
 Humphrey Loki  10  25 000  ADMIN  30 000  12
 Cedric Mukui  11  19 000  SALES  35 000  33
 Frederick Chege 15 25 000 MARKETING 14 000 14
 Osman Hussein 14 23 000 ADMIN 25 000 0
 Jeremy Nyamu 18 27 000 ACCOUNT 14 000 7

 

  1. Using the information above, design a spreadsheet and enter the given data as it appears. Give it the title “COMPANY PAYMENTS”. Save the workbook file as COMPANY1 (14marks)
  2.        
    1. Copy the data into Sheet 2 and rename it as COMPANY2 and use it to answer the questions that follow (2 marks)
    2. Calculate the total sales and total mileage giving them an appropriate label (2marks)
    3. Rotate the column headings to 45° (2 marks)
    4. The employee's sales commission is calculated as 12% of the employee's sales. Input this commission rate in cell C20 and label it appropriately. Bold the label and change its font to size 16 (4marks)
    5. Insert a new column labeled 'Sales commission' between 'sales' and 'hours of overtime’. (2marks)
    6. Create a formulae to give the amount of sales commission for each employee by making references to sales commission cell. (3marks)
  3.  
    1. Convert the basic pay and sales to two decimal places. (2marks)
    2. Use a function in a new column labeled REMARK to put the remark 'EXCELLENT' for only those employees whose sales is greater than 22,000, ‘GOOD’ those employees whose sales are between 15000 to 21999 otherwise the remark should be ‘LOW SALES. (6marks)
    3. Apply both outline and inside double line border to the worksheet portion with data (3marks)
  4. Overtime payment is done by multiplying 5% of sales with the hours worked. Use a formula to calculate the overtime pay for each of the employees in a new column labeled “OVERTIME PAY” (2marks)
  5. Use a function to compute the Total payment of each employee. It should be summation of Basic pay, Sales Commission and Overtime pay. Give it the heading TOTAL PAYMENT. Save the changes. (2marks)
  6. Use an appropriate subtotals function to show how much TOTAL PAYMENT the company gives to employees in each department (4marks)
  7. Print COMPANY1, COMPANY2 and all the formulas used in company2. (3marks)

QUESTION 2 - DATABASES
Assuming that you have been approached by an automobile Showroom company to help manage their vehicles database whose details are given below:

  1. Create database named Magari (2marks)
    Car Make RegNo Type Year Value Owner ID Owner Name
    Toyota KBD 949U Coupe 2010 1 200 000  M0001 Faith N
    Nissan KCT 149E Wagon 2014 2 500 000 M0002  Jacob W.
    Isuzu KDD 977W Troupe 2016 4 500 000 M0003  Dan C.
    Toyota KBA 241V Troupe 2009  900 000 M0002 Jacob W.
    Toyota KBD 049X Coupe 2010  1 150 000 M0004 Rachel R.
    Nissan KCV 518C Saloon 2012  1 700 000 M0004 Rachel R.
    Subaru KCY 123Z Saloon 2014 2 100 000 M0001 Faith N.
  2. Design two Tables named Cars and Owners to be used to hold the above data. Assign appropriate primary keys for each table. Prepare appropriate input masks to help validate both RegNo and Owner ID field entries (18marks)
  3. Create a relationship between the tables. (2marks)
  4. Create forms named “CarDetails” with a heading and “OwnerDetails”. Use them to add car details and owner details records respectfully. (4marks)
  5. Insert the record below having the following respective details. (4marks)
    Volkswagen KCV 321D Beatle 2012 1 325 000 0002 Jacob W.
  6. Add a column into the car table labeled “Date of Service”, and add the following dates. Save the changes made. (4marks)
    Date of Service OwnerID
    20/09/2021 M0001
    21/10/2021 M0002
    10/10/2021 M0003
    11/10/2021 M0002
    19/11/2021 M0004
    21/10/2021 M0004
    22/11/2021 M0001
  7. Create a query that retrieves a list of cars and their owners to be serviced on 21/10/2021 or on 22/11/2021. Name it Service Query. (5marks)
  8. Create a tabular report named NumbOfCars displaying the cars and their owners; indicating the number of cars each owner has; sort the records with Name in ascending order. (6marks)
  9. Create a report named TotalValue Report that computes and displays the total value of the cars owned by each owner. (5marks)
  10. Print
    1. The two tables
    2. The query
    3. The two reports


Marking Scheme

Qns Area Mks
1. a
Each row @1mk. Deny 0.5mrk for each mistake
Correct heading
Bolded heading
Wrapped heading @ 0.5
Correct saving (COMPANY1)
10
1
1
1
1
 b. i.
Copying
Correct name (COMPANY2)
0.5
0.5
 ii.
Label for Total
Correct formula
1
1
iii.
Rotating
Correct selection (all headings)
1
1
 iv.
Inserting 12%
Label 
Bold
Font 16
1
1
1
1
 v.
Inserting
Correct name Sales Commission
1
1
 vi.
Correct formula
Copying
2
1
c. i.
2 Decimal places Basic pay 
2 Decimal places
1
1
ii.
Remark label
Correct If function
Copying
2
3
1
iii.
Outline border
Inside border
Correct selection
1
1
1
d. Correct label OVERTIME PAY
Correct formula
1
1
e.
Total payment label
Formula
1
1
f.
Correct sorting
Correct  grouping
Subtotals
Grand total
1
1
1
1
g.
Printing COMPANY1
Printing COMPANY2
Printing COMPANY2 Formulas
1
1
1
Total marks 50
 
QUESTION 2: DATABASE
Qns Area Mks
2.a Correct database name  2
b.
Each correct fieldname @1mk
Each correct data type @1mk
Correct table names @0.5mk
Correct primary @0.5mk
Correct input masks @1mk
7
7
1
1
2
c.
Correct relationship link
Enforcing referential integrity
1
1
d. Correct forms 4
e. Correct added fields (deny 0.5mk for each mistake) 4
f. Mapping date of service to correct owner (deny 1mk for each mistake)
g.
Correct query name
Each correct criterion/ correct use of or  @2mks 
1
4
h.
Correct report name
All fields needed
No of cars per owner
Sorting
1
1
2
2
i.
Correct report name
Computed total value
Correct grouping per owner
1
2
2
j.
Printing @ table 1mk
Printing query 
Printing @ report 1mk 
2
1
2
Total Marks  50

Download Computer Studies Paper 2 Questions and Answers - Bunamfan Cluster Pre Mock Exam 2022.


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
.
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