Windows Vista

• Starting & Shutting down Windows
  
•  Introduction to AERO


• Introduction to Desktop area, Task Bar, Start Button & My Computer


• File & Folder Management using Explorer covering topics like Copying, Moving, Removing Files & Folders


• Restoring Removed Files & Folders using Recycle Bin


• Creating shortcuts


• Configuring Windows using Control Panel


• Using Accessories like Paint Brush, Calculator, Word Pad etc.


• Accessing other computers on a Network



MS Word 2007

• Formatting a document


• Using Tables


• Mail merge


• Using Templates


• Applying Themes


• Inserting Images


• Cover page Designing


• Using Bookmarks


• Page setup & Printing


• Creating Table of Contents (TOC)


• Real Time Examples like Challan, Invoice, Production Job Card etc.

MS Excel 2007

• Understanding Labels, Values & Formulas


• Using Functions like SUM(), AVERAGE(), MAX(), MIN(), INT(), COUNT(), MOD(), IF(), AND(), OR(), CONCATENATE(), RANK() etc.


• Cell Formatting & Conditional Formatting


• Pivot Table & Chart


• Changing Column / Row Height & Width


• Sorting & Filtering Data


• Creating Charts (Graphs)


• Page setup & Printing


• Protecting Workbook & Worksheet


• Programming Macros


• Real Time Examples like Salary Sheet, Mark Sheet, Bank Book, Sales Register with Tax Calculations, Interest Calculation Stock Register etc.

Power Point 2007

•  Creating slides
  


•  Slide Designs
  


•  Slide Layouts
  


•  Slide Transition
  


•  Changing Backgrounds
  
•  Inserting Images & Objects
  


•  Applying Animation
  


• Custom slide show and Printing

Access 2007

•  Working with Tables
  


•  Queries
  


•  Forms
  


•  Reports
  


•  Linking Tables using Relations
  


• Database Security
  

Internet Concepts

•  Using Internet Explorer
  
•  Search Engine
  


•  Using Web Based E-Mails
  


•  e-commerce

Outlook 2007

•  Using POP3 Mail
  


•  Creating Appointments
  


•  Recurring Appointments
  


•  Recurring Event
  


•  Recurring Meeting
  


•  Tasks
  


•  Setting Reminders

Theory

•  Information technology, the internet, and you
  
•  The Internet, the web and e-commerce
  
•  Basic application software
  
•  Specialized Application Software
  
•  System software
  
•  System Unit (Hardware)
  
•  Input & Output
  
•  Secondary storage
  
•  Communication & Networks  

Period:
72 Hrs Practical 27 Hrs Theory