IT APPLICATION -I

Syllabus

BBA106

IT Application–I

Unit 1: IT for Business Intelligence (8 Hours)

Data and Information; Concepts of CPU, Memory and Storage Devices; System and Application Software; Fundamentals of Database and Data Warehouse; Working of Internet, Intranet and Extranet; Concept of Business Intelligence and Power of Data; Salient Features of MS Office Software, Power BI and Tableau. Introduction of AI and ML.

Unit 2: MS Word (8 Hours)

Salient Features of MS Word; Use of Templates; Working with Word Document: Editing Text, Finding and Replacing Text, Spell Check, Autocorrect, Bullets & Numbering, Tabs, Paragraph Formatting, Indent, Page Formatting, Header, and Footer; Inserting and Formatting a Table; Inserting Pictures and Video;
Suing Mail-Merge; Linking Databases and Spreadsheet Files; Printing and Protecting Documents.

Unit 3: MS PowerPoint (8 Hours)

Concepts and Criteria for Effective Presentation; Use of Templates and Design; Working with Presentations: Slides, Fonts, Drawing, Editing; Inserting: Tables, Images, Texts, Symbols, Hyperlinking and Media; Transition, Animation, and Slideshow.

Unit 4: Basics of MS Excel (8 Hours)

Characteristics of Spreadsheet; Managing Worksheets: Formatting, Conditional Formatting, Entering Data, and Editing; Printing and Protecting Worksheets; Handling Operators in Formulas; Working with Multiple Worksheets; Controlling Worksheet Views, Naming Cells and Cell Ranges. Customize Options and Views for Worksheets and Workbooks: Hide or Unhide Worksheets, Hide or Unhide Columns and Rows, Customize the Quick Access Toolbar, and Modify Document Properties.

Unit 5: Data Management and Charts in MS Excel (8 Hours)

Concept of Data and Data Management; Creating an Excel Table from a Cell Range; Converting a Table to a Cell Range; Add or Remove Table Rows and Columns; Manage Table Styles and Options; Apply Styles to Tables; Filter Records; Sort Data by Multiple Columns; Change Sort Order; Remove Duplicate Records; Working with Different Types of Charts of MS Excel and Using Various Options.