|
DETAILED SYLLABUS PGDCA
PGDCA - 1 Computer organisation
1. TYPES OF COMPUTER Analog, Digital and Hybrid type, Hardware, Software, System software, Application software, Stored Program Concept and Von Newman Architecture, Firm ware, Human ware, Stored Program Concept, Evolution of computers, Generation of computer.
2. Background AND NUMBER SYSTEM Information Representation and Codes, Data Types, Complements, Addition and Subtraction of Binary Numbers, Fixed Point and Floating Point Representation, Octal and Hexadecimal System, Conversion of Number Systems, Alpha Numeric Codes – ASCII & EBCDIC, Error Detection Codes, Building Blocks of Computers, Combinational Blocks (Gates, Multiplexers, Decoders, Encoders etc.), Sequential Building Blocks (Flip Flops, Registers, Counters, Random Access Memory, etc.)
3. Register Transfer Language and Micro-Operations Register Transfer Language, Concept of Bus, Bus and Memory Transfer, Arithmetic Micro Operations, Logical and Shift Micro Operations
4. Architecture of a Simple Processor A Simple Computer Organization, Computer Registers, Computer Instructions, Timing and Control, Instruction Cycle, Program Interrupts, Design of Basic Computer
5. CPU Organization Addressing Modes, Instruction Formats, CPU Organization with Large Registers, Stacks and Handling of Interrupts and Subroutines.
6. PROGRAMMING LANGUAGES Machine language, Assembly language, High level language
7. ORGANISATION OF A DIGITAL COMPUTER Input unit, Output unit, Central Processing unit, Memory
8. DATA PROCESSING Data collection, Classification, Sorting and Merging, Processing, Summarising, Storing
9. DATA ORGANISATION Organisation Data, Character, Field, Record, File, Database, Sequential Access, Random Access, Indexed Sequential Access
10. PROGRAMMING PROCESS Problem Definition, Algorithm, Flowchart and coding, Testing and debugging, Implementation, Documentation, Structured Programming
11. DATA COMMUNICATION Local Area Network, Wide Area Network, Satellite Communication, Internet 12. OPERATING SYSTEM Introduction, Different Operating Systems, Loading and Quitting the Operating Systems, Important DOS Commands
PGDCA - 2 OPERATING SYSTEM concepts using windows and linux
1. Introduction to operating system Definition and Necessity, Evolution and types, Concepts, Processor, Computing Environments, Structure, Hardware Organization and Architecture, Design Trends and Implementations
2. Processor and Memory Management Process and States, Context Switching, Scheduling and Synchronization, Inter process Communication, Concurrent Processes, Threads, Critical Regions, Recover Prevention and Solutions of Dead locks, Inter Process Communication for Multi-Threaded and Multiple CPU Systems, Memory System, Types and Organizations, Cache Memory, Allocation Techniques, Partitioning, Static, Dynamic and Augmentation Paging, Swapping, Virtual Memory
3. Input /Output and File Systems Input/Out put devices, Controllers and Channels, BUS structures, Input /Output techniques, Programmed Interrupt driven and DMA, Input /Output Subsystem layers, Graphic Support Devices, Multi Media Systems, File Systems concepts, General Hierarchical Models of file system, File and Directories, Allocation and storage issues, Connectivity, Access control and Security
4. Processor Systems Single CPU and Multiple CPU systems, Types and Needs of multi processing systems, RISC Approach, Pipelining, Client Server concepts, Distributed systems, Networking and Services, Reliability Issues, Fault Tolerant Systems
5. LOCAL AREA NETWORK Introduction to Network, Advantages, Network Technology, Ethernet, Arcnet, IBM Token Ring, Cabling Method, Connectors, Terminators, Hub (Active & Passive), Inter Networking, Bridges & gate ways, Real world networking, LAN Software, LAN commands, User Commands, Supervisor commands, Console commands, use of system utilities, printer queue, SPOOL, local/shared printing, Priority printing, user rights, Workstation Generation, Creation of AUTOEXEC.BAT file, MAKEUSER, user Rights, SYSCON: System configuration, FILER : Directories & Files, FCONSOLE : Menu Utility, File Server, Communication server, File server protocol, Hardware requirements, Hard disk, Memory, Types of workstation & Operating systems, Network bridges, Method of combining various types of topologies together, Setting-up of hardware for LAN installations
WINDOWS
1. WINDOWS INTRODUCTION Operating System
2. Desk top icons My Computer, Recycle Bin, Internet Explorer, Network Neighborhood, My Documents
3. Working with windows How to create a Folder, Copying and cutting files, Renaming
4. START ICON Programs, Favorites, Documents, Settings, Find, Run, Shut down
5. APPLICATION ICONS
LINUX 1. HISTORY 2. DISTRIBUTIONS 3. DEVICES AND DRIVES IN LINUX 4. FILE SYSTEM HIERARCHY 5. COMPONENTS: KERNEL, DISTRIBUTION, SAWFISH, GNOME.
PGDCA-3 personal computer software tools (ms word, EXCEL AND powerpoint)
WINDOWS
1. WINDOWS INTRODUCTION Operating System
2. Desk top icons My Computer, Recycle Bin, Internet Explorer, Network Neighborhood, My Documents
3. Working with windows How to create a Folder, Copying and cutting files, Renaming
4. START ICON Programs, Favorites, Documents, Settings, Find, Run, Shut down
5. APPLICATION ICONS
MS WORD
1. AN INTRODUCTION TO WORD The Word work space, Starting and quitting Word, Creating and Manipulating Various documents, Editing of proofing files, Merging documents and macros
2. HOW TO USE MOUSE AND MENU Working with dialog box
3. PRIMARY COMMANDS IN FILE MENU The Open Commands, The File name commands, The New commands, The Save, Save As, and Save all commands, The Close command, The Page setup, The Print commands, The Exit commands
4. EDIT MENU COMMANDS The Cut, Copy, and Paste commands, The Undo and Repeat commands
5. FORMAT COMMANDS Font commands, Paragraph commands
6. OTHER MENU The view menu, The Insert menu, The tool menu, The table menu, The Window menu
EXCEL
1. BUILDING A SIMPLE WORKSHEET Entering Text, Entering Values, Entering Dates and Times, Moving Around, Selecting Ranges, Using Menu, Using Tool Bar, Using Shortcut Menus, Changing Entries, Copying Entries, Moving Entries, Inserting and Deleting cells
2. FORMATTING BASICS Changing Character Style, Changing Alignment, Changing Column Width
3. WORKING WITH MULTIPLE WORKSHEET Copying entries between work books, Moving sheets between work books, Deleting sheets, Quitting Excel
4. OPENING EXISTING WORKBOOKS Simple calculations, Doing Arithmetic, Totaling column of values, Naming cells and Ranges
5. FORMATTING TEXT Displaying dollars and cents, Formatting decimal places, dates Format, Copying style and formats
6. FORMULAS THAT MAKE DECISIONS Using the IF function, Using the nested IF function, Copying formulas
7. Checking Spelling, Printing Worksheets, Preview Worksheets, Setting up the pages,
8. Sorting data, Keeping Leading in View, Finding records, Adding and deleting Records, Filtering Records
9. Plotting charts, Sizing and moving charts, Updating charts, Changing the chart type, Using chart auto format
10. Creating Macros, Recording Macros, Running Macros
Power Point
1. POWER POINT Main Features of Power Point
2. Making the Presentation Creating Template with the Auto Content Wizard. Creating a Presentation with a Template. Creating a presentation from Scratch
3. Different Views Normal Slide, Outline, Slide Sorter, Slide Show, Notes, Slide Master
4. Animation, Art and Sound Controlling Transitions between slides. Animating Different Parts of a slide. Inserting a Motion Clip. Including Sounds in slides.
5. Including Graphs, Charts, Tables and Columns Organization Chart Slide, Creating a table Slide. Creating two column Slide, Module 1: Showing A Presentation, Rehearsing/ Timing a Presentation, Designation some slides as “Hidden”, Viewing Slides Anywhere in a Slide Show.
6. TECHNIQUES FOR MAKING A SHOW LIVELIER
7. Office Connections Presenting with the help of other Office Programs Importing the text from a World Document.
8. PRINTING A PRESENTATION
PGDCA-4 PROGRAMMING IN c
1. Introduction to Problem Solving & C Programming Overview of C, Introduction, History of C, Importance of C, Sample C Programs, Programming Style, Executing a C Program, Introduction, Constants, Variables and Data Types, Character Set, Comments, Line Comment, Block Comment, Declarations, Operators in C, Arithmetic Operators, Relational Operators, Logical Operators, Hierarchy of Operations, Left to Right Operations, Right to Left Operations, Control Structures in C, Decision Making Statements, if …. else Statement, switch … case Statement and examples, Looping Statements, for loop Statement, while … Statement, do while Statement and examples, Nested Loops, Programs, Number Series, Summation, Base Conversions
2. Arrays and Functions Arrays in C and Concept, One – Dimensional Arrays, Array Processing, Searching, Sorting, Merging, Multi Dimensional Arrays, Two Dimensional Arrays, Matrix Manipulation, Modular Function, Programming Concept, Function Introduction, C Library Function, User Defined Function, Function Declaration, Function Prototype, Function Definition, Scope Rules for Variables, Local Variables, Global Variables, Storage Classes, Automatic, Static, External Registers, Parameter Passing Mechanisms Introduction, Call by Value, Call by Reference, Recursive Functions, and examples, Passing Arrays as Function Arguments
3. Advanced Programming Pointers, Introduction, Uses, Pointers and Arrays, Arrays of pointers, Pointer to Functions, Function Returning Pointers, String representation in C, String Manipulation using Function, Examples, Structures, Introduction, Declaration, Array of Structure, Arrays within Structures, Nested Structures, Pointers to Structures, Structure as Function Arguments, Unions, Declaration, Union Versus Structures, Enumerated Data Types, Typedef
4. File Handling Features File Pointers, Defining File Pointers, Opening and Closing a File, File Functions, Putc(), Getc(), Fread(), Fwrite(), Fscanf(), Fprintf(), feof, ferror, fprintf, fscanf, fgets, fputs, fseek function – ftell, #define , #include, #undef, #if, #else, @elif, File Creation and Modification, Text Manipulation Utilities Line, Word and Character Counting, Case Conversion, Pattern Searching, Command line Arguments, C Preprocessor Header File, Graphics Functions
5. Data Structures Fundamental Concepts, Elementary Data Organization, Data Types, Basic Concepts Stacks, Queues, Linked Lists – Concept, Singly Linked List, Doubly Linked List, Circular Linked List, Insertion, Deletion, Binary Trees, Implementation in C
PGDCA-5 objected oriented PROGRAMMING CONCEPTS USING C++
1. OBJECT ORIENTED PROGRAMMING CONCEPTS Introduction, Need of OOP Concepts, Data hiding, Encapsulation, Polymorphism
2. BASIC CHARACTERISTICS OF OOP Objects, Classes, Inheritance, Reusability, Polymorphism, Operator Overloading
3. C++ PROGRAMMING-BASICS Structure of a Program, Preparations of a program, Functions, Extractions and Insertion Operators, Data types, Variables, Manipulators, Operators, Header files and library files, Error types
4. DECISION MAKING Introduction, Using IF statement, Nesting of IF………..ELSE statement, switch statement, Conditional statement, GO…….TO Statements, Examples
5 MAKING LOOPS Introduction, While Statement, Do Statement, For Statement, Control Statements, Examples
5. FUNCTIONS User defined functions, Defining, Functions- Prototypes, Passing arguments, Return statement, Recursion, Online functions, Examples
7. ARRAYS Introduction, One dimensional arrays, Two dimensional arrays, Arrays of strings, Passing arrays to functions, Examples
8. STRUCTURES Introduction, Definition, Accessing Members, Comparison of Structure Variables, Arrays of structures, Size of structures, Union, Enumerated data type, Examples
9. OBJECTS & CLASSES Introduction, Objects and classes, Public and private, Member functions, Constructors, Destructors, Member functions outside the class, Operator overloading, Examples
10. INHERITANCE Introduction, Derived class and Base class, Accessing Base class members, Protected access specifier Multiple inheritance, Examples
11. POINTERS Under standing pointers, Accessing increments and scale factor, Pointer increments and scale factor, Pointers and Arrays, Pointers and Functions, Pointers and Structures, Memory management with new & delete, Concepts of linked lists, Advantage of lists, Types of linked lists
12. VIRTUAL FUNCTIONS & POLYMORPHISM Introduction, Virtual functions, Late binding, Friend functions, Friend classes, Example
13. FILES AND STREAMS Introduction, Stream class, Opening and closing of files, Allowed modes, Reading and Writing files, File pointers, Command line arguments
PGDCA -6 OPEN OFFICE
1. Overview of OpenOffice.org Calc 1. Describe the features of Open Office Calc 2. The Open Office Calc Screen
2. Entering Information in a Worksheet 1. Entering numeric values 2. Entering text values 3. Entering dates and times 4. Entering notes 5. Entering formulas 6. Saving the workbook 3. Editing the Worksheet 1. Selecting cells and ranges 2. Clearing and deleting cells 3. Undoing commands 4. Using Cut, Copy and Paste 5. Adding rows and columns to the worksheet 6. Entering a series of labels, numbers and dates 4. Formatting a Worksheet 1. Formatting cells 2. Applying an Auto format to a table 3. Changing column widths and row heights 4. Inserting page breaks 5. Organising Information with Workbooks 1. Linking Information between worksheets 2. Using more than one Workbook 6. Customising OpenOffice Calc to work the way you do 1. Using the Zoom command 2. Setting AutoCorrect options 3. Setting Printing Options 4. Controlling Page Orientation 5. Adjusting the Margins 6. Adding gridlines and other options 7. Creating worksheet charts 1. Planning a Chart 2. Creating a Chart 3. Formatting a Chart
PGDCA -7 LAB - I (OS and C)
PGDCA -8 LAB - II (C++)
PGDCA -9 SEMINAR
PGDCA - 10 Database management system USING SQL, PL/SQL AND ORACLE
1. Overview of Database Management Data Information and knowledge, Increasing use of Data as a Corporate Resource, Data Processing versus Data Management, File-Oriented Approach versus Database Oriented Approach to Data Management (Disadvantages of File Oriented Approach), Data Independence, Database Administration Roles, DBMS Architecture, Different Kinds of BMS Users, Importance of Data Dictionary, Contents of Data Dictionary, Types of Database Languages, Data Models
2. Traditional Data Model ANSI/SPARC 3-level Architecture and the Place of Logical Data Models in this Architecture, A brief overview of the three Traditional Models namely Hierarchical Model, Network Model and Relational Model Data Definition and Data Manipulation Constructs in each of the three Models with Examples, A comparison of the Three Models
3. Relational Models Definition of Relation, Properties of Relational Model (Codd’s 12 Rules or Equivalent), Concepts of Keys : Candidate Key, Primary Key, Alternative Key, Foreign, Fundamental Integrity Rules, Entity Integrity, Referential Integrity, Relational Algebra, Select, Project, Cross Product, Different Types of Joints (Theta Join, Equi-Join, Natural Join, Other Joins), Set Operations, Tuple Relational Calculus, Domain Relation Calculus, Simple and Complex Queries Using Relational Algebra, Stand-Alone and Embedded Query Languages
4. Structured Query Languages SQL Constructs (SELECT … FROM … WHERE … GROUP BY … HAVING … ORDERBY…), INSERT, DELETE, UPDATE, VIEW Definition Tables, Temporary Queries, Correlated nested Queries, SQL Standards (SQL ’86, SQL’89, SQL ‘920, Transaction Constraints : Not null, Unique, Check, Primary Key, Foreign Key, References.
5. Embedded SQL and Application programming Interfaces Limitation of SQL in Handling Complex Applications, Programmatic Access to Relational Database, Static Embedded SQL Handling of Nulls, Cursors, Use of SQLCA/SQLLSTATE and Dynamic Embedded SQL, SQLDA, Application Programming Interfaces (API’s), Types of API Calls, Native API’s, Introduction to ODBC (Open Database Connectivity)
6. Database Design ANSI/SPARC 3-level Architecture, Entity – Relationship Model as a tool for Conceptual Design-Entities Attributes and Relationships, ER Diagram, Converting an E-R Model into Relational Scheme, Normalization Concepts in Logical (Relational) Model, Updates Anomalies, Issues in Physical Security
7. Design and Development of Database Application on Commercial RDBMS Platforms Database Design, Applications Design, SQL Embedded SQL, Trouble shooting Performance and Documentation
8. ORACLE SQL Introduction to RDBMS, SQL Procedural Vs Non Procedural Languages, DDL, DML, DCL., Data Types in SQL, Create, Alter, Drop Tables, Insert, Update, Delete Tables, Constraints, Column and Table Level Constraints and NULL value Concepts –Entity and Referential integrities, Range, Searching, Patterns , Matching, Built-in Functions, UNION, INTERSECT AND MUNUS CLAUSES, Indexes, Views, Sequences, Report Creation, JOIN Concepts, Permission Granting and Revoking
9. ORACLE PL / SQL Introduction to PL/SQL, Portability, Execution, Environment, Data types, PL/SQL in SQL PLUS, Executing a PL/SQL Block, Syntax, of PL/SQL, Structure of a PL/SQL Block, Comments, Identifiers, Commit, Rollback, Save points, Cursor, Locks : Shared Locks, Exclusive Locks – Implicit Locking, Explicit Locking, Exception Handling
PGDCA-11 VISUAL PROGRAMMING LANGUAGES VC++
MODULE- I 1.0 MFC - Overview 1.0.1 What is MFC 1.0.2 Advantage s of using MFC 1.0.3 Single document Interface 1.0.4 Multiple document Interfaces
1.1 MFC- classes 1.2 MFC- calls 1.3 Dialog based application 1.4 Document view architecture 1.5 Serialisation 1.6 Database support 1.7 Message handling 1.8 Shared DLL principles MODULE- II
2.0 Introduction to VC++ 2. 0.1 Customizing the IDE 2 .0.2 Using toolbars-Customizing tool bars 2 .0.3 Common Tools 2. 0.4. Creating Visual C++ applications with App Wizard controls 2.0.5. Events defined classes 2.1 C-archieve classes 2.2 Customizing the Application wizard supplied Resources MODULE- III 3.0 MFC Message Architecture 3.0.1 Dialog and property sheet 3.0.2 Dialog and message handling 3.0.3 Constructing Dialogs. 3.0.4 Data Exchange 3.0.5 Constructing Property pages 3.0.6 Adding property sheet objects 3.1 MFC support for common dialogs - colour 3.2 Cfile 3.3 Cfind replace 3.4 Cput 3.6 Common controls 3.7 Animation Header 3.8 List status Window 3.10 Tool bar 3.11 Tool tip and tree control
MODULE- IV
4.0 Introduction to Database Management using VC++ 4.1 Data Access Objects (DAO) 4.2 Open database connectivity 4.3 ODBC - Drivers 4.4 Working with ODBC 4.5 Overview of ODBC and DAO classes 4.6 Database building - Creating a database 4.7 Adding tables 4.8 Using Queries to Data 4.9 Creating text form 4.10 Database application using DAO 4.11Adding reports to an application
MODULE- V
5.0 Using Active X controls 5.0.1Creating Active X Controls 5.0.2.Adding Active X controls to a dialog template 5.0.3Setting control properties 5.0.4.Adding menu bar
5.1 Messages 5.2 Active X controls supplied with VC++ 5.3 Device context and GDI objects 5.4 General Device contexts 5.5 Basic CDC classes 5.6 Part time Device contexts 5.7 Window Device Contexts 5.8 Simple drawing functions 5.8.1 Selecting GDI objects 5.8.2 Basic lines and shapes 5.9 Bit-maps 5.10 Scrolling, Clipping & Printing 5.11 GDI support in MFC 5.12 Building - DLL’s 5.13 Debugging in VC++
VISUAL PROGRAMMING LANGUAGES VB
1. Windows Programming Visual Basic Environment Windows Programming Concepts, Windows GUI, Application Programming Interface, Features of Windows OS, Kernal, User and GUI Services, Other APIS, Memory Models, Message Architecture of Windows, Call Backs, Window Procedures, Message Queries, Graphic Device Context, Resources in Windows, registry Dynamic Kinking Concept, Platform Difference , Windows NT, Windows 95, Other Platforms, Windows and VB Features, Steps involved in Developing a simple VB Application, Visual Basic Environment IDE Features, General – Menus and Windows, Single Document Interface Environment (SDI), Toolbox and Controls, Form Window, Project Explorer, Form Designer, Object Browser Short cut (pop up) Menus, VB Editor, Creating Simple Application
2. Forms, Tool Box, Standard Controls, Menu Designing and Dialog Boxes From, The Anatomy of a Form, Controls, Properties, Events and Methods, MDI Forms, Creating MDI Forms, Using Form Wizard, Tool Box, Controls, Properties, Events and Method, Custom Controls, Properties, Events and Methods, Command Button, Text Boxes, Frame Controls, List Boxes, Combo boxes, Image controls, Timer, Scroll bars, Drive List, Directory List Box, Data Control, Menu Properties, Check Event Menu Methods, Creating Menu with Menu Editor, Menu Design, Sample Menu Design Window, MDI Forms, MDI Parent & Child Forms, Window Menu, Title Converting & Arranging Child Windows, Dialog Boxes, Custom Dialog Boxes, Designing Custom Dialog Boxes, Common Dialog Boxes, File Open, File Save, Color Changing Print, Font Choice – Method.
3. Visual Basic Programming Modules and Design, Variables, Constants, Statements, Control Structures, Decision making Statements, if … else statements, Select … Case, Goto, Looping Statements, Do … while, Do … until, For … next, While … wend, Exit Statements, Functions, Built-in Functions, Working with Sun and Function Procedures, Public, Private & Static Scopes Friend Functions, Arrays, Files, Sequential Files, Random Files, Binary Files, Processing File in VB, Database Features, Data Controls, Advanced Database Controls, Tables and Queries
4. OOPs in VB, IDE and Crystal Reports OOPs Concepts, Properties and Methods of and Object, Inheritance, Encapsulation Polymorphism Character, Object and VB, OLE, OLE Control, Creating an Object in VB, General property Procedures, Creating a New Class Module, Using Object Browsers IDE Features, Extension of IDE with Add-Ins, Loading Add-Ins into IDE, Using Add-Ins Application Wizard, Add-Ins Tool Bar, Creating Add-Ins, Application Level Utility Module Level Utility, Procedure Level Utility, Crystal Reports, Using Crystal Reports Understanding and Using Print Form Methods, Printing Reports
5. Using ActiveX Using ActiveX, ActiveX Platform, ActiveX Requirements, Role of ActiveX in Software Development, Creating & Using ActiveX Documents, ActiveX Controls, ActiveX DLL, ActiveX Excel, Windows API, API Functions, Windows API Library Files, Declaring a Windows API Function, Statements, Data Types, Introducing DLL, DLL Calling Converts, API Viewer Using API Application. Multiple mode, Paintbrush to OS, Linear gradient tool
6. Preparing Image for the WEB Creating WEB Pages with Images
PGDCA-12 COMPUTER GrAphics and multimedia
1. INTRODUCTION TO COMPUTER GRAPHICS
2. GRAPHICAL I/O DEVICE
3. C GRAPHICS LIBRARY
4. TRANSFORMATION OF POINTS
5. LINE & CIRCLE DRAWING ALGORITHMS
6. GRAPHICS PROGRAMMING IN C
7. INTRODUCTION TO MULTIMEDIA
8. DEMONSTRATION OF MULTIMEDIA SYSTEM
PGDCA-13 system analysis and design
1. Introduction Introduction, System Definition and Concepts, Real – Life Business Subsystems, System Models; Types of Models, System Environments and Boundaries, Real – Time and Distributed Systems, Basic Principles of successful Systems.
2. System Analyst Introduction, Role and Need of Systems Analyst, Qualifications and Responsibilities, Systems Documentation as an Agent of Change.
3. System Development Cycle Introduction, Introduction to Systems Development Life Cycle (SDLC), Various Phases, Systems Analyst as an Agent of Change.
4. System Planning Introduction, Data and Fact Gathering Techniques, Feasibility Study and its importance, Types of Feasibility Reports, System selection Plan and Proposal, Prototyping, Cost Benefit Analysis.
5. System Design and Modeling Introduction, Process Modeling, Logical and Physical Design, Design Representations, Systems Flowcharts and structured Charts, Data Flow Diagrams, Common Diagramming Conventions and Guidelines Using DFD and ERD for Data Modeling and System Analysis.
6. Input and Output Introduction, Classification of Forms, Input/Output Forms, User Interface Design, Graphical Interfaces.
7. Modular and Structure Design Introduction, Module Specifications, Module Coupling and Cohesion, Top-down and Bottom-up interfaces.
8. System Implementation and Maintenance Introduction, Planning Considerations, Conversion Methods, Procedures and Controls, System Acceptance Criteria, System Evaluation and Performance, Testing and Validation, System quality Control and Issues.
9. System Audit and Security Introduction, Computer System as an Expensive Resource, Procedures and Norms for Utilization of Computer Equipment, Audit of Computer System Usage, Audit Trails, Types of Threats to Computer System and Control Measures.
Pgdca -14 java programming & INTERNET applications
MODULE - I 1.0 Introduction to Java 1.1 Features 1.1.1 Platform independent, Security 1.1.2 Byte codes and JVM 1.1.3 Java versus C++ 1.2 Java Buzzwords 1.2.1 Simple, object oriented, robust, multithreaded, Architecture Neutral, High performance 1.2.2 Java Applications 1.2.3 Java Applets 1.3 Java Languages 1.3.1 Data types in Java 1.3.2 Integral types - Bytes, short, int, long 1.3.3 Floating points - float, double character 1.3.4 Boolean type 1.4 Variables 1.4.1 Declaration of variable 1.4.2 Dynamic initialization 1.4.3 Scope of variables 1.4.4 Final variables 1.4.5 Type promotion - rules 1.4.6 Type casting 1.5 Literals 1.5.1 Integer, Floating point, Boolean, character and string literals 1.6 Operators 1.6.1 Arithmetic Operators 1.6.2 Relational Operators 1.6.3 Increment and decrement operators 1.6.4 Conditional Operators 1.7 Control Statements 1.7.1 IF, if ...... else, switch.... case 1.7.2 Iteration - while, do while, for break, continue 1.8 A simple java program 1.8.1 Structure 1.8.2 The main () method 1.8.3 Command line arguments 1.8.4 Editing, compiling and executing a java program 1.9 Arrays 1.9.1 Declaring and creating arrays - The new operator 1.9.2 One - dimensional arrays 1.9.3 Multidimensional arrays 1.9.4 Simple programs using arrays, read, print, sort etc MODULE - II 2.0 Object Oriented Programming in Java 2.0.1 Class -syntax - class and method naming conversions 2.0.2 Class members, private, public and protected access. 2.0.3 Creating objects 2.0.4 Object references 2.0.5 Defining Constructors 2.0.6 This keyword and its use 2.0.7 Program example using simple classes 2.0.8 Final member and methods 2.0.9 Static members and methods 2.0.10 Overloading methods 2.0.11 Passing simple types and objects as method arguments 2.1 Packages 2.1.1 Overview of packages in the java library 2.1.2 Java.lang 2.1.3 Java.io 2.1.4 Java.Util 2.1.5 Java. net 2.1.6 Java. awt 2.1.7 Java. sql 2.1.8 Defining a package 2.1.9 Classpath 2.1.10 Importing a package-import statement
2.2 Interfaces 2.2.1 Defining interface 2.2.2 Implementation interface 2.2.3 Interface variables 2.2.4 Extending interfaces 2.3 Exception Handling 2.3.1 Exception class hierarchy 2.3.2 Exception handling-try, catch, throw 2.3.4 Throw clause, finally block 2.3.5 Example program using Arithemetic Exception 2.3.6 Class Not Found Exception and Nullpointer Exception 2.3.7 User defined exceptions-examples
MODULE - III 3.0 Inheritance 3.0.1 Defining inheritance 3.0.2 Sub class, super class 3.0.3 Defining sub class-extends keyword 3.0.4 Creating multi level class hierarchy 3.0.5 Order of constructor execution 3.0.6 Super keyword 3.0.7 Method over riding 3.0.8 Using final to prevent over riding 3.0.9 Abstractclasses 3.1 Multithreading 3.1.1 Definition of thread 3.1.2 Java:lang. Thread class methods 3.1.3 Creating a thread 3.1.3.1 By extending thread class 3.1.3.2 By implementing Runnable interface 3.1.4 Creating multiple threads 3.1.5 Synchroniaing threads 3.1.5.1 Synchronized methods 3.1.5.2 Synchronized statement
MODULE - IV 4.0 Java Library 4.0.1 Srting Handling-string class 4.0.2 String Constructors 4.0.3 String literals, concatenation 4.0.4 Character extraction methods, substring () 4.0.5 Index methods, length () method 4.0.6 String comparison method 4.0.7 Conversion using value of methods 4.1 String Buffer Class 4.1.1 String Buffer constructors 4.1.2 Append (), insert () and replace () methods 4.2 Type Wrapper classes 4.2.1 Uses of type wrapper classes 4.2.2 Integer, Double, Float, Boolan, Character classes 4.3 Math class 4.3.1 The math class methods 4.4 Utility classes 4.4.1 The Vector class 4.4.2 The Hash table class 4.4.3 The Enumeration interface 4.4.4 The Date Class 4.4.5 Random class 4.5 Input / Output in Java 4.5.1 Concepts of streams 4.5.2 Java. in package -io class hierarchy 4.5.3 Input stream, Out put stream, Data input Stream, Data Out put Stream 4.5.4 Reader and Writer classes 4.5.5 Using console input 4.5.6 The file class 4.5.8 File input stream 4.5.9 File input stream 4.5.10 File handling using File Input Steam and File out put stream 4.6 Networking in Java 4.6.1 The I net Address class 4.6.2 TCP / IP classes 4.6.3 Socket class 4.6.4 Server Socket class 4.6.5 Writing a client server program using TCP/IP classes (Simple message passing only)
MODULE - V 5.0 GUI programming 5.0.1 Java awt package 5.0.2 Components and containers 5.0.3 AWT class hierarchy 5.1 Applets In Java 5.1.1 The Applet class 5.1.2 Applets Life cycle methods 5.1.3 Applet drawing methods 5.1.4 HTML applet tags - to embed applets in Web pages 5.1.5 Testing applets with applets viewer tool 5.2 Components classes in AWT 5.2.1 label, text field, Button, Check box, Check box-group, Choice list, Scroll bar 5.3 Container classes 5.3.1 Panel, Frame, Window 5.4 Layout Manager - Flow layout, Grid layout, Border layout, Card layout 5.5 Event handling 5.5.1 Event model, Listeners 5.5.2 Listener objects 5.5.3 Listener interfaces for most types of events 5.6 JDBC 5.6.1 The 3 Tier architecture
INTERNET applications
1. INTRODUCTION TO INTERNET Understanding Networks, Getting to know web browsers, Getting to know the Internet Explorer Window
2. APPLICATIONS Internet Electronic Mail, Setting up E-mail, Creating Mail Messages, Editing Mail Messages, Attaching a file to a Mail message, Sending and receiving mail messages, Creating and using an Address Book
3. SEARCHING AND BROWSING ON THE INTERNET Internet Searching, Tools for Specialized Searches, Finding Specific Topics
Pgdca -15 computer networkS
1. Introduction Communication System, Analog Data, Digital Data, Synchronous and Asynchronous Data Transmission, Serial and Parallel data transmission, Simplex, Half duplex, Full duplex modes of communication.
2. Transmission Media Guided or Bounded media: - Twisted pair, Coaxial Cable, Optic fiber. Non-Guided or Unbounded media: - Terrestrial microwave link and Satellite Microwave link, Radio, Infrared.
3. fiber-optic communication Optical source, Propagation in fiber, Light detector, Types of fiber- mono mode, multi mode, step index, graded index, advantages of fiber-optic communication, FDDI - Fiber distributed data interface.
4. Data Modems Concept of Modulation , Amplitude Shift Keying (ASK), Frequency Shift Keying (FSK), Phase Shift Keying (PSK).
5. MULTI CHANNEL DATA COMMUNICATION Concept of multi channeling, Multiplexing:- Frequency division multiplexing, Time division multiplexing, Pulse code modulation, CODECS.
6. NETWORK CLASSIFICATION LAN, WAN, MAN,VAN, Applications of networks, Advantages of networks, hardware requirements for a network, Network security, firewall.
7. DATA NETWORKS Switching techniques:-Circuit switching, message switching, packet switching. Network Topologies: - Bus, Ring, Star, Tree, Hybrid, completely connected networks, point-to-point and broadcast types.
8. NETWORK PROTOCOLS Network Architecture, Protocol Hierarchies, OSI Terminology, 7 layers of OSI model, Ethernet and Token ring, x.25 protocol, ISDN.
8. WIRELESS COMMUNICATION Satellite communication, GSM, Cellular Radio.
PGDCA-16 INTRODUCTION TO VISUAL STUDIO.NET
MODULE - I 1.0 Introduction to .net technologies 1.1 Overview of Visual studio. Net 1.2 .Net Languages 1.3 Comparison of .Net languages 1.4 Common Language Runtime 1.5 .Net frame work 1.6 .Net frame work security 1.7 Advantages of .Net frame work 1.8 Glass Library 1.8.1 Assemblies 1.8.2 Namespace 1.9 Execution of application in the .net Frame work 1.10 Application domains 1.11 Common type system
MODULE - II 2.0 Vb. net 2.1 Comparison with previous version of Visual Basic 2.1.1 Variable declaration changes 2.1.2 Array declaration changes 2.1.3 Data type charges 2.1.4 Logical operator changes 2.1.5 Changes in control statements 2.1.6 String declaration changes 2.2 Creating new window Applications Using vb.net 2.2.1 Creating Forms 2.2.2 Adding controls to forms 2.2.3 Writing event driven codes to the form controls 2.2.4 Arranging controls in form 2.2.5 Adding controls at runtime 2.2.6 Aligning, anchoring, docking and layering of controls 2.2.7 Creating dialog boxes 2.2.8 Displaying message boxes 2.2.9 Implementing MDI forms 2.2.10Programming with clipboard 2.2.11Using String methods and string handling techniques 2.2.12Using control statements for powerful codes (IF - then - next, for -each, do-loop) 2.2.13Writing Procedures and function 2.2.14Delcaring and passing arguments 2.2.15Overloading procedure 2.2.16Using Optional arguments in Procedure 2.3 Implementation Vb. net Classes 2.4 Error handling in Vb .net 2.5 Database Programming 2.5.1 Using ADO. net 2.5.2 ADO. net Components 2.5.2.1Data sets 2.5.2.2Data adapters 2.5.3 Creating data entry screen for accepting and displaying data 2.5.4 Setting data adapters for storing and retrieving data 2.5.5 Data form wizard MODULE - III 3.0 VC . Net 3.1 Introduction to VC .net 3.2 Types of VC .net applications 3.3 Programs with Managed and without managed extensions 3.4 Project Templates in Visual C++ net 3.4.1 ATL Project 3.4.2 MFC Projects 3.4.3 Managed Projects 3.4.4 Other Projects templates 3.5 Creating forms and adding menus 3.6 Creating Dialog boxes 3.7 Painting the screen 3.8 Developing MFC applications 3.9 Database programming in Visual C++ .net 3.10 Managed extension for C++ 3.11 Exception Handling
MODULE - IV 4.0 C#. Net 4.1 Introduction to C# 4.2 Variable types 4.3 Type conversions 4.4 Visual C# operators 4.5 Introduction to C# statements 4.6 Declaration of arrays 4.7 Single and Multidumensional arrays 4.8 Introduction to Jagged Arrays 4.9 Creating classes in Visual C# 4.10 Creating Windows Applications 4.11 Creating windows Services 4.12 Installation and Administration of Services
MODULE - V 5.0 ASP.Net 5.1 Introduction to ASP.net 5.2 ASP.NET AND .NET frame work SDK 5.3 Creating Web forms 5.3.1 Adding controls 5.3.2 Web page processing 5.4 Introducing to HS 5.4.1 Installation - Creating virtual Directory 5.5 Using HTML and XML in ASP.net 5.6 Server side programming using ASP.net 5.7 Using Validation controls in ASP.net pages 5.8 Using ADO.net with ASP.net 5.9 Running a site using HS and ASP.net
PGDCA -17 LAB – I (Graphics and Multimedia)
PGDCA -18 LAB – II (Oracle)
PGDCA -19 LAB – III (Java)
PGDCA -20 LAB – IV (VB and VC++)
PGDCA -21 LAB – V (Visual Studio.net)
PGDCA -22 PROJECT AND VIVA
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||