If this scheme pleases you, click here to download.
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