COMPUTER STUDIES PAPER 2 - KAPSABET BOYS 2019 TRIAL MOCK EXAMINATION

Share via Whatsapp
Download PDF for future reference Join our whatsapp group for latest updates

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;

    CAPENTER _ID

    CAPENTER NAME

     

    CUSTOMER _ID

    CUSTOMER NAME

    CAP_001

    JAMES

     

    CUST_01

    MARY K.

    CAP_002

    JOHN

     

    CUST_02

    DIANA K.

    CAP_003

    ALEX

     

    CUST_03

    ALEX N.

    CAP_004

    ISAAC

     

    CUST_04

    MARTHA K.

    CAP_005

    MAURICE

     

    CUST_05

    SARAH W.


    Order TableCarpenter Table                                                                 Customer Table

    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

    (1mk)
    1.  
      1. Using database application package, create a database file named;
      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 (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 asmark 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

 

1mk

 

ii)

Carpenter Table

Customer Table

Order Table

Availability of all field names@½mk

Correct data types @½mk

5mks

5mks

 

iii)

Carpenter Table

Customer Table

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

2mks

 

iv)

Relationship

Correct llinks@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

4mks

 

ii)

Total income Query

Correct formulae 3mks

Correct output 3mks

6mks

 

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>

4mks

 

QUESTION 2

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

  1. Subject totals using a function/formula ½*5
  2. Total marks per stream                ½ *10
  3. Mean mark for each student       ½ *10
  4. Ranking for every student           ½ *10
  5. Presence of a column chart          1mks
    Correct content                                 1mks
    Labeling x-axis                                  1mks
    Y-axis                                                  1mks
    Legend                                               1mks
    Title                                                    1mks
    Different sheet                                  1mks
  6. Sorting of records subtotals        5mks
  7. Average using subtotals       YZ*10
  8. Printing the three sheets

 

 


Download COMPUTER STUDIES PAPER 2 - KAPSABET BOYS 2019 TRIAL MOCK EXAMINATION.


Tap Here to Download for 50/-


Read 971 times Last modified on Wednesday, 21 October 2020 14:10

Leave a comment

Make sure you enter all the required information, indicated by an asterisk (*). HTML code is not allowed.

Print PDF for future reference