Computer Studies Paper 2 Questions and Answers - Momaliche Pre Mock Exams 2023

Instructions to Candidates

• 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.

1. The following data was extracted from Applicants’ file for Momaliche high school comp/Maths teacher recruitment
   1.  
      1. Enter the data as it appears in a spreadsheet. And save it as INTERVIEW (13mks)

         	A	B	C	D	E	F	G	H	I
         1	NAME	ADDRESS	TOWN	comp	Math	Eng	MEAN	APPLIUCANT'S POSITION	REMARK
         2	Willington	400	Nairobi	40	60	60
         3	Benjamin	3201	Kisumu	55	50	40
         4	Nyambane T.	5600	Kisii	70	60	50
         5	Grace	1236	Bungoma	30	80	70
         6	Rebecca	48	Eldoret	75	70	80
         7	Fatuma A	6032	Mombasa	40	30	50
         8	Kamau J.	8021	Nyeri	50	40	55
         9	Achieng.	209	Siaya	80	50	70

      2. Insert two blank rows at the top of the worksheet. (1 mark)
      3. Enter the following title and subtitle in the blank rows respectively; MOMALICHE HIGH SCHOOL RECUIRTMENT FILE and APPLICANTS DETAILS. (3marks)
      4. Centre the title and subtitle across the columns that contain data. (2marks)
   2. Using functions, compute:
      1. The mean for each Applicant and format it to 2 decimal places. (3marks)
      2. The position of each Applicant. (3marks
      3. The highest and lowest score for Benjamin, enter the answers in L3 and M3 respectively (3marks)
   3. The school wishes to analyze the applicants’ data in order to find those applicants who qualify for recruitment. Successful candidates MUST meet the following minimum requirements;
      1. Must have scored a mean of 40 marks and above;
      2. Must have scored 60 marks and above in Computer;
      3. Must have scored 50 marks and above in either Mathematics or English.
         Use the above criteria to remark If the applicants qualifies, the function should display ‘Successful’. Otherwise it should display ‘Unsuccessful’. (5mark)
   4. Using a function find the number of applicants who are successful. (2marks)
   5. Copy the entire worksheet to sheet 2 and rename it as Successful Applicants. (2marks)
   6. Filter the ‘Successful Applicants’ sheet to display the records of those applicants who are successful. (2marks)
   7. In a new worksheet Create a bar chart to compare the performance of mathematics and computer for all applicants (4marks)
      1. Insert SUBJECT PERFORMANCE as the heading of the chart (2 mark)
      2. Assign the appropriate LEGENDS to the chart (1 mark)
      3. Name the axis appropriately (2 marks)
   8. Print: (2 marks)
      1. INTERVIEW;
      2. Successful Applicants Sheet;
2. The document below is a brochure of KENYA UNIVERSITY AND COLLEGES CENTRAL PLACEMENT SERVICE (KUCCPS). Use a desktop publishing package to design it exactly the way it appears with the following specifications:
   1. Create a brochure named KUCCPS by creating a new master page with the following page layout.
      1. Paper size A4
      2. Orientation: Landscape.
      3. Margins guides 0.5inch or 1.3cm on top and bottom, 0.5 inch or 1.3cm inside and outside.
      4. Put 30% tint accent 3 background (7 marks)
   2. Enter the text and objects and format them as they appear. Use Font size 12 for the text and font size 14 for the titles. (40 marks)
   3. Save the publication as KUCCPS (1 mark)
   4. Print the publication (2 marks)
      

MARKING SCHEME