NAME ………………………………………………………………………..ADM. NO……………CLASS………..

101/3

ENGLISH

PAPER 3

FORM THREE

JULY 2023

2 HOURS 30MIN

 

 

MOCKS 1 2023

(Creative Composition and Essays Based on Set Texts)

Instructions to candidates

(a) Write your name and admission number

(b) Answer three questions only

(c) Questions 1and 2 are compulsory

(d)  In question 3 choose only one of the optional set texts you have prepared for.

(e) Each of your essays must not exceed 450 words.

 

1 Either

Write a composition ending with the following words;

(a) ………I regret failing to read between the lines.

OR

(b)  An essay proposing to the government ways indiscipline

in schools can be dealt with effectively.

2. The compulsory Set Text

Henry OleKulet; Blossoms of the Savannah

“Success or failure is in the mind,” using illustrations from

Blossoms of the Savannah, write an essay to illustrate the truthfulness

of the statement above.

3. Optional Set Texts

Answer any one of the following two questions.

Either

(a) The Short Stories

Godwin Shiundu, A silent Song and other stories

Actions speak louder than words. Discuss the truth of this

saying using illustrations from Leonard Kaberia’s A Silent Song.

Or

(b) The Play

David Mulwa; Inheritance

A nation without good leadership is deemed to fail. Drawing your illustrations

from ‘inheritance’ discuss the above statement.

 

NAME: …………………………………………………………. INDEX NO.: …………………

 

CLASS: ……………………………………………………………………….. DATE: ……………………………

 

CANDIDATE’S SIGNATURE: ……………………………

 

 

 

 

 

                MOCKS 1 2023

 

 

 

101/1

JULY 2023

ENGLISH (Functional Writing, Cloze Test, Oral Skills)

 

Paper 1

2 Hours

 

 

 

 

 

 

 

ENGLISH (Functional Writing, Cloze Test, Oral Skills)

Paper 1

 

2 Hours

 

 

 

 

 

 

 

For Examiner’s Use Only

 

NO.	QUESTIONS	TOTAL	CANDIDATES
		SCORE	SCORE
1.	FUNCTIONAL WRITING	20
2.	CLOZE TEST	10
3.	ORAL SKILLS	30
	TOTAL	60

 

 

 

 

 

 

 

 

 

1

 

 

1. FUNCTIONAL WRITING

 

 

You have returned to school after the mid-term break and realized that you left one of the set books back home. Write to your parent back home asking him or her to bring you the book during the Peace Prayer Day to be held in your school. Remember to tell them about your back to school, performance in the examinations you have done and your target grade at K.C.S.E.

 

(20 marks)

 

…………………………………………………………………………………………………

 

…………………………………………………………………………………………………

 

…………………………………………………………………………………………………

 

…………………………………………………………………………………………………

 

…………………………………………………………………………………………………

 

…………………………………………………………………………………………………

 

…………………………………………………………………………………………………

 

…………………………………………………………………………………………………

 

…………………………………………………………………………………………………

 

…………………………………………………………………………………………………

 

…………………………………………………………………………………………………

 

…………………………………………………………………………………………………

 

…………………………………………………………………………………………………

 

…………………………………………………………………………………………………

 

…………………………………………………………………………………………………

 

…………………………………………………………………………………………………

 

…………………………………………………………………………………………………

 

…………………………………………………………………………………………………

 

…………………………………………………………………………………………………

 

 

2

 

…………………………………………………………………………………………………

 

…………………………………………………………………………………………………

 

…………………………………………………………………………………………………

 

…………………………………………………………………………………………………

 

…………………………………………………………………………………………………

 

…………………………………………………………………………………………………

 

…………………………………………………………………………………………………

 

…………………………………………………………………………………………………

 

…………………………………………………………………………………………………

 

…………………………………………………………………………………………………

 

…………………………………………………………………………………………………

 

…………………………………………………………………………………………………

 

…………………………………………………………………………………………………

 

…………………………………………………………………………………………………

 

…………………………………………………………………………………………………

 

…………………………………………………………………………………………………

 

…………………………………………………………………………………………………

 

…………………………………………………………………………………………………

 

…………………………………………………………………………………………………

 

 

 

 

 

 

 

 

 

 

 

 

 

 

3

 

 

2. CLOZE TEST

 

Fill in each blank space in the following passage with the most appropriate word.

 

(10 marks)

 

 

Most African tribes have a communal (a)…………………………………………

 

to   life.   A   person   is   an   individual   only   to   the   extent   that   he   or   she      is        a

 

(b)…………………….…………of a clan, a community or a family. Land was never

 

owned by an individual, but by the people, and (c) ……………………..…………………

 

not be disposed of by anybody. (d)……………………………. there were traditional

 

heads,   they   held   land   in   (e)…………………………………..   for   the             community

 

generally. Food grown on the land was regarded as food to feed the hungry among the tribe. (f)……………………………………. each family might have its own piece of land

 

on which to cultivate, when there was famine or when you simply wanted to eat, you merely looked for food and ate it. There was no (g) ………………….. on your mind as to who owned it. In many parts of Africa it was thought quite natural for travelers to walk

 

(h)…………………………… the nearest garden, and pick some bananas or maize and

 

eat. Nobody would interfere with them (i)……………..…………………….. they went in

 

and    started    taking    loads    of     food     away.     Then     they     were,     of             course,

 

(j)………………………………. the laws of hospitality and generosity, and exploiting

 

the clan through whose land they were passing.

 

(Adapted from Freedom and After; Tom Mboya; London; Andre deutsch; 1963)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

4

 

 

3. ORAL SKILLS

 

1. Read the narrative below then answer the questions that follow.

 

In the beginning, the sun married the moon. They travelled together for a long time, the sun leading and the moon following. As they travelled, the moon would get tired, and the sun would carry her for three days every month.

 

One day the moon annoyed the sun and she was beaten by the sun, just the same way some women are beaten by their husbands. But it happened that the moon was one of those short-tempered women who fight their husbands. When she was beaten, she fought back and wounded the sun’s forehead. The sun also beat the moon, scratched her face and plucked out one of her eyes.

 

When the sun realized that he was wounded, he was very embarrassed and said to himself “I am going to shine so hard that people will not be able to look at me”. And so he shone so hard that people could not look at him without squinting. That is why the sun shines so brightly.

 

As for the moon, she did not feel any embarrassment and so she did not have to shine any brighter. And up to now, if you look closely at the moon, you will see the wounds that the sun inflicted on her.

 

 

 

Questions

 

 

 

1. Mention any two ways by which you would prepare your audience to receive this story (2 marks)

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

 

 

 

1. How would you say the line: “I am going to shine so hard that people will not be able

 

to look at me” to bring out complete effect?            (3 marks)

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

 

5

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

…………………………………………………………………………………………..…

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

 

 

• Imagine you are the story-teller charged with the responsibility of narrating this story.

 

What story telling devices would you employ and why?                                     (3 marks)

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

6

 

 

1. iv) While telling the story, you realized that a section of the audience was passive. What was

 

the likely cause for this?                                                                                                    (2 marks)

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

1. b) Provide another word that has the same pronunciation as each of the following words

 

		(3 marks)
i)	wrapped	………………………….
ii)	lichen	………………………….
iii)	room	………………………….

 

 

1. State whether you voice will rise or fall at the end of each of the sentences below (3 marks)

 

1. Fire! Fire! ……………………………………..

 

1. Did carry your set book to class? ………………………….

 

• I was never visited by parents. ………………………………

 

 

1. d) Explain what you would do if you were, without prior notice, asked to pass a vote of

 

thanks during your school’s Prize-Giving Day.                         (4 marks)

 

…………………………………………………………………………………………………

 

…………………………………………………………………………………………………

 

…………………………………………………………………………………………………

 

…………………………………………………………………………………………………

 

…………………………………………………………………………………………………

 

…………………………………………………………………………………………………

 

 

 

 

 

7

 

 

 

 

1. You have attended a one-day seminar. The person sitting next to you is intruding into your personal space. What four personal space guidelines could this person have failed to

follow?                                                                                                                                                 (4 marks)

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

1. f) The following is a conversation between two girls. Identify and illustrate any three

 

shortcomings in the Pet’s listening skills                                                                   (6 marks)

 

SHELLIE: (Walking excitedly to her) Good afternoon, Pet.

 

PET:                  (Reading a newspaper. Looking up…) Afternoon too Shellie (resumes

 

reading)

 

SHELLIE:     (Beaming) Yesterday, I watched the students of Mpesa Academy eulogize the late Bob Collymore.

 

PET:                  The one that was brought live on TV? I don’t like funerals since I lost my

 

aunt.

 

SHELLIE: They were articulate and expressive in their show of emotions…

 

PET:                  So that moved you?

 

SHELLIE: It not only moved me. It made me admire the late Bob.

 

PET:                  (Absent- mindedly) Even after being cremated? I would rather burn in hell.

 

SHELLIE: (Insistent) I think he was a wonderful man; he had time for even little

 

people.

 

PET:                  (Dismissively) So?

 

SHELLIE: We can learn something from those who depart before us, Pet. It is possible.

 

PET:                  (Laughing as she walks away) Ok. Keep learning. I hope you become

 

	professor.
SHELLIE: Pet, I think something is the matter with you.
PET:	(Waving at her) Bye! See you in school tomorrow.

 

1. ……………………………………………………………………………………..

 

 

 

8

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

1. ……………………………………………………………………………………..

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

• ………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

Name ……………………………………………. Stream……… Index Number………

 

Candidate’s Signature……………………………                          Date ……………………

 

 

 

101/2

 

ENGLISH

 

PAPER 2

(Comprehension, Literary Appreciation and Grammar)

 

JULY 2023

 

2½ HOURS

 

                MOCKS 1 2023

 

English Paper 2

 

Instructions to candidates

 

• Write your name and index number in the spaces provided above.
• Sign and write the date of examination in the spaces provided above.

 

• Answer ALL the questions in this question paper.

 

• All your answers must be written in the spaces provided in this question paper.

 

• This paper consists of 13 printed pages

 

• Candidates should check the question paper to ascertain that all the pages are printed as indicated and that no questions are missing.

 

 

 

 

 

 

 

 

For Examiners’ use only

 

Question	Maximum	Candidate’s
	Score	Score
1	20
2	25
3	20
4	15

 

 

1

 

1. Read the passage below then answer the questions that follow:

 

If one said, “The room had an extremely obnoxious smell.” And another said, “The room had the smell of rotten fish.” Which of the two sentences is appealing? Whereas the first sentence may look superior with the word ‘obnoxious’ making it pronounced, the second one stands out. Why? It is more subtle, graphic and appeals to our senses of sight, smell and even taste. Apart from that it is memorable. This is the residence of imaginative or creative writing.

 

Writing is arguably the highest in the order of skills in language acquisition. It combines: listening, speaking and reading. When one writes, it is for reading and when one reads they are in a one- on-one conversation with the writer; laughing at the jokes, frowning and being drawn to feel with what the writer is saying. If this is the case then there is need for anybody who wants to write to give it some thought.

 

Good writing that evokes feelings begins with a mindset that delves beneath the surface of things. Creative writings swim in the undercurrents of human existence seeking to bring to the fore hidden nuances of things and human life. In imaginative writing one explains the universal significance of what they observe. For instance, if the twins born together but raised apart eventually reunite and seek to locate the fact surrounding their parentage, creative writing would focus on the twists not the obvious based on the phenotypically acknowledged attribute that a DNA test would readily confirm. But a captivating writing would be if the test also revealed that the fathers who have raised them are not their biological fathers. This would unearth more than what looks true in the surface.

 

It is this imagination that rises above the mundane human realities that would form some fodder for thought as one gleans through what has been creatively written. Scintillating stories have lived with humanity from the adorable age of oral narratives when animals satirized human foibles. Again, these were not stories for stories’ sake but ones with didactic values; a take-home that would make the human world a better place.

 

The significance of expressive language cannot be gainsaid in writing. Even scientific reading would be made more accessible and enjoyable if they employed not the jargons that exist in their registers but in how the scientific writers would manipulate language in such a way that would draw attention to itself. Deliberate diction and syntax would create a definite pattern in such writing so as to communicate the complex scientific terminologies with a light timbre of humour.

 

It is the writer’s thinking captured in images using words and phrases with an obvious appeal and impact on the senses of taste, touch, hearing, smell and sight that would engrain what is read into the hearts and minds of the readers. It is the sensory details communicated through words that are impressionistic. And writing is as good as the indelible impression it leaves on the reader’s mind.

 

Through good creative works, the reader is transported to worlds far and wide, real and imagined while unveiling the new insights that traversing such worlds bring to human experiences. It is the writer’s conscious effort that concretizes these fictional and real worlds

 

 

2

 

in any written piece. In such writings, love comes through as a beautiful flower and kindness as the milk of human life.

 

Sustained vivid accounts of human experiences captured in words using mental pictures engraved in human senses would make creative writing be in a better stead than an action-pact movie.

 

(Adapted from a paper presented by Oloo Oliver on Creative Writing to teachers at Star of the Sea; Mombasa County; 2017)

 

Questions

 

1. a) According to paragraph one, what does creative writing entail? (2marks)

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

 

1. b) Why is it important for anyone who wants to write to think? (2marks)

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

 

1. c) Scintillating stories have lived with humanity from the adorable age of oral narratives

 

when animals satirized human foibles. (Rewrite beginning: Satirizing…)                                                                                                                                                                   (1mark)

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

 

1. d) How would creative writing work as a ‘mode of transport’? (2marks)

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

 

 

 

3

 

 

1. e) Explain why twins are mentioned in this passage. (2marks)

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

 

1. In note-form mention any three things one needs to consider in creative writing. (3marks)

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

 

1. g) Why do you think impression is important in creative writing? (2marks)

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

 

1. h) According to the passage, what is the significance of creative writing? (2marks)

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

 

1. i) Describe how creative writing would outdo movies. (2marks)

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

4

 

 

1. Give the meaning of the following word and expression as used in the passage

 

1. Indelible

 

………………………………………………………………………………………

 

………………………………………………………………………………………

 

 

1. engraved in human senses.

 

………………………………………………………………………………………

 

………………………………………………………………………………………

 

 

 

 

 

2. Read the excerpt below then answer the questions that follow

 

Nora: (begins to unpack the box, but soon pushes it away from herself) If only I dared go out. If only no one would come. If only I could be sure nothing would happen here in the meantime. Stuff and nonsense! No one will come. Only I mustn’t think about it I will brush my muff. What lovely, lovely gloves! Out of my thoughts, out of my thoughts! One, two, three, four, five, six- (screams) Ah! There is something coming -, (makes a movement towards the door, but stands irresolute) (enter MRS. LINDE from the hall, where she has taken off her cloak and hat)

 

Nora: Oh, it’s you Christine. There is no one else out there, is there? How good of you to come!

 

Mrs. Linde: I heard you were up asking for me.

 

Nora: Yes, I was passing by. As a matter of fact, it is something you could help me with. Let us sit down here on the sofa. Look here. Tomorrow evening there is a fancy-dress ball at the

 

Stenborgs’, who live above us; and Torvald wants me to go as a Neapolitan fisher girl, and dance the Tarantella that I learned at Capri.

 

Mrs. Linde: I see; you are going to keep up the character.

 

Nora: Yes, Torvald wants me to. Look, here is the dress; Torvald had it made for me there, but now it is all so torn, and I haven’t any idea—

 

Mrs. Linde: We will easily put that right. It is only some of the trimming come unsewn here and there. Needle and thread? Now then, that’s all we want.

 

Nora: It is nice of you.

 

 

5

 

Mrs. Linde: (sewing) So you are going to be dressed up tomorrow Nora I will tell you what —

 

• I shall come in for a moment and see you in your fine feathers. But I have completely forgotten to thank you for a delightful evening yesterday.

 

Nora: (gets up, and crosses the stage) Well, I don’t think yesterday was as pleasant as usual. You ought to have come to town a little earlier, Christine. Certainly Torvald does understand how to make a house dainty and attractive.

 

Mrs. Linde: And so do you, it seems to me; you are not your father’s daughter for nothing. But tell me, is Dr. Rank always as depressed as he was yesterday?

 

Nora: No; yesterday it was noticeable. I must tell you that he suffers from a dangerous disease. He has consumption of the spine, poor creature. His father was a horrible man who committed all sorts of excesses; and that is why his son was sickly from childhood, do you understand?

 

Mrs. Linde: (dropping her sewing) But, my dearest Nora, how do you know anything about such things?

 

Nora: (walking about) Pooh! When you have three children, you get visits now and then from—- from married women, who know something of medical matters, and they talk about one thing and another.

Mrs. Linde: (goes on sewing a short silence) Does Doctor Rank come here everyday?

 

Nora: Everyday regularly. He is Torvald’s most intimate friend and a great friend of mine too. He is just like one of the family.

 

Mrs. Linde: But tell me this—- is he perfectly sincere? I mean, isn’t he the kind of man that

is very anxious to make himself agreeable?

 

Nora: Not in the least. What makes you think that?

 

Mrs. Linde: When you introduced him to me yesterday, he declared he had often heard my name mentioned in this house; but afterwards I noticed that your husband hadn’t the slightest idea who I was. So how could Doctor Rank—?

 

Nora: That is quite right, Christine. Torvald is so absurdly fond of me that he wants me absolutely to himself, as he says. At first he used to seem almost jealous if I mentioned any of the dear folk at home; so naturally I gave up doing so. But I often talk about such things with Doctor Rank, because he likes hearing about them.

 

 

Questions

 

 

1. a) Why does Nora look disturbed at the beginning of this excerpt?

(3marks)

 

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

6

 

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

 

1. b) Who brought the box that Nora is unpacking at the beginning of this excerpt why did

 

Nora want it?                                                                                                                                                                 (2marks)

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

 

1. “Yes, Torvald wants me to. Look, here is the dress; Torvald had it made for me there, but now it is all so torn, and I haven’t any idea—–“

 

1. i) What does this reveal about the character of Nora? (2marks)

 

………………………………………………………………………………………

 

………………………………………………………………………………………

 

………………………………………………………………………………………

 

………………………………………………………………………………………

 

 

1. From this statement, describe the relationship that exists between Nora and

 

Torvald.(2marks)

 

………………………………………………………………………………………

 

………………………………………………………………………………………

 

………………………………………………………………………………………

 

………………………………………………………………………………………

 

 

 

 

7

 

iii)     Identify and explain a dramatic technique used in this statement (2marks)

 

………………………………………………………………………………………

 

………………………………………………………………………………………

 

………………………………………………………………………………………

 

………………………………………………………………………………………

 

 

1. Cite two things that indicate that Nora is lying about Dr. Rank’s sickness in this excerpt.

 

(2marks)

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

 

1. Explain the message in Dr. Rank’s story as narrated by the two women in this excerpt.

(2marks)

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

 

1. Apart from repairing the fancy dress, what else does Mrs. Linde repair in this play and

how?(3marks)

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

 

 

 

8

 

1. g) How is morality explored in this excerpt? (3marks)

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

 

1. h) Describe Mrs. Linde’s attitude towards Dr. Rank in this excerpt. (2marks)

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

 

i)	Explain Nora’s voice at the end of this excerpt	(2marks)
	………………………………………………………………………………………………
	………………………………………………………………………………………………
	………………………………………………………………………………………………
	………………………………………………………………………………………………
j)	Explain the word ‘dainty’ as used in this excerpt.	(1mark)

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

 

 

 

3. Read the story below then answer the questions that follow

 

Long time ago, the Hyena and the Rock where bosom friends. Whenever the Hyena was idle with nothing to eat, the Rock provided him with some warmth as he yawned away the day. He could sleep on the Rock, roll over to the other side and when he felt any movement, especially of what was edible, he stood on the Rock with a limp and peered into the horizon for what lady luck might have brought to his door-step.

 

 

9

 

On a rainy day, the Hyena would bring home huge chunks of carcasses, lay them on the Rock and devour ravenously. When his meal was over, usually after a day or two, he spent the rest of the days uncertain of his next meal, licking the remnants of blood left on the Rock. He licked these for days and the Rock remained silent and obedient.

 

One day when the Hyena had a meal- a smelly piece of meat he had salvaged from a pride lions in the vast savannah grassland, there was a big fight between the Hyena and the vultures who wanted to have a piece from his hard-earned meal. The Hyena bared his teeth to scare off the reluctant birds but the vultures with their sharp pointed beaks flew away with some pieces of the rotten bones. The struggle left the back of Rock with scratches and bruises.

 

That evening it rained heavily. The Hyena searched and searched and searched but he did not find a crack or space within the rock in which to hide. When morning came, the Hyena looked feverish as he went atop the Rock to await the warmth from the rising sun. The water from its now wet fur dripped down on the rock and when the sun’s eyes peered from the eastern horizon, the droplets glittered and reflected in the Hyena’s eyes. “Hmmm’ it feels good to be warm. But I’m hungry,” the Hyena said.

 

In the sweltering afternoon sun, the Hyena moved away to a shade that the canopy of trees had provided. In a short time, deep sleep overcame him. He slept carelessly having had no sleep the previous night. He slept on his belly, his sides and on his back snoring loudly. Suddenly his stomach rumbled like thunder and before he knew it, the contents of his bowels spewed out on the green grass. The smell was awful. He gave the steaming mixture a gleeful look before he pounced on it again. He guessed the future would be stormy without any morsel in sight.

 

 

After the long rains came a long dry spell. People waited for the rains. The pregnant clouds had receded and the sky was sapphire blue. The birds moved higher up the mountains. Even the King of the Jungle roamed keenly near the few watering points that still had the precious liquid- water. There was no prey in sight The Hyena lurked lazily behind prides waiting to scavenge.

 

After several days, weeks and months the Hyena approached the Rock again. He looked him more keenly this time. He prayed that God would grant the desires of his heart. “What a lovely back, the Rock has!” he thought, “he could make a meal in this adversity.” He moved closer and now the rock resembled a Hippo. As he went closer and closer, the Rock now changed to look like a sleepy antelope.

 

“Rock, you know I’m hungry yet you lie here like a meal,” the Hyena said. The Rock was quiet. “I will eat you one day. I will plunge my teeth into your neck and belly then you will be my meal.” But the Rock was still silent. “And you will make my meal for days. I will eat you in bits.” Again the Rock was dumb. The Hyena walked away singing happily:

 

A meal, meals you people

 

Let the hungry cry

 

And the weak die

But the lame will eat, eat and eat.

 

10

 

When the Hyena looked back, the back of the Rock looked yummy. He said, “God this one I have found out of my hand work. But you can still go ahead and find me another one.” Then to the Rock he said, “Even though you are quiet, you have heard.”

 

Two days later, the Hyena became the vultures’ sumptuous meal on the rock.

 

(Taken from Oloo Oliver’s Collection for Oral Narratives; 2019; Unpublished)

 

 

Questions

 

1. What in the story suggests that the relationship between Hyena and Rock was lopsided? (1mark)

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

 

1. Explain what the phrase “rainy day’ in paragraph two of the story reveals about the

 

Hyena’s life?                                                                                                                                                                 (2marks)

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

 

1. How does the saying: “When two bulls fight it is the grass that suffers,” apply in this

 

story?                                                                                                                        (2marks)

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

 

1. Cite two evidences from the story that indicate that Rock shielded Hyena from crisis. (2marks)

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

 

11

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

 

1. e) Comment on any two features of oral narratives in this story (4marks)

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

 

1. f) What two functions does Hyena’s song serve in this story? (2marks)

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

 

1. g) Explain what this story teaches us about human relationships. (3 marks)

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

 

 

12

 

1. h) Identify any two values that can be derived from this story. (2marks)

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

 

i)	What two instances show Hyena’s greed in this story?	(2marks)
	………………………………………………………………………………………………
	………………………………………………………………………………………………
	………………………………………………………………………………………………
	………………………………………………………………………………………………
j)	Explain what led to the death of the Hyena in the story?	(2marks)

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

………………………………………………………………………………………………

 

 

 

 

 

4. Grammar

 

1. Rewrite the following sentence according the instructions give after each. Do not

 

change the meaning.                                                                                                                                                              (5marks)

 

1. Zena studied her opponent’s face because she wanted to win contest. (Rewrite beginning with a present participle)

 

………………………………………………………………………………………

 

………………………………………………………………………………………

 

 

 

 

 

 

 

13

 

1. They were unaware that the thieves had dug a whole behind their house. (Begin:

 

Little…)

 

………………………………………………………………………………………

 

………………………………………………………………………………………

 

 

 

 

• The teacher asked us to write down the notes and show him at the end of the lesson. (Rewrite in direct speech)

 

………………………………………………………………………………………

 

………………………………………………………………………………………

 

 

1. The bachelor prepared his own supper. (Rewrite to remove gender bias)

 

………………………………………………………………………………………

 

………………………………………………………………………………………

 

 

1. You can serve me now. (Add a question tag)

 

………………………………………………………………………………………

 

 

1. b) Replace the underlined words with appropriate phrasal verbs. (3marks)

 

1. The thug could not escape from the hands of the police-officers.

 

………………………………………………………………………………………

 

 

1. I will visit you next week.

 

………………………………………………………………………………………

 

 

• My parents provide my basic needs at school.

 

………………………………………………………………………………………

 

 

1. c) Fill in the blanks with the correct form of the word given in brackets. (3marks)

 

1. Our principal is revered for her…………………………. character. (conscience)

 

1. The newspaper has a …………………………of over a million readers. (read)

 

• That club does not entertain those who are …………………………. in environmental conservation. (interest)

 

14

 

1. d) The following sentences contain errors. Rewrite them correctly (2marks)

 

1. We are discussing about how to improve in English.

 

………………………………………………………………………………………

 

………………………………………………………………………………………

 

 

1. They say he does not reply messages sent to him.

 

………………………………………………………………………………………

 

………………………………………………………………………………………

 

 

1. e) Use complex prepositions to complete the sentences below. (2marks)

 

1. Rana visited the yard ……………………………….. buying a brand new car.

 

1. ………………………. lethargy, most students do not like reading set books.

PAPER 3 ENGLISH MARKING GUIDE

MOCKS 1 2023

1(a)- Must be a story

– should bring out a lie he/she did not detect earlier.

– should include the reaction or effects of the revelation.

(b) The candidate should demonstrate clear knowledge of, and

suggest practical and effective ways of dealing with indiscipline in schools.

2. (a) Blossoms of the Savannah

“Failure or success is in the mind.”

– The candidate should highlight both failure and success as occasioned by

different characters in the text.

– There should be a clear connection between the inaction or action that brings

about the failure or success. Consider the following suggestions;

Introduction

Our actions or inactions have direct contribution to what we become. Ordinarily, we would

say, we can choose to succeed or fail, depending on the working of our mind.

Blossoms of the Savannah has characters who failed or succeeded because of what was

in their mind as shown below.

Body

1. Resian’s determination leads to her going to university
2. Resian successfully resists Olarinkoi. She had previously told him that he

may succeed in circumcising her on the body, but in her mind, she would remain

uncircumcised.

3. Resian fights monoeyed woman in a dream, and wins.
4. Taiyo, not so aggressive in her resistance to FGM, becomes a victim.
5. Taiyo is tolerant to the Nasila culture, especially in traditional dances,

she becomes a victim of those very culture.

6. Mama Milanoi’s failure to defend and protect her daughters leads to her

losing both of them. She fails as a mother.

7. MinikEneNkoito has a determination to succeed. Despite working in

a very hostile environment, she succeeds to rescue or free more

more than three hundred girls from early marriages and circumcision.

 

3. Short story.

Introduction

Humanity is premised on love for one another. When we fail to show love

and compassion to the less privileged in society, we act more or less like

beasts. On the other hand building a united caring society needs

our deliberate, conscious efforts to reach out to those in need.

Body

– Ezekiel fails to provide proper habitation for his own brother. He is sick

and lives in a flea infested hut. The pavement in town may have been better.

– Though the brother is a preacher, and we expect better from him, he

fails to take Mbane to hospital for treatment.  His wife, however,tries by giving

Mbane some medicine.

– The gay pedestrians could pass by talking of bright weather, lovely morning….they

would sing to the blue sky, whistle to the gay morning as their footsteps sang their way

down the pavement and this would taunt him. They offered nothing in spite of his

condition.

-Some gay people, however, would answer to his pleas( give him money)

– Those working around, though seeing , had an indifferent attitude. They were never

touched. Thieves, too, stole from him.

– ” Good men who thronged the brothels were not good enough to him. Moreover, they

cursed.

– Christians who sang praises and hallelujah noticed him but did not care. In fact they

considered him an abled bodied person only crippled more everyday by the idleness of

ofleasurely begging. They failed to show true Christ’s love.

Conclusion

From the above illustrations it’s obvious that omission is a sin just as commission.

We should show love through our actions.

 

 

 

1. Introduction

Many nations have become failed states due to bad leadership.  Before their total failure,

chaotic scenes, loss of life and destruction of property have preceded their fall.

Such is the situation in Kutula Republic as demonstrated below.

Body

1. Lacuna Kasoo decrees farming policies that cause uprising amongst people,

he sanctions Chipande as the only coffee farmer.

2. Lacuna hires his cronies, tribesmen and clan members only. This escalates people’s

revolt.

3. Inefficiency is rampant in government as those employed are not necessarily qualified

for those positions.

4. Thorn macay runs down Kutula colony through high handedness. People egitate for

freedom as seen through their king, King Kutula XV, ” your people will continue to die.”

5.Leaders look down upon the people, for example, Chipande says of the attendant,  “that

how we put them in their place,” meaning social and economic subjugation.

Conclusion.

From the illustrations above, it is clear that poor leadership brings nations down.

 

 

MOCKS 1 2023

 

 

MARKING SCHEME

 

FUNCTIONAL WRITING

 

You have returned to school after the mid-term break and realized that you left one of the set books back home. Write to your parent back home asking him or her to bring you the book during the Peace Prayer Day to be held in your school. Remember to tell them about your back to school, performance in the examinations you have done and your target grade at K.C.S.E.

 

(20 marks)

 

 

• Expect an informal letter. If not deduct – 4 AD

 

–      Accept both blocked (strictly) semi – blocked (strictly). If mixed deduct     1 mk.

 

• Tone – formal (This is tied to language mark)

 

FORMAT

 

Address 1         – (Don’t award if name is in address

 

Date                    – Format Accept only Eg 30^th July, 2019

 

(if different format deny mark)

 

Salutation – Accept Dear Mum, Dear Dad ONLY

 

Closing tag      – Your son/daughter/ Yours sincerely

 

Name (Accept one name or two)

 

 

 

CONTENT

 

–      Greetings/Pleasantries *P      (1 mark)

 

–      Mention of having forgotten a set-book and its title *ST    (2 mark)

 

–      Asking the parents to bring the book    *B (1 mark)

 

• Mentioning the date and time for the Peace Prayer *DT (2 mark)

 

• Mentioning the performance in an exam *PM (1mark)

 

–      Stating the target at KCSE *T             (1mark)

 

 

 

 

 

 

 

LANGUAGE   4 marks

 

 

Very good

 

Good

 

Fair

 

Weak

A – 4 (merit ticks)

 

B – 3

 

C – 2

 

D – 1 (Extremely chaotic)

 

 

1.  CLOZET TEST
Fill in each blank space in the following passage with the most appropriate word.	(10
marks)

 

Most African tribes have a communal (a) approach to life. A person is an individual only to the extent that he or she is a (b) member of a clan, a community or a family. Land was never owned by an individual, but by the people, and (c) could not be disposed of by anybody.

 

• where there were traditional heads, they held land in ( e) trust for the community generally. Food grown on the land was regarded as food to feed the hungry among the tribe. (f) Although each family might have its own piece of land on which to cultivate, when there was famine or when you simply wanted to eat, you merely looked for food and ate it. There was no (g) question/doubt on your mind as to who owned it. In many parts of Africa it was thought quite natural for travelers to walk (h) into the nearest garden, and pick some bananas or maize and eat. Nobody would interfere with them (i) unless they went in and started taking loads of food away. Then they were, of course, (j) disobeying / contravening the laws of hospitality and generosity, and exploiting the clan through whose land they were passing.

 

(adapted from Freedom and After; Tom Mboya; London; Andre deutsch; 1963)

 

 

2. ORAL SKILLS

 

1. Read the narrative below then answer the questions that follow.

 

In the beginning, the sun married the moon. They travelled together for a long time,

 

the sun leading and the moon following. As they travelled, the moon would get tired, and the un would carry her for three days every month.

 

One day the moon annoyed the sun and she was beaten by the sun, just the same way

 

some women are beaten by their husbands. But it happened that the moon was one of those short-tempered women who fight their husbands. When she was beaten, she fought back and wounded the sun’s forehead. The sun also beat the moon, scratched her face and plucked out one of her eyes.

 

 

When the sun realized that he was wounded, he was very embarrassed and said to himself “I am going to shine so hard that people will not be able to look at me”. And so he shone so hard that people could not look at him without squinting. That is why the sun shines so brightly.

 

As for the moon, she did not feel any embarrassment and so she did not have to shine any brighter. And up to now, if you look closely at the moon, you will see the wounds that the sun inflicted on her.

 

Questions

 

1. Mention any two ways by which you would prepare your audience to receive this story

 

(2

 

marks)

 

• Clear throat

 

• Ring bell

 

• Give relevant proverbs

 

• Tell a joke

 

• Clap hands

 

Any 2 plausible @ 1 mark = 2 marks NB: Personal involvement

 

 

1. How would you say the line: “ I am going to shine so hard that people will not be able to look at me” to bring out complete effect?

 

(3 marks)

 

• Verbal – rising intonation (indicating threat)

 

• Non-verbal – Accept any relevant

 

• Gesture

 

–      Facial expression     must specify

 

• Body movement

 

Accept Either

1 verbal

 

2 non verbal

 

OR

 

2 verbal

 

1 non – verbal

 

NB: Personal involvement

 

 

• Imagine you are the story-teller charged with the responsibility of narrating this story. What story telling devices would you employ and why?

 

(3 marks)

 

• Mimicry

 

• Tonal variation

 

• Facial expression

 

• Gestures & body movement / dramatization

 

Accept relevant / specific illustration of each

 

Any 3 x 1 = 3 marks

 

NB: Personal involvement

 

 

1. While telling the story, you realize that a section of the audience was passive. What was the likely cause for this?

 

(2 marks)

 

• I was inaudible

 

• I failed to involve /engage them in the story eg through involving them in signing, fillers etc.

 

• I failed to maintain eye contact

 

• Physical factors – Noise, heat

 

Any other relevant 2 @ 1 mark = 2 marks

 

 

1. b) Provide another word that has the same pronunciation as each of the following words.

 

i.	Wrapped	rapped
ii.	Lichen	liken
iii.	Room	rheum

 

1. c) State whether your voice will rise or fall at the end of each of the sentences below (3 marks)

 

i.	Fire! Fire!	Rise
ii.	Did carry your set book to class?	Rise
iii.	I was never visited by parents	Fall

 

 

1. Explain what you would do if you were, without prior notice, asked to pass a vote of thanks during your school’s Prize-Giving Day.

 

(4 marks)

 

• Accept the challenge

 

• Psyche myself, adopt, upright posture / confidence

 

• Speak audibly

 

• Recognize those present (hierarchy)

 

• Thank those who have attended / participating

 

• Highlight a few of items captured eg in speech esp guest of honour

 

• Encourage fellow students to work hard

 

• Eye contact

 

Any other relevant @ 1 mark = 4 marks NB: Personal involvement

 

 

1. You have attended a one-day seminar. The person sitting next to you is intruding into your personal space. What four personal space guidelines could this person have failed to follow?

 

(4 marks)

 

She could have been

 

• Seated too close for comfort

 

• Leaning on my shoulder

 

• Looking into my bag, phone / personal items

 

• Chewing to loudly / distracting me NB: Personal involvement

 

 

1. The following is a conversation between two girls. Identify and illustrate any three shortcomings in the Pet’s listening skills.

 

 

SHELLIE:       (Walking excitedly to her) Good afternoon, Sheillie..

 

PET:                  (Reading a newspaper. Looking up…) Afternoon to Pet (resumes reading)

 

SHELLIE:       (Beaming) Yesterday, I watched the students of Mpesa Academy eulogize the late Bob Collymore.

 

PET:                  The one that was brought live on TV? I don’t like funerals since I lost my aunt.

 

SHELLIE:       They were articulate and expressive in their show of emotions..

 

PET:                  So that moved you?

 

SHELLIE:       It not only moved me. It made me admire the late Bob.

 

PET:                  (Absent-mindedly) Even after being cremated? I would rather burn in hell.

 

SHELLIE:       (Insistent) I think he was a wonderful man; he had time for even little people.

 

PET:                  (Dismissively) So?

 

SHELLIE:       We can learn something from those who depart before us, Pet. It is possible.

 

PET:                   (Launching as she walks away) Ok. Keep learning. I hope you become professor.

 

SHELLIE:       Pet, I think something is the matter with you.

 

PET:                  (Waving at her) Bye! See you in school tomorrow.

 

 

 

1. Pet has

 

• Poor turn taking

 

• She does not pay attention / is absent minded

 

• Makes sarcastic remarks

 

• Pet is impolite / rude Identification – 1 mark Illustration(from the context) – 1 mark

Name ……………………………………………. Stream……… Index Number………

 

Candidate’s Signature……………………………                          Date ……………………

 

 

 

101/2

 

ENGLISH

 

PAPER 2

(Comprehension, Literary Appreciation and Grammar)

 

 

2½ HOURS

 

MOCKS 1 2023

 

 

English Paper 2- MARKING SCHEME

 

Instructions to candidates

 

• Write your name and index number in the spaces provided above.
• Sign and write the date of examination in the spaces provided above.

 

• Answer ALL the questions in this question paper.

 

• All your answers must be written in the spaces provided in this question paper.

 

• This paper consists of 13 printed pages

 

• Candidates should check the question paper to ascertain that all the pages are printed as indicated and that no questions are missing.

 

 

 

 

 

 

For Examiners’ use only

 

Question	Maximum	Candidate’s
	Score	Score
1	20
2	25
3	20
4	15

 

 

 

1

 

1. Read the passage below then answer the questions that follow:

 

If one said, “The room had an extremely obnoxious smell.” And another said, “The room had the smell of rotten fish.” Which of the two sentences is appealing? Whereas the first sentence may look superior with the word ‘obnoxious’ making it pronounced, the second one stands out. Why? It is more subtle, graphic and appeals to our senses of sight, smell and even taste. Apart from that it is memorable. This is the residence of imaginative or creative writing.

 

Writing is arguably the highest in the order of skills in language acquisition. It combines: listening, speaking and reading. When one writes, it is for reading and when one reads they are in a one- on-one conversation with the writer; laughing at the jokes, frowning and being drawn to feel with what the writer is saying. If this is the case then there is need for anybody who wants to write to give it some thought.

 

Good writing that evokes feelings begins with a mindset that delves beneath the surface of things. Creative writings swim in the undercurrents of human existence seeking to bring to the fore hidden nuances of things and human life. In imaginative writing one explains the universal significance of what they observe. For instance, if the twins born together but raised apart eventually reunite and seek to locate the fact surrounding their parentage, creative writing would focus on the twists not the obvious based on the phenotypically acknowledged attribute that a DNA test would readily confirm. But a captivating writing would be if the test also revealed that the fathers who have raised them are not their biological fathers. This would unearth more than what looks true in the surface.

 

It is this imagination that rises above the mundane human realities that would form some fodder for thought as one gleans through what has been creatively written. Scintillating stories have lived with humanity from the adorable age of oral narratives when animals satirized human foibles. Again, these were not stories for stories’ sake but ones with didactic values; a take-home that would make the human world a better place.

 

The significance of expressive language cannot be gainsaid in writing. Even scientific reading would be made more accessible and enjoyable if they employed not the jargons that exist in their registers but in how the scientific writers would manipulate language in such a way that would draw attention to itself. Deliberate diction and syntax would create a definite pattern in such writing so as to communicate the complex scientific terminologies with a light timbre of humour.

 

It is the writer’s thinking captured in images using words and phrases with an obvious appeal and impact on the senses of taste, touch, hearing, smell and sight that would engrain what is read into the hearts and minds of the readers. It is the sensory details communicated through words that are impressionistic. And writing is as good as the indelible impression it leaves on the reader’s mind.

 

Through good creative works, the reader is transported to worlds far and wide, real and imagined while unveiling the new insights that traversing such worlds bring to human experiences. It is the writer’s conscious effort that concretizes these fictional and real worlds

 

 

2

 

in any written piece. In such writings, love comes through as a beautiful flower and kindness as the milk of human life.

 

Sustained vivid accounts of human experiences captured in words using mental pictures engraved in human senses would make creative writing be in a better stead than an action-pact movie.

 

(Adapted from a paper presented by Oloo Oliver on Creative Writing to teachers at Star of the Sea; Mombasa County; 2017)

 

Questions

 

1. a) According to paragraph one, what does creative writing entail? (2marks)

 

Creative writing making expression which are subtle, graphic and appealing to the human senses so as to be memorable

 

1. b) Why is it important for anyone who wants to write to think? (2marks)

 

It is the highest in the order of skills in language acquisition that combines all the other skill; listening, speaking and reading.

 

1. c) Scintillating stories have lived with humanity from the adorable age of oral narratives

 

when animals satirized human foibles. (Rewrite beginning: Satirizing…)                                                                                                                                                                   (1mark)

 

Satirizing human foible, scintillating have live with humanity from the adorable age of oral narratives.

 

1. d) How would creative writing work as a ‘mode of transport’? (2marks)

 

Through good creative works the reader is transported to worlds far and wide, real and imagined while unveiling the new insights that traversing such worlds bring to human experiences.

 

1. e) Explain why twins are mentioned in this passage. (2marks)

 

To show that good creative writing should focus on twists and turns and not the obvious/ that creative writing goes beneath the surface.

 

1. In note-form mention any three things one needs to consider in creative writing. (3marks)

 

• Expressive language

 

• Deliberative diction and syntax.

 

• Thinking in terms of images.to create an indelible impression

 

g)	Why do you think impression is important in creative writing?	(2marks)
	It engrains what one reads into the heart and mind to leave and indelible impression
h)	According to the passage, what is the significance of creative writing?	(2marks)
	To be able to manipulate language in a manner that draws attention to itself to
	make reading enjoyable.
i)	Describe how creative writing would outdo movies.	(2marks)
		3

 

By sustained vivid accounts of human experiences captured in word using words engraved in human senses.

 

1. Give the meaning of the following word and expression as used in the passage

 

1. indelible

 

inerasable/lasting/unforgettable/memorable/rememberable/ingrained/indestru ctable

1. engraved in human senses.

 

Carved/etched/embossed/furrowed/embedded/chiseled/imprinted/lodged

 

2. Read the excerpt below then answer the questions that follow

 

Nora: (begins to unpack the box, but soon pushes it away from herself) If only I dared go out. If only no one would come. If only I could be sure nothing would happen here in the meantime. Stuff and nonsense! No one will come. Only I mustn’t think about it I will brush my muff. What lovely, lovely gloves! Out of my thoughts, out of my thoughts! One, two, three, four, five, six- (screams) Ah! There is something coming -, (makes a movement towards the door, but stands irresolute) (enter MRS. LINDE from the hall, where she has taken off her cloak and hat)

 

Nora: Oh, it’s you Christine. There is no one else out there, is there? How good of you to come!

 

Mrs. Linde: I heard you were up asking for me.

 

Nora: Yes, I was passing by. As a matter of fact, it is something you could help me with. Let us sit down here on the sofa. Look here. Tomorrow evening there is a fancy-dress ball at the

 

Stenborgs’, who live above us; and Torvald wants me to go as a Neapolitan fisher girl, and dance the Tarantella that I learned at Capri.

 

Mrs. Linde: I see; you are going to keep up the character.

 

Nora: Yes, Torvald wants me to. Look, here is the dress; Torvald had it made for me there, but now it is all so torn, and I haven’t any idea—

 

Mrs. Linde: We will easily put that right. It is only some of the trimming come unsewn here and there. Needle and thread? Now then, that’s all we want.

 

Nora: It is nice of you.

 

Mrs. Linde: (sewing) So you are going to be dressed up tomorrow Nora I will tell you what —

 

• I shall come in for a moment and see you in your fine feathers. But I have completely forgotten to thank you for a delightful evening yesterday.

 

 

 

 

4

 

Nora: (gets up, and crosses the stage) Well, I don’t think yesterday was as pleasant as usual. You ought to have come to town a little earlier, Christine. Certainly Torvald does understand how to make a house dainty and attractive.

 

Mrs. Linde: And so do you, it seems to me; you are not your father’s daughter for nothing. But tell me, is Dr. Rank always as depressed as he was yesterday?

 

Nora: No; yesterday it was noticeable. I must tell you that he suffers from a dangerous disease. He has consumption of the spine, poor creature. His father was a horrible man who committed all sorts of excesses; and that is why his son was sickly from childhood, do you understand?

 

Mrs. Linde: (dropping her sewing) But, my dearest Nora, how do you know anything about such things?

 

Nora: (walking about) Pooh! When you have three children, you get visits now and then from—- from married women, who know something of medical matters, and they talk about one thing and another.

 

Mrs. Linde: (goes on sewing a short silence) Does Doctor Rank come here everyday?

 

Nora: Everyday regularly. He is Torvald’s most intimate friend and a great friend of mine too. He is just like one of the family.

 

Mrs. Linde: But tell me this—- is he perfectly sincere? I mean, isn’t he the kind of man that

is very anxious to make himself agreeable?

 

Nora: Not in the least. What makes you think that?

 

Mrs. Linde: When you introduced him to me yesterday, he declared he had often heard my name mentioned in this house; but afterwards I noticed that your husband hadn’t the slightest idea who I was. So how could Doctor Rank—?

 

Nora: That is quite right, Christine. Torvald is so absurdly fond of me that he wants me absolutely to himself, as he says. At first he used to seem almost jealous if I mentioned any of the dear folk at home; so naturally I gave up doing so. But I often talk about such things with Doctor Rank, because he likes hearing about them.

 

 

Questions

 

1. a) Why does Nora look disturbed at the beginning of this excerpt? (3marks)

 

Krogstad had visited her and threatened her with dire legal consequences arising from the discrepancy in the bond she signed when she took a loan of 250pounds to save Torvald. She is also afraid that her much guarded secret might be revealed and this might ruin her relationship with the husband.

 

 

 

 

 

5

 

1. b) Who brought the box that Nora is unpacking at the beginning of this excerpt why did

 

Nora want it?                                                                                                                                                                 (2marks)

 

The nurse brought the box. Nora wanted it so that it can be repaired in readiness for the fancy-dress ball coming up at the Stenborgs’.

 

1. “Yes, Torvald wants me to. Look, here is the dress; Torvald had it made for me there, but now it is all so torn, and I haven’t any idea—–“

 

1. i) What does this reveal about the character of Nora? (2marks)

 

She is obedient/submissive– wants to go by what Torvald wants.

 

She is honest/sincere/truthful– admits that she has no idea how to fix the torn fancy dress.

1. From this statement, describe the relationship that exists between Nora and

 

Torvald.                                                                                                                                                     (2marks)

 

It is a hypocritical/pretentious. She wants to please Torvald by doing what he wants not because she likes it.

It is also cordial/warm. Torvald had a dress made for Nora.

 

• Identify and explain a dramatic technique used in this statement. (2marks)

 

Symbolism. The torn fancy dress that needs repair. It symbolizes the pretentious relationship between Nora and Torvald that requires fixing.

 

Suspense/Ellipsis. Nora doesn’t say the idea she doesn’t have for the dress. This keeps the audience guessing hence heightens the tension in the play. Situational irony. Nora’s dress is new yet it torn and requires repair. It helps heighten the tension in the play.

 

(1 mark for identification and illustration; 1 mark for explanation)

 

 

1. Cite two things that indicate that Nora is lying about Dr. Rank’s sickness in this excerpt.

(2marks)

 

• When asked by Christine how she gets to know about such details, she becomes restless and walks about

 

• She also hesitates/stammers when she says that she gets visitors who have a medical knowledge.

 

• She gives a flimsy reason– that because she has three children she gets visits from married women who know something about medical matters.

 

• It is evident that her reasons are based on gossip– that the women talk about one thing and another.

 

(Accept any two well explained)

1. Explain the message in Dr. Rank’s story as narrated by the two women in this excerpt.

(2marks)

 

• Love/Friendship. Dr. Rank is Torvald’s intimate friend and Nora’s great friend too.

 

6

 

• Dr. Rank suffers because of the excesses committed by his father- that if you live immoral life, it will make your children or relatives suffer too.

 

1. Apart from repairing the fancy dress, what else does Mrs. Linde repair and how? (3marks)

 

 

• She goes all out to repair Torvald-Nora relationship/marriage to make it be premised on truth and honesty rather than pretence. She does so by asking Krogstad not to withdraw the bond so that the truth about Nora’s secret can be known to Helmer. She also insists that Nora should let Helmer know about her much guarded secret.

 

• Christine repairs her broken relationship with Nils. She seeks him out, invites him to Helmer’s house, opens up to him and accepts to be the mother to his

	children.
g)	How is morality explored in this excerpt?	(3marks)
	Dr. Rank’s father committed excesses in his youth and as a result his son suffers
	from a disease- the consumption of the spine- that would finally kill him. This is a
	warning to people to live moral lives devoid of excesses.
h)	Describe Mrs. Linde’s attitude towards Dr. Rank in this excerpt.	(2marks)
	She is critical/condemnatory/spiteful/sarcastic of Dr. Rank. She thinks that he is not
	perfectly sincere.
i)	Explain Nora’s voice at the end of this excerpt	(2marks)

 

• Conceited/exultant/boastful/arrogant voice. She talks of how much Torvald possesses her jealously
• Ironic voice. That Torvald is absurdly fond her yet there are things she can only

 

share with Dr. Rank and not Torvald.

1. j) What does the word ‘dainty’ mean in this excerpt (1mark)

 

Beautiful/Charming/Exquisite/Lovely/Neat/Elegant.

 

3. Read the story below then answer the questions that follow

 

Long time ago, the Hyena and the Rock where bosom friends. Whenever the Hyena was idle with nothing to eat, the Rock provided him with some warmth as he yawned away the day. He could sleep on the Rock, roll over to the other side and when he felt any movement, especially of what was edible, he stood on the Rock with a limp and peered into the horizon for what lady luck might have brought to his door-step.

 

On a rainy day, the Hyena would bring home huge chunks of carcasses, lay them on the Rock and devour ravenously. When his meal was over, usually after a day or two, he spent the rest of the days uncertain of his next meal, licking the remnants of blood left on the Rock. He licked these for days and the Rock remained silent and obedient.

 

One day when the Hyena had a meal- a smelly piece of meat he had salvaged from a pride lions in the vast savannah grassland, there was a big fight between the Hyena and the vultures who wanted to have a piece from his hard-earned meal. The Hyena bared his teeth to scare off the reluctant birds but the vultures with their sharp pointed beaks flew away with some pieces of the rotten bones. The struggle left the back of Rock with scratches and bruises.

 

 

7

 

That evening it rained heavily. The Hyena searched and searched and searched but he did not find a crack or space within the rock in which to hide. When morning came, the Hyena looked feverish as he went atop the Rock to await the warmth from the rising sun. The water from its now wet fur dripped down on the rock and when the sun’s eyes peered from the eastern horizon, the droplets glittered and reflected in the Hyena’s eyes. “Hmmm’ it feels good to be warm. But I’m hungry,” the Hyena said.

 

In the sweltering afternoon sun, the Hyena moved away to a shade that the canopy of trees had provided. In a short time, deep sleep overcame him. He slept carelessly having had no sleep the previous night. He slept on his belly, his sides and on his back snoring loudly. Suddenly his stomach rumbled like thunder and before he knew it, the contents of his bowels spewed out on the green grass. The smell was awful. He gave the steaming mixture a gleeful look before he pounced on it again. He guessed the future would be stormy without any morsel in sight.

 

 

After the long rains came a long dry spell. People waited for the rains. The pregnant clouds had receded and the sky was sapphire blue. The birds moved higher up the mountains. Even the King of the Jungle roamed keenly near the few watering points that still had the precious liquid- water. There was no prey in sight The Hyena lurked lazily behind prides waiting to scavenge.

 

After several days, weeks and months the Hyena approached the Rock again. He looked him more keenly this time. He prayed that God would grant the desires of his heart. “What a lovely back, the Rock has!” he thought, “he could make a meal in this adversity.” He moved closer and now the rock resembled a Hippo. As he went closer and closer, the Rock now changed to look like a sleepy antelope.

 

“Rock, you know I’m hungry yet you lie here like a meal,” the Hyena said. The Rock was quiet. “I will eat you one day. I will plunge my teeth into your neck and belly then you will be my meal.” But the Rock was still silent. “And you will make my meal for days. I will eat you in bits.” Again the Rock was dumb. The Hyena walked away singing happily:

 

A meal, meals you people

Let the hungry cry

 

And the weak die

But the lame will eat, eat and eat.

 

When the Hyena looked back, the back of the Rock looked yummy. He said, “God this one I have found out of my hand work. But you can still go ahead and find me another one.” Then to the Rock he said, “Even though you are quiet, you have heard.”

Two days later, the Hyena became the vultures’ sumptuous meal on the rock.

 

(Taken from Oloo Oliver’s Collection for Oral Narratives; 2019; Unpublished)

 

 

Questions

 

 

8

 

1. What in the story suggests that the relationship between Hyena and Rock was lopsided? (1mark)

 

It is always the Hyena that benefited from the rock.

1. Explain what the phrase “rainy day’ in paragraph two of the story reveals about the

 

Hyena’s life?                                                                                                                                                                 (2marks)

 

The Hyena’s life depended on opportunities/chances that he did not work for/ the Hyena never worked for his own.

1. How does the saying: “When two bulls fight it is the grass that suffers,” apply in this

 

story?                                                                                                                                                                 (2marks)

 

The fight between the Hyena and the vultures over a smelly piece of meat, the back of the rock is left in scatches.

 

1. Cite two evidences from the story that indicate that Rock shielded Hyena from crisis. (2marks)

 

• The Hyena searches for a long time on the rock for a crack to hide in when it rains.

 

• When the Hyena is feverish after a heavy downpour he goes atop the rock to await the warm from the rising sun.

 

• When he is hungry with nothing to eat, he wants to eat the rock. (Expect any 2)

 

1. Comment on any two features of oral narratives in this story

(4marks)

 

• Opening formula eg. “Long time ago..” Transports the listener to the world of fantansy where the events of the story are plausible.

 

• Repetition eg. “..searched and searched and searched.” Creates rhythm/shows the Hyena’s desperation.

 

• Personification/Use of Dialogue eg. Hyena tells the rock that he would it it one ady but the rock remains silent. This makes the sory real and dramatic.

 

• Use of song eg. The Hyena sings with joy at the sight of the rock after staying for long without a meal. It develops plot/ breaks the monotony of narration.
• There is a moral lesson eg. Greed is bad.

 

 

f)

(Expect any two. No mark for identification without illustration.)

What two functions does Hyena’s song serve in this story?                                          (2marks)

 

 

• It breaks the monotony of narration.

 

• It develops the plot- prepares us for the encounter with the rock.

 

1. g) Explain what this story teaches us about human relationships. (3 marks

 

Human relationships are characterized by betrayals eg. The Hyena turns on the Rock when hungry in spite of the rock’s hospitality.

 

1. h) Identify any two values that can be derived from this story. (2marks)

 

Patience- Rock remained patient/calm despite the suffering he undergoes because of

 

the Hyena.

 

Love- the Rock remained a true friend to the Hyena even in times of crises.

 

9

 

1. i) What two things show Hyena’s greed in this story? (2marks)

 

• He gives his own smelly vomit a gleeful look then pounces on it.

 

• He imagines that the rock is now an antelope or hippo and wants to eat it.

 

1. j) What do you think led to the death of the Hyena in the story? (2marks)

 

• Hunger

 

• He might have attempted to eat the rock and this left him seriously injured.

 

 

 

 

4. Grammar

 

1. Rewrite the following sentence according the instructions give after each. Do not

change the meaning.                                                                                                                                                              (5marks)

 

1. Zena studied her opponent’s face because she wanted to win contest. (Rewrite beginning with a present participle)

 

Wanting to win the contest, Zena studied the opponent’s face.

 

 

1. They were unaware that the thieves had dug a hole behind their house. (Begin:

 

Little…)

 

Little did they know that the thieves had dug a hole behind their house.

 

• The teacher asked us to write down the notes and show him at the end of the lesson. (Rewrite in direct speech)

 

The teachers asked us, “Write down the notes and show me at the end of the lesson.”

 

OR

 

“Write down the notes and show me at the end of the lesson,” the teacher told us.

OR

 

“Write down the notes,” the teacher told us, “and show me at the end of the lesson.”

 

1. The bachelor prepared his own supper. (Rewrite to remove gender bias)

 

The unmarried prepared their own supper/The single prepared their own supper.

 

1. You can serve me now. (Add a question tag)

 

You can serve me now, will you?

 

10

 

1. b) Replace the underlined words with appropriate phrasal verbs. (3marks)

 

1. The thug could not escape from the hands of the police-officers. break away
2. I will visit you next week. call on

• My parents provide my basic needs at school.

 

 

cater for

 

1. c) Fill in the blanks with the correct form of the word given in brackets.

 

(3marks)

 

 

1. Our principal is revered for her conscientious (conscience)

 

1. The newspaper has a readership of over a million readers. (read)

 

• That club does not entertain those who are disinterested in environmental conservation. (interest)

 

1. d) The following sentences contain errors. Rewrite them correctly (2marks)

 

1. We are discussing how to improve in English.

 

 

1. They say he does not reply to messages sent to him.

 

 

1. e) Use complex prepositions to complete the sentences below. (2marks)

 

1. Rana visited the yard with a view to buying a brand new car.

 

1. Due to lethargy, most students do not like reading set books.

 

 

 

 

NAME …………………………………………. INDEX NO …………………………….

 

CANDIDATES SIGN ……………………………..  DATE………………………..

 

 MOCK EXAM

451/1

Computer Studies

Paper 1

(THEORY)

2 ½ Hours

 

 

1. State one function of each of the following.

(a) Peripheral devices                                                                                          (1 mark

 

(b) System software                                                                                             (1 mark)

………………………………………………………………………………………………………………………………………………………………………………………………

2. Give importance of having the following in computer laboratory;-             (3marks)
3. Standard furniture in the laboratory

………………………………………………………………………………………………

1. Antiglare screen/ monitor

………………………………………………………………………………………

• UPS

………………………………………………………………………………………………………………………………………………………………………………………………

3. Describe future trends in microcomputers in relation to:

(a)       Hardware                                                                                            (2 marks)

…………………………………………………………………………………

(b)       Software                                                                                             (2 marks)

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

4. Explain themeaningofBACKUP (2mks)

………………………………………………………………………………………

 

5. Differentiate between the following terms as used in word processing. (3marks)

• Drop Cap and Case

………………………………………………………………………………………

• Superscript and subscript

…………………………………………………………………………………………

• Indent and tab

………………………………………………………………………………………

6. Statetwo advantages ofelectronicspreadsheets overmanual workshee (2marks)

……………………………………………………………………………………

7. (a) State and explain any one type of computer processing file.                       (1mark)

………………………………………………………………………………………

(b)             List any two fileorganization methods                                                    (2marks) …………………………………………………………………………………………………………………………………………………………………………………………

8. Defineaprimarykeyfield (3marks)

…………………………………………………………………………………………

9. Statethetwo requirements of computerprogram testing (2marks)

 

…………………………………………………………………………………………………………………………………………………………………………………………………………………………

 

10. A computer studies form one student was requested to format his diskette in Windows XP Operating System environment. Instead, he selected and formatted the hard drive by mistake.

(a)       Explain why the student had to format his diskette.                         (1 mark)

……………………………………………………………………………………………………………………………………………………………………………………

(b)       Explain a possible consequence of the mistake made by the student.    (1 mark)

…………………………………………………………………………………………

(c)      Describe two situations when the computer user will be required to format a storage media.                                                                                               (1 mark)

……………………………………………………………………………………………………………………………………………………………………………………

11. Worksheet cells are referenced usingthe column letter and row number e. D2 is cell in column D and row2.

Usethesampleworksheet provided to answerthequestions below.

 

 

 

	A	B	C	D	E	F
1	Moth	Jan.	Feb	Mar.	April	Total
2	Fees	460	460	460	460
3.	Food	300	350-	305	270
4.	Electricity	100	100	100	100
5.	Fuel	150	150	150	150
6	Transport	38	270	150	300
7	total

a)   b)	Writedown thedatatypethat is stored in cells C5   What cell contains thedataitems representingtransport forthemonth of	(1mark)
	February?	(1mark)
c)	Writedown the formulathat maybeused to computethetotal in cell F6.	(1mark)

 

 

12. What is deadlock in reference to operating systems                                     (2marks)

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

13. One way in which computing technology has impacted positively on society is the ease of communication through the e-mail. State two disadvantages of e-mail. (2 marks)

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

14. Differentiate between baseband and broadband signal as used in networking. (2marks)
15. Baseband signal

……………………………………………………………………………………………………………………………………………………………………………………

1. Broadband signal

……………………………………………………………………………………………………………………………………………………………………………………

15. Explain two ways of protecting data and information against unauthorized access. …………………………………………………………………………………………………………………………………………………………………………………(2marks)

 

 

SECTION B (60 MARKS)

Answer question 16 (compulsory) and any other three questions from this section.

16. a) State the function of the following symbols as used in the flowchart.

(i)                                                                                                        (1 mark)

 

 

……………………………………………………………………………………………………

(ii)                                                                                                       (1 mark)

 

 

………………………………………………………………………………………………….

(b)To maintain a strategic fit Safaricom is introducing a tariff called the mega tariff that will lower costs to Safaricom to Safaricom calls and calls to other networks.  Calls to             Safaricom networks will be charged according to the time of the day as listed below:

-Between 8am to 12 noon – 6 Ksh

-Between 12 noon to 8pm-0.8 Kshs

-Between 8pm to 1 am -4Kshs

-Between 1 am to 8am- 1Kshs

Internal calls to other networks are charged at a fixed rate of Kshs 7 between 8am to 8pm             and Kshs 5 the rest of the day. International calls are charged at a rate of Kshs 25 between 8am to 8pm and Kshs 35 for the rest of the day.  All calls are charged per minute usage.

Mr. Wasswa Baale a business man who makes both internal and international calls would like to make maximum use of this tariff.

 

 

 

Write a pseudo code that would show him know the charges of calls with an appropriate label when he the inputs type of call and the time where appropriate.  Use a 24 hour clock.                                                                                                                                                (7 marks)

 

 

 

 

 

(c)       Design a flowchart for the pseudo code in 16(a) above.                               (6 marks)

 

 

 

 

 

 

17. Perform the followingbinaryarithmetic andgiveyour answers in decimal notation:

(i)       1010.101 +11.011                                                                (3marks)

 

 

(ii)      1010.011 – 11.011                                                                  (3marks)

 

 

 

 

 

 

 

(b)Covert the following numbers into theirbinaryequivalents

 

 

(i)       0.562510                                                                                                                          (3marks)

 

(ii)      0.312510                                                                                                                          (3marks)

 

1. c) Usingfour– bit twos compliment, perform the followingarithmetic (3marks)

101₂-111₂

 

 

 

 

 

 

 

 

 

 

 

 

18. A school computer laboratory is scheduled to undergo major renovations. The lab is schedule to receive new computer whose specifications are given below:-

Pentium IV 2.8GHz processor

40GB HDD

3 ½ FDD

256MB RAM

56 x CD ROM

17” SVGA TFT monitor

The computers are going to be networked and will be able to browse the internet.

1. Explain what is meant by the terms:-                                                           (2marks)
2. FDD

……………………………………………………………………………………………………………………………………………………………………………………………………

1. HDD

……………………………………………………………………………………………………………………………………………………………………………………………………

• SVGA

……………………………………………………………………………………………………………………………………………………………………………………………………

1. TFT

……………………………………………………………………………………………………………………………………………………………………………………………………

1. The computer is to be networked, name one extra device that should be fitted on every computer to enable this to happen             (1mark)

……………………………………………………………………………………………………………………………………………………………………………………………………

1. The computer is to receive internet facilities through the server on a dial; up system. Name and describe the function of a special device that needs to be connected to the server to complete the connection.       (1mark).

……………………………………………………………………………………………………………………………………………………………………………………………………

1. (i) The school has to apply star topology to link up the computer. List two advantages of this type oftopology.                                                       (1mark)

……………………………………………………………………………………………………………………………………………………………………………………………………

(ii) Name the central device used to connect the computers in this topology.   (1mark)

……………………………………………………………………………………………………………………………………………………………………………………………………

1. List two other types of topologies that the school could have opted for       (1mark)

……………………………………………………………………………………………………………………………………………………………………………………………………

1. List four advantages of using a network                                                 (2marks)

……………………………………………………………………………………………………………………………………………………………………………………………………

 

1. (i) Data transmission via the internet is done using a mode known as packet switching. Describe thisdata transmission mode.                                                             (1mark)

……………………………………………………………………………………………………………………………………………………………………………………………………

(ii) Name two other modes of transmission                                                        (1mark)

……………………………………………………………………………………………………………………………………………………………………………………………………

1. (i) The school’s LAN is done using UTR cable. List two advantages of using this type of cable. (1mark)

……………………………………………………………………………………………………………………………………………………………………………………………………

(ii) List two advantages of using fibre cable in networking.                  (1mark)

……………………………………………………………………………………………………………………………………………………………………………………………………

1. Data flows in the school’s LAN in a duplex manner. Discuss two other types of data transmission in network giving examples.                                                        (2marks)

……………………………………………………………………………………………………………………………………………………………………………………………………

19. a) The growth and widespread use of computers and its related technologies has led to job displacement, creation and replacement. Define the following terminologies.

(i)        Job displacement                                                                                (1mark)

………………………………………………………………………………………………………………………………………………………………………………………………

(ii)      Job creation                                                                                        (1mark)

………………………………………………………………………………………………………………………………………………………………………………………………

(iii)      Job replacement                                                                     (1mark)

………………………………………………………………………………………………………………………………………………………………………………………………

(b) Natural language processing is an area of computer systems evolution.

(i) Differentiate between natural language processing and voice input/output.(2marks)

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

(ii) State any two difficulties of implementing natural language processing.   (2 marks)

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

(c)(i) Explain three ways in which computers and related technologies can increase                         stress in the workplace.                                                                      (3 marks)

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

 

(ii) Suggest two ways in which computer related stress in the workplace can be minimized.

(2 marks)

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

(d)State any three examples of Internet use that may be considered morally wrong. (3 marks)

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

20. Define the following terms

• Database ( ½mark)

……………………………………………………………………………………………………………………………………………………………………………………………………

• Database management system ( ½ mark)

……………………………………………………………………………………………………………………………………………………………………………………………………

• Hierarchical database       (1mark)

……………………………………………………………………………………………………………………………………………………………………………………………………

• Relational database (1mark)

……………………………………………………………………………………………………………………………………………………………………………………………………

• Network database (1mark)

……………………………………………………………………………………………………………………………………………………………………………………………………

(b) List the advantages of using an electronic database system for storage of data over the file approach.                                                                                                              (4marks).

…………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

(c ) Study the spreadsheet below and answer the questions that follow

	A	B		C		D
1	WESTERN COMPBOOK CENTRE SALES
2	BOOK TITLE		PRICE PER BOOK		BOOKS SOLD
3	DBASE IV		400.00		145
4	LOTUS FOR DUMMIES		460.00		15
5	OFFICE WORD IN 3 DAYS		300.00		65
6	LEARN C++ IN 3 DAYS		700.00		100
7	TEACH YOURSELF PASCAL		700.00		200
8	COMPUTER STUDIES		500.00		300
9	THE CLEVER FOOL COMUTER		300.00		10
10

 

1. Write down the formula that can be used to find the price of the most costly book. (1mark)

……………………………………………………………………………………………………………………………………………………………………………………………………

1. Write down the formula that can be used to determine the total sales for the book titled COMPUTER STUDIES (1mark)

……………………………………………………………………………………………………………………………………………………………………………………………………

• Write down the formula that can be used to determine the average price of the books.(1mark)

……………………………………………………………………………………………………………………………………………………………………………………………………

1. Write down the formula in cell D6 that can be used to find the new price per book if they went up by a percentage written in cell B 10 and the formula has to be entered only in cell D3 then be copied to others.                                                                                       (1mark)

……………………………………………………………………………………………………………………………………………………………………………………………………

1. Write down the output in D7 if in B6 is 10% (1mark)

……………………………………………………………………………………………………………………………………………………………………………………………………

(d) State any four advantages of using an electronic spreadsheet as compared to a traditional worksheet.                                                                                                            (2marks)

……………………………………………………………………………………………………………………………………………………………………………………………………

______________________________

 

451/1

Computer Studies

Paper 1

(THEORY)

2 ½ Hours

 

 

1. State one function of each of the following.

(a) Peripheral devices                                                                                          (1 mark

 

(b) System software                                                                                             (1 mark)

………………………………………………………………………………………………………………………………………………………………………………………………

2. Give importance of having the following in computer laboratory;-             (3marks)
3. Standard furniture in the laboratory

………………………………………………………………………………………………

1. Antiglare screen/ monitor

………………………………………………………………………………………

• UPS

………………………………………………………………………………………………………………………………………………………………………………………………

3. Describe future trends in microcomputers in relation to:

(a)       Hardware                                                                                            (2 marks)

…………………………………………………………………………………

(b)       Software                                                                                             (2 marks)

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

4. Explain themeaningofBACKUP (2mks)

………………………………………………………………………………………

 

5. Differentiate between the following terms as used in word processing. (3marks)

• Drop Cap and Case

………………………………………………………………………………………

• Superscript and subscript

…………………………………………………………………………………………

• Indent and tab

………………………………………………………………………………………

6. Statetwo advantages ofelectronicspreadsheets overmanual workshee (2marks)

……………………………………………………………………………………

7. (a) State and explain any one type of computer processing file.                       (1mark)

………………………………………………………………………………………

(b)             List any two fileorganization methods                                                    (2marks) …………………………………………………………………………………………………………………………………………………………………………………………

8. Defineaprimarykeyfield (3marks)

…………………………………………………………………………………………

9. Statethetwo requirements of computerprogram testing (2marks)

 

…………………………………………………………………………………………………………………………………………………………………………………………………………………………

 

10. A computer studies form one student was requested to format his diskette in Windows XP Operating System environment. Instead, he selected and formatted the hard drive by mistake.

(a)       Explain why the student had to format his diskette.                         (1 mark)

……………………………………………………………………………………………………………………………………………………………………………………

(b)       Explain a possible consequence of the mistake made by the student.    (1 mark)

…………………………………………………………………………………………

(c)      Describe two situations when the computer user will be required to format a storage media.                                                                                               (1 mark)

……………………………………………………………………………………………………………………………………………………………………………………

11. Worksheet cells are referenced usingthe column letter and row number e. D2 is cell in column D and row2.

Usethesampleworksheet provided to answerthequestions below.

 

 

 

	A	B	C	D	E	F
1	Moth	Jan.	Feb	Mar.	April	Total
2	Fees	460	460	460	460
3.	Food	300	350-	305	270
4.	Electricity	100	100	100	100
5.	Fuel	150	150	150	150
6	Transport	38	270	150	300
7	total

a)   b)	Writedown thedatatypethat is stored in cells C5   What cell contains thedataitems representingtransport forthemonth of	(1mark)
	February?	(1mark)
c)	Writedown the formulathat maybeused to computethetotal in cell F6.	(1mark)

 

 

12. What is deadlock in reference to operating systems                                     (2marks)

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

13. One way in which computing technology has impacted positively on society is the ease of communication through the e-mail. State two disadvantages of e-mail. (2 marks)

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

14. Differentiate between baseband and broadband signal as used in networking. (2marks)
15. Baseband signal

……………………………………………………………………………………………………………………………………………………………………………………

1. Broadband signal

……………………………………………………………………………………………………………………………………………………………………………………

15. Explain two ways of protecting data and information against unauthorized access. …………………………………………………………………………………………………………………………………………………………………………………(2marks)

 

 

SECTION B (60 MARKS)

Answer question 16 (compulsory) and any other three questions from this section.

16. a) State the function of the following symbols as used in the flowchart.

(i)                                                                                                        (1 mark)

 

 

……………………………………………………………………………………………………

(ii)                                                                                                       (1 mark)

 

 

………………………………………………………………………………………………….

(b)To maintain a strategic fit Safaricom is introducing a tariff called the mega tariff that will lower costs to Safaricom to Safaricom calls and calls to other networks.  Calls to             Safaricom networks will be charged according to the time of the day as listed below:

-Between 8am to 12 noon – 6 Ksh

-Between 12 noon to 8pm-0.8 Kshs

-Between 8pm to 1 am -4Kshs

-Between 1 am to 8am- 1Kshs

Internal calls to other networks are charged at a fixed rate of Kshs 7 between 8am to 8pm             and Kshs 5 the rest of the day. International calls are charged at a rate of Kshs 25 between 8am to 8pm and Kshs 35 for the rest of the day.  All calls are charged per minute usage.

Mr. WasswaBaale a business man who makes both internal and international calls would like to make maximum use of this tariff.

 

 

 

Write a pseudo code that would show him know the charges of calls with an appropriate label when he the inputs type of call and the time where appropriate.  Use a 24 hour clock.                                                                                                                                                (7 marks)

 

 

 

 

 

(c)       Design a flowchart for the pseudo code in 16(a) above.                               (6 marks)

 

 

 

 

 

 

17. Perform the followingbinaryarithmetic andgiveyour answers in decimal notation:

(i)       1010.101 +11.011                                                                (3marks)

 

 

(ii)      1010.011 – 11.011                                                                  (3marks)

 

 

 

 

 

 

 

(b)Covert the following numbers into theirbinaryequivalents

 

 

(i)       0.562510                                                                                                                          (3marks)

 

(ii)      0.312510                                                                                                                          (3marks)

 

1. c) Usingfour– bit twos compliment, perform the followingarithmetic (3marks)

101₂-111₂

 

 

 

 

 

 

 

 

 

 

 

 

 

18. A school computer laboratory is scheduled to undergo major renovations. The lab is schedule to receive new computer whose specifications are given below:-

Pentium IV 2.8GHz processor

40GB HDD

3 ½ FDD

256MB RAM

56 x CD ROM

17” SVGA TFT monitor

The computers are going to be networked and will be able to browse the internet.

1. Explain what is meant by the terms:-                                                           (2marks)
2. FDD

……………………………………………………………………………………………………………………………………………………………………………………………………

1. HDD

……………………………………………………………………………………………………………………………………………………………………………………………………

• SVGA

……………………………………………………………………………………………………………………………………………………………………………………………………

1. TFT

……………………………………………………………………………………………………………………………………………………………………………………………………

1. The computer is to be networked, name one extra device that should be fitted on every computer to enable this to happen             (1mark)

……………………………………………………………………………………………………………………………………………………………………………………………………

1. The computer is to receive internet facilities through the server on a dial; up system. Name and describe the function of a special device that needs to be connected to the server to complete the connection.       (1mark).

……………………………………………………………………………………………………………………………………………………………………………………………………

1. (i) The school has to apply star topology to link up the computer. List two advantages of this type oftopology.                                                       (1mark)

……………………………………………………………………………………………………………………………………………………………………………………………………

(ii) Name the central device used to connect the computers in this topology.   (1mark)

……………………………………………………………………………………………………………………………………………………………………………………………………

1. List two other types of topologies that the school could have opted for       (1mark)

……………………………………………………………………………………………………………………………………………………………………………………………………

1. List four advantages of using a network                                                 (2marks)

……………………………………………………………………………………………………………………………………………………………………………………………………

1. (i) Data transmission via the internet is done using a mode known as packet switching. Describe thisdata transmission mode.                                                             (1mark)

……………………………………………………………………………………………………………………………………………………………………………………………………

(ii) Name two other modes of transmission                                                        (1mark)

……………………………………………………………………………………………………………………………………………………………………………………………………

1. (i) The school’s LAN is done using UTR cable. List two advantages of using this type of cable. (1mark)

……………………………………………………………………………………………………………………………………………………………………………………………………

(ii) List two advantages of using fibre cable in networking.                  (1mark)

……………………………………………………………………………………………………………………………………………………………………………………………………

1. Data flows in the school’s LAN in a duplex manner. Discuss two other types of data transmission in network giving examples.                                                        (2marks)

……………………………………………………………………………………………………………………………………………………………………………………………………

19. a) The growth and widespread use of computers and its related technologies has led to job displacement, creation and replacement. Define the following terminologies.

(i)        Job displacement                                                                                (1mark)

………………………………………………………………………………………………………………………………………………………………………………………………

(ii)      Job creation                                                                                        (1mark)

………………………………………………………………………………………………………………………………………………………………………………………………

(iii)      Job replacement                                                                     (1mark)

………………………………………………………………………………………………………………………………………………………………………………………………

(b) Natural language processing is an area of computer systems evolution.

(i) Differentiate between natural language processing and voice input/output.(2marks)

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

(ii) State any two difficulties of implementing natural language processing.   (2 marks)

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

(c)(i) Explain three ways in which computers and related technologies can increase                         stress in the workplace.                                                                      (3 marks)

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

(ii) Suggest two ways in which computer related stress in the workplace can be minimized.                                                                                                                                                (2 marks)

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

(d)State any three examples of Internet use that may be considered morally wrong. (3 marks)

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

20. Define the following terms

• Database ( ½mark)

……………………………………………………………………………………………………………………………………………………………………………………………………

• Database management system ( ½ mark)

……………………………………………………………………………………………………………………………………………………………………………………………………

• Hierarchical database       (1mark)

……………………………………………………………………………………………………………………………………………………………………………………………………

• Relational database (1mark)

……………………………………………………………………………………………………………………………………………………………………………………………………

• Network database (1mark)

……………………………………………………………………………………………………………………………………………………………………………………………………

(b) List the advantages of using an electronic database system for storage of data over the file approach.                                                                                                              (4marks).

…………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

(c ) Study the spreadsheet below and answer the questions that follow

	A	B		C		D
1	WESTERN COMPBOOK CENTRE SALES
2	BOOK TITLE		PRICE PER BOOK		BOOKS SOLD
3	DBASE IV		400.00		145
4	LOTUS FOR DUMMIES		460.00		15
5	OFFICE WORD IN 3 DAYS		300.00		65
6	LEARN C++ IN 3 DAYS		700.00		100
7	TEACH YOURSELF PASCAL		700.00		200
8	COMPUTER STUDIES		500.00		300
9	THE CLEVER FOOL COMUTER		300.00		10
10

 

1. Write down the formula that can be used to find the price of the most costly book. (1mark)

……………………………………………………………………………………………………………………………………………………………………………………………………

1. Write down the formula that can be used to determine the total sales for the book titled COMPUTER STUDIES (1mark)

……………………………………………………………………………………………………………………………………………………………………………………………………

• Write down the formula that can be used to determine the average price of the books.(1mark)

……………………………………………………………………………………………………………………………………………………………………………………………………

1. Write down the formula in cell D6 that can be used to find the new price per book if they went up by a percentage written in cell B 10 and the formula has to be entered only in cell D3 then be copied to others.                                                                                       (1mark)

……………………………………………………………………………………………………………………………………………………………………………………………………

1. Write down the output in D7 if in B6 is 10% (1mark)

……………………………………………………………………………………………………………………………………………………………………………………………………

(d) State any four advantages of using an electronic spreadsheet as compared to a traditional worksheet.                                                                                                            (2marks)

……………………………………………………………………………………………………………………………………………………………………………………………………

____________________________

NAME……………………………………………..INDEX NO…………………….

 

 

CANDIDATE SIGN.……………………. DATE………………………

 

Mock Exam

451/2

Computer Studies

Paper 2

(PRACTICAL)

2 ½ Hours

 

QUESTION ONE

(a)       Type the following text using a word processor, font size 12’, line spacing 1 1/2 and save it as ACM1.                                                                                                                    (20mks)

Congress Endorses Computer Science Education as Driver of Innovation, Economic

Growth

AC (1 0/21/0 9,)

ACM and several computing community partners commend the U.S. I-House of Representatives

passage of a resolution to improve the visibility of computer science as a transforming industry

that propels technology innovation and improves economic productivity. The House resolution

designates the week of December 7 as ‘National Computer Science Education Week’ and calls

on educators and policymakers to improve computer science learning at all education levels and to encourage increased participation in computer science.

ACM is working with Microsoft. Google, Intel. the Computer Science Teachers Association (CSTA), the NationalCenter for Women & Information Technology (NC WIT), and the Computing Research Association to improve awareness that computer science education is a national priority. “National Computer Science Education Week will help us draw attention to the need for an educational system that values computer science as a discipline and provides students with critical thinking skills and career opportunities,” says ACM Education Policy Committee chairBobby Schnabel, dean of the School of Informatics at IndianaUniversity.

 

CSTA executive director Chris Stephenson notes the vital role that computing plays in people’s daily lives, and stresses the urgency of building a strong computing workforce. “We need to expose K- 12 students to computer science concepts to help them gain critical 21st century skills and knowledge. and we’re grateful for Congress’ recognition of this need as a national priority,” Stephenson says. NCWI CEO and co-founder Lucy Sanders says the annual commemoration of National Computer Science Education Week can strengthen efforts to inform students, teachers, parents, and the public about how computer science enables innovation in all science, technology, engineering, and mathematics fields and creates economic opportunities.

 

 

 

REQUIRED

(a)       (i)        Format the heading as follows: Uppercase, size 16’, double underlined.      (3mks)

(ii)       Apply two columns in the second paragraph.                                                            (2mks)

(iii)      Indent the third paragraph to 0.5” to the right and 0.5” to the left. (2mks)

(iv)      Save the document as ACM2.                                                                                    (2MKS)

(b)       (i)        Copy ACM1 into a new document.                                                                (2mks)

(ii)       Apply drop cap in the first paragraph.                                                                       (2mks)

(ii)       Apply page break in the document so that each paragraph is in its own page.             (2mks)

(iii)      Number the pages in the document.                                                                          (2mks)

(iv)      Enter the following in page two of the document.                                                    (3mks)

PACKAGE	DURATION	FEES
WORD		1500
EXCEL	20 HOURS
ACCESS	25HOURS	3000
DTP	15 HOURS	3500

 

(iv)      Save as ACM3.                                                                                                           (3mks)

 

END

(c)       Print ACM1, ACM2 and ACM3.                                                                               (3mks)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Question Two

A school keeps its students details in a computer database. The information below contains details obtained from two tables of database. Study the tables and answer the following questions.

                                                DETAILS

NAMES	KCPE MARKS	ADMNO	Year Of KCPE	DORMITORY
Tom Jose	250	2030	2011	Ruvuma
Okoth Rao	356	2031	2012	Zaire
Ken Otieno	412	2032	2012	Tana
Dan Muoso	205	2033	2011	Ruvuma
Adan Hassan	400	2034	2010	Zaire
Ahmed Kubasu	185	2035	2011	Tana
Mutai Jemo	289	2036	2012	Ruvuma
Mutua Sarafi	300	2037	2012	Zaire
Muesh Linda	426	2038	2011	Tana
Viena Oscar	405	2039	2010	Zaire
Violet Kadija	336	2040	2012	Tana

 

PERFORMANCE
ADMNO	ENGLISH	MATHS	KISWAHILI	COMPUTER
2030	59	48	56	83
2031	56	36	48	76
2032	29	25	59	80
2033	88	79	65	67
2034	70	29	62	91
2035	39	46	24	68
2036	82	78	18	84
2037	54	75	19	46
2038	69	54	46	87
2039	53	96	75	24
2040	74	20	49	50

 

1. Create a new database called STUDENTS.       (2marks)
2. Design two tables: DETAILS and PERFORMANCE with the following properties in their fields:

Validate the ADMNO entry to exactly four characters, three characters for KCPE MARKS and DORMITORY names each to start with capital letter.                                                            (4marks)

1. c) Using appropriate primary and foreign keys create a relationship between the two tables and enforce referential integrity.                               (4 marks)
2. d) Create and use forms to enter data into tables.       (12 marks)
3. e) Create a query that would extract students whose name starts with letter “A” and save it as “Names”                                           (4marks)
4. f) Create a query that would display ADMNO, NAME, ENGLISH, MATHS,KISWAHILI and COMPUTER and calculate the totals of the four subjects, sort the totals in descending order. Save it as “MARKS”                                                       (4marks)
5. g) Create a query that would display only those students who sat their KCPE in 2012 and reside in Tana dormitory, save the query as “Tanas”                               (3marks)
6. h) Using the performance table, compute the average for ENGLISH field, standard deviation for MATHS field and Variance for KISWAHILI field to be displayed on the same table. (3marks)

(i) Create a form to display all fields of details table with the following:                                (7marks)

• Layout:-tabular
• Style:-opulent
• Title:-Dform
• Add two form controlsto “print” and “close” the form.

1. j) Create a report with the title “Excellent” using the query “MARKS” above.       (2marks)
2. k) Print:
3. Dform in portrait while the query “MARKS” in landscape       (2marks)
4. Performance table       (2marks)

• Report excellent

 

 

 

                                               END

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

QUESTION TWO

 

 

1. a) The following information was extracted from a mark book maintained by a class teacher of a certain school. Using a spreadsheet, create a worksheet that contains the information and save as Test 1.                                                                                                                                                          (5 marks)

NAME	MATH	ENG	KISW	BIO	PHY	CHEM
Muigai K.	85	81	60	92	90	74
Wakhisi N.	81	50	48	56	68	52
Otieno J.	62	71	44	55	60	60
Nasimiyu C.	70	42	51	48	62	88
Wamaitha D.	21	44	30	72	22	40
Kimeli F.	48	55	31	45	60	50
Chepchumba G.	98	54	65	30	40	45
Nasong’o R.	48	52	28	47	50	54
Saidi A.	49	56	65	58	50	55
Okiya S.	65	74	45	80	42	50

 

1. b) Create four new columns and label them as TOTAL, MEAN, GRADE and REMARK                                                                                                                (2 marks)
2. c) i) Using formulas compute the total and  mean for Muigai K. and copy it             to other cells to generate values for the other students.                                                                        (4 marks)
3. ii) Use an appropriate function to determine a grade and a remark for Muigai K. Use the following grading system to determine the student’s grade: (8 marks)

MEAN            GRADE                       REMARK

80 to 100                     A                     Excellent

70 to 79                       A-                    Very Good

60 to 69                       B                     Good

40 to 59                       C                     Fair

Below 40                     F                      Fail

2. ii) Copy the formulas to other cells in order to generate total, mean, grades and remarks for all the other students. Save your work as Test 2.                                     (3 marks)

iii) Format the mean marks to one decimal place.                                                    (1 mark)

1. d) The class teacher wishes to determine those students who are likely to qualify for a course in

medicine. For a student to qualify, he/she must have scored:

• 70 marks and above in Biology,
• 60 and above in either Chemistry or Physics,
• 50 and above in either English or Kiswahili.

Create a new column labeled MEDICINE and use an appropriate function to determine those students who qualify. If a student qualifies, the function should return “QUALIFY”, otherwise it should return “UNQUALIFIED”.                                                                         (5 marks)

1. e) Create a new column and label it as POSITION. Enter a function in cell L2 and copy it to other cells to determine the position of each student.             (4 marks)
2. f) Apply borders to your worksheet as follows:
3. i) Double outline border. (1 mark)
4. ii) Single line for inside vertical and horizontal borders. (1 mark)
5. g) Copy the data on sheet1 to sheet2 and rename the sheet2 as QUALIFY. Filter the worksheet to display the records of the students who qualify.                                                         (4 marks)
6. h) Create a bar graph on a separate sheet to compare the performance of the first four students in the six subjects. Label the bar graph appropriately.                         (4 marks)
7. i) Launch a word processor and type the following letter. Save as Confirmation. (3 marks)

15/03/2018

Dear <<NAME>>

We are pleased to inform you that you qualify to pursue a course in medicine having satisfied the admission board by posting a mean of <<MEAN>> and a mean grade of <<GRADE>> respectively. This performance placed in position             <<POSITION>>.

Thanks.

Yours faithfully,

1. J. Mwanamoshi

DIRECTOR

1. j) Merge the letter in (i) above (Confirmation) and the information on sheet 2 (QUALIFY) to generate letters for those students who qualify for a course in medicine. Save as Confirmation letters.                                                             (4 marks)
2. k) Print Test 1, Test 2, Confirmation and any one of the confirmation letters.       (2 marks)

 

 

____________________________________________

NAME:…………………………………………………ADM/NO……………………STR……..

 

451/2

COMPUTER STUDIES

FORM THREE ENDTERM ONE EXAM

PAPER 2

PRACTICAL

 

KISUMU GIRLS HIGH SCHOOL

 

TIME: 2HOURS

TERM 1 2021

 

INSTRUCTIONS TO CANDIDATES

• Type your name and admission number at the top right hand corner of each printout.
• 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 storage media.
• Answer all questions.
• All questions carry equal marks
• All answers must be saved in your CD-R/RW. Make printouts of the answers on the answer sheets provided.
• Hand in all the printout and the CD-R/RW
• Candidates may be penalized for not following instruction given in this pager
• Arrange your printout and staple them together.

 

 

 

 

 

 

 

 

 

 

 

 

QUESTION 1

1. Table 1, table 2 and table 3 are extracts of records, kept in a carpentry shop. Use the information to answer the questions that follow;

CAPENTER _ID	CAPENTER NAME		CUSTOMER _ID	CUSTOMER NAME
CAP_001	JAMES ALUSA		CUST_01	MARY KHASANDI
CAP_002	JOHN KANYO		CUST_02	DIANA KHAYANGA
CAP_003	ALEX MUYA		CUST_03	ALEX NYUMBILA
CAP_004	ISAAC WESA		CUST_04	MARTHA KHAOYA
CAP_005	MAURICE NDEYO		CUST_05	SARAH WAFULA
			CUST_06	JOHNSON LUVAHA

 

1. Carpenter Table            Customer Table
2. Order Table

CARPENTER _ID	CUSTOMER _ID	ORDER _NO	ITEM ORDERED	MONTH	AMOUNT
CAP_001	CUST _01	1721	Bench	January	18,000
CAP_002	CUST _02	1722	Coffee table	January	25,000
CAP_003	CUST _03	1723	Office table	January	10,000
CAP_004	CUST _04	1724	Single bed	January	18,000
CAP_005	CUST _05	1725	Arm chair	January	60,000
CAP_001	CUST _01	1726	Double bed	February	75,000
CAP_002	CUST _04	1727	Dining table	February	85,000
CAP_004	CUST _03	1728	Arm chair	February	60,000
CAP_001	CUST _02	1729	Double decker bed	February	72,000
CAP_002	CUST _06	1730	Kitchen table	February	82,000
CAP_004	CUST _02	1731	Bench	March	18,000
CAP_003	CUST _06	1732	bench	march	18,000

 

1. i) Using database application package, create a database file named;

CARPENTERINFORMATION                                                                                                                      (1mk)

1. ii) Create three tables named Carpenter Table, Customer Table and Order Table that will be used to store the above data.                                       (10mks)

iii) Set the primary key for the tables                                                                                                      (2mks)

1. iv) Create relationship among the tables         (2mks)

 

1. i) Create a data entry form for each table         (3mks)
2. ii) Enter the data in Carpenter Table, Customer Table and Order Table respectively

(11mks)

1. i) Create a query named individual income to display the amount received from each customer every month.                                       (4mks)
2. ii) Create a database object that computers Total income for each month. Save the query as                        (6mks)
3. Create a query named loyalty to compute the total number of orders made by each customer over the three months.                                                                                                                  (3mks)
4. Create a report to display order details, save the report as Order report                            (4mks)
5. Print the three tables and the report         (4mks)

 

QUESTION 2

Use a spreadsheet to manipulate data in the table below.

Adm No	Name	Stream	Comp	Art	Bus	Eng	Math	Student Mean	Rank
C001	Barasa	H	56	45	36	56	26
C002	Wangila	K	58	57	90	54	23
C003	Wafula	H	48	56	54	45	25
C004	Wanjala	K	78	95	78	46	24
C005	Kerubo	H	49	86	68	35	52
C006	Akinyi	K	56	45	25	63	54
C007	Odhiambo	H	75	78	45	65	56
C008	Okunyuku	K	89	69	65	53	51
C009	Nekesa	H	69	58	45	54	52
C010	Simiyu	H	85	46	78	52	53
	TOTAL
	TOTAL	FOR H
	TOTAL	FOR K

 

1. Enter the data in all bordered worksheet and auto fit all column. Save the workbook as

mark 1                                                                                                                                                                    (15mks)

1. Find the total marks for each subject         (3mks)
2. Find total for each subject per stream using a function         (5mks)
3. Find mean mark for each student using a function         (5mks)
4. Rank mean student in descending order using the mean         (5mks)
5. Create a well labeled column chart on a different sheet to show the mean mark of every student. Save the workbook as mark 2.                                                      (7mks)
6. Using mark1, use subtotals to find the average mark for each subject per stream. Save the workbook as mark 3                        (7mks)
7. Print mark 1,mark 2 and the chart

 

Terminologies used in DTP.

• Ranner – the main headline across the top of the page.
• Cross head – a small heading used to break up text into easily readable sections.
• Bullet – solid dot printed before pieces of text in order to add an emphasis.
• Cast off – a calculation as to how much space the text will use on a page.
• Footer – a line of text at the bottom of each page giving the publications title, author’s name, etc.
• Masthead – details of the person involved in printing the publication.
• WYSIWYG (What You See Is What You Get) – this means that, the presentation on the screen is exactly what you will get from the Printer.
• Jigging – moving text around by means of DTP software.

Setting up a publication using master pages.

Every publication has 1 or 2 blank Master pages identified by letter ‘L’ for left and ‘R’ for right. Letters L & R mark the master page icon for facing pages, while R alone marks a single-sided publication.

These icons appear at the lower left corner of a publication window.

 

To switch to master pages, click the master page icon, then:

 

1. Place non-printing ruler guides on the master pages.

 

Non-printing ruler guides are vertical or horizontal lines you place on the printable area.  They assist you to place text & graphics accurately & consistently throughout the publication.

 

To place ruler guides; point to the ruler, then drag the guide to the required position.

 

2. Create basic design elements on the master pages, including the text & graphics that you want to appear on each page in your publication.

 

Creating a new master page based on a publication page.

 

1. Switch to the publication page on which you want to base the new master.
2. Click on Window, then choose Show Master Pages.
3. From the Master Pages palette menu, choose Save Page As.
4. Type a name, then click Save.

 

Objects and guides applied to the selected publication page are copied to the new master.  The new master page then becomes active and its name appears on the Master Pages palette.

• To open the Master Pages palette menu, click the right-facing arrow at the right corner of the palette.

5. To turn to the master applied to the current publication page, click the name of the master page.

 

 

 

 

Displaying master pages and master page items.

 

Method 1:

 

1. Right-click the master page icon at the bottom of the publication window to display the list of masters, then select the master you want to view.

 

Method 2:

 

1. Click on Layout, choose Go to Page, and then select the name of the master you want.

 

Adding, or modifying guides & objects on a master page.

 

You can add or manipulate text and graphics, and change guides or rulers on a master page.  When you modify a master page, the changes appear instantly on associated publication pages.

 

To modify or rename a master page:

 

1. Display the master page you want to add or modify text, graphics, or nonprinting guides.

 

2. To change the master’s name, page margins, or column guides;

 

1. Press CTRL and double-click the name of the master page you want to modify or edit.
2. Type the new name, and the new values you want for margins or columns.
3. If you want the objects and guides (i.e., margins and columns) on the associated pages to be repositioned or resized as appropriately as those of the master you are editing, select Adjust Layout.

 

3. Click OK.

 

Deleting a master page and all the objects on it.

 

1. Click on Window, then choose Show Master Pages.
2. Select the master page to delete, then click the trash button on the bottom of the palette.
3. When prompted, click OK.

 

Setting up margin guides

 

Margin guides are very important because; they define the printable area of your publication.

 

To change margin settings;

 

1. Click on File, then choose Document Setup.

 

• For a double-sided document (i.e., a document that will be printed on both sides), enter the values for inside & outside margins to accommodate binding. For single-sided pages, set the Left & Right
• Enter the values for the Top & Bottom

 

2. Click OK.

 

Displaying and hiding rulers

 

1. To display the rulers, click on View, then select Show rulers. To hide the rulers, click on View, then select Hide rulers

 

Setting measurement units of a ruler

 

You can set the measurement units on both the vertical and horizontal ruler.

 

1. Right-click each ruler separately, to display a list of the available measurement systems.
2. Select the measurement unit you want to use, e.g., millimeters, inches, etc

 

 

 

 

 

 

 

SAVING THE LAYOUT OF YOUR PUBLICATION

 

Once you set up your publication layout, it is important to save it before you start entering text and graphics.

 

To save a publication for the first time.

 

1. Click on File, then choose Save or Save As (or press CTRL+’S’).
2. In the Save Publication dialog box, type a name for the publication, then select a drive or folder in which to store the publication.
3. Click Save.

 

After you name and save a publication once, the Save and Save As commands function differently:

 

To save changes made to a publication.

 

1. Click on File, then choose Save (or click the Save button on the toolbar).

This saves the changes made to your publication with the same filename.

 

Using the ‘Save As…’ command.

 

Save As can be used if you want to:

 

• Name and save a new publication.
• Save a publication on a different disk drive or in a different folder.
• Make a copy of an existing publication with a new name, leaving the original publication unchanged.

 

To save a publication with a new name or in a different location.

 

1. Click on File, then select Save As.
2. In the Save Publication dialog box, select the new location you want to save your publication in and/or type a new name.
3. Under Copy, select an option.
   • No additional files – saves the current publication only.
   • Files required for remote printing – copies all the files needed to print the publication to one location.
4. Click Save.

 

Reverting to the Last Saved version.

 

Sometimes, you may make changes to a document that make the document more confusing.  To abandon all the changes and restore the most recently saved version of your publication;

 

1. Click on File, then select Revert.
2. In the prompt that appears, click OK.

 

This deletes all changes made since the last time you saved the publication.

 

Closing a publication.

 

This closes the active publication and returns to the PageMaker window.

 

1. Click on File, then choose Close.

 

If you have made any changes since you last saved the publication, PageMaker asks if you want to save those changes.  You can save the changes, or ignore them.

 

Opening an existing publication.

 

1. Click on File, select Open (or press CTRL+’O’).
2. In the Open Publication dialog box, select the drive or folder that contains the document.
3. Select the filename of the publication you want to open.
4. Choose whether to open it as Original or a Copy, then click Open.

 

 

To quickly open a recently saved publication.

 

PageMaker keeps track of the last eight publications you opened and saved.

 

1. Click on File menu, then choose Recent Publications.
2. Select the publication you want to open from the Recent Publications

 

Review Questions.

 

1. Identify four common features in word processing and desktop publishing software.
2. Differentiate between the Pasteboard and Printable page.
3. (a). What are Master pages?

(b). Why are master pages important in a publication?

4. What commands are used in place of portrait and landscape page orientation in PageMaker?
5. Explain the importance of the following tools on the PageMaker’s toolbox.

• Pointer tool
• Text tool
• Rotate tool
• Line tool
• Hand tool
• Zoom tool

WORKING WITH TEXT

 

Adding text to a PageMaker publication.

 

Text can be entered into a PageMaker publication in 2 main ways:

 

• Typing the text directly into a page.
• Importing the text from another program.

 

Method 1: Typing text directly into the page.

 

1. Click the Text tool (T) from the toolbox. The pointer turns into an I-beam (insertion point).
2. Click at the point where you want to insert text on the page, then type the text.

–Or–

Drag a rectangular area to define a text block or text frame, then type the text.

 

A text frame defines the space you want the text to occupy.  It confines the text to the area you’ve selected.

 

3. To display the boundaries of the text block you’ve created, select the Pointer tool and click anywhere in the text.

 

Method 2: Pasting text from another Window-based program.

 

1. Select the text you want to copy, e.g., in Microsoft Word.
2. Click on Edit, then choose Copy.
3. Switch to the PageMaker program, e.g., using ALT+TAB.
4. Click to place the insertion point where the pasted text should start.
5. Click on Edit menu, then choose Paste.

 

Changing the view of a Page.

 

After typing text into a PageMaker publication, you may need to increase or decrease the page view to see either all the text and graphics or to magnify a portion of the page.

 

1. Click in the text or select the graphic you want to see clearly so that when you magnify, it comes to the center of the screen

 

2. Click on View menu, then choose:

 

• Actual Size – to see text and graphics as they will appear when printed.

 

• Fit in Window – to check the overall composition of a page or a two-page spread.

 

-Or-

 

• Choose Zoom To, then click the desired view from the list that appears, e.g., 25%, 50%, 75%, 100%, etc.

 

• Entire Pasteboard – to view objects on the pasteboard.

 

Selecting text in a PageMaker publication.

All text in PageMaker is contained either in text blocks or in text frames.

 

Method 1: Selecting text using the Text tool (T).

 

When the text is selected using the Text tool, you can type, edit or change the text attributes, e.g., Bold, Underline, etc.

 

1. Select the Text tool from the toolbox.
2. Move the cursor to the beginning of the text to be worked on, then drag the I-beam to select a range of text.

 

Alternatively;

 

• To select a word, double-click the word.
• To select an entire paragraph, triple-click the paragraph.

 

3. Choose the desired command to apply to the text.

 

Method 2: Selecting text using the Pointer tool (ë).

 

The Pointer tool is used to select a text block.  When you click the text using the Pointer tool, a line appears at the top and at the bottom of the text block.

 

This method is used if you want to:

• Move the text block.
• Change the size of the text block.
• Delete the text block.

 

Method 3: Using the Select All command.

 

This selects all the objects and/or text in a text block.

 

1. Using the Text tool, click anywhere inside the text block.
2. On the Edit menu, click Select All (or press CTRL+’A’).

To deselect, click an empty part of the page (or choose Deselect All from the Edit menu).

 

Selecting objects.

 

• To select a single object, click the object with the Pointer tool to display the object’s border.

 

• To add objects to a selection, hold down SHIFT as you click other objects.

 

• To select several objects at once, drag the pointer tool around multiple objects. Make sure you include each object’s bounding box (as indicated by its selection handles).

 

• To select an object underneath another object on the same layer, press CTRL and click the object you want to select.

 

Editing a publication.

 

The term editing means making changes to a publication.

 

PageMaker has two special editing tools:

 

• The Find and Change tool, and
• The Spelling

 

Therefore editing a publication includes the process of correcting spelling mistakes, and replacing of words.

 

Note.  Before editing the publication, you must open it in the story window.

 

PageMaker defines each text block as a story.  A Story is a collection of text that PageMaker recognizes as a single unit for editing purposes.

 

A story can be just one letter or several hundred pages of text.

 

Searching for and replacing words in the publication.

 

The Find and change tool helps a person to search for specific occurrences of a particular word or a group of words in a publication and replace it with another one.

 

To find and change a word or a phrase in the publication:

 

1. Using the Text tool, click an insertion point in a story, or select a range of text if you want to limit your search to that section.
2. Click on Edit, then select Edit Story. The publication now opens in the story window showing only the text but not the graphical objects.
3. Click on Utilities, then select Find or Change. A dialog box is displayed.
4. In the Find What textbox, type the word you want to find. To change the word, type the new word to replace with in the Change To
5. Under Search document, select an option to determine the scope of the search, e.g., Current publication or in all open publications. If you search the current publication only, select an option in the Search Story.
6. Click Find in the dialog box to begin the search. To continue with the search operation, select Find Next.
7. Once you are through, click on Story, then choose Close Story.

 

Spell-checking the publication.

 

1. Click the I-beam anywhere in the publication or select the range to be spell checked.
2. Click on Edit, then select Edit Story.
3. Click on Utilities, then select Spelling. A dialog box is displayed with the following options:

 

• Change To: – displays the word PageMaker does not recognize. Type or select the correct word from the list in the Suggestions

 

• Ignore: –

 

• Replace: – replaces the misspelled word with the one you have typed in the Change To box, or selected in the Suggestions

 

• Add: – opens the Add word to user dictionary dialog box in which you specify the word you want to add to or remove from the dictionary.

 

4. Under Search story, specify the scope of the search, e.g., in selected text, in the Current story only, or in All stories in the publication.
5. Specify spell checking options:

 

• Alternate Spellings – it lets you see suggested replacements for misspelled words.
• Show Duplicates – displays repeated words.

 

6. Click the Start button to begin spell checking.

 

Deleting text.

 

1. Select the text to be deleted.
2. On the Edit menu, select Clear (or press the Delete key).

 

Moving and copying text.

 

1. Select the text to be moved or copied.
2. On the Edit menu, click Cut (or press CTRL+’X’) to move the text to a new location, or click Copy (or press CTRL+’C’) to make a duplicate of the selected text.
3. Click or select where you want to move or copy the text to.
4. On the Edit menu, click Paste (or press CTRL+’V’).