If this scheme pleases you, click here to download.
| WK | LSN | TOPIC | SUB-TOPIC | OBJECTIVES | T/L ACTIVITIES | T/L AIDS | REFERENCE | REMARKS |
|---|---|---|---|---|---|---|---|---|
| 2 | 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
|
|
| 2 | 4 |
Databases
|
Introduction
|
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
|
|
| 3 | 1-2 |
Databases
|
Database systems
Database models Creating a database in Microsoft access |
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
Longhorn Computer Studies by S.Mburu and C.Chemwa page 113-116 |
|
| 3 | 3 |
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
|
|
| 3 | 4 |
Databases
|
Data entry and manipulation
|
By the end of the
lesson, the learner
should be able to:
Define manipulating a database Type into table datasheet |
Explaining
Demonstration Discussions |
Newspaper
Letters Books Internet Handouts |
Longhorn Computer Studies by S.Mburu and C.Chemwa page 124-126
|
|
| 4 | 1-2 |
Databases
|
Modifying database structure
Form design |
By the end of the
lesson, the learner
should be able to:
Modify table datasheet 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 126-131
Longhorn Computer Studies by S.Mburu and C.Chemwa page 131-134 |
|
| 4 | 3 |
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
|
|
| 4 | 4 |
Databases
|
Creating reports and labels
|
By the end of the
lesson, the learner
should be able to:
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 142-146
|
|
| 5 | 1-2 |
Databases
Desktop publishing |
Setting up database security and startup
Introduction Desktop publishing Designing a publication |
By the end of the
lesson, the learner
should be able to:
Create an encryption using password Design a publication |
Explaining
Demonstration Discussions |
Newspaper
Letters Books Internet Handouts |
Longhorn Computer Studies by S.Mburu and C.Chemwa page 147-149
Longhorn Computer Studies by S.Mburu and C.Chemwa page 153-158 |
|
| 5 | 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
|
|
| 5 | 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
|
|
| 6 | 1-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 Set indents and tabs |
Explaining
Demonstration Discussions |
Newspaper
Letters Books Internet Handouts |
Longhorn Computer Studies by S.Mburu and C.Chemwa page 164-166
Longhorn Computer Studies by S.Mburu and C.Chemwa page 167-170 |
|
| 6 | 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
|
|
| 6 | 4 |
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
|
|
| 7 | 1-2 |
Desktop publishing
Programming with visual basic |
Formatting a graphical object
Drawing other polygons Project |
By the end of the
lesson, the learner
should be able to:
Format a graphical object Use codes to create a project |
Explaining
Demonstration Discussions Explaining Demonstration Discussions |
Newspaper
Letters Books Internet Handouts Newspaper Books internet |
Longhorn Computer Studies by S.Mburu and C.Chemwa page 175-176
Longhorn Secondary Computer studies Form 3, pages 151-153 |
|
| 7 | 3 |
Programming with visual basic
|
Creating menus
|
By the end of the
lesson, the learner
should be able to:
Explain the steps for creating menus |
Explaining
Demonstration Discussions |
Newspaper
Books Internet |
Longhorn Secondary
Computer studies Form 3, pages 154-155 |
|
| 7 | 4 |
Programming with visual basic
|
Message boxes
|
By the end of the
lesson, the learner
should be able to:
Explain the steps for creating message boxes |
Explaining
Demonstration Discussions |
Newspaper
Books Internet |
Longhorn Secondary
Computer studies Form 3, pages 155-156 |
|
| 8 | 1-2 |
Programming with visual basic
|
Dialog boxes
Project |
By the end of the
lesson, the learner
should be able to:
Explain the steps for creating dialog boxes Work on a project to open project menu |
Explaining
Demonstration Discussions |
Newspaper
Books Internet |
Longhorn Secondary
Computer studies Form 3, pages 156-157 Longhorn Secondary Computer studies Form 3, pages 157-158 |
|
| 8-9 |
half term |
|||||||
| 9 | 2 |
Programming with visual basic
|
Project
|
By the end of the
lesson, the learner
should be able to:
Explain how to create a project |
Explaining
Demonstration Discussions |
Newspaper
Books Internet |
Longhorn Secondary
Computer studies Form 3, pages 159-160 |
|
| 9 | 3 |
Programming with visual basic
|
List boxes
Combo boxes |
By the end of the
lesson, the learner
should be able to:
Explain the steps of creating list boxes |
Explaining
Demonstration Discussions |
Newspaper
Books Internet |
Longhorn Secondary
Computer studies Form 3, pages 160-161 |
|
| 9 | 4 |
Programming with visual basic
|
Visual basic data structures
|
By the end of the
lesson, the learner
should be able to:
Discuss the visual basic data structures |
Explaining
Demonstration Discussions |
Newspaper
Books Internet |
Longhorn Secondary
Computer studies Form 3, pages 162-164 |
|
| 10 | 1-2 |
Programming with visual basic
|
Visual basic data structures
|
By the end of the
lesson, the learner
should be able to:
Discuss how to record data Explain how to keep array of records Discuss the data files Explain types of data files |
Explaining
Demonstration Discussions |
Newspaper
Books Internet |
Longhorn Secondary
Computer studies Form 3, pages 164-165 Longhorn Secondary Computer studies Form 3, pages 165-168 |
|
| 10 | 3 |
Programming with visual basic
|
Project
|
By the end of the
lesson, the learner
should be able to:
Discuss how to create a project using visual basic |
Explaining
Demonstration Discussions |
Newspaper
Books Internet |
Longhorn Secondary
Computer studies Form 3, pages 168-170 |
|
| 10 | 4 |
Programming with visual basic
|
Project
|
By the end of the
lesson, the learner
should be able to:
Discuss how to create an interface form |
Explaining
Demonstration Discussions |
Newspaper
Books Internet |
Longhorn Secondary
Computer studies Form 3, pages 171-174 |
|
| 11 | 1-2 |
Programming with visual basic
|
Project
Project form |
By the end of the
lesson, the learner
should be able to:
Explain how to add an item into a combo box Explain the steps for creating a project form |
Explaining
Demonstration Discussions |
Newspaper
Books Internet |
Longhorn Secondary
Computer studies Form 3, pages 174-177 Longhorn Secondary Computer studies Form 3, pages 177-179 |
|
| 11 | 3 |
Programming with visual basic
|
Project form
Project form |
By the end of the
lesson, the learner
should be able to:
Explain the steps for creating two forms |
Explaining
Demonstration Discussions |
Newspaper
Books Internet |
Longhorn Secondary
Computer studies Form 3, pages 180-182 |
|
| 11 | 4 |
Programming with visual basic
|
Linking visual basic forms to a database
|
By the end of the
lesson, the learner
should be able to:
Explain the procedures of linking visual basic forms to a database |
Explaining
Demonstration Discussions |
Newspaper
Books Internet |
Longhorn Secondary
Computer studies Form 3, pages 187-189 |
|
| 12 | 1-2 |
Programming with visual basic
|
Linking visual basic forms to a database
Project |
By the end of the
lesson, the learner
should be able to:
Explain how to link form controls to an underlying table Create a project with visual basic |
Explaining
Demonstration Discussions |
Newspaper
Books Internet |
Longhorn Secondary
Computer studies Form 3, pages 190-191 Longhorn Secondary Computer studies Form 3, pages 191-192 |
|
| 12 | 3 |
Programming with visual basic
|
Project
|
By the end of the
lesson, the learner
should be able to:
Create data control and data bound controls |
Explaining
Demonstration Discussions |
Newspaper
Books Internet |
Longhorn Secondary
Computer studies Form 3, pages 193-194 |
|
| 12 | 4 |
Programming with visual basic
|
Project
|
By the end of the
lesson, the learner
should be able to:
Create a project using the VBBiblio |
Explaining
Demonstration Discussions |
Newspaper
Books Internet |
Longhorn Secondary
Computer studies Form 3, pages 194-197 |
|
| 13 | 1-2 |
Programming with visual basic
|
Project
Building reports Creating a visual basic executable file |
By the end of the
lesson, the learner
should be able to:
Create a record set manipulation Explain steps for building reports using data report designer |
Explaining
Demonstration Discussions |
Newspaper
Books Internet |
Longhorn Secondary
Computer studies Form 3, pages 197-198 Longhorn Secondary Computer studies Form 3, pages 198-199 |
|
| 13 | 3 |
Database
|
Introduction
|
By the end of the
lesson, the learner
should be able to:
Discuss database |
Explaining
Demonstration Discussions |
Newspaper
Books Internet |
Longhorn Secondary
Computer studies Form 3, pages 201-202 |
|
| 13 | 4 |
Database
|
Defining attributes
|
By the end of the
lesson, the learner
should be able to:
Discuss attributes |
Explaining
Demonstration Discussions |
Newspaper
Books Internet |
Longhorn Secondary
Computer studies Form 3, pages 202-204 |
|
| 14 | 1-2 |
Database
|
Creating the database
Defining a file/table structure |
By the end of the
lesson, the learner
should be able to:
Explain the steps for creating a database Explain the steps for defining the file/table structure |
Explaining
Demonstration Discussions |
Newspaper
Books Internet |
Longhorn Secondary
Computer studies Form 3, pages 204-205 Longhorn Secondary Computer studies Form 3, pages 205 |
|
Your Name Comes Here