Postgraduate Diploma in Computer Application (PGDCA): Comprehensive Computer Course from Basics to Advanced
The Postgraduate Diploma in Computer Application (PGDCA) is a thorough computer course designed to take students from the fundamentals to advanced levels. This course provides an in-depth understanding of essential tools, programming, software, and skills that are crucial for today’s tech-driven world. Whether you’re a beginner or have prior experience, this course is crafted to prepare you for various roles in the IT industry.
What You’ll Learn in the PGDCA Course
Basic Computer Skills
Start with essential computer knowledge, including typing skills and basic typewriting techniques to build speed and accuracy.
Office Productivity Tools
Gain mastery over essential office tools like Microsoft Word (Winword), Excel, and PowerPoint. These tools are indispensable for creating documents, handling data, and presenting information professionally.
Database Management with MS Access
Learn to manage and manipulate databases effectively using Microsoft Access, a powerful tool for handling data in small to medium-scale organizations.
Programming Fundamentals and Visual Basic
Understand the foundations of programming and application development with Visual Basic (VB), which introduces programming logic, syntax, and application creation.
Database Query Language: SQL
Get hands-on experience with SQL (Structured Query Language) for both client and server environments. SQL is critical for data management and forms the backbone of modern database systems.
Graphic Design and Photo Editing
Master design and photo editing software such as Photoshop and CorelDRAW. These tools are essential for creating high-quality graphics, enhancing images, and preparing visual assets for both digital and print media.
Tally ERP with GST Accounting
Gain expertise in Tally ERP with a focus on GST (Goods and Services Tax) compliance. This module is crucial for anyone aiming to work in finance, accounting, or business management roles.
Why Choose PGDCA for Career Growth?
The PGDCA program equips you with a broad range of technical skills. It’s ideal for students looking to start a career in IT, graphic design, data management, or accounting. With training that spans fundamental to advanced levels, graduates are prepared to meet the diverse demands of today’s job market.
Who Can Join?
This course is suitable for students, working professionals, or anyone looking to gain comprehensive computer skills. The program structure is beginner-friendly, while also covering advanced topics to keep learners engaged and progressively skilled.
Enroll in PGDCA Today!
If you're looking for a computer course that provides job-ready skills and takes you from basics to an advanced level, the PGDCA is the perfect choice.
Eligibility
Students with their academic qualification from 8th on wards are eligible to learn this course, who are already having system knowledge or not.
Target Audiences :-
School Students from 8th onwards
11th Mpcc - Maths, Physics, Science , Computer Science.
11th ACEC- Accounts, Commerce, Economics, Computer Science.
12th Mpcc - Maths, Physics, Science , Computer Science.
12th ACEC- Accounts, Commerce, Economics, Computer Science.
BCA - Bachelor of Computer Application.
B.Sc -CS Bachelor of Science. Computer Science.
MCA - Master of Computer Application.
M.Sc - CS Master of Science.
B.E - All Branches.
M.E - All Branches.
Pgdca Course Syllabus
Basics
Windows OS
Control Panel
Wordpad
Notepad
Paint
Fingering
Home
Home Options
Formatting
Elements
Alignments
Sorting Indentation
Pre-defined Headings
Styles
Edit
Edit
Clipboard
Find Text and Options
Format Painter
Insert
Insert - Pages
Table
Picture
Clip Art
Shapes
SmartArt
Chart
Screenshot
Links
Header & Footer
Textbox
Quick Parts
Word Art
Drop Cap
Equation & Symbol.
Typing Practice ( English & Tamil )
Mailing & Attachments
Print
Scan
Copy
Online Transactions
Introduction to Accounts
Introduction
Branches of Accounting
Financial Accounting
Cost Accounting
Management Accounting
Types of Accounts
Real Accounts.
Personal Accounts.
Nominal Accounts.
Accounting Principles or concepts
Rules of Accounting
Accounting Master
Journal.
Ledgers
Groups
Vouchers
Assets.
Liabilities.
Capital.
Revenue
Expenses.
Terms Used
Accounting
Business Transaction
Purchase
Sales
Purchase return or Rejection in or Outward invoice
Sales return or Rejection out or Inward invoice
Assets
1.Fixed Assets
2. Current Assets
Liabilities
Capital
Debtors
Creditor
Debit
Credit
Drawings
Receipts
Account
Ledger
Journal entries
Trial balance
Profit
Profit and Loss Account
Balance Sheet
Sundry Debtors
Sundry Creditors
Entity
Types of accounts
Personal account
Real Account
Nominal account
Mode of Accounting
Journals and Ledger
Posting
Accounting Period
Financial Statements
Trail balance
Profit and Loss Account
Balance sheet
Golden Rule of Accounting
Real Account
Debit what comes into the business
Credit what goes out from the business
Personal Account
Debit the receiver
Credit the giver
Nominal Account
Debit the expense or loss of the business
Credit the income or gain of the business
Getting Started with Tally Prime
Company Features
Configuration
Getting functions with Tally.Prime
Creation / setting up of Company in Tally.Prime
Inventory Masters
Stock Groups
Multiple Stock Groups
Stock Categories
Multiple Stock Categories
Units of Measure
Stock Items
Contra Banking
Bank Accounts.
Bank OD Accounts.
Bank OCC Accounts.
Vouchers in Tally
Introduction
Types of Vouchers
Accounting Vouchers
Inventory Vouchers
Invoicing
Receipt Voucher
Payment Voucher
Sales
Purchase
Contra
Advanced Accounting
Bill-wise details
Cost centers and Cost Categories
Interest calculations
Budget and controls
Scenario management
Bank Reconciliation
Group Creation.
Voucher Creation
Order Processing
Order Processing
Purchase order
Sales order
Reorder Levels
Batch-wise details
Bill of Materials
Different Actual and Billed Quantities
POS
Memorandum Voucher
Reversing Journal Voucher
Optional
Post Dated
Method of Adjustment
New Reference
Against Reference
On Advance
On Account
Technology Advancement
Backup and restore
Split company data
Import and export of data
Consolidation of Accounts
ODBC connectivity
Filter
Regional languages
Taxation in India
Taxation in India
Concept of Sales Tax
Concept of Service Tax
TDS
Income Tax
Excise Duty
Customs Duty
Fridge Benefit tax
GST
Getting Reports
Profit & Loss Account
Balance Sheet
Exception Reports
Statutory Reports
Payroll Reports
Trail balance
Day Book
Stock Summary
Outstanding Statement
Functional keys
VB-Unit-1
Introduction to Visual Basic: Introduction Graphics User Interface(GUI)
Programming Language (Procedural, Object Oriented, Event Driven)
The Visual Basic Environment IDE; Introduction to VB
Controls: Textboxes, Frames, check Boxes, Option Buttons
Setting a Border & Style, the shape Control, The line control, Working with
multiple controls and their properties
Designing the user Interface
Keyboard access, tab controls.
Default & controls property, Coding for Controls, list box and combo box and their properties, filing the list
box using property window/ add item method, picture/ image box and their properties.
VB-Unit-2
Variables, Constants and Calculations: Variables, Variables Public,
Private, Static, Constants, Data Types, Naming rules/ conventions,
Named & intrinsic, Declaring variables, Scope of variables, Val
Function, Arithmetic operations, formatting Data. Error functions and
types. Introducing to menu editor.
VB-Unit-3
Decision & conditions and Controls: If Statement, If then-else
Statement, Comparing String, Compound conditions (and, or Not),
Nested if Statements, Case Structure, Using If Statements with option
Buttons & Check Boxes, Displaying Message in Message Box, testing
whether input is valid or not. Using call Statement to call a procedure.
Do loop, while and for next loop.
VB-Unit-4
Working with forms and procedures: Introducing to forms and types
of forms and setting form properties, Creating, adding, removing
Forms in project, hide, Show Method, Load, Unload, Statement, Me Keywords, Referring to objects on a Different Forms.
UNIT – V Introduction to database connecting tools (ADO, DAO, ADODC,
ADODB), Creating the database file for use by Visual Basic (Using MSAccess), Using the Data control, Setting its property,
Using Data control with forms, using list boxes & combo boxes as data bound
controls, updating a database file (adding, deleting records): PS –
(Lecturers should be on Basic concepts only i.e. Definition, Diagrams and working Principles)
SQL - Structured Query Language
Introduction to SQL
Introduction to Databases and RDBMS
Installation
SQL Syntax
DataTypes
Operators in SQL
Expressions in SQL
Comments
Statements - DDL, DCL,DML
Pre-defined functions - Aggregate , String and Date functions
Queries and Sub-Queries
Clauses
Joins in SQL
Views in SQL
SQL Indexes
SQL Transactions
SQL Injections
Procedures
Cursors
Photo Editing
Introduction
Raster vs. Vector
Creating new images
Saving files for print
Saving files for web/screen
Working with Bridge Lesson 1. Getting to Know the Work Area
Using the tools
Using the options bar and other panels
Undoing actions in Photoshop
Customizing the workspace
Tools panel overview Lesson 2. Basic Photo Corrections
Strategy for retouching
Resolution and image size
Adjusting the color in Camera Raw
Straightening and cropping the image in Photoshop
Replacing colors in an image
Adjusting saturation with the Sponge tool
Repairing areas with the Clone Stamp tool
Using the Spot Healing Brush tool
Using content-aware fill
Applying the Unsharp Mask filter Lesson 3. Working with Selections
Course Syllabus | Adobe Photoshop Private Tutoring 1
About selecting and selection tools
Using the Quick Selection tool
Moving a selected area
Manipulating selections
Using the Magic Wand tool
Selecting with the lasso tools
Rotating a selection
Selecting with the Magnetic Lasso tool
Cropping an image and erasing within a selection
Refining the edge of a selection Lesson 4. Layer Basics
About layers
Using the Layers panel
Rearranging layers
Applying a gradient to a layer
Applying a layer style
Flattening and saving files Lesson 5. Masks and Channels
Working with masks and channels
Creating a mask
Refining a mask
Creating a quick mask
Manipulating an image with Puppet Warp
Working with channels Lesson 6. Typographic Design
About type
Creating a clipping mask from type
Creating type on a path
Warping point type
Designing paragraphs of type
Vector - Drawing
Getting Started
Case Study: Visiting Card
Understanding the Color Palette
Case Study: Sticker
Case Study: Letterhead with Logo
Working with the Objects
Case Study: Wedding Card
Case Study: Flex Banner
Understanding other controls (Layers and Tables)
Case Study: Flyer with Coupon
Case Study: Brochure
Other Features
Case Study: Product Box Package
Case Study: Book Cover
Case Study: Newspaper advertising
Case Study: Magazine Inner page
Pgdca Course Duration
Total Hours of this Program is 180 Hours. Per day Session is : 1.5 Hours. .
Class Schdule
Weekly Class Days Monday,Tuesday,Wednesday,Thursday,Friday
Regular Class Medium
100% Live Interactive Sessions
Faculty Name : Kaviya
More than 1 year of Experience
100% Direct Live Classes
Currently we conduct Offline Live Interactive classes only. The offline live classes are conducted with instant doubt clearing sessions.
Post Course Support
We had given dashboard to each and every student indidually. Here they can find course materials support,internship, placement vaccancy details, new courses arrival for life term.
Course Subject Materials
In the terminus of student dashboard there is a provision to view and download the PDF course materials relevant to the course subject topics.
Enroll Procedures
Step-1 : Click login/Sign-up menu item. Click the New User Registration and fill up all your needed details.
Then login with the username and password just before you were created. Go to dashboard, click buy course option then you will be able to purchase.
Course Fees Pay Procedures
a. PayTM payment gateway integrated with our site.
Tie-Up's for Placement Support
Winways Softwares Ascent Softwares BygC Consultant for Private Banking Sector
Instead of not knowing the Tamil language , the trainer here make me understand the open office concept very well. Now i am fulfilled with the skill of the subjects . Thanks all of them.
I studied this openoffice as one of the subject of my course pgdca . This course is well suited for the beginners who are start their career in the IT journey.
Nirmala
Instead of not knowing the Tamil language , the trainer here make me understand the open office concept very well. Now i am fulfilled with the skill of the subjects . Thanks all of them.