Computer Studies Paper 2 Questions and Answers - Kapsabet Pre Mock Exams 2021/2022

Share via Whatsapp

COMPUTER STUDIES
PAPER 2

INSTRUCTIONS TO CANDIDATES

  • Type your name and admission number at the top right hand corner of each printout.
  • Write the name and version of the software used for each question attempted in the answer sheet.
  • Passwords should not be used while saving in the diskettes.
  • Answer all questions
  • All questions carry equal marks
  • All answers must be saved in your diskette. Make printouts of the answers on the answer sheets provided.
  • Hand in all the printout and the diskette
  • Candidates may be penalized for not following instruction given in this pager
  • Arrange your printout and staple them together.

QUESTION 1

  1. Table 1, table 2 and table 3 are extracts of records, kept in a carpentry shop. Use the information to answer the questions that follow;
    Carpenter Table
    CAPENTER _ID CAPENTER NAME
    CAP_001  JAMES
    CAP_002  JOHN
    CAP_003  ALEX
    CAP_004  ISAAC
    CAP_005 MAURICE

    Customer Table
    CUSTOMER_ID CUSTOMER NAME
    CUST_01  MARY K.
    CUST_02  DIANA K.
    CUST_03 ALEX N.
    CUST_04 MARTHA K.
    CUST_05 SARAH W.
    CUST_06 JOHNSON G.

    Order Table
    CUST_01​
    CARPENTER _ID CUSTOMER _ID ORDER _NO ITEM ORDERED MONTH AMOUNT
    CAP_001 CUST_01 1721 Bench January 18 000
    CAP_002 CUST_02 1722 Coffee Table January 25 000
    CAP_003 CUST_03 1723 Office table January 10 000
    CAP_004 CUST_04 1724 Single bed January 18 000
    CAP_005 CUST_05 1725 Arm chair January  60 000
    CAP_001 CUST_01 1726 Double bed February 75 000 
    CAP_002 CUST_04 1727 Dining table February 85 000
    CAP_004 CUST_03 1728 Arm Chair February 60 000
    CAP_001 CUST_02 1729 Double decker bed February 72 000
    CAP_002 CUST_06 1730 Kitchen table February 82 000
    CAP_004 CUST_02 1731 Bench March 18 000
    CAP_003 CUST_06 1732 Bench March 18 000

    1.                  
      1. Using database application package, create a database file named;
        CARPENTERINFORMATION (1mk)
      2. Create three tables named Carpenter Table, Customer Table and Order Table that will be used to store the above data. (10mks)
      3. Set the primary key for the tables (2mks)
      4. Create relationship among the tables (2mks)
    2.        
      1. Create a data entry form for each table (3mks)
      2. Enter the data in Carpenter Table, Customer Table and Order Table respectively(11mks)
    3.       
      1. Create a query named individual income to display the amount received from each customer every month. (4mks)
      2. Create a database object that computers Total income for each month. Save the query as Totalincomenomnthly. (6mks)
    4. Create a query named loyalty to compute the total number of orders made by each customer over the three months. (3mks)
    5. Create a report to display order details, save the report as Order report (4mks)
    6. Print the three tables and the report (4mks)

QUESTION 2
Use a spreadsheet to manipulate data in the table below.

Adm No Name Stream Comp Art Bus Eng Mat Student mean Rank
C001 Barasa H 56  45  36  56  26    
C002 Wangila K 58 57  90  54  23    
C003 Wafula H 48  56  54  45  25    
C004 Wanjala K 78 95 78 46 24    
C005 Kerubo H 49  86  68  35  52    
C006 Akinyi K 56  45  25  63  54    
C007 Odhiambo H 75 78 45 65 56    
C008 Okunyuku K 89 69 65 53 51    
C009  Nekesa H 69  58 45 54 52    
C010 Simiyu H 85 46 78 52 53    
  TOTAL                
  TOTAL FOR H              
  TOTAL FOR K              

 

  1.  Enter the data in all bordered worksheet and auto fit all column. Save the workbook as mark 1 (15mks)
  2. Find the total marks for each subject (3mks)
  3. Find total for each subject per stream using a function (5mks)
  4. Find mean mark for each student using a function (5mks)
  5. Rank mean student in descending order using the mean (5mks)
  6. Create a well labeled column chart on a different sheet to show the mean mark of every student. Save the workbook as mark 2. (7mks)
  7. Using mark1, use subtotals to find the average mark for each subject per stream. Save the workbook as mark 3 (7mks)
  8. Print mark 1,mark 2 and the chart

MARKING SCHEME

QUESTION 1

        Mark
Allocation
Score
A i CARPENTERINFORMATION   1 mk  
  ii Carpenter Table
Customer Table
Order Table
Availability of all
field names @ 1/2mk
Correct data type @ 1/2mk

 

5 mks
5 mks

 
  iii Carpenter Table
Customer Table

 

One primary key on each of
the two table @1mk

 

2mks

 
  iv Relationship Correct links @ 1 2mks  
B i  Entry form for the three tables @1mk 3mks  
  ii Data entry Award 1mk for any two
correct records
11mks  
C i Individual income query Correct formulae 2mks
Correct output 2mks
4 mks  
  ii Total income query Correct formulae 3mks
Correct output 3 mks
6 mks  
  iii Loyalty query Correct formulae 2mks
Correct output 1mk
3mks  
E   Order report   1mk  
F   Order table macro   3mks  
G   Print outs Print out @ 1mk 4 mks  

 

QUESTION 2

  1. Presence of workbook 1mks
    Correctly saved (correct name) 1mks
    10 records correctly entered (5) ½*10 5mks
    Auto fit columns @1/2*10 5mks
    Presence of borders 3mks
  2. Subject totals using a function/formula ½*5
  3. Total marks per stream ½ *10
  4. Mean mark for each student ½ *10
  5. Ranking for every student ½ *10
  6. Presence of a column chart 1mks

    • Correct content 1mks
    • Labeling x-axis 1mks
    • Y-axis 1mks
    • Legend 1mks
    • Title 1mks
    • Different sheet 1mks
  7. Sorting of records subtotals 5mks
    • Average using subtotals Y Z *10
  8. Printing the three sheets
  9. TOTAL 

Download Computer Studies Paper 2 Questions and Answers - Kapsabet Pre Mock Exams 2021/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