If this scheme pleases you, click here to download.
| WK | LSN | TOPIC | SUB-TOPIC | OBJECTIVES | T/L ACTIVITIES | T/L AIDS | REFERENCE | REMARKS |
|---|---|---|---|---|---|---|---|---|
| 1 | 3 |
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
|
|
| 1 | 4 |
Spreadsheets
|
Components of a spreadsheet
Applications of an electronic spreadsheet |
By the end of the
lesson, the learner
should be able to:
Discuss the components of a spreadsheet 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 74-
|
|
| 2 | 1-2 |
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 |
|
| 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 Handouts |
Longhorn Computer Studies by S.Mburu and C.Chemwa page 83-88
|
|
| 2 | 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
|
|
| 3 | 1-2 |
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 |
|
| 3 | 3 |
Databases
|
Database systems
Database models |
By the end of the
lesson, the learner
should be able to:
Define database system Explain features of DBMS software 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 111-113
|
|
| 3 | 4 |
Databases
|
Creating a database in Microsoft access
|
By the end of the
lesson, the learner
should be able to:
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 116-119
|
|
| 4 | 1-2 |
Databases
|
Field data types
Data entry and manipulation Modifying database structure |
By the end of the
lesson, the learner
should be able to:
Discuss the field data types Explain the filed properties 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 119-122
Longhorn Computer Studies by S.Mburu and C.Chemwa page 124-126 |
|
| 4 | 3 |
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
|
|
| 4 | 4 |
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
|
|
| 5 |
Mid term Break |
|||||||
| 6 | 1-2 |
Databases
Databases Desktop publishing |
Creating reports and labels
Setting up database security and startup Introduction Desktop publishing |
By the end of the
lesson, the learner
should be able to:
Create reports and labels Print reports and labels Create an encryption using password 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 142-146
Longhorn Computer Studies by S.Mburu and C.Chemwa page 147-149 |
|
| 6 | 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
|
|
| 6 | 4 |
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
|
|
| 7 | 1-2 |
Desktop publishing
|
Editing a publication
Formatting a publication Paragraph formatting |
By the end of the
lesson, the learner
should be able to:
Edit a publication Check for spelling mistakes Explain how to format a publication Set indents and tabs |
Explaining
Demonstration Discussions |
Newspaper
Letters Books Internet Handouts |
Longhorn Computer Studies by S.Mburu and C.Chemwa page 162-163
Longhorn Computer Studies by S.Mburu and C.Chemwa page 167-170 |
|
| 7 | 3 |
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
|
|
| 7 | 4 |
Desktop publishing
|
Measuring objects and text frames
Formatting a graphical object |
By the end of the
lesson, the learner
should be able to:
Perform measurements using ruler guides Format a graphical object |
Explaining
Demonstration Discussions |
Newspaper
Letters Books Internet Handouts |
Longhorn Computer Studies by S.Mburu and C.Chemwa page 173-174
|
|
| 8 |
Mid term Break |
|||||||
| 9 | 1-2 |
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 Define the term internet Explain the development of internet |
Explaining
Demonstration Discussions Q/A discussion Demonstration observation |
Newspaper
Letters Books Internet Handouts Internet Text book Working Computer |
Longhorn Computer Studies by S.Mburu and C.Chemwa page 176-180
Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 168-169 |
|
| 9 | 3 |
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 |
|
| 9 | 4 |
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 |
|
| 10 | 1-2 |
INTERNET AND E-MAIL
|
INTERNET SERVICES
|
By the end of the
lesson, the learner
should be able to:
Explain the internet services |
Q/A Demonstration Practical |
Letters Cards Books computer |
Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 273-276 |
|
| 10 | 3 |
INTERNET AND E-MAIL
|
ACCESSING INTERNET
|
By the end of the
lesson, the learner
should be able to:
Log in/Sign in Surf/browse |
Q/A Demonstration practical |
Web pages Books Working computer |
Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 279 |
|
| 10 | 4 |
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 |
|
| 11 | 1-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 State the e-mail facilities Compose mails Check mails |
Q/A Demonstration practical |
Handouts Books Working computer Books Web pages Working computer |
Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 178-180 Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 30-37 |
|
| 11 | 3 |
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 |
|
| 11 | 4 |
INTERNET AND E-MAIL
|
SET-UP
|
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 |
Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 181-182 |
|
| 12 | 1-2 |
INTERNET AND E-MAIL
|
TEL MESSAGING
|
By the end of the
lesson, the learner
should be able to:
Explain the term tel messaging Develop contact mgt |
Q/A Demonstration practical |
Handouts Web pages Working computer |
Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 181-182 |
|
| 12 | 3 |
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 |
|
| 12 | 4 |
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 |
|
Your Name Comes Here