Computer Education
MS-CIT & TCP (Tally Certified Professional)
Computer Basics, MS Office & Tally Training

Home


q

MAHARASHTRA  STATE
CERTIFICATE  IN INFORMATION  TECHNOLOGY

1

Office

2007


w
1

Word 2007

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

 

2
Excel 2007

p
Power Point 2007

i
Access 2007


2
Outlook 2007


2
Internet Explorer