QUESTION 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
-
- Using database application package, create a database file named;
- Create three tables named Carpenter Table, Customer Table and Order Table that will be used to store the above data. (10mks)
- Set the primary key for the tables (2mks)
- Create relationship among the tables (2mks)
-
- Create a data entry form for each table (3mks)
- Enter the data in Carpenter Table, Customer Table and Order Table respectively (11mks)
-
- Create a query named individual income to display the amount received from each customer every month. (4mks)
- Create a database object that computers Total income for each month. Save the query as (6mks)
- Create a query named loyalty to compute the total number of orders made by each customer over the three months. (3mks)
- Create a report to display order details, save the report as Order report (4mks)
- 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 |
- Enter the data in all bordered worksheet and auto fit all column. Save the workbook asmark 1 (15mks)
- Find the total marks for each subject (3mks)
- Find total for each subject per stream using a function (5mks)
- Find mean mark for each student using a function (5mks)
- Rank mean student in descending order using the mean (5mks)
- 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)
- Using mark1, use subtotals to find the average mark for each subject per stream. Save the workbook as mark 3 (7mks)
- 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
- Subject totals using a function/formula ½*5
- Total marks per stream ½ *10
- Mean mark for each student ½ *10
- Ranking for every student ½ *10
- Presence of a column chart 1mks
Correct content 1mks
Labeling x-axis 1mks
Y-axis 1mks
Legend 1mks
Title 1mks
Different sheet 1mks - Sorting of records subtotals 5mks
- Average using subtotals YZ*10
- Printing the three sheets
Download COMPUTER STUDIES PAPER 2 - KAPSABET BOYS 2019 TRIAL MOCK EXAMINATION.
Tap Here to Download for 50/-
Get on WhatsApp for 50/-
Why download?
- ✔ To read offline at any time.
- ✔ To Print at your convenience
- ✔ Share Easily with Friends / Students