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;
- 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 - 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 - 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 -
- 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 Orde 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 Totalincomemonthly. (6 mks)
- 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 | Math | 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 (5 mks)
- 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 (3mks)
Download Computer Studies Paper 2 Questions and Answers - Moi Kabarak High School Mock 2020/2021.
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