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

MIDTERM EXAM

7 1
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 2
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
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
8

HALFTERM BREAK

9 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
9 2
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
9 3
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
10 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
10 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
10 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
11

END TERM EXAM

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
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
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 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