Information Technology for Business (Excel & DBMS) Bangalore University BBA 5th Semester NEP Notes
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 |