Download Syllabus PGDCA

UNIT I : Brief History of Development of Computers, Computer System Concepts, Computer System Characteristics, Capabilities and Limitations, Types of Computers, Basic Components of A Computer System - Control Unit, ALU, Input/output Functions and Characteristics, Memory RAM, ROM, EPROM PROM and other types of Memory.
UNIT II Input/output & Storage Units-: Keyboard, Mouse, Trackball, Joystick, Digitizing tablet, Digital Camera, Scanners -MICR, OCR, OMR, Barcode Reader, Voice Recognition, Light pen, Touch Screen, Monitors characteristics and types of monitor -Digital, Analog, Size, Resolution, Refresh Rate Printers And Its Types -Dot Matrix, Inkjet, Laser, Plotter, Sound Card And Speakers, Storage Fundamentals - Primary Vs Secondary Data Storage And Retrieval Methods - Sequential, Direct And Index Sequential, Various Storage Devices - Magnetic Tape, Magnetic Disks, Hard Disk Drives, Floppy Disks ,Optical Disks, Flash Drives Video Disk, Physical Structure of Floppy &Hard Disk, Drive Naming Conventions In PC.
UNIT III Use of Communication and IT, Communication Process, Communication Types- Simplex, Half Duplex, Full Duplex, Serial And Parallel Communication, Types Of Network - LAN, W AN, MAN ,Internet, Topologies of LAN - Ring, Bus, Star, Mesh And Tree Topologies, Components of LAN -Media, , World Wide Web and Applications and Internet Services.
UNIT IV Software and Its Need, Types of Software - System Software, Application Software, System Software Operating System, Utility Program, Programming Languages, Assemblers, Compilers And Interpreter, Programming Languages- Machine, Assembly, High Level, 4GL, Their Merits And Demerits, Application Software and its Types - Word- Processing, Spreadsheet, Presentation Graphics, Data Base Management Software, Characteristics, Virus-Working Principles, Types of Viruses, Virus Detection and Prevention methods.
Note: In each theory paper, nine questions are to be set. Two questions are to be set from each Unit and candidate is required to attempt one question from each unit. Question number one will be compulsory, which will consist of MCQ, True/False, Match the Columns and Fill in the Blanks out of the entire syllabus. In all, five questions are to be attempted.

UNIT I MS Word Basics: Introduction to MS Office, Introduction to MS Word, Features & area of use. Working with MS Word, Menus & Commands, Toolbars & Buttons, Shortcut Menus, Wizards & Templates, Creating a New Document, Different Page Views and layouts, Applying various Text Enhancements, Working with -Styles, Text Attributes print options Advanced Features of MS-Word
UNIT II MS Excel: Introduction and area of use, Working with MS Excel, Toolbars, Menus and Keyboard Shortcuts, concepts of Workbook & Worksheets, Using Wizards, Various Data Types, Using different features with Data, Cell and Texts, Inserting, Removing & Resizing of Columns & Rows, Working with Data & Ranges, Different Views of Worksheets, Column Freezing, Labels, Hiding, Splitting etc., Using different features with Data and Text, Cell Formatting including Borders & Shading, Advanced Features of MS Excel
UNIT III MS PowerPoint: Introduction & area of use, Working with MS PowerPoint, Creating a New Presentation, Working with Presentation, Advanced Features of MS Powerpoint
UNIT IV Ms Access : Basics of RDBMS ,Introduction to database -What is a Database, Why use a Relational Database, Overview of Database Design - Determining tables, Determining Fields, Determining Relationships, Integrity Rules Primary/Foreign Key, One-to-Many, Many-to-Many, One-to-One) Introduction to MS Access (Objects, Navigation).Create a Table in MS Access -Data Types, Add record delete record and edit text Working with Internet, WWW and Web browsers, Basics of Electronic Mail
Note: In each theory paper, nine questions are to be set. Two questions are to be set from each Unit and candidate is required to attempt one question from each unit. Question number one will be compulsory, which will consist of MCQ, True/False, Match the Columns and Fill in the Blanks out of the entire syllabus. In all, five questions are to be attempted.

Unit 1: Introduction to Programming Algorithms, flowcharts, Programming Languages, compilation, testing & debugging and documentation, Flow Chart, Basic algorithms/flowcharts for sequential processing, decision based processing and iterative processing. Some examples like: Exchanging values of two variables, summation of a set of numbers, Test whether a number is prime, factorial etc.
Unit 2:- Introduction to Python Python Introduction, Using Comments, Literals, Constants, Python‟s Built-in Data types, Strings ,Accepting input from Console, printing statements, Simple „Python‟ programs. Operators, Expressions and Python Statements, Assignment statement, expressions, Arithmetic, Relational, Logical, Bitwise operators and their precedence, Conditional statements: if, if-else, if-elif-else; While Statement, For loop, break statement, Continue Statement, Pass statement, else, assert. Lists, tuples and dictionary
Unit 3: Functions Uses of functions, Function parameters, the Return statement, Default argument values, VarArgs parameters. Library function-input(), eval(),print(), String Functions: count(), find(), rfind(), capitalize(), title(), lower(), upper(), swapcase(), islower(), isupper(), istitle(), replace(), strip(), lstrip(), rstrip(), aplit(), partition(), join(), isspace(), isalpha(), isdigit(), isalnum(), startswith(), endswith(), encode(), decode(), String: Slicing, Membership, Pattern Matching, Numeric Functions: eval(), max(), min(), pow(), round(), int(), random(), ceil(), floor(), sqrt(), Date & Time Functions, Recursion.
Unit 4: File Processing Concept of Files, File opening in various modes and closing of a file, Reading from a file, Writing onto a file, File functions-open(), close(), read(), readline(), readlines(),write(), writelines(),tell(),seek(), Command Line arguments. NumPy Basics
Note: In each theory paper, nine questions are to be set. Two questions are to be set from each Unit and candidate is required to attempt one question from each unit. Question number one will be compulsory, which will consist of MCQ, True/False, Match the Columns and Fill in the Blanks out of the entire syllabus. In all, five questions are to be attempted.

UNIT I: System Analysis and Design Concept: Definition, Characteristics, Elements of system, Physical and abstract system, open and closed system, man-made information systems. System Development Life Cycle: Various phases of system development, Feasibility study -Technical, Operational & Economic Feasibilities, Cost/Benefit Analysis , System Testing
UNIT-II :Object Oriented Programming Language: Introduction to .NET, .NET Framework features & architecture, CLR, Common Type System, MSIL, Introduction to visual studio, Visual BASIC, visual development & event drive Programming, Methods and events, Variables, Data Type of variables, Classes 8s Objects, simple projects in VB.NET, constructor, inheritance, Access Specifiers, Overloading
UNIT-III : Scope and lifetime of a variable, Arrays, Collections, Subroutines, Functions, Control how statements: conditional statement, loop statement. Msgbox & Input box. Forms: Loading, showing and hiding forms, Methods and events, GUI Programming with Windows Form, Textbox, Label, Button, simple projects in VB.NET using these controls Listbox, Combobox, Checkbox, PictureBox, Radio Button, Panel, scroll bar, Timer, Dialog boxes, Designing menus, Advanced projects in VB.NET using these controls
UNIT-IV Database programming with ADO.NET Accessing Data using Server Explorer, Creating Connection, Accessing Data using Data Adapters arid Datasets, using Command & Data Reader, data bind Controls, displaying data in data grid. Processing Access Database using ADO.NET Object model, Connection object, Command object, Add, delete, move & update records to dataset. Projects in VB.NET using database
Note: In each theory paper, nine questions are to be set. Two questions are to be set from each Unit and candidate is required to attempt one question from each unit. Question number one will be compulsory, which will consist of MCQ, True/False, Match the Columns and Fill in the Blanks out of the entire syllabus. In all, five questions are to be attempted.

UNIT-I The basic Financial Accounts, types of accounts, Rules of Entries of transaction, Journal. Cash Book Types, Format of Cash book, Balancing of Cash Book, Subsidiary books Purchase, Sales, and Purchase return and sales return. Ledger, posting of entries.
UNIT II Trial Balance, Rectification of errors, adjustment entries. Depreciation and Inflation.
UNIT III Principles of Cost Accounting, Valuation of Stocks, Allocation of Overheads, Methods of material issues.Payroll department, Preparation of Pay roll, Preparation of wage record, Methods of payments of wages, overview of computerized method for payroll preparation.
UNIT IV Inventory account and store record, inventory or stock control and cost accounting, Department demand and supply method of stock control. Classification and condition of material Report on material handling. Overview of computerized accounting process Introduction to accounting system software, their features and some basic operations.
Note: In each theory paper, nine questions are to be set. Two questions are to be set from each Unit and candidate is required to attempt one question from each unit. Question number one will be compulsory, which will consist of MCQ, True/False, Match the Columns and Fill in the Blanks out of the entire syllabus. In all, five questions are to be attempted.

UNIT-I : Concepts of Hypertext & HTML: Elements of HTML syntax, Head & Body Sections, Building HTML documents, Inserting texts, Images, Hyperlinks, Backgrounds and Color controls, HTML tags, Table layout and presentation, Use of font size & Attributes. List types and its tags, Use of Frames and forms.
UNIT-II :Overview of Dynamic Web page: Understanding ASP.NET Controls, Applications, Web servers, IIS, Web forms, web form controls, server controls, client controls. Adding controls to a web form, Buttons, Text Box, Labels, Checkbox, Radio Buttons, List Box. Running a web Application, creating a multiform web project, Form Validation: Client side validation, server Side validation, Validation Controls: Required Field Comparison Range. Calendar control, Ad rotator Control, Internet Explorer Control, Accessing Data using Data Adapters and Datasets.
UNIT-III : Database programming for websites: Creating Connection, Accessing Data using Data Adapters and Datasets , using Command & Data Reader, data bind Controls, data grid. Add, delete, move & update records to dataset. Projects in ASP.NET using database.
UNIT-IV : Introduction to XML in .NET: XML basics, attributes, fundamental XML classes, Document, textwriter, textreader, XML validations, XML in ADO.NET, The XML Data Document, Introduction to Web services, State management- View state, Session state, Application state SOAP, web service description language.
Note: In each theory paper, nine questions are to be set. Two questions are to be set from each Unit and candidate is required to attempt one question from each unit. Question number one will be compulsory, which will consist of MCQ, True/False, Match the Columns and Fill in the Blanks out of the entire syllabus. In all, five questions are to be attempted.

UNIT I : Internet : Evolution, Protocols, Interface Concepts, Internet Vs Intranet, Growth of Internet, ISP, Connectivity - Dialup, Leased line, VSAT etc., URLs, Domain names, Portals, Application. E-MAIL - Basics of Sending & Receiving, Word Wide Web (www) - History, Working, Web Browsers, Its functions, Concept of Search Engines, Searching the Web, HTTP, Common terminologies: LAN, WAN, Node, Host, Workstation, bandwidth, Network Components: Severs, Clients, Communication Media, Types of network: Clients Server, Network topologies: Bus, star and ring.
UNIT-II Concepts of Hypertext: HTML introduction, features, uses & versions Using various HTML tags, Elements of HTML syntax, Head & Body Sections, , Inserting texts, Text alignment, Using images in pages, Hyperlinks text and images, bookmarks, Backgrounds and Color controls, creating and using Tables in HTML, and presentation, Use of font size & Attributes, List types and its tags.
UNIT-III Introduction to WYSIWYG Design tools for HTML, Overview of MS FrontPage, Macromedia Dream weaver, and other popular HTML editors, designing web sites using MS FrontPage Cascading Style Sheets
UNIT-IV :Javascript : Javascript vs. Java, Javascript versions, Script element,. Functions: Functions introduction, Calling functions, Javascript Comments, Variables: Variables overview, declaring variables, Types of variables, Casting variables, Alert box , Prompt & confirm. Expressions: Arithmetic operators, Assignment operators, Logical operators, Expressions and precedence, Statements: If statement, For statement, While statement, Break/Continue statements, Creating arrays/event handlers, JavaScript Object model, Object and Events in JavaScript OnClick, On MouseOver, On Focus, OnChange, OnLoad etc. Getting data with forms.
Note: In each theory paper, nine questions are to be set. Two questions are to be set from each Unit and candidate is required to attempt one question from each unit. Question number one will be compulsory, which will consist of MCQ, True/False, Match the Columns and Fill in the Blanks out of the entire syllabus. In all, five questions are to be attempted.

UNIT I Introduction to database -What is a Database, Why use a Relational Database, Overview of Database Design Data Normalization (Determining tables, Determining Fields, Determining Relationships) Integrity Rules (Primary/Foreign Key, One-to-Many, Many-to-Many, One-to-One)
UNIT II Purpose of database system, Views of data, Data models: Relational, Network, Hierarchical, Instances & Schemes, Data Dictionary, Types of Database languages : DDL, DML, Structures of a DBMS, Advantages & Disadvantages of a DBMS, 3- level Architecture Proposal : External, Conceptual & Internal Levels
UNIT III Entity Relationship Model as a tool of conceptual design : Entities & Entity set, Relationship & Relationship set, Attributes, Mapping Constraints, Keys, Entity-Relationship diagram Relations, Domains, Attributes, Tuple, Concepts of Keys: Candidate key, Primary Key, Alternate Key, Super Key, Foreign Key, Fundamental integrity rules: Entity integrity, Referential integrity, Normalization: 1NF, 2NF, 3NF
UNIT IV Creating Tables, Views, Joins and queries in SQL Server. Working with Table: Data Management and Retrieval: DML adding a new Row/Record Customized Updating and Deleting an Existing Rows/Records retrieving Data from Table Arithmetic Operations restricting Data with WHERE clause Sorting Functions and Grouping: Built-in functions Grouping Data. Multiple Tables: Joins