Syllabus
|
Course Code: BCA-102 Course Name: OFFICE AUTOMATION- I |
||
| MODULE NO / UNIT | COURSE SYLLABUS CONTENTS OF MODULE | NOTES |
|---|---|---|
| 1 | Word Processing Basics: Creating, Formatting and Editing a Word Document: Word Wrap, Spelling and Grammar Check, Formatting Text and Paragraph, Paragraph Indents, Inserting and Formatting a Picture/ Clip Art in a Word document, Smart Art, Wrap Text around Images, Adding Effect to Images, Inserting Symbols and Equations, Document, Bullet and Numbered List, Find and Replace, Page Setup. | |
| 2 | Advance Features of Word Processing: Formatting Tables, Align Cell Text, Merge Cell, Text Directions, Adding a Chart and Chart Styles, using and Making Templates, Mail- Merge, Add to Dictionary, Treasures, Character Map, Headers and Footers, Page Numbering, Page Borders, Creating Columns, Creating and Dropping Comments, Watermark. | |
| 3 | Excel Basics: About Ribbon Menus, Creating & Editing Worksheet, Use of Various Data Types, Text Orientation, Formatting Spreadsheet: Cell Alignment and Border, Freeze Panes, Conditional Formatting, Using Formulas and Functions, VLookup, Cell Referencing, Page Setup, Page Options, Customizing Margins, Headers and Footers, Print Options, Print Formulas. | |
| 4 | Excel Advance Features: Transferring Data to and From Non Worksheet Files, Database Handling, Adding, Formatting and Customising Chart, Change Chart Type, Sorting Data, Use of Filters, Data Analysis with Goal Seek and Scenario Manager, Creating Scenario, Creating Pivot Tables, Using Slicers, Pivot Chart, Creating a Drop Down List, Locking Cells, Using Multiple Workbooks. | |
