POST GRADUATE DIPLOMA IN COMPUTER APPLICATION - 1YEAR

SEMESTER – I

 COMPUTER FUNDAMENTALS

Introduction to Basic concepts  –Word pad –Notepad – Paint Brush

WINDOWS XP

Computer Fundamentals – Introduction to GUI –MS-Dos –

Notepad - Windows Explore – Control Panel

 MS-OFFICE XP

 WORD 2002

Creating text and Documents – Index and tables – Embedding Picture –

Table Manipulating – Mail merge – Macro.

 EXCEL 2002

Formatting Cells – Charts – Pivot Table – Data Table – Forms – Scenarios – Goal Seek – Macros and Models.

POWERPOINT 2002

Creating Presentations – OLE – Enhancing Presentation – Special Effects

 INTERNET

Introduction to Home Page - Creating E-Mail ID – Receiving & Sending E-Mail – Chatting – Location Information

 C PROGRAMING

Data types – Operators – Expression – Condition compilation – Looping & Branching –Arrays – Function – Storage classes – Structures and union – Introduction to Data Structure

SEMESTER – II

C++ PROGRAMING

Introduction to Oops – Input & Output streams – Classes & Objects – Member Functions – Function Overloading – Friend Function & Classes – Operator overloading – Constructer & Destructor – Inheritance – Polymorphism – File handling.

 SQL CONCEPT

SQL Enterprises Manager – Client Configuration Utility – T-SQL and ANSI SQL – views and Index – Data modeling – Stored Procedures.

 RDBMS CONCEPT (FOXPRO/MS-ACCESS)

Creating & maintaining Database – Sort and Index – programming Concepts – Concepts of a Relational Database Function – Creating Form, Report and Queries.

 VISUAL BASIC

Controls – user Controls – Properties and events – Control Statement and loops – Procedures and function – Error handling – Creating instance of objects – menu Editors – MDI applications – Sequential – Random and Binary File handling- data manager.

TALLY

Principles of Accounting – Voucher types – Classification of  ledgers – Inventory Groups – Creation of Godowns – Stock item – Bills of materials – VAT computation – payroll – trial balance – balance sheet .

v HARDWARE

Introduction to Computer – Microprocessor – VGA cards & other cards- keyboard – mouse – monitor – installation – Assembling – troubleshooting Configuring device.