Post Graduate Diploma in Computer Applications

Overview

Post Graduate Diploma in Computer Applications (PGDCA) is designed for graduate students who are seeking professional knowledge in computer applications. This course is a stepping stone for students who want to learn computer applications in different fields like banking, insurance and accounting. This programme will give the aspirants a sound understanding of basic computer applications in business covering key programming languages, data base management, systems analysis, computer software development in specific applications such as studies, financial management and long-range planning.

Program Objective

  • PGDCA programme is aimed towards building a prospective career in the field of computer application.
  • The programme is designed with the objective to provide knowledge and skills in the various aspects of computer applications and core programming.
  • Students will also be trained in the latest trends of information technology.

Course Features

  • Mobile App based Learning
  • Online Learning Portal
  • Audio video lectures by renowned subject experts
  • Industry specific training curriculum
  • Self-Assessment tests
  • Online Faculty for query solving

Course Audience

The PGDCA course can be pursued by graduates or working professionals looking to build a career in the IT industry. Successful candidates can look forward to getting employed in IT firms, Banking and Finance industry, Educational Organizations or Research Firms in any of the following job profiles-

  • Application Developer
  • Data Analyst
  • Database Administrator
  • IT Support Technician and many more…

Course Eligibility

Any graduate from a recognized University


Course Duration

1 Year (2 semesters)


Course Fees/ Price (In INR)

15000/- (inclusive of taxes)

Course Structure

Paper-I Computer Fundamentals and PC Software
1 UNIT 1: Introduction to Computer
  Block Diagram of Computer, Evolution, Generations, Classification and its Application
2 UNIT 2: Basic Components of Computer
  Concept of Bit and Byte; Block Diagram of Computer, CPU, ALU, CU; Computer Memory: Primary and Secondary; Input/Output Devices; Buses: Address, Data, Control.
3 UNIT 3: Introduction to OS
  Definition and functions of an Operating System, Types of OS (Single User, Multi user, Single tasking, Multitasking, Real time, Network OS, Distributed OS)
4 UNIT 4: MS DOS Operating System
  Introduction to DOS, System files of DOS, concept of Booting, Files and Directory Structure, Concept of Paths, Internal and External commands, Batch File.
5 UNIT 5: MS Windows Operating System
  Features of Windows 7, Exploring Components of Windows: The Desktop, The Icons, Working with Windows, The Start Menu and Taskbar, Quiting Windows; Customizing the Desktop, Files and Folders.
6 UNIT 6: LINUX Operating System
  Open Source and Free Software, Advantages and Disadvantages of Linux Operating System, Concept of Path, Basic Linux Commands, File Permission, Text Editor vi.
7 UNIT 7: Microsoft Word-Part I
  Starting MS-Word, Document Window and its Components, Different Bars, Document View, Creating a New Document, Saving a Document, Opening an Existing Document, Exiting MS-Word, Working with Text, Working with Paragraph, Bullets and Numbering, Find and Replace, Copy, Cut and Paste.
8 UNIT 8: Microsoft Word-Part II
  Spelling and Grammar Checking, Undo and Redo option, Header and Footer, Page Setup, Printing Documents, Inserting Picture, Working with Tables: Inserting Table, Deleting Table, Traversing Table, Selecting a Table, Rows and Columns, Deleting Rows and Columns, Merge and Split Cells; Creating Multiple Columns.
9 UNIT 9: Microsoft Excel
  Starting MS-Excel, Working with Toolbars, Row, Column and Cell, Working with Excel: Creating a New Workbook, Working with Cells and Fonts, Merging Cells, Inserting and Deleting Rows and Columns; Saving a Workbook, Closing a Workbook;
10 UNIT 10: Functions of Excel
  Different Operators used in Excel; Working with Formula and Functions; Sorting Data; Working with Charts.
11 UNIT 11: Microsoft PowerPoint
  Starting MS-PowerPoint, Creating a New Presentation, Working with Slides, Applying Text and Graphics, Applying Themes, Customizing Slide Show, Saving, Running and Closing a Presentation, Opening an Existing Presentation.

Paper-II Digital Logic
1 UNIT 1: Number Systems
  Decimal, Binary, Hexadecimal and Octal. It’s Conversion: Decimal to Binary/Hexadecimal/Octal and vice versa. Addition/ Subtraction on Binary Numbers, Complement: r’s and (r-1)’s complement. Fixed Point representation and Floating point representation, BCD, ASCII, EBCDIC, Gray code.
2 UNIT 2: Boolean Algebra
  Boolean operators, Rules (postulates and basic theorems) of Boolean algebra, Dual and complement of Boolean expression, representation of Boolean expression in Canonical form, Boolean expression and their simplification by algebraic method and Karnaugh Map, Don’t care condition.
3 UNIT 3: Logic Gates
  Logic Gates(OR, AND, NOT, NAND, NOR, XOR, XNOR), Truth Tables, De-Morgan’s theorem, Conversion of the logic gates.
4 UNIT 4: Combinational Circuits
  Introduction to Combinational Circuits; Half-adder, Full-adder, Binary Parallel Adder, 4-bit Binary Parallel Adder, Serial Adder; Half-subtractor, Full-subtractor; Multiplexer: Basic 2-Input Multiplexer, 4-Input-Multiplexer, 8-to-1 Multiplexer, 16-to-1 Multiplexer, Multiplexer Applications; Demultiplexer: Parallel-to-Serial Converter, Data Distributors, 1-to-4 Demultiplexer; Encoder: Octal-to-Binary Encoder, Decimal-to-BCD Encoder; Decoder: Basic Binary Decoder, 3-line-to-8-Line Decoder, Magnitude Comparator
5 UNIT 5: Sequential Circuits
  Sequential Circuits; Flip-Flops: RS, D, JK, MS; Counters: Asynchronous , Synchronous; Registers and its types, Shift Registers: Serial in-Serial out Registers, Shift-Left Register, Shift-Right Register, Serial-in-Parallel-out Shift Registers, Parallel-in-Serial-out Shift Registers, Parallel-in-Parallel-out Register, Applications of Shift Registers.
6 UNIT 6: Memory Organization
  Random Access Memory: Types of RAM; Static RAM : Static RAM cell and its structure; DRAM : basic structure of DRAM; Organization of RAM : 2D organization, 3D organization; ROM : Types of ROM, organization of simple ROM cell.

Paper-III Computer Programming using C
1 UNIT 1: Introduction to Programming
  Basic Definition of Pseudo Code, Algorithm, Flowchart, Program, Elementary Data Types: Integer, Character, Floating Point and String Variables; Constants and Identifiers; Variable Declarations, Syntax and Semantics, Reserved Word, Initialization of Variable during Declarations, Symbolic Constants.
2 UNIT 2: Operators and Expressions
  Expression in C; Different Types of Operators: Arithmetic, Relational and Logical, Assignment, Conditional, Increment and Decrement, Bitwise, Comma and Sizeof; Precedence and Associatively of Operators; Type Casting.
3 UNIT 3: Decision and Control Structures
  Various Input /Output Functions: scanf, getch, getchar, printf, putchar; Conditional Statement- if, if- else, nested if-else switch; Other Statement: Break, Continue, Goto; Concept of Loops: While, Do-While, For, Nested Loop.
4 UNIT 4: Storage Class
  Automatic, External, Static, Register, Scope and Lifetime of Variables, Macro, Preprocessor Directive.
5 UNIT 5: Functions
  Function: Function Declaration, Function Definition, Function Call, Function Parameters, Formal and Actual Parameter, Parameter Passing Methods, Recursive Function.
6 UNIT 6: Arrays and Pointers
  Arrays, 1-Dimensional Array, 2-Dimensional Array and its Declaration; String; Pointers: Declaration, Passing Pointer to a Function, Pointer and 1-Dimensional Arrays, Dynamic Memory Allocation.
7 UNIT 7: Structures and Union
  Structure Declarations, Definitions, Array of Structures, Pointers to Structures; Union: Definition, Declaration, Use; Enumerated Data Types; Defining Your Own Types (typedef)
8 UNIT 8: File Handling
  Opening, closing, reading and writing of files. Seeking forward and backward. Examples of file handling programs.
Paper - IV Fundamentals of Networking and Web Technology
1 UNIT 1: Basics of Computer Network
  Computer Network: Definition, Goals; Broadcast and Point-To-Point Networks; Connectionless and Connection-Oriented Services; Network Devices; Network Topologies; Types of Network: LAN, MAN, WAN; Server Based LANs and Peer-to-Peer LANs; Transmission Types; Modes of Communication; Switching Techniques
2 UNIT 2: Network Models
  Design Issues of the Layer, Protocol Hierarchy, ISO-OSI Reference Model: Functions of each Layer; Various Terminology used in Computer Network; Connection-Oriented and Connectionless Services, Internet (TCP/IP) Reference Model, Comparison of ISO-OSI and TCP/IP Model
3 UNIT 3: Transmission Media
  Transmission Medium, Guided Media: Coaxial Cable, Twisted Pair, Fiber Optics Cable; Unguided Media: Radio Waves, Infrared, Micro-wave, Satellite
4 UNIT 4: Internet Basics
  Internet: Architecture, Accessing, Internet Service Providers (ISP), Organization of Internet Protocol suite, IP Address, DNS, URL; World Wide Web (WWW): Web Page, Web Servers, Web Browsers, Cookies
5 UNIT 5: UNIT 5: Static Web Page Design
  Function: Function Declaration, Function Definition, Function Call, Function Parameters, Formal and Actual Parameter, Parameter Passing Methods, Recursive Function.
6 UNIT 6: HTML Tags and XML
  HTML Form; Additional Advanced HTML Tags; Introduction of XML.
7 UNIT 7: JavaScript
  Client Side Programming; Basic Programming Concepts; Control Structures in JavaScript; Array; Functions; Working With Form Object; Built-in Objects in JavaScript, User Defined Objects in JavaScript

Paper – V Computer Organization and Architecture
1 UNIT 1: Digital Component
  Flip-Flops, Counter, Register, Half adder-Full Adder, Half subtractor-Full subtractor, Coder-Decoder, Multiplexer, De-multiplexer, Magnitude Comparator
2 UNIT 2: Input-Output Organization
  Different I/O techniques (Programmed I/O, Interrupt-Driven I/O, Direct Memory Access), I/O Processors.
3 UNIT 3: Memory Units
  Memory Hierarchy, Semiconductor RAM memories, Internal organization of Memory Chips, Read Only Memories; Locality of reference, Cache Memory, Mapping functions, Virtual Memory, Paging; Magnetic Disk, RAID, Optical memories, Magnetic tape
4 UNIT 4: CPU Organizations
  CPU Building Blocks, CPU Registers and BUS Characteristics, Registers and System Bus Characteristics; Instruction Format; Addressing Modes; Interrupts: Concepts and types; Instruction and Execution Interrupt cycle; Hardwired and Micro Program control; Introduction to RISC and CISC
5 UNIT 5: UNIT 5: Multi-Processor Organization
  Parallel Processing, Concept and Block Diagram, Types (SISD, SIMD, Interconnect network, MIMD, MISD), Future Directions for Parallel Processors, Performance of Processors.
6 UNIT 6: Pipelining
  Data Path, Time Space Diagram, Hazards. Instruction Pipelining, Arithmetic Pipelining

Paper - VI Data structure through C language
1 UNIT 1: Introduction to Data Structure
  Basic concept of data, data type, Elementary structure, Arrays: Types, memory representation, address translation functions for one & two dimensional arrays and different examples.
2 UNIT 2: Algorithms
  Complexity, time-Space, Asymptotic Notation
3 UNIT 3: Linked List
  Introduction to Linked List , representation of single linked list, linked list operations :Insertion into a linked list, deletion a linked list, searching and traversal of elements and their comparative studies with implementations using array structure.
4 UNIT 4: Stack
  Definitions, representation using array and linked list structure, applications of stack.
5 UNIT 5: Queue
  Definitions, representation using array, linked representation of queues, application of queue.
6 UNIT 6: Searching
  Linear and Binary search techniques, Their advantages and disadvantages, Analysis of Linear and Binary search
7 UNIT 7: Sorting
  Sorting algorithms (Complexity, advantages and disadvantage, implementation), bubble sort, insertion sort, selection sort, quick sort.
8 UNIT 8: Trees
  Definition and implementation : Binary Tree, Tree traversal algorithms (inorder, preorder, postorder), postfix, prefix notations; Binary Search Tree: Searching in BST, insertion and deletion in BST.
9 UNIT 9: Graph
  Introduction to Graph, Graph representation : adjacency matrix, adjacency list, Traversal of graph : depth first search and breadth first search.

Paper – VII Fundamentals of Database Management Systems
1 UNIT 1: File Structure and Organization
  Data and information, Concept of field, key field; Records and its types, fixed length records and variable length records; Files, operation on files, Primary file organization
2 UNIT 2: Database Management System
  Definition of DBMS, file processing system Vs DBMS, Advantages and Disadvantages of DBMS, Users of DBMS : Database Designers, Application programmer, Sophisticated Users, End Users, Capabilities of good DBMS, Overall System structure
3 UNIT 3: Data Models
  Data Models : Object Based Logical Model, Record Base Logical Model, Relational Model, Network Model, Hierarchical Model, Entity Relationship Model : Entity Set, Attribute, Relationship Set, Entity Relationship Diagram (ERD), Extended features of ERD
4 UNIT 4: Relational Databases
  Relational data model concept, Terms :Relation, Tuple, Attribute, Cardinality, Degree, Domain; Keys : Super Key, Candidate Key, Primary Key, Foreign Key; Relational Algebra – Operations: Select, Project, Union, Difference, Intersection, Cartesian Product, Natural join
5 UNIT 5: SQL (Part I)
  Introduction of SQL, characteristics of SQL, Basic Structure, DDL Commands, DML, DQL, SELECT Statement, WHERE Clause, Useful Relational Operators, Aggregate Functions, SUM Function, AVG Function
6 UNIT 6: SQL (Part II)
  Compound Conditions and Logical Operators, AND Operator, OR Operator, Combining AND and OR Operators, IN Operator, BETWEEN Operator, NOT Operator, Order of Precedence for Logical Operators, LIKE Operator, Concatenation Operator, Alias Column Names, ORDER BY Clause, Handling NULL Values, DISTINCT Clause
7 UNIT 7: Relational Database Design
  Introduction to Normalization, Anomalies of unnormalized database, Normal Form : 1NF, 2NF, 3NF
Paper - VIII Project
A project report has to be submitted as per the given guidelines