If this scheme pleases you, click here to download.
| WK | LSN | TOPIC | SUB-TOPIC | OBJECTIVES | T/L ACTIVITIES | T/L AIDS | REFERENCE | REMARKS |
|---|---|---|---|---|---|---|---|---|
| 1 |
REPORTING BACK TO SCHOOL |
|||||||
| 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
|
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 | 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-
|
|
| 2 | 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
|
|
| 3 | 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
|
|
| 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
|
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
|
|
| 3 | 4 |
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 | 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 |
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
|
|
| 4 | 3 |
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
|
|
| 4 | 4 |
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 | 1 |
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
|
|
| 5 | 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
|
|
| 5 | 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
|
|
| 5 | 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
|
|
| 6 | 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
|
|
| 6 | 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
|
|
| 6 | 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
|
|
| 6 | 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
|
|
| 7 | 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
|
|
| 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 | 3-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
|
|
| 8 |
MIDTERM EXAM AND BREAK |
|||||||
| 9 | 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
|
|
| 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
|
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 | 4 |
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
|
|
| 10 | 1 |
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
|
|
| 10 | 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
|
|
| 10 | 3 |
DATA SECURITY AND CONTROLS
|
INTRODUCTION
|
By the end of the
lesson, the learner
should be able to:
Define the term data security Identify security threats on ICT |
Q/A Demonstration practical |
Books Working computer |
Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 185-186 |
|
| 10 | 4 |
DATA SECURITY AND CONTROLS
|
INTRODUCTION
|
By the end of the
lesson, the learner
should be able to:
Define the term data security Identify security threats on ICT |
Q/A Demonstration practical |
Books Working computer |
Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 185-186 |
|
| 11 | 1 |
DATA SECURITY AND CONTROLS
|
CONTROL MEASURES
|
By the end of the
lesson, the learner
should be able to:
Discuss the control measures on ICT |
Q/A discussion |
Internet Books Working computer |
Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 186-188 |
|
| 11 | 2 |
DATA SECURITY AND CONTROLS
|
CONTROL MEASURES
|
By the end of the
lesson, the learner
should be able to:
Discuss the control measures on ICT |
Q/A discussion |
Internet Books Working computer |
Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 186-188 |
|
| 11 | 3 |
DATA SECURITY AND CONTROLS
|
CONTROL MEASURES
|
By the end of the
lesson, the learner
should be able to:
Discuss the control measures on ICT |
Q/A discussion |
Internet Books Working computer |
Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 186-188 |
|
| 11 | 4 |
DATA SECURITY AND CONTROLS
|
COMPUTER CRIMES
|
By the end of the
lesson, the learner
should be able to:
Define the term computer crimes Explain the computer crimes |
Q/A Demonstration Practical |
Books Internet Working computer |
Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 188-190 |
|
| 12 | 1 |
DATA SECURITY AND CONTROLS
|
ICT PROTECTION
|
By the end of the
lesson, the learner
should be able to:
Discuss ICT protection measures |
Q/A Demonstration practical |
Books Internet Handouts Working computer |
Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 190-193 |
|
| 12 | 2 |
DATA SECURITY AND CONTROLS
|
ICT PROTECTION
|
By the end of the
lesson, the learner
should be able to:
Discuss ICT protection measures |
Q/A Demonstration practical |
Books Internet Handouts Working computer |
Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 190-193 |
|
| 12 | 3 |
DATA SECURITY AND CONTROLS
|
ICT PROTECTION
|
By the end of the
lesson, the learner
should be able to:
Discuss ICT protection measures |
Q/A Demonstration practical |
Books Internet Handouts Working computer |
Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 190-193 |
|
| 12 | 4 |
DATA SECURITY AND CONTROLS
|
LAWS OF ICT
|
By the end of the
lesson, the learner
should be able to:
Define the terms ethics Explain the ethical issues |
Q/A demonstration practical |
Books Internet Handouts Books Working computer |
Computer studies by S.John Onunga page 327-328 |
|
| 13 | 1 |
DATA SECURITY AND CONTROLS
|
ICT LEGISLATION
|
By the end of the
lesson, the learner
should be able to:
lesson, be able to Discuss ICT laws |
Q/A discussion |
|
Computer studies by S.John Onunga page 328-331 |
|
| 13 | 2 |
DATA SECURITY AND CONTROLS
|
ICT LEGISLATION
|
By the end of the
lesson, the learner
should be able to:
lesson, be able to Discuss ICT laws |
Q/A discussion |
|
Computer studies by S.John Onunga page 328-331 |
|
| 13 | 3 |
DATA SECURITY AND CONTROLS
|
ICT LEGISLATION
|
By the end of the
lesson, the learner
should be able to:
lesson, be able to Discuss ICT laws |
Q/A discussion |
|
Computer studies by S.John Onunga page 328-331 |
|
| 13 | 1-4 |
DATA SECURITY AND CONTROLS
|
ICT LEGISLATION
|
By the end of the
lesson, the learner
should be able to:
lesson, be able to Discuss ICT laws |
Q/A discussion |
|
Computer studies by S.John Onunga page 328-331 |
|
| 14 |
ENDTERM TWO EXAMINATION |
|||||||
Your Name Comes Here