Isams_ADV.DIP_PGD

ISAMS_ ADV.DIP_PGD_CATALOG PAGE.

OYENEGBIN | FAVORITE_LINKS | Isams | Isams_Diploma_ Sylabus | Isams_ADV.DIP_PGD | UNILAG_DIP_STUDENTS | COURSE_CONTENT1 | COURSE_CONTENT2 | COURSE_CONTENT3 | CIFMAN | STDENTS' PHOTOGRAPHS | LECTURERS'_Photo_Page | P.G.D_LAUTECH_Photo_Page | MY CONTACTS | GUEST BOOK
  
    

OTHER ISAMS COURSEWARE.


ADVANCED DIPLOMA Level (2 Semesters)

1.ADVANCED DIPLOMA IN COMPUTER SCIENCE WITH MANAGEMENT (ADCSM)

HARMATTAN SEMESTER

ADCSM 211 ADVANCED C++ ANDVISUALBASIC

ADCSM 213 DIGITAL COMPUTER COMM. & COMPUTER MGT STUDIES

ADCSM 215 COMPUTER ELEC.& H-WARE MAINT./REPAIRS

ADCSM 217 BUSINESS FINANCE & ANALYSIS FOR BUSINESS DECISION & MODELLING

ADCSM 219 ENTERPRENEURAL DEV. & BUSINESS POLICY

ADCSM 221 MGT & ORGAN. THEORY

RAIN SEMESTER

ADCSM 212 SOFTWARE ENGINEERING & SYSTEMS PROGRAMMING

ADCSM 214 REL. DATABASE, DATA MODELLING & SQL
ADCSM 216 MANAGERIAL ECONOMICS & SPSSO
ADCSM 218 ORGAN. BEHAVIOUR & HUMAN RELATIONS
ADCSM 220 DATA STRUC. & DATABASE ARCHI./IMPLEMENTATIONS
ADCSM 221 RESEARCH PROJECT
ADCSM 211 ADVANCED C++ AND VISUAL BASIC
Object-Oriented programming with C++; Encapsulation, Inheritance, Polymorphism; Overloading, Modelling the real world with classes; Building classes a graphic example; Declaring objects; Member functions, Virtual functions; Dynamic objects.
ADCSM 213 DIGITAL COMPUTER COMMUNICATION ADVANCED DIPLOMA Level 2 Semesters

1.ADVANCED DIPLOMA IN COMPUTER SCIENCE WITH MANAGEMENT (ADCSM)HARMATTAN SEMESTER

ADCSM 211 ADVANCED C++ AND VISUAL BASIC
ADCSM 213 DIGITAL COMPUTER COMM. & COMPUTER MGT STUDIES
ADCSM 215 COMPUTER ELEC. & H-WARE MAINT./REPAIRS
ADCSM 217 BUSINESS FINANCE & ANALYSIS FOR BUSINESS DECISION & MODELLING
ADCSM 219 ENTERPRENEURAL DEV. & BUSINESS POLICY
ADCSM 221 MGT & ORGAN. THEORY RAIN SEMESTER
ADCSM 212 SOFTWARE ENGINEERING & SYSTEMS PROGRAMMING

ADCSM 214 REL. DATABASE, DATA MODELLING & SQL
ADCSM 216 MANAGERIAL ECONOMICS & SPSSO
ADCSM 218 ORGAN. BEHAVIOUR & HUMAN RELATIONS
ADCSM 220 DATA STRUC. & DATABASE ARCHI./IMPLEMENTATIONS

ADCSM 222 RESEARCH PROJECT

ADCSM 214 ADVANCED C++ AND VISUAL BASIC
Object-Oriented programming with C++; Encapsulation, Inheritance, Polymorphism; Overloading, Modelling the real world with classes; Building classes a graphic example; Declaring objects; Member functions, Virtual functions; Dynamic objects.

ADCSM 213 DIGITAL COMPUTER COMMUNICATION & COMPUTER MANAGEMENT STUDIES

A.) DIGITAL COMPUTER COMMUNICATION

1.MODULATION TECHNIQUES: Describe the different types of modulation amplitudes, frequency and phase.
2.MULTIPLEXING: Define a multiplexer. Explain frequency division multiplexing, time division and statistical multiplexing. Illustrate a multiplexer with diagrams. Calculate the cost effectiveness of a multiplexer. Define a concentrator. Differentiate between a Multiplexer and a Concentrator.
3.TRANSMISSION MODES: Explain the difference between simplex, half-duplex and full duplex transmission. Define synchronous and asynchronous transmissions.
4.TYPES OF MEDIA: Explain various transmission media in data communication links: switched and leased telephone lines, twisted wires, coaxial, radio satellite, optical fibre cable. Compare and contrast the link media listed above.
5.LINE ORGANIZATION: Define line organizations. Define point-to-point, multi-point and multi-drop organizations. Explain the difference between the organizations listed above
6. COMMUNICATION SOFTWARE: Define communication software. Explain the functions of the various communication software (shell, NOS, application programme, performance software).
7.COMMUNICATION PROTOCOLS: Define a communication protocol. State the functions of communication protocol. Differentiate between various transmission protocols (Asynchronous and Synchronous).Describe some specific transmission protocols binary synchronous control, synchronous data link control (SDLC),High data link control (HDLC) X 25, etc.
8.NETWORK: Define a network. Explain different types of network organizations: star, loop, ring, bus, mesh, etc. Know different types of network LAN, WAN, MAN. Know management of system in network environment various gates, etc. Explain
specific existing network architecture SNA, Digital network architecture (DNA), JANET, JUNET, ASCNET, MAILNET, INTERNET.
B. COMPUTER MANAGEMENT STUDIES
a.ORGANIZATIONAL STRUCTURE OF DP DEPARTMENT: Describe the organizational structure of a data processing department. Describe the functions of the various personnelin a data processing department.

b.PROCEDURES OF COMPUTER OPERATIONS: Describe the principles and procedure of operating the computer system (the fix up, start-up, and shutdown). Identify the functions of the constituents of thecommands. Describe the functions and operations of a master console.Describe initialization & formatting of storage devices: disks/tapes/diskettes, etc\
c.TYPES OF DATA PREPARATION METHODS: Apply the techniques of capturing data-off-line modes. Perform data verification. Explain data transmission methods and Identify the items of equipment used in the above-listed methods.
d.SECURITY OF THE ENVIRONMENT: Explain the
control techniques. Identify and explain
standard operations procedures of computer installations. Explain the need for computers systems auditing.
e.SAFETY PROCEDURES: Explain prevailing safety regulations in the computer installation. Describe method of preventing hazards (fire, flooding, sabotage, etc).Describe file security methods and explain the need for file security in computer installations. Explain user passwords and user names. Describe the need for libraries computer installations. Describe a model library structure. Explain the need for user identification procedure within an installation.


ADCSM 215 COMPUTER ELECTRONICS & HARDWARE MAINTENANCE & REPAIRS
A: BASIC COMPUTER ELECTRONICS Constructional Features
1.1 Define a pulse.
1.2 Explain pulse shaping.
1.3 Define rise time, fall time, pulse circuits, duration, overshoot, and undershoot.
1.4 Explain the structural action of multi-vibration: monostable, stable.
1.5 Explain the constructional features of the R-S and J-K flip-flops.
1.6 Apply the R-S and J-K flip-flops to solve problems.
1.7 Explain the operations of shift registers. Integrated Circuit Devices
2.1 Describe the application of I.C in the field of digital system design.
2.2 Explain the characteristics and implications of using ATL, TTL, DTL, ECL, and HTL
gates.
2.3 Apply different transistor logic gates to solve problems.
Digital IC System
3.1 Explain the constructional features of binary and decode counter: straight binary shift even, shift odd, sign and preset.
3.2 Describe the configurations of the counters in 3 above.
Small Scale Integrated Circuits (SSIC)
4.1 Synthesize a 4-bit adder.
4.2 Synthesize a NBCD adder.
4.3 Synthesize code-converting circuits, integrated (SSI) circuits, e.g. BCD gray.
4.4 Design a 4-decade excess-3 adder code converting circuits.
4.5 Solve problem of combinational circuit designs.
Elementary Digital Computer Architecture
5.1 Explain the various WORD formats.
5.2 Explain the Neumann configuration of digital computers.
5.3 Explain the arithmetic logic unit (ALU) and its basic registers.
5.4 Explain the basic registers of the timing and control unit.
5.5 Explain the basic registers of the I/O units.
5.6 Explain the basic registers of memory control units
5.7 Describe the Four, three and two address machines.
5.8 Describe the single address machines.
5.9 Describe the various methods of addressing.
B: BASIC HARDWARE MAINTENANCE
Basic Electric Current Theory
1.1 Describe voltage and current sources.
1.2 State Kirchoff law.
1.3 Explain the uses of transistors, capacitors, and resistors.
Logic Circuits and Analysis
2.1 State the laws of Boolean algebra.
2.2 Define a Boolean expression.
2.3 Construct truth tables.
2.4 Explain the use of the laws in 2.1 above in minimization of Boolean expression.
2.5 Describe the characteristics of logic gates.
2.6 Describe combinational circuits design.
2.7 Describe Kanmaugh map.Maintenance Tools
3.1 Identify maintenance tools, electronic millimeter, oscilloscope, tester, etc.
3.2 Describe the use of the tools in 3.1 above.
3.3 Apply the tools in 3.1 above for maintenance purpose.

ADCSM 217 BUSINESS FINANCE & ANALYSIS FOR BUSINESS DECISION & MODELLING

1.0 ANALYSIS & CAPITAL INVESTMENT
1.1 Overview of firm and finance; Nature of finance; Risk and finance.
1.2 Objectives of the firm; Source of Business frequency.
1.3 Introduction to financial market; Nature of financial market; Money market; Capital market.
The regulator of stock market.
1.4 The concept of time value of money; Simple and compound interest; Future value of lump sum; Future value of current annuity; Sure way for capital amortization.
1.5 Capital Investment; The investment decision process; Accounting rate of return (ARR); Payback period (PBP); Net present value (NPV); Internal rate of return (IRR); Profitability index/fund.
2.0 ANALYSIS FOR BUSINESS DECISION
2.1 Introduction; What is decision? Rationality in decision-making; Rationality paradox; Bounded rationality.
2.2 Elements of Decision making; Decision situations: certainty, uncertainty, risk.
2.3 Decision Tree and Secretary problem; Feedback analysis.
3.0 BUSINESS MODELS
3.1 Define and understand the definition of business models.
3.2 Describe different types of model: physical, mathematical, analogue and simulation.
3.3 Recognise a problem where a business model could be applied to assist in the solution
of that problem.
3.4 Outline the potential limitations of a business model in a given situation.
3.5 Appreciate that decision-making is not confined to the use of specific results of applying modelling techniques.
4.0 DECISIONS AND MODELS
4.1 Construct a decision tree from a limited set of data and carry out a forward and backward pass.
4.2 Derive a suitable course of action as a result of the analysis carried out in 2.1.
5.0 FORECASTING
5.1 Identify the various forecasting models and derive a forecast value from limited range of
data.
5.2 Plot calculated result using linear,log-linear and log-log graph papers.
6.0 SIMULATION
6.1 Definition; Concrete examples; Advantages and disadvantages; Mote Carlo simulation; Worked example.

7.0 JOB SEQUENCING
7.1 Definition; Procedure for solving sequencing problems; Types of sequencing problems and
priority rules.
8.0 INVENTORY APPRIASAL
8.1 Describe the Economic Order Quantity (EOQ) from a limited set of data.
8.2 Derive the EOQ from a formula supplied.
9.0 LINEAR PROGRAMMING
9.1 Define the differences between the graphical and simplex methods of linear programming (LP).
9.2 Derive the Objective function and Constraint function for Minimization and Maximization problems.
9.3 Derive solutions to graphical LP problems.
9.4 Create and describe the elements of a Simplex LP tableau.
9.5 Interpret the final Simplex LP tableau and use it to solve a business problem.
9.6 Identify slack variables and shadow or dual values.
9.7 Use the primal-dual relationship for the solution of appropriate problems.
10.0 NETWORK ANALYSIS
10.1 Create an activity-on arrow network from a limited set of data, analyse the network in terms of earliest and latest activity time and define the critical path(s).
10.2 Carry out an analysis of a Gantt Chart; create a resource profile to meet a resource constraint.
10.3 Carry out a cost analysis of a small network by using cost slopes.
10.3 Compare and contrast activity-on-arrow and activity-on-node networks.
11.0 QUEUING THEORY
11.1 Identify the elements involved in a simple queuing system.
11.2 Derive various values associated with a simple queuing system.
12.0 REPLACEMENT ANALYSIS
12.1 Derive workable solution to problems caused by the need to replace components but subject to failure or deterioration.
13.0 APPLICATIONS
13.1 Identify suitable modeling techniques to non-complex problem solution, appraising them for feasibility.
13.2 Describe managerial problems and benefits of applying a variety of modeling techniques to business problems.
14.0 SOFTWARE PACKAGES
14.1 Identify possible computer software application packages that could be used to carry out the necessary calculations for the techniques and models identified in 2.1 2.9.
15.0 PROBLEM DEFINITION
15.1 Identify for a given scenario, the data necessary to create a business model.
16.0 SOFTWARE COST ESTIMATION
16.1 Explain the difficulties of software cost estimation.
16.2 Apply appropriate models identity in 2.1 2.9 to software estimation.
16.3 Apply appropriation models identified in 2.1 2.9 to software project planning.

ADCSM 219 ENTERPRENEURAL DEVELOPMENT & BUSINESS
POLICY

1.ENTERPRENEURIAL DEVELOPMENT
Explain the concepts of entrepreneur and entrepreneurial development. Who is n entrepreneur? State and discuss the personal characters and behavioural traits of entrepreneurs. What are the Qualities of a good entrepreneur? Examine the Financial aspects of entrepreneurship. Discuss the Nigeria environment and the problems of entrepreneurs in the country. Examine the Nigerian legislations regulating entrepreneur activities. Explain the legal procedures (Business registration, etc) and strategic preparations (feasibility study & report, etc) required for an entrepreneur to commence business operations.

2. BUSINESS POLICY
Define the concepts of business and business policy. Explain the nature and dynamics of business and business policy. Cite case studies off general management and the coordination of the functions of management/finance. Explain advanced production methods and policies. Discuss the Decision theory.Explain the classical school, creative brain-storming and technological forecasting. Explain the concepts of Certainty and uncertainty and the use of models. Discuss the concept of achievement and the criteria for evaluating it.

ADCSM 221 MANAGEMENT & ORGANISATION THEORY
Management introduction; nature and evolution of management (schools of) thought, theories and principles. Examine the universally accepted functions of management; planning, organizing, staffing, directing and controlling, policy, procedure and programme of formulation. Organization: Nature, purpose, and principle of organization. Organization structure, concepts of centralization, decentralization, divisionalization, and departmentation. Organizational culture; and organizational development.


RAIN SEMESTER

ADCSM 212 SOFTWARE ENGINEERING & SYSTEMS PROGRAMMING
ADCSM 214 RELATIONAL DATABASE, DATA MODELLING & SQL
ADCSM 216 MANAGERIAL ECONOMICS & SPSSO
ADCSM 218 ORGANISATIONAL BEHAVIOUR & HUMAN RELATIONS
ADCSM 220 DATA STRUCTURE & DATABASE ARCITECTURES/IMPLEMENTATIONS
ADCSM 221 RESEARCH PROJECT.

ADCSM 212 SOFTWARE ENGINEERING & SYSTEMS PROGRAMMING

GOAL(S) To expose the students to the techniques and tools for designing and building Systems as well as ways in which the performance of a system can be evaluated.
A. SOFTWARE ENGINEERING
1. CREATION METHODOLOGIES
Design in other areas, Construction steps oriented towards software; Coherent creation methodologies.
2. TOOLS AND TECHNIQUES FOR SYSTEM CONSTRUCTION
System Implementation Language; Structure Programming, Modular Programming
Programming tools and environment; Documentation.
3. PERFORMANCE MEASUREMENT AND EVALUATION.
Software characteristics; Software reliability versus software efficiency. Types of Maintenance; Maintenance of Structured and Unstructured programs.
B. SYSTEM PROGRAMMING
Compiler, Assembler, Interpreter Differences: Define Compiler, Assembler & Interpreter. Compare and contrast Compiler, Assembler and Interpreter. Compilation Process: Explain the compilation process: Lexical analysis, syntax analysis, code preparation, code generation, table of information and error routine.Grammar and Language: Define Grammar and Language; define an alphabet;define string; define a phase; Write production or rewriting rules.Construct syntax trees for sentences.
Functions of a Scanner: Explain in-scanning process. Break up a simple source
code into tokens (variables, constants,labels literals, operands and delimiters).
Describe internal forms of tokens. Recognise tokens using state diagrams.
Function of Recognizer: Describe parsing techniques. Parse the output of the Scanner using syntax trees and polish notation. Parse sentences applying Top-Down and Bottom-Up methods. Recognize basic constructs such as triples, indirect Triples
and quadruples.
Storage Allocation: Explain storage allocation techniques. Draw data area display
for operands. Calculate Storage requirements for elementary data items arrays and strings.
Error Routine: Explain error routine. Write scanning error routine. Write Semantic error routine.
Code Generation: Explain code generation.Generate code for simple arithmetic expression: triples, indirect triples and quadruples.

ADCSM 214 RELATIONAL DATABASE, DATA MODELLING & SQL
RELATIONAL DATABASE & DATA MODELLING

TRADITIONAL DATABASE SYSTEMS Define a database and database management system; Describe Traditional database models [Paper & Biro; Hierarchical and Network (CODASYL) systems]; Explain the advantages and disadvantages of these systems. Discuss the need for Relational Database Model.

THE RELATIONAL MODEL: describe Relational Database model and the work of Dr. Codd. Highlight the inadequacies of the original model and explain the concept of EER. Describe the major advantages of Relational Model over traditional models; disadvantages of relational database model. Describe the necessary rules/constraints of the Relational Model - Integrity rules. Describe the manipulation of relational model relational algebra operations and operators.

DATA MODELLING Describe the Basic Structure and the Relational Model: the Single Entity - Modelling single entity database; Creating a single table database; Querying a single table database. Relationship Describe ONE-TO-ONE, ONE-TO-MANY and MANY-TO-MUCH Relationships. Creating and querying a relational database with a many-to-many relationship. Relationship descriptors as identifiers, dependent and intersection, entity-tree structure.
Building Blocks (fundamental concepts) Entity, Attributes, Tuples, Relationship, Identifier; Entity types Independent, Dependent, Intersection, Aggregate, Subordinate. Data Model quality criteria (well-formed data model and high fidelity image); Quality improvement (detail and context with examples). The concept of Normalization functional dependency and first to fifth normal forms.
SQL
Introduction; Data definition, keys, Indexes, Notation. Relational Algebra operators and their effects (SELECT JOIN, PROJECT, UNION, DIVIDE, ETC.).
Create Table Column definition, Primary Key definition, Referential Constraint definition.
Data types (smallint and integer, float, decimal cha and varchar, time and date, graphic and blob.
ALTER TABLE statement; DROP TABLE statement; CREATE VIEW STATEMENT; CREADE INDEX AND DROP INDEX Statements Data Manipulation. Qualifying column names, select statement, product, join. INSERT and UPDATE COMMAND; Delete statement.
EMBEDDED WS=SQL using with COBOL and programming languages.

ADCSM 216 MANAGERIAL ECONOMICS & STATISTICAL PACKAGE
FOR SOCIAL SCIENCES (SPSSO)

A. MANAGERIAL ECONOMICS
Scope of managerial economics, definitions, micro-economic theory and business decision making. Business objectives. Profit as an objective. Investment decisions. Techniques of investment appraisal, cost-benefit analysis. Issues relating to pricing policy.

B. STATISTICAL PACKAGE FOR SOCIAL SCIENCES (SPSSO)
1. SPSSO at a glance.
2. Collection of Data. Distributed Analysis. Data Management.
Working with data files. Using the Data Editor.
3. Statistical Analysis.
4. Reports.
5. Descriptive statistics. Compare means. Correlate. Regression Analysis.
6. Data reduction.
7. Non parametric tests.
8. Graphical Analysis.


ADCSM 218 ORGANISATIONAL BEHAVIOUR & HUMAN
RELATIONS

Historical development: human relation's movement, theory X and theory Y (cf. theory Z), management approaches, classical and modern organization theories; human motivation; personality development theory; group dynamics and informal organization. Leadership and the dynamics of power; the dynamics of behaviour, frustration, and conflict. The impact of change.


ADCSM 220 DATA STRUCTURE & DATABASE ARCHITECTURES/
IMPLEMENTATIONS

A. DATA STRUCTURE & DATABASE MANAGEMENT SYSTEMS
1. CONCEPT OF DATA STRUCTURE
Define data structure; Data attributes, name value and range, units for identifying
Tool for studying data. Ordered list. Simple linked lists. String structure.
2. GENERAL CONCEPT OF DATABASES
Database as a relational database package; Entering Database from DOS; Two modes of using Database Assist and Command Assist Pull-down menu; Types of files in Database (database) (. dbf), catalogue (.cat), Index (.ndx) command and procedure (.prg), format (.fmt), label (.lbl), memory (.mem), query (.qry), View (.vue), report (.frm), text (.txt). Emphasis on .dbf, .frm and .lbl files; structure; Entering data; Editing data; Saving/Quitting; File organization Sort/Index; Creating label files; Creating Editing a report file; Printing a report file; Introduction to elementary database programming.
B. DATA STRUCTURE AND STORAGE
1. DATA STRUCTURE AND STORAGE DEVICES.
2. DATA STORAGE AND DATA PROCESSING ARCHITECTURES
Introduction, Client/server, Distributed database, Hybrid Architecture.
3. HIERARCHICAL AND NETWORK MODELS
Introduction, the Hierarchical model, the Network (CODASYL) model; Data Extraction.
4. THE RELATIONAL MODEL
Integrity rules, Manipulation relational algebra operations and operators.
5. OBJECT-ORIENTED DBMS
Introduction, OO Concepts. Why OO? Objects and information systems modeling; persistent objects; OO DBMS.

ADCSM 221 RESEARCH PROJECT
(Refer to Diploma in Computer with Management)

CERTIFICATE IN COMPUTER APPLICATIONS MS-DOS/WINDOWS, MS-DOS
General Introduction
- Classification of Computer: micro, mini and mainframe
- Computer: 3 major components- INPUT, OUTPUT & PROCESSOR (CPU)
- The Operating System as the overal manager of all prograams in computer.
- Hardware and Software
- Meaning of C:/> prompt and the A:/> prompt
- Booting or bootstrapping
- File name, file extensions, the default drive, MS-S DOS Commands
- Internal Commands
- Dir(ectory) with parameters (/p,/w), c/s, date, time, delete, rename, copy, tree, types, erase
- External Commands
- Format, diskcopy, backup, restore, path, (AUTOEXEC.BAT)
Directories
- What is a directory
- Creating to a directory
- Changing to a directory
- Removing a directorry

WINDOWS
- Introduction to Windows 98
- Starting Windows 98
- Group and Items Concept
- Folder and Files Concepts
- Desktop Management
- Icons and Windows (Creating Shortcuts)
- Basic Settings
- Running Applications
- Switching between Applications- Multitasking
- File Management
- Disk Management
- Installation and Removal of Application
- Printing
- Logoff Procedure
- Locating files and Folders

BASIC PROGRAMMING

- Full meaning of BASIC
- General Programming Concepts
- Structure of the BASIC program
- Basic character sets, Constants, String Constants, Numeric Constants,
Variables
- Arithmetic Operations
- LET Statement
- INPUT, READ
- PRINT, LPRINT
- RUN Statement
- LIST, LLIST
- Arrays (Single/Double Dimensional Arrays)
- Iterations
- Functions and Subroutines
- The DIM Statement
- RESTORE Statement
- RND Function
- Creating a sequential file
- Open, Close statement
- TAB, Branching & Loop
- Load a file and save a file

MS-WORD
- MS-WORD as a wordprocessor
- Starting MS-WORD
- The MS-WORD Screen title bar, tool bar, work-area, scroll bar and status bar
- Editing
- Typing a document
- Use of backspace and delete keys
- Deleting a line (Ctrl+end)
- Forcing and continue/Exit
- Text appearance and Size
- Format command
- Line format
- Page format
- Document
- Others - Overstrike
- Text Conversion
- Retrieving file into current document/document2
- BLOCK/MOVE Command
- SWITCH command
- FONT Command
- PRINT ommand
- SPELL Checking/Thessarus
- Tables Creation/Editing
- Mathematical functions in Tables
- Mail merging
- Footnote and Endnote

MS-EXCEL
- Getting started
- Purpose and components of MS-EXCEL
- Entering/Editing
- Types of data - numbers (value), formula and labels.
Mathematical functions
- Simple calculations using mathematical signs
- Range Label, Format, Justify
- Printing a worksheet
- Graphical Representation of Data - Overview of Excel Basic Functions
- Creating printed form on Online
- Creating Formulas and Auditing Workbooks
- Creating and Using Charts
- Creating and Using Data in a Map
- Excel-database Creation, Query and Retrieving data
- Summarizing Data in Lists and Tables
- Data analysis Operations
- What-if Analysis Operations
- Statistical Data Analysis
- Data and Graphics sharing between Applications
- Automating Tasks-Macros
- Customizing Excel.

General Concept of Databases
- Dbase as a relational databse package
- Entering Dbase from DOS
- Two modes of using Dbase Assist and Command
- Assit Pull-down menu
- Types of file in dbase (databases) (.dbf), Catalogue (.cat), Index
(.ndx), command and procedure (.prg), format (.fmt), label (.lbl),
memory(.mem), query (qry), view (.vue), report (.frm), text
(.txt).Emphasis on .dbf, .frm, and .lbl files.
- Files structure
- Editing Data
- Saving
- File Organization
- Creating a Label file
- Creating/Editing a report file
- Printing a report file
- Introduction to Elementary dbase Programming.
Use of MS-ACCESS as DBMS.
POSTGRADUATE PROGRAMMES IN SOCIAL SCIENCES

(PGD & MBA)

POSTGRADUATE PROGRAMMES: 2 or 3 Semesters

1) POSTGRADUATE DIPLOMA PROGRAMMES: 2 Semesters
i) Accountancy
ii) Banking and Finance
iii) Business Administration
iv) Computer Science and Technology (3 semesters)
v) Education
vi) Marketing
vii) Purchasing and Supply
viii) Secretarial Administration
ix) Statistics
x) Transport

2) POST-GRADUATE DEGREE PROGRAMME: 3 Semesters

i) Master of Business Administration
ii) Master of Business Administration-Accountancy
iii) Master of Business Administration-Marketing
iv) Master of Banking and Finance
v) Master of Public Administration
vi) Master in Education
vii) Master of Law (LL.M)
POSTGRADUATE CURRICULUM
INTRODUCTION
The facility of Post-graduate Diploma/Degree is instituted to meet the ever increasing demand and yearnings of our numerous industries at the top management level.
The multi-various problems with their attendant complexeties faced by both private and government parastatals require advanced and pragmatic management training programes. The primary objective of the facility is to assist decision makers in solving the day to day management problems more precisely and effectively through the application of modern management techniques. In this regard, the mounting of postgraduate programmes in management sciences is a technological setting aimed at alleviating the problems of shortage of high-level manpower in Nigerias economy.

OBJECTIVES
The postgraduate programmes under Accountancy and Management Sciences is to train individuals on how to effectively handle management problems to meet the modern day challenges of the typical dynamic industrial environment. Other specific objectives of the programmes includes amongst others:

(i) To instil a problem solving attitude in management of organisations.
(ii) To teach basic tools and concepts of decision making and train the students in their application to managerial problems-solving.
(iii) To provide a broader socio-economic scope against which specific managerial problems may be assessed.
(iv) To develop the management skills required by individuals in the implimentation of decisions.


POST GRADUATE DIPLOMA: MGT SCIENCES

IST SEMESTER

COURSE CODE COURSE TITLE COURSE UNIT

PGD 601 Accountancy and Audit MGT 3
PGD 603 Financial Management 3
PGD 605 Management Informatics 3
PGD 607 Mnagerial Economics 3
PGD 609 Quantitative Technique 3
PGD 699 Research Project 6
21 Units


2ND SEMESTER

(A) FINANCIAL MANAGEMENT SPECIALISATION
PGD 602 Business Finance 3
PGD 604 Public Finance 3
PGD 606 Investment Analysis & Portfolio Management 3
PGD 608 Cost Accounting 3
PGD 612 Taxation 3
15 Units

(B) MANAGEMENT STUDIES SPECIALISATION
PGD 614 Management and Organisation Behaviour 3
PGD 616 Public Sector Management 3
PGD 618 Entrepreneurship 3
PGD 620 Operations and Production Management 3
PGD 622 Personnel Management 3
15 Units

(C) ACCOUNTING SPECIALISATION
PGD 624 Accountancy 3
PGD 626 Management Accountancy 3
PGD 628 Auditing and Investigation 3
PGD 630 Taxation 3
PGD 632 Public Sector Accounting 3
15 Units

(D) MANAGEMENT INFORMATICS SPECIALISATION

PGD 634 Data Processing and Appreciation 3
PGD 636 Programming and Information System 3
PGD 638 Concept of Computer 3
PGD 640 Computer filing and communication system 3
PGD 642 Analysis and Design of Information System 3
15 Units


PGD COURSE DESCRIPTION

PGD in Mgt. Science Course Description
PGD 601 Principles of Accounting & Auditing
Basic theory of auditing; book-keeping; elementary theory of accounts;
Basic theory of auditing; internal & external auditing practice.

PGD 602 Business Finance
Sources and uses of funds; consumption-investment problems; market rate of interest;investment decisions; internal and external finance.

PGD 603/MBA 705 Basic Financial Management (see MBA 703)

PGD 604 Public Finance
Basic concepts of financing in government, budgeting; its relationship with planning and plan implementation, the integrated system of planning, programming and budgeting for development.

PGD 605/MBA 701 Basic Management Informatics
Concepts of information, computer application to information processing, human as information processors; systems concept and information system, decision making, concepts for information sytems; value of information.

PGD 606 Investment Analysis and Portfolio Management
Operation of security markets, capital market theory and efficient market theory; valuation of stocks and bonds; application of financial theories in portfolio analysis; selection and performance valuation; analysis of other forms of investment warrants, options and commodity trading.

PGD 607 Economics
Factors of production, demand, supply and price theory, resources allocation decision in an economy, national economy and circular flow of income; national income theory and policy issues; theory of the firm, perfect competition, monopoly, oligopoly and duopoly; international trade and trade policies.

PGD 608 Cost Accounting
Cost concepts; measurement of relevant costs, incremental and marginal costs, opportunity costs, preparation, interpretation and presentation of business budget and budgetory controls.

PGD 609 Quantitative Analysis
Frequency distributions, measures of central tendencies and dispersion, probability; sampling techniques; linear correlation; time series and regression analysis.

PGD 610 Auditing
The role, nature and purpose of audit; internal and external audit, the concepts of “true and fair”, independence of auditor, relationship of auditors to shareholders and other finanacial statement users.

PGD 614 Management and Organization Behaviour
Behavioural Science concepts; techniques for maximizing human resources towards organizational goals; division of work and organizational structure; span of management and coordination of organizational activities.

PGD 616 Public Sector Management
Management of public enterprises; the functions of the civil services; public policy formulation and implementation; organization and management of central departments.

PGD 618 Enterpreneurship
Meaning, roles and qualifities of entrepreneurs. Types of business ownership’s; basic managerial functions; taking business decision based on decision theory; analysis of new projects.

PGD 620 Operation/Production Management
Basic concepts of operation and production management; product and process design; capacity planning and scheduling, quality planning and control; inventory management.

PGD 622 Personnel Management
Manpower planning ; managing the workforce, job design; appraisal system; employee information systems.

PGD 624 Financial Accounting
Theory of accounts; depreciation accounts; purchase and sale of fixed assets; partnership accounts, goodwill; methods of valuation; dissolution accounting requirement of limited companies; purchase, amalgation and absorption of business; control accounts.

PGD 630 Taxation
Nature and origin of taxation; direct and indirect taxation; progressive, proportional and regressive taxes; business taxation; capital transfer tax; capital gain tax; petroleum profit tax VAT.

PGD 632 Public Sector Accounting
Basic accounting for non-profit organisation; basic characteristics of government accounting; structure of governmental accounting in Nigeria; the treasury; audit department; consolidated revenue fund, capital and development fund; planning programming and budgeting system (PPBS).

PGD 638 Concept of the Computer
Computer fundamentals; central procesing units; input/output devices; data entry and special reading devices; storage; computer classification.

PGD 634 Data Processing and Computer Application
Data and information; value of information; developments and trends in data processing systems; modes of computer processing, concepts of information systems.

PGD 636 Programming and Information System
Information technology, office automation; general programming concept; programming applications – MS-EXCEL, Dbase.

PGD 640 Computer, Filing and Communication System
Data communication, record management, data base management creating a record file, record management programmes, computer network.

PGD 642 Analysis and Design of Information System
System study, system analysis concepts, system design, methodologies, system documentation; security in computer information systems.



MASTERS OF BUSINESS ADMINISTRATION (MBA) DEGREE

IST SEMESTER COURSE
UNITS

MBA 701 Management Informatics 3
MBA 703 Managerial Economics 3
MBA 705 Basic Financial Management 3
MBA 707 Quantitative Techniques 3
MBA 709 Cost Accountancy 3
15 Units


2ND SEMESTER

MBA 702 Business Statistics 3
MBA 704 Financial Accountancy 3
MBA 706 Marketing Management 3
MBA 708 Organisation Thoery and Management 3
MBA 710 Business Policy 3
15 Units

3RD SEMESTER

(A) OPERATIONS MANAGEMENT SPECIALISATION

MBA 711 Production and Inventory Management 4
MBA 713 Quality Control and Industrial Statistics 3
MBA 715 Plant Layout and Material Handling 3
MBA 717 Production Scheduling and Sequencing 3
MBA 719 Operational Research 4
17 Units

(B) MARKETING MANAGEMENT SPECILISATION

MBA 721 Advanced Marketing 3
MBA 723 Consumer Behaviour 3
MBA 725 Advertising 3
MBA 727 Quantitative Analysis in Marketing 3
MBA 729 Forecasting 3
MBA 731 Location Theory 3
18 Units



(C) FINANCIAL MANAGEMENT SPECIALISATION COURSE
UNITS

MBA 733 Financial Analysis and Theory 3
MBA 735 Financial Management and Policy 3
MBA 737 Investment Analysis 3
MBA 739 Financial Statement Analysis 3
MBA 741 Security Pricing and portfolio selection 3
MBA 743 International Business Finance 3
21 Units

(D) MANAGEMENT INFORMATICS

MBA 745 Management Information Systems 3
MBA 747 Economics of Data Processing 3
MBA 749 Methods and Techniques of System 3
MBA 751 Simulation Theory and Application 3
MBA 753 Computer Applications in Management 3
MBA 755 Software Development Theory and Practice 3
18 Units

4TH SEMESTER

MBA 799 Reasearch Projects 6 Units




MASTERS PROGRAMMES - COURSE DESCRIPTION

MBA 701 Basic Management Informatics
Concepts of information; computer application to information processing; human as information processor; systems concepts and information systems; decision making concepts for information systems; value of information.

MBA 702 Business Statistics
Descriptive statistics; probability distributions; estimation problems; regression and correlation analysis; hypothesis testing. Each statistical concept is illustrated with policies such as price control, subsidies, taxes and tariffs.

MBA 705 Basic Financial Management
Why individuals borrow and lend; creating wealth by investing in productive opportunities; How the investors value the firm; investment and financing decisions, consumption/investment problems using expected utility theory; consumer port-folio selection problems; market risk-return relationships and the valuation of risk assets. Operations functions; design of products and services; forecasting; process design; capacity planning and scheduling; inventory management; workforce management; quality control.

MBA 706 Basic Marketing Management
Concepts of marketing, marketing research; marketing decision in the areas of pricing; product policy; promotional; policy and distribution; marketing strategy and planning; management of the marketing functions; organisation, staffing information and control.

MBA 707 Quantitative Techniques
Linear programming techniques; assignment problems; decision theory, Markov theory analysis; queuing theory; simulation.

MBA 708 Organisation Theory and Management
Introduction to mangement; planning and decision making; the organising function; leading; controlling.

MBA 709 Basic Managerial Accounting
The nature and scope of managerial accounting; cost accounting analysis of financial requirements of business concerns; sources of finance; evaluation of capital expenditure proposals; control of capital expenditure; break-even analysis and marginal costing; differential costing; standard costing and variance analysis; method of financial report for management.

MBA 710 Business Policy
The concept and process of strategic management; product / market port-folio analysis operations management; and corporate strategy; management of growth and technology, turn-around strategies; the role of computer in today’s management; the business-environment interface; labour, the consumer, government, technology, scarcity of suppliers; mergers and acqisitions.

MBA 711 Production and Inventory Management
Aggregate resources planning, master production schedule, capacity planning; safety stock determination; distribution requirement, planning inventory management; review of inventory models, meaning of service, implicit costs in aggregate inventory management.

MBA 713 Quality Control and Indusrial Statistics
Acceptance sampling (by attributes and variables); programme of rectifying inspection; controls charts; estimation pertaining to proportions, means and variances, analysis of variance (ANOVA).

MBA 715 Plant Layout and Material Handling
The use of models and techniques for the design and set up of
- line layouts and flow line system
- process layout
- group layout
- flexible manufacturing systems.

MBA 719 Operations Research
Linear programming, problems formulations, computer software solutions; goal programming; project scheduling; CPM, PERT; GERT; dynamic programming; stochastic models; probabilities inventory models, decision models for queuing systems.

MBA 721 Advanced Marketing
The nature and complexity of marketing decisions; strucure in marketing problems into analytical models; evaluation of the utility of the existing models, and associated measurements for marketing management.

MBA 723 Consumer Behaviour
Measurement and analysis of consumer behaviour; perceptual and preference analysis; attitude change; non-congnitive approach, life style influence and group decision making.

MBA 725 Advertising
The behaviour and quantitative tools that make for an efficient coordination of the diverse aspects of marketing communications; use of advertising in a social contexts; societal consequences of advertising.

MBA 727 Quantitative Analysis in Marketing
Sales analysis and forecasting; product decisions; pricing; distribution and advertising decisions; the focus of the analysis will be on the existing models, issues of model development and implementation.

MBA 729 Forecasting
Selected forecasting methodologies; exponential smoothings; Box-Jenkins method; econometric models; time series analysis discrete and applied.

MBA 731 Location Theory
The study of space-dimension on economic theory relevant to the optical location of firms; theoretical models of classical and cash management.

MBA 733 Financial Analysis and Theory
Portfolio theory and the capital asset pricing model; market efficiency; capital budgeting and option pricing theory and implications for corporate finance; divided policy; asymmetric information and signalling; mergers and take-over bids, valuation and cash management.

MBA 735 Finanacial Management and Policy
Case studies based on MGS 633, Consequently, MGS 633 is a pre-requisite case report for further case-studies.

MBA 737 Investment Analysis
Capital budgeting problems, implementation of investment seletion procedures and the evaluation of their usefulness under uncertainty and/or in situations of imperfect markets; cost-benefit analysis.

MBA 739 Financial Statement Analysis
The mechanics of financial statement analysis; a brief review of capital market theory and capital asset pricing models; time series properties of accounting income numbers; analysis and management forecasts; equity valuation models and accounting information; accounting numbers and the credit market; risk estimation with accounting information; the effects of accounting information; the effects of accounting numbers-micro implications.

MBA 741 Security Princing and Portfolio Selection
Extensions of the capital asset pricing model; empiricalets of equlibrium pricing models; marketing efficiency-theory and evidence; option princing-theory and evidences application of option pricing theory to valuation of warrant convertibles, right issues, surbordinated debt; bond pricing duration; commodity markets and futures contracts; arbitace pricing theory.

MBA 743 International Business Finance:
Foreign exchange uncertainties and ways to offset or minimize them; financial management within multinational companies, the constraints and the oppurtunities arising from multinationality; the EEC financial markets – EEC currency and bond; the ECOWAS financial markets – ECOWAS currency and bond; development finance.

MBA 745 Management Information System
Previous and current developments in distributed processing in essentials, implementation, networks case studies of distributed system, future development.

MBA 747 Economics of Data Processing
The development of a framework for viewing the firms as an information system; primary methods for economic evaluation, cost-benefit analysis, utility.











SECTION D:



COLLEGE REGULATIONS





ACADEMIC TIME TABLE

The Harmattan and Rain Semester Teaching Time - Table shall be made available to students at the beginning of each Semester to guide them in selecting course, particularly electives, for which they can register. The Harmattan and Rain Semester Examination' Time- Table, however shall be made available to students at least two weeks before the commencement of each examination.

(i) The Senate shall have control and general discretion on all college examinations and shall exercise such powers as may be necessary to discharge these functions.

(ii) Senate shall be responsible for the details of organization and administrative arrangements for all examinations. It shall set up a sub-committee on Examination to assist it in the performance of these functions. The Registrar or his nominee shall be the Secretary to the Sub-committee.

(iii) Subject to the overriding control of Senate exercised through the Senate Committee on Examinations as in (ii) above, College examination shall be conducted by Department Boards of Examiners appointed by Senate on the recommendations of the appropriate College/Department Board.

(iv) Senate shall determine whether any matter is one of the conducts of examination or of the organization and arrangements for examinations.

DATES OF COLLEGE EXAMINATIONS

(i) The Senate shall schedule/fix the dates of all Semester examinations on the recommendation of the Committee of Rector and HODs. Such dates shall be published in the College Calendar; and once published, shall not be altered except with the express approval of the Senate.

(ii) Examiners must ensure that College examinations are held at the end of each Semester for all courses offered in that Semester and make available to the Head of Department exact sources or any copyrighted materials used in the question papers set by them.

(iii) The question papers must be written legibly or typed personally by the examiner himself on the prescribed forms.

(iv) The course number and title of paper in each subject must conform with the numbers and title in the College Handbook.

The Chief Examiner in each subject shall be responsible for the correctness of the question papers. The Chief Examiner or one of the College Examiners must sign all corrected proofs.

Maps, drawing, photographs, sketches and any other materials needed for reproduction in question papers must be in a form, which can be reproduced without notification and must be submitted along with the question papers.

(7) The Examiners are required to strictly preserve the secrecy of question papers at all stages until after the examination. The contents of question papers must not be disclosed to any person other than fellow examiners in the same subject or an official of the College specially appointed to deal with question papers.

(8) The Chief Examiner shall arrange for delivery of marked answer scripts to External Examiners where applicable. On no condition should the scripts be forwarded by post or sent abroad.

(9) The authorized scheme for College Examination is that approved by the Senate and it is the responsibility of the Course Examiner to ensure that this scheme is strictly adhered to.

On the completion of the examination, the Head of Department or Chief Examiners shall retain answer scripts.

REGISTRATION FOR COLLEGE EXAMINATION

A candidate for a college examination shall register for such Department for at least one-year after the date of Examination after which they may be destroyed, examination in the prescribed entry registration form. The completed registration form must be lodged with the Departmental Officer of the College/ Department to which the student belongs not later than the closing date prescribed for the registration for such courses.

Any candidate who fails to register for examination at the appropriate time as prescribed by the Senate shall not be allowed to take any examination in such courses. Any examination taken without registration shall be null and void.

(1) Candidates must present themselves at such examination for which they have registered under these regulations. Candidates who fail to do so for reasons other than illness or accident shall be deemed to have failed that examination. Misreading of the Time- table shall not be accepted as a satisfactory explanation for absence.

(2) As a general rule no special examination shall be set for any candidate who fails or is unable to complete any examination but such examination shall be taken at the next available opportunity which may be the following year. The general rule notwithstanding each case shall be considered on its merit.

GUIDELINES FOR CANDIDATES AT COLLEGE EXAMINATIONS

(1) A candidate shall not be allowed during an examination to communicate by word or otherwise with other candidate nor shall he leave his/her place except with the consent of an Invigilator. Should a candidate act in such a way as to disturb or inconvenience other candidates, he/she may, at the discretion of the Invigilator, be excluded from the examination room. Such an action by the Invigilator must also be reported to the Rector.

(2) It shall be an examination offence for any student, staff or any person whatsoever to impersonate a candidate in any College examination. Any student or staff of the College found guilty under this regulation shall be subject to disciplinary action by the appropriate authority of the College.

(3) It shall be an examination offence for any candidate to take onto an
examination room or have in his/her possession during an examination any
book or paper or printed or written documents, whether relevant to
examination or not, unless specifically authorized to do so. An invigilator has
authority to confiscate such documents.

(4) A candidate shall not remove from an examination room any papers, used or
unused, except the question paper and such book and papers, if any, as
he/she is authorized to take into the examination room.

(5) Candidate shall comply with all ‘’direction to candidates’’ set out on an
examination answer book or other examination materials supplied to them.
They shall also comply with direction given to them by an Invigilator.

(6) Candidate shall not write on any paper other than the examination answer
books. All rough work must be done in the answer book and crossed out
neatly. Supplementary answer books, even if they contain only rough work
must be tied inside the main answer books.

(7) When leaving the examination room, a candidate shall not leave his written
work on the desk but he shall hand over to an Invigilator. Candidates are
responsible for the proper return of their written work.

(8) Smoking shall not be permitted in examination rooms during examination
sessions.

(9) Any candidate or staff who attempts in any way to unlawfully have or give a
pre-knowledge of an examination question or to influence the marking of
Scripts or the award of marks by the College or External Examiner shall be
Subject to disciplinary action by the appropriate authority of the College.

EXAMINATION OFFENCES

(1) If any candidate is suspected of cheating, receiving or assisting other candidates or of infringing any other examination regulation, the Invigilator shall submit a written report to the Associate Rector Academics, of the circumstances within 24 hours of the examination session. The candidate concerned shall be allowed to continue with the examination.

(2) Any candidate suspected under Regulation (1) above shall be required to submit
to the Invigilator written reports immediately after the paper. Failure to make a
report shall be regarded as a breach of discipline.

(3) Where the Association Rector (Academics) has reason to believe that the nature of any question or the content of any paper may have become known before the date and time of the examination to any person other than the examiners of the paper, the Board of Examiners and any official of the College authorized to handle the paper, he may order the suspension of the examination or the cancellation of the paper or setting of a new paper and shall report the matter to the Senate. The Associate Rector (Academics) shall take any disciplinary measure against any student or students involved, as he may deem appropriate.

(4) If in the opinion of an Invigilator, circumstances arise which render the examination unfair to any candidate he must report the matter to the Associate Rector (Academics) within 24 hours of the examination.

(5) Where a matter is reported to the Associate Rector (Academics) under regulations 3 & 4 above, he may take such other action(s) as he thinks fit for the purpose of these regulations.

(6) Any candidate or member of the Academic staff may complain to the Associate Rector (Academics) that examination has been improperly conducted. The Associate Rector (Academics) shall investigate the complaint and report the result of his investigation to the Senate which shall take such actions as it may deem appropriate, including withholding of result or deprivation of the award of degree, diploma, etc.

EXAMINATION ACCOMODATION

(1) All College examination shall be held in rooms approved by the Registrar as suitable for the purpose. The rooms shall be prepared as follows;

(i) As much as possible the Registrar shall endeavor to accommodate all candidates who are to write papers in the same course in one room.

(ii) Where all candidates for the same course cannot be seated in one room, and are likely to be split into different rooms, the HOD of the Department must be informed in good time to make arrangement for sufficient number of Invigilators.

(iii) Sitting arrangement shall be standardized and specific distance maintained between one candidate and the other to prevent cheating.

The Registrar shall supply to the invigilator at each examination room the following materials;
- Answer books and other approved writing materials, e.g. drawing
papers, square ruled paper and graph.

MEDICAL ATTENTION

The Registrar shall arrange with the Director of Medical and Health Services for at least one of the College Medical Officers to be on call for the purpose of attending to candidates for the whole period of the Examination.

USE OF TYPEWRITER OR DICTATION OF ANSWERS

When a candidate in any college examination, for special medical reasons, desires to use a typewriter to indicate his/her answers, the Registrar shall, after consultation with the Director (Medical and Health Services) arrange for the typing or dictation of his/her answers under supervision at the candidate’s expense.

APPOINTMENT OF UNIVERSITY EXAMINERS

Examinations for the Diploma of the College shall be conducted by examiners appointed by the Senate on the recommendation of the appropriate Department.

(a) College examiners in each of the Departments within the Faculty shall be
appointed annually by the Senate on the recommendation of the
Department/ Faculty Board from among the academic staff of the College.
An assistant Lecturer shall not normally be appointed an examiner. One of
the College Examiners shall be designated Chief Examiner.

(b) All appointment of college Examiners shall normally be made at the first meeting of Senate of each academic year, provided that Senate, as recommended by the Academic Boards, may ratify such appointment.

(c) In the event of an emergency, the Rector may, on the recommendation of the appropriate HOD of a Department appoint an examiner to fill a vacancy
provided always, that such actions are reported to the next Senate meeting
for ratification.

FUNCTIONS OF COLLEGE EXAMINERS

(a) The Chief Examiner:

i) Shall be responsible for collection, collation and harmonization of all the segments of a paper/or a Course Examination.
ii) Shall ensure that all questions are coordinated and enough copies duplicated for each course.
iii) Shall arrange for the marking and presentation of the results to Senate in good time.

(b) Other College Examiners:

i) All examiners are to adhere to the time–table for the submission of questions. Draft examination questions are to be submitted to Heads of Departments by Examiners eight (8) Weeks before the beginning of the examination.

ii) Draft examination questions together with model answers and marking
Scheme should be submitted to the Head of Department. Head of
Department will not accept draft examination questions without model
answers and a marking scheme.
iii) Examiners shall proof-read their questions till all corrections have been made, so that corrections will not be in the examination room. A report on corrections made in the examination room shall be made by the senior Invigilator to the examiners’ Head of Department.

(iv) Examiners shall be present during the first half of the examination and should be available throughout the examination. Examiners should therefore, consult the final time–table for information on the place and time for their examinations.

(v) Examiners shall collect their scripts from the Head of the Department.

(vi) The Examiner or his nominee shall sign for any script collected from the Head
of Department.

(vii) Examiners shall adhere to the time-table for the submission of examination Grades and attendance at Examiners’ Board meeting. Examiners are to submit their examination grades to the Head of Department not later than two (2) weeks of the paper being taken.

Duties of Department/Faculty Examination Officers (DEO/FEO)

(i) Department/Faculty Examination Officers should be responsible for ensuring that all arrangement for the College examinations in the Faculty/Department are made.

(ii) They shall be responsible for the preparation of Faculty/Department Examination Time-table, allocation of Examination rooms, and assignment of Invigilators.

(iii) They shall be responsible for the collection of draft examination question for Head of Departments.

(iv) They shall provide assistance in the processing of examination results (calculation of G.P.A).

(v) They shall provide assistance in the preparation of examination result for submission to the faculty/college Examiners Board.

Duties of Examination Attendants

(i) To report once to the Invigilator any unseemly behavior of any candidate.

(ii) To accompany candidates leaving examination room under permission, so as to avoid cheating.

(iii) To run errand on the instruction of the examination Supervisor/Invigilator.

(iv) To perform such other duties as may assigned from time to time by the chief invigilatoror any other Senior Examination Officer. Under no circumstances should an attendant aid and abet a candidate to cheat during the examinations.

APPOINTMENT AND FUNCTIONS OF EXTERNAL EXAMINERS

One external from a University of repute shall participate in the conduct of the final year examination of each Diploma programme, and the determination of the overall results in accordance with the general regulation relating to the duties of the external examiner.

FUNCTIONS OF EXTERNAL EXAMINERS

It shall be the duty of the External Examiners, where applicable, to assist in the conduct of the examination for which they have been appointed and in particular:

i) to scruntinize draft question papers and to satisfy themselves that the question papers are appropriate having regard to the approved syllabus for the course being examined and the level of the examination; and to recommend such alteration or modifications to the papers as they may think desirable. All question papers must be signed by the external Examiner,

ii) to mark or revise the marking of scripts in consultation with the Chief Examiner in the subject;

iii) to assess practical or oral test in consultation with the Chief Examiner in the subject;

iv) to participate in the determination of results and to adjudicate in cases of diagreement among College Examiners in consultation with the Chief Examiner;

v) to submit to the Rector, on the following points,

vi) the general standard of the Examination and the performance of the candidates;

vii) the standard of marking by the College Examiners;

viii) a critical appraisal of the conduct of the examination, with suggestions for improvement on future occassions.

BOARD OF EXAMINERS

The Board of examiners of a Colllege shall be constituted as follows:
The Dean of the Faculty as Chairman;
The HODs and all other College approved Examiners in the Faculty;
Where applicable, the relevant External Examiners.


The Functions of the Board of Examiners of a Faculty shall be:

(i) to consider and ratify the marks, and in final examinations, the clasifications recommended by the Department Board of Examiners in respect of graduating students;

(ii) to make recommendations to the Faculty Board for the award of degrees, diplomas and certificates;

(iii) to consider all cases of absence or withdrawal from examinations and to make re-commendations to the Faculty Board;
(iv) to make recommendations to the Faculty Board for the award of distinctions and prizes.

The Department Board of Examiners shall be constituted as follows:

The Chief Examiner (Chairman)
The Exernal Examiner (s) where applicable
All the College Examiners in each paper.

The Function of the Departmental Board of Examiners shall be:
(i) the moderation of al examination questions;
(ii) to consider the marks allotted to candidate for individual course;
(iii) to make recommendation to the Faculty Board of Examiners.
PATTERN OF EXAMINATION
(i) Each course shall be examined at the end course.
(ii) Each course will normally be examined by a theory paper of 1-3 hours in addition to which there may be a pratical paper and /or an oral examination.
(v) MEASUREMENT OF PERFORMANCE
Performance in a course shall be measured in terms of:
(a) The results of prescribed theory and examination and /or
(b) Assessment of essays, pratical exercise and reports prescribed for each course.

RE-SIT EXAMINATIONS
The following guidelines are prescribed for the registration and conduct of re-sit examintions;
(i) That the re-sit examinations for both Harmatan and Rain Semester course be held once a year before the commencement of a new session.

(ii) That a student for re-sit examination should not be allowed to re-sit more than 10 Units, and not more than two courses in any year, except that a student who is unable to take his examinations (some or all) at the regular time may be allowed to exceed the 10 units ceiling subject to the approval of the Senate.

(iii) That a candidate must score not less than 30% in the particular course(s) in which a re-sit is being sought. This however does not apply to candidate taking examinations on special grounds for the first time as noted in (ii) above.

(iv) That student shall pay a fee of N1,500.00 per course for the re-sit examinations. These fees shall be subject to review from time to time as appropriate.

(v) That once a student registers for re-sit examination, it shall be mandatory for him to take the examination. Failure to do so shall earn him/her a zero mark.

(vi) If a student fails a re-sit paper or fail to present himself/herself for a re-sit examination registered for, such a student is deemed to have failed the examination and he/she is expected to register afresh for that course.

REGISTRATION OF STUDENT UNABLE TO GRADUATE DUE
TO SOME OUTSTANDING COURSE(S)

At the commencement of the session, a student shall through his/her Dean seek a general waiver of the regulations relating to minimum course load of full time studentship if he/she is unable to graduate because of one or two outstanding course. Such a student need not carry minimum full-time studentship load. In cases where the course are few and the circumstances permit the student may register for only one Semester for which he/she would pay fees on pro-rata basis.

FINAL YEAR STUDENTS PROJECT

Deans shall consider the cases of final year students who are unable to graduate because of non-completion and submission of final year projects with a view to dertermining whether student involved in the perparation of the projects would have to register as full-time student whilst working on the project or stay out of campus and receive supervision on the preparation of the project.The senate shall at the beginning of a new session, be informed of the status of All such students by the appropriate Department/Faculty.

ORIENTATION PROGRAMME

There is usually a one-week Orientation Programme, which should be fully attended by all fresh students. It is at this forum that essential and much needed information that will help fresh student to face adequately the challenges of higher institution education and as well understand life in the college will be given wider and fuller coverage; hence it is in every student’s interent to attend all the various activities scheduled for for the orientation week.

The College recognises also the various interests of students in the area of literary activities and as set forth the following guidelines to regulate such activities.

Publication
(a) Editors of publication and authors of any articles or cartoons that are libelous shall be held responsible for their content and they shall be liable to what ever penalty recommended by the Students’ Disciplinary Committee, ISAMS Press Council.

(b) Each article or cartoon shall bear the name of the author or a registered pen name. (This pre-supposes that any student writer who wishes to be writing articles under a pen name must register it with the student affairs officer before using it).

Code of Conduct of all students

As a corporate institution, the College accept the reponsibility to create the best congenial atmosphere for the smooth development of its students.The following guidelines are therefore set out for this purpose;

(a) The College expect its students to comport themselves decently and responsibly in public places;

(b) No student shall engage his/her fellow student or any member of the
public in physical combat;

(c) The junior staff of the college i.e. messengers, drivers, security men, etc. are
responsible officers of the college and student should not, on any account, insult or assult them. Any student aggrieved by any of the college staff make a reportof such grievance to the student Affairs Officers who shall take the matter up with the appropriate quarters of the College.

(d) The College expects a healthy and decent male/female relationship among
students.

(e) In the light of (d) above therefore, no male visitors shall be found in any
female after 10.00 p.m;
(f) Similarly, no female visitors shall be found in any male hostels after 10.00
p.m.

(g) No liquor shall be sold or consumed in the college premises before 6.00 pm. Any student who has to drink must do so with moderation and temporance. Any student found drunk or misbehaving under the influence of alcohol either on or off-campus shall be severely disciplined;

(c) The possession and/or comsumption of any dangerous drug is totally prohibited. Any student found contravening this regulation should be summarily dismissed from the college.

(d) Any student found stealing should be severely disciplined in accordance with the College regulations. Those found stealing outside the College premises may be handed over to the law enforcement agencies. The College shall deal FIRMLY and RUTHLESSLY with any reported cases of violation of any of this Code of Conduct.

Student are advised to read this Handbook to give you a full and comprehensive information about the College, its general regulations and the conduct of its academic affairs.

STUDENTS’ RIGHTS, PRIVILEGES AND OBLIGATIONS

In order to be able to operate effectively toward achieving their goals in the
College, students are entitled to some undeniable rights. And for the College community at large to be conducive to the attainment of the goals, they too owe it some obligation in exchange for certain privileges that the institution offers you. It is a two-way traffic.

Right:

1. The rigth of membership of the college community.

2. The right to receive tuition in the courses for which you have paid and have been duly registered.

3. The right to be examined in accordance with the approved rules and regulations governing the award of your degree or diploma, and

4. The right to be heard in accordance with the rules governing the fundamental rights of freedom of speech and natural justice.

Privileges:

1. The privileges to use the name of the college for protecting yourselves in all honest and lawful transaction only through the presentation of your students Identity card;

2. The privilege to use the college to enhance the attainment of your ultimate
objectives here;
3. The privilege to be certified at the end of your course here only after duly
satisfying your examiners and the senate at every stage of process leading to certification;

4. The privilege to enjoy medical care on campus within the affordable
limits of the college resources provided; of course, you have duly
registered at the college health center; and

5. The privilege to live in a college assisted Hostel on the payment of the
prescribed accommodation fees.

Obligations:

Consequent upon the right and privileges the College is conferring on students as members, they are reciprocally obliged to:

1. Observe the rules and regulations governing academic programmes such as
registering for courses as well as for examinations at the appropriate times;

2. Respect and obey constitute authorities of this College;

3. Treat all College properties, either provided for use, or not, with care;

4. Observe every rule and regulation of the college assisted hostels; and

5. Abstain from doing anything whatsoever that can bring the name of the
College into disrepute or embarrass its authorities.



& COMPUTER
MANAGEMENT STUDIES

A. DIGITAL COMPUTER COMMUNICATION
1. MODULATION TECHNIQUES: Describe the different types of modulation – amplitudes, frequency and phase.
2. MULTIPLEXING: Define a multiplexer. Explain frequency division multiplexing, time division and statistical multiplexing. Illustrate a multiplexer with diagrams. Calculate the cost effectiveness of a multiplexer. Define a concentrator. Differentiate between a Multiplexer and a Concentrator.
3. TRANSMISSION MODES: Explain the difference between simplex, half-duplex and full duplex transmission. Define synchronous and asynchronous transmissions.
4. TYPES OF MEDIA: Explain various transmission media in data communication links: switched and leased telephone lines, twisted wires, coaxial, radio satellite, optical fibre cable. Compare and contrast the link media listed above.
5. LINE ORGANIZATION: Define line organizations. Define point-to-point, multi-point and multi-drop organizations. Explain the difference between the organizations listed
above.
6. COMMUNICATION SOFTWARE: Define communication software. Explain the functions of the various communication software (shell, NOS, application programme,
performance software).
7. COMMUNICATION PROTOCOLS: Define a communication protocol. State the functions of communication protocol. Differentiate between various transmission protocols (Asynchronous and Synchronous). Describe some specific transmission protocols – binary synchronous control, synchronous data link control (SDLC), High
data link control (HDLC) X 25, etc.
8. NETWORK: Define a network. Explain different types of network organizations: star, loop, ring, bus, mesh, etc. Know different types of network LAN, WAN, MAN. Know management of system in network environment – various gates, etc. Explain specific existing network architecture SNA, Digital network architecture (DNA), JANET, JUNET, ASCNET, MAILNET, INTERNET.
B. COMPUTER MANAGEMENT STUDIES
a. ORGANIZATIONAL STRUCTURE OF DP DEPARTMENT: Describe the organizational structure of a data processing department. Describe the functions of the various personnel in a data processing department.
b. PROCEDURES OF COMPUTER OPERATIONS: Describe the principles and procedure of operating the computer system (the fix up, start-up, and shutdown). Identify the
functions of the constituents of the operating system. Explain operator system
commands. Describe the functions and operations of a master console.
Describe initialization & formatting of storage devices: disks/tapes/diskettes, etc
c. TYPES OF DATA PREPARATION METHODS: Apply the techniques of capturing data- off-line modes. Perform data verification. Explain data transmission methods and Identify
the items of equipment used in the above-listed methods.
d. SECURITY OF THE ENVIRONMENT: Explain the control techniques. Identify and explain standard operations procedures of computer installations. Explain the need for
computers systems auditing.
e. SAFETY PROCEDURES: Explain prevailing safety regulations in the computer installation. Describe method of preventing hazards (fire, flooding, sabotage, etc).
Describe file security methods and explain the need for file security in computer
installations. Explain user passwords and user names. Describe the need for libraries
computer installations. Describe a model library structure. Explain the need for user
identification procedure within an installation.


ADCSM 215 COMPUTER ELECTRONICS & HARDWARE MAINTENANCE & REPAIRS

A: BASIC COMPUTER ELECTRONICS
Constructional Features
1.1 Define a pulse.
1.2 Explain pulse shaping.
1.3 Define rise time, fall time, pulse circuits, duration, overshoot, and undershoot.
1.4 Explain the structural action of multi-vibration: monostable, stable.
1.5 Explain the constructional features of the R-S and J-K flip-flops.
1.6 Apply the R-S and J-K flip-flops to solve problems.
1.7 Explain the operations of shift registers.
Integrated Circuit Devices
2.1 Describe the application of I.C in the field of digital system design.
2.2 Explain the characteristics and implications of using ATL, TTL, DTL, ECL, and HTL
gates.
2.3 Apply different transistor logic gates to solve problems.
Digital IC System
3.1 Explain the constructional features of binary and decode counter: straight binary shift even, shift odd, sign and preset.
3.2 Describe the configurations of the counters in 3 above.
Small Scale Integrated Circuits (SSIC)
4.1 Synthesize a 4-bit adder.
4.2 Synthesize a NBCD adder.
4.3 Synthesize code-converting circuits, integrated (SSI) circuits, e.g. BCD gray.
4.4 Design a 4-decade excess-3 adder code converting circuits.
4.5 Solve problem of combinational circuit designs.
Elementary Digital Computer Architecture
5.1 Explain the various WORD formats.
5.2 Explain the Neumann configuration of digital computers.
5.3 Explain the arithmetic logic unit (ALU) and its basic registers.
5.4 Explain the basic registers of the timing and control unit.
5.5 Explain the basic registers of the I/O units.
5.6 Explain the basic registers of memory control units
5.7 Describe the Four, three and two address machines.
5.8 Describe the single address machines.
5.9 Describe the various methods of addressing.
B: BASIC HARDWARE MAINTENANCE
Basic Electric Current Theory
1.1 Describe voltage and current sources.
1.2 State Kirchoff’s law.
1.3 Explain the uses of transistors, capacitors, and resistors.
Logic Circuits and Analysis
2.1 State the laws of Boolean algebra.
2.2 Define a Boolean expression.
2.3 Construct truth tables.
2.4 Explain the use of the laws in 2.1 above in minimization of Boolean expression.
2.5 Describe the characteristics of logic gates.
2.6 Describe combinational circuits design.
2.7 Describe Kanmaugh map.
Maintenance Tools
3.1 Identify maintenance tools, electronic millimeter, oscilloscope, tester, etc.
3.2 Describe the use of the tools in 3.1 above.
3.3 Apply the tools in 3.1 above for maintenance purpose.

ADCSM 217 BUSINESS FINANCE & ANALYSIS FOR BUSINESS DECISION & MODELLING

1.0 ANALYSIS & CAPITAL INVESTMENT
1.1 Overview of firm and finance; Nature of finance; Risk and finance.
1.2 Objectives of the firm; Source of Business frequency.
1.3 Introduction to financial market; Nature of financial market; Money market; Capital market.
The regulator of stock market.
1.4 The concept of time value of money; Simple and compound interest; Future value of lump
sum; Future value of current annuity; Sure way for capital amortization.
1.5 Capital Investment; The investment decision process; Accounting rate of return (ARR);
Payback period (PBP); Net present value (NPV); Internal rate of return (IRR) ;
Profitability index/fund.
2.0 ANALYSIS FOR BUSINESS DECISION
2.1 Introduction; What is decision? Rationality in decision-making; Rationality paradox; Bounded rationality.
2.2 Elements of Decision making; Decision situations: certainty, uncertainty, risk.
2.3 Decision Tree and Secretary problem; Feedback analysis.
3.0 BUSINESS MODELS
3.1 Define and understand the definition of business models.
3.2 Describe different types of model: physical, mathematical, analogue and simulation.
3.3 Recognise a problem where a business model could be applied to assist in the solution
of that problem.
3.4 Outline the potential limitations of a business model in a given situation.
3.5 Appreciate that decision-making is not confined to the use of specific results of applying
modelling techniques.
4.0 DECISIONS AND MODELS
4.1 Construct a decision tree from a limited set of data and carry out a forward and backward
pass.
4.2 Derive a suitable course of action as a result of the analysis carried out in 2.1.
5.0 FORECASTING
5.1 Identify the various forecasting models and derive a forecast value from limited range of
data.
6.2 Plot calculated result using linear, log-linear and log-log graph papers.
6.0 SIMULATION
6.1 Definition; Concrete examples; Advantages and disadvantages; Mote Carlo simulation;
Worked example.



7.0 JOB SEQUENCING
7.1 Definition; Procedure for solving sequencing problems; Types of sequencing problems and
priority rules.
8.0 INVENTORY APPRIASAL
8.1 Describe the Economic Order Quantity (EOQ) from a limited set of data.
8.2 Derive the EOQ from a formula supplied.
9.0 LINEAR PROGRAMMING
9.1 Define the differences between the graphical and simplex methods of linear programming
(LP).
9.2 Derive the Objective function and Constraint function for Minimization and Maximization
problems.
9.3 Derive solutions to graphical LP problems.
9.4 Create and describe the elements of a Simplex LP tableau.
9.5 Interpret the final Simplex LP tableau and use it to solve a business problem.
9.6 Identify slack variables and shadow or dual values.
9.7 Use the primal-dual relationship for the solution of appropriate problems.
10.0 NETWORK ANALYSIS
10.1 Create an activity-on arrow network from a limited set of data, analyse the network in
terms of earliest and latest activity time and define the critical path(s).
10.2 Carry out an analysis of a Gantt Chart; create a resource profile to meet a resource
constraint.
10.3 Carry out a cost analysis of a small network by using cost slopes.
10.3 Compare and contrast activity-on-arrow and activity-on-node networks.
11.0 QUEUING THEORY
11.1 Identify the elements involved in a simple queuing system.
11.2 Derive various values associated with a simple queuing system.
12.0 REPLACEMENT ANALYSIS
12.1 Derive workable solution to problems caused by the need to replace components subject
to failure or deterioration.
13.0 APPLICATIONS
13.1 Identify suitable modeling techniques to non-complex problem solution, appraising them
for feasibility.
13.2 Describe managerial problems and benefits of applying a variety of modeling
techniques to business problems.
14.0 SOFTWARE PACKAGES
14.1 Identify possible computer software application packages that could be used to
carry out the necessary calculations for the techniques and models identified
in 2.1 – 2.9.
15.0 PROBLEM DEFINITION
15.1 Identify for a given scenario, the data necessary to create a business model.
16.0 SOFTWARE COST ESTIMATION
16.1 Explain the difficulties of software cost estimation.
16.2 Apply appropriate models identity in 2.1 – 2.9 to software estimation.
16.3 Apply appropriation models identified in 2.1 – 2.9 to software project planning.

ADCSM 219 ENTERPRENEURAL DEVELOPMENT & BUSINESS
POLICY

1. ENTERPRENEURIAL DEVELOPMENT
Explain the concepts of entrepreneur and entrepreneurial development. Who is n entrepreneur? State and discuss the personal characters and behavioural traits of entrepreneurs. What are the Qualities of a good entrepreneur? Examine the Financial aspects of entrepreneurship. Discuss the Nigeria environment and the problems of entrepreneurs in the country. Examine the Nigerian legislations regulating entrepreneur activities. Explain the legal procedures (Business registration, etc) and strategic preparations (feasibility study & report, etc) required for an entrepreneur to commence business operations.

2. BUSINESS POLICY
Define the concepts of business and business policy. Explain the nature and dynamics of business and business policy. Cite case studies off general management and the coordination of the functions of management/finance. Explain advanced production methods and policies. Discuss the Decision theory. Explain the classical school, creative brain-storming and technological forecasting. Explain the concepts of Certainty and uncertainty and the use of models. Discuss the concept of achievement and the criteria for evaluating it.

ADCSM 221 MANAGEMENT & ORGANISATION THEORY
Management introduction; nature and evolution of management (schools of) thought, theories and principles. Examine the universally accepted functions of management; planning, organizing, staffing, directing and controlling, policy, procedure and programme of formulation. Organization: Nature, purpose, and principle of organization. Organization structure, concepts of centralization, decentralization, divisionalization, and departmentation. Organizational culture; and organizational development.


RAIN SEMESTER

ADCSM 212 SOFTWARE ENGINEERING & SYSTEMS PROGRAMMING
ADCSM 214 RELATIONAL DATABASE, DATA MODELLING & SQL
ADCSM 216 MANAGERIAL ECONOMICS & SPSSO
ADCSM 218 ORGANISATIONAL BEHAVIOUR & HUMAN RELATIONS
ADCSM 220 DATA STRUCTURE & DATABASE ARCITECTURES/IMPLEMENTATIONS
ADCSM 221 RESEARCH PROJECT.


ADCSM 212 SOFTWARE ENGINEERING & SYSTEMS PROGRAMMING

GOAL(S) To expose the students to the techniques and tools for designing and building
Systems as well as ways in which the performance of a system can be evaluated.
A. SOFTWARE ENGINEERING
1. CREATION METHODOLOGIES
Design in other areas, Construction steps oriented towards software; Coherent creation
methodologies.
2. TOOLS AND TECHNIQUES FOR SYSTEM CONSTRUCTION
System Implementation Language; Structure Programming, Modular Programming
Programming tools and environment; Documentation.
3. PERFORMANCE MEASUREMENT AND EVALUATION.
Software characteristics; Software reliability versus software efficiency. Types of
Maintenance; Maintenance of Structured and Unstructured programs.
B. SYSTEM PROGRAMMING
Compiler, Assembler, Interpreter Differences: Define Compiler, Assembler &
Interpreter. Compare and contrast Compiler, Assembler and Interpreter.
Compilation Process: Explain the compilation process: Lexical analysis, syntax
analysis, code preparation, code generation, table of information and error routine.
Grammar and Language: Define Grammar and Language; define an alphabet;
define string; define a phase; Write production or rewriting rules.
Construct syntax trees for sentences.
Functions of a Scanner: Explain in-scanning process. Break up a simple source
code into tokens (variables, constants, labels literals, operands and delimiters).
Describe internal forms of tokens. Recognise tokens using state diagrams.
Function of Recognizer: Describe parsing techniques. Parse the output of the
Scanner using syntax trees and polish notation. Parse sentences applying Top-Down
and Bottom-Up methods. Recognize basic constructs such as triples, indirect Triples
and quadruples.
Storage Allocation: Explain storage allocation techniques. Draw data area display
for operands. Calculate Storage requirements for elementary data items – arrays
and strings.
Error Routine: Explain error routine. Write scanning error routine. Write Semantic
error routine.
Code Generation: Explain code generation. Generate code for simple arithmetic
expression: triples, indirect triples and quadruples.



ADCSM 214 RELATIONAL DATABASE, DATA MODELLING & SQL
RELATIONAL DATABASE & DATA MODELLING

TRADITIONAL DATABASE SYSTEMS – Define a database and database management system; Describe Traditional database models [Paper & Biro; Hierarchical and Network (CODASYL) systems]; Explain the advantages and disadvantages of these systems. Discuss the need for Relational Database Model.

THE RELATIONAL MODEL: describe Relational Database model and the work of Dr. Codd. Highlight the inadequacies of the original model and explain the concept of EER. Describe the major advantages of Relational Model over traditional models; disadvantages of relational database model. Describe the necessary rules/constraints of the Relational Model - Integrity rules. Describe the manipulation of relational model – relational algebra operations and operators.

DATA MODELLING – Describe the Basic Structure and the Relational Model: the Single Entity - Modelling single entity database; Creating a single table database; Querying a single table database. Relationship – Describe ONE-TO-ONE, ONE-TO-MANY and MANY-TO-MUCH Relationships. Creating and querying a relational database with a many-to-many relationship. Relationship descriptors as identifiers, dependent and intersection, entity-tree structure.
Building Blocks (fundamental concepts) – Entity, Attributes, Tuples, Relationship, Identifier; Entity types – Independent, Dependent, Intersection, Aggregate, Subordinate. Data Model quality criteria (well-formed data model and high fidelity image); Quality improvement (detail and context with examples). The concept of Normalization – functional dependency and first to fifth normal forms.
SQL
Introduction; Data definition, keys, Indexes, Notation. Relational Algebra operators and their effects (SELECT JOIN, PROJECT, UNION, DIVIDE, ETC.).
Create Table – Column definition, Primary Key definition, Referential Constraint definition.
Data types (smallint and integer, float, decimal cha and varchar, time and date, graphic and blob.
ALTER TABLE statement; DROP TABLE statement; CREATE VIEW STATEMENT; CREADE INDEX AND DROP INDEX Statements – Data Manipulation. Qualifying column names, select statement, product, join. INSERT and UPDATE COMMAND; Delete statement.
EMBEDDED WS=SQL using with COBOL and programming languages.

ADCSM 216 MANAGERIAL ECONOMICS & STATISTICAL PACKAGE
FOR SOCIAL SCIENCES (SPSSO)

A. MANAGERIAL ECONOMICS
Scope of managerial economics, definitions, micro-economic theory and business decision making. Business objectives. Profit as an objective. Investment decisions. Techniques of investment appraisal, cost-benefit analysis. Issues relating to pricing policy.

B. STATISTICAL PACKAGE FOR SOCIAL SCIENCES (SPSSO)
1. SPSSO at a glance.
2. Collection of Data. Distributed Analysis. Data Management.
Working with data files. Using the Data Editor.
3. Statistical Analysis.
4. Reports.
5. Descriptive statistics. Compare means. Correlate. Regression Analysis.
6. Data reduction.
7. Non parametric tests.
8. Graphical Analysis.


ADCSM 218 ORGANISATIONAL BEHAVIOUR & HUMAN
RELATIONS

Historical development: human relation's movement, theory X and theory Y (cf. theory Z), management approaches, classical and modern organization theories; human motivation; personality development theory; group dynamics and informal organization. Leadership and the dynamics of power; the dynamics of behaviour, frustration, and conflict. The impact of change.


ADCSM 220 DATA STRUCTURE & DATABASE ARCHITECTURES/
IMPLEMENTATIONS

A. DATA STRUCTURE & DATABASE MANAGEMENT SYSTEMS
1. CONCEPT OF DATA STRUCTURE
Define data structure; Data attributes, name value and range, units for identifying
Tool for studying data. Ordered list. Simple linked lists. String structure.
2. GENERAL CONCEPT OF DATABASES
Database as a relational database package; Entering Database from DOS; Two modes of using Database Assist and Command – Assist Pull-down menu; Types of files in Database (database) (. dbf), catalogue (.cat), Index (.ndx) command and procedure (.prg), format (.fmt), label (.lbl), memory (.mem), query (.qry), View (.vue), report (.frm), text (.txt). Emphasis on .dbf, .frm and .lbl files; structure; Entering data; Editing data; Saving/Quitting; File organization – Sort/Index; Creating label files; Creating Editing a report file; Printing a report file; Introduction to elementary database programming.
B. DATA STRUCTURE AND STORAGE
1. DATA STRUCTURE AND STORAGE DEVICES.
2. DATA STORAGE AND DATA PROCESSING ARCHITECTURES
Introduction, Client/server, Distributed database, Hybrid Architecture.
3. HIERARCHICAL AND NETWORK MODELS
Introduction, the Hierarchical model, the Network (CODASYL) model; Data Extraction.
4. THE RELATIONAL MODEL
Integrity rules, Manipulation – relational algebra operations and operators.
5. OBJECT-ORIENTED DBMS
Introduction, OO Concepts. Why OO? Objects and information systems modeling; persistent objects; OO DBMS.

ADCSM 221 RESEARCH PROJECT
(Refer to Diploma in Computer with Management)
CERTIFICATE IN COMPUTER

APPLICATIONS
MS-DOS/WINDOWS

MS-DOS

General Introduction
- Classification of Computer: micro, mini and mainframe
- Computer: 3 major components- INPUT, OUTPUT & PROCESSOR (CPU)
- The Operating System as the overal manager of all prograams in
computer.
- Hardware and Software
- Meaning of C:/> prompt and the A:/> prompt
- Booting or bootstrapping
- File name, file extensions, the default drive

MS-S DOS Commands
- Internal Commands
- Dir(ectory) with parameters (/p,/w), c/s, date, time, delete, rename, copy, tree, types, erase
- External Commands
- Format, diskcopy, backup, restore, path, (AUTOEXEC.BAT)
Directories
- What is a directory
- Creating to a directory
- Changing to a directory
- Removing a directorry

WINDOWS
- Introduction to Windows 98
- Starting Windows 98
- Group and Items Concept
- Folder and Files Concepts
- Desktop Management
- Icons and Windows (Creating Shortcuts)
- Basic Settings
- Running Applications
- Switching between Applications- Multitasking
- File Management
- Disk Management
- Installation and Removal of Application
- Printing
- Logoff Procedure
- Locating files and Folders

BASIC PROGRAMMING

- Full meaning of BASIC
- General Programming Concepts
- Structure of the BASIC program
- Basic character sets, Constants, String Constants, Numeric Constants,
Variables
- Arithmetic Operations
- LET Statement
- INPUT, READ”
- PRINT, LPRINT”
- RUN Statement
- LIST, LLIST
- Arrays (Single/Double Dimensional Arrays)
- Iterations
- Functions and Subroutines
- The DIM Statement
- RESTORE Statement
- RND Function
- Creating a sequential file
- Open, Close statement
- TAB, Branching & Loop
- Load a file and save a file

MS-WORD
- MS-WORD as a wordprocessor
- Starting MS-WORD
- The MS-WORD Screen – title bar, tool bar, work-area, scroll bar and status bar
- Editing
- Typing a document
- Use of backspace and delete keys
- Deleting a line (Ctrl+end)
- Forcing and continue/Exit
- Text appearance and Size
- Format command
- Line format
- Page format
- Document
- Others - Overstrike
- Text Conversion
- Retrieving file into current document/document2
- BLOCK/MOVE Command
- SWITCH command
- FONT Command
- PRINT ommand
- SPELL Checking/Thessarus
- Tables Creation/Editing
- Mathematical functions in Tables
- Mail merging
- Footnote and Endnote

MS-EXCEL
- Getting started
- Purpose and components of MS-EXCEL
- Entering/Editing
- Types of data - numbers (value), formula and labels.
Mathematical functions
- Simple calculations using mathematical signs
- Range Label, Format, Justify
- Printing a worksheet
- Graphical Representation of Data - Overview of Excel Basic Functions
- Creating printed form on Online
- Creating Formulas and Auditing Workbooks
- Creating and Using Charts
- Creating and Using Data in a Map
- Excel-database Creation, Query and Retrieving data
- Summarizing Data in Lists and Tables
- Data analysis Operations
- What-if Analysis Operations
- Statistical Data Analysis
- Data and Graphics sharing between Applications
- Automating Tasks-Macros
- Customizing Excel.

General Concept of Databases
- Dbase as a relational databse package
- Entering Dbase from DOS
- Two modes of using Dbase Assist and Command
- Assit Pull-down menu
- Types of file in dbase (databases) (.dbf), Catalogue (.cat), Index
(.ndx), command and procedure (.prg), format (.fmt), label (.lbl),
memory(.mem), query (qry), view (.vue), report (.frm), text
(.txt).Emphasis on .dbf, .frm, and .lbl files.
- Files structure
- Editing Data
- Saving
- File Organization
- Creating a Label file
- Creating/Editing a report file
- Printing a report file
- Introduction to Elementary dbase Programming.
Use of MS-ACCESS as DBMS.


POSTGRADUATE PROGRAMMESIN
SOCIAL SCIENCES

(PGD & MBA)
POSTGRADUATE PROGRAMMES: 2 or 3 Semesters

1) POSTGRADUATE DIPLOMA PROGRAMMES: 2 Semesters

i) Accountancy
ii) Banking and Finance
iii) Business Administration
iv) Computer Science and Technology (3
semesters)
v) Education
vi) Marketing
vii) Purchasing and Supply
viii) Secretarial Administration
ix) Statistics
x) Transport

2) POST-GRADUATE DEGREE PROGRAMME: 3 Semesters

i) Master of Business Administration
ii) Master of Business Administration-Accountancy
iii) Master of Business Administration-Marketing
iv) Master of Banking and Finance
v) Master of Public Administration
vi) Master in Education
vii) Master of Law (LL.M)
POSTGRADUATE CURRICULUM

INTRODUCTION

The facility of Post-graduate Diploma/Degree is instituted to meet the ever increasing demand and yearnings of our numerous industries at the top management level.

The multi-various problems with their attendant complexeties faced by both private and government parastatals require advanced and pragmatic management training programes. The primary objective of the facility is to assist decision makers in solving the day to day management problems more precisely and effectively through the application of modern management techniques. In this regard, the mounting of postgraduate programmes in management sciences is a technological setting aimed at alleviating the problems of shortage of high-level manpower in Nigeria’s economy.

OBJECTIVES
The postgraduate programmes under Accountancy and Management Sciences is to train individuals on how to effectively handle management problems to meet the modern day challenges of the typical dynamic industrial environment. Other specific objectives of the programmes includes amongst others:

(i) To instil a problem solving attitude in management of organisations.
(ii) To teach basic tools and concepts of decision making and train the students in their application to managerial problems-solving.
(iii) To provide a broader socio-economic scope against which specific managerial problems may be assessed.
(iv) To develop the management skills required by individuals in the implimentation of decisions.


POST GRADUATE DIPLOMA: MGT SCIENCES

IST SEMESTER

COURSE CODE COURSE TITLE COURSE
UNIT

PGD 601 Accountancy and Audit MGT 3
PGD 603 Financial Management 3
PGD 605 Management Informatics 3
PGD 607 Mnagerial Economics 3
PGD 609 Quantitative Technique 3
PGD 699 Research Project 6
21 Units


2ND SEMESTER

(A) FINANCIAL MANAGEMENT SPECIALISATION
PGD 602 Business Finance 3
PGD 604 Public Finance 3
PGD 606 Investment Analysis & Portfolio Management 3
PGD 608 Cost Accounting 3
PGD 612 Taxation 3
15 Units

(B) MANAGEMENT STUDIES SPECIALISATION
PGD 614 Management and Organisation Behaviour 3
PGD 616 Public Sector Management 3
PGD 618 Entrepreneurship 3
PGD 620 Operations and Production Management 3
PGD 622 Personnel Management 3
15 Units

(C) ACCOUNTING SPECIALISATION
PGD 624 Accountancy 3
PGD 626 Management Accountancy 3
PGD 628 Auditing and Investigation 3
PGD 630 Taxation 3
PGD 632 Public Sector Accounting 3
15 Units

(D) MANAGEMENT INFORMATICS SPECIALISATION

PGD 634 Data Processing and Appreciation 3
PGD 636 Programming and Information System 3
PGD 638 Concept of Computer 3
PGD 640 Computer filing and communication system 3
PGD 642 Analysis and Design of Information System 3
15 Units


PGD COURSE DESCRIPTION

PGD in Mgt. Science Course Description
PGD 601 Principles of Accounting & Auditing
Basic theory of auditing; book-keeping; elementary theory of accounts;
Basic theory of auditing; internal & external auditing practice.

PGD 602 Business Finance
Sources and uses of funds; consumption-investment problems; market rate of interest;investment decisions; internal and external finance.

PGD 603/MBA 705 Basic Financial Management (see MBA 703)

PGD 604 Public Finance
Basic concepts of financing in government, budgeting; its relationship with planning and plan implementation, the integrated system of planning, programming and budgeting for development.

PGD 605/MBA 701 Basic Management Informatics
Concepts of information, computer application to information processing, human as information processors; systems concept and information system, decision making, concepts for information sytems; value of information.

PGD 606 Investment Analysis and Portfolio Management
Operation of security markets, capital market theory and efficient market theory; valuation of stocks and bonds; application of financial theories in portfolio analysis; selection and performance valuation; analysis of other forms of investment warrants, options and commodity trading.

PGD 607 Economics
Factors of production, demand, supply and price theory, resources allocation decision in an economy, national economy and circular flow of income; national income theory and policy issues; theory of the firm, perfect competition, monopoly, oligopoly and duopoly; international trade and trade policies.

PGD 608 Cost Accounting
Cost concepts; measurement of relevant costs, incremental and marginal costs, opportunity costs, preparation, interpretation and presentation of business budget and budgetory controls.

PGD 609 Quantitative Analysis
Frequency distributions, measures of central tendencies and dispersion, probability; sampling techniques; linear correlation; time series and regression analysis.

PGD 610 Auditing
The role, nature and purpose of audit; internal and external audit, the concepts of “true and fair”, independence of auditor, relationship of auditors to shareholders and other finanacial statement users.

PGD 614 Management and Organization Behaviour
Behavioural Science concepts; techniques for maximizing human resources towards organizational goals; division of work and organizational structure; span of management and coordination of organizational activities.

PGD 616 Public Sector Management
Management of public enterprises; the functions of the civil services; public policy formulation and implementation; organization and management of central departments.

PGD 618 Enterpreneurship
Meaning, roles and qualifities of entrepreneurs. Types of business ownership’s; basic managerial functions; taking business decision based on decision theory; analysis of new projects.

PGD 620 Operation/Production Management
Basic concepts of operation and production management; product and process design; capacity planning and scheduling, quality planning and control; inventory management.

PGD 622 Personnel Management
Manpower planning ; managing the workforce, job design; appraisal system; employee information systems.

PGD 624 Financial Accounting
Theory of accounts; depreciation accounts; purchase and sale of fixed assets; partnership accounts, goodwill; methods of valuation; dissolution accounting requirement of limited companies; purchase, amalgation and absorption of business; control accounts.

PGD 630 Taxation
Nature and origin of taxation; direct and indirect taxation; progressive, proportional and regressive taxes; business taxation; capital transfer tax; capital gain tax; petroleum profit tax VAT.

PGD 632 Public Sector Accounting
Basic accounting for non-profit organisation; basic characteristics of government accounting; structure of governmental accounting in Nigeria; the treasury; audit department; consolidated revenue fund, capital and development fund; planning programming and budgeting system (PPBS).

PGD 638 Concept of the Computer
Computer fundamentals; central procesing units; input/output devices; data entry and special reading devices; storage; computer classification.

PGD 634 Data Processing and Computer Application
Data and information; value of information; developments and trends in data processing systems; modes of computer processing, concepts of information systems.

PGD 636 Programming and Information System
Information technology, office automation; general programming concept; programming applications – MS-EXCEL, Dbase.

PGD 640 Computer, Filing and Communication System
Data communication, record management, data base management creating a record file, record management programmes, computer network.

PGD 642 Analysis and Design of Information System
System study, system analysis concepts, system design, methodologies, system documentation; security in computer information systems.



MASTERS OF BUSINESS ADMINISTRATION (MBA) DEGREE

IST SEMESTER COURSE
UNITS

MBA 701 Management Informatics 3
MBA 703 Managerial Economics 3
MBA 705 Basic Financial Management 3
MBA 707 Quantitative Techniques 3
MBA 709 Cost Accountancy 3
15 Units


2ND SEMESTER

MBA 702 Business Statistics 3
MBA 704 Financial Accountancy 3
MBA 706 Marketing Management 3
MBA 708 Organisation Thoery and Management 3
MBA 710 Business Policy 3
15 Units

3RD SEMESTER

(A) OPERATIONS MANAGEMENT SPECIALISATION

MBA 711 Production and Inventory Management 4
MBA 713 Quality Control and Industrial Statistics 3
MBA 715 Plant Layout and Material Handling 3
MBA 717 Production Scheduling and Sequencing 3
MBA 719 Operational Research 4
17 Units

(B) MARKETING MANAGEMENT SPECILISATION

MBA 721 Advanced Marketing 3
MBA 723 Consumer Behaviour 3
MBA 725 Advertising 3
MBA 727 Quantitative Analysis in Marketing 3
MBA 729 Forecasting 3
MBA 731 Location Theory 3
18 Units



(C) FINANCIAL MANAGEMENT SPECIALISATION COURSE
UNITS

MBA 733 Financial Analysis and Theory 3
MBA 735 Financial Management and Policy 3
MBA 737 Investment Analysis 3
MBA 739 Financial Statement Analysis 3
MBA 741 Security Pricing and portfolio selection 3
MBA 743 International Business Finance 3
21 Units

(D) MANAGEMENT INFORMATICS

MBA 745 Management Information Systems 3
MBA 747 Economics of Data Processing 3
MBA 749 Methods and Techniques of System 3
MBA 751 Simulation Theory and Application 3
MBA 753 Computer Applications in Management 3
MBA 755 Software Development Theory and Practice 3
18 Units

4TH SEMESTER

MBA 799 Reasearch Projects 6 Units




MASTERS PROGRAMMES - COURSE DESCRIPTION

MBA 701 Basic Management Informatics
Concepts of information; computer application to information processing; human as information processor; systems concepts and information systems; decision making concepts for information systems; value of information.

MBA 702 Business Statistics
Descriptive statistics; probability distributions; estimation problems; regression and correlation analysis; hypothesis testing. Each statistical concept is illustrated with policies such as price control, subsidies, taxes and tariffs.

MBA 705 Basic Financial Management
Why individuals borrow and lend; creating wealth by investing in productive opportunities; How the investors value the firm; investment and financing decisions, consumption/investment problems using expected utility theory; consumer port-folio selection problems; market risk-return relationships and the valuation of risk assets. Operations functions; design of products and services; forecasting; process design; capacity planning and scheduling; inventory management; workforce management; quality control.

MBA 706 Basic Marketing Management
Concepts of marketing, marketing research; marketing decision in the areas of pricing; product policy; promotional; policy and distribution; marketing strategy and planning; management of the marketing functions; organisation, staffing information and control.

MBA 707 Quantitative Techniques
Linear programming techniques; assignment problems; decision theory, Markov theory analysis; queuing theory; simulation.

MBA 708 Organisation Theory and Management
Introduction to mangement; planning and decision making; the organising function; leading; controlling.

MBA 709 Basic Managerial Accounting
The nature and scope of managerial accounting; cost accounting analysis of financial requirements of business concerns; sources of finance; evaluation of capital expenditure proposals; control of capital expenditure; break-even analysis and marginal costing; differential costing; standard costing and variance analysis; method of financial report for management.

MBA 710 Business Policy
The concept and process of strategic management; product / market port-folio analysis operations management; and corporate strategy; management of growth and technology, turn-around strategies; the role of computer in today’s management; the business-environment interface; labour, the consumer, government, technology, scarcity of suppliers; mergers and acqisitions.

MBA 711 Production and Inventory Management
Aggregate resources planning, master production schedule, capacity planning; safety stock determination; distribution requirement, planning inventory management; review of inventory models, meaning of service, implicit costs in aggregate inventory management.

MBA 713 Quality Control and Indusrial Statistics
Acceptance sampling (by attributes and variables); programme of rectifying inspection; controls charts; estimation pertaining to proportions, means and variances, analysis of variance (ANOVA).

MBA 715 Plant Layout and Material Handling
The use of models and techniques for the design and set up of
- line layouts and flow line system
- process layout
- group layout
- flexible manufacturing systems.

MBA 719 Operations Research
Linear programming, problems formulations, computer software solutions; goal programming; project scheduling; CPM, PERT; GERT; dynamic programming; stochastic models; probabilities inventory models, decision models for queuing systems.

MBA 721 Advanced Marketing
The nature and complexity of marketing decisions; strucure in marketing problems into analytical models; evaluation of the utility of the existing models, and associated measurements for marketing management.

MBA 723 Consumer Behaviour
Measurement and analysis of consumer behaviour; perceptual and preference analysis; attitude change; non-congnitive approach, life style influence and group decision making.

MBA 725 Advertising
The behaviour and quantitative tools that make for an efficient coordination of the diverse aspects of marketing communications; use of advertising in a social contexts; societal consequences of advertising.

MBA 727 Quantitative Analysis in Marketing
Sales analysis and forecasting; product decisions; pricing; distribution and advertising decisions; the focus of the analysis will be on the existing models, issues of model development and implementation.

MBA 729 Forecasting
Selected forecasting methodologies; exponential smoothings; Box-Jenkins method; econometric models; time series analysis discrete and applied.

MBA 731 Location Theory
The study of space-dimension on economic theory relevant to the optical location of firms; theoretical models of classical and cash management.

MBA 733 Financial Analysis and Theory
Portfolio theory and the capital asset pricing model; market efficiency; capital budgeting and option pricing theory and implications for corporate finance; divided policy; asymmetric information and signalling; mergers and take-over bids, valuation and cash management.

MBA 735 Finanacial Management and Policy
Case studies based on MGS 633, Consequently, MGS 633 is a pre-requisite case report for further case-studies.

MBA 737 Investment Analysis
Capital budgeting problems, implementation of investment seletion procedures and the evaluation of their usefulness under uncertainty and/or in situations of imperfect markets; cost-benefit analysis.

MBA 739 Financial Statement Analysis
The mechanics of financial statement analysis; a brief review of capital market theory and capital asset pricing models; time series properties of accounting income numbers; analysis and management forecasts; equity valuation models and accounting information; accounting numbers and the credit market; risk estimation with accounting information; the effects of accounting information; the effects of accounting numbers-micro implications.

MBA 741 Security Princing and Portfolio Selection
Extensions of the capital asset pricing model; empiricalets of equlibrium pricing models; marketing efficiency-theory and evidence; option princing-theory and evidences application of option pricing theory to valuation of warrant convertibles, right issues, surbordinated debt; bond pricing duration; commodity markets and futures contracts; arbitace pricing theory.

MBA 743 International Business Finance:
Foreign exchange uncertainties and ways to offset or minimize them; financial management within multinational companies, the constraints and the oppurtunities arising from multinationality; the EEC financial markets – EEC currency and bond; the ECOWAS financial markets – ECOWAS currency and bond; development finance.

MBA 745 Management Information System
Previous and current developments in distributed processing in essentials, implementation, networks case studies of distributed system, future development.

MBA 747 Economics of Data Processing
The development of a framework for viewing the firms as an information system; primary methods for economic evaluation, cost-benefit analysis, utility.



WHAT A CONVERSE !!! THE PEACEFUL AND THE DEADLY.