Get premium membership and access revision papers, questions with answers as well as video lessons.

Got a question or eager to learn? Discover limitless learning on WhatsApp now - Start Now!

Computer Studies Paper Two Question Paper

Computer Studies Paper Two

Course:Secondary Level

Exam Year:2006

MOI HIGH SCHOOL KABARAK
451/2
COMPUTER STUDIES
PAPER TWO
PRACTICAL

INSTRUCTIONS TO CANDIDATES

Answer questions 1 and either 2 or 3 . All questions carry equal marks
Type your name and index number at the top right hand corner of each printout
Write your name and index number on the diskette.
Do not use password while saving files.
Write the name and version of software used for each question attempted on the answer sheet .
Hand all print outs and the diskette.

1. Using a word processor package . type the letter as it appears and save it as : LETTER
( 25 marks)
Computer studies Department
P.O BOX 301
MACHAKOS
KENYA
TEL.0145-21542
5TH MARCH . 2006

Dear Mr holmos

RE: I LOVE MS – OFFICE

It is real pleasure to be able to write to you and express my undying love for your product . For many years now I have taken delight in the use of Microsoft. Your software is just so good. Sometime I think that all the excitement will just kill me. I find that everyday Microsoft Office offers me new challenges. Holmes in short, you and your great company give my life meaning , I thank you. I would be grateful if you could answer a number of questions

What makes your products so popular? Or could it be the lack of serious competition
Your products are so exciting where do you find your insepirations? Perhaps you cpould give some tips to the fourth form K.C.S.E Computer Studies students
Power rationing can be a real pain to a computer useer. Do you have any suggestions as to how we can cope with it? A part from moving to a different country.
Finally , which is your favourite Teletubby? Dispy Lala or Po? Of course its kacla-la-la-la. She is the koollest of them all.

By the way , let me leave you with a quip aboput computer experts:

A computer Expert………………………………………..

“……………………..Someone who will know tomorrow
why things he predicted yesterday,
Didn’t happen today ?

OR

“……………………. Someone who is not always right,
But is often wrong for more sophisticated reasons.
Yours sincerely
Mr. Hoff

b) Spell check your document. ( 4 marks)
c) I) Change the reference of the letter to font size 16, Bold and underline it ( 1mk)
Save your document as letter 2 ( 2 marks)

d) I) Format the first letter of your paragraph to drop three lines ( 2 marks)
II) Search and replace the word computer with the word machine. ( 3 marks)

e) Capitalize the first character of all occurrences of the word holmes ( 3 marks)
f) Put a 6 point frame a round your document
g) Animate the quip to have a blinking background and then save as : Letter 3 (3mks)
h) Print Letter 2 and letter 3

2 a) The table below shows the marks scored by F1 students in a subjects used to gauge admission of the candidates to F2 . Enter the data in a spreadsheet package as it appears…….

Save it as Lochab ( 12 marks)

Serial No Name Maths Geog Histo Germany French Eng
1 Alina Bbatia 50 85 47 72
2 Amrita Suri 31 45 69 64
3 Apurva Balanta 55 65 87 55
4 Dhruti Maru 87 68 59 64
5 Fanzia Hassan 77 37 75 76
6 Gilliam B 59 84 56 53
7 Neil Patel 44 65 75 82
8 Anil Kerai 60 85 69 92
9 Peninah Wamithi 71 87 78 84
10 Priyanka Wadba 15 14 35 74
11 Leroy Kiptoo 40 63 68 96
12 Zabra Hassan Ali 66 95 84 35
13 Amos Yegon 91 64 47 74
14 Habil Omollo 88 83 69 85

b) Find the totals for all the subjects and the total for each candidate in all the subjects.
Label them properly ( 4 marks)
c) Find the average score for each candidate in all the subjects ( 2 marks)
Write the formula used on the piece of paper provided ( 2 marks)
d) Round off the values in the average column to 2 decimal places save your worksheet a s LOCHAB ( 2 marks)

e) Type a formula in an empty cell to count all the students not taking germany

Computer Studies Paper Two Question Paper

More Question Papers

Popular Exams