Home






SCHEME OF WORK
Computer Studies
Form 2 2025
TERM II
School


To enable/disable signing area for H.O.D & Principal, click here to update signature status on your profile.




To enable/disable showing Teachers name and TSC Number, click here to update teacher details status on your profile.












Did you know that you can edit this scheme? Just click on the part you want to edit!!! (Shift+Enter creates a new line)


WK LSN TOPIC SUB-TOPIC OBJECTIVES T/L ACTIVITIES T/L AIDS REFERENCE REMARKS
2 1
Databases
Introduction
By the end of the lesson, the learner should be able to:

Define database
Explain the database concepts
Definition of terms
Explaining
Demonstration
Discussions
Newspaper
Letters
Books
Internet
Handouts
Longhorn Computer Studies by S.Mburu and C.Chemwa page 110-111
2 2
Databases
Introduction
By the end of the lesson, the learner should be able to:

Define database
Explain the database concepts
Definition of terms
Explaining
Demonstration
Discussions
Newspaper
Letters
Books
Internet
Handouts
Longhorn Computer Studies by S.Mburu and C.Chemwa page 110-111
2 3
Databases
Database systems
By the end of the lesson, the learner should be able to:

Define database system
Explain features of DBMS software
Definition of terms
Explaining
Demonstration
Discussions
Newspaper
Letters
Books
Internet
Handouts
Longhorn Computer Studies by S.Mburu and C.Chemwa page 111-113
2 4
Databases
Database models
By the end of the lesson, the learner should be able to:

Discuss the types of database models
Explain the data organization in a database
Definition of terms
Explaining
Demonstration
Discussions
Newspaper
Letters
Books
Internet
Handouts
Longhorn Computer Studies by S.Mburu and C.Chemwa page 113-116
3 1
Databases
Creating a database in Microsoft access
By the end of the lesson, the learner should be able to:

Create a database in Microsoft access
Definition of terms
Explaining
Demonstration
Discussions
Newspaper
Letters
Books
Internet
Handouts
Longhorn Computer Studies by S.Mburu and C.Chemwa page 116-119
3 2
Databases
Creating a database in Microsoft access
By the end of the lesson, the learner should be able to:

Create a database in Microsoft access
Definition of terms
Explaining
Demonstration
Discussions
Newspaper
Letters
Books
Internet
Handouts
Longhorn Computer Studies by S.Mburu and C.Chemwa page 116-119
3 3
Databases
Creating a database in Microsoft access
By the end of the lesson, the learner should be able to:

Create a database in Microsoft access
Definition of terms
Explaining
Demonstration
Discussions
Newspaper
Letters
Books
Internet
Handouts
Longhorn Computer Studies by S.Mburu and C.Chemwa page 116-119
3 4
Databases
Field data types
By the end of the lesson, the learner should be able to:

Discuss the field data types
Explain the filed properties
Explaining
Demonstration
Discussions
Newspaper
Letters
Books
Internet
Handouts
Longhorn Computer Studies by S.Mburu and C.Chemwa page 119-122
4

CAT 1 Exam

5 1
Databases
Data entry and manipulation
By the end of the lesson, the learner should be able to:

Define manipulating a database
Type into table datasheet
Explaining
Demonstration
Discussions
Newspaper
Letters
Books
Internet
Handouts
Longhorn Computer Studies by S.Mburu and C.Chemwa page 124-126
5 2
Databases
Data entry and manipulation
By the end of the lesson, the learner should be able to:

Define manipulating a database
Type into table datasheet
Explaining
Demonstration
Discussions
Newspaper
Letters
Books
Internet
Handouts
Longhorn Computer Studies by S.Mburu and C.Chemwa page 124-126
5 3
Databases
Modifying database structure
By the end of the lesson, the learner should be able to:

Modify table datasheet
Explaining
Demonstration
Discussions
Newspaper
Letters
Books
Internet
Handouts
Longhorn Computer Studies by S.Mburu and C.Chemwa page 126-131
5 4
Databases
Modifying database structure
By the end of the lesson, the learner should be able to:

Modify table datasheet
Explaining
Demonstration
Discussions
Newspaper
Letters
Books
Internet
Handouts
Longhorn Computer Studies by S.Mburu and C.Chemwa page 126-131
6 1
Databases
Form design
By the end of the lesson, the learner should be able to:

Design a form using form wizard, from scratch
Explaining
Demonstration
Discussions
Newspaper
Letters
Books
Internet
Handouts
Longhorn Computer Studies by S.Mburu and C.Chemwa page 131-134
6 2
Databases
Creating database queries
By the end of the lesson, the learner should be able to:

Explain types of queries
Create queries
Print queries
Explaining
Demonstration
Discussions
Newspaper
Letters
Books
Internet
Handouts
Longhorn Computer Studies by S.Mburu and C.Chemwa page 135-140
6 3
Databases
Creating database queries
By the end of the lesson, the learner should be able to:

Explain types of queries
Create queries
Print queries
Explaining
Demonstration
Discussions
Newspaper
Letters
Books
Internet
Handouts
Longhorn Computer Studies by S.Mburu and C.Chemwa page 135-140
6 4
Databases
Creating reports and labels
By the end of the lesson, the learner should be able to:

Create reports and labels
Print reports and labels
Explaining
Demonstration
Discussions
Newspaper
Letters
Books
Internet
Handouts
Longhorn Computer Studies by S.Mburu and C.Chemwa page 142-146
7 1
Databases
Setting up database security and startup
By the end of the lesson, the learner should be able to:

Create an encryption using password
Explaining
Demonstration
Discussions
Newspaper
Letters
Books
Internet
Handouts
Longhorn Computer Studies by S.Mburu and C.Chemwa page 147-149
7 2
Databases
Setting up database security and startup
By the end of the lesson, the learner should be able to:

Create an encryption using password
Explaining
Demonstration
Discussions
Newspaper
Letters
Books
Internet
Handouts
Longhorn Computer Studies by S.Mburu and C.Chemwa page 147-149
7 3
Desktop publishing
Introduction Desktop publishing
By the end of the lesson, the learner should be able to:

Define desktop publishing
Explain the purpose of desktop publishing software
Explaining
Demonstration
Discussions
Newspaper
Letters
Books
Internet
Handouts
Longhorn Computer Studies by S.Mburu and C.Chemwa page 151-153
7 3-4
Desktop publishing
Introduction Desktop publishing
By the end of the lesson, the learner should be able to:

Define desktop publishing
Explain the purpose of desktop publishing software
Explaining
Demonstration
Discussions
Newspaper
Letters
Books
Internet
Handouts
Longhorn Computer Studies by S.Mburu and C.Chemwa page 151-153
8

Midterm Break

9

CAT 2 Exam

10 1
Desktop publishing
Designing a publication
By the end of the lesson, the learner should be able to:

Design a publication
Explaining
Demonstration
Discussions
Newspaper
Letters
Books
Internet
Handouts
Longhorn Computer Studies by S.Mburu and C.Chemwa page 153-158
10 2
Desktop publishing
Designing a publication
By the end of the lesson, the learner should be able to:

Design a publication
Explaining
Demonstration
Discussions
Newspaper
Letters
Books
Internet
Handouts
Longhorn Computer Studies by S.Mburu and C.Chemwa page 153-158
10 3
Desktop publishing
Manipulating text and graphical objects
By the end of the lesson, the learner should be able to:

Type text using text box, text frame
Explaining
Demonstration
Discussions
Newspaper
Letters
Books
Internet
Handouts
Longhorn Computer Studies by S.Mburu and C.Chemwa page 159-162
10 4
Desktop publishing
Editing a publication
By the end of the lesson, the learner should be able to:

Edit a publication
Check for spelling mistakes
Explaining
Demonstration
Discussions
Newspaper
Letters
Books
Internet
Handouts
Longhorn Computer Studies by S.Mburu and C.Chemwa page 162-163
11 1
Desktop publishing
Formatting a publication
By the end of the lesson, the learner should be able to:

Explain how to format a publication
Explaining
Demonstration
Discussions
Newspaper
Letters
Books
Internet
Handouts
Longhorn Computer Studies by S.Mburu and C.Chemwa page 164-166
11 2
Desktop publishing
Formatting a publication
By the end of the lesson, the learner should be able to:

Explain how to format a publication
Explaining
Demonstration
Discussions
Newspaper
Letters
Books
Internet
Handouts
Longhorn Computer Studies by S.Mburu and C.Chemwa page 164-166
11 3
Desktop publishing
Formatting a publication
By the end of the lesson, the learner should be able to:

Explain how to format a publication
Explaining
Demonstration
Discussions
Newspaper
Letters
Books
Internet
Handouts
Longhorn Computer Studies by S.Mburu and C.Chemwa page 164-166
11 4
Desktop publishing
Paragraph formatting
By the end of the lesson, the learner should be able to:

Set indents and tabs
Explaining
Demonstration
Discussions
Newspaper
Letters
Books
Internet
Handouts
Longhorn Computer Studies by S.Mburu and C.Chemwa page 167-170
12 1
Desktop publishing
Page formatting
By the end of the lesson, the learner should be able to:

Set column guides on a page
Explaining
Demonstration
Discussions
Newspaper
Letters
Books
Internet
Handouts
Longhorn Computer Studies by S.Mburu and C.Chemwa page 171`-173
12 2
Desktop publishing
Page formatting
By the end of the lesson, the learner should be able to:

Set column guides on a page
Explaining
Demonstration
Discussions
Newspaper
Letters
Books
Internet
Handouts
Longhorn Computer Studies by S.Mburu and C.Chemwa page 171`-173
12 3
Desktop publishing
Measuring objects and text frames
By the end of the lesson, the learner should be able to:

Perform measurements using ruler guides
Explaining
Demonstration
Discussions
Newspaper
Letters
Books
Internet
Handouts
Longhorn Computer Studies by S.Mburu and C.Chemwa page 173-174
12 4
Desktop publishing
Measuring objects and text frames
By the end of the lesson, the learner should be able to:

Perform measurements using ruler guides
Explaining
Demonstration
Discussions
Newspaper
Letters
Books
Internet
Handouts
Longhorn Computer Studies by S.Mburu and C.Chemwa page 173-174
13 1
Desktop publishing
Formatting a graphical object
By the end of the lesson, the learner should be able to:

Format a graphical object
Explaining
Demonstration
Discussions
Newspaper
Letters
Books
Internet
Handouts
Longhorn Computer Studies by S.Mburu and C.Chemwa page 175-176
13 2
Desktop publishing
Drawing other polygons
By the end of the lesson, the learner should be able to:

Draw polygons
Print a publication
Explaining
Demonstration
Discussions
Newspaper
Letters
Books
Internet
Handouts
Longhorn Computer Studies by S.Mburu and C.Chemwa page 176-180
13 3
Desktop publishing
Drawing other polygons
By the end of the lesson, the learner should be able to:

Draw polygons
Print a publication
Explaining
Demonstration
Discussions
Newspaper
Letters
Books
Internet
Handouts
Longhorn Computer Studies by S.Mburu and C.Chemwa page 176-180

Your Name Comes Here


Download

Feedback