This course has been designed to introduce the students to applications of computers to manage different operation of organizations. It provides them an opportunity to study the hands-on implementation of different technologies in corporate environment.
Information & System Concepts-Introduction --Concepts, Classification of Information, Methods of Data & Information Collection, Value of Information, Organization and Information, System: A Definition. Types of Systems, System Decomposition, Integration of Sub Systems, Current trends in information Technology ,International Business and IT.
Management Information System-MIS: Definition, Nature & Scope, MIS Characteristics, Functions, Structure of MIS, Role of MIS, MIS as a Control System, Process of Management, Application of MIS, ERP & IT’s Benefits.
Internet-Introduction to Internet, wire less network, Internet Tools & Services, www, Internet in India, Security, Web Browser, client & server on the web, search engines, Future of Internet, E-Commerce an Introduction, E-Business Fundamentals.
Security Issues : Information Technology Act ,cyber Laws, Security Issues: Viruses, Worms and other creatures, IT issues for Management, Criteria of investment in hardware & software , role of changing world of Information.
Various Tools & Functions: Filling series fill with drag, data sort, Formatting worksheet, Functions and its parts, Some useful Functions in spreadsheet (SUM, AVERAGE, COUNT, MAX, MIN, IF), What if analysis, Cell referencing (Relative, Absolute, Mixed), Renaming sheet, Printing worksheet.
Advance Spread-Sheet Tools- Goal seek, solver, Finance Functions & advance Auto Filter, V look up, H-look up, Scenario, Sub-total, Macro, Protection.
Suggested Readings:
Case study of MIS /Access for any application system in the organizations.