Kenya Certificate of Secondary Education
451/2
COMPUTER STUDIES Paper 2
(PRACTICAL)
2 ½ hours
Instructions to candidates
 Write your name and Index No on the CD/ Removable storage medium provided
 Write the Name and version of software used in each question attempted in the answer sheet provided
 Answer all the questions.
 All questions carry equal marks.
 Passwords should not be used while saving in the CD/Removable storage medium.
 All answers must be saved in your CD/Removable storage medium.
 Make a printout of the answers on the answer sheet.
 Arrange your printouts and tie/ staple them together
 Hand in all the printouts and the CD/Removable storage medium used.
QUESTIONS

 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. (12marks)
MASENO SCHOOL,
P.O.BOX 120,
KISUMU.
8TH JULY 2020.
<NAME >, <ADMNO>,
<ADDRESS>
<TOWN>
Dear <NAME>
REF: 2020 KCSE RESULTS.
I am happy to inform you that the KCSE 2020 Examinations are out. Kindly arrange to visit our school on <Date to visit> at 9.00 a.m. in order to know the details. Remember to carry your original KCPE certificate and examination registration card bearing the index number.
Your’s Sincerely,
Chief Principal
Data source (List of Candidates)
Name Adm. No Address Town Date to visit Alem Cyril 178398 P.O.BOX 24 Nairobi 04/05/2020 Odaba Norbert Ian 178409 P.O.BOX 186 Mombasa 08/05/2020 Andrea M Kelvin 178719 P.O.BOX 48 Voi 24/03/08
Required: Save Main document as Main Doc (1mark)
 Save Data source as Datasource (1mark)
 Change the addresses and reference font size to 14pts (1mark)
 Underline the reference (1mark)
 Merge the letter onto main document so as to produce copies for all the three candidates and save it as ‘Results 2020’ (6marks)
 Print the letters (3marks)
 Using a word processing package, type the document below exactly as it appears.
Answer the questions that follow.
RECURSION
An object is said to be recursive if it partially consists (or is defined in terms) of itself. Recursion is encountered not only in mathematics, but also in daily life. Who hasn’t seen an advertising picture which contains itself?
Recursion is a particularly powerful means in mathematical definitions. A few familiar examples are those of natural numbers, tree structures and of certain functions. Natural numbers
 1 is a natural number.
 the successor of a natural number is a natural number.
 Tree structures, e.g., O is a tree (called the empty tree).
 The factorial function n! (for nonnegative integers).
 0! =1.
 If n > 0, then n! = n.(n  1)!.

 Apply the following formats to the title “RECURSION’
Capitalization  Uppercase
Alignment  Centered
Appearance  Bold
Font type  Arial Black
Size  18
Underline  Single (2 marks)  onvert the paragraph starting from “The power of recursion ……….” to two columns, and justify them. (3 marks)
 Apply borders on the table as shown. (1 marks)
 Put a header and a footer. The header should read ‘Learning word’ while the footer should appear as © followed by your first name. (2 marks)
 Group the structure diagram s one object (3marks)
 Save the entire document as Recursion and in a compact disk. (2 marks)
 Natural numbers
 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. (12marks)

 Create a new workbook and name it as Form Four Computer Results. (1mark)
 Design the table as it is and enter the fo1lowng data in sheet I (12marks)
 Rename the sheet as Term one results. (1mark)
 Using Formula and NOT Function Find:
 Totals (2marks)
 Average (2marks)
 Use the IF function to award remarks as follow (3marks)
 A student whose average is above or equals 65 is given “Excellent”
 An average of 55 or above but less than 65 award “average work”
 An average less than 55 award “work below average”
 Award position to student basing on the average scored. (3marks)
 On the last rows enter formulas to count students from both classes (2marks)
 Sort the students list by class position in ascending order. (2marks)
 Copy sheet one and rename it as worksheet data management using the subtotal function, find the subtotal and Grand totals of the two classes in terms of CAT TOTAL. (8marks)
 Copy the entire worksheet onto sheet 2 and rename it “lower group” (2marks)
 Filter “Lower group” sheet to display students from “E” class and whose average score is below 50. (4marks)

 Draw a 3D clustered bar graph to display the following information. (3marks)
 The three cats
 Names
 Title as “TERM ONE COMPUTER RESULTS”  Place the legend at the bottom of the graph (lmark)
 Save the chart on a new sheet and name it graphical analysis (lmark)
 Draw a 3D clustered bar graph to display the following information. (3marks)
 Print:
 The filtered lower group (lmark)
 The chart (lmark)
 Term one results sheet (1mark)
 Create a new workbook and name it as Form Four Computer Results. (1mark)
Download Computer Studies Paper 2 Questions with No Answers  Maseno Mock Exams 2020/2021.
Tap Here to Download for 50/
Get on WhatsApp for 50/
Why download?
 ✔ To read offline at any time.
 ✔ To Print at your convenience
 ✔ Share Easily with Friends / Students