MANAGEMENT INFORMATION SYSTEM

Course main Aim/Goal

This course is designed to provide the student with the knowledge of management information system

General Objectives: On completion of this course, the student should:

1 The concept of MIS

2 Know the development cycle of MIS and total system

3 Understand the principles of decision-making

4 Understand the computer report

5 Understand Data Base Management System

6 Know DBMS case study.

1.1 Define MIS

1.2 Identify different types of MIS

1.3 Explain the importance of MIS to business organization.

Explain MIS

ii. Explain Management, Information and system.

iii. Describe the qualities of information used in MIS

iv. Identify different types of MIS and their importance in private and public sectors.

v. Demonstrate examples of fully implemented MIS.

2.1 . Identify the phases involved in the development cycle of MIS.

2.2 Explain each of the phases in 2.1.

2.3 State the objective of the total system.

2.4 Describe the contribution of each subsystem in 2.3.

2.5 Explain rationalization of information flows, timing and accuracy of destination of output.

Explain the phases involved in the development cycle of MIS: Study, design, development, operation.

ii. Describe each of the phases in (i) above.

iii. Explain the objectives of the total system.

iv. Explain rationalization of information flows, timing and accuracy of destination of output.

3.1 Describe the stages in decision making.

3.2 Explain some decision making techniques

Explain the stages in decision making.

ii. Describe some decision making techniques: PERT, GANNT, CHART, CIPP, STAKE etc.

iii. Explain any three of the techniques in (ii) above.

iv. Give assignment.
 
4.1 Define computer report.

4.2 Explain report formats and form design.

4.3 Explain the types of reports and their uses.

Explain computer report.

ii. Describe report formats and form design.

iii. Explain scheduled, on-demand, predictive and exception reports etc and their uses.

iv. Conduct Test

5.1 Define a database.

5.2 Describe the characteristics of database.

5.3 Identify the various types of DBMS.

5.4 Identify the relational DBMS, Oracle, Access, SQL Server, DB2, INGRES, etc.

Explain Database.

Ii Explain the characteristics of a database: Integrated, shareable, consistent, reliable, secure, and private,readily available, flexible, extensible,etc.

iii. Explain the various types of DBMS: network, hierarchical, inverted listed, relational object-oriented, etc.

iv. Explain relational DBMS

6.1 Explain data base case study.

6.2 Use a relational DBMS to undertake a case study.

6.3 Build form in a chosen DBMS

6.4 Create queries in the chosen DBMS.

6.5 Develop simple SQL code to query a database using restrictions, projections and simple joins (inner).

Explain data base case study.

Guide students to build tables using a relational DBMS case.

iii. Demonstrate the methods of validation and formatting in a chosen DBMS.

Demonstrate how and when to create indexes to speed up the processing of data.

v. Give Practical assignment.

vi. Demonstrate building forms in the chosen DBMS and use them to add, delete and edit data.

vii. Give Practical work.

viii. Demonstrate how to create queries in the chosen DBMS using QBE tool. Conduct Test.