Regular and Diploma Packages

DAYS

CONTENTS

              DAY-1

Introduction Of Computers, Parts of computers, Keyboard Keys, Mouse Operations.

              DAY-2

Hardware and Software, Types of Software’s, Explanation about Folder and File. How to Create a Folder and Saving the Files

              DAY-3

Introduction of Ms-Office, Introduction Of Ms-word and how to Save the File.

1.       Home:- Clipboard, Font, Paragraph, Styles.

              DAY-4

        Home:- Editing which contains Find, Replace, Go to, Select.

2.       Insert:- Pages, Table, Table Tools.

              DAY-5

       Insert:-Illustrations which contains how to keep Pictures, ClipArt and    

       Picture Tools, How to Insert Shapes and its Drawing Tools.

              DAY-6

       Insert:- How to insert Smart Art and Its Smart Art Tools, Text which   

       contains Text Box, WordArt, Quick Parts, Drop Cap, Date and Time,

       Object.

              DAY-7

        Insert:-Symbols and Equations, Hyperlink and Bookmark, Header and

        Footer and its Header and Footer Tools, Page numbers.

              DAY-8

3.       Page Layout:- Page Setup, Page Background which contains Watermark, Page Color, Page Border, Paragraph which contains Indent and Spacing.

              DAY-9

4.       References:- Table of Contents, Captions, Footnotes

              DAY-10

5.       Mailings:-  Mail Merging

             DAY-11

6.       Review: – Proofing which contains Spellings and Grammar Check, Thesaurus, Word Count, Translate, Research, Comments, Protect Document and also Locking the Document with Password.

             DAY-12

7.       View:- Document Views, Show/Hide, Zoom, Window, Macros

             DAY-13

 Introduction Of MS-Power Point and how to save the Power Point File.

1.       Home:- Slides, Drawing, Font, Paragraph

2.       Insert:- Text, Media Clips

3.       Design:- Themes, Background, Page Setup

DAY-14

4.       Animations:- Custom Animations, Transition to the Slide, Advanced Slide

5.       Slide Show:- Start Slide Show, Setup

6.       Review:- Protect Presentation, Show Markup

7.       View:- Presentation View, Zoom, Color or Gray Scale

DAY-15

Introduction Of MS-Excel, How to Save the MS-Excel File.

1.  Fill Handle Operations, Cell Reference, Cell Reference Formulas.

DAY-16

1. Home: – Alignment, Insert Cells, Delete Cells, and Format Cells.
2. Excel Functions: – Sum, Product, MIN, MAX.

DAY-17

1. Excel Functions:- Average, Count
2. Home:- Editing which contains Auto Sum, Fill, Clear, Sort and Filter
3. Home:- Styles Which contains Conditional Formatting, Cell Styles, Format as Table

DAY-18

1. Excel Functions: – Network Days, Days 360, Now, Today.
2. Home:- Number
3. Insert:- Chart and Chart Tools

DAY-19

1. Page Layout: – Page Setup, Scale to Fit, Sheet Options.
2. Excel Functions:- IF condition

DAY-20

1. Excel Functions:- Sum If, Count If, Average If
2. Formulas:- Formula Auditing

DAY-21

1. Data:- Get External Data, Data Tools which contains Data Validation, Text to Columns, Remove Duplicates, Text to Columns

DAY-22

1. Review:- Protect Sheet
2. Few Excel Functions

DAY-23

1. View:- Workbook views, Freeze Panes, Save Work Space
2. Few Excel Functions

DAY-24

Introduction of Internet, Creating user account, with Password, Changing the wall Paper, Applying Screen Saver, How to Browse in internet, How to do online Transactions, How to Copy the Data From Internet.

DAY-25

How to Create Email-ID, how to send mails, how to check mails, How to download software’s and files. How to copy the data into Pen Drive, How to take the Print