Computer Studies Paper 2 Questions and Answers - Cekenas Pre Mocks 2022

INSTRUCTIONS TO CANDIDATES

• Type your name and index number at the top hand corner of each printout.
• Write your name and index number of the CD-RW
• Write the name and version of the software used for each question attempted in the answer sheet
• Passwords should not be used while saving the CDs
• Answer all questions
• All questions carry equal marks
• All answers must be saved in your CD
• Make printouts of the answers on the answer sheets provided
• Hand in all the printouts and the CDs
• Arrange your printouts and stable them together
• Candidates may be penalized for not following instructions given in this paper

FOR EXAMINERS USE ONLY

QUESTIONS

1.                              
   1. Using a word processor type the passage below as it appears and save it as Society. (40 marks)
      
      
      
   2. Copy the Society to a new document and save it as Society 2 (2marks)
   3. Change the paragraph starting with “For instance……….“ to bold italic (2 marks)
   4. Look for the word alarming and replace it with the word surprising (3marks)
   5. Using the word count feature count the number of characters with spaces in the passage (2marks)
   6. Insert alphabetical capital letter page numbers at the top left side of the document Society 2 and update all the changes. (2 marks)
   7. Print the two documents Society and Society 2 (2 marks)
2. The tables below, STUDENT, SUPERVISOR and SUPERVISIONS are extracts of records kept in MOKASA UNIVERSIRY for project supervisions.
   

   Student Number	Name	Gender	Project  Fee Paid
   C001	Ken	M	32000
   C002	Joy	F	27800
   C003	Lero	M	18900
   C004	Moth	F	42700
   C005	Ben	M	45000

   Table 1 STUDENTS TABLE
   

   Supervisor Number	Name	Department
   L220	Alex	Mechanical
   L230	Sakaja	ICT
   L240	Roy	Electronics
   L250	Mati	Education
   L260	Joy	Human Resource

   Table 2 SUPERVISOR S’ TABLE
   

   Supervision Number	Supervision Date	Student Number	Supervisor Number	Project Title
   100	12/03/2015	C001	L220	Java
   200	22/03/2015	C003	L230	Website
   300	17/03/2015	C004	L240	Robotics
   400	02/03/2015	C001	L220	Java
   500	18/03/2015	C002	L240	Robotics
   600	12/03/2015	C004	L230	Java
   700	11/03/2015	C002	L250	Database
   800	12/03/2015	C003	L220	Java
   900	12/04/2015	C005	L250	Database
   1100	12/04/2015	C002	L250	Database

   Table 3 SUPERVISIONS TABLE
   1. Using a database application software, create a database file named PROJECT (1mark)
   2. Create three tables named STUDENT, SUPERVISOR and SUPERVISIONS as shown above. (9mks)
   3. Set the primary key for each table. (3mks)
   4. Create relationships among the tables. (3mks)
   5. Enter the data in the table STUDENT, SUPERVISOR and SUPERVISIONS as shown above. (10mks)
   6. Create a form for each table above. (3mks)
   7. Create a query named BALANCE to display student name, Gender, project fee balance per student, given that the total project fee is Ksh.50000. (4mks)
   8. Create a query named BALANCE2 to display students’ Names, project title whose fee balance is above Ksh.20000. . (5mks)
   9. Create a report named SUPERVISION to display Students Names, Project Title, names of supervisor, and supervision Dates. The records in the report should be grouped by students’ Name and the number of supervisions by each student should be displayed. (5mks)
   10. Title the report as supervision per lecturer. (2mks)
   11. Print the following:
       • Tables: STUDENT, SUPERVISOR and SUPERVISIONS (2mks)
       • Queries: BALANCE and BALANCE2 (2mks)
       • REPORT: SUPERVISIONS (1mk)

 MARKING SCHEME