Computer Basic Course


  Contents

    Module 1: Basic Computer Concepts

    Module 2: Microsoft Word

    Module 2: Microsoft Excel

    Module 3: Microsoft PowerPoint

Basic Computer Concepts

     Introduction

  • What is a Computer?
  • Software and Hardware
  • Hardware Components
  • Hardware Accessories
  • Operating System Software
  • Software Applications
Working with Computers
  • Computer Terminology
  • Starting and Stopping the Computer
  • Using the Mouse
  • Computer Tools & Utilities
  • Disk Utilities
  • Files & Directories
  • Manipulating Files & Folders
  • Working with the Windows Environment
  • Internet
  • E-Mail
  • Browsers, E-Mail Clients


Microsoft Word

    Introduction

  • Introduction to MS-Word
  • Menus
  • Shortcuts
  • Document types
Working with Documents

  • Opening Files – New & Existing
  • Saving Files
  • Formatting page and Setting Margins
  • Converting files to different formats
  • Importing
  • Exporting
  • Sending files to others
  • Editing text documents
  • Inserting
  • Deleting
  • Cut, Copy, paste
  • Undo, Redo
  • Find, Search, Replace
  • Using Tool bars, Ruler
  • Using Icons
  • Using help

 Formatting Documents  

  • Setting Font Styles
  • Font selection – style, size, color etc.,
  • Type face – Bold Italic, underline
  • Case settings
  • Highlighting
  • Special symbols
  • Setting Paragraph style
  • Alignments
  • Indents
  • Line space
  • Margins
  • Bullets and Numbering
  • Setting Page Style
  • Formatting
  • Border& Shading
  • Columns
  • Header & footer
  • Setting Footnotes
  • Inserting manual Page break, Column break and line break.
  Creating sections and frames

    • Inserting Clip arts, pictures, and other files
    • Anchoring & Wrapping
    • Setting Document Styles
    • Table of Contents
    • Index
    • Page Numbering, data &Time, Author etc.,
    • Creating Master Documents
    • Web page

               Creating Tables

    • Table settings
    • Borders
    • Alignments
    • Insertion, deletion
    • Merging
    • Splitting
    • Sorting
    • Formulas

     Drawing

    • Inserting Pictures/Files etc.,
    • Drawing Pictures
    • Formatting &Editing pictures
    • Grouping and ordering
    • Rotating

              Tools

    • Word Completion
    • Spell Checks
    •  Macros
    • Mail merge
    • Templates
    • Using Wizards
    • Tracking Changes
    • Security

    Microsoft Excel

       Introduction

    • Spreadsheet & its Applications
    • Opening spreadsheet
    • Menus & Toolbars & icons
    • Shortcuts
    • Using help
    • Shortcuts

    Working with Spreadsheets

    • Opening a File
    • Saving Files
    • Setting Margins
    • Converting files to different formats
    • Importing, Exporting and Sending files to others
    • Spreadsheet addressing
    • Rows, Columns & Cells,
    • Referring cells and Selecting cells
    • Entering and Editing Data
    • Entering Data
    • Cut, Copy, paste, Undo, Redo, Find, Search & Replace
    • Filling continuous rows, columns
    • Inserting - Data, cells, column, rows & sheets
    • Manual breaks
    • Computing data
    • Setting Formula
    • Finding total in a column or row
    • Mathematical operations (Addition, Subtraction, Multiplication, Division, Exponentiation)
    • Using other Formulas

    Formatting Spreadsheets

    • Formatting – Cell, row, column & Sheet
    • Alignment, Font, Border &shading
    • Highlighting values
    • Hiding/Locking Cells
    • Worksheet
    • Sheet Name
    • Rows& Columns Headers
    • Row Height, Column Width
    • Visibility – Row, Column, Sheet
    • Security
    • Formatting – worksheet
    • Sheet Formatting & style - (Background, color , Borders & shadingm) 
    • Anchoring objects
    • Formatting layout for Graphics, Clip art etc.,

     Working with sheets

    • Sorting
    • Filtering
    • Validation
    • Consolidation
    • Subtotal
    • Creating Charts
    • Selecting charts
    • Formatting charts, label, scaling etc.

     Using Tools

    • Error Checking
    • Spell Checks
    • Macros
    • Formula Auditing
    • Creating & using Templates
    • Tracking Changes
    • Customization
    • Printing worksheet

     Microsoft PowerPoint

    Introduction

    • Opening new Presentation
    • Different presentation templates
    • Setting backgrounds
    • Selecting presentation layouts

    Creating a presentation

    • Setting presentation style
    • Adding Text to the presentation
    • Formatting a presentation
    • Adding style
    • Color, gradient fills
    • Arranging objects
    • Adding Header & Footer
    • Slide Background
    • Slide layout
    • Adding Graphics to the presentation
    • Inserting pictures, movies, tables, etc into the presentation
    • Drawing Pictures using Draw

    Adding effects to the presentation

    • Setting Animation & transition effect
    • Adding audio and video
    • Printing Handouts
    • Generating standalone presentation viewer

    No comments:

    Post a Comment