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

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.

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

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