Information Technology for Business (Excel & DBMS) Bangalore University BBA 5th Semester NEP Notes

16/11/2023 1 By indiafreenotes
Unit 1 [Book]
Introduction to IT, Introduction to IS, Difference be IS and IT, Need for Information System VIEW
Information Systems in the Enterprise VIEW
Impact of Information Technology on Business: VIEW
Business Data Processing VIEW
Intra and Inter Organizational communication using network technology VIEW
Business Process Outsourcing and Knowledge Process Outsourcing VIEW
Managers and Activities in Information Systems VIEW
Importance of Information systems in Decision making and Strategy building VIEW
Information systems and Subsystems VIEW


Unit 2 [Book]
Transaction Processing Systems (TPS)  Features, Process, Advantages and Disadvantages, Role in Decision making process VIEW
Management Information System (MIS) VIEW
Decision Support Systems (DSS) VIEW
Group Decision Support System (GDSS) VIEW
Executive Information System (EIS) VIEW
Expert System (ES) VIEW


Unit 3 [Book]
Introduction to Data and Information, Database, Types of Database Models VIEW
Introduction to DBMS, Advantages and Disadvantages of DBMS, Application of DBMS VIEW
Difference between File Management Systems and DBMS VIEW
Data Warehousing VIEW
Data Mining VIEW
MS Access, Create Database, Create Table, Adding Data, Forms in MS Access, Reports in MS Access VIEW


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


Unit 5 [Book]
Virtualization VIEW
Cloud computing VIEW
Grid Computing VIEW
Internet of Things VIEW
Green Marketing VIEW
Artificial Intelligence VIEW VIEW
Machine Learning VIEW