Longhorn Secondary Form 3 Computer Studies Schemes of Work Term 3 2020/2021

Rate this item
(0 votes)
WEEK LESSON TOPIC SUB-TOPIC OBJECTIVES    LEARNING/TEACHING ACTIVITIES LEARNING/ TEACHING RESOURCES REFRENCES REMARKS
1 1 PROGRAMMING WITH VISUAL AIDS Definition

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

  • Define the term visual basic

  • start up visual basic

  • Identify features of visual basic
  • Demonstration by the teacher

  • Discussions

  • Question and answer
  • Chalkboard

  • Computer

  • Chart
Longhorn Computer Studies by Mburu and Chemwa Bk.3 page 122.  
  2 PROGRAMMING Visual basic tool box

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

  • Identify parts of the visual basic tool box

  • Describe parts of the visual basic tool box
  • Demonstration

  • Question and answer
  • Chalkboard

  • Photograph

  • Computer
Longhorn Computer Studies by Mburu and Chemwa Bk.3 page 123.  
  3-4   Saving a visual project

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

  • Save a visual basic project

  • Open an existing visual basic project
  • Demonstration by the teacher

  • Question and answer

  • Practical
  • Computer

  • Chalkboard
Longhorn Computer Studies by Mburu and Chemwa Bk.3 page 123.  
2 1   Visual basic fundamental concepts

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

  • Identify the visual basic fundamental concepts

  • Describe the listed fundamental concepts
  • Discussions

  • Questions and answers
  • Chalkboard

  • Charts

  • Computer

  • Simple calculators
Longhorn Computer Studies by Mburu and Chemwa Bk.3 page 136.  
  2   Mathematical operators

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

  • Identify  mathematical operators

  • Describe the listed mathematical operators
  • Discussions

  • Questions and answers
  • Chalkboard

  • Charts

  • Computer

  • Simple calculators
Longhorn Computer Studies by Mburu and Chemwa Bk.3 page 137.  
  3-4   Numeric strings and values

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

  • Convert a numeric string to a value

  • Convert a value to a string
  • Illustration by the teacher

  • Discussions

  • Question and answer
  • Charts

  • Computer
Longhorn Computer Studies by Mburu and Chemwa Bk.3 page 137.  
3 1   Project Developments

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

  • Create a program used to calculate the area of a rectangle
  • Discussions in groups

  • Illustrations by the teacher
  • Charts

  • Computer
Longhorn Computer Studies by Mburu and Chemwa Bk.3 page 145.  
  2   Project Developments

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

  • Write a program used to find roots of a quadratic expression
  • Discussion in groups

  • Illustrations by the teacher
  • Charts

  • Computer
Longhorn Computer Studies by Mburu and Chemwa Bk.3 page 147.  
  3-4  

Case construct

Looping Construct

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

  • Use case statement that can display the name of a weekday when its number is provided

  • Write a program using a do-loop

  • Write a program using FOR-NEXT LOOP
  • Demonstration by the teacher

  • Discussion

  • Question and answer
  • Chart

  • Chalkboard

  • Computer printer
Longhorn Computer Studies by Mburu and Chemwa Bk.3 page 147.  
4 1    Working with graphical objects

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

  • Insert a picture using a picture box

  • Define module and procedure

  • Declare general subroutines
  • Demonstration by the teacher

  • Discussion

  • Question and answer
  • Chart

  • Computer
Longhorn Computer Studies by Mburu and Chemwa Bk.3 page 150.  
  2   Working with graphical objects

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

  • Write a general subroutine that solves  y= xn  given that the value of n are integers
  • Demonstration by the teacher

  • Question and answer

  • Practical
  • Computer

  • Printer

  • Chart

  • Chalkboard

 

Longhorn Computer Studies by Mburu and Chemwa Bk.3 page 151  
  3-4   Creating means and dialogue boxes

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

  • Create a dropdown menu

  • Create a message and dialogue box
  •  Demonstration

  • Discussion

  • Question and answer
 
  • Chart

  • Printer

  • Computer

  • Chalkboard
 Longhorn Computer Studies by Mburu and Chemwa Bk.3 page 151  
5 1   List boxes and control boxes

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

  • Define list box and combo box

  • Create a list box and combo box

  • Create a project that loads a list of items
  • Discussion

  • Demonstration

  • Practical
 
  • Chart

  • Photograph

  • Computer

  • Chalkboard
 Longhorn Computer Studies by Mburu and Chemwa Bk.3 page 161  
  2   Visual basic data structures

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

  • Define the term arrays

  • Declare an array
 
  • Discussion

  • Demonstration

  • Practical
 
  • Chart

  • Photograph

  • Computer

  • Chalkboard
 Longhorn Computer Studies by Mburu and Chemwa Bk.3 page 163  
  3-4   Visual basic data structures

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

  • Declare two dimensional arrays

  • Write an array of records
 
  • Discussion

  • Demonstration

  • Practical
 
  • Chart

  • Photograph

  • Computer

  • Chalkboard
 Longhorn Computer Studies by Mburu and Chemwa Bk.3 page 161  
6 1   Data files

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

  • Define a file

  • Identify types of files recognized by visual basic

  • Link virtual basic to data base
 
  • Discussion

  • Demonstration

  • Practical
 
  • Chart

  • Computer

  • Chalkboard
 Longhorn Computer Studies by Mburu and Chemwa Bk.3 page 187-189  
  2 INTRODUCTION TO DATA BASE DESIGN Definition

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

  • Define a file

  • Identify types of files recognized by virtual basic

  • Link virtual basic to data base
 
  • Discussion

  • Demonstration

  • Practical
 
  • Chart

  • Computer

  • Chalkboard
 Longhorn Computer Studies by Mburu and Chemwa Bk.3 page 187-189  
  3-4   Defining attributes

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

  • Define a foreign key

  • Distinguish between an entity and attributes

  • Create one to many relationships
  • Question and answer

  • Practical

  • Demonstration

  • Discussions
 
  • Chart

  • Computer

  • Chalkboard
 Longhorn Computer Studies by Mburu and Chemwa Bk.3 page 203-204  
7 1   File table structure

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

  • Create a table 

  • Set primary key and foreign key
  • Demonstration

  • Discussion

  • Practical
 
  • Chart

  • Computer

  • Chalkboard
 Longhorn Computer Studies by Mburu and Chemwa Bk.3 page 217  
  2   Enforcing Referential integrity

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

  • Enforce referential integrity between tables

  • Normalize table

 

  • Demonstration

  • Discussion

  • Practical
 
  • Chart

  • Computer

  • Chalkboard
 Longhorn Computer Studies by Mburu and Chemwa Bk.3 page 217  
  3-4   Forms and commands

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

  • Create a form/ interface

  • Call for commands
 
  • Discussion in groups

  • Demonstration

  • Practical

  • Question and answer
 
  • Chart

  • Computer

  • Chalkboard
 Longhorn Computer Studies by Mburu and Chemwa Bk.3 page 210  
8 1   Creating reports

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

  • Describe the tools used to automate database

  • Create a switchboard
 
  • Discussion in groups

  • Demonstration

  • Practical

  • Question and answer
 
  • Chart

  • Computer
 Longhorn Computer Studies by Mburu and Chemwa Bk.3 page 211  
  2   Automating database

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

  • Describe the tools used to automate database

  • Create a switchboard
  •  Discussion in groups

  • Demonstration

  • Practical

  • Questions and Answers
  • Chart

  • Computer
 Longhorn Computer Studies by Mburu and Chemwa Bk.3 page 212  
  3-4   Automating database

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

  • Create macros

  • Develop a system using a case study
  • Demonstration

  • Assignment
 
  • Chart

  • Computer
 Longhorn Computer Studies by Mburu and Chemwa Bk.3 page 212  

REVISION AND END TERM EXAMS

 
          
Read 675 times Last modified on Tuesday, 25 May 2021 13:57

Leave a comment

Make sure you enter all the required information, indicated by an asterisk (*). HTML code is not allowed.