Computer Studies Paper 2 Questions and Answers - Moi Kabarak High School Mock 2020/2021

INSTRUCTIONS TO CANDIDATES

• Passwords should not be used while saving in the compact disks
• Answer all the questions
• All questions carry equal marks
• All answers must be saved in your compact disks
• Make a printout of the answers on the answer sheets provided
• Hand in all the printouts and the compact disks

QUESTION 1
2020 PAVEMENT PUBLISHERS
"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;

1. Carpenter Table
   

   CAPENTER_ID	CAPENTER NAME
   CAP_001	JAMES ALUSA
   CAP_002	JOHN KANYO
   CAP_003	ALEX MUYA
   CAP_004	ISAAC WESA
   CAP_005	MAURICE NDEYO

2. Customer Table
   

   CUSTOMER_ID	CUSTOMER NAME
   CUST_01	MARY KHASANDI
   CUST_02	DIANA KHAYANGA
   CUST_03	ALEX NYUMBILA
   CUST_04	MARTHA KHAOYA
   CUST_05	SARAH WAFULA
   CUST_06	JOHMSOM LUVAHA

3. Order 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

   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)
   3. Enter the data in Carpenter Table, Customer Table and Orde Table respectively  (11mks)
   4.  
      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 Totalincomemonthly.    (6 mks)
   5. Create a query named loyalty to compute the total number of orders made by each customer over the three months.     (3mks)
   6. Create a report to display order details, save the report as Order report    (4mks)
   7. 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      (5 mks)
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)      
   Print mark 1,mark 2 and the chart        (3mks)