Computer Application Training In Pitampura Delhi

DIPLOMA IN COMPUTER APPLICATION

Course Syllabus

Module 1: Office Management

WORD (Documentation)

  • Page Setup, Text formatting, Data Proofing, Line & Paragraph setting
  • Header & footers, Mail Merge, Macro
  • Table (Applying Math formulas in table)
  • PROJECTS (Resume, Official Application, Letter, etc.)

ADVANCE EXCEL (Spreadsheet)

  • Referencing, Functions & formulas, Data Import & Export
  • Sorting and Filtering, Macros
  • Data Validation, Pivot Table, H Lookup– V Lookup
  • Creating MIS Reports, Database Projects

POWERPOINT (Presentation & Projects)

  • Slide Layout, Slide Transition, Slide Show, Animation
  • Sound and Video Effects, etc. (PROJECT)

Internet

  • Email, Bill Payment (mobile, Electricity, Jal Board, etc.)
  • Ticket Booking, Railway Reservation, Digital Locker, Job Portals (naukri.com, etc.)

Module 2: Desk Top Publishing (DTP)

Corel DRAW

  • Color Properties, Tool Box, Text Effect, Glowing Effects
  • Bitmap, Texture, Logo, 3D logo design
  • Pamphlet designing, banner design, Invitation cards, book covers

PHOTOSHOP

  • Layers, Channel, Tools, Color Adjustment, Background Effects
  • Digital Object Painting, Portfolio
  • Layer Mask, Vector Mask, Clipping Mask, Quick Mask
  • Book Cover, Flyer, Background Designing By Brush

INDESIGN

  • Tools, Image Adjustment, Colors Setting, Text Wrapping, FX effects, Master Pages
  • Hidden Character Spaces, Character and Paragraph style, Links, Liquid Layout

Module 3: Web Designing

HTML & HTML (5.0)

  • HTML Tags, Attributes, Headings, List, Image
  • HTML Tags, Attributes, Headings, List, Image
  • HTML Hyperlink, frames, Form, Table
  • HTML5 Semantic Attributes, Audio Tag, Video tag
  • HTML 5 New Form Elements, Canvas
  • HTML5 SVG element, Drag and Drop API
  • Geolocation, HTML5 Compatibility

CASCADING STYLE SHEET (CSS 3 & 5)

  • Backgrounds, Box Model, Dimension, Pseudo-class, Pseudo-element, Navigation Bar
  • Image Gallery, Image Opacity, Rounded Corners, Gradients, Shadows
  • 2D & 3D Transforms, Animations, Image Slideshow, Image Hover Overlay
  • Animation Button, Vertical tabs, Overlay effect

# NOTE : ONE MODULE FROM 4.1/4.2/4.3 CAN BE CHOSEN

Module 4.1: COMPUTER ACCOUNTING

TALLY (ERP) with G.S.T.

  • Ledger Posting, Bill wise details, Cost center, Allow Invoice
  • TDS(Tax deducted at source), TCS(Tax collecting at sources)
  • GST (IGST, CGST, SGST)
  • Debit note and Credit note
  • Zero value entry, Multiple Godowns, Integrate account and inventory
  • Allow multi-currency
  • Maintain stock categories
  • Use different actual and billed quantity
  • Profit and Loss Statement, Balance Sheet

Busy (with G.S.T.)

  • Excise implementation, Pay Roll implementation
  • Advance POS (point of sales) data entry, Credit limit, Cost centres
  • Purchase and Sales challan, MIS report, Data configuration, etc
  • GST (IGST, CGST, SGST), CST calculation and payment, Service tax
  • Excise implementation, Pay Roll implementation
  • Credit limit, Cost centre, Budget, Multi currency
  • Purchases & Sales Challan and Delivery goods & receipts note

Module 4.2: WEB DEVELOPMENT THROUGH PHP & MySQL

PHP (WITH MySQL)

  • Web Hosting and Domain Name concepts
  • Programming Concepts in PHP (Loops, Function, Array, String, File Handling, etc.)
  • PHP Forms (Retrieving Form Data, Get & Post Method)
  • Regular Expressions (User Input Validation, Metacharacters, Verifying E-mail Address)
  • Database Connection with MYSQL
  • Admin Panel in PHP
    • Block/Unblock/View Users, Design Client and Admin side, Pagination etc.
  • Developing an e-Commerce Website (ONLINE SHOPPING WEBSITE)
    • Payment Gateway Integration(Shopping Cart)
    • Integration of Online Chat Support application, SMS API
  • Java Script & CSS with PHP, Cpanel, FTP, AJAX, Admin Panel,
  • PHP OOPS, PHP PDO, Website Security

Module 4.3: HARDWARE & NETWORKING CONCEPTS

PC Architecture, Formatting Hard Disk, Hard Disk Partition,
Operating System Installation ( Win-7 , XP, Linux)

  • By Using Pen Drive, CD, DVD
  • Network Setting / Desktop Setting / Control Panel
  • Managing Users & Groups

C-MOS (BIOS) Set Up

  • Set Date / Time, Reset BIOS, BIOS Options (Manage Boot Sequence)
  • Jumper Setting (Detecting Hard Disk / CD Drive)

Driver Installation

  • Mother Board (LAN, Graphic, Sound Drivers), Printer, Scanner Drivers

Application Software Installation

  • MS-Office / Open Office/ Tally/Busy etc., .Net/ Java/SQL/PHP, etc.
  • Multimedia Software (2D & 3D) etc. WEB Browser Installation

Assembling of Computer, Trouble Shooting (Fault finding)
Networking Concepts

  • Network Devices, Cable & Connectors, IP Addressing
  • Setup Local Area Network, Sharing (Printers, Files, Folder, etc.)
  • Trouble Shooting and Network Problems

Quick Contact

    Are You Looking For Computer Application Training ?
    ×

      Open chat