IT COURSE OF STUDY DETAILS 

COURSE OF STUDY

CCA  / DCA / PGDCA /APGDCA

• MS-WORD
  • Description of MS-Office and  Introduction to MS- Word & its Concepts
    • What is Microsoft Office & MS-Word
    • Features of MS-Word & How to Start MS-Word
    • Parts of Ms-Word Screen with description.
    • The Basics of the word Window.
    • Using the Task pane
    • Saving a New file or documents
    • Backspace and Delete, Cut, Copy , Paste
    • Switching between applications
    • Splitting & Zooming
• Editing Ms-Word Documents & word proofing Tools
  • Change in View
  • Spell & Grammar Check
  • Using Auto Text.
  • Find & Replace
  • Auto correct
  • Using Thesaurus
  • Using word Count
• Text Formatting
  • Changing Font,  its size & its colour
  • Aligning text
  • Formatting Characters
  • Paragraph Formatting
  • Applying borders & shadings
  • The ruler, Indent Text
• Document Formatting
  • Page setup options
  • Page Breaks
  • Headers & Footers
  • Insert Page numbers
  • Setting up columns
  • Insert footnotes & endnotes.

• Using Wizards & Templates & creating Tables
  • Working with templates
  • Using Wizards
  • Working with Tables
  • Creating Graphs & charts
  • Create Text Box
  • Printing Envelopes
  • Printing Labels
  • Tracking changes
• Printing documents & working with Mail- Merge
  • Selecting Printer
  • Using Print Preview features
  • Printing a document
  • Using Mail-merge
  • Working with Graphics
  • Working with Web Pages
  • MS-EXCEL
    • INTRODUCTION TO MS-EXCEL & ITS CONCEPTS
      • What is Microsoft Excel?
      • Working with Spread Sheet
      • Feature of Spread Sheet
      • Advantages of Spread Sheet
      • Application of Spread Sheets
      • How to Start MS-Excel
      • Excel Window
      • Identifying Basic Parts of Spread Sheets
• USING WORKBOOK, ENTERING & EDITING DATA IN EXCEL
  • Creating Work Book
  • Opening a Workbook
  • Saving Workbooks
  • Closing a Workbook
  • Entering Data
  • Edit & Delete Data in Workbook
  • Inserting a Row & a column
  • Deleting a Row & a column
  • Naming the Cells
  • Switching between a Worksheet
• FORMATTING A WORKSHEET, WORKING WITHIN EXCEL
  • Working with Multiple Worksheets
  • Changing Column width and Row height
  • Text Alignment
  • Formatting Workbook
  • Appling colour and boarders to cells
  • Grouping Worksheets
  • Applying & Modifying Cell Format

• WORKING WITH EXCEL GRAPHIC AND CHART
  • Creating a Chart
  • Moving Chart
  • Deleting Chart
  • Resizing the chart
  • Editing Chart
  • Formatting Chart
  • Using Auto Filter
  • Sorting
  • What is Comments?
• FORMULA FUNCTION AND PRINTING WORKSHEETS
  • Operators
  • Order of Calculation
  • Cell Reference to Calculation
  • Entering a Formula
  • Editing a Formula
  • Displaying a Formula
  • Entering a Function
  • Defining Page Setup options
  • Print Management 
• OBJECT LINKING AND EMBEDING
  • Object Linking & Embedding (OLE) Concept
  • Linking Worksheet and Workbooks in Excel
  • Embedding Data in worksheets
  • Inserting Hyperlink
  • Creating New Workbooks from Templates

• MS-POWER POINT
  • INTRODUCTION TO MS-POWER POINT
    • What is Power Point?
    • Uses of Ms-Power point
    • Features of Power Point
    • Starting Power Point
    • Standard, Formatting and Drawing

• WORKING WITH TEXT, CHARTS & DRAWING OBJECTS
  • Creating a Blank Presentation
  • Creating a Title Slide
  • Inserting a Slide by Slide Layout
  • Power Point Views
  • Applying a Design Template
  • Numbering the Slides
  • Saving a Presentation
  • Formatting Text

• WORKING WITH SLIDES, HANDOUTS AND MASTER FOR PRESENTATION
  • Adding a Picture, Clip Art /Image
  • Adding a Table  / Chart
  • Adding a Word Art to the Presentation
  • Slide Animation
  • Creating a Slide Master
  • Spell Check
  • Adding Transition
  • Formatting a Text Box
  • Customizing Slide Design
  • Compressing Pictures
  • Grouping & Ungrouping Objects

• PRINTING & DELIVERING PRESENTATIONS
  • Setting up Pages
  • Printing Presentation
  • Power Point Inserting Sound Effects
  • Power Point Packaging

• NETWORKING & INTERNET BASIC
  • INTRODUCTION, KEY CONCEPT AND FEATURES OF INTERNET
    • What is Internet / The World Wide Web
• INTERNET PROTOCOLS & COMMUNICATION PROTOCOLS
  • Internet Protocol(IP)
  • Communication Protocols
• ADVANTAGES OF INTERNET, CONNECTING TO INTERNET
  • Modem / Browsers / ISPs
  • Types of Internet Access
  • Surfing Strategies
  • Internet Fault Finding
• UNDERSTANDING URL CONCEPTS, INTERNET SERVICE PROVIDERS
  • Understanding URL Concepts
  • Working with Internet Explorer
• HARDWARE & SOFTWARE PERQUISITES FOR INTERNET
  • Hardware Requirement
  • Software Requirement
  • Password Protection
  • Internet Cookies
  • Firewalls & Antivirus
• TCP/IP CONNECTION
  • What is E-mail?
  • Creating an E-mail ID
  • Forward & Reply of Mail
• SEARCHING INFORMATION ON INTERNET OR BROWSING DIFFERENT WEBSITE.
  • Searching Information
  • Searching the Web