CA 114 : Office Management Tools

1. Elements of ICT
1.1 Definition of ICT
1.2 Applications of ICT
1.3 Impact of ICT in business
1.4 Communication tools - Email, chatting, Social Networking, video conferencing
1.5 Different ICT Tools

2. Word Processing
2.1 Introduction to Office Automation Suites
2.2 Components of MS-Office
2.3 Features of MS-Office 2010
2.4 Interface of MS-Word 2010
2.5 Text Formatting, Paragraph Formatting, Page Formatting
2.6 Header & Footers
2.7 Working with Graphics and Pictures, Symbols
2.8 Working with Tables
2.9 Multicolumn News Letter, Smart Art, Spell Check
2.8 Mail Merge

3. Working with Excel 2010
3.1 Introduction to Worksheets and Workbooks
3.2 Working with Worksheet - Inserting, Deleting, Rename
3.3 Wrap Text, Merge & Center
3.4 Inserting and Deleting Rows and Columns
3.5 Format - Row Height, Column Width, Auto-fit, Hide/Unhide
3.6 Working with Data – Sorting, Filter, Conditional formatting
3.7 Page Formatting – Margin, Orientation, Size, Print Area, Break
3.8 Inbuilt Functions
3.9 Basic functions – SUM, COUNT, AVERAGE, MIN, MAX
3.10 Advanced functions: UPPER, LOWER, TRIM, LEN, IF… condition, Remove duplicates
3.11 Creating and Working with Charts


4. Working with PowerPoint Presentation 2010
4.1 Introduction to Power Point
4.2 Applying Themes and Layouts
4.3 Working with Objects, Entering, Editing, and Formatting Text
4.4 Inserting Pictures, Graphics, Shapes, Charts and SmartArt
4.5 Adding Sound and Video
4.6 Adding Transitions Effects and Animation
4.7 Normal view, Slide