Unique Visitor

Flag Counter

শুক্রবার, ৭ ডিসেম্বর, ২০১২

Management Information System (Manual 2)

Define MIS

 A management information system (MIS) provides information that is needed to manage organizations efficiently and effectively. Management information systems are not only computer systems - these systems encompass three primary components: technology, people (individuals, groups, or organizations), and data/information for decision making. Management information systems are distinct from other information systems in that they are designed to be used to analyze and facilitate strategic and operational activities in the organization.


1. MIS is always management oriented and keeps in view every level of management and gets the desired information.

2. Integrated - refers to how diff components(sub systems) are actually tied up together. eg: diff departments of organization linked together.

3. Useful for planning - as every organization makes log-term and short-term plans with the help of information like sales & production, capital investments, stocks etc management can easily plan.

4. Effective MIS helps the management to know deviations of actual performance from pre-set targets and control things.

5. its important for increasing efficiency.

6.MIS provides updated results of various departments to management.

7.MIS is highly computerized so it provides accurate results.

8.MIS adds to the intelligence, alertness, awareness of managers by providing them information in the form of progress and review reports of an ongoing activity.

9.Helps managers in decision- making.

A system is a set of interacting or interdependent components forming an integrated whole or a set of elements and relationships which are different from relationships of the set or its elements to other elements or sets.

Most systems share common characteristics:  
  • A system has structure, it contains parts (or components) that are directly or indirectly related to each other;
  • A system has behavior, it contains processes that transform inputs into outputs (material, energy or data);
  • A systems has inter-connectivity: the parts and processes are connected by structural and/or behavioral relationships.
  • A system's structure and behavior may be decomposed via subsystems and sub-processes to elementary parts and process steps.

An information system (IS) - is any combination of information technology and people's activities that support operations, management and decision making. In a very broad sense, the term information system is frequently used to refer to the interaction between people, processes, data and technology. In this sense, the term is used to refer not only to the information and communication technology (ICT) that an organization uses, but also to the way in which people interact with this technology in support of business processes.
Some make a clear distinction between information systems, computer systems, and business processes. Information systems typically include an ICT component but are not purely concerned with ICT, focusing instead on the end use of information technology. Information systems are also different from business processes. Information systems help to control the performance of business processes.
Alter argues for an information system as a special type of work system. A work system is a system in which humans and/or machines perform work using resources to produce specific products and/or services for customers. An information system is a work system whose activities are devoted to processing (capturing, transmitting, storing, retrieving, manipulating and displaying) information. 

Transaction Processing System(TPS)

•Whenever two people make an exchange, it is called a transaction. Transactions are important events for a company, and collecting data about them is called transaction processing. Examples of transactions include making a purchase at a store, withdrawing money from a checking account, making a payment to creditor, or paying an employee.

•Because transactions generally involve an exchange of money, it is critical that the data be protected during transmission and stored carefully so that it cannot be altered. It is also critical that the data be saved so that managers can verify the data if any conflicts arise. Also, the sales and purchase data from the foundation of the accounting and financial systems of every company, so the system must be able to produce the standard reports

What is MIS?

MIS or Management Information System is one of the major types of the computer systems because this system is the head of all the other systems in keeping and controlling them. The major constituent of this system are the employees. Managing the information that is strictly internal for any business and relating it with the employees and managing their functions in every aspect is the job of this system, that is done for the faultless performance of a business. This system is the most important one because of the reason that it helps in making the major decisions for the business and helps the decision makers in making future plans as well. And not only for this purpose, has MIS helped the business people in almost all the operational areas.

What is DSS?

A very important system for any large organization is the Decision Support System, abbreviated as DSS. This system, as the name suggests is ideal for making the right decisions for any business. Decision making is a critical process that involves considering all the major operations, forecasts, activities, planning and management of various functions. This system helps the senior management of an organization to get the required data in no time and process it further to make rapid, necessary decisions. This system not only helps the managers in making the decisions, but also in executing them rightfully. Just one major drawback is observed that is related to the fact that this system is not very good at handling large amounts of data and consequences.

 Difference between MIS and DSS and EIS

The difference between the three systems lies in their functions. The main function of MIS is related to the managing the internal operations and the documents. The DSS helps employees in making decisions even for the daily tasks. The EIS assists the senior level managers in making serious decisions that are very important and critical to make. MIS and the other two systems are still interlinked because of the fact that MIS holds all the documentations that are used by the other two. In the same way, DSS and the EIS are similar in a way that both are focusing on the decision making. The MIS has the feature to be used by the intellectual group that includes the high level and middle level management, as compared to that the DSS is the only one among the three that is used at all the business levels and the information it uses is not only internal but also the external one. Summarizing, EIS is complicated as compared to the DSS and MIS.


বুধবার, ৫ ডিসেম্বর, ২০১২

Management Information System

Management Information System

A management information system (MIS) provides information that is needed to manage organizations efficiently and effectively. Management information systems are not only computer systems - these systems encompass three primary components: technology, people (individuals, groups, or organizations), and data/information for decision making. Management information systems are distinct from other information systems in that they are designed to be used to analyze and facilitate strategic and operational activities in the organization. Academically, the term is commonly used to refer to the study of how individuals, groups, and organizations evaluate, design, implement, manage, and utilize systems to generate information to improve efficiency and effectiveness of decision making, including systems termed decision support systems, expert systems, and executive information systems. Most business schools (or colleges of business administration within universities) have an MIS department, alongside departments of accounting, finance, management, marketing, and sometimes others, and grant degrees (at undergrad, masters, and PhD levels) in MIS.

For Details Visit: M I S Details (Manual 1)

বৃহস্পতিবার, ৮ নভেম্বর, ২০১২

Excel Lession Advance Level

Click Here To Read The Manual(Excel)


 1.           Simple file handling.
               a)         Navigate to drives and folders
               b)         Organise files
               c)         Create, copy, move, rename, find, files and folders.

2.           Using Worksheets
               a)         Rename, delete,  insert, change order.
3.           Cell
               a)         Copy, paste, drag and drop
               b)         Create a Series
               c)         Alter cell width and height
4.           Formatting
               a)         Wrap, Centre across selection, shade, border, change font attributes
               b)         Number formatting – number of decimal places, currency
5.           Formulas
               a)         Order of operations (BEDMAS) and use of operators + - / * ^ ()
               b)         Use of functions, SUM, MAX, MIN, AVERAGE, COUNT, COUNTA
               c)         Use of % sign
               d)         Relative and Absolute cell references
6.           Graphing – simple pie, bar and column graphs.
7.           Apply Data Integrity Practices
               a)         comparison with original information sources
               b)         audited formulae
               c)         check-totals.

Click Here To Read The Manual(Excel)

Excel Intermediate Level

Contents and Page No

Moving around                                                                                                  3
Personal Expenses Exercise                                                                               6
Changing cell widths by dragging                                                                        6
Changing cell widths automatically                                                                      6
Formulas with numbers                                                                                      7
Formulas with Cell references                                                                            7
Inserting Cell References Automatically                                                              8
Personal Expenses Exercise                                                                               8
The Sum Function                                                                                              9
The AutoSum button                                                                                          9
Personal Expenses 2 Exercise                                                                          10
Accessing other built-in Functions                                                                    11
Average Function.                                                                                           11
Max and Min Function                                                                                     11
If/Then Function.                                                                                             12
The Count Functions                                                                                        12
PMT Function                                                                                                 13
Groceries Exercise                                                                                           13
International Academy Exercise                                                                       14
Cut and copy.                                                                                                  14
Click and Drag.                                                                                               15
Dragging Exercise                                                                                            15
Inserting a new Row                                                                                        15
Deleting a row or Column.                                                                               16
Absolute and Relative Cell references                                                               16
Personal Income Exercise                                                                                17
Berry Pickers Exercise                                                                                     18
Centering across Columns                                                                                19
Word colour and Cell colours.                                                                         19
Vertical Adjustment within rows                                                                       19
Wrapping text within a cell.                                                                              20
Number Formats.                                                                                            21
Deleting Rows and Columns                                                                            21
Car Expenses Exercise                                                                                    21
Sorting                                                                                                            22
Garage Sale Exercise                                                                                       22
Lookup Function                                                                                             23
Harry’s Bar Date and Time exercise                                                                 24
Minute                                                                                                             24
Now                                                                                                               24
Using Sheets                                                                                                    25
Extra Exercises                                                                                                27
Run a macro from a button                                                                               27
Run a macro from a Toolbar                                                                            27
Charting                                                                                                          29
George’s Chocolate Sales Exercise                                                                  30
Create a custom number format                                                                       30

শনিবার, ২৯ সেপ্টেম্বর, ২০১২

Access 2007 Tutorials

  1.  Getting Familiar with Microsoft Access 2007 for Windows
  2.  Understanding Security
  3.  Access Objects
  4.  Creating Microsoft Access Tables
  5.  Working with Microsoft Access Tables
  6.  Sorting, Filtering, and Creating Relationships
  7. Creating Microsoft Access Queries
  8. Creating Forms and Sub Forms of multiple items
  9. Creating Reports

Links of Tutorial:

Advance Access Tutorial
  1. Introduction
  2. Tables
  3. Relationship
  4. Queries
  5. Form
  6. Sub Forms
  7. Combo Box
  8. Advance Form
  9. Parameter Queries
  10. Action Queries
  11. Introduction To Visual Basic
  12. Event Driven Programming with Macros
  13. Data Access Objects
  14. Advanced Triggers
Links  :

বৃহস্পতিবার, ১৩ সেপ্টেম্বর, ২০১২

Basics of Internet

Read Link -> Basic Concept of Internet

The contents are:
  1. History of the World Wide Web
  2. Getting to the Internet : Browsers
  3. URL's
  4. Internet Explorer
Read Link -> Basic Concept of Internet

Internet Safety

Click the link below to read the document.

1. Internet Safety Guide 1

2. Internet Safety 2

The contents of the document are shown below:
  1. Internet Safety
  2. Raising Awareness
  3. Content Filtering
  4. School Acceptable Use Policy
  5. Email and Chat
  6. School Web site
  7. Data Protection Act
Click To Read The Document  ->> 1. Internet Safety Guide 1
                                                      2. Internet Safety 2

Basic Computer Concepts

Click Link The Link Below to Read the Documents:
Basic of Computer Concepts (Hardware and Software)

The above document(link) will cover the following items
  1. What is Computer?
  2. Types of Computer
  3. Hardware Components
  4. Main Parts of Computer
  5. Software Components
  6. Information Network
  7. Computer Accessories
  8. Uses of Computer
  9. Create a Good Working Environment
  10. Health and Safety Precautions
  11. Value of Backup
  12. Likes and Dislikes of Computer
  13. Computer Virus
  14. Software Copyright
Click Here to Read : ->> Basic of Computer Concepts (Hardware and Software)