Welcome to scheme section of our lessons. Do have great time exploring.

DATA PROCESSING SSI Scheme of Work.
This scheme contains weeks, topics, units as well as teacher and learners activities to help teachers in preparation of lessons.

DATA PROCESSING SSI FIRST TERM

1 History of computing Concrete devices

Teacher’s/Pupils Activities
i. Mention concrete device used in computing e.g tally stick, coins, rope etc
ii. Identify concrete devices used in computing.

Teacher’s/Pupils Activities
2 History of computing
Numbering system
Conversion from one number system to another
i. Explain number systems (binary, octal, decimal and hexadecimal number systems)
ii. Change from one number system to another
3 Digitalization of data

  • Definition
  • History of computer development

i. Definition of digitalization
ii. Explain process of digitalization (how data is changed to machine code)
iii. Explain history of computer
development e.g. Abacus, Pascal, Babbage, Hotterith and Eniac.
4 Digitalization of data

  • Types of computers
  • Components of computers

i. List and explain types of computers e.g. mainframe, laptops etc
ii. Name and explain computer components.
iii. Input devices e.g. keyboard
iv. Processing device e.g. CPU
v. Output device e.g. Visual Display Unit (VDU)
vi. Identify components of a computer
5 Data and information

  • Data
  • Data types
  • Information

i. Definition of data
ii. State types of data e.g. strings, numbers etc
iii. Definition of information
6 History of computer

  • Generations of computer
  • Characteristics features of each generation

Teacher’s/Pupils Activities
i. Mention the generation of computer
ii. Describe each generation of
computer in terms of year of development, the technology
speed of operation storage capacity etc.
Identify the generation of computer and match each with its characteristics features
7 Classification of computers

  • By type
  • By size
  • By functionality

Teacher’s/Pupils Activities
i. List classification of computer by size e.g. supercomputer
ii. By type e.g. digital
iii. By function e.g. general purpose computer
8 ICT Application in everyday life

  • Uses of ICT
  • ICT and the society

Teacher’s/Pupils Activities
i. Explain the uses of ICT
ii. Explain and leads discussion on the importance of ICT in the society

9 The art of information processing

  • Information processing procedures
  • Definition of information processing.

Teacher’s/Pupils Activities
State the procedures for information processing
i. Collation of information
ii. Organization of information
iii. Analysis of information
iv. Interpretation of information
10 Process of information transmission

  • Method of transmission information
  • Method of transmitting information

Teacher’s/Pupils Activities

i. Definition of information transmission
ii. List and explain method of transmitting information e.g. newspaper, radio, telephone, television etc
11 Medium of information transmission

Teacher’s/Pupils Activities
Name types of medium of information transmission

Types of medium for transmission and receiving information
Classify information by means of transmission and mode of receiving
– Wireless e.g. Bluetooth, infrared
– Satellite e.g. internet
– Cable e.g. cable TVs
– Radio waves e.g. Radio station
12 Medium of information Transmission
Classification of means of Transferring information.

Teacher’s/Pupils Activities
Classify means of transmitting information
i. Electronic
ii. Non ā€“ electronic
13 Revision Revision
14 Examination Examination

DATA PROCESSING SS I SECOND TERM

1 Operation system
Types of operating system

Teacher’s/Pupils Activities
i. Definition of operating system
ii. States types of operating system
2 Operating system
Examples of operating system
Function of operating system
i. Gives example of operating system
ii. Outlines the function of an operating system
iii. Listen to teacher explanation
3 Word processing
Uses of word processing software
Example of word processing software
i. Define word processing
ii. State the uses of word processing software
iii. List the examples of word processor (micro soft word)
4 Exploring the word window
Load and exit Ms word
Component of the word window
Create and save new document
i. Start Microsoft word
ii. Name the components
iii. Create a new document and save it.
Instructional Resources
Computer set, ms office software
5 Editing a document
Open an existing document
Correct errors
i. Open an existing document
ii. Correct typing errors using arrow, delete and
backspace keys
iii. Correcting document using copy, cut and paste facilities
6 Formatting texts

i. Modifying text font and size

Modify text font and size
Align text
Indent paragraph
Insert headers and footers
ii. Aligning text in document
iii. Indenting paragraph and modifying line spacing
iv. Inserting headers and footers
Instructional resources
Computer system, projector with screen, ms office software.
7 Working with table

  • Tables and its functions
  • Create tables
  • Format tables

i. Define tables and states its functions
ii. Create table using insert and draw method
iii. Formatting tables
Instructional resources
Computer system, projector with screen, Ms Office Software
8 Working with graphics

  • Using insert tab
  • Working with shapes and Smart Art

i. Inserting pictures, clip art, Word Art and charts using the insert tab.
ii. Inserting shapes and working with Smart Art graphic.
Instructional resources : Computer system, projector with screen, Ms Office Software
9 Spreadsheet

  • Uses of Spreadsheet
  • Examples of Spreadsheet

i. Definition of spreadsheet
ii. States the uses of spreadsheet
iii. Give the examples of spreadsheet package
Instructional resources: Computer set, interactive training CD
10 Spreadsheet
Component of spreadsheet
i. Load ms ā€“ excel software
ii. Show them the components of Ms Excel (worksheet, workbook, cell, cell range name box, formula bar etc)
Instructional Resources: Ms excel software, computer set
11 Revision Revision
12 Examination Examination

DATA PROCESSING SS I THIRD TERM

1 Inserting formulas and using functions

  • Writing simple formula
  • Writing complex formula

i. Write simple formulas of addition, subtraction, multiplication and division.
ii. Use auto sum, average, product and quotient functions.
iii. Total rows and columns.
Instructional resources : Computer set, ms excel software
2 Formatting the worksheet

  • Align cells
  • Selecting columns, rows and entire worksheet
  • Inserting and deleting rows and columns
  • Adjust column width and row height
  • Changing vertical alignment and rotating cell content

i. Type in a range of cells and align the content
ii. Select column, rows and entire worksheet
iii. Insert and delete rows and columns
iv. Adjust columns width and rows height
v. Change vertical alignment and rotate all content
Instructional Resources
Computer set, ms excel software
3 Formatting the worksheet

  • Transferring data
  • Merging cell
  • Inserting and removing borders and gridlines

i. Transfer data from one worksheet to another workbook
ii. Merge cells
iii. Insert and removed borders and gridlines
Instructional resources
Computer set, ms excel software
4 Managing data in spreadsheet

  • Creating references
  • Using built in function

i. Create cell references (BIO, C2 : H2)
ii. Use built in functions common to financial and statistical applications. Sum, average, product, cumulative frequency etc.
iii. Guide the students to Sort data in ascending or descending order.
iv. Filter data using auto filter and custom filter
5 Managing data in spread sheet

  • Sorting data
  • Filtering data

i. Sort data in ascending or descending order
Filter data using auto filter and custom filter
6 Creating charts on spreadsheet
Creating different types of charts
Create different types of chart, pie, line, column and bar chart
Guide students to create their own chart
7 Introduction to Database Management System (DBMS)

  • Uses applications of Database
  • Components of DBMS
  • Examples of DBMS

i. Define database, and database management system
ii. State uses or application areas of database
iii. List and explain components of DBMS

  • Software
  • Hardware
  • Data
  • Procedure
  • Access language
  • Users

iv. Give examples of Database Management System such as oracle, access, SQL server etc
Instructional resources
Computer set, interactive training CD
8 Database working environment

  • Load access
  • Data types
  • Samples of DBMS in local template

i. Open Ms access and navigate the environment to show different components
ii. Name and explain all the data types: text, memo etc.
open north wind in local template, practice loading and exiting Ms access.
Instructional resources: Computer set, ms access software
9 Database objects

  • Table
  • Forms
  • Report
  • Query
  • Macro

Creating table in design view
i. Define all the access object and show them samples from the system.
ii. Create access table in design view, inserting fields and declaring their data types

iii. Students should practice creating table
Instructional Materials
Computer set, Ms access software
10 Computer ethics
Computer room management ethics
Laboratory rules and regulations.
i. Explain computer room
management ethics.
ii. List and explain laboratory rules and regulations.
Instructional Materials
Charts of an ideal computer room /
laboratory
11 Safety measures
i. Sitting arrangement
ii. Positioning of monitor base
iii. Illuminating the computer room
iv. Maintaining adjust free environment
v. Keep liquid away from the computers.
i. State adequate sitting arrangement in a
ii. Demonstrate how to position
the monitor base
iii. Explain the necessity of illuminating the computer room and keeping liquid away from the computers.
iv. Explain how to maintain dust free environment
Instructional resources: Charts, pictures
12 Revision Revision
13 Examination Examination

Was this helpful? Do stay connected to itsmyschoollibrary.com for more educational contents.