Home






SCHEME OF WORK
Computer Studies
Form 2 2025
TERM III
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
1 1
Spreadsheets
Electronic spreadsheets
By the end of the lesson, the learner should be able to:

Define electronic spreadsheets
Discuss the advantages of electronic spreadsheets
Definition of terms
Explaining
Demonstration
Discussions
Newspaper
Letters
Books
Internet
Handouts
Longhorn Computer Studies by S.Mburu and C.Chemwa page 73-74
1 2
Spreadsheets
Components of a spreadsheet
By the end of the lesson, the learner should be able to:

Discuss the components of a spreadsheet
Definition of terms
Explaining
Demonstration
Discussions
Newspaper
Letters
Books
Internet
Handouts
Longhorn Computer Studies by S.Mburu and C.Chemwa page 74-
1 3
Spreadsheets
Applications of an electronic spreadsheet
By the end of the lesson, the learner should be able to:

Explain the uses of electronic spreadsheet in the society and business organizations
Definition of terms
Explaining
Demonstration
Discussions
Newspaper
Letters
Books
Internet
Handouts
Longhorn Computer Studies by S.Mburu and C.Chemwa page 76
1 4
Spreadsheets
Applications of an electronic spreadsheet
By the end of the lesson, the learner should be able to:

Explain the uses of electronic spreadsheet in the society and business organizations
Definition of terms
Explaining
Demonstration
Discussions
Newspaper
Letters
Books
Internet
Handouts
Longhorn Computer Studies by S.Mburu and C.Chemwa page 76
2 1
Spreadsheets
Creating workbooks in Microsoft excel
By the end of the lesson, the learner should be able to:

Create workbooks in Microsoft excel
Definition of terms
Explaining
Demonstration
Discussions
Newspaper
Letters
Books
Internet
Handouts
Longhorn Computer Studies by S.Mburu and C.Chemwa page76-79
2 2
Spreadsheets
Entering data into a worksheet
By the end of the lesson, the learner should be able to:

Enter data into a worksheet
Definition of terms
Explaining
Demonstration
Discussions
Newspaper
Letters
Books
Internet
Handouts
Longhorn Computer Studies by S.Mburu and C.Chemwa page 80-81
2 3
Spreadsheets
Using basic formulae and functions
By the end of the lesson, the learner should be able to:

Use basic formulae and functions in worksheet
Definition of terms
Explaining
Demonstration
Discussions
Newspaper
Letters
Books
Internet
Longhorn Computer Studies by S.Mburu and C.Chemwa page 83-88
2 4
Spreadsheets
Editing and formatting worksheets
By the end of the lesson, the learner should be able to:

Edit and format worksheets using different methods
Definition of terms
Explaining
Demonstration
Discussions
Newspaper
Letters
Books
Internet
Handouts
Longhorn Computer Studies by S.Mburu and C.Chemwa page 89-95
3 1
Spreadsheets
Worksheet data management
By the end of the lesson, the learner should be able to:

Discuss the steps on entering data using forms
Definition of terms
Explaining
Demonstration
Discussions
Newspaper
Letters
Books
Internet
Handouts
Longhorn Computer Studies by S.Mburu and C.Chemwa page 96-101
3 2
Spreadsheets
Creating charts
By the end of the lesson, the learner should be able to:

Explain steps for creating column and line charts
Edit and format charts
Print workbooks
Definition of terms
Explaining
Demonstration
Discussions
Newspaper
Letters
Books
Internet
Handouts
Longhorn Computer Studies by S.Mburu and C.Chemwa page 101-108
3 3
Spreadsheets
Creating charts
By the end of the lesson, the learner should be able to:

Explain steps for creating column and line charts
Edit and format charts
Print workbooks
Definition of terms
Explaining
Demonstration
Discussions
Newspaper
Letters
Books
Internet
Handouts
Longhorn Computer Studies by S.Mburu and C.Chemwa page 101-108
3 4
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
4 1
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
4 2
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
4 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
4 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
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
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 1
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 2
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
6 3
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
6 4
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 1
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
7 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
7 3
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
7 4
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
8

TERM ONE ROUND ONE EXAMS 2026

9 1
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
9 2
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
9 3
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
9 4
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