Computer Studies Paper 2 Questions and Answers - Kenya High Post Mock 2023 Exams

INSTRUCTIONS

• Type your name and admission number at the top right hand corner of each printout
• Sign and write the date of the examination below the name and index number on 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.
•  This paper consists of 4 printed pages. Candidates should check the question paper to ascertain that all the pages are printed as indicated and that no questions are missing.

QUESTIONS

QUESTION ONE :50MK

1.  Type the following letter as it appears in a word processor. Use the mail merge feature to produce to produce copies of the same letter to the persons whose details are given below
   (12 Mks)
   
   MHS LIGHT HIGH SCHOOL
   P.O.BOX 900
   NAKURU
   
   6TH JULY 2010
   
   <NAME>, <ADMNO>
   
   <ADDRESS>
   
   <TOWN> DEAR<NAME>
   REF:2008 KCPE RESULTS
   I am happy to inform you that the NOV-DEC. Examinations are out. Kindly arrange to visit our school on<Date to visit>at 9.00 am in order to know the details. Remember to carry your original KCPE certificate and examination registration card–bearing the index number.
   Yours truly,
   Headteacher
   Data source (List of candidates)
   

   Name	Adm no-	Address	Town	Date of visit
   Mark otieno	8074	P.O Box 24	Sondu	02/03/08
   Kelvin Kirui	8189	P.O Box 172	Kericho	08/03/08
   Bernard Soi	8065	P.O Box 84	Bomet	24/03/08

   
   Required
   1. Save Main document as Main Doc (1 mk)
   2. Save Data source as Data source (1 mk)
   3. Change the addresses and reference font size to 14 pt (1½mks)
   4. Underline the reference (½ mk)
   5. Merge the letter onto main document so as to produce for all the three candidates and save it as ‘Results 2021’ (6 mks)
   6. Print the letters (3 mks)
2.  
   1. Type the following text in word processing software and save it in a folder using your Name and Index number
      A computer is a machine or an electronic device that can solve problems by accepting data, performing certain operations on that data(processing)and presenting the results of those operations (Information)Basic characteristics that distinguish a computer from other information
      processing devices:
      1. A computer is electronic-That is, all its processing operations are carried out with electrical signals
      2. A computer can store information for future reference. This is done on temporary basis with memory circuits and permanently with storage devices such as magnetic disks and tape.
      3. A computer is programmable-unlike other devices built to perform a single function, a computer can be instructed or programmed to perform a variety of tasks.
         HOW A COMPUTER OPERATIONS
         Converting the data (raw facts) into information’s (Organized, usable form) is called data processing. Data get into the system by means of input device e.g keyboard then the performs the necessary calculations or manipulation on the data and finally the organized information is displayed by an output device e.g a monitor.
         FUNCTIONS PERFORMED BY A COMPUTER
         Although computers have many applications, they can perform only three basic tasks.
         1. Arithmetic functions on numeric data (adding, subtracting, multiplying and dividing)
         2. Test relationships between data items (by comparing values)
         3. Store and retrieve data
            These skills are really no more than people can do, but the computer can accomplish can the task more;
            Faster Accurately Reliable
            Required
            1. Align the title to the center and underline it (1 mk)
            2. Add border to the title (2 mks)
            3. Replace all the numberings with bullets (2 mks)
            4. Insert the footer ‘’Computer F4 Joint Evaluation Test,2010’’ (2 mks)
            5. Set the line spacing to exactly 1.5 (4 mks)
            6. Insert word Art ‘’COMPUTER’’ and set it to appear behind the text. (5 mks)
            7. Search for words ‘’Computer’’ and replace all with ‘’PC’’ (2mks)
            8. Move paragraph with the heading ‘’how a computer operates’’ to the end of the document (2 mks)
            9. Set the font style of the document to Arial black (3 mks)
            10. Save your work as ‘’computer literacy’’ (1 mk)
            11. Print your document (2 mks)

QUESTION 2: 50 Marks
The data in the tables below was extracted from survey data on employment
Table 1:Employee Table

Table 2: Employment Type

Table 3: Employers Table

1.  
   1. Create a database named "EMPLOYMENT" to store the data above
   2. Create relationships between the tables
   3. use forms to enter data into the tables
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 2012.
   2. compute the mean age of employees on the report you created in b (i) above.
3.  
   1. Ceate a query to display the employees and their job description. save the query as "EMPTYPE"
   2. create a pie chart based on the query in c(i) above to display the propotions of employees in various job descriptions. save the report as CHART.
4. Print the.
   1. three tables
   2. two reports
   3. output of query results for EMPTYPE

MARKING SCHEME

QUESTION ONE :50Marks

1. Typing the entire document 12mks
   1. Saving Main document 1mk
   2. Saving Data source as Data source (1 mk)
   3. .Changing the addresses and reference font size to 14 pt (1½mks)
   4. Underlining the reference (½ mk)
   5. Merging the letter onto main document so as to produce for all the three candidates and save it as ‘Results 2021’ (6 mks)
   6. Printing the letters (3 mks)
2.  
   1. Aligning the title to the center and underline it (1 mk)
   2. Adding border to the title (2 mks)
   3. Replacing all the numberings with bullets (2 mks)
   4. Inserting the footer ‘’Computer F4 Joint Evaluation Test,2010’’ (2 mks)
   5. Setting the line spacing to exactly 1.5 (4 mks)
   6. Inserting word Art ‘’COMPUTER’’ and setting it to appear behind the text. (5 mks)
   7. Searching for words ‘’Computer’’ and replace all with ‘’PC’’ (2mks)
   8. Moving paragraph with the heading ‘’how a computer operates’’ to the end of the document (2 mks
   9. Setting the font style of the document to Arial black (3 mks)
   10. Saving the work as ‘’computer literacy’’ (1mks)
   11. Printing document (2 mks)

QUESTION TWO

1. Creating database and 3 tables -14mks
2. Creating relationship between tables -4mks
3. Entering all data and all forms available-101/2mks
4. Generating reports based on the requirements 10mks
5. Computing mean age (2mks)
6. Creating query based on criteria given (3mks)
7. Pie charts creation (3mks)
8. Printing (3mks)