information communication technology knec course outline

MODULE 1

INTRODUCTION TO INFORMATION COMMUNICATION TECHNOLOGY AND ETHICS(150 hours)

INTRODUCTION

This module unit is intended to introduce the trainee to information communication Technology,equipping him/her with necessary knowledge,skills and attitude to enable him/her professionally work with ICT facilities.

GENERAL OBJECTIVES

1. Appreciate the role of ICT in contemporary society
2. appreciate the ethical and legal implication in the use of ICT
3. appreciate and uphold professional and life skills in the society

INTRODUCTION TO ICT

1. Meaning of ICT
2. Uses of ICT in organizations
3. ICT equipment/facilities
4. Impact of ICT in contemporary society

INTRODUCTION TO COMPUTERS

1. Meaning and importance of a computer
2. Historical evolution of computers
3. Classification of computers
4. Components of a computer
5. Uses of computers (benefits, challenges).

COMPUTER HARDWARE AND ORGANISATION

1. Computer hardware devices

• central processing unit
• input devices
• output devices
• Storage devices
• Bus system

COMPUTER SOFTWARE

1. Meaning and importance of computer software
2. Classification of computer software
3. Software installation

HARDWARE-SOFTWARE SELECTION AND ACQUISITION

1. Meaning and importance
2. Factors considered
3. Procedures
4. methods

COMPUTER PERSONNEL

1. Roles and skills of computer personnel

COMPUTER SAFETY AND ERGONOMICS

1. Meaning and importance
2. The safety of computer system
3. Ergonomics

INTRODUCTION TO COMMUNICATION NETWORKS

1. Meaning and importance of communication network
2. Types of communication tools/technologies
3. Types of networks

ICT ETHICS AND LEGISLATIONS

1. Meaning and importance of ethics for ICT
2. Ethical challenges in ICT(types,Reasons,Control measures)
3. Meaning and importance of ICT legislations
4. Sources of ICT legislation
5. ICT legislations and policies issues
6. Enforcement measures for ICT legislation and policies

LIFE SKILLS

1. Meaning and importance of life skills
2. Types of life skills

– time management

– self awareness

– self esteem

– emotions and stress management

– people skills

– others

CONFLICT MANAGEMENT

1. Meaning of conflict
2. Importance of managing conflicts
3. Types of conflicts
4. Causes of conflicts
5. Techniques or approaches to conflict management

SOCIAL RESPONSIBILITY IN ICT

1. Meaning and importance of social responsibility
2. Social responsibility in ICT
3. Environmental protection
4. confidentiality and privacy
5. others
6. challenges of social responsibility in ICT

EMERGING TRENDS IN ICT AND ETHICS

1. Emerging trends in ICT and ethics
2. Challenges of emerging trends in ICT and ethics
3. Coping with the challenges of emerging trends in ICT and ethics

 

COMPUTER APPLICATION 1(HOURS)

INTRODUCTION

This  module unit is designed to equip the trainee with knowledge, skills and attitudes that will enable him/ her with appreciating computer application

GENERAL OBJECTIVES

1. By the end of this topic, the trainee should be able to:
2. Understand the basic concept of computer application
3. Appreciate and use word processing application software
4. Use spreadsheet application software
5. Use database application software
6. Appreciate and use desktop publishing
7. Appreciate the application of internet and e-mail facilities
8. Appreciate and use presentation application software

INTRODUCTION TO COMPUTER APPLICATION

1. Meaning
2. Describe types of software
3. State application areas

INTRODUCTION TO OPERATING SYSTEM ENVIRONMENT

1. Meaning
2. Characteristics of OS
3. Launching and closing OS
4. Manipulating key board and mouse
5. Feature of graphical and character use interface
6. Identify basic computer information
7. Using various storage media
8. Manipulation of files and features
9. Scanning and cleaning virus
10. Accessory programs

WORD PROCESSING

1. Starting word processor
2. Editing and formatting a document
3. Opening and editing
4. Text manipulation
5. Formatting tools
6. Creating and formatting a table
7. Calculations in tables
8. Charts creation
9. Mail merge

STYLES, TEMPLATES AND GRAPHICAL EFFECTS

1. Styles and templates
2. Graphics
3. Graphical effects

TABLE OF CONTENT, LIST OF FIGURES AND PRINTING

1. Generating tables of content
2. Generating list of figures
3. Print previews

MACROS EMERGING TRENDS

1. Printing macros
2. Emerging trends

INTRODUCTION AND STARTING SPREADSHEET APPLICATION

1. Definition of spread sheet
2. Importance of spread sheets
3. Opening and closing
4. Screen layout
5. Entering, formatting and editing of data

FUNCTIONS, CALCULATIONS AND SPREAD SHEET TOOLS

1. Functions
2. Linking spread sheets
3. Tools
4. help

MACROS

1. Writing a macro program

CHARTS AND PRINTING

1. Charts
2. Printing of worksheet and charts

EMERGING TRENDS

1. Emerging trends

INTRODUCTION TO DATABASES

1. Definition
2. Uses of databases
3. Advantages
4. Types of databases
5. Database creation

TABLES

1. Data types
2. Types of keys
3. Table of keys
4. Table creation
5. Entering data
6. Editing tables

RELATIONSHIPS

1. Types of relations
2. Linking tables
3. Sorting and filtering

FORMS

1. Creating forms
2. Entering data in forms
3. Editing and formatting

QUERIES

1. Importance
2. Creating queries
3. Listing and formatting queries
4. Calculated field

REPORTS

1. Importance
2. Creating reports
3. Modifying and adding graphs
4. Calculations
5. Headers and footers

PRINTING

1. Printing of various objects

EMERGING TRENDS IN DATABASE APPLICATION

1. Identifying emerging trends
2. Copying with trends

DESKTOP PUBLISHING

1. Definitions
2. Characteristics
3. Importance of desktop publishing
4. Types of desktop publishing

DATA MANIPULATION

1. Data
2. Text
3. Graphics
4. Creating and inserting tables
5. Indexing tables of contents and data

EDITING, FORMATTING AND TRANSFORMATION OF SHAPES

1. Spell checking a document
2. Editing
3. Creating multi-page document
4. Creating and modifying frames
5. Creating and enhancing drawings
6. Aligning, resizing, coping and pasting objects
7. Adding and assigning objects to layers

IMPORTING AND EXPORTING FILES AND DOCUMENTS

1. Importing files and documents
2. Exporting files and documents
3. Merging file and graphs

 

PRINTING

1. Printing pictures
2. Printing graphs
3. Printing text

EMERGING TRENDS IN DESKTOP PUBLISHING

1. Identifying emerging trends

PRESENTATION APPLICATION

1. Definition
2. Types
3. importance

STARTING

1. Opening and closing presentation
2. Screen layout
3. Opening and closing an existing document

CREATING PRESENTATIONS AND SLIDES

1. Create presentation and slides
2. Change slide layout, add and remove a slide
3. Change the order of slides in a presentation
4. Save presentation and slides

EDITING AND FORMATTING SLIDE PRESENTATIONS

1. Editing slides
2. Formatting and resizing slides
3. Adding, footer, header, date, time and page numbers to slides

CREATING TEMPLATES

1. Definition
2. Using template
3. Creating your own master slide template
4. Colour schemes

INSERTING OBJECTS

1. Insert clips arts and objects
2. Modifying clip arts and objects

SLIDE SHOW AND PRINTING

1. Customize slide
2. Slide transition
3. Slide timing
4. Slide presentation
5. Slide printing

EMERGING TRENDS IN PRESENTATION

1. Identification of emerging trends

INTERNET AND EMAIL APPLICATION

1. Definition
2. Concepts
3. Historical background
4. Uses and importance
5. Opening an e-mail account
6. Sending and receiving mails
7. Managing e-mails messages
8. Surfing the internet

EMERGING TRENDS IN INTERNET

1. Identify emerging trends

COMMUNICATION SKILLS (110 hours)

INTRODUCTION

At the end of the course unit, the trainee should comprehend and effectively use communication as required in a modern business office.

GENERAL OBJECTIVES

By the end of the course unit, the trainee should be able to:

1. Learn and apply the principles of communication effectively
2. Use proper language in communication
3. Write and use various documents such as business correspondence, speeches, documents of meeting
4. Use oral, non verbal and visual communication effectively

MEANING AND ROLE OF COMMUNICATION

1. Definition of communication
2. Role of communication organization

THEORY OF COMMUNICATION

1. Conceiving the message
2. Encoding the message
3. Selecting the communication media
4. Decoding the message
5. Interpreting the message
6. Providing feedback

PRINCIPLES OF COMMUNICATION

1. Communicating patterns in firms
2. Role of the Public Relations Department
3. Communication difficulties in firms (barriers of communication)
4. Language in communication
5. spoken

THE SYNTAX AND SEMANTICS

1. Clear wording
2. Arrangement of ideas
3. Paragraphing

SUMMARY

1. Summarizing correspondence
2. Summarizing a whole passage of part
3. Consideration in summary writing length
4. Vocabulary
5. Layout
6. Continuity
7. Interaction of students own ideas
8. Summarizing speeches
9. Summarizing telephone conversation

BUSINESS CORRESPONDENCE

1. Business letter (all types)
2. Memorandum
3. Circulars
4. Telegram/telex/ cables
5. Press advertising
6. Questionnaires
7. Message forms
8. Posters
9. Notices

MEETINGS

1. Different types of meetings
2. Purposes of meetings
3. Terminologies used in meetings
4. Documents used in meetings
5. Advantages and disadvantages of meetings

REPORTS

1. Types of reports
2. Purpose of reports
3. Structure and contents
4. Format and presentation
5. Short informal reports
6. Style and language

ORAL COMMUNICATION

1. Face-to- face communication
2. Speech writing and presentation
3. Oral report
4. Importance and non- verbal communication
5. Non-verbal communication importance
6. Types of non- verbal communication

VISUAL COMMUNICATION

1. Interpretation of various visual aids
2. Organization charts
3. Tables
4. Graphs
5. Pie and cake charts
6. Histograms
7. Flow-charts etc
8. Audio- visual aids
9. Boards
10. Tape recorders
11. Overhead projectors
12. Plastigraphs
13. Filmstrips and slides

STRUCTURED PROGRAMMING (200 hours)

INTRODUCTION

This module unit is intended to equip the trainee with knowledge and skills to write programs using structured programming languages

GENERAL OBJECTIVES

By the end of this module course unit the trainee should be able to;

1. Understand the program development cycle
2. Apply development skills in pascal and c programming languages
3. Understand the various data types, control and data structures used in structured computer programs
4. Develop a program in a structured programming language.

INTRODUCTION TO STRUCTURED PROGRAMMING

1. Structured programming
2. Types of structured programming languages
3. History of programming languages
4. Programming paradigms
5. Hardware and software considerations for structured programming

PROGRAM DEVELOPMENT AND DESIGN

1. Program development and design
2. Program development circle
3. Structured programming concepts
4. Program design tools

PROGRAM STRUCTURE

1. Program structure
2. Format of a structured programming language
3. Operators
4. Data types

PROGRAM WRITING

1. Writing a program in a structured language
2. Handling errors

CONTROL STRUCTURES

1. Control structures
2. Importance of control structures
3. Types of control structures

DATA STRUCTURES

1. Data structures
2. Types of data structures
3. Sort techniques
4. Search techniques

SUB- PROGRAMS

1. Sub- programs
2. Types of sub- programs
3. Scope of variables
4. Parameters

FILE HANDLING

1. Importance of file handling
2. Types of files
3. File organization techniques
4. File design
5. File handling operations

PROGRAM DOCUMENTATION

1. Program documentation
2. Importance of program documentation
3. Types of program documentation
4. Write program documentation

EMERGING TRENDS IN PROGRAMMING

1. Emerging trends in programming
2. Challenges of emerging trends in programming

COMPUTATIONAL MATHEMATICS (130 HOURS)

INTRODUCTION

This module unit is intended to equip the trainee with the knowledge, skills and attitudes to be used in the Information Communication Technology

GENERAL OBJECTIVES

By the end of this module unit, the trainee should be able to:

1. Understand mathematical techniques relevant to Information Communication Technology
2. Use mathematical techniques to solve Information Communication Technology problems
3. Apply mathematical principles in decision making
4. Appreciate the role of computational mathematics in Information Communication Technology.

INTRODUCTION TO COMPUTATIONAL MATHEMATICS

1. Algebra

Quadratic equations

Simultaneous equations

Linear equation with three or more unknowns

Definition of matrices

Matrix operation

Application to matrices

NUMBER SYSTEMS AND BINARY ARITHMETIC

1. Number systems

• Decimal
• Binary
• Octal
• Hexadecimal

2.Binary arithmetic

BINARY CODES

1. BCD
2. GRAY
3. Alphanumeric code

LOGIC GATES AND BOOLEAN ALGEBRA

1. AND
2. OR
3. Inverter
4. Boolean Algebra
5. NAND
6. NOR
7. Implementation
8. Exclusive OR
9. Exclusive NOR

DISCREET COUNTING

1. Fundamental principles
2. Permutations and combinations
3. Binomial expansion

GRAPHS AND FUNCTIONS

1. Continuous functions
2. (interpolations and extrapolations)
3. Graphs of functions
4. Areas under a curve
5. Errors in graphs
6. In-equalities

NUMERICAL ANALYSIS

1. Interactive method
2. Approximation
3. Errors
4. Linear interpolation and extrapolation
5. Finite differences

DATA COLLECTION REPRESENTATION

1. Basic for data collection
2. Data classification
3. Data tabulation
4. Data presentation

MEASURES OF CENTRAL TENDENCY

1. Definition of measures
2. Properties
3. Calculation and
4. Calculations
5. Interpretation

MEASURES OF DISPERSION

1. Characteristics
2. Relative and absolute
3. Measures
4. Measures calculations
5. Interpretation

ELEMENTS OF PROBABILITY

1. Modeling
2. Scale
3. Space
4. Multiple probabilities
5. Conditional probabilities
6. Probability trees

INTRODUCTION TO MODELING

1. Symbolic models
2. Laws of modeling
3. Generalizing models
4. Spartial models
5. Logical models
6. Statistical models

OPERATING SYSTEMS(100 hours)

INTRODUCTION

This module unit is intended to equip the trainee with knowledge, skills and attitudes to enable him/her use operating system in a computing environment.

GENERAL OBJECTIVES

By the end of the module unit the trainee should be able to:

1. Understand the principles of operating systems
2. Appreciate the functions of operating systems
3. Use operating systems in a computer environment

INTRODUCTION TO OPERATING SYSTEM

1. Meaning and importance of operating systems
2. Historical development of operating systems
3. Operating systems structure
4. Types of operating systems
5. Job control

PROCESS MANAGEMENT

1. Meaning and importance
2. Inter-process communication
3. Process scheduling
4. Deadlocks
5. Error diagnosis

MEMORY MANAGEMENT

1. Meaning and importance
2. Memory allocation techniques
3. Virtual memory

DEVICE (1/0) MANAGEMENT

1. Meaning and importance
2. Principles of I/O hardware
3. Principles of I/O software
4. Disks clocks
5. Terminals
6. Virtual device

FILE MANAGEMENT

1. Meaning and importance
2. File systems
3. File management techniques
4. File protection and security

ENTREPRENEURSHIP EDUCATION (154 hours)

INTRODUCTION

This course unit is intended to equip trainee with the necessary knowledge, skills and attitudes that will enable them start, operate a personal or group business enterprise.

It is also intended to install the drive necessary for any of them to venture into profit making activities.

GENERAL OBJECTIVES

By the end of this topic, the trainee should be able to:

1. Demonstrate positive attitudes toward self-employment
2. Identify viable business opportunity
3. Understand factors liable to affect the success of a business
4. Portray a desire to venture into business
5. Apply entrepreneurial competencies in business situations
6. Acquire management skills necessary for running a successful enterprise

ENTREPRENEURSHIP AND SELF EMPLOYMENT

1. Importance of self-employment
2. Entrepreneurship contribution to national development

ENTREPRENEURSHIP OPPORTUNITIES

1. Business opportunities
2. Assessing product demand
3. Matching of skills and resources to changing technology
4. Evaluating of business environment

ENTREPRENEURIAL AWARENESS

1. Types of business finance
2. Contractual agreements
3. Government’s policy on SEE
4. Tendering procedures
5. Problems of starting and operating a small enterprise

ENTREPRENEURIAL MOTIVATION

1. Internal motivation factors
2. Techniques of self-assessment
3. External motivation factors

ENTREPRENEURAL COMPETENCIES

1. Decision making in business
2. Instituting change
3. Coping with competition
4. Risk taking
5. Techniques of time management
6. leadership

ENTERPRISE MANAGEMENT

1. Evaluating business goals
2. Efficiency of resource utilization
3. Finance planning
4. Production management
5. Management of human resource
6. Work study
7. Marketing and public relations
8. Information management
9. Project planning

                                                                                                  MODULE 2

RESEARCH PROJECT 

INTRODUCTION

This course unit is intended to expose trainee to the practical experience in project planning and execution whereby the trainee are expected to plan, gather, review and present project materials and information in accordance with given specifications

GENERAL OBJECTIVES

At the end of this course unit, the trainee should be able to:

1. Understand the scope and challenges involved in carrying out a given project
2. Understand the various methodologies that can be applied in data collection for different types of projects
3. Analyze/ interpret project data and made conclusion based on the subject matter of the project
4. Present project report in an organized manner, taking into consideration quality of materials, neatness and the standard format

INTRODUCTION TO PROJECT WORK

1. Meaning of projects
2. Importance of projects

PROJECT PROPOSAL

1. Selection of a project
2. Project objectives
3. Importance of project proposal
4. Preparation of a project proposal

METHODOLOGIES

1. Sampling
2. Instruments for data collection
3. Data collection procedure

ANALYSIS

1. Methods of data analysis (methods of analyzing data)

PRESENTATION

1. Display of product
2. Project report writing

SYSTEMS ANALYSIS AND DESIGN (160 HOURS)

INTRODUCTION

This module unit is intended to equip the trainee with the knowledge, skills and attitudes to enable him/her to undertake system analysis and design

GENERAL OBJECTIVES

By the end of this module unit, the trainee should be able to:

1. Understand systems concepts
2. Understand systems analysis and design phases
3. Use systems analysis design tools and techniques
4. Apply systems development methodologies
5. Apply information system project management skills

INTRODUCTION TO SYSTEM ANALYSIS AND DESIGN

1. Meaning of system analysis and design

• system
• information system
• information technology

2. Components of an information system

3. Types of information system (TPS,DSS,OAS,GSS,ELS,Others)

4. Roles of information system stakeholders

SYSTEMS THEORY

1. Systems theory
2. Components of a system
3. Types of systems
4. System properties

SYSTEMS DEVELOPMENT LIFE CYCLE (SDLC)

1. Meaning of SDLC
2. SDLC stages

PROBLEM DEFINITION

1. Problem definition
2. Indicators of problems
3. Methods of identifying the problem
4. Contents of TOR

FEASIBILITY STUDY

1. Fact finding methods
2. Feasibility study report
3. Types of feasibility

• economic
• social/ behavioral
• legal
• schedule
• operational

SYSTEM ANALYSIS

1. Meaning and importance of system analysis
2. Methods in system analysis

• structured
• prototyping

3. Tools

• DFD’S
• flowcharts
• data dictionary
• ELH
• others

SYSTEMS DESIGN AND DEVELOPMENT

1. Meaning and importance of system design
2. Qualities of a good design
3. System design models
4. System components tools
5. Design tools
6. System development methodologies
7. System design methods
8. Criteria for choosing a system development methodology

IMPLEMENTATION

1. Meaning and importance of system implementation
2. Procedures of system implementation
3. System implementation techniques
4. Testing techniques
5. Levels of acceptance testing
6. User training

MAINTENANCE AND REVIEW

1. Meaning of system maintenance and review
2. Importance of maintenance
3. Types of system maintenance

SYSTEM DOCUMENTATION

1. Meaning of document
2. Need for documentation
3. Types of documentation

ICT PROJECT MANAGEMENT

1. Meaning and importance of ICT project management
2. ICT project management tools
3. criteria for evaluating ICT projects
4. Signs of a failing ICT project
5. Reasons for ICT project failure
6. Strategies for managing a failing ICT project

EMERGING TRENDS IN SAD

1. Emerging trends in SAD
2. Challenges of emerging trends in SAD

OBJECT ORIENTED PROGRAMMING (90 HOURS)

INTRODUCTION

This module unit is intended to provide the trainee with knowledge and skills to develop programs in Object Oriented Languages

GENERAL OBJECTIVES

By the end of this module unit the trainee should be able to;

1. Understand the various data types, control structures and data structures used in object oriented programming
2. Apply programming skills in C++
3. Develop object oriented programs

INTRODUCTION TO OBJECT ORIENTED PROGRAMMING

1. Object oriented programming
2. Evolution of object oriented programming
3. OOP paradigms
4. Merits and demerits of OOP
5. Examples of object oriented languages
6. Operating systems requirements
7. Object oriented databases(OODBs)

OOP CONCEPTS

1. Concepts associated with OOP
2. Comparison between structured and OOP
3. Reasons for embracing OOP

LANGUAGE STRUCTURES OF OBJECT ORIENTED PROGRAMMING (OOP)

1. Language structure
2. Features of OOP languages
3. File extensions in OOP
4. Data types in OOP
5. Variable declaration
6. Implementation of language structure

ESSENCE OF OBJECTS AND CLASSES

1. Definition of objects and classes in OOP
2. Importance of objects and classes in OOP
3. Implementation of objects and classes

INHERITANCE

1. Meaning and importance
2. Rules of inheritance in OOP
3. Implementation of inheritance

POLYMORPHISM

1. Meaning and importance of polymorphism
2. Encapsulation/ information Hiding
3. Implementation of polymorphism

CONSTRUCTORS AND DESTRUCTORS

1. Meaning of constructors
2. Constructor implementation

OPERATOR OVERLOADING

1. Meaning and importance of operator overloading
2. Implementation of operator overloading

FILE ORGANISATION

1. Meaning and importance of file organization
2. File stream
3. File stream features/ properties
4. File operations

EMERGING TRENDS IN OBJECT ORIENTED PROGRAMMING

1. Emerging trends in OOP
2. Challenges of emerging trends in OOP
3. Coping with challenges of emerging trends in OOP

VISUAL PROGRAMMING (190 HOURS)

INTRODUCTION

This module unit is intended to provide trainee with knowledge and skills to develop programs in visual programming languages

GENERAL OBJECTIVES

By the end of this module unit the trainee should be able to:

1. Apply programming skills in visual basic
2. Understand the various data types, control structures and data structures used in object oriented programming
3. Develop object oriented programs

INTRODUCTION TO VISUAL PROGRAMMING LANGUAGES

1. Visual programming
2. Example of visual programming languages
3. Hardware and software considerations for visual programming

VISUAL ENVIRONMENT

1. Description of visual environment
2. Integrated development environment
3. Visual objects

PROGRAM STRUCTURE

1. Format of a visual program
2. Data types
3. Operators
4. Variables

PROGRAM WRITING

1. Creating an application
2. Compilation
3. Debugging
4. Testing
5. Execution

CONTROL STRUCTURES

1. Types of control structures
2. Implementation of control structures

ERROR HANDLING

1. Types of errors
2. Error handling techniques

SUB-PROGRAMS

1. Meaning of subprograms
2. Types of subprograms
3. Scope of variables

DATA STRUCTURES

1. Data structures
2. Types of data structures
3. Sort techniques
4. Search techniques

LINKING TO DATABASES

1. Database controls
2. Reports

EMERGING TRENDS IN VISUAL PROGRAMMING

1. Emerging trends in visual programming
2. Challenges of emerging trends in visual programming

DATABASE MANAGEMENT SYSTEM (100 HOURS)

INTRODUCTION

This module unit is designed to equip trainee with knowledge, skills and attitude that will enable him/ her understand the construction and management of databases

GENERAL OBJECTIVES

By the end of this module unit, the trainee should be able to:

1. Appreciate database design and development
2. Understand the components of database management systems
3. Develop and manipulate a database

INTRODUCTION TO DATABASE MANAGEMENT SYSTEMS

1. Meaning of DBMS
2. Historical evolution of DBMS
3. Traditional vs.database approaches
4. Components of a database management systems
5. Classification of database system
6. Advantages of DBMS
7. Role of key players in database design and development

DATABASE ORGANIZATION

1. Meaning of database organisation
2. Database organization approaches

• distributed
• centralized
• client/server database

PRINCIPLES AND TECHNIQUES OF DATABASE DESIGN

1. Meaning
2. Database design cycle

RELATIONAL DATABASE SYSTEM

1. Meaning of rational database system
2. Characteristics
3. Relational algebra
4. Relational calculus

ENTITY RELATIONSHIP

1. Meaning of entity relationship
2. Connotations of entity relationship
3. Drawing ERDs

NORMALIZATION

1. Meaning and importance of normalization
2. Normalization rules
3. Performing normalization

QUERYING A DATABASE

1. Meaning of a database query
2. Features
3. Categories of SQL statements
4. Design SQL statements
5. Design SQL queries
6. Use of SQL statements to interrogate a database

 

[sc name=”college 1″]

FUNCTION OF DATABASE MANAGEMENT SYSTEM

1. Meaning
2. Transaction processing
3. Concurrency controls
4. Database recovery
5. Database security and authorization

EMERGING TRENDS

1. Emerging trends in database management system
2. Challenges of emerging trends in database management system
3. Coping with emerging trends in database management system

COMPUTER APPLICATION II (120 HOURS)

INTRODUCTION

This module unit is designed to equip the trainee with knowledge,skills and attitude that will enable him/her use specialised computer application software

GENERAL OBJECTIVES

By the end of this module unit, the trainee should be able to:

1. Use financial application software
2. Use project management software
3. Use computer aided design
4. Appreciate the use of geographical information systems
5. Appreciate the use of artificial intelligence

FINANCIAL APPLICATIONS

1. Meaning and importance of financial application
2. Types of financial applications
3. Features of financial applications
4. Fundamentals of accounting
5. Accounting and book keeping
6. Accounting ledgers
7. Practical applications

COMPUTER AIDED DESIGN (CAD)

1. Meaning and importance of CAD
2. Fundamentals of Technical Drawing
3. Features of CAD software
4. Screen layout
5. Commands used
6. Configuration of CAD
7. Practical applications

GEOGRAPHICAL INFORMATION SYSTEM (GIS)

1. Meaning and importance of  GIS
2. Components of GIS
3. Application areas
4. others

ARTIFICIAL INTELLIGENCE

1. Meaning and importance of artificial intelligence
2. Categories of artificial intelligence
3. Benefits and challenges of artificial intelligence
4. Emerging trends in artificial intelligence

                                                                                       MODULE 3

DATA COMMUNICATION AND NETWORKING (150 HOURS)

INTRODUCTION

This module unit is designed to equip the trainee with knowledge, skills and attitude that will enable him/her install and manage data communication networks

GENERAL OBJECTIVES

By the end of this module unit, the trainee should be able to:

1. Understand the concepts of data communications networks
2. Understand the use and application of different transmission media
3. Understand the various data transmission techniques
4. Appreciate the need for international standards
5. Use switching techniques in networking
6. Manage data communication networks
7. Appreciate the use and application of internet
8. Evaluate the performance of data communication network

INTRODUCTION TO COMPUTER NETWORKS

1. Meaning of computer network
2. Component types of computer networks
3. Types of computer networks
4. Role of computer networks
5. Network topologies
6. Categories of computer networks

NETWORK MEDIA

1. Meaning and importance of network media
2. Types of transmission media
3. Electrical properties of matter
4. Types of wireless network and topologies
5. Advantages and disadvantages of different media and their application

DATA COMMUNICATION

1. Meaning of data communication
2. Principles of data communication
3. Encoding techniques in data communication
4. Networking models and their importance
5. OSI module and different layers
6. Standards for internet networking component
7. As they map to OSI model
8. TCP model and functions
9. Comparison of OSI and TCP models

NETWORK CONNECTIONS AND PROTOCALS

1. Transport protocols
2. Others
3. Network connectivity

LOCAL AREA NETWORK

1. Meaning of LAN
2. LAN protocols and transmission methods
3. Media access methods

WIDE AREA NETWORK

1. Meaning of WAN
2. WAN protocols

ETHERNET TECHNOLOGY

1. Meaning of ethernet technology
2. Ethernet standards

NETWORK TROUBLE SHOOTING

1. Meaning and importance of trouble shooting
2. Importance of network trouble shooting
3. Methods of trouble shooting

NETWORK SECURITY

1. Meaning and importance of network security
2. Network security
3. Security techniques
4. Security threats and other network vulnerabilities

NETWORK  DESIGNS

1. Meaning of network designs
2. Computer development
3. Life cycle
4. Hardware and software
5. Requirement  selective
6. Set-up connection and test
7. Trouble shooting

TCP/IP CONCEPTS

1. Meaning of concepts
2. Types of data flow
3. Use of IP addresses
4. Testing of TCP/ IP
5. Configuration

COMMUNICATION SOFTWARE

1. Meaning of communication software
2. Types of network software

INTERNET

1. Meaning and importance of internet
2. Computer configuration for internet usefile transfer
3. Browsing internet

EMERGING TRENDS

1. Emerging trends in networking
2. Challenges of emerging trends
3. Coping with challenges of emerging trends in networking

MANAGEMENT INFORMATION SYSTEMS(100 HOURS)

INTRODUCTION

This module unit is intended to equip the trainee with the necessary knowledge, skills and attitude  that will enable him/ her to manage information systems

GENERAL OBJECTIVES

By the end of this module unit, the trainee should be able to;

1. Understand the role of information systems in management
2. Appreciate the role of information in an organization
3. Understand the need for managing information system resources
4. Understand the uses of IS in organizations
5. Appreciate information system ethics

INTRODUCTION TO MANAGEMENT INFORMATION SYSTEMS

1. Meaning of management information systems
2. Components of a management information system
3. Role of information in an organization
4. System classification
5. Qualities of good information system
6. Social-technical view of information systems

USE OF INFORMATION SYSTEM IN MANAGEMENT

1. Meaning and importance of management
2. Use of IS in management
3. Use of IS in management decision making
4. Types of decisions
5. Decision making cycle

MANAGEMENT OF INFORMATION SYSTEMS RESOURCES

1. Information resource management concept
2. Importance of managing information resources
3. Information system resources
4. Information society

INFORMATION SYSTEM PLANNING

1. Meaning and importance of information systems planning
2. Information systems planning process
3. Reasons for aligning information systems plan to organisation plan

INFORMATION SYSTEM PROJECT MANAGEMENT

1. Meaning  and importance of information system project management
2. Information system project management techniques
3. Sign of a failing information system project
4. Causes for information system project failure
5. Control measure and techniques of rescuing a failing information system project

INFORMATION SYSTEMS ACQUISITION

1. Information systems acquisition process
2. Factors that influence information system acquisition
3. Factors that influence the choice of information system acquisition method
4. Criteria for information system acquisition

THE ROLE OF INFORMATION SYSTEM IN ORGANISATION

1. The applications of IS in an organisation
2. Application of IS for competitive advantages in an organisation

INFORMATION SYSTEMS MAINTENANCE

1. Meaning and importance of information systems and maintenance
2. Techniques of maintaining an information system

THE ROLE OF ICT IN AN ORGANIZATIONAL CHANGE

1. Meaning of organizational change
2. Considerations for implementing a change programme in an organization
3. Impact of IS as an agent of organizational change

• automation
• rationalization
• business process
• re-engineering

INFORMATION SYSTEM ETHICS

1. Ethical issues in information systems
2. Guidelines for responsible use of information systems
3. Computer crime
4. Control measures for computer crime

EMERGING TRENDS IN MANAGEMENT INFORMATION SYSTEM

1. Emerging trends in MIS
2. Challenges of emerging trends
3. Coping with challenges in MIS

PRINCIPLES AND PRACTICE OF MANAGEMENT (144 hours)

INTRODUCTION

This course unit is aimed at equipping the trainee with knowledge and skills that will enable him/ her to perform management functions in an organisation

GENERAL OBJECTIVES

By the end of this course unit, the trainee should be able to:

1. explain and apply the management function in an organisation
2. assist managers at various levels in an organisation
3. appreciate the role played by management in development
4. cultivate a sense of entrepreneurship
5. appreciate the importance of purchasing and supplies management in information technology
6. undertake marketing activities in information technology sector

INTRODUCTION OF MANAGEMENT

1. Definition of management
2. Early contribution to management
3. The classical thought of management
4. The human relations school of thought
5. The modern thought to management
6. The environment thought of management
7. Managerial services as overview

PLANNING FUNCTION

1. Nature and purpose of planning
2. Types of plans
3. Principles of planning
4. Difficulties in planning

ORGANIZATION FUNCTION

1. Structure and organisational design
2. Departmentation
3. Authority relationship
4. Decentralization of authority
5. Decision making

STAFFING FUNCTION

1. Definition of staffing
2. Manpower planning
3. Job design
4. Job analysis
5. Job evaluation
6. Recruitment
7. Selection
8. Induction
9. Retirement, redundancies and redeployment, training and retraining
10. Personnel records, wages and redeployment, training and re-training
11. Personnel records, wages and salaries industrial relations

DIRECTING/ LEADING FUNCTION

1. The human factors in directing/ leading
2. Motivation
3. Nature of leading/ directing
4. Co-ordination

CONTROLLING FUNCTION

1. Nature and characteristics of control
2. Areas of control
3. Non-budgetary controls
4. Budgetary controls

PERSONNEL MANAGEMENT

1. The scope of personnel management
2. Staffing
3. Wages and salaries administration
4. Employee development
5. Industrial relations

PURCHASING AND SUPPLIES MANAGEMENT

1. Overview of purchasing and supplies management
2. Computer hard and software purchasing processes
3. Ethical standards in purchasing computer hardware and software
4. Negotiations and determination of terms of purchase
5. Stock and inventory control information
6. Technology industry

MARKETING MANAGEMENT

1. Overview of marketing and marketing management
2. Marketing mix
3. Marketing research
4. After sales service
5. Consumer behaviour
6. Marketing planning
7. Marketing control

QUANTITATIVE METHODS

INTRODUCTION

This course unit is intended to provide the trainee with the necessary computing skills to enable him/ her to use numerical methods to quantify and process data.

GENERAL OBJECTIVES

By the end of this course unit, the trainee should be able to:

1. Use forecasting tools to analyse systems
2. Apply approximation methods in systems design
3. Appreciate financial, network planning and simulation techniques in systems design

DATA COLLECTION AND PRESENTATION

1. Basic for data collection
2. Data classification
3. Data tabulation
4. Diagrammatic and graphical presentation

MEASURES OF CENTRAL TENDENCY

1. Definition of measures
2. Properties
3. Calculation and interpretation
4. Data presentation

MEASURE OF DISPERSION

1. Characteristics
2. Relative and absolute measures
3. Calculation of measures

CORRELATION AND REGRESSION

1. Scatter diagram
2. Correlation
3. Correlation coefficient
4. Coefficient of determination
5. Linear regression models

TIME SERIES ANALYSIS

1. Components of time series
2. Time series models
3. Measurement methods
4. Application of time series

INDEX NUMBERS

1. Definition of index numbers
2. Types of construction problems
3. Application of index numbers
4. Limitations

PROBABILITY DISTRIBUTION

1. Concepts of discrete and continuous variables
2. Discrete distributions
3. Continuous distribution

NETWORK PLANNING

1. Introduction
2. Network construction
3. Critical construction
4. Applications

LINEAR PROGRAMMING (LP)

1. Models
2. Types of models
3. LP models requirement
4. LP models
5. Solutions methods

ESTIMATION AND TEST OF HYPOTHESIS

1. Estimation
2. Types of estimators
3. Sampling distributions
4. Confidence interval and interpretation
5. Hypothesis
6. Types of errors
7. Test statistics and the test

THE ORYDECISION

1. Mathematical expectation
2. Expectation and decision

SIMULATION

1. Definition
2. Techniques of simulation

SAMPLING

1. Introduction
2. Sampling and census
3. Types of sampling and limitations

FINANCIAL MATHEMATICS

1. Simple and compound interest
2. Sinking fund
3. Annuities and perpetuities
4. cash flow generation
5. Mortgages
6. Project appraisal methods
7. Inventory control systems
8. Economic order quantity models
9. Safety stock and re-order level.

INTERNET BASED PROGRAMMING -(110 HOURS)

INTRODUCTION

This module unit is intended to provide the trainee with knowledge and skills to develop internet based programs

GENERAL OBJECTIVES

By the end of this module unit the trainee should be able to:-

1. Appreciate the use of various web development languages
2. Acquire development skills in internet based programs
3. Use the various web authoring tools
4. Develop a web site

INTRODUCTION TO INTERNET BASED PROGRAMMING

1. Internet based programming
2. World wide web
3. Role of web site organizations

WEB PROGRAMMING

1. Web programming
2. Approaches to web programming
3. Web programming languages
4. Web programming interfaces
5. Criteria for choosing a web programming language

HTML CODING

1. HTML
2. HTML structure
3. HTML Tags
4. Insert objects in HTML document
5. HTML Hyperlinks
6. Tables
7. Frames
8. Forms

WEB AUTHORING AND DESIGN TOOLS

1. Web design tool
2. Features of web design tools
3. Web authoring, design formats and protocols
4. Characteristics of a good design
5. Design a website

JAVA SCRIPT AND ACTIVE SERVER PAGES

1. Describe Java Script and ASP
2. Data input procedures
3. Data output procedures

WEB SECURITY

1. Web security
2. Web security issues
3. Challenges of web security
4. Control measures

EMERGING TRENDS IN INTERNET BASED PROGRAMMING

1. Emerging trends in internet-based programming
2. Challenges of emerging trends in internet based programming
3. Cope with the challenges of emerging trends in internet based programming

BUSINESS PLAN

INTRODUCTION

This module unit is designed to equip the equip the trainee with knowledge, skills and attitudes to enable him/ her prepare a business plan

GENERAL OBJECTIVES

By the end of this module unit, the trainee should be able to:

1. Understand the background of intended business
2. Understand the market environment of the business
3. Understand organization and management plan
4. Appreciate operational plan
5. Prepare financial projections
6. Prepare a business plan

INTRODUCTION TO BUSINESS PLANNING

1. Meaning of business plan
2. Purpose of a business plan
3. Features of a business plan
4. Guidelines for developing an effective business plan

BUSINESS DESCRIPTION

1. Business name
2. Business location and address
3. Form of ownership
4. Type of business
5. Products/ services
6. Justification of the opportunity
7. The industry
8. Business goals and objectives
9. Entry and growth strategy
10. SWOT analysis

MARKETING PLAN

1. Customer identification
2. Competitor analysis
3. Market share
4. Promotion and advertising
5. Pricing strategy
6. Sales tactics
7. Sales target
8. Distribution strategy
9. Customer service

ORGANISATION AND MANAGEMENT PLAN

1. Organisation structure
2. Management team
3. Recruitment, training and promotion
4. Remuneration and incentives
5. Licenses, permits and other requirements
6. Supporting services

OPERATIONAL/ PRODUCTION PLAN

1. Production facilities and capacity utilization
2. Production and operation strategy
3. Production process
4. Regulations affecting operations
5. Operational timetable/ production schedule

FINANCIAL PLAN

1. Pre-operations cost
2. Working capital
3. Cash flow projections
4. Pro-forma income statements
5. Pro-forma balance sheets
6. Break even analysis
7. Profitability rations
8. Desired financing
9. Proposed capitalization
10. Potential risks

PRESENTATION

1. Business plan writing
2. Presentation of the business plan

EMERGING TRENDS AND ISSUES

1. Emerging issues in business planning
2. Strategies in dealing with emerging issues