Computer Studies Paper 2 Questions and Answers - Royal Exam Series Post Mock Trial Exams 2022

COMPUTER STUDIES
PAPER 2
PRACTICAL

INSTRUCTIONS TO CANDIDATE

• Answer All questions
• All answers must be saved in your diskettes! Removable device
• Insert your name and index number as headers on all your documents
• Make a print out of the answers on the answer sheets provided
• Hand in the print outs and the diskette

Questions

Answer question one (compulsory)

1.          
   1.          
      1. Using a word processing program, type the following table and save as LIST.
         Adjust your font type to
         1. Times New Romans, (1mark)
         2. font size 12. (1mark)
         3. Use the auto sum feature to get the sum in the fees column. (2marks)
            

            Name	Box Number	Town	Form	House	Fees
            Wanjala Naswa	132	Namalala	2W	Kilimanjaro	9250
            Abdalla Ali	100	Bamburi	1W	Simba	11500
            Mulwa Norr	50	Matuu	1W	Simba	11500
            Mwangi Mama	500	Kairuthi	4R	Chui	10500
            Kiptoo John	100	Tindinyo	2R	Ndovu	8575

            (14 Marks)
      2. Convert the table above to text. (2marks)
   2. Using mail merge, type the following letter. Use the table above as the data source and merge the details where applicable. Include all the formatting features in the letter. Justify the first paragraph of the letter.
      Save as LETTER.
      

      Success High School, P.O Box 1000,             Nakuru.                      30th November 2020. .......................................... P.O Box...”Box Number” .......................................... Dear...”Name”, RE : ADMISSION We are pleased to offer you a place in this school in form “Form”. Your house will be “House”. The amount of fees required is Ksh “Fees”. The school opens on 5th January, 2021. You are required to bring the following items:     Beddings                     Stationery 1. 1 mattress               1. Text books 2. 2 blankets                2. Exercise books 3. 2 bed sheets            3. 1 mathematical set 4. 1 bedcover               4. 1 ruler 5. 2 pillow cases           5. 1 Bible/Koran Yours faithfully. Henry Mkubwa (PRINCIPAL)

      (28 Marks)
   3. Print both LIST and LETTER. (2marks)
2. Using a spreadsheet program type the worksheet below as it appears. (7marks)
   
   
   1.      
      1. Create a worksheet with the following entries:
      2. Adjust column width where necessary to display all entries in detail. Validate the cells to accept
         ONLY numerals between 0 to100 and return a comment “Please enter a number between 0 and 100” whenever an out of range error occurs. Save the worksheet as MARKS1. (4 Marks)
   2. Obtain the following:
      1. total score for each student
      2. mean score for each student
      3. highest score per subject
      4. standard deviation per subject
      5. rank for each student
      6. the grade for each student based on the following information.
         

         Mean	Grade
         75 - 100 70 - 74 65 - 69 60 - 64 55 - 59 50 - 54 45 - 49 40 - 44	A A- B+ B B- C+ C C-

         
         On the paper provided write the formula for each activity above.
         Save your worksheet as MARKS 2. (22 Marks)
   3. Insert a new row for Chege Kisilu between Ayuku Aseka and Irungu Wambua. Enter his scores as 60. 50, 80, and 20. Save your worksheet as MARKS 3. (3 Marks)
   4. Format the ranges with values for mean score and standard deviation to display results to 3 decimal places. Save your worksheet as MARKS 4. (4 Marks)
   5. Select a free cell and enter 10%. Use the value entered to increment the mean score of each student. Save as MARKS 5. (8 Marks)
   6. Print MARKS 2, MARKS 3, MARKS 4 and MARKS 5. (2marks)

Marking Scheme

1.        
   1.        
      1. Existence of filename called LIST = 1 mks
         • Creation of table and data existence (with borders) = 2 mks
         • Underline of the header labels = 1 mks
         •  All correct entries = 10 mks
         • Correct usage of fonts and size (times New Roman, Size 12) = 2 mks
         • Use of auto sum feature to get the sum in the fees column = 4mks
         •  Existence of filename LETTER = 1 mks
           
           
      2. Converting table to text = 2mks
         • Justification of the 1st paragraph = 4 mks
         • Correct typing of whole document = 10 mks
         •  Formatting as per specification given = 5 mks
         • Merging the two documents = 6mks
         • Hardcopy printouts of LIST.DOC and LETTER.DUC = 2 mks
           
           
2.           
   1.         
      1.         
         • Creation of the worksheet and existence of MARKS1 = 2 mks
           - All entries correctly entered = 5 mks
           - Validation of cells to display “Please enter number between 0 and 100” = 2 mks
           - Formatting of worksheet as per specification and existence of MARKS 2 = 2 mks
           
           
   2. Correct formula for each of the following:
      • Total for each student (SUM) = 2 mks
      • Mean Score for each student (AVERAGE) =2 mks
      • Highest score per subject (MAX) =2 mks
      • Standard Deviation (SD) = 2 mks
      • Rank for each student (RANK) =2 mks
      • Grade computations for each student = 10 mks
      • Saving = 2 mks
      • Insert a new row for Chege Kisilu and entering data = 3 mks)
        
        
   3.      
   4. Format the ranges with values for mean score and standard deviation to display results to 3decimal places and existence of MARKS 4. = 4 Mks
      
      
   5. Select a free cell and enter 10%. = 2mks
      Use the value entered to increment the mean score of each student. = 4mks
      Existence of MARKS 5. (2mks)
      
      
   6. Printing.