Education resource centre



Download 3.49 Mb.
Page38/47
Date29.01.2017
Size3.49 Mb.
#11609
1   ...   34   35   36   37   38   39   40   41   ...   47

DATA PROCESSING

SSI FIRST TERM

WEEK

TOPIC / CONTENT

ACTIVITIES

1

History of computing

Concrete devices



  1. Mention concrete device used in computing e.g tally stick, coins, rope etc

  2. Identify concrete devices used in computing

2

History of computing

Numbering system

Conversion from one number system to another


  1. Explain number systems (binary, octal, decimal and hexadecimal number systems)

  2. Change from one number system to another

3

Digitalization of data

Definition

History of computer development


  1. Definition of digitalization

  2. Explain process of digitalization (how data is changed to machine code)

  3. Explain history of computer development e.g. Abacus, Pascal, Babbage, Hotterith and Eniac.

4

Digitalization of data

Types of computers

Components of computers


  1. List and explain types of computers e.g. mainframe, laptops etc

  2. Name and explain computer components

  3. Input devices e.g. keyboard

  4. Processing device e.g. CPU

  5. Output device e.g. Visual Display Unit (VDU)

  6. Identify components of a computer




5

Data and information

Data


Data types

Information



  1. Definition of data

  2. State types of data e.g. strings, numbers etc

  3. Definition of information

6

History of computer

Generations of computer

Characteristics features of each generation


  1. Mention the generation of computer

  2. 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



  1. List classification of computer by size e.g. supercomputer

  2. By type e.g. digital

  3. By function e.g. general purpose computer

8

ICT Application in everyday life

Uses of ICT

ICT and the society


  1. Explain the uses of ICT

  2. 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

State the procedures for information processing



  1. Collation of information

  2. Organization of information

  3. Analysis of information

  4. Interpretation of information

10

Process of information transmission

Method of transmission information

Method of transmitting information


  1. Definition of information transmission

  2. List and explain method of transmitting information e.g. newspaper, radio, telephone, television etc

11

Medium of information transmission

Types of medium for transmission and receiving information

Classify information by means of transmission and mode of receiving


Name types of medium of information transmission

  • 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 Tran



Classify means of transmitting information

  1. Electronic

  2. Non – electronic

13

Revision

Revision

14

Examination

Examination

DATA PROCESSING

SS I SECOND TERM

WEEK

TOPIC / CONTENT

ACTIVITIES

1

Operation system

Types of operating system



  1. Definition of operating system

  2. States types of operating system

2

Operating system

Examples of operating system

Function of operating system


  1. Gives example of operating system

  2. Outlines the function of an operating system

  3. Listen to teacher explanation

3

Word processing

Uses of word processing software

Example of word processing software


  1. Define word processing

  2. State the uses of word processing software

  3. 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



  1. Start Microsoft word

  2. Name the components

  3. Create a new document and save it.

Instructional Resources

Computer set, ms office software



5

Editing a document

Open an existing document

Correct errors


  1. Open an existing document

  2. Correct typing errors using arrow, delete and backspace keys

  3. Correcting document using copy, cut and paste facilities

6

Formatting texts

Modify text font and size

Align text

Indent paragraph

Insert headers and footers


  1. Modifying text font and size

  2. Aligning text in document

  3. Indenting paragraph and modifying line spacing

  4. 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



  1. Define tables and states its functions

  2. Create table using insert and draw method

  3. 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


  1. Inserting pictures, clip art, Word Art and charts using the insert tab

  2. 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


  1. Definition of spreadsheet

  2. States the uses of spreadsheet

  3. Give the examples of spreadsheet package

Instructional resources

Computer set, interactive training CD



10

Spreadsheet

Component of spreadsheet



  1. Load ms – excel software

  2. 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 TERD

WEEK

TOPIC / CONTENT

ACTIVITIES

1

Inserting formulas and using functions

Writing simple formula

Writing complex formula


  1. Write simple formulas of addition, subtraction, multiplication and division

  2. Use auto sum, average, product and quotient functions

  3. 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



  1. Type in a range of cells and align the content

  2. Select column, rows and entire worksheet

  3. Insert and delete rows and columns

  4. Adjust columns width and rows height

  5. 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



  1. Transfer data from one worksheet to another workbook

  2. Merge cells

  3. Insert and removed borders and gridlines

Instructional resources

Computer set, ms excel software



4

Managing data in spreadsheet

Creating references

Using built in function


  1. Create cell references (BIO, C2 : H2)

  2. Use built in functions common to financial and statistical applications. Sum, average, product, cumulative frequency etc.

  3. Guide the students to Sort data in ascending or descending order

  4. Filter data using auto filter and custom filter

5

Managing data in spread sheet

Sorting data

Filtering data


  1. Sort data in ascending or descending order

Filter data using auto filter and custom filter

6

Creating charts ion 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



  1. Define database, and database management system

  2. State uses or application areas of database

  3. List and explain components of DBMS

  • Software

  • Hardware

  • Data

  • Procedure

  • Access language

  • Users

  1. Give examples of Database Management System 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



  1. Open Ms access and navigate the environment to show different components

  2. 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

  1. Define all the access object and show them samples from the system

  2. Create access table in design view inserting fields and declaring their data types

  3. Students should practice creating table

Instructional Materials

Computer set, Ms access software



10

Computer ethics

Computer room management ethics

Laboratory rules and regulations


  1. Explain computer room management ethics.

  2. List and explain laboratory rules and regulations

Instructional Materials

Charts of an ideal computer room / laboratory



11

Safety measures

  1. Sitting arrangement

  2. Positioning of monitor base

  3. Illuminating the computer room

  4. Maintaining adjust free environment

  5. Keep liquid away from the computers




  1. State adequate sitting arrangement in a computer room

  2. Demonstrate how to position the monitor base

  3. Explain the necessity of illuminating the computer room and keeping liquid away from the computers

  4. Explain how to maintain dust free environment

Instructional resources

Charts, pictures



12

Revision

Revision

13

Examination

Examination

DYING AND BLEACHING

SS1 FIRST TERM

WEEK

TOPIC/CONTENT

ACTIVITIES

1

COLOUR THEORY- INTRODUCTION TO COLOR SCHEME;-

Primary color and formation of secondary colors and process of mixing the tertiary colors.



The teacher explains the color theory. The students draw the chart for better understanding of color scheme.

2

COLOR SCHEME (PRACTICAL)

The teacher demonstrates how to mix the secondary colors. The students produce the color scheme using postal colors (red, yellow and blue) to get the secondary and tertiary colours.

3

FORMATION OF MOTIF- INTRODUCTION TO CREATION AND FORMATION OF MOTIF OR FORMAT AREA.

The teacher demonstrates on how to cut a stencil or motif/design or format area.

The students produce a similar work/ design or motif.



4

FORMATION OF TRADITIONAL AFRICAN MOTIF.

The teacher produces a sample of a traditional or local motif, it can be in animal form, bed, hen, crocodile etc. or stylized motif in foliage.

The students produce a similar motif on cardboard to form a stencil.



5

CREATION OF PATTERNS


The teacher produces pattern with the motif stencil. He guides the students to be observant. The students produce their motif, already cut in stencil, using poster color and textile material through dabbing. Emphasis must be on the arrangement of the pattern.

6

INTRODUCTION TO TIE AND DYE-

Meaning of tie and dye.

Types of reactive dye e.g. vat dye (indanthrene) indigo, dylon.

The binding agents, table salt, caustic soda, sodium hydrosulphate. Some materials like plastic spoons, plastic basin, raffia twin etc.



The teacher explains the use of these materials.

The students listen attentively.



7

TIE AND DYE, A THEORETICAL APPROACH.

Techniques of tie and dye. Folding, knotting, pleating, stiching, twisting, marbling, wick folding and sewing stick assisted pattern. Demonstrate the pattern by using 100% cotton textile material. Get the chemical- vat dye (dye stuff). Custic soda, sodium hydrosulphate. Allow the students to try what you have done. Get the hot water ready with the chemicals. Allow the cloth to stay for about 20 minutes in the dye bath, then remove wash with cold water and spread on the line, not in the hot sun.



The students explain the processes involved in tie and dye.

8

TIE AND DYE (PRACTICAL)

The teacher guides the students as they produce the tie and dye using the materials mentioned.

9

INTRODUCTION TO PLAIN DYING OF FABRIC

The teacher introduces the plain dying. Explains that cotton materials absords, the dye very well. He also explains that the other reaction dyes work with a selected material. He will explain the difference between tie dying and pkin dying. The students get the materials ready for plain dying.

10

PLAIN DYING

The teacher gets the materials ready for plain dying.

11

PLAIN DYING (ANOTHER COLOR)

The teacher teaches the students the process of plain dying in another color, how a darker color super imposes the light color. The students produce it following the teacher’s guide.

12

EXHIBITION OF WORKS

The teacher guides the students to fabricate exhibition stands, display the works. The students display the work.

13

Revision

Revision

14

Examination

Examination


Download 3.49 Mb.

Share with your friends:
1   ...   34   35   36   37   38   39   40   41   ...   47




The database is protected by copyright ©ininet.org 2024
send message

    Main page