COMPUTER STUDIES FORM 2 SCHEMES OF WORK TERM 1-3 PDF

APPLICATION PACKAGES (WORD PROCESSORS)
WEEK LESSON TOPIC SUB – TOPIC OBJECTIVES LEARNING/TEACHING ACTIVITIES LEARNING/TEACHING RESOURCES REFERENCES REMARKS
1   Reporting from home and settling for first term work
 

2

 

1

   

DEFINITION OF WORD PROCESSOR

 

By the end of the lesson, the learner should be able to

·        Define the term word processor

·        Explain the purpose of a word processor

 

·        Q/A discussion

 

·        Newspapers

·        Letters

·        Cards

·        books

 

·        Longhorn Secondary. S.Mburu, G. Chemwa page 1-3

 
   

2-3

   

USING A WORD PROCESSING PACKAGE

 

By the end of the lesson, the learner should be able to

·        Start a Microsoft word

·        Explain the Microsoft screen layout

 

·        Q/A demonstration practical

 

·        Handouts

·        Books

·        Working personal computer

 

·        Longhorn Secondary. S.Mburu, G. Chemwa page 5-10

 
 

3

 

1

   

RUNNING THE PROGRAMME

 

By the end of the lesson, the learner should be able to

·        Save and retrieve

·        Close and exit

 

·        Q/A demonstration practical

 

·        Books

·        Handouts

·        Working computer

 

 

·        Longhorn Secondary. S.Mburu, G. Chemwa page 13-17

 
   

2-3

   

EDITING AND FORMATTING A DOCUMENT

 

By the end of the lesson, the learner should be able to

·        Select a document

·        Move, copy and delete

·        Insert and type over

 

·        Q/A demonstration practical

 

·        Handouts

·        Books

·        Working computer

 

·        Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 16-19

 
 

4

 

1

   

FIND AND REPLACE

 

By the end of the lesson, the leaner should be able to

·        Define the term find and replace

·        Find and replace a documents

·        Use thesaurus

 

·        Q/A Demonstration practical

 

·        Letters

·        Card working computer

 

·        Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 16-24

 
   

2-3

   

TEXT FORMATTING

 

By the end of the lesson, the learner should be able to

·        Bold, italicize, underline, change fonts

 

·        Q/A Demonstration practical

 

·        Letters

·        Cards

·        Working computer

 

·        Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 22-23

 
 

5

 

1

   

PARAGRAPH FORMATTING

 

By the end of the lesson, the learner should be able to

·        Drop cap, sub and superscript

·        Align and indent text

 

·        Q/A demonstration practical

 

·        Handouts

·        Cards

·        Working computer

 

·        Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 22-23

 
   

2-3

   

PARAGRAPH FORMATTING

 

By the end of the lesson, the learner should be able to

·        Space and section break

·        Bullet and number

·        Insert columns/page headers and footers

 

·        Q/A demonstration practical

 

·        Books

·        Newspapers

·        Working computer

 

·        Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 22-23

 
 

6

 

1

   

SET-UP

 

By the end of the lesson, the learner should be able to

·        Set up margins

·        Set paper size and orientation

 

·        Q/A demonstration practical

 

·        Handouts

·        Working computer

 

 

·        Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 33-35

 
   

2-3

   

SET-UP

 

By the end of the lesson, the learner should be able to

·        Define the term table

·        Crate tables

·        Insert rows and columns

·        Merge/split rows

 

·        Q/A Demonstration practical

 

·        Handouts

·        Working computer

·        books

 

·        Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 37-39

 
 

7

 

1

   

TABLE CONVERSION/ ARITHMETIC CALCULATIONS

 

By the end of the lesson, the learner should be able to

·        convert text to a table and vice verse

·        import tables/perform calculations

 

·        Q/A Demonstration practical

 

·        Handouts

·        Working computer

·        Chalk board

 

·        Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 40-41

 
   

2-3

   

MAIL MERGE

 

By the end of the lesson, the learner should be able to

·        Define the term mail merge

·        Create: main document and data source

·        Merge fields

 

·        Q/A Demonstration practical

 

·        Letters

·        Card

·        Working computer

·        Chalk board

 

·        Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 44-46

 
 

8

 

1

   

GRAPHICS

 

By the end of the lesson, the learner should be able to

·        Define the term graphic

·        Insert/edit graphics

 

·        Q/A Demonstration practical

 

·        Clip art

·        Working computer

 

·        Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 44-49

 
   

2-3

   

PRINTING

 

By the end of the lesson, the learner should be able to

·        Define the term printing

·        Set up the printer and print

 

·        Q/A Demonstration practical

 

·        Letters

·        Working computer

 

·        Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 44

 
 

9

 

1

   

SPREAD SHEETS (SPREADSHEETS)

 

By the end of the lesson, the learner should be able to

·        Define the term spreadsheets

·        Explain the application areas of spreadsheet

 

·        Q/A Discussion

 

·        Call register

·        Accounts book

 

·        Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 52-53

 
   

2-3

   

CREATING A WORKSHEET

 

By the end of the lesson, the learner should be able to

·        Define the term worksheet

·        Create a worksheet

·        Save/retrieve a worksheet

 

·        Q/A demonstration practical

 

·        Handouts

·        Class register

·        Accounts book

·        Working computer

 

·        Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 57-65

 
 

10

 

1

   

CELL DATA TYPES

 

By the end of the lesson, the learner should be able to

·        Define the term cell data type

·        Explain the different data types

 

·        Q/A discussion

 

·        Books

 

·        Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 66

 
   

2-3

   

CELL REFERENCING

 

By the end of the lesson, the learner should be able to

·        Define the term cell referencing

·        Explain the different cell referencing

·        Apply cell referencing on a computer

 

·        Q/A Demonstration practical

 

·        Books

·        Handouts

·        Working computer

 

·        Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 66-69

 
 

11

 

1

   

FUNCTIONS AND FORMULAE

 

By the end of the lesson, the learner should be able to

·        Differentiate between functions and formulae

·        Apply functions and formulae on a document

 

·        Q/A demonstration Practical

 

·        Working computer

·        Books

 

 

·        Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 70-73

 
   

2-3

   

WORKSHEET FORMATTING

 

By the end of the lesson, the learner should be able to

·        Format a worksheet: text, numbers, rows, columns and global

 

·        Q/A Demonstration practical

 

·        Books

·        Handouts

·        Working computer

 

·        Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 74-79

 
 

12

 

1

   

DATA MANAGEMENT

 

By the end of the lesson, the learner should be able to

·        Explain the terms, Sort, filter, total forms

·        Apply the above features

 

·        Q/A Demonstration practical

 

·        Books

·        Working computer

 

 

·        Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 73-75

 
   

2-3

   

CHARTS/GRAPHICS

 

By the end of the lesson, the learner should be able to

·        Definite the terms chart

·        Explain the different charts

·        Insert charts

 

·        Q/A Demonstration practical

 

·        Books

·        Handouts

·        Working computer

 

·        Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 77-79

 
  END TERM EXAMS/SCHOOLS CLOSE
 

 

 

 

 

 

COMPUTER FORM 2 SCHEMES OF WORK – TERM 2

DATABASES
WEEK LESSON TOPIC SUB – TOPIC OBJECTIVES LEARNING/TEACHING ACTIVITIES LEARNING/TEACHING RESOURCES REFERENCES REMARKS
1   Reporting from home and settling for the second term work
 

2

 

1

   

DATABASE

 

By the end of the lesson, the learner should be able to

·        Define the database

·        Explain the concept of D/base

 

·        Q/A discussion

 

·        Class list

 

·        Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 93-94

 
   

2-3

   

DATABASE MODELS

 

By the end of the lesson, the learner should be able to

·        Define the term d/base model

·        Explain the difference d/base models

·        Discuss the features of a database

 

·        Q/A demonstration practical

 

·        Handouts

·        Books

·        Working computer

 

·        Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 96-98

 
 

3

 

1

   

DATA ORGANIZATION

 

By the end of the lesson, the learner should be able to

·        Organize data in a database

·        Start Ms Access

 

·        Q/A demonstration practical

 

·        Handouts

·        Books

·        Working computer

 

 

·        Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 97-100

 
   

2-3

   

MS ACCESS SCREEN LAYOUT

 

By the end of the lesson, the learner should be able to

·        Explain the access screen layout

·        Create a database

 

·        Q/A Demonstration practical

 

·        Letters

·        Cards

·        Books

·        Working computer

 

·        Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 100-104

 
 

4

 

1

   

EDITING A D/BASE

 

By the end of the lesson, the learner should be able to

·        Edict a data base

 

·        Q/A Demonstration practical

 

·        Letters

·        Cart

·        Working computer

 

·        Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 108-109

 
   

2-3

   

QUERIES

 

By the end of the lesson, the learner should be able to

·        Define the term query

·        Crate a query

 

·        Q/A Demonstration Practical

 

·        Letters

·        Card

·        Working computer

 

·        Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 116-117

 
 

5

 

1

   

UPDATING A QUERY

 

By the end of the lesson, the learner should be able to

·        Update a query

·        View a query

 

·        Q/A Demonstration practical

 

·        Handouts

·        Books

·        Working computer

 

·        Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 120-122

 
   

2-3

   

FORM DESIGN

 

By the end of the lesson, the learner should be able to

·        Explain the form layout

·        Create a form

 

·        Q/A Demonstration practical

 

·        Books

·        Newspaper

·        Working  computer

 

·        Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 110-113

 
 

6

 

1

   

FORMATTING FIELDS

 

By the end of the lesson, the learner should be able to

·        Display records in a form

·        Format fields

 

·        Q/A Demonstration practical

 

·        Handouts

 

·        Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 113

 

 
   

2-3

   

REPORTS LAYOUT

 

By the end of the lesson, the learner should be able to

·        Define a report

·        Create a report

·        Modify a report

 

Q/A Demonstration Practical

 

·        Handouts

·        Books

·        Working Computer

 

·        Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 125-129

 

 
 

7

 

1

   

REPORTS LAYOUT

 

 

By the end of the lesson, the learner should be able to

·        Sort and group data in a report

·        Design labels

 

·        Q/A Demonstration practical

 

·        Forms

·        Report

·        Working computer

 

·        Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 40-41

 

 
   

2-3

   

PRINTING

 

By the end of the lesson, the learner should be able to

·        Define the term printing

·        Print: form and a report

 

·        Q/A Demonstration Practical

 

·        Forms

·        Report

·        Working computer

 

·        Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 112

 
DESKTOP PUBLISHING
 

8

 

1

   

DESKTOP PUBLISHING

 

By the end of the lesson, the learner should be able to

·        Define DTP S/W

·        State then purpose of DTPS/W

 

·        Q/A Demonstration practical

 

·        Clip art

·        Working computer

 

·        Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 132-134

 

 
   

2-3

   

DESIGNING A PUBLICATION

 

By the end of the lesson, the learner should be able to

·        Explain the DTP S/W

·        Discuss the types of DTP publications

 

·        Q/A Observation Practical

 

·        Letters

·        Working computer

 

·        Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 133-134

 

 
 

9

 

1

   

DESIGNING A PUBLICATION

 

By the end of the lesson, the learner should be able to

·        Run the DTP program

·        Explain the DTP screen layout

 

·        Q/A discussion

 

·        Cards, certificates, text, calendars, text books

 

·        Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 134-136

 
   

2-3

   

DESIGNING A PUBLICATION

 

By the end of the lesson, the learner should be able to

·        Set up a publication

·        Manipulate text and graphics

 

Q/A demonstration practical

 

·        Cards, certificates, text calendars, textbooks

·        Working Computer

 

 

·        Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 139-143

 
 

10

 

1

   

TEXT

 

By the end of the lesson, the learner should be able to

·        Design page layout

·        Use a ruler to measure

 

·        Q/A discussion

 

·        Calendars, textbooks

 

 

·        Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 158

 
   

2-3

   

GRAPHICS

 

By the end of the lesson, the learner should be able to

·        Define the term graphics

·        Change full stroke

·        Reshape objects

 

·        Q/A Demonstration practical

 

·        Books

·        Handouts

·        Working Computer

 

·        Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 150

 
 

11

 

1

   

GRAPHICS

 

By the end of the lesson, the learner should be able to

·        Copy an object

·        Import and wrap text

 

·        Q/A Demonstration Practical

 

·        Books

·        Handouts

·        Working computer

 

·        Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 161-162

 
   

2&3

   

GRAPHICS

 

By the end of the lesson, the learner should be able to

·        Group objects

·        Lock objects

 

·        Q/A Demonstration Practical

 

·        Books

·        Handouts

·        Working computer

 

·        Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 164-168

 
 

12/13

 

1

   

ROTATE/CROP

 

By the end of the lesson, the learner should be able to

·        Explain the terms, sort, filter, total, forms

·        Apply the above features

 

·        Q/A Demonstration practical

 

·        Books

·        Working computer

 

 

·        Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 164

 
  THE SCHOOL CLOSES/END OF TERM EXAMS
 

 

 

 

 

 

 

 

COMPUTER FORM 1 SCHEMES OF WORK – TERM 1

 

INTERNET AND E-MAIL

WEEK LESSON TOPIC SUB – TOPIC OBJECTIVES LEARNING/TEACHING ACTIVITIES LEARNING/TEACHING RESOURCES REFERENCES REMARKS
1 Reporting from home and settling for the first term work
 

2

 

1

   

INTERNET AND E-MAIL

 

By the end of the lesson, the learner should be able to

·        Define the term internet

·        Explain the development of internet

 

·        Q/A discussion

·        Demonstration

·        observation

 

·        internet

·        Text book

·        Working Computer

 

·        Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 168-169

 

 
   

2-3

   

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

 

 
 

3

 

1

   

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

 

 
   

2-3

   

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

 
   

1

   

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

 
 

4

 

2-3

   

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

 

 
 

5

 

1

   

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

 

 
   

2-3

   

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

 

1

   

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

 
   

2-3

   

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

 
 

7

 

1

   

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

 

 
   

2-3

   

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

 

 
 

8

 

1

   

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

 
   

2-3

   

G. DATA SECURITY AND CONTROLS

 

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

 
 

9

 

1

   

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

 
   

2-3

   

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

 
 

10

 

1

   

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

 
   

2-3

   

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

 
 

11

 

1

   

ICT LEGISLATION

 

By the end of the lesson,  the learner should be able to

·        Discuss ICT laws

 

·        Q/A discussion

   

·        Computer studies by S.John Onunga page 328-331

 
   

2-3

   

WORKSHEET FORMATTING

 

By the end of the lesson, the earner should be able to

·        Format a w/sheet: text, numbers, rows, columns and global

 

·        Q/A Demonstration practical

 

·        Books

·        Handouts

·        Working computer

 

·        Longhorn Computer studies Secondary. S.Mburu, G. Chemwa page 190-193

 

 
   

SCHOOLS CLOSES END OF YEAR

 

Leave a Reply

Your email address will not be published. Required fields are marked *

*