IT Applications in Business-Lab

Course Objective: This course aims to develop proficiency in using essential office productivity tools including MS Word, MS Excel, and MS PowerPoint, enabling students to create professional documents, perform data analysis, and design effective presentations.

Course Outcomes: Upon completion of this course, students will be able to:

CO1. Operate Windows environment and manage files using essential system commands CO2. Create and format documents using MS Word for professional and academic use CO3. Utilize MS Excel functions for data entry, analysis, and visualization CO4. Design engaging presentations using MS PowerPoint with appropriate animations and formatting This Lab would be based on the course BBA-DM 113: IT Applications in Business

1. Knowledge of all commands of using Windows to be taught.

2. Introduction to MS-Word:

Introduction to Word Processing, it's Features, Formatting Documents, Paragraph Formatting, Indents, Page Formatting, Header and Footer, Bullets and Numbering, Tabs, Tables, Formatting the Tables, Finding and Replacing Text, Mail Merging etc.

3. Introduction to MS-Excel:

Introduction to Electronic Spreadsheets, Entering Data, Entering Series, Editing Data, Cell Referencing, ranges, Formulae, Functions, Auto Sum, Copying Formula, Formatting Data Creating Tables, Graphs and charts, Creating Database, Sorting Data, Filtering etc. Mathematical functions, Statistical functions, date and time functions, Text functions, financial functions, Analyze data with Pivot tables, create and manage scenarios and summaries.

4. Introduction to MS PowerPoint:

PowerPoint, Features of MS PowerPoint Clipping, Slide Animation, Slide Shows, Formatting etc.