IT Application in Business

Syllabus

Course Code: BBA 109

IT Applications in Business

Unit I                                                                                                 8 Hours

Basics of Information Technology: Components of IT Systems, Characteristics of Computers, Input-Output Devices (Hardware, Software, Human Ware and Firmware), Classification of Computers. Computer Memory: Types of Memory, Storage Devices, Mass Storage Systems. Concept of Cloud Computing.

Unit II                                                                                             10 Hours

Computer Software: Types of Software. Application Software and their uses. Database Concepts. Introduction to Operating System, Need, Functions and Types of Operating Systems. Introduction to GUI. Compiler, Interpreter and Assembler, Types of Computer Languages.

Unit III                                                                                            12 Hours

Desktop Components: Introduction to Word Processor, Presentation Software.

Advanced Excel: Introduction, Features, Applications and Advanced Functions of Excel, Creating Tables, Graphs and Charts, Table Formatting, Worksheets Management, Sort and Filters tools, Subtotal, Mathematical Functions, Statistical Functions, Date and Time Functions, Text Functions, Financial Functions, Analyze Data with Pivot Tables, Create and Manage Scenarios and Summaries.

Unit IV                                                                                            12 Hours

Computer Networks and IT Application: Data Communication Concepts, Types of Communication Media, Concepts of Computer Networks, Internet, Intranet, Extranet, Network Topologies, Networking Devices, OSI Model. Internet Services.

Information Technology and Society: Application of Information Technology in Railways, Airlines, Banking, Online Banking System, Insurance, Inventory Control, Financial Systems, Hotel Management, Education, entertainment and health, Security Issues in Information Technology.