Computer Studies Paper 2 Questions and Answers - KCSE 2022 Prediction

INSTRUCTIONS TO THE CANDIDATES

1. Indicate your name and index number at the top right hand corner of the printout.
2. Write your name and index number on the CD/removable storage medium provided.
3. Write the name and version of the software used for each question attempted.
4. This paper consists of two questions each having 50 marks.
5. Answer all the questions Passwords should not be used while saving files.
6. All files created must be saved in the provided CD/removable storage medium.
7. Make printouts of your answers on the answer sheet provided.
8. Hand in all the printouts and the CD/Removable storage medium used.
9. This paper consists of 7 printed pages.
10. Candidates should answer the questions in English.

Questions

1. The following table contains data extracted from an employees’ payroll file maintained by a certain company
   

   EMPNO	NAME	BASIC PAY	DEPARTMENT	AGE	STATUS
   E100	Marren	16000.00	Computer	34	Single
   E101	Wezo	17000.00	Computer	44	Married
   E102	Dave	19000.00	Finance	33	Divorced
   E103	Charles	21000.00	Research	33	Single
   E104	Davy	23000.00	Research	25	Single
   E105	Thomas	25000.00	Computer	26	Married
   E106	Ann	27000.00	Finance	28	Married
   E107	Susan	29000.00	Finance	29	Divorced
   E108	Tina	31000.00	Research	24	Divorced
   E109	Andrew	33000.00	Computer	40	Single
   E110	Hardy	35000.00	Finance	20	Married
   E111	Selly	37000.00	Finance	43	Single
   E112	Kimani	10000.00	Research	15	Single
   E113	Chep	15000.00	Finance	35	Divorced
   E114	Eddie	35000.00	Computer	25	Married
   E115	Moses	59000.00	Research	33	Single
   E116	Miriam	70000.00	Finance	56	Divorced
   E117	Maurice	32876.00	Computer	70	Divorced
   E118	Alphine	43876.00	Research	65	Divorced
   E119	Cazy	48098.00	Research	32	Single
   E120	Langat	6500.00	Computer	12	Single
   E121	Phenny	29000.00	Finance	70	Single
   E122	Hilda	32000.00	Computer	13	Married

   1.                       
      1. Create a database file and save as Company. (2 mks)
      2. Create a table named Workers containing the fields shown in the table above. (5 mks)
      3. Choose and set an appropriate field as a primary key. (2 mks)
   2.            
      1. Create a form named WorkersForm to be used to enter the data above in the Workerstable to appear as shown below. (7 mks)
         
      2. Use the WorkersForm to enter the data above into the Workerstable. (5 mks)
   3. Create queries to determine:
      1. number of people with basic salary greater than 32,000/= .Save the query as Basic (3mks)
      2. number of people with basic salary less than 45,000/= and come from computer department. Save the query as Computer. (5 mks)
      3. those whose name begin with letter ‘M’ or end in letter ‘S’. Save the query as Names (3 mks)
   4.                  
      1. Create a query to determine those employees who will earn more than 50,000/= if there is an increment of basic pay by 10%. Save the query as SalaryIncrement. (4marks)
      2. Create a query to determine the year of birth of each employee from the current year. Save as YearOfBirth. (3 mks)
   5.                
      1. Create a report from Workerstable to display all the data in the table. Save as WorkersReport. (3 mks)
      2. Modify the WorkersReport in (e)(i) above as follows:
         1. Add the “EMPLOYEE SALARY DETAILS”as the report title. Use font size 19 pts, bold, underline and centre it across the columns containing data. (3 mks)
         2. Display the employees records according to their department and show the total amount the company spend on each department as salary and the total amount spend on paying all the employees. Save as WorkersReport_2. (6 mks)
   6. Print: (3 mks)
      1. Workers table;
      2. YearOfBirth query;
      3. WorkersReport_2.
         
         
         
         
         
         
         
2. The following data was extracted from Applicants’ file of KERICHO COMPUTER COLLEGE.
   1.                                          
      1. Enter the data as it appears in a spreadsheet. (12mks)
         

         	A	B	C	D	E	F	G	H	I
         1	NAME	ADDRESS	TOWN	ENG	KISW	MATH	MEAN	POSITION	REMARK
         2	Wanjiku N.	400	Nairobi	40	60	60
         3	Otieno D.	3201	Kisumu	55	50	40
         4	Nyambane T.	5600	Kisii	70	60	50
         5	Simiyu S.	1236	Bungoma	30	80	70
         6	Chebet K.	48	Eldoret	75	70	80
         7	Fatuma A	6032	Mombasa	40	30	50
         8	Kamau J.	8021	Nyeri	50	40	55
         9	Amoit C.	2	Busia	80	50	70

      2. Insert two blank rows at the top of the worksheet. (2 mks)
      3. Enter the following title and subtitle in the blank rows respectively; KERICHO COMPUTER COLLEGE and APPLICANTS FILE. (2 mks)
      4. Centre the title and subtitle across the columns that contain data. (2 mks)
   2. Using functions, compute:
      1. the mean for each student and format it to 2 decimal place. (3 mks)
      2. the position of each student. (2 mks)
      3. the highest score for each subject. (2 mks)
   3. The college wishes to analyze the applicants’ data in order to find those applicants who qualify for admission to pursue a course in IT. 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 Mathematics;
      3. Must have scored 50 marks and above in either English or Kiswahili.
         Enter an appropriate function in cell I4 and copy it to other cells to determine whether the student qualifies for admission. If the student qualifies, the function should display ‘Successful’. Otherwise it should display ‘Unsuccessful’. (12 mks)
      4. Create a function to find the number of applicants who are successful. (3 mks)
      5. Copy the entire worksheet to sheet 2 and rename it as Successful Applicants. (4 mks)
      6. Filter the ‘Successful Applicants’ sheet to display the records of those applicants who are successful. (4 mks)
      7. Print: (2 mks)
         1. Sheet1;
         2. Successful Applicants Sheet;

Marking Scheme

1. The following table contains data extracted from an employees’ payroll file maintained by a certain company.
   1.                  
      1. Create a database file and save as Company. (Award 1 mk)
      2. Create a table named Workers containing the fields in the table.
         (½ mk x 6 fields, and ½ mk for saving as Workers) (Award Max 3 mks)
      3. Choose and set an appropriate field as a primary key. (Award ½ mk)
   2.                              
      1. Create a form named WorkersForm.
         • Form title (award 1½ mk)
         • Controls (award 3 mks)
         • Layout (award 2½ mks)
      2. Use the WorkersForm to enter the data above into the Workerstable. (Award 5 mks)
   3.  Create queries to determine:
      1. number of people with basic salary greater than 32,000/= .Save the query as Basic
         (Query 1 mk, correct criteria 1 mk and saving as Basic 1 mk) (Award Max 3 mks)
      2. number of people with basic salary less than 45,000/= and come from computer
         department. Save the query as Computer.
         (Query 1 mks, criteria for salary 1½ mks, criteria for department 11/2mks and saving as Computer 1mk) (Award Max 5 mks)
      3. those whose name begin with letter ‘M’ or end in letter ‘S’. Save the query as Names
         (Query ½ mk, criteria 2mks and saving as Names ½ mk.)(Award max 3 mks)
   4.                  
      1. Create a query to determine those employees who will earn more than 50,000/= if there is an increment of basic pay by 10%. Save the query as SalaryIncrement.
         (Query ½ mk, calculated field 2 mks, criteria 1 mk and saving as SalaryIncrement ½ mk) (Award Max 4 mks)
      2. Create a query to determine the year of birth of each employee from the current year. Save as YearOfBirth.
         (Query ½ mk, calculated field for year of birth 2 mks and saving as YearOfBirth ½ mk) (Award Max 3 mks)
   5.                    
      1. Create a report from Workerstable to display all the data in the table. Save as WorkersReport. (Award 3 mks)
      2. Modify the WorkersReport in (e)(i) above as follows:
         1. Add the “EMPLOYEE SALARY DETAILS”as the report title. Use font size 19 pts, bold, underline and centre it across the columns containing data.
            (Correct report title 1 mk, font size ½ mk, bold ½ mk, underline ½ mk and centre alignment ½ mk) (Award max 3 mks)
         2. Display the employees records according to their department and show the total amount the company spend on each department as salary and the total amount spend on paying all the employees. Save as WorkersReport_2.
            (Displaying employees records according to departments –2mks
            Departmental salary subtotal – 2 mks
            Grand total on salaries – 1 ½ mks
            Saving as WorkersReport_2 – ½ mk) (award Max 6 mks)
            
            
   6. Print:
      1. Workers table; (award 1 mk)
      2. YearOfBirth query; (award 1 mk)
      3.  WorkersReport_2. (award 1 mk)
2.                
   1.                        
      1. Enter marks to the spreadsheet ( award 12mks)
      2. Insert two blank rows at the top of the worksheet.
         (Award 1x 2 = 2 mks)
      3. Enter the following title and subtitle in the blank rows respectively; KERICHO COMPUTER COLLEGE and APPLICANTS FILE. (Award 1 x 2=2 mks)
      4. Centre the title and subtitle across the columns that contain data.(award 1 x 2=2 mks)
   2. Using functions, compute:
      1. the mean for each student and format it to zero decimal place.(award 3 mks)
      2. the position of each student. (Award 2 mks)
      3. the highest score for each subject. (Award 2 mks)
         (Deny marks if the candidate used a formula instead of a function)
   3. The college wishes to analyze the applicants’ data in order to find those applicants who qualify for admission to pursue a course in IT. Successful candidates MUST meet the following minimum requirements;
      • Must have scored a mean of 45 marks and above;
      • Must have scored 60 marks and above in Mathematics;
      • Must have scored 50 marks and above in either English or Kiswahili.
        Enter an appropriate function in cell I4 and copy it to other cells to determine whether the student qualifies for admission. If the student qualifies, the function should display ‘Successful’. Otherwise it should display ‘Unsuccessful’. (Award 12 mks)
   4. Create a function to find the number of applicants who are successful. (award 3 mks)
   5. Copy the entire worksheet to sheet 2 and rename it as Successful Applicants.
      (Copying entire worksheet to sheet 2 – (award 3 mks)
      Renaming sheet 2 as Successful Applicants – (award 1 mk)
   6. Filter the ‘Successful Applicants’ sheet to display the records of those applicants who are successful. (award 4 mks)
   7. Print:
      1. Sheet1;
      2. Successful Applicants Sheet;
         (1 x 2=(award 2 mks)