If this scheme pleases you, click here to download.
| WK | LSN | TOPIC | SUB-TOPIC | OBJECTIVES | T/L ACTIVITIES | T/L AIDS | REFERENCE | REMARKS |
|---|---|---|---|---|---|---|---|---|
| 1 | 1 |
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 |
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
|
Applications of an electronic spreadsheet
Creating workbooks in Microsoft excel |
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 | 3 |
Spreadsheets
|
Entering data into a worksheet
Using basic formulae and functions |
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
|
|
| 1 | 4 |
Spreadsheets
|
Editing and formatting worksheets
Worksheet data management |
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
|
|
| 2 | 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
|
|
| 2 | 2 |
Databases
|
Introduction
Database systems |
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
|
|
| 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 |
Definition of terms
Explaining Demonstration Discussions |
Newspaper
Letters Books Internet Handouts |
Longhorn Computer Studies by S.Mburu and C.Chemwa page 113-116
|
|
| 2 | 4 |
Databases
|
Field data types
Data entry and manipulation |
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
|
|
| 3 | 1 |
Databases
|
Modifying database structure
Form design |
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
|
|
| 3 | 2 |
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 |
Explaining
Demonstration Discussions |
Newspaper
Letters Books Internet Handouts |
Longhorn Computer Studies by S.Mburu and C.Chemwa page 135-140
|
|
| 3 | 3 |
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
|
|
| 3 | 4 |
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 |
Explaining
Demonstration Discussions |
Newspaper
Letters Books Internet Handouts |
Longhorn Computer Studies by S.Mburu and C.Chemwa page 151-153
|
|
| 4 | 1 |
Desktop publishing
|
Manipulating text and graphical objects
Editing a publication |
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
|
|
| 4 | 2 |
Desktop publishing
|
Formatting a publication
Paragraph formatting |
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
|
|
| 4 | 3 |
Desktop publishing
|
Page formatting
Measuring objects and text frames |
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
|
|
| 4 | 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
|
|
| 5 | 1 |
Desktop publishing
INTERNET AND E-MAIL |
Drawing other polygons
INTRODUCTION |
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 Internet Text book Working Computer |
Longhorn Computer Studies by S.Mburu and C.Chemwa page 176-180
|
|
| 5 | 2 |
INTERNET AND E-MAIL
|
IMPORTANCE OF THE INTERNET
|
By the end of the
lesson, the learner
should be able to:
Explain the importance of the internet |
Q/A demonstration practical |
Handouts Books Working computer |
Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 266-275 |
|
| 5 | 3 |
INTERNET AND E-MAIL
|
INTERNET CONNECTIVITY
|
By the end of the
lesson, the learner
should be able to:
Define the internet connectivity Explain elements of IC |
Q/A Demonstration Practical |
Handouts Books Modem S/W Working computer |
Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 273-276 |
|
| 5 | 4 |
INTERNET AND E-MAIL
|
INTERNET SERVICES
ACCESSING INTERNET |
By the end of the
lesson, the learner
should be able to:
Explain the internet services |
Q/A Demonstration Practical |
Letters
Cards Books computer Web pages Working computer |
Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 273-276 |
|
| 6 | 1 |
INTERNET AND E-MAIL
|
HYPER LINKS AND SEARCH ENGINES
|
By the end of the
lesson, the learner
should be able to:
Define the term search engine Use search engines |
Q/A Demonstration practical |
Letters Card Working computer |
Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 177-179 |
|
| 6 | 2 |
INTERNET AND E-MAIL
|
ELECTRONIC MAIL
|
By the end of the
lesson, the learner
should be able to:
Explain the term e-mail Discuss the use of email s/w |
Q/A Demonstration practical |
Handouts Books Working computer |
Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 178-180 |
|
| 6 | 3 |
INTERNET AND E-MAIL
|
E-MAIL
|
By the end of the
lesson, the learner
should be able to:
State the e-mail facilities Compose mails Check mails |
Q/A Demonstration practical |
Books Web pages Working computer |
Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 30-37 |
|
| 6 | 4 |
INTERNET AND E-MAIL
|
E-MAIL
|
By the end of the
lesson, the learner
should be able to:
Manipulate an e-mail |
Q/A Demonstration practical |
Handouts Books Web pages Working computer |
Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 180 |
|
| 7 | 1 |
INTERNET AND E-MAIL
|
SET-UP
TEL MESSAGING |
By the end of the
lesson, the learner
should be able to:
Fax e-mail Attach files |
Q/A Demonstration practical |
Websites
Web pages Working computer Handouts |
Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 181-182 |
|
| 7 | 2 |
INTERNET AND E-MAIL
|
EMERGING ISSUES
|
By the end of the
lesson, the learner
should be able to:
Explain the emerging issues Search for the emerging issues in the net |
Q/A Demonstration practical |
Websites Web pages Working computer |
Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 182-183 |
|
| 7 | 3 |
INTERNET AND E-MAIL
|
GRAPHICS
|
By the end of the
lesson, the learner
should be able to:
Define the term graphic Insert/edit graphics |
Q/A Demonstration practical |
Web sites Web pages Working computer |
Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 44-49 |
|
| 7 | 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 |
|
| 8 |
TERM THREE ROUND TWO EXAMS |
|||||||
| 9 | 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 |
|
| 9 | 2 |
DATA SECURITY AND CONTROLS
|
COMPUTER CRIMES
ICT PROTECTION |
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 Handouts |
Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 188-190 |
|
| 9 | 3 |
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 |
|
| 9 | 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 |
|
Your Name Comes Here