Spreadsheet: 744226d1629094803-want-to-pull-in-data-automatically-from-other-sheets-working-lessonplan
Sheet: scheme of work G9

1 | Remedial Work Flowcharts | Quick Test Pg 82, Qu 1-3
2 | Programming and Flowcharts Selection | Quick Test Pg 82 Qu 4-6
3 | Programming and Flowcharts Dry Run | Quick Test Pg 88-89 Revision Time  Pg 90-92
4 | Programming and Flowcharts Sequence | Written Test
5 | Spreadsheet | Quick Test Pg 127 Qu 1
6 | Creating and Formatting a Worksheet | Quick Test Pg 127 Qu 1,2
7 | Creating and Formatting a Worksheet continued | Revision Time  Pg 131- 134
8 | Class Assessment 2 Test on MS Excel
9 | Multimedia and some of its uses | Quick Test Pg 39 Qu 1-3
10 | Range of ICT applications and their effects in everyday life | Quick Test Pg 45,46 Qu 1-3
11 | Automatic Teller Machine | Quick Test Pg 48 Qu 1
12 | Potential health problems related to ICT | Quick Test Pg 51-52 Qu 1,2 Revision Time Pg 53- 54Exam Prac Pg54-56
13
Dr [NAME]
SCHEME OF WORK: 2019 Term 1
Computer Science Department
Name of Educator |  | : Mr. [NAME], Mr [NAME] |  |  |  |  | Subject | : Computer Science
Number of periods per week | : 2 |  |  |  |  |  |  |  | Class |  | : Form 3
Textbook |  |  | : Information Communications Technology (S3)
Field of Extra & Co-Curricular Activities involved: ………………………………………………………………………………………………….
Week | Date | Topic |  |  | Teaching Strategies | Objective/Learning Outcome | Homework/ Class work |  | Remarks
 |  |  |  |  |  | At the end of the lesson, students should be able to:
1 | 14 Jan        –               18 Jan | Introducing the syllabus |  |  | Questioning | - Show an awareness of the subject
2 | 21 Jan        –               25 Jan | 1 Components of a computer system |  |  | Demonstration | - Define hardware, software
 |  | -          Hardware |  |  | Expository | - Give examples of hardware, software
 |  | -          Software |  |  | [NAME] notes | - Differentiate between hardware and software
3 | 28 Jan        –               01 Feb | 2 Components of a general purpose computer |  |  | Demonstration | Identify the main components of a general purpose computer
 |  | CPU |  |  | Expository |  | Pg 11 Quick Test 1.1
 |  | -          Main Memory |  |  | [NAME] notes
 |  | -          ALU
 |  | -          Control Unit
4 | 04 Feb        –               08 Feb | 3 Input Devices |  |  | Demonstration | Write short notes on the following devices
 |  | -          Keyboard |  |  | Expository | ü  Keyboard
 |  | -          Mouse |  |  | [NAME] notes | ü  [NAME] | Pg 13 Quick Test 1.2
 |  | -          Touchpad |  |  |  | ü  Touchpad
 |  | -          Tracker ball |  |  |  | ü  Tracker ball
 |  | -          Touch screen |  |  |  | ü  Touch screen
 |  | -          Graphics |  |  |  | ü  Graphics
 |  | -          Tablets |  |  |  | ü  Tablets
 |  | -          Joystick |  |  |  | ü  [NAME]
 |  | -          Scanner |  |  |  | ü  [NAME]
5 | 11 Feb       –               15 Feb
 |  | Class Assessment 1
6 | 18 Feb          –               22 Feb | 4 Output devices |  |  | Demonstration | Write short notes on the following devices
 |  | ü  Monitor |  |  | Expository | ü  Monitor | Pg 16 Quick Test 1.3
 |  | ü  Printer |  |  | [NAME] notes | ü  Printer
 |  | ü  Speaker |  |  |  | ü  Speaker
 |  | ü  Plotter |  |  |  | ü  Plotter
7 | 25 Feb       –               01 March | 5 Binary digits |  |  | Demonstration | Know how data is stored in storage devices | Pg 21/22 Quick Test 1.4
 |  | 5.1 Relationship of data representation: bit, byte and character |  |  | Expository | - Represent data in terms of  Bits, Bytes and characters
 |  | 5.2 ASCII Code |  |  | [NAME] notes | - Differentiate between Bits, Bytes, KB, MB, TB
 |  | 5.3 Units of measurement (Bits, Bytes, KB, MB, TB)
 |  | + Secondary storage devices
8 | [NAME]–               08 Mar | 6 Computer System |  |  | Demonstration | Differentiate between the 4 types of computers
 |  | 3.1 Computational Capabilities of various types of computers |  |  | Expository | - Write down the uses of | Pg 26 Quick Test 1.5
 |  | -          Microcomputer |  |  | [NAME] notes | ü  Microcomputer
 |  | -          Minicomputer |  |  |  | ü  [NAME]
 |  | -          Mainframe |  |  |  | ü  Mainframe
 |  | -          supercomputer |  |  |  | ü  Supercomputer
9 | 11 Mar       –               15 Mar
 |  | Class Assessment 2
10 | 18 Mar       –               22 Mar | 7 Word Processing |  |  | Demonstration | Create new documents
 |  | -          Creating new documents |  |  | Expository | Save documents | Pg 32 Quick Test 1.6
 |  | -          Saving |  |  | [NAME] notes | Enter and delete text
 |  | -          Entering and deleting text |  |  | Hands on activity | Format Text
 |  | -          Formatting Text |  |  |  | [NAME] spacing | Practical Exercises
 |  | -          Line spacing |  |  |  | Place text to Subscript/
 |  | -          Subscript |  |  |  | Superscript
 |  | -          Superscript |  |  |  | Insert Header/ Footers
 |  | -          Header/ Footers
11 | [NAME]–               29 Mar | 8 Mail Merge |  |  | Demonstration | Explain the term Mail merge | Practical exercises
 |  | -          Advantages |  |  | Expository | Give advantages and disadvantages of Mail merge | + Pg 38 Quick Test 1.7 + Pg 39 Quick Test 1.8
 |  | -          Disadvantages |  |  | [NAME] notes
 |  |  |  |  | Hands on activity
12 | 01 April       –               05 April | To continue Word processing |  |  | Hands on activity | Past Exam questions | Past exam papers questions on Word Processing – Oct 2016, Oct 2015
13 | 08 April       –               12 April
 |  | Revision and recap of topics covered during first term.
Date:…………………………………………………Signature of Educator………………………………………..Signature of HOD…………………………………..
Date:……………………………………………….. Signature of Rector/Deputy Rector:………………………………………………………………………………….