COMPUTER APPLICATIONS FOR BUSINESS

Course Outcome:
After completion of course students will be able to:
1. Demonstrate computer applications
2. Make use of Ms-Office for business applications.
3. Organize data using MS-Excel
4. Analyze and Visualize business data using Ms-Excel.
5. Create interactive presentations and documents.


Syllabus Contents:
Unit 1
MS-Word and PowerPoint:
MS-Word-Word Processing: Introduction to MS Office components, Introduction and working with MS Word, Word basic commands Formatting Documents- Setting Font style, alignment, Indent, paragraph setting, page setting, and document style.
Tables- Creating and formatting table, Border setting, Merging, Splitting, Sorting, Insertion and deletion of row column.
Tools: Word completion, spell check, Mail merge, Macros, Temples, using wizards document security,
Drawing: Inserting picture, drawing, formatting picture, grouping, ordering, and rotating picture.

Unit 2
Ms-PowerPoint: Creating presentation, using templates, setting presentation layout.
Formatting Presentation: Adding style, management objet, header & footer, slide background, slide layout.
Graphics and Effects: Inserting, drawing pictures, setting animation & transition effect, Adding multimedia files to presentation.

Unit 3
Ms-Excel:
Introduction to spreadsheet, sorting, filtering of data, Relative reference, absolute reference and mixed reference formula, editing formula, Naming cell and range. Formatting Worksheet: Assigning and removing formats, using auto formats, custom formats, custom borders, controlling column height and width.
Analysing Data: Entering Functions in worksheet, Mathematical functions, text functions, logical functions, and financial functions.

Unit 4
Statistical Analysis: Average, Median, Min, Max, Median, Mode, Standard deviation, variance, percentile function, quartile function COUNT, COUNTA, COUNTIF, COUNTBLANK , SUM, SUMIF. What-If-Analysis, Goal Seek,
Solver, Scenario Manager, Pivot table, Pivot Chart. Data Visualization: Introduction to data visualization, Basic Charts in Excel, Creating Embedded charts, Creating charts and chart sheet. Different types of charts.

Skill Level: Beginner