Post Graduate Diploma in Computer Programming & Application (PGDCPA)
Semester I Semester II
1. Fundamental of Computers 1. Programming Concepts
2. DOS & Windows XP 2. OOPS (C++ Language)
3. Office Automation (MS Word, ME Excel, 3. Tally 5.4 / Tally 6.3 / Tally 9
MS PowerPoint) 4. PageMaker 7
4. Internet 5. Introduction to Multimedia
5. FoxPro Programming 6. Introduction to H/W Maintenance
6. C Language 7. Project
Advance Diploma in Computer Application (ADCA)
Semester I Semester II
1. Fundamental of Computers 1. Programming in C++ (OOPS)
2. DOS & Windows 98, 2000, XP 2. Visual Basic OR PageMaker
3. Office Automation (MS Word, ME Excel, 3. Corel Draw
MS PowerPoint) 4. Internet & Web Page Designing OR
4. FoxPro Tally 9 OR .Net
5. Programming in C 5. Introduction to H/W Maintenance
6. System Analysis & Design OR
Multimedia
7. Project
Diploma in Computer Application (DCA)
Semester I Semester II
1. Fundamental of Computers 1. Tally 5.4, Tally 7.2, Tally 9
2. DOS & Windows XP 2. Pagemaker
3. Office Automation (MS Word, ME Excel, 3. Corel Draw
MS PowerPoint) 4. Photoshop
4. Internet 5. Project
5. FoxPro Programming
6. C Language
Diploma in Office Automation (DOA)
1. Fundamental of Computers (FOC)
2. Windows XP
3. Disk Operating System (DOS)
4. Important & Advantages of MS Word
5. Using MS Word
6. MS Excel
7. MS PowerPoint
8. Internet
9. Tally 7.2 / 9
10. Pagemaker 7
11. Project
Diploma in E-Commerce (DEC)
1. Introduction to E Commerce
2. C & C++ Language
3. Windows & Internet
4. HTML / DHTML
5. Java Programming
6. Visual Basic
7. Server Administration & Security
8. Web Technology
9. Project
Diploma in Multimedia Techniques (DMT)
1. Adobe Pagemaker 7
2. Corel Draw 12
3. Adobe Photoshop
4. Flash
5. Dream Weaver
6. Basic of Other Multimedia Software
7. Project
Diploma in graphic Designing (DGD)
1. MS Word
2. Windows XP
3. MS PowerPoint
4. Adobe PageMaker 7
5. Typing Tutor
6. Shreelipi / Devnagri
7. Corel Draw 12
8. Instant Artist
9. Adobe Photoshop CS
10. Photo Editing
11. Concepts for installation of software, font & clip art
12. Basic Knowledge of Paper
Detail Syllabus of All Above Courses
Office Automation
MS Word
Word processing concepts: Saving, Closing, Opening an existing document, Selecting text, Editing text, Finding and replacing text, printing documents, Creating and Printing Merged Documents, Character and+ Paragraph Formatting, Page Design and Layout.
Editing and Proofing Tools: Checking and correcting spellings. Handling Graphics. Creating Tables and Charts. Document Templates and Wizards.
Advanced Features of MS-Word: Spell Check, Thesaurus, Find & Replace; Headers & Footers ; Inserting – Page Numbers, Pictures, Files, Autotexts, Symbols etc.; Working with Columns, Tabs & Indents; Creation & Working with Tables including conversion to and from text; Margins & Space management in Document; Adding References and Graphics; Mail Merge, Envelops & Mailing Labels.
MS Excel
Spreadsheet Concepts. Creating, Saving and Editing a Workbook, Inserting, Deleting Work Sheets, entering data in a cell / formula Copying and Moving data from selected cells, Handling operators in Formulae, Functions: Mathematical, Logical, Statistical, Text, financial, Date and Time functions, Using Function Wizard.
Formatting a Worksheet: Formatting Cells- changing data alignment, changing date, number, character, or currency format, changing font, adding borders and colors, Printing worksheets, Charts and Graphs-Creating, Previewing, Modifying Charts.
Integrating word processor, spread sheets, web pages.
MS PowerPoint
Creating, Opening and Saving Presentations, Creating the Look of Your Presentation, Working in Different Views, Working with Slides, Adding and Formatting Text, Formatting Paragraphs, Checking Spelling and Correcting Typing Mistakes, Making Notes Pages and Handouts, Drawing and Working with Objects, Adding Clip Art and Other Pictures, Designing Slide Shows, running and Controlling a Slide Show, Printing Presentations.
Programming in C & C++
Programming in C
Introduction & features of C, Structure of C program, Variables, Expressions, Identifiers, Keywords, Data Types, Constants, Operator and expression Operator: Arithmetic, Logical, Relational, Conditional and Bit wise Operators, Precedence and Associativity of Operators, Type conversion in expression, Basic input/output and library functions Single character input/output i.e. getch(), getchar(). getche(), putchar(),Formatted input output i.e. printf() and scanf(), Library functions - concepts, Mathematical & Character functions. If statement, If.....Else statement, Nesting of If....Else Statement, else if ladder, The ?: operator, goto statement, Switch statement, Compound statement, Loop controls, for, while, do-while loops, break, continue, goto statement, ARRAYS Single and Multi Dimensional arrays, Array declaration and initialization of arrays, Strings : declaration, initialization, functions.
Programming in C++
Object-Oriented Programming Paradigm, Basic Concepts of Object-Oriented Programming, Benefits of OOPs, Object-Oriented Languages, Applications of OOP, C++ Statements, Class, Structure of C++ Program, Creating the Source File, Compiling and Linking. Introduction, Tokens, Keywords, Identifiers, Basic Data types, User Defined Data Types, Derived Data Types, Symbolic, Constants, Type, compatibility, Declaration of Variables, Dynamic Initialisation of Variables, Reference Variables, Operators in C++, Scope Resolution Operator, Member ,Dereferencing Operators, manipulators, Type Cast Operator, Expressions and Implicit Conversions, Operator Precedence,
Control Structures- Specifying a Class, Defining Member Functions, Making an Outside Function Inline, Nesting of Member Functions, Private Member Function, Arrays within a Class, Memory Allocation for Objects, Static Data Member, Static Member Functions, Arrays , Objects, Object as Function Arguments.
Constructors and destructors- Introduction, Constructors, Parameterized Constructors, Multiple Constructors with Default ,Arguments, Dynamic Initialization of Objects, Copy
Constructors, Dynamic Constructors, Constructing Two-Dimensional Arrays, Destructor.
Functions in C++ - The Main Function, Function Prototyping, Call by reference, Return by Reference, Inline Functions, Default Argument, Const. Arguments, Function overloading, Friend and
Virtual Function- Operator overloading and type conversions: Introduction, defining Operator Overloading, Overloading Unary Operators, Overloading Binary Operators Using Friends, Manipulation of strings using Operators, Rules for Overloading Operators, Type
conversions.
Inheritance extending class - Introduction, Defining Derived Classes, Single nheritance, Making a Private Member ,Inheritable, Multilevel Inheritance, Multiple Inheritance, Hierarchical Inheritance,
Inheritance- Pointers, virtual functions and polymorphism, Compile time Polymorphism, run time polymorphism, Pointers to Objects, This Pointer, Pointers to Derived Classes, Virtual Functions, Pure Virtual Functions.
Visual Basic Programming
Integrated Development Environment of Visual Basics, Integrated Development Environment of VB, User Interface, Designing, Basics of Event driven programming. Form - Designing, Showing & Hiding, Datatypes & Control Statements , Data Types, Variables & Constant, Arrays, Dynamic Arrays, Array as function, Collections, Procedures, Arguments passing, Functions Return Values. Control Flow Statements : if-then, if-then-else, Select case, Looping statement: Do- Loop, For-next, While-Wend, Nested ,Control Structure, Exit statement.
Building Blocks of Visual Basic : Basic Active X Control & Their Use - Text box, List box, combo box, Scroll bar, Slider & Fire Controls. Advance Active X Control - Common Dialog controls, Color, font, File open, file save, print help, tree View & list View. Controls
Components of Visual Basic . Graphics controls, Image Handling in VB, Coordinate System, Graphics methods- Text Drawing, Lines & Shape, Filling Shapes, Grid methods. Menu editor: Pull-down and Pop-up menus Multiple Document interface- Parent & Child Forms & Methods.
Error handling: Types of Errors, Error handling methods and functions , Database programming with Visual Basic , Database programming with VB - DATA Control - methods, Properties, Visual data manager, Connectivity with database, DATA bound controls.
RDBMS & Oracle
Introduction- Purpose of Database Systems, Views of data, Data Models, Database
language, Transaction Management, Storage Management, Database Administrator,
Database Users, Overall System Structure, Different types of Database Systems
E-R Model: Basic Concepts, Design Issues, Mapping Constraints, Keys, E-R
Diagram, Weak Entity set, Extended E-R features, Design Of an E-R Database
Schema, Reduction of an E-R schema to Tables, Relational Model: Structure of Relational Database, The Relational Algebra, The,tuple relational calculus, The Domain Relational Calculus, Views, SQL- Background, Basic Structure, SET operations, Aggregate functions, Null,Values, Nested Sub queries, Derived Relations, Views, Modification of Database,Joined Relations, DDL, Other SQL features
Transaction- Transaction Concepts, State, Implementations of Atomicity and
durability, Concurrent Executions, Serializability, Recoverability, Transaction
Definition in SQL. Concurrency Control- Lock based protocol, Timestamp based protocol, Validation based protocol, Multiple Granularity, Multi version Schemes, Deadlock Handing, Insert and Delete operations, Concurrency in index structure
Query Optimization, Relational Database Design- Pitfalls in Relational-Database Design, Decomposition, Normalization Using Functional Dependencies, and Normalization Using Multi valued, Dependencies, Normalization Using Join Dependencies, Domain-Key Normal Form and Alternative Approaches to Database Design, Other Relevant Advance Topics and Applications- Object Oriented Database,
Decision-Support Systems, Data Analysis, Data Mining, Data Warehousing, Spatial
and Geographic Databases, Multimedia Databases, Mobility and Personal Databases, Information-Retrieval Systems, Distributed Information Systems, The World Wide Web, ORACLE 8.0 Database: SQL, PL/SQL, Developer 2000(Oracle Forms and Reports) .
Internet & Web Designing
Internet, Growth of Internet, Owners of the internet, anatomy of Internet. ARPANET and Internet history of the World Wide Web, Basic Internet Terminology, Net Etiquette.
Internet Applications-Commerce on the Internet, Governance on the Internet, Impact of Internet on Society-Crime on/through the Internet., Internet - Evolution, Protocols, Interface Concepts, Internet ,Vs Intranet, Growth of Internet, ISP, Connectivity - Dial-up, Leased line, VSAT etc., URLs, Domain names, Portals, Application.
INTERNET protocols-Data Transmission Protocols, Client/Server Architecture & its Characteristics, FTP & its usages. Telnet Concept, Remote Logging, Protocols, Terminal Emulation, Massage Board, Internet chatting - Voice chat, text chat. Word wide web (www)-History, Working, Web Browsers, Its functions, Concept of Search Engines, Searching the Web, HTTP, URLs, Web Servers, Web Protocols. • Web publishing - Concepts, Domain name Registration, Space on Host Server for Web site, HTML, Design tools, HTML editors , Image editors, Issues in Web site creations & Maintenance, FTP
software for upload web site. HTML - Concepts of Hypertext, Versions of HTML, Elements of HTML syntax, Head & Body Sections, Building HTML ,documents, Inserting texts, Images, Hyperlinks, Backgrounds and Color controls, Different HTML tags, Table yout and
presentation, Use of font size & Attributes, List ,types and its tags, Use of Frames and Forms in web pages.
FoxPro
FoxPro - Versions, features, requirement of Hardware and Software , FoxPro - Menu System, Working with FoxPro ,Creating Database File Some common operations on data- CREATE, LIST, APPEND, CLOSE, QUIT , FoxPro - Data Types , Data Displaying and Monitoring Commands - DISPLAY, LIST, LOCATE, EDIT, CHANGE, BROWSE, REPLACE, DELETE, RECALL, PACK (All Commands with various Options) , Modify structure, memo field and file utilities -
File utilities in FoxPro - DISPLAY DIRECTORY, COPY, DELETE, RENAME.
Sorting & Indexing Concept,Sort Commands - Single & Multiple Key, , Indexing, FIND, SEEK, Printing reports and labels ,FoxPro Report - its creation, features & Utilities, Preview,
Printing Custom Report, grouping & Subgrouping., FoxPro Label - Designing & Printing ,Memory Variables - Creation and Uses, Simple Vs Array, Saving and Restoring Memory Variables, ?/??/??? Commands ,Time & Date Functions and Commands, Date Arithmetic,Converting Defining Function Keys,. Concepts of FoxPro commands file, Modify Commands,Conditioning , Branching and Looping within Program files ,with Do- While Enddo, If - Endif, Scan-Endscan, For - Endfor, Docase-Endcase, Text - Endtext, Executing ,Commands from other command files, Macro Substitution , Error conditions and program debugging aids
Financial Accounting - Tally
Introduction, Starting Tally, Masters, Vouchers, Vouchers (Advance), Display (Final accounts), Display (Book of accounts), Printing, Maintenance, Summing Up.
Tally fundamentals
Software Configuration & INI setup, Data Directory & Folders configuration, Single & Multiple User, Tally Screen Components, Mouse / Keyboard Conventions & Key,Combinations, Switching between screen areas, Quitting Tally, Maintaining Company Data, Basic Company Details, Create/Alter/Select/Load/Close a Company, Chart of Accounts F11: Company Features & F12: Configuration.
Basic and advanced accounting
Create, Alter & Display Groups and Ledgers, All accounting voucher transactions, Create and Alter new Voucher type, Item and Account Invoice transactions, Excise Invoice, Export Invoice, Transactions using Bill-wise details, Bank Reconciliation, Interest calculations using simple & advance parameters, Interest calculations on outstanding balances & on invoices, Use of voucher class,. Reports like balance sheet, Profit & Loss account, Ratio analysis, Trial Balance. Accounts books like cash/bank book, All ledgers, Group summary & vouchers, Sales, purchase & journal registers, ledger & group breakup, outstanding receivables & payables, interest receivable & payable, Statistics, Cash & Fund flow, Day book, List of Accounts.
Basic and advanced inventory
Create, Alter & Display Stock Groups and Stock Items, Stock item behaviour using ,Create, Alter & Display Stock categories, , Reports like Stock summary, Inventory books like Stock item, Group summary, Stock transfers, Physical stock register, Movement analysis, Stock group & item analysis, stock category analysis, Ageing analysis, Sales order & Purchase order book, Statement of inventory related to Godowns, categories, stock query,
Administration
Back-up & Restore, Splitting company data, Export & import of Data, ODBC compliance, Re-write data.
Desk Top Publishing (DTP)
PageMaker
Introduction, Tour of PageMaker, Editing, Adding Design Elements, Setting of Templates, Setting up Custom Styles, Using Layers, Printing, Adding color, Developing long documents, Using PhotoShop Filters, Creating HTML Pages, Using PageMaker help
Corel Draw
Introduction, Creating Artistic text, Working with shapes, Controlling the CorelDraw 9 Environment, Setting up Page Layout, Defining Outlines, Mixing Up Fills, Drawing and Editing FreeHand Curves, Bezier Curves, Working with Shapes and Curves, Working with Bitmaps Images, Lenses and Power Clips, Blends and Contours, Working with Perspective, Designing with Paragraph Text, Managing Layers and Pages, Importing and Exporting Objects, Printing, From CorelDraw to the World Wide Web, Driving in to PhotoPaint, Painting text, Painting Bitmap, Working with objects, Working with masks .
Adobe Photoshop
Introduction, Using the Editing Tools, Working with layers, channels and paths, Image modification tool, Working with text, Working with history and actions, Adjusting Images, Designing images for the Web, Using image ready, Saving your work.
