COMPUTER FORM 2 SCHEMES OF WORK

TERM 1
APPLICATION PACKAGES (WORD PROCESSORS)
WE LES TOPIC SUB - TOPIC OBJECTIVES LEARNING/TEACHING LEARNING/TEACHING REFERENCES REMARKS
EK SO ACTIVITIES RESOURCES
N
1 Reporting from home and settling for first term work

2 1 DEFINITION OF By the end of the lesson,  Q/A discussion  Newspapers  Longhorn

WORD PROCESSOR the learner should be able  Letters Secondary.
to  Cards S.Mburu, G.
 Define the term  books Chemwa page 1-
word processor 3
 Explain the
purpose of a word
processor

2-3 USING A WORD By the end of the lesson,  Q/A demonstration  Handouts  Longhorn
PROCESSING the learner should be able practical  Books Secondary.
PACKAGE to  Working S.Mburu, G.
 Start a Microsoft personal Chemwa page 5-
word computer 10
 Explain the
Microsoft screen
layout

3 1 RUNNING THE By the end of the lesson,  Q/A demonstration  Books

PROGRAMME the learner should be able practical  Handouts  Longhorn
to  Working Secondary.
 Save and retrieve computer S.Mburu, G.
 Close and exit Chemwa page
13-17

2-3 EDITING AND By the end of the lesson,  Q/A demonstration  Handouts  Longhorn
FORMATTING A the learner should be able practical  Books Computer
DOCUMENT to  Working studies
 Select a computer Secondary.
document S.Mburu, G.
 Move, copy and Chemwa page
delete 16-19
 Insert and type
over

4 1 FIND AND REPLACE By the end of the lesson,  Q/A Demonstration  Letters  Longhorn
the leaner should be able practical  Card working Computer
to computer studies
1
  Define the term Secondary.
find and replace S.Mburu, G.
 Find and replace a Chemwa page
documents 16-24
 Use thesaurus

2-3 TEXT FORMATTING By the end of the lesson,  Q/A Demonstration  Letters  Longhorn
the learner should be able practical  Cards Computer
to  Working studies
 Bold, italicize, computer Secondary.
underline, change S.Mburu, G.
fonts Chemwa page
22-23

5 1 PARAGRAPH By the end of the lesson,  Q/A demonstration  Handouts  Longhorn

FORMATTING the learner should be able practical  Cards Computer
to  Working studies
 Drop cap, sub and computer Secondary.
superscript S.Mburu, G.
 Align and indent Chemwa page
text 22-23

2-3 PARAGRAPH By the end of the lesson,  Q/A demonstration  Books  Longhorn
FORMATTING the learner should be able practical  Newspapers Computer
to  Working studies
 Space and section computer Secondary.
break S.Mburu, G.
 Bullet and Chemwa page
number 22-23
 Insert
columns/page
headers and
footers

6 1 SET-UP By the end of the lesson,  Q/A demonstration  Handouts  Longhorn

the learner should be able practical  Working Computer
to computer studies
 Set up margins Secondary.
 Set paper size and S.Mburu, G.
orientation Chemwa page
33-35

2-3 SET-UP By the end of the lesson,  Q/A Demonstration  Handouts  Longhorn
the learner should be able practical  Working Computer
to computer studies
 Define the term  books Secondary.
2
 table S.Mburu, G.
 Crate tables Chemwa page
 Insert rows and 37-39
columns
 Merge/split rows

7 1 TABLE By the end of the lesson,  Q/A Demonstration  Handouts  Longhorn

CONVERSION/ the learner should be able practical  Working Computer
ARITHMETIC to computer studies
CALCULATIONS  convert text to a  Chalk board Secondary.
table and vice S.Mburu, G.
verse Chemwa page
 import 40-41
tables/perform
calculations

2-3 MAIL MERGE By the end of the lesson,  Q/A Demonstration  Letters  Longhorn
the learner should be able practical  Card Computer
to  Working studies
 Define the term computer Secondary.
mail merge  Chalk board S.Mburu, G.
 Create: main Chemwa page
document and 44-46
data source
 Merge fields

8 1 GRAPHICS By the end of the lesson,  Q/A Demonstration  Clip art  Longhorn
the learner should be able practical  Working Computer
to computer studies
 Define the term Secondary.
graphic S.Mburu, G.
 Insert/edit Chemwa page
graphics 44-49

2-3 PRINTING By the end of the lesson,  Q/A Demonstration  Letters  Longhorn
the learner should be able practical  Working Computer
to computer studies
 Define the term Secondary.
printing S.Mburu, G.
 Set up the printer Chemwa page 44
and print

9 1 SPREAD SHEETS By the end of the lesson,  Q/A Discussion  Call register  Longhorn
(SPREADSHEETS) the learner should be able  Accounts book Computer
to studies
 Define the term Secondary.
3
 spreadsheets S.Mburu, G.
 Explain the Chemwa page
application areas 52-53
of spreadsheet

2-3 CREATING A By the end of the lesson,  Q/A demonstration  Handouts  Longhorn
WORKSHEET the learner should be able practical  Class register Computer
to  Accounts book studies
 Define the term  Working Secondary.
worksheet computer S.Mburu, G.
 Create a Chemwa page
worksheet 57-65
 Save/retrieve a
worksheet

10 1 CELL DATA TYPES By the end of the lesson,  Q/A discussion  Books  Longhorn
the learner should be able Computer
to studies
 Define the term Secondary.
cell data type S.Mburu, G.
 Explain the Chemwa page 66
different data
types

2-3 CELL REFERENCING By the end of the lesson,  Q/A Demonstration  Books  Longhorn
the learner should be able practical  Handouts Computer
to  Working studies
 Define the term computer Secondary.
cell referencing S.Mburu, G.
 Explain the Chemwa page
different cell 66-69
referencing
 Apply cell
referencing on a
computer

11 1 FUNCTIONS AND By the end of the lesson,  Q/A demonstration  Working  Longhorn
FORMULAE the learner should be able Practical computer Computer
to  Books studies
 Differentiate Secondary.
between S.Mburu, G.
functions and Chemwa page
formulae 70-73
 Apply functions
and formulae on a
document
4
 2-3 WORKSHEET By the end of the lesson,  Q/A Demonstration  Books  Longhorn
FORMATTING the learner should be able practical  Handouts Computer
to  Working studies
 Format a computer Secondary.
worksheet: text, S.Mburu, G.
numbers, rows, Chemwa page
columns and 74-79
global

12 1 DATA By the end of the lesson,  Q/A Demonstration  Books

MANAGEMENT the learner should be able practical  Working  Longhorn
to computer Computer
 Explain the terms, studies
Sort, filter, total Secondary.
forms S.Mburu, G.
 Apply the above Chemwa page
features 73-75

2-3 CHARTS/GRAPHICS By the end of the lesson,  Q/A Demonstration  Books  Longhorn
the learner should be able practical  Handouts Computer
to  Working studies
 Definite the terms computer Secondary.
chart S.Mburu, G.
 Explain the Chemwa page
different charts 77-79
 Insert charts

END TERM EXAMS/SCHOOLS CLOSE

COMPUTER FORM 2 SCHEMES OF WORK – TERM 2

DATABASES
WE LES TOPIC SUB - TOPIC OBJECTIVES LEARNING/TEACHING LEARNING/TEACHING REFERENCES REMARKS
EK SO ACTIVITIES RESOURCES
N
1 Reporting from home and settling for the second term work

2 1 DATABASE By the end of the lesson,  Q/A discussion  Class list  Longhorn
the learner should be able Computer
to studies
 Define the Secondary.
5
 database S.Mburu, G.
 Explain the Chemwa page
concept of D/base 93-94

2-3 DATABASE By the end of the lesson,  Q/A demonstration  Handouts  Longhorn
MODELS the learner should be able practical  Books Computer
to  Working studies
 Define the term computer Secondary.
d/base model S.Mburu, G.
 Explain the Chemwa page
difference d/base 96-98
models
 Discuss the
features of a
database

3 1 DATA By the end of the lesson,  Q/A demonstration  Handouts

ORGANIZATION the learner should be able practical  Books  Longhorn
to  Working Computer
 Organize data in a computer studies
database Secondary.
 Start Ms Access S.Mburu, G.
Chemwa page
97-100

2-3 MS ACCESS By the end of the lesson,  Q/A Demonstration  Letters  Longhorn
SCREEN LAYOUT the learner should be able practical  Cards Computer
to  Books studies
 Explain the access  Working Secondary.
screen layout computer S.Mburu, G.
 Create a database Chemwa page
100-104

4 1 EDITING A D/BASE By the end of the lesson,  Q/A Demonstration  Letters  Longhorn
the learner should be able practical  Cart Computer
to  Working studies
 Edict a data base computer Secondary.
S.Mburu, G.
Chemwa page
108-109

2-3 QUERIES By the end of the lesson,  Q/A Demonstration  Letters  Longhorn
the learner should be able Practical  Card Computer
to  Working studies
 Define the term computer Secondary.
query S.Mburu, G.
6
  Crate a query Chemwa page
116-117

5 1 UPDATING A By the end of the lesson,  Q/A Demonstration  Handouts  Longhorn

QUERY the learner should be able practical  Books Computer
to  Working studies
 Update a query computer Secondary.
 View a query S.Mburu, G.
Chemwa page
120-122

2-3 FORM DESIGN By the end of the lesson,  Q/A Demonstration  Books  Longhorn
the learner should be able practical  Newspaper Computer
to  Working studies
 Explain the form computer Secondary.
layout S.Mburu, G.
 Create a form Chemwa page
110-113

6 1 FORMATTING By the end of the lesson,  Q/A Demonstration  Handouts  Longhorn

FIELDS the learner should be able practical Computer
to studies
 Display records in Secondary.
a form S.Mburu, G.
 Format fields Chemwa page
113

2-3 REPORTS LAYOUT By the end of the lesson, Q/A Demonstration Practical  Handouts  Longhorn
the learner should be able  Books Computer
to  Working studies
 Define a report Computer Secondary.
 Create a report S.Mburu, G.
 Modify a report Chemwa page
125-129

7 1 REPORTS LAYOUT By the end of the lesson,  Q/A Demonstration  Forms  Longhorn
the learner should be able practical  Report Computer
to  Working studies
 Sort and group computer Secondary.
data in a report S.Mburu, G.
 Design labels Chemwa page
40-41

7
 2-3 PRINTING By the end of the lesson,  Q/A Demonstration  Forms  Longhorn
the learner should be able Practical  Report Computer
to  Working studies
 Define the term computer Secondary.
printing S.Mburu, G.
 Print: form and a Chemwa page
report 112
DESKTOP PUBLISHING

8 1 DESKTOP By the end of the lesson,  Q/A Demonstration  Clip art  Longhorn
PUBLISHING the learner should be able practical  Working Computer
to computer studies
 Define DTP S/W Secondary.
 State then S.Mburu, G.
purpose of Chemwa page
DTPS/W 132-134

2-3 DESIGNING A By the end of the lesson,  Q/A Observation  Letters  Longhorn
PUBLICATION the learner should be able Practical  Working Computer
to computer studies
 Explain the DTP Secondary.
S/W S.Mburu, G.
 Discuss the types Chemwa page
of DTP 133-134
publications

9 1 DESIGNING A By the end of the lesson,  Q/A discussion  Cards,  Longhorn

PUBLICATION the learner should be able certificates, text, Computer
to calendars, text studies
 Run the DTP books Secondary.
program S.Mburu, G.
 Explain the DTP Chemwa page
screen layout 134-136

2-3 DESIGNING A By the end of the lesson, Q/A demonstration practical  Cards,
PUBLICATION the learner should be able certificates, text  Longhorn
to calendars, Computer
 Set up a textbooks studies
publication  Working Secondary.
 Manipulate text Computer S.Mburu, G.
and graphics Chemwa page
139-143

10 1 TEXT By the end of the lesson,  Q/A discussion  Calendars,  Longhorn

the learner should be able textbooks Computer
8
 to studies
 Design page Secondary.
layout S.Mburu, G.
 Use a ruler to Chemwa page
measure 158

2-3 GRAPHICS By the end of the lesson,  Q/A Demonstration  Books  Longhorn
the learner should be able practical  Handouts Computer
to  Working studies
 Define the term Computer Secondary.
graphics S.Mburu, G.
 Change full stroke Chemwa page
 Reshape objects 150

11 1 GRAPHICS By the end of the lesson,  Q/A Demonstration  Books  Longhorn

the learner should be able Practical  Handouts Computer
to  Working studies
 Copy an object computer Secondary.
 Import and wrap S.Mburu, G.
text Chemwa page
161-162

2& GRAPHICS By the end of the lesson,  Q/A Demonstration  Books  Longhorn
3 the learner should be able Practical  Handouts Computer
to  Working studies
 Group objects computer Secondary.
 Lock objects S.Mburu, G.
Chemwa page
164-168

12/ 1 ROTATE/CROP By the end of the lesson,  Q/A Demonstration  Books

13 the learner should be able practical  Working  Longhorn
to computer Computer
 Explain the terms, studies
sort, filter, total, Secondary.
forms S.Mburu, G.
 Apply the above Chemwa page
features 164
THE SCHOOL CLOSES/END OF TERM EXAMS

9
 COMPUTER FORM 1 SCHEMES OF WORK – TERM 1

INTERNET AND E-MAIL

WE LES TOPIC SUB - TOPIC OBJECTIVES LEARNING/TEACHING LEARNING/TEACHING REFERENCES REMARKS
EK SO ACTIVITIES RESOURCES
N
1 Reporting from home and settling for the first term work

2 1 INTERNET AND E- By the end of the lesson,  Q/A discussion  internet  Longhorn
MAIL the learner should be able  Demonstration  Text book Computer
to  observation  Working studies
 Define the term Computer Secondary.
internet S.Mburu, G.
 Explain the Chemwa page
development of 168-169
internet

2-3 IMPORTANCE OF By the end of the lesson,  Q/A demonstration  Handouts  Longhorn
THE INTERNET the learner should be able practical  Books Computer
to  Working studies
 Explain the computer Secondary.
importance of the S.Mburu, G.
internet Chemwa page
266-275

3 1 INTERNET By the end of the lesson,  Q/A Demonstration  Handouts  Longhorn

CONNECTIVITY the learner should be able Practical  Books Computer
to  Modem S/W studies
 Define the  Working Secondary.
internet computer S.Mburu, G.
connectivity Chemwa page
 Explain elements 273-276
of IC

2-3 INTERNET By the end of the lesson,  Q/A Demonstration  Letters  Longhorn
SERVICES the learner should be able Practical  Cards Computer
to  Books studies
 Explain the  computer Secondary.
internet services S.Mburu, G.
Chemwa page
273-276

10
 1 ACCESSING By the end of the lesson,  Q/A Demonstration  Web pages
INTERNET the learner should be able practical  Books  Longhorn
to  Working Computer
 Log in/Sign in computer studies
 Surf/browse Secondary.
S.Mburu, G.
Chemwa page
279

4 2-3 HYPER LINKS AND By the end of the lesson,  Q/A Demonstration  Letters  Longhorn
SEARCH ENGINES the learner should be able practical  Card Computer
to  Working studies
 Define the term computer Secondary.
search engine S.Mburu, G.
 Use search Chemwa page
engines 177-179

5 1 ELECTRONIC MAIL By the end of the lesson,  Q/A Demonstration  Handouts  Longhorn
the learner should be able practical  Books Computer
to  Working studies
 Explain the term computer Secondary.
e-mail S.Mburu, G.
 Discuss the use of Chemwa page
email s/w 178-180

2-3 E-MAIL By the end of the lesson,  Q/A Demonstration  Books  Longhorn
the learner should be able practical  Web pages Computer
to  Working studies
 State the e-mail computer Secondary.
facilities S.Mburu, G.
 Compose mails Chemwa page
 Check mails 30-37

6 1 E-MAIL By the end of the lesson,  Q/A Demonstration  Handouts  Longhorn

the learner should be able practical  Books Computer
to  Web pages studies
 Manipulate an e-  Working Secondary.
mail computer S.Mburu, G.
Chemwa page
180

2-3 SET-UP By the end of the lesson,  Q/A Demonstration  Websites  Longhorn
the learner should be able practical  Web pages Computer
to  Working studies
11
  Fax e-mail computer Secondary.
 Attach files S.Mburu, G.
Chemwa page
181-182

7 1 TEL MESSAGING By the end of the lesson,  Q/A Demonstration  Handouts  Longhorn
the learner should be able practical  Web pages Computer
to  Working studies
 Explain the term computer Secondary.
tel messaging S.Mburu, G.
 Develop contact Chemwa page
mgt 181-182

2-3 EMERGING ISSUES By the end of the lesson,  Q/A Demonstration  Websites  Longhorn
the learner should be able practical  Web pages Computer
to  Working studies
 Explain the computer Secondary.
emerging issues S.Mburu, G.
 Search for the Chemwa page
emerging issues in 182-183
the net

8 1 GRAPHICS By the end of the lesson,  Q/A Demonstration  Web sites  Longhorn
the learner should be able practical  Web pages Computer
to  Working studies
 Define the term computer Secondary.
graphic S.Mburu, G.
 Insert/edit Chemwa page
graphics 44-49

2-3 G. DATA SECURITY By the end of the lesson,  Q/A Demonstration  Books  Longhorn
AND CONTROLS the learner should be able practical  Working Computer
to computer studies
 Define the term Secondary.
data security S.Mburu, G.
 Identify security Chemwa page
threats on ICT 185-186

9 1 CONTROL By the end of the lesson,  Q/A discussion  Internet  Longhorn

MEASURES the learner should be able  Books Computer
to  Working studies
 Discuss the computer Secondary.
control measures S.Mburu, G.
on ICT Chemwa page
186-188
12
 2-3 COMPUTER By the end of the lesson,  Q/A Demonstration  Books  Longhorn
CRIMES the learner should be able Practical  Internet Computer
to  Working studies
 Define the term computer Secondary.
computer crimes S.Mburu, G.
 Explain the Chemwa page
computer crimes 188-190

10 1 ICT PROTECTION By the end of the lesson, Q/A Demonstration practical  Books
the learner should be able  Internet  Longhorn
to  Handouts Computer
 Discuss ICT  Working studies
protection computer Secondary.
measures S.Mburu, G.
Chemwa page
190-193

2-3 LAWS OF ICT By the end of the lesson,  Q/A demonstration  Books  Computer
the learner should be able practical  Internet studies by S.John
to  Handouts Onunga page
 Define the terms  Books 327-328
ethics  Working
 Explain the ethical computer
issues

11 1 ICT LEGISLATION By the end of the lesson,  Q/A discussion  Computer

the learner should be able studies by S.John
to Onunga page
 Discuss ICT laws 328-331

2-3 WORKSHEET By the end of the lesson,  Q/A Demonstration  Books  Longhorn
FORMATTING the earner should be able practical  Handouts Computer
to  Working studies
 Format a computer Secondary.
w/sheet: text, S.Mburu, G.
numbers, rows, Chemwa page
columns and 190-193
global

SCHOOLS CLOSES END OF YEAR

13