Courses

MS-CIT

Maharashtra State Certificate in Information Technology

(Examination & Certificate by MKCL & MSBTE)

PRACTICAL SYLLABUS

• Computer Fundamental  
• Windows Fundamental
• Windows 7 OS
• MS-Word 2010
• MS-Excel 2010
• MS-PowerPoint 2010
• MS-Outlook 2010
• Internet

THEORY SYLLABUS

• nformation Technology
• Internet, Web & E-Commerce
• System Software
• System Unit
• Input & Output Devices
• Secondary Storage

Note : Every Students enrolled for MS-CIT have to score minimum 20 marks in ERA for appearing final online exam.

Advanced Excel-2010

• Formatting a Spreadsheet
• Formulas and Functions
• Logical functions (IF, AND,...)
• Date, Time & Math. Formulas
• Hlookup and Vlookup
• Finance Formulas
• Pivot Tables & Charts
• Page setup
• Printing
• Data Validations
• Conditional Formatting
• Sorting and Filtering Data
• Working with MIS Reports
• Macros

Accounting Course Tally ERP 9.00 & Xepert Tally ERP 9.00

Tally ERP 9.00

Basic Accounting

• What is Book Keeping & an Accounts ?
• Golden rules of Accounting
• Accounting Groups
• Introduction to Tally
• Uses & Adv. of Tally

Account Finalization

• Balance Sheet  & Trial Balance
• Profit and Loss a/c

Inventory

• Stock Items & Stock Category
• Stock Group  
• Purchase Order & Sales Order
• Price List & Bill of Material
• Discount & Stock Journal
• Rejection in & out

Taxation

• TCS, TDS, VAT & GST
• Service Tax, CST & Payroll 

Data Recording

• Company Creation & Security
• Ledgers & Groups
• Vouchers (Purchase, Sales)
• Vouchers (Receipt, Payment) 
• Vouchers (Contra, Journal)

Printing Concepts

• Printing of Voucher & Printing Reports
• Printing Inventory Reports

Xepert Tally ERP 9.00

Book - 1 (Learning Tally.ERP 9)

Basic of Accounting

• Business Organisation
• Creating Account & Inventory Masters
• Taxes & Payroll Theory

Book - 2 (Basic Accounting in Tally.ERP)

• Basic Accounting (Manual)
• Starting Tally.ERP 9
• Recording Transactions
• Depreciation & Provisions 

Book - 3 (Adv. Accounting & Inventory)

• Inventory & Invoicing
• Interest Calculation
• Bank Reconciliation & Check Printing)
• Multiple Currency
• Integrate Accounts & Inventory

Book - 4 (Adv. Inventory & MIS)

• Order Processing - Purchase / Sales 
• Receipt Note, Delivery Note, Return
• Recorder Lever Monitoring
• Manufacturing Voucher Type
• Cost Center, Categories
• Job Costing, POS (Point of Sales)
• Multiple Mailing Details & Logo Printing
• Budget & Control
• Option Voucher, Scenario Management

Book - 5 (Taxation in Tally.ERP 9)

• VAT (Value Added Tax)
• CST (Central Sales Tax)
• TDS (Tax Deducted at Service) 
• Excise for Dealers & Manufactures 

Book - 6 (Payroll & Tally  Technology)

• Payroll, Printing Reports & Documents
• Exporting Data & Reports 
• Backup & Restore of Data
• Multi Lingual Tally.ERP 9
• Installation & Licensing

Graphic Design

Photoshop

• Basics of Photoshop 
• The Working Place
• Image & Color Modifications
• Tools, Using the Brush and Paint
• Photo Mixing & Text Effects
• Working with Selections
• Scaling, Knowing the Layers
• Getting Creative with Types
• Masks & Filter Gallery
• Playing with Palettes
• Color Adjustments

Corel Draw

• Introduction to CorelDRAW
• Page layout settings
• Convert to curves tools
• Blending Effects, Shaping & Lens
• Rollover & Power clip
• Tracing images
• Making logos & Cartoons
• Attractive Brochure Designs
• Visiting card Designs
• Banners & Hoarding Designs
• Import & Export

Adobe Illustrator

• Basics of Illustrator 
• The Working Place
• Tools
• Knowing the Layers
• Pen, Pencils and Paths
• Using the Brush and Paint
• Specialized Tools
• Getting Creative with Types
• Using the Symbols
• Designing Graphics
• Effects and Filters
• Playing with Palettes
• Output, Exporting

Adobe InDesign

• Basics of InDesign
• Tools & Control
• Customizing Option
• Object & Tables

Computer Typing (Marathi & Hindi) 

Project

Web Design

HTML

• Introduction
• Tags, Marquee behaviors 
• Horizontal Rule, Headings
• Font effects, Bullets & Numbering
• Image mapping, Table properties
• Web page linking
• Image and Table linking, Form

CSS

• Controls & Structure
• Functions, Arrays & Objects 
• Events & Script Validation

JAVA Script

• Controls & Structure
• Functions & Arrays
• Objects & Events
• Script Validation & Creating form

• Adobe Dreamweaver
• Website layout designs
• Colors in a website
• Planning for a website
• The working place
• Starting with the website
• Inserting Text and Graphics
• Working with Tables
• Linking Web Pages
• Using Frames, Using Behaviors
• Creating form

Adobe Flash (2D Animation)

• Introduction to flash
• Page properties & Background designs
• Introduction to time line
• Image editing for Animation
• Classic & Motion Tween
• Frame by frame animation
• Add classic motion guides & Rotation
• Shape Tween & Masking effects
• Creating advertisements 
• Graphic effects & Movie clip

Computer Typing (Marathi & Hindi) 

Project

NetMaster

NetTech Master

SocialNet Master

MobiTech Master

TechCID Master

CompTech Master

ITAdvice Master

Hardware & Networking

Hardware

Theory Session

• History of computer & Parts Hardware components 
• Hardware, Portable devices 
• Connectivity devices internal parts of computer
• SMPS & Motherboard 
• Processors, Hard disk & CD-RW 
• Output devices
• Monitor & Printer

Practical Session

• DOS, Command utilities
• Assembling / Disassembling System Unit
• Installation & Repairing Software 
• Troubleshooting
• OS and Software Installation
• OS Control Panel
• Device Management
• Troubleshooting Software 
• OS/OS partition repairing Special features of recovery  
• Deleted Data Recovery

Networking

Theory Session

• LAN, MAN, WAN
• Peer or Workgroup
• Client, Server model 
• Bus, Ring, Star...
• Cables, Bandwidth
• OSI Model
• TCP/IP
• HUB, S/W, Router

Practical Session

• Crimping & Resources Sharing
• Network Mapping Drive
• Telnet, Remote Desktop
• Net Meeting
• Networking Software 
• Network Security 
• Networking Devices
• Troubleshooting 
• PING, IPconfig, Nbtstat
• Team viewer, VNC

KLiC Diploma