Computer Studies Paper 2 Questions - Kapsabet Boys Post Mock 2023 Exams

INSTRUCTIONS

• Write the name and the version of the software used for each questions attempted in the answer sheet
• Answer all the questions
• All questions carry equal marks
• Passwords should not be used while saving in the diskette/removable media
•  All answers must be saved in your diskette/removable media
• Make a print out and tie/staple them together
• Hand in all the printout and the diskette/removable media
• . This paper consists of 4 printed pages. Candidates should check the question paper to
• Ensure that all the pages are printed as indicated and no questions are missing.

QUESTIONS

QUESTION 1

1. Type the following letter as it appears in a word processor. Use the mail merge feature to produce copies of the same letter to the persons whose details are given below. (12 marks)
                                                                                                                                JKML HIGH SCHOOL
                                                                                                                                P.O. BOX 4500
                                                                                                                                NAIROBI
                                                                                                                                29TH JUNE 2018
   <NAME>, <ADMNO>,
   <ADDRESS>
   <TOWN>
   DEAR<NAME>
   
   REF: 2017 KCSE RESULTS
   
   I am happy to inform you that the 2017 KCSE Examination results are out. Kindly arrange to visit the school on <Date to visit> at 9.00 am in order to collect the slip. Remember to carry your original student card bearing the index number. All the students must wear full school uniform.
   
   Yours truly,
   
   Chief Principal
   
   Data Source (List of Candidates)
   

   Name	Adm no.	Address	Town	Date of visit
   Mary Muthoni	8074	P.O Box 24	Nairobi	02/03/2014
   James Karanja	8189	P.O Box 172	Nairobi	08/03/2014
   Bernard Mwangi	8065	P.O Box 002	Nairobi	24/03/2014
   Mary Mwagi	8041	P.O Box 190	Nairobi	02/03/2014
   Henry Kamau	8042	P.O Box 141	Nairobi	02/03/2014
   James Karanja	8043	P.O Box 84	Nairobi	08/03/2014
   Alex Kubasu	8044	P.O Box 80	Nairobi	08/03/2014
   Ann Wairomu	8055	P.O Box 7	Nairobi	24/03/2014

   
   Required
   1. Save Main document as Main Doc. (1 mark)
   2.  Save Data source as Datasource (1 mark)
   3. Change the addresses and reference font size to 14pts (11/2 marks)
   4. Underline the reference (1/2 mark)
   5. Merge the letter onto main document so as to produce for all the candidates and save it as
      ‘Results 2013’ (6 marks)
      
      
      4. Print the letters (3 marks)

QUESTION 2
The data in the table was extracted from a survey data on employment
Table 1 : EMPLOYEE TABLE

Table 2 : EMPLOYMENT TYPE

Table 3 : EMPLOYER TABLE

1.  
   1. Create a database named “STAFF” to store the above. (4 mks)
   2. Create relationships between the tables (41/2 mks)
   3. Use forms to enter data into the tables (101/2 mks)
2.  
   1. Generate a report to display the name, year of birth, age and employer’s name for the employees who will be over 30 years old by the year 2015. (10 mks)
   2. Compute the mean age of employees on the report you created in b (i) above (2mks)
3.  
   1. Create a query to display the employees and their job description. Save the query as
      “STAFF TYPE”. (3mks)
   2. Create a pie chart based on the query in c(i) above to display the proportion of employees in various job description. Save the report as CHART (3mks)
4. Print
   1. Three tables (1mk) 
   2. Two reports 1 mk)
   3. Query Results (1 mk)