Videos for Better Comprehension

Tips to Maximize Learning

1. Watch in sequence: Start with the introductory videos, then progress through the playlist modules to build understanding incrementally.

2. Take notes: Jot down definitions of major IS types (TPS, MIS, DSS), and examples for how they're used in different business functions.

3. Apply the concepts: Reflect by examining a local company or your favourite brand—identify which information systems they might use for supply chain, customer relationship, or decision support.

4. Explore further: Look for lectures from accredited institutions or business schools to deepen your understanding once you’ve got the basics.

1. Information Technology In 4 Minutes

2. What is Information Technology? Explained Simply!

3. What is Information Technology (IT)?

4. What is Information Technology?

5. What is Management Information System (MIS)?

6. Introduction to Management Information Systems (MIS) concentration

****
7. Introduction to Information Systems (IS)

8. Types of Information Systems (TPS, MIS, and DSS)

9. What is Management Information System (MIS)?

10. Introduction to Information Systems - Principles of Business Information Systems (28 Minutes)

11. Series of talks on Information technology

12. How Information Systems Are Transforming Business?

13. Management information system , lecture, BCA, MCA by Anju Bhatt I Guru Kpo

14. Introduction to Information Systems

15. Decision Support System (DSS) -Management Information System-Information System-Management Tutorials

16. Office Automation System (OAS) Introduction & Examples - Management Information System (MIS) 

17. Group Decision Support System and Executive Support System GDSS

18. Difference between Executive Information System and Traditional Information System

19. Executive Information Systems

20 Navigating Your Business Landscape: A Guide to Executive Information Systems (EIS)

Module 3: Database Management System (DBMS)

1. What is Database & Database Management System DBMS | Intro to DBMS

2. Introduction to Database Management Systems

Module No. 1: Information Technology and Information System

1. Introduction to Information Technology (IT)

What is Information Technology?

Information Technology, or IT, refers to all the technologies used to manage and process information. It includes:

• Hardware (like computers, servers, smartphones),

• Software (like MS Word, Tally, accounting packages),

• Networks (Wi-Fi, internet, LAN),

• Databases (used to store and retrieve data).

• Definition: Information Technology refers to the use of hardware, software, networks, and databases to collect, store, process, and distribute information.

• It includes computers, telecommunication tools, and other digital technologies used in business operations.

• Purpose: To support and enhance the processing of information and communication within and outside an organization.

Why is IT important in business?

• Helps automate repetitive tasks (e.g., payroll calculation).

• Makes communication faster through email, WhatsApp, video calls.

• Supports data storage and analysis.

• Saves time, reduces cost, and improves productivity.

Real-life Examples:

• Banks using ATM machines (hardware + software).

• Online stores using e-commerce websites.

• Offices using Zoom/Teams for meetings.

---

2. Introduction to Information System (IS)

What is an Information System?

An Information System (IS) is a combination of people, technology, processes, and data that helps in collecting, processing, storing, and distributing information to support business activities.

It’s not just about computers — it’s also about how data is used and how it helps people make decisions.

• It helps in decision-making, coordination, analysis, and control in an organization.

Examples:

• Payroll System, Inventory Management System, CRM (Customer Relationship Management), ERP (Enterprise Resource Planning).

Five Main Components of an IS:

1. Hardware – Physical devices (computers, printers).

2. Software – Programs used to process data.

3. Data – Raw facts and figures.

4. People – Users who operate the system.

5. Processes – The steps or rules followed to manage data.

Examples:

• A supermarket’s billing system.

• A company’s attendance tracking system.

• School student information system.

---

3. Difference between IT and IS

Basis	Information Technology (IT)	Information System (IS)
Meaning	Tools and devices for processing information	A full system that uses IT to manage business information
Components	Only technology: hardware, software, network	Technology + people + process + data
Focus	Technical tools	Business process support and decision making
Example	Laptops, software like MS Excel	Payroll system using Excel and employee data

Aspect     Information Technology (IT)                 Information System (IS)

Definition Tools and technologies used for processing data System that uses IT to support business functions

Focus Hardware, software, networks         Integration of IT, people, and processes

Purpose To provide the technical tools                 To manage and use information for decision making

Example Computer, database software                 HR management system using computers and software

Think of IT as the engine, and IS as the full car that includes the engine, driver, fuel, and destination!

---

4. Need for Information Systems in Business

Why do businesses need Information Systems? Here are the reasons:

1. Better Decision Making: IS provides correct, updated, and useful information to managers for making wise decisions.

2. Improves Efficiency: Automates tasks, reduces manual work.

3. Faster Communication: Emails, WhatsApp groups, and internal portals help employees stay connected.

4. Data Management: Stores large data safely (e.g., customer details, sales history).

5. Customer Satisfaction: Fast service and accurate information improve the customer experience.

6. Gaining Competitive Advantage: Helps in doing better than competitors by responding quickly and smartly.

7. To improve operational efficiency

   8. To support decision-making processes

   9. To enhance communication and collaboration

   10. To gain competitive advantage

   11. To manage and store vast amounts of business data

   12. To automate routine business tasks

---

5. Information Systems in the Enterprise

Different types of information systems are used in different levels of a business.

1. Transaction Processing System (TPS)

• Handles daily routine tasks.

• Examples: Billing, inventory entry, salary calculation.

2. Management Information System (MIS)

• Helps middle managers with reports and summaries.

• Example: Monthly sales reports, employee performance.

3. Decision Support System (DSS)

• Assists in analyzing data to make complex decisions.

• Example: Choosing between two suppliers based on quality and price.

4. Executive Information System (EIS)

• Provides top-level managers with high-level dashboards.

• Example: CEO getting an overview of profits from all branches.

5. Enterprise Resource Planning (ERP)

• Integrates all functions (finance, HR, inventory) into one system.

• Example: SAP, Oracle ERP.

6. Customer Relationship Management (CRM)

• Manages customer information and communication.

• Example: Calls, emails, feedback data stored for better service.

7. Supply Chain Management (SCM): For handling production and logistics.

---

6. Impact of IT on Business

Information Technology has changed how businesses work in many ways:

a. Business Data Processing

• Fast and accurate data processing using software like Excel, Tally.

• Example: Bank calculating interest or deductions quickly.

b. Intra and Inter-Organizational Communication

• Intra-organization: Within the company – employees communicate via email, video meetings.

• Inter-organization: With other businesses or customers – vendors send invoices via mail or portal.

c. Business Process Outsourcing (BPO)

• Non-core activities (like call centers, payroll processing) are outsourced to other companies.

• Benefits: Reduces costs, improves focus on core business.

d. Knowledge Process Outsourcing (KPO)

• High-skill tasks like research, financial analysis, legal work outsourced.

• Enables businesses to access expert talent and improve decision-making.

• Example: A company in the US gets a legal report prepared by an Indian law firm.

---

7. Managers and Activities in IS

Different managers use Information Systems in different ways:

• Operational Managers: Use TPS and MIS for daily operations.

• Middle Managers: Use MIS and DSS for analysis and reporting.

• Top-Level Managers: Use EIS and DSS for strategic decisions.

Manager Level	Role	Information System Used
Operational Manager	Day-to-day tasks	TPS
Middle Manager	Planning and controlling operations	MIS, DSS
Top Manager	Strategic goals, long-term decisions	EIS, DSS

Activities include:

• •  Data collection and entry

  •  Information analysis and report generation

  •  Decision-making and strategy formulation

  •  Monitoring performance and feedback

---

8. Importance of IS in Decision-Making and Strategy Building

• IS helps managers and owners analyze business problems.

• Helps in forecasting future trends using past data.

• IS provides what-if analysis (e.g., What happens if price is increased by 10%?).

• Builds strategies like cost-cutting, expansion, new market entry.

• Example: Analyzing customer buying patterns to design marketing campaigns.

• • •  Provides timely and accurate information for decision-making.

  • •  Helps in identifying trends, risks, and opportunities.

  • •  Supports data-driven strategies for growth, innovation, and customer satisfaction.

  • •  Enhances coordination between departments and with stakeholders.

  • •  Enables real-time monitoring and performance evaluation.

---

9. Information Systems and Subsystems

• Just like our body has different systems (digestive, nervous), an IS has subsystems.

• Each subsystem has a specific role, but all work together.

Examples of Subsystems in IS:

• HR Subsystem: Handles employee data and payroll.

• Finance Subsystem: Tracks income and expenses.

• Sales Subsystem: Manages customer orders and delivery.

• Inventory Subsystem: Monitors stock levels and reordering.

All these come together to form one large enterprise system.

•  An Information System is a system of subsystems, each designed for a specific business function.

•  Subsystems can be:

• Functional: HR, Finance, Marketing, Operations

• Cross-functional: ERP integrates multiple functional subsystems

•  Subsystems interact to form a cohesive, enterprise-wide system that supports business goals.

Conclusion

• IT is about the technology itself (hardware + software).

• IS is a broader concept – it includes people, processes, and business goals.

• Together, they help companies run efficiently, make better decisions, and compete successfully in the market.

• IT is the technical foundation, IS is the organizational system using IT.

• Businesses rely on IS for efficiency, accuracy, and competitive advantage.

• Managers use different levels of IS for operational, tactical, and strategic decisions.

• IS consists of interconnected subsystems that work together for overall business success.

Info. Tech. Business Timetable

Information Technology for Business III BBA - A:  Classes - Course Plan

Class hours: 

Monday: 10.15-11.10 AM

Tuesday: 01.15-02.10 PM

Class Rep: Preetham Sylvester: 6360859903

Classes taken 

No        Date                     Topic

 1.       22.07.2025        Introduction to Information Technology for Business, Objectives, and Importance

2. 28.07.2025: understanding information technology, importance of IT, IT and business alignment strategy, impact of IT on business, what's IT,  Key concepts and terminology, real-world examples, IT strategy and business alignment, what is IT? components.

3. 29.07.2025: Definition of IT, Importance of IT in business, real-life examples, Introduction to Information Systems, five main components, differences between IT and IS, need for information systems in business

4. 04.08.2025:  Need for information systems in business, information systems in the enterprise,

5. 11.08.2025:  Impact of IT on business, managers and activities in IS, importance of IS in decision making and strategy building, information systems and subsystems

6. 12.08.2025: Subsystems of information system, TPS - features, advantages, disadvantages, role of TPS in the decision-making process, MIS - features, advantages, disadvantages, role of TPS in the decision-making process

7. 18.08.2025: DSS, GDSS meaning, features, process, advantages, disadvantages, role in decision making, summary

8. 19.08.2025: EIS, ES, meaning, features, process, advantages, disadvantages, role in decision making, summary

9. 01.09.2025: OAS meaning, features, process, advantages, disadvantages, role in decision making, summary

10. 02.09.2025: Overview of Module I and II, revision, short test, General introduction to Module III

11. 15.09.2025: 1st assessment questions and discussions, DBMS  

12.16.09.2025: Introduction to Database Management System, why businesses need databases, characteristics of DBMS, components of DBMS, Advantages of DBMS, Examples of business applications

13. 22.09.2025: Internal Assessment answer sheets, Inspiration video on Raul John

14. 23.09.2025: Gala 2025

15. 29.09.2025: Summary of DBMS, what is a database? Types of database models, differences between file management systems and DBMS, Applications of DBMS,

16. 30.09.2025: Summary of DBMS, Data models, components of data model, importance of data model, basic building blocks of data models.

17. 13.10.2025: Types of data models, commonly used types of data models, summary, Data warehousing, Definitions

18. 14.10.2025: Extractions, transformation, loading (ETL), why ETL is important, Characteristics of data warehouse, operational vs data warehouse systems, architecture of data warehouse, data warehouse components,  

19. 27.10.2025: Capacity building Program (Joshua)

20. 28.10.2025: Capacity building Program (Joshua)

21. 06.11.2025: Online Analytical Processing (OLAP), advantages/disadvantages of data warehousing, limitations, challenges, Future trends in data warehousing,  ETL Process, 

22. 10.11.2025: Introduction to MS Access, Create Database, Create Table, Adding Data, Forms in MS Access, Reports in MS Access

23. 11.11.2025: Data mining, steps in data mining process, Techniques of data mining, importance of data mining in business, examples of data mining applications, 

24. 13.11.2025: Lectio Brevis

25.  17.11.2025: MS Access, 

26.  18.11.2025: Revision

27. 09.12.2025: Question paper solving

ITB Course Syllabus

Name of the Program: Bachelor of Business Administration (BBA)

Name of the Course: Information Technology for Business
Course Code: BBA 5.6 (A) Vocational
Course Credits: 4 Credits
No. of Hours per Week: 4 Hrs.
Total No. of Teaching Hours: 56 Hrs.

Pedagogy: Classroom lecture, tutorials, Group discussion, Seminar, Case studies.

Course Outcomes: On successful completion Student will demonstrate;

• a) Understand the fundamentals of information technology
• b) Understand usage of information technology in business.
• c) Learn core concepts of computing and modern systems
• d) Applications of Excel and SQL.
• e) Awareness about latest information.

Syllabus

Module No. 1: Information Technology and Information System: 10 Hours

Introduction to IT, Introduction to IS, Difference be IS and IT, Need for Information System, Information Systems in the Enterprise, Impact of Information Technology on Business (Business Data Processing, Intra and Inter Organizational communication using network technology, Business process and Knowledge process outsourcing), Managers and Activities in IS, Importance of Information systems in decision making and strategy building, Information systems and subsystems.

Module No. 2: Subsystems of Information System: Hours - 12

Transaction Processing Systems (TPS), Management Information System (MIS), Decision Support Systems (DSS), Group Decision Support System (GDSS), Executive Information System (EIS), Expert System (ES), Features, Process, advantages and Disadvantages, Role of these systems in Decision making process.

Module No. 3: Database Management System: Hours - 14

Introduction to Data and Information, Database, Types of Database models, Introduction to DBMS, Difference between file management systems and DBMS, Advantages and Disadvantages of DBMS, Data warehousing, Data mining, Application of DBMS, Introduction to MS Access, Create Database, Create Table, Adding Data, Forms in MS Access, Reports in MS Access.

Module No. 4: Microsoft Excel in Business: 14 

Introduction to MS Excel, features of MS Excel, Cell reference, Format cells, Data Validation, Protecting Sheets, Data Analysis in Excel: Sort, Filter, Conditional Formatting, Preparing Charts, Pivot Table, What if Analysis (Goal Seek, Scenario manager), Financial Functions: NPV, PMT, PV, FV, Rate, IRR, DB, SLN ,SYD. Logical Functions: IF, AND, OR, Lookup Functions: V Lookup, H Lookup, Mathematical Functions, and Text Functions.

Module No. 5: Recent Trends in IT: Hours 05

Virtualization, Cloud computing, Grid Computing, Internet of Things, Green Marketing, Artificial Intelligence, Machine Learning.

Skill Development Activities:

1. Creating Database Tables in MS Access and Entering Data
2. Creating Forms in MS Access
3. Creating Reports in MS Access
4. Creating charts in Excel
5. What if analysis in Excel
6. Summarizing data using Pivot Table
7. VLookup and HLookup Functions
8. Rate of Interest Calculation using Financial Function
9. EMI calculation using Financial Function
10. Data Validation in Excel
11. Sort and Filter
12. Conditional Formatting in Excel.

Books for Reference:

1. Lauaon Kenneth & Landon Jane, "Management Information Systems: Managing the Digital firm", Eighth edition, PHI, 2004.

2. Uma G. Gupta, "Management Information Systems – A Management Prespective", Galgotia publications Pvt., Ltd., 1998.

3. Louis Rosenfel and Peter Morville, "Information Architecture for the World wide Web", O'Reilly Associates, 2002.

4. C.S.V.Murthy: Management Information Systems, HPH

5. Steven Alter, "Information Systems – A Management Perspective", Pearson Education, 2001.

6. Uma Gupta, "Information Systems – Success in 21st Century", Prentice Hall of India, 2000.

7. Robert G. Murdick, Joel E. Ross and James R. Claggett, "Information Systems for Modern Management", PHI, 1994.

8. Introduction to Database Systems, CJ Date, Pearson

9. Database Management Systems, Raghurama Krishnan, Johannes Gehrke, TATA McGraw Hill 3rd Edition.

10. The Database Systems – The Complete Book, H G Molina, J D Ullman, J Widom Pearson

11. Database Systems Design, Implementation, and Management, Peter Rob & Carlos Coronel 7th Edition.

12. Fundamentals of Database Systems, Elmasri Navrate Pearson Education

13. Introduction to Database Systems, C.J.Date Pearson Education

14. Microsoft Access 2013 Step by Step by Cox, Joyce, Lambert, Joan.

15. Excel 2019 All-In-One: Master the new features of Excel 2019 / Office 365 (English Edition) by Lokesh Lalwani

16. Microsoft Excel 2016 - Data Analysis and Business Modeling by Wayne L. Winston (Author)