Computer Studies P2 Questions and Answers - Butula Sub-County Post Mock Exams 2021/2022

INSTRUCTIONS TO CANDIDATES

• Type your name and index number at the top right hand corner of each printout
• Write your name and index number on the compact disks
• 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 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

QUESTIONS

QUESTION 1:

1. Using a word processor, create the following table as it appears and save it as Table1 (25marks)
   

   ADM NO	NAME	STREAM	COMP	ART	BUS	ENG	MAT	TOTAL MARK	STUDENT MEAN
   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	Okunyuk	K	89	69	65	53	51
   C009	Nekesa	H	69	58	45	54	52
   C010	Simiyu	H	85	46	78	52	53
   TOTAL FOR H
   TOTAL FOR K
   	TOTAL

2. Sort the table’s content by Stream in ascending order (1mark)
3. Merge the cells containing identical streams (1mark)
4. Save the changes made to the table as Edited_Table1 (1mark)
5. Using appropriate formula, determine:-
   • TOTAL MARK (4markS)
   • STUDENT MEAN (4markS)
   • TOTAL FOR STREAM H (4markS)
   • TOTAL FOR STREAM K (4markS)
     TOTAL FOR ALL STREAMS (4markS)
6. Print: (2markS)
   • Table1
   • Edited_Table1

Question 2
The following table contains details of Baharini Girls school (50MARKS)

REQUIRED

1. Create a database file that can be used to store the above data. Name the file Baharini school database. (2mks)
2. Create Three tables, one for student details, Accounts table and dormitory table (11 mks)
3. Create a relationship between the three tables (3mks)
4.  Using appropriate forms, Enter the information given into the three tables (15mks)
5. Create a query for “ all students housed in Chui” (3mks)
6. Design a “current age query”to display current ages of all the students (5mks)
7. Create a report “Hefty Balances” showing students with fees balances of more than 10000kshs (3mks)
8. Create a report to show all students admitted in the school (3mks)
9. Print,Thethreetables,Hefty balances reportand all students housed in Chuireport (5mks)

MARKING SCHEME

Table 2