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
1

SCHOOL OPENING

1 2-3
Spreadsheets
Electronic spreadsheets
Components of a spreadsheet
By the end of the lesson, the learner should be able to:

Define electronic spreadsheets
Discuss the advantages of electronic spreadsheets

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 73-74
Longhorn Computer Studies by S.Mburu and C.Chemwa page 74-
2 1
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 2-3
Spreadsheets
Creating workbooks in Microsoft excel
Entering data into a worksheet
By the end of the lesson, the learner should be able to:

Create workbooks in Microsoft excel

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 page76-79
Longhorn Computer Studies by S.Mburu and C.Chemwa page 80-81
3

OPENER EXAMINATION TERM 2 2025

4 1
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
4 2-3
Spreadsheets
Using basic formulae and functions
Editing and formatting worksheets
By the end of the lesson, the learner should be able to:

Use basic formulae and functions in worksheet

Edit and format worksheets using different methods
Definition of terms
Explaining
Demonstration
Discussions
Newspaper
Letters
Books
Internet
Newspaper
Letters
Books
Internet
Handouts
Longhorn Computer Studies by S.Mburu and C.Chemwa page 83-88
Longhorn Computer Studies by S.Mburu and C.Chemwa page 89-95
5 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
5 2-3
Spreadsheets
Databases
Creating charts
Introduction
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

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 101-108
Longhorn Computer Studies by S.Mburu and C.Chemwa page 110-111
6 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
6 2-3
Databases
Database models
Creating a database in Microsoft access
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

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 113-116
Longhorn Computer Studies by S.Mburu and C.Chemwa page 116-119
7 1
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
7 2-3
Databases
Data entry and manipulation
Modifying database structure
By the end of the lesson, the learner should be able to:

Define manipulating a database
Type into table datasheet

Modify table datasheet
Explaining
Demonstration
Discussions
Newspaper
Letters
Books
Internet
Handouts
Longhorn Computer Studies by S.Mburu and C.Chemwa page 124-126
Longhorn Computer Studies by S.Mburu and C.Chemwa page 126-131
8 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
8

MID TERM EXAMINATION TERM 2 2025

9

MID TERM BREAK

10 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
10 2-3
Databases
Creating database queries
Creating reports and labels
By the end of the lesson, the learner should be able to:

Explain types of queries
Create queries
Print queries

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 135-140
Longhorn Computer Studies by S.Mburu and C.Chemwa page 142-146
11 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
11 2-3
Desktop publishing
Introduction Desktop publishing
Designing a publication
By the end of the lesson, the learner should be able to:

Define desktop publishing
Explain the purpose of desktop publishing software

Design a publication
Explaining
Demonstration
Discussions
Newspaper
Letters
Books
Internet
Handouts
Longhorn Computer Studies by S.Mburu and C.Chemwa page 151-153
Longhorn Computer Studies by S.Mburu and C.Chemwa page 153-158
12 1
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
12 2
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
13

END OF TERM 2 EXAMINATION

14

MARKING, RESULTS RELEASE AND SCHOOL CLOSING


Your Name Comes Here


Download

Feedback