DIPLOMA IN COMPUTER APPLICATION (DCA) ( M-OO2 )

DCA 

MS-Word:

1 Creating a new word document 2 Opening an existing document 3 Editing and Saving a document 4 Typing a text, deleting, inserting, finding, replacing, copying and moving text 5 Justifying texts 6 Bold, Italics, Underline, Strike, Double Strike and Colouring text 7 Selecting Font and Font Sizes 8 Formatting page, margins, page size, portrait and landscape 9 Inserting symbols, pictures 10 Using Bullets 11 Using and manipulating tables, inserting / deleting of rows and columns 12 Sorting tables 13 Using Header and footer, Inserting Page number 14 Changing character width and line spacing 15 Printing of a document, Using print preview 16 Copy / moving text between two different documents 

 MS-EXCEL:

BASICS 1 Creating a new excel workbook 2 Creating an excel worksheet 3 Entering values into worksheet 4 Modifying values in the worksheet 5 Copy and paste values in the worksheet 6 Find and replace values in the worksheet 7 Formulas in worksheet 8 Delete a worksheet 9 Data filtering 10 Data sorting 11 Using ranges 12 Data validation 13 Using styles 14 Using themes 15 Using templates 16 Using macros 17 Adding graphics 18 Cross referencing 19 Printing worksheets 20 Translate worksheet 21 Email workbooks 22 Workbook security 23 Data tables 24 Pivot tables  25 Keyboard shortcuts 26 Zoom in out 27 Special symbols 28 Insert comments 29 Adding textbox 30 Undo changes 31 Setting cell type 32 Setting fonts 33 Text decoration 34 Rotate cells 35 Setting colours 36 Text alignment 37 Merge and wrap 38 Borders and shades Formatting A Worksheet 39 Applying formatting to a worksheet 40 Adjusting margins in a worksheet 41 Page orientation in a worksheet 42 Page orientation in a worksheet 43 Setting header and footer in a worksheet 44 Inserting page breaks in a worksheet 45 Setting background in a worksheet 46 Freeze panes 47 Conditional formatting Working with Graphs 48 Creating a chart 49 Manipulating a chart

MS-POWERPOINT:

The Basics 1 What is Power point 2 Working with Slides 3 Working with Textboxes 4 Rearranging slides 5 Working with slide notes 6 Working with sections 7 Working with outlines 8 Sidebars in power point 9 Presentation views 10 Setting presentation background Editing Presentation 11 Cut And Paste Operations 12 Copy And Paste Operations 13 Find And Replace Operations 14 Edit PowerPoint Presentation 15 Content Translation  16 Set Language Type 17 Duplicating Content 18 Special Characters 19 Slides Zoom in-out Formatting Presentation 20 Font Management And Text Decoration 21 Paragraph Indentation 22 Set line spacing 23 Borders and Shading 24 Using slide master 25 How to create a design template Adding Multimedia To The Presentation 26 add,edit,format picture in a slide 27 How to add a screenshot to a slide 28 How to add shapes to a slide 29 How to edit shapes to a slide 30 How to format added shapes to a slide 31 How to add text to shapes in a slide 32 How do I arrange shapes and pictures on a slide 33 How to group and ungroup objects 34 How to Add audio and video to the slide 35 Working with tables in a slide 36 Working with charts on a slide 37 How to Add and format smart art on the slide 38 How to Add and preview animations on the slide 39 How to Add and preview transitions on the slide Sharing A Presentation 40 How To Convert PowerPoint to PDF 41 How To Convert PowerPoint to Video 42 How To Create an Image From PowerPoint 43 How To Print a PowerPoint 44 How To Broadcast PowerPoint presentation

Eligibility :

1) 10th passed

2) 12th passed