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
- 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_01CARPENTER _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;
CARPENTERINFORMATION (1mk) - 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)
- Using database application package, create a database file named;
-
- 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 Totalincomenomnthly. (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 as mark 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 | 1 mk | ||
ii | Carpenter Table Customer Table Order Table |
Availability of all field names @ 1/2mk Correct data type @ 1/2mk |
5 mks |
||
iii | Carpenter Table Customer Table |
One primary key on each of |
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
- 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 Y Z *10
- Printing the three sheets
- TOTAL
Download Computer Studies Paper 2 Questions and Answers - Kapsabet Pre Mock Exams 2021/2022.
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
Join our whatsapp group for latest updates