COMPUTER FORM 2 SCHEMES OF WORK – TERM 1
APPLICATION PACKAGES (WORD PROCESSORS)
LES TOPIC SUB - TOPIC OBJECTIVES LEARNING/TEACHING LEARNING/TEACHING REF
SO ACTIVITIES RESOURCES
N
Reporting from home and settling for first term work
1 DEFINITION OF By the end of the lesson, Q/A discussion Newspapers
WORD PROCESSOR the learner should be able Letters
to Cards
books
Define the term
word processor
Explain the
purpose of a word
processor
2-3 USING A WORD By the end of the lesson, Q/A demonstration Handouts
PROCESSING the learner should be able practical Books
PACKAGE to Working
personal
Start a Microsoft computer
word
Explain the
Microsoft screen
layout
1 RUNNING THE By the end of the lesson, Q/A demonstration Books
PROGRAMME the learner should be able practical Handouts
to Working
computer
Save and retrieve
Close and exit
2-3 EDITING AND By the end of the lesson, Q/A demonstration Handouts
FORMATTING A the learner should be able practical Books
DOCUMENT to Working
computer
Select a
document
Move, copy and
delete
Insert and type
over
1 FIND AND REPLACE By the end of the lesson, Q/A Demonstration Letters
the leaner should be able practical Card working
to computer
Define the term
find and replace
Find and replace a
documents
Use thesaurus
2-3 TEXT FORMATTING By the end of the lesson, Q/A Demonstration Letters
the learner should be able practical Cards
to Working
computer
Bold, italicize,
underline, change
fonts
1 PARAGRAPH By the end of the lesson, Q/A demonstration Handouts
FORMATTING the learner should be able practical Cards
to Working
computer
Drop cap, sub and
superscript
Align and indent
text
2-3 PARAGRAPH By the end of the lesson, Q/A demonstration Books
FORMATTING the learner should be able practical Newspapers
to Working
computer
Space and section
break
Bullet and
number
Insert
columns/page
headers and
footers
By the end of the lesson, Q/A demonstration Handouts
1 SET-UP the learner should be able practical Working
to computer
Set up margins
Set paper size and
orientation
2-3 SET-UP By the end of the lesson, Q/A Demonstration Handouts
the learner should be able practical Working
to computer
books
Define the term
table
Crate tables
Insert rows and
columns
Merge/split rows
1 TABLE By the end of the lesson, Q/A Demonstration Handouts
CONVERSION/ the learner should be able practical Working
ARITHMETIC to computer
CALCULATIONS Chalk board
convert text to a
table and vice
verse
import
tables/perform
calculations
2-3 MAIL MERGE By the end of the lesson, Q/A Demonstration Letters
the learner should be able practical Card
to Working
computer
Define the term Chalk board
mail merge
Create: main
document and
data source
Merge fields
1 GRAPHICS By the end of the lesson, Q/A Demonstration Clip art
the learner should be able practical Working
to computer
Define the term
graphic
Insert/edit
graphics
2-3 PRINTING By the end of the lesson, Q/A Demonstration Letters
the learner should be able practical Working
to computer
Define the term
printing
Set up the printer
and print
1 SPREAD SHEETS By the end of the lesson, Q/A Discussion Call register
(SPREADSHEETS) the learner should be able Accounts book
to
Define the term
spreadsheets
Explain the
application areas
of spreadsheet
2-3 CREATING A By the end of the lesson, Q/A demonstration Handouts
WORKSHEET the learner should be able practical Class register
to Accounts book
Working
Define the term computer
worksheet
Create a
worksheet
Save/retrieve a
worksheet
1 CELL DATA TYPES By the end of the lesson, Q/A discussion Books
the learner should be able
to
Define the term
cell data type
Explain the
different data
types
2-3 CELL REFERENCING By the end of the lesson, Q/A Demonstration Books
the learner should be able practical Handouts
to Working
computer
Define the term
cell referencing
Explain the
different cell
referencing
Apply cell
referencing on a
computer
1 FUNCTIONS AND By the end of the lesson, Q/A demonstration Working
FORMULAE the learner should be able Practical computer
to Books
Differentiate
between
functions and
formulae
Apply functions
and formulae on a
document
2-3 WORKSHEET By the end of the lesson, Q/A Demonstration Books
FORMATTING the learner should be able practical Handouts
to Working
computer
Format a
worksheet: text,
numbers, rows,
columns and
global
1 DATA By the end of the lesson, Q/A Demonstration Books
MANAGEMENT the learner should be able practical Working
to computer
Explain the terms,
Sort, filter, total
forms
Apply the above
features
2-3 CHARTS/GRAPHICS By the end of the lesson, Q/A Demonstration Books
the learner should be able practical Handouts
to Working
computer
Definite the terms
chart
Explain the
different charts
Insert charts
END TERM EXAMS/SCHOOLS CLOSE
COMPUTER FORM 2 SCHEMES OF WORK – TERM 2
DATABASES
LES TOPIC SUB - TOPIC OBJECTIVES LEARNING/TEACHING LEARNING/TEACHING REF
SO ACTIVITIES RESOURCES
N
Reporting from home and settling for the second term work
1 DATABASE By the end of the lesson, Q/A discussion Class list
the learner should be able
to
Define the
database
Explain the
concept of D/base
2-3 DATABASE By the end of the lesson, Q/A demonstration Handouts
MODELS the learner should be able practical Books
to Working
computer
Define the term
d/base model
Explain the
difference d/base
models
Discuss the
features of a
database
1 DATA By the end of the lesson, Q/A demonstration Handouts
ORGANIZATION the learner should be able practical Books
to Working
computer
Organize data in a
database
Start Ms Access
2-3 MS ACCESS By the end of the lesson, Q/A Demonstration Letters
SCREEN LAYOUT the learner should be able practical Cards
to Books
Working
Explain the access computer
screen layout
Create a database
1 EDITING A D/BASE By the end of the lesson, Q/A Demonstration Letters
the learner should be able practical Cart
to Working
computer
Edict a data base
2-3 QUERIES By the end of the lesson, Q/A Demonstration Letters
the learner should be able Practical Card
to Working
computer
Define the term
query
Crate a query
1 UPDATING A By the end of the lesson, Q/A Demonstration Handouts
QUERY the learner should be able practical Books
to Working
computer
Update a query
View a query
2-3 FORM DESIGN By the end of the lesson, Q/A Demonstration Books
the learner should be able practical Newspaper
to Working
computer
Explain the form
layout
Create a form
1 FORMATTING By the end of the lesson, Q/A Demonstration Handouts
FIELDS the learner should be able practical
to
Display records in
a form
Format fields
2-3 REPORTS LAYOUT By the end of the lesson, Q/A Demonstration Practical Handouts
the learner should be able Books
to Working
Computer
Define a report
Create a report
Modify a report
1 REPORTS LAYOUT By the end of the lesson, Q/A Demonstration Forms
the learner should be able practical Report
to Working
computer
Sort and group
data in a report
Design labels
2-3 PRINTING By the end of the lesson, Q/A Demonstration Forms
the learner should be able Practical Report
to Working
computer
Define the term
printing
Print: form and a
report
DESKTOP PUBLISHING
1 DESKTOP By the end of the lesson, Q/A Demonstration Clip art
PUBLISHING the learner should be able practical Working
to computer
Define DTP S/W
State then
purpose of
DTPS/W
2-3 DESIGNING A By the end of the lesson, Q/A Observation Letters
PUBLICATION the learner should be able Practical Working
to computer
Explain the DTP
S/W
Discuss the types
of DTP
publications
1 DESIGNING A By the end of the lesson, Q/A discussion Cards,
PUBLICATION the learner should be able certificates, text,
to calendars, text
books
Run the DTP
program
Explain the DTP
screen layout
2-3 DESIGNING A By the end of the lesson, Q/A demonstration practical Cards,
PUBLICATION the learner should be able certificates, text
to calendars,
textbooks
Set up a Working
Computer
publication
Manipulate text
and graphics
1 TEXT By the end of the lesson, Q/A discussion Calendars,
the learner should be able textbooks
to
Design page
layout
Use a ruler to
measure
2-3 GRAPHICS By the end of the lesson, Q/A Demonstration Books
the learner should be able practical Handouts
to Working
Computer
Define the term
graphics
Change full stroke
Reshape objects
1 GRAPHICS By the end of the lesson, Q/A Demonstration Books
the learner should be able Practical Handouts
to Working
computer
Copy an object
Import and wrap
text
2& GRAPHICS By the end of the lesson, Q/A Demonstration Books
3 the learner should be able Practical Handouts
to Working
computer
Group objects
Lock objects
1 ROTATE/CROP By the end of the lesson, Q/A Demonstration Books
the learner should be able practical Working
to computer
Explain the terms,
sort, filter, total,
forms
Apply the above
features
THE SCHOOL CLOSES/END OF TERM EXAMS
