PGDCA – Fundamental of Computer & M S Office

Brief history of development of computer, computer system concepts, Basic component of computer, control unit, ALU, Input/output, semiconductor memory function and characteristics, Memory-RAM, ROM, EPROM, PROM and other types of memory, Capabilities and limitation, Generation of computers, Analog and Digital Hybrid Computers, General and Special of Computer, Types Of Computer –Micro, Mini, Mainframe, Supercomputers. MS OFFICE: Introduction to MS Office, MS Word, MS Excel, MS PowerPoint, Internet and Email, MS Word- Introduction to MS Word, Text Basic, Text Formatting and Saving File, Working With Object, Header and Footers, Working with bullets and Numbered lists, Table, Styles and Contents, Merging Documents, Sharing and Maintaining Document, Printing, Proofing the document, Introduction to Excel, Formatting excel workbook, Perform Calculation With Function, Short and Filter data with excel, Use Macros to Automate Tasks.
MS PowerPoint: Setting up PowerPoint Environment- New, Open, Close, Save, Save As, Cut, Copy, Paste, Creating Slides, Hyperlinks and Action Button, Slide Show Option, Using Slide Master, Using Smart Art and Table, What Is Internet?, Email Addressing, Email Attachments, Browsing, Download Video And Music.

 PGDCA – Database Using MS Access, MySQL

Introduction To database concept, need of database, Flat Database, Database Management System, Characteristics of DBMS, Relational Database, Entity and Referential Integrity, Database concept of Primary Key, Database Application Example, Banking, Railways, School, Retail Store. Database Element- Tables, Query, Form, Report, and Introduction to client Server Paradigm. MySQL Database, Its Features, Installation on Windows, Making it works on Command Line, Using the Built in Database, Running and Shutting down MySql Server, Setting up MySql User account. CREATE and DROP database, Important Administrative MySql database Commands- SHOW DATABASE, USE DATABASE, SHOW TABLES, SHOW COLUMN, and SHOW INDEX.
Tables in Database, Create a Table in MS Access- Data Types, Field Properties, Fields: name, types, properties- default values, format, caption, validation rules Data Entry, Add record delete record and edit text, sort, find/replace, filter/select, rearrange columns, freeze columns. Edit a Tables- copy, delete, import, modify table structure, find, replace.

PGDCA – VB.Net Programming

Object Oriented Programming Language – Object Oriented Programming Concepts, Object Oriented Programming Compared to Traditional Programming Objects, Messages, Methods and Classes. Control Structure, Inheritance and Polymorphism, Advantages, Usage. Program development environment, Introduction to .NET, .NET Framework feature and architecture, CLR, Common Type System, MSIL, Introduction to Visual Studio, Visual BASIC, Visual Development and event drive Programming, Methods and Events, Variables, Data Type of Variables, Classes and Objects, simple project in VB.NET, constructor, Inheritance, Access Specifiers, Overloading.

 PGDCA – DTP with Page maker, Photoshop, Corel draw

Introduction to Desk Top Publishing (DTP), Photocomposing Machines and DTP, Definition, Need and Area of Application, Use of DTP in Offset Printing and web Designing, Use of Desk Top Publishing in Publications, Importance of D.T.P in Publication, Advantages of D.T.P in Publication, Page Layout and Designing in a single Page Production . Laser printers – Use, Types, Advantage of laser printer in publication, Introduction to Adobe Page Maker 7.0, Aldus and Adobe Page Maker, Previous and Current version of Page Maker, Page Maker as a DTP Software, Difference between a Page Maker and Word Processing Software. Introduction to Adobe Photoshop, Photoshop Document, Various Graphics Files and Extensions- JPG, GIF, PNG, TIF, BMP, PSD, CDR, SVG etc, Photoshop- Introduction to PSD Files, screen and work area Interfaces: Menu Bar, Option Bar, Palette, Active Images Area, Tool Box List.
Introduction to CorelDraw, Creating Basic Object, Starting CorelDraw, Manipulating Objects, Formatting Objects, Manipulating text, printing, Shaping Object, Layers, Creating Templates, Advance Enhancement, Content and Graphics, Marketing Plan, Scanning, Printing Technology.

 PGDCA – Financial Accounting with Tally

Basic Concepts of Accountings, Financial Statements, Financial Statement Analysis, Cost Centre, Basic Concepts of Inventory, Tally, Configuration and INI setup, Data Directory and Folders Configuration, single and multiple user, Tally Screen Components, Mouse/Keyboard Convention and Key, Combinations, Switching Between Screen Areas, Quitting. Tally Maintaining Company Data, Basic Company Details – create/Alter/select/Load/close a company, Chart of Account, Company Features, and Configuration.
Cheque Printing, Common Printing Option, Different Printing Formats, Multi-Account Printing, Dynamic- Report specific Option, Creating Group Company, Use of Tally vault, Using Security Control and defining different security levels, Use of Tally Audit.

 PGDCA – Internet and Web Designing

Introduction to Internet – internet Evolution and Concepts, Internet vs Intranet, Growth of Internet, Internet Service Provider and Its Function, Connectivity – Dialup, Leased Line, VSAT, URLs, portals, Internet Services, Application. HTML – Concepts of Hypertext, Versions of HTML, Elements of HTML, Syntax, Tags and Attributes, Head and Body Sections, Building, HTML Documents, Inserting Texts, Images, Hyperlink, Backgrounds and color controls Different HTML Tags, Table Layout and Presentation, Creating Lists, Use of Font Size and Attributes, Lists Type and Its Tags.
Introduction to WYSIWG HTML editor, advantages of using HTML editors, creating a new page and site, Inserting and formatting text, Creating and Inserting Images. Word Press – What is Word Press, Installation, Login, Overview of admin panel, user profile, Word Press Themes, Themes depository, Create and Add New Logo, set up a static homepage?