PGDCA One Year Computer Course

August 03, 2019

PGDCA (12 Months) Post Graduate Diploma in Computer Application

LEVEL -1

WINDOWS

Computer Fundamentals- Introduction to OS/GUI- WordPad – Notepad- MSPaint- Windows Explorer- Control Panel.

MS OFFICE

MSWord: Creating Text & Documents- Indexes & Tables- Embedding Picture – Table Manipulation- Mail Merge.

MS Excel: Formatting Cells – Charts – Pivot Table – Data Table – Forms – Scenarios – Goal Seek module.

MS PowerPoint : Creating Presentation – OLE – Enhancing Presentation – Adding Audio & Video – Special Effects.

LEVEL -2

Elective 1 Financial Accounting

Tally.ERP 9

Principles of Accounting – Voucher Types- Classification of Ledgers – Concept of inventory Groups – Creation of Godowns – Stock Items- concept of sales & Purchase order processing – Making Voucher Entries for all transactions – Job Costing- Bank Reconciliation- POS- Payroll- Income tax- Multi Currancy- Budgets & Scenarios- Calculation of GST.

Elective 2 Programming tools

“C” Language

Data Types – Operators – Expressions – Conditional Compilation – Looping & Branching – Arrays – Functions – Storage Classes – Structures and Unions – Pointers – Dynamic Memory Allocation – File Handling – Linked Lists – Double Linked List – Circular Linked List – Bit Manipulation – Introduction to Data Structure.

OOPS Using C++

Introduction to OOPS – Input & Output Streams – Classes & Objects – Member Functions – Function Overloading – Friend Functions & Classes – Operator Overloading – Constructor & Destructor – Inheritance – Polymorphism – File handling using Stream Classes – Instance – Templates.

LEVEL - 3

DTP

Adobe PageMaker

Page Layouts – Master Page – Creating Styles – Indents and Taps – Changing Fills and Strokes – Text Wraps – Working with Frames – Creating Index & Table of Contents – Building a Booklet – Merging Records – Working on Publication Convertor – Project.

Photoshop

Photoshop Extended functions – Print & Web Resolutions – Image Editing – Image Special effects – Color Correction – Color Separation – Black & White to Color Conversion – Layer Styles – Collage Creation – Wrapper Designing.

Corel Draw

2D Shapes – Logo – Emblem – Designing and Drawing – Advertisement Layouts – Filters – Special Effects – Gradient and Color Fill – Image and Color Correction – Project.

LEVEL - 4

Client / Server Technology

SQL SERVER

SQL Enterprises Manager – Client Configuration Utility – T-SQL and ANSI SQL – Views and Index – Data Modeling – Data Integrity – Triggers – Stored Procedures.

VISUAL BASIC

Controls – User Controls – Properties and Events – Control Statements and Loops – Procedures and Functions – Error Handling – Creating Instances of Objects – Menu Editor – MDI Applications – Sequential, Random and Binary File Handling – Data Manager – ODBC – OLEDB – Data Controls and SQL – ActiveX – RDO – ADO – Data Report – DHTML.

LEVEL - 5

Hardware Basics & Trouble Shooting

Introduction to Computer Hardware – Input & Output devices, Memory – Types of Mother Board, Processor – Hard disk Drive, DVD Drive – Types of Ports – Slots – Connectors – Hardware trouble shooting – Windows Installation – Common Windows Problem.