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 | |