MIS Technician Level 6 Notes

Management & Information Systems

Learning Outcome 1: Apply Information System Concepts

Definition of Terms

• Management: The efficient completion of activities through others, involving planning, organizing, directing, controlling, and coordinating, with decision-making integrated into each function.
  • Three levels: top, middle, and operational.
  • Each level requires different types of information for decision-making.
• Information: Interpreted and understood data that provides meaning within a context.
  • Functions:
    • Reduces uncertainty in planning and decision-making.
    • Aids in monitoring and control.
    • Facilitates communication.
    • Simplifies problems for better understanding.
  • Qualities: accuracy, verifiability, completeness, timeliness, relevance, understandability, appropriateness, economical, accessibility.
• System: A unified whole comprising independent, interrelated elements working towards a common goal through organized input processing and output generation.
  • Components are connected in an organized manner.
  • Components are affected by being within the system.
  • The system serves a specific purpose.
  • Can be open or closed.
    • Open System: Interacts with the external environment.
    • Closed System: Does not interact with the surrounding environment (primarily mechanical or physical systems).
• Information System: A system of people, machines, hardware, software, procedures, communications, policies, and methods for collecting, processing, storing, and disseminating information to support decision-making.

Meaning of Management Information Systems (MIS)

• A system providing information support for organizational decision-making.
• An integrated man-machine system to support operations, management, and decision-making.
• A system based on the organization's database to provide information to its members.
• A computer-based information system.
• An organized approach to gather information and make strategic management decisions.
• A system to support decision-making functions.

Qualities of Good Information

• Relevance: Pertains to the strategic decisions being reviewed.
• Accuracy: Avoids estimations or probable costs.
• Timely: Based on information from specific time periods (e.g., quarterly, annually).
• Exhaustive: Comprehensive information gathering refined as decision-making narrows.
• Cost-Effective: Efficient system for gathering information.
• Senior management support and sponsorship.
• Business risk analysis.
• Good project management controls.
• Good change management controls.
• Good user interaction/feedback controls.
• Good security management controls.
• Good management reporting system.
• Good return on investment.
• All functional requirements delivered, and users approve.

Components of MIS

• People: end users, IS specialists, system analysts, programmers, data administrators.
• Hardware: physical computer equipment and associated devices.
• Software: programs and procedures.
• Data: data and knowledge bases.
• Networks: communications media and network support.

Role of Information in an Organization

• Collects, processes, and distributes data to relevant destinations.
• Meets diverse needs through query, analysis, modeling, and decision support systems.
• Supports strategic planning, management control, operational control, and transaction processing.
• Aids clerical personnel in transaction processing and answering queries.
• Assists junior management with operational data for planning, scheduling, and control.
• Supports middle management in short-term planning, target setting, and business function control.
• Helps top management in goal setting, strategic planning, and business plan implementation.
• Facilitates information generation, communication, problem identification, and decision-making.

Qualities of a Good Information System

• Handles voluminous data.
• Confirms data and transaction validity.
• Performs complex data processing and multidimensional analysis.
• Enables quick search and retrieval.
• Provides mass storage.
• Communicates information to the user on time.
• Fulfills changing information needs.

Types of Systems

• Deterministic Systems: Function according to predetermined procedures, allowing accurate prediction of future behavior if current states are known (e.g., solar system, computer program).
• Probabilistic Systems: Operate on probability, making future behavior unpredictable (e.g., social systems).
• Information Systems: Both deterministic (processing data according to programmed instructions) and probabilistic (influenced by unexpected events like human error or viruses).
• Cybernetic Systems: Adapt to their environment for survival through self-organization, self-monitoring, and self-regulation (e.g., organizations, human beings, plants).
• Closed Systems: Do not interact with the environment (rare in social systems, mainly scientific).
• Open Systems: Interact with the environment, receiving input and producing output (e.g., business information systems). Require regulation due to environmental interactions. Example: Process regulation through negative feedback
• Negative Feedback: Regulates a system by providing data about its performance.
• Control: Monitors and evaluates feedback to ensure the system progresses toward set goals.
  • Positive Feedback: Indicates proper system performance, prompting maintenance of the current course.
  • Negative Feedback: Indicates deteriorating performance, signaling deviation from goals.
• Entropy: The tendency of a system's performance to deteriorate over time.
• Subsystem: Smaller systems linked together to form a larger system (building blocks interfaced by communication links).

Learning Outcome 2: Analyze Information Systems Strategic Levels

Strategic Levels of an Organization

1. Operational Level:
   • Focuses on day-to-day activities and tasks.
   • Involves executing specific tasks and processes.
   • Ensures smooth and efficient operations according to established procedures.
   • Managed by front-line supervisors, team leaders, and department managers.
2. Knowledge Level:
   • Emphasizes expertise, skills, and specialized knowledge.
   • Involves specialists, subject matter experts, researchers, and technical staff.
   • Essential for innovation, problem-solving, and continuous improvement.
3. Tactical Level:
   • Focuses on intermediate-term planning and decision-making.
   • Translates strategic goals into actionable plans.
   • Involves resource allocation, budgeting, and project management.
4. Strategic Level:
   • Deals with long-term planning, vision-setting, and overall direction.
   • Involves senior executives and top-level management.
   • Focuses on identifying opportunities, assessing risks, and allocating resources.

Classification of Information Systems

• Transaction Processing Systems (TPS):
  • Processes routine transactions efficiently and accurately.
  • Supports operational-level activities (e.g., order processing, inventory management).
  • Characterized by high speed, reliability, and real-time processing.
• Management Information Systems (MIS):
  • Provides middle managers with reports for monitoring and control.
  • Summarizes and aggregates data to generate regular reports and forecasts.
  • Supports tactical-level decision-making.
• Decision Support Systems (DSS):
  • Assists managers in analyzing information and evaluating alternatives.
  • Provides interactive tools and models for semi-structured decision-making.
  • Utilizes data analysis, simulation, optimization, and visualization techniques.
• Executive Information Systems (EIS):
  • Supports strategic decision-making for top executives.
  • Provides summarized and customizable information from internal and external sources.
  • Emphasizes graphical displays, KPIs, and trend analysis.
• Enterprise Resource Planning (ERP) Systems:
  • Integrates and automates core business processes across functional areas.
  • Provides a centralized database and standardized processes.
  • Enables better coordination and decision-making.
• Knowledge Management Systems (KMS):
  • Captures, stores, organizes, and shares knowledge and expertise.
  • Facilitates knowledge creation, dissemination, and reuse.
  • Promotes learning, innovation, and collective knowledge-based decision-making.

Types of Information Systems (Based on Functional Areas)

• Transaction Processing Systems (TPS)
  • handles events that generate/modify data, which is stored in an information system.
  • Examples: purchases, bank withdrawals, payments to creditors, employee payments.
  • Data saved and protected carefully due to its impact on business and foundation for accounting systems.
  • Transaction processing includes data entry, validation, processing (online or batch), storage, output generation, and query support.
  • Characteristics: records internal/external transactions, performs routine tasks, frequently accessed data, maintain data integrity using imposed rules and guidelines, serve the various functional areas of the organization.
• Knowledge Work and Office Systems
  • Supports knowledge workers (engineers, designers, technicians) by creating, using, and disseminating knowledge.
  • Functions: keeps knowledge up to date, assists internal consultants, and acts as change agents.
  • Knowledge workers (create knowledge and information) and data workers (process and distribute information) are essential.
  • Requires tools such as graphics, analytics, communications, and document management.
  • Examples include Computer Aided Design (CAD) applications, Virtual Reality, Investment Systems.
• Decision Support Systems (DSS)
  • Assist managers in semi-structured and unstructured decisions.
  • Interactive systems using communication technologies, data, knowledge, and models to complete tasks.
  • DSS users: financial analysts, loan officers, auditors, production schedulers
  • Components: user interface, database, models/analytical tools, and network architecture that integrates system components.
    • Types: Data-Driven DSS, Model-Driven DSS, Knowledge-Driven DSS, Document-Driven DSS.
      • Data-Driven: access and manipulate large datasets.
      • Model-Driven: use models and parameters for analysis; perform "what-if" scenarios.
      • Knowledge-Driven: specialized problem-solving and knowledge base expertise.
      • Document-Driven: retrieve and manage unstructured documents and web pages using technologies like search engines.
  • Examples: investment evaluation, fraud detection, corporate planning, forecasting, etc.
• Management Information Systems (MIS)
  • Provide information for management functions (planning, organizing, controlling, coordinating, decision-making) by producing reports on a regular basis.
  • Operate above TPS, managing activities support operations.
  • Used mostly by middle-level managers requiring structured and unstructured decision-making.
• Executive Support Systems (ESS)
  • Facilitate strategic decision-making for senior executives.
  • Provide summarized internal and external information.
  • Features: easy to use with graphical interfaces, broad information with drill-down options, context information, data integration and timeliness.
  • Benefits: simple for high-level executives, timely information delivery, filters data for better time management, tracks improvements.
  • Disadvantages: need computer skills, preparation time, difficulty quantifying decision improvements, database integrity difficulties.
  • Examples: monitor market trends, manage company assets and inventories.
• Information System Processing Requirements
  • Computational resources necessary to execute tasks effectively.
    • Influenced by complexity, data volume, transaction frequency, user interactions.
• Computational Power: Systems for complex tasks (simulations, data analytics) require more power
• Data Volume and Velocity: Systems processing large volumes or high transaction rates need sufficient capabilities
• Response Time: Systems requiring real-time responses (financial trading) need fast processing
• Concurrency and multi-user support: Systems concurrently supporting multiple users must manage resource allocation.
• Scalability: Ability to adapt to increasing loads (adding CPU cores, memory, or storage).
• Optimization Techniques: Algorithm optimization, data compression, caching etc., help improve processing efficiency, reduce resource consumption, and improve performance by mitigating processing bottlenecks
• Resource Allocation and Management: Monitoring utilization and dynamically adjusting allocation
• Security and Compliance: Systems handling data require encryption, controls, audit trails.

Learning Outcome 3: Manage Information Resources

Information System Resources

• Encompass tangible and intangible elements supporting IS functions:
  • Hardware
  • Software
  • Databases
  • Networks
  • Procedures
  • Security Facilities
  • Physical Buildings
• Hardware Resources: Physical components (servers, workstations, storage, networking equipment, peripherals).
• Software Resources: Programs and applications (operating systems, ERP, CRM, DBMS).
• Data Resources: Information and data assets (structured data in databases, unstructured data like documents and multimedia).
• Human Resources: People involved in IS development, operation, and maintenance (administrators, developers, engineers, analysts, end-users).
• Financial Resources: Budgetary allocations and investments for IS (hardware, software, upgrades, licenses, personnel, training).
• Infrastructure Resources: Physical and virtual infrastructure (data centers, server rooms, network infrastructure, cloud services).
• Knowledge Resources: Intellectual capital, expertise, and institutional knowledge (best practices, standards, documentation, training materials).

Classification of Information System Resources

1. Hardware Resources:
   • Central Processing Unit (CPU): Executes instructions and processes data.
   • Storage Devices: HDDs, SSDs, and other storage media for data and software.
   • Networking Equipment: Routers, switches, modems for communication and data transfer.
   • Peripheral Devices: Input/output devices like keyboards, mice, monitors, printers, and scanners.
2. Software Resources:
   • System Software: Operating systems (Windows, macOS, Linux) and utilities.
   • Application Software: Programs for specific tasks (word processors, spreadsheets, ERP, CRM).
   • Development Tools: IDEs, compilers, debuggers for software development.
3. Data Resources:
   • Structured Data: Organized data in databases (MySQL, Oracle, SQL Server).
   • Unstructured Data: Text, multimedia files, images, and videos without predefined models.
   • Metadata: Descriptive information about data elements.
4. Human Resources:
   • System Administrators: Manage hardware, software, and network infrastructure.
   • Database Administrators (DBAs): Oversee database management, performance, security.
   • Software Developers: Design, develop, test, and maintain software and systems.
   • Network Engineers: Design, implement, and maintain network infrastructure.
   • End Users: Interact with the information system to perform tasks and make decisions.
5. Financial Resources:
   • Budget Allocations: Funds for hardware, software, upgrades, personnel, and operations.
   • Capital Expenditures (CAPEX): Investments in physical assets (servers, networking equipment).
   • Operating Expenses (OPEX): Recurring expenses for licenses, maintenance, and salaries.
6. Infrastructure Resources:
   • Data Centers: Facilities for hosting and managing IS resources.
   • Cloud Computing Services: IaaS, PaaS, and SaaS provided by cloud service providers.
   • Virtualization Platforms: Tools for creating and managing virtual machines and infrastructure.
7. Knowledge Resources:
   • Best Practices: Guidelines for effective IS design, implementation, and management.
   • Documentation: Technical manuals, user guides, and system specifications.
   • Training Materials: Educational resources for users and IT professionals.

Managing Information System Resources

• Efficiency: Proper utilization of hardware, software, networks, and data.
• Cost Reduction: Minimizing unnecessary expenses through resource optimization.
• Security: Protecting sensitive data and assets from unauthorized access.
• Scalability: Ensuring systems can handle increased workload and adapt to changing requirements.
• Reliability: Maintaining uninterrupted business operations through proactive monitoring and disaster recovery planning.
• Compliance: Adhering to regulatory requirements related to data privacy, security, and confidentiality.
• Decision Making: Implementing systems for data collection, storage, and analysis to inform decision-making.