Management Information System Lab
Lab 01. Introduction to Management Information Systems (MIS)
1.1. Understanding MIS and Its Role in Engineering
1.2. Key Components of MIS (Hardware, Software, Data, People, Processes)
1.3. Types of Information Systems (TPS (Transaction Processing Systems (SAP)), DSS
(Decision Support Systems (Siemens MindSphere, IBM Watson in Healthcare, Financial
DSS: Bloomberg Terminal, Amazon’s Warehouse Optimization System)), ESS
(Executive Support Systems, (SAP Digital Boardroom (Used by Siemens, BMW, Coca-
Cola), IBM Cognos Analytics for Business Intelligence)), MIS (Management
Information Systems))
1.4. Real-World Applications of MIS
Lab 02. Microsoft Access for Data Management
2.1. Introduction to Microsoft Access and Its Capabilities
2.2. Designing and Creating Tables, Queries, and Reports
Lab 03. Data Normalization and Relationships in Access
3.1. Automating Tasks with Macros and Forms
3.2. Understanding Relational Database Management Systems (RDBMS)
3.3. Hands-on Lab: Database in Access
Lab 04. AI Agents in MIS Applications
4.1. AI in Marketing: Customer Chat Automating
4.2. Social Media Control and Automation Using AI Bots
Lab 05. AI Local Machine Installation and usage (Prompts methods)
5.1. Hands-on Lab: Implementing an AI Chatbot for Customer Support
Lab 06. Database Management Systems (DBMS) and SQL
6.1. Introduction to Databases and Their Importance
6.2. Understanding Relational Database Management Systems (RDBMS)
Lab 07. Basics of SQL: Queries, Joins, and Transactions
7.1. Hands-on Lab: Creating and Managing Databases in MySQL
Lab 08. Business Intelligence and Data Visualization using Power BI
8.1. Introduction to Power BI for Decision Making
8.2. Data Cleaning, Transformation, and Modeling in Power BI
8.3. Creating Dashboards and Reports
8.4. Hands-on Lab: Developing a simple Dashboard
1|Page
Lab 09. Enterprise Resource Planning (ERP) and SAP
9.1 Introduction to ERP Systems and Their Role
9.2 Overview of SAP: Modules and Functionalities
9.3 Implementing Engineering Project Planning in SAP
9.4 Hands-on Lab: SAP for Data Management
Lab 10. AI and Machine Learning in MIS
10.1. Introduction to Machine Learning
10.2. Understanding the Role of Machine Learning
10.3. Key Machine Learning Concepts: Supervised, Unsupervised, and Reinforcement
Learning
Lab 11. Clustering and Classification Techniques in MIS
11.1. Regression Models for Data
11.2. Data Collection, Preprocessing, and Feature Engineering
11.3. Building and Training Machine Learning Models Using Python (Scikit-learn,
TensorFlow)
Lab 12. Cybersecurity in Management Information Systems
12.1. Introduction to Cybersecurity
12.2. Importance of Cybersecurity in Modern Information Systems
Lab 13. Key Cybersecurity Threats: Phishing, Malware,
Ransomware, and Insider Attacks
13.1. Data Encryption Techniques and Secure Communication Protocols
13.2. Access Control Mechanisms and Multi-Factor Authentication
13.3. Network Security and Firewalls: Protecting Enterprise Data
Lab 14. Intrusion Detection Systems (IDS) and Intrusion Prevention
Systems (IPS)
14.1. Securing a Database: SQL Injection Prevention and Data Masking
14.2. Implementing Role-Based Access Control
2|Page
