Post Graduate Diploma In Computer Applications (PGDCA) and Post Diploma In Computer Applications (PDCA)

I. Details of course

Stream : Full – Time

Eligibility :

PGDCA: Degree in any discipline from any one of the universities in Kerala or recognized by any one of the universities in Kerala.

PDCA: Diploma issued after studying a three year course recognized by the board of Technical Education

Duration : The normal duration of the course is 1 year comprising of 2 semesters. The classes will be held on all week days- 3 hours per day.

Examination: There will be examination at the end of each semester.

Fees: Course fee and examination fee will be fixed by RUTRONIX from time to time. Candidates should remit the examination fee as and when notified.

Re-admission Rules: Students who discontinue the course after the commencement of the classes and who are not eligible to appear for the examination due to shortage of attendance can get admitted to the same semester on request as per the existing terms and conditions of RUTRONIX on condition that the candidate shall study the course and attend examination as per the scheme and syllabi of the course to which he/she is re-admitted.

Certification: Progress of the trainees is evaluated on their performance in theory and practical. An appropriate grading system is employed in the assessment of performance. Certificate will be issued to all successful students. Students who score a minimum of 40% marks in the final examination and 50% overall average ( internal and final marks put up together) alone would be declared successful. Those who failed to get 50% average should register for subjects in which the average mark is less than 50% (in that particular subject). In such cases the new mark alone will be considered for declaring results.

1

Note:

1. Scholarship will be provided to eligible female & male applicants as per norm set forth by RUTRONIX. Others are required to pay the specified course fee.

Scholarship amount shall be changed and will be communicated to ATCs and students then and there or before the admission notification of a particular batch.2. Syllabus ,Scheme of examination etc. will be changed as decided by RUTRONIX from time to time

Rules and regulations of conduct of class/examination:

1. Instructional duration in an academic year:Each semester consists of a minimum of 20 weeks of instruction, including intervening holidays and excluding period of examinations and study holidays.2. The course will follow a semester pattern, with an end semester examination, conducted by RUTRONIX.3. Classes will be held on all week days at 3 hours per day and thereby a minimum of 19 hours per week.

II. SCHEME OF COURSE

Training Schedule

Semester I (20 WEEKS)

Paper No. subject Theory hours per week

Lab hours per week

Marks Total

Internal External

Theory-I Computer fundamentals, OS, internet concepts and Office suite

3 -- 50 100 150

Theory -II Java , C++ and Data structures using C++

4 -- 50 100 150

Theory-III System Engineering ,DBMS and SQL

3 -- 50 100 150

Lab-I OS & Office -- 2.5 50 100 150

2

suitLab II CPP & Java -- 4 50 100 150Lab III SQL -- 2.5 50 100 150Total 10 9 300 600 900

Semester II (20 WEEKS)

Paper No. Subject Theory hours per week

Lab hours per week

Marks Total

Internal External

Theory-IV Web design and PHP/ASP.Net

3 -- 50 100 150

Theory -V VB and VB.net 3 -- 50 100 150Theory-VI Data

Communication and Computer Networks

3 -- 50 100 150

Lab-III Web design & PHP/ASP.Net

-- 3 50 100 150

Lab IV VB and VB.Net -- 3 50 100 150Project & Seminar 3 50 100 150

Total 9 9 300 600 900

III. MODULE WISE SYLLABUS

PAPER SUBJECT THEORY(Hrs) PRACTICAL(Hrs)

Semester I

ICOMPUTER FUNDAMENTALS, INTERNET CONCEPTS, OS AND OFFICE SUITE

60 50

IIJAVA, C++ AND DATA STRUCTURES USING C++ 80 80

IIISYSTEM ENGINEERING, DBMS AND SQL 60 50

Total 200 180

Semester II

IV WEB DESIGN AND PHP/ASP.NET 60 60

VVISUAL BASIC AND VISUAL BASIC.NET 60 60

VIDATA COMMUNICATION AND COMPUTER NETWORKS 60

3

Project 60

180 180

IV. DETAILED SYLLABUS

PAPER I: COMPUTER FUNDAMENTALS, INTERNET CONCEPTS, OS AND OFFICE SUITEModule I: Computer fundamentals(Theory:30 hrs)Introduction to computers :Computer -Definition, Characteristics etc., Generation of computers, Classification and Types of Computers, Basic Computer organization, History of ComputersNumber Systems :Various Digital Number Systems, Base Values, Converting from one number system to another, Arithmetic using 1's and 2's complement, Binary addition and subtraction, data representation codes-ASCII Microprocessors: different processors, clock speed, CPU speed Computer Memory: various classifications-Primary and secondary Electronic, Magnetic and OpticAbout RAM - Classifications, Cache memory About ROM-ClassificationsMemory devices:Secondary Storage Devices(Floppy Disk, Zip drive, Hard disk, Optical disk, DVD, Blue Ray Disk, Pen drive)Input devices: commonly used devices(Keyboard, mouse, Joy stick, touch pad, touch screen, track ball, light pen, scanner, MICR, OCR, OMR, Bar code reader)Output devices:Soft copy devices - various types of monitorsHard copy devices- Impact and non impact printers, plotterComputer hardware :Definition, About Mother board and other types of cards, types of cabinets, power supply unit etc. About cards and ports (ATA,IDE,SATA,SCSI, Extension BUS and Slots, ISA-PCI ,AGP etc.,& About -Input-output ports (VGA,USB, Ethernet, fire wire, audio, game port, bluetooth, wifi etc.)CPU - various parts and its functioningComputer Software :About computer software- different classifications-system software(OS & Language processors), Application software-subdivisionsComputer Virus-how does it infect computers, different types, precautions for protection & anti virus software’sProgram Logic & Flow ChartInternet concepts (Theory 5 hrs. Practical 10 hrs.) About Internet, Intranet, Extranet, Hardware & software requirement for internet (mention about modem, ISP, Browser –chrome, opera, internet explorer, fire fox etc.)- Types of internet connection and Internet services-WWW ,e-mail, attach files to email, downloading ,e-commerce, chatting, blog , Google calendar, Google documents, twitter, You tube, future mails etc.Module II- Operating systemsMs-Dos: (Theory 4 hrs. :Practical 5 hrs)MS-DOS-Loading Operating system-boot sector &booting-boot sequence of dos system file-dos prompt-types

4

of dos commands-external & internal-CLS,DATE,TIME,VER,VOL,DIR-VAROIUS SWITCHES(/W,/S,/L,/B)-SORTING OF DIRECTORY LISTINGcopy con, type, ren , copy (all options),del/erase, wild cards, prompt, directory and sub directory- sub directory commands, CD,MD,RD,CD..,CD\ & path About files-file naming-types of files & file extensions(Program files, data files, text files, system files etc., batch files-special commands in batch fileExternal Dos commandslabel,mem,chkdsk,tree,deltree,more,diskcopy,diskcomp,format,scandisk,sys,xcopy,attrib,fdisk(hard disk partitioning), -.exe, .com, .bat filesWindows: (Theory 4 hrs. :Practical 10 hrs)About windows Operating System- different versions in hierarchical order-elements of windows screen-desktop-icons-system icons(my computer, my document, network neighbor hood, recycle bin)-shortcut icons(program, folder, documents etc.),task bar and taskbar components, using mouseThe start menu - different options, starting a program, elements of a window, My computer icon etc., create files & folders, Windows accessoriesMore about internet explorerLinux: (Theory 4hrs: Practical 10 hrs)About Linux operating system- features-differences between other operating systems-Linux distributionsLinux utilities – image viewer, file compression and decompression, sound player, movie player, internet browser, drawing utilities etc.Linux commands: Linux terminals –cp.mv,ls,clear,exit,date,rm,echo,pico,diff,grep,mke2fs,man,mkdir,less,mv,pwd,cd,cd...,date,free Module III :Office suite ( Theory 13 hrs.: Practical 15 hrs) About Word processors- Ms-word & open office writer-features, screen structure, Screen components using tools, tool bars, default file extension etc.Different menus and menu commandsImportant tools- autocorrect, spell check, mail merge, about data files etc.About spread sheets-Ms-excel & open office calc - features, screen structure, Screen components using tools, tool bars etc.Concepts of work books and work sheets, default file extensions, Different menus and menu commands, Data types, functions ,formulae, charts, formatting cells, Pivot table, outlining etcAbout presentations- Power point & open office impress--features, screen structure, Screen components using tools, tool bars, default file extension etc.Different menus and menu commandsSpecial Features for an effective presentation.About handling of database-Ms-Access &open Office Base: creating database- default file extensions, database objects(tables, queries, forms, reports),tables & field properties-primary keyMore about query, form & report

PAPER II- JAVA, C++ AND DATA STRUCTURES USING C++Module I- C++ (Theory 30 hrs.: Practical 30 hrs )Principles of Object-Oriented Programming: Object-Oriented Programming Paradigm, Basic Concepts of Object-OrientedProgramming, Benefits of OOPS, Applications of OOP C++ Statements, Structure of C++ ProgramTokens, Expression and Control Structures:Introduction, Tokens, Keywords, Identifiers and Constants, Basic Data Types, User- Defined Data Types, Derived Data Types, Symbolic Constants, Type Compatibility, Declaration of Variables, Dynamic Initialization of

5

Variables, Reference Variables, Operators in C++,Scope Resolution Operator, Member Dereferencing Operators, Memory Management Operators, Manipulators, Type Cast Operator, Expressions and their Types, Special Assignment Expressions, Implicit Conversions, Operator Overloading, Operator Precedence, Control Structures, Structures, Functions, Arrays, Strings, String library Functions.Classes and Objects:Specifying a class, Defining Member Functions, Making an outside Function Inline, Nesting of Member Functions, Private Member Function, Array within a class, Memory allocation for objects, Static Data Member, Static Member Functions, Array of Objects, Object as function arguments.Constructor and Destructors:Introduction, constructors, parameterized Constructors, Multiple constructors with Default Arguments, Dynamic Initialization of Objects, Copy Constructors, Dynamic Constructors and Destructor.Function 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, Recursion.Inheritance: - Extending Classes Introduction, Defining Derived Classes, Single Inheritance, Making a Private Member. Inheritance, Multiple Inheritances, Multilevel Inheritance, Hierarchical Inheritance, Hybrid Inheritance. Pointers, Virtual Functions and Polymorphism Compile time Polymorphism, run time Polymorphism, Pointers to Objects, This Pointer, Pointers to Derived Classes, Virtual Functions and Pure Virtual Functions.Pointers, Virtual Functions and PolymorphismIntroduction, Pointers, Pointers to Objects, This Pointer, Pointers to Derived ClassedManaging Console I/O OperationsC++ Streams, C++ Stream ClassesWorking With filesClasses for File Stream Operations, Opening and Closing a file, Detecting end –of-file, More about Open (): File Modes, File Pointers and Their Manipulations, Sequential Input and Output Operations, Updating a File: Random AccessException HandlingBasics of Exception handling, Exception Handling Mechanism, Throwing mechanism, Catching mechanism, Rethrowing an ExceptionModule II- Java (Theory 30 hrs.: Practical 30 hrs )

Java Evolution –Java history- Java features- compiled an interpreted ,platform independent and

portable , object oriented, robust and secure, distributed , simple, small, and familiar , multithreaded

and interactive, high performance, dynamic and extensible – How Java differs from C++ - Java and

Internet-Java and world Wide Web – Hardware and software soft ware requirements-Java support

systems –Java Environment- Java development kit , application programming Interface

Overview of Java language- Simple Java program-class declaration, opening brace, the main

line ,the output line – Use of math functions- comments –An application with two classes-Java

6

programme structure- documentation section, package statement, import statements, Interface

statements, Class definitions ,main method class-Java tokens- Java character set, Keywords,

Identifiers , Literals ,operators ,separators-Java statements-Implementing a Java program-creating

the program, compiling the program, running the program – Java virtual machine –Command line

arguments-programming style

Constants, Variables and Data Types:

Constants- integer constant ,real constants, single character constants, string constants, backslash

character constants- Variables-Data types-Integer types, floating point types, character

type ,Boolean type – Declaration of variables-giving values to variables-assignment statement, read

statement-Scope of variables-Symbolic constants-Type casting-automatic conversion-getting

values to variables-Standard default values.

Operators and Expressions: Arithmetic operators: Integer arithmetic, real arithmetic, Mixed –mode

arithmetic-Real operators, Logical Operators-Assignment operators-Increment and decrement

operators-Conditional operator-bitwise operators-special operators-instance of operator, dot

operator – Arithmetic expressions-Evaluation of expressions-precedence of arithmetic operators-

type conversion expressions-automatic type conversion, casting a value-Operator precedence and

associativity -Mathematical functions

Decision making and branching : Decision making with if statement, simple if statement, simple if

statement, the if –else statement-nesting of if-else statements-the else if ladder-the switch

statement, the ?:operator

Decision making and looping: the while statement, the do statement, the for statement-

additional features of for loop-nesting of for loops-Nesting of for loops-jumping out of a

loop ,skipping out of a loop- Labeled loops

Classes, Objects and methods: defining a class- adding variables-adding methods-creating objects-

accessing class members- constructors, methods overloading-static members-nesting of methods-

inheritance-extending a class-defining subclass-subclass constructor, multilevel inheritance,

7

hierarchical inheritance- Overriding methods-final variables and methods-abstract methods and

classes- visibility control- public access-friendly access- protected access-private access- private

protected access-rules of thumb

Arrays ,Strings and Vectors : arrays – one dimensional arrays- creating an array- declaration of

arrays ,creation of arrays, initialization of arrays, array length- Two dimensional arrays – variable size

arrays- strings- string arrays, string methods, string buffer class- Vectors

Interfaces: Multiple Inheritance –defining interfaces-extending interfaces-implementing interfaces-

Accessing interface variables

Packages : Putting classes together- Java API packages- using system packages-naming conventions-

creating packages accessing a package- using a package-adding a class to a package –hiding classes

Multithreaded programming : crating threads-extending the thread class- declaring the class-

implementing the run( ) method, starting new thread –Stopping and blocking a thread – stopping a

thread, blocking a thread-life cycle of a thread-newborn state, runnable state, running state, blocked

state ,dead state – Using thread methods-Thread exceptions-thread priority ,Synchronization-

implementing the runnable interface

Managing errors and exceptions: types of error- compile time errors, runtime errors - exceptions-

syntax of exception handling code-multiple Catch statements-Using finally statement- Throwing our

own exceptions-using exceptions for debugging

Applet programming: Local and remote applets-how applets differ from applications-preparing to

write applets, building applet code-Applet Life Cycle-initialization state, running state, Idle or

stopped state, dead state, display state-Creating an executable applet- designing a web page-

comment section ,head section, body section- Applet Tag- Adding applet to HTML file –running the

applet-more about applet tags-passing parameter to applets-aligning the display-more about

HTML tags-displaying numerical values-getting input from the user and program analysis

Graphics programming: The graphics class- lines and rectangles-circles and ellipses-drawing arcs-

line graphs-using control loops in applets-drawing bar charts

Managing input-output files in Java: concept of streams-stream class-byte stream class – input

stream classes, output stream classes- Character stream classes –reader stream classes, writer

stream classes – Using streams –other useful I/O classes, using the file class, Input/output exceptions

8

–creation of files-Reading /writing characters, reading/writing bytes-handling primitive data types-

concatenating and buffering files. – random access files- interactive input and output- simple Input

and output – other stream classes – object streams ,piped streams, pushback streams filtered

streams

Networking : Socket programming- server socket(TCP/IP)-client socket (TCP/IP)-server sending

message to client-Echo-server and client-datagram packet .datagram socket-UDP server –client

conversation- URL – URL class –URL connection -JDBC and ODBC- Types of Drivers-Java SQL package-

using JDBC-Driver Manager-creating connection-connection interface-creating statements-Statement

interface-executing statements-prepared statement interface-Callable statement interface –

ResultSet interface

Module III- Data Structures using C++: (Theory 20 hrs)Introduction to Data Structure, SORTING(bubble sort, selection sort, insertion sort)Recursion Advanced Sorting Techniques(shell sort, quick sort, merge sort)SEARCHING (Sequential searching, Binary searching)STACKS using Arrays-push and popQUEUES using arraysCircular QUEUES using arraysLinked Lists – Linear Linked List, Double Linked List, Stacks Using Linked List, Queues Using Linked List, Circular Queues Using Linked ListBINARY TREESPAPER III SYSTEM ENGINEERING DBMS AND SQLModule I: System Engineering: (Theory 20 hrs)Introduction to System Engineering-System Definition and concepts: General Theory systems, Manual and automated systems, Real-life Business Sub-Systems. System Environments and Boundaries. Real time and distributed systems. Basic principles of successful systems. Approach to system development: Structured System Analysis and Design, Prototype, Joint Application DevelopmentSystems documentation consideration: Principles of Systems Documentation, Types of documentation and their importance, Enforcing documentation discipline in an organizationSystem Planning: Data and fact gathering techniques: Interviews, Group Communication, Questionnaires, And Presentations & Site Visits. Assessing Project Feasibility: Technical, Operational, Economic, Cost Benefits Analysis, Schedule, legal and contractual, Political. Modem Methods for determining system requirements: Joint Application, Development Program, Prototyping, Business Process Re-engineering. System Selection Plan and Proposal-Post implementationModular and Structured Design: Module specifications. Top-down and bottom-up design. Module coupling and cohesion. Structure ChartsInput/Out put: Classification of forms, Input/output forms design. User-interface design, Graphical interfaces. Standards and guidelines for GUI design. Designing Physical Files and Databases: Designing Fields, Designing Physical Records, Designing Physical Files, Designing Databases. Introduction to CASE Tools, Features, Advantages and Limitations of CASE Tools, Awareness about some commercial CASE Tools. System Implementation and Maintenance :

9

Planning considerations. Conversion methods, procedures and controls. System acceptance criteria. System Evaluation and Performance. Testing and Validation. Preparing User Manual. Maintenance Activities and IssuesIntroduction to Management Information System (MIS) :Meaning and role of MIS-Systems approach to MIS-Types of information systems: Transaction Processing System, Management Information System, Decision Support System, Expert System Case Studies (Illustrative): MIS for Accounting and Finance Function.MIS for Marketing System.Module II:DBMS (Theory 30 hrs)Introduction: Why Database, Characteristics of Data in Database, DBMS, What is database Advantage of DBMSDatabase architecture& modeling :Conceptual, physical and logical database models, Role of DBA, Database DesignEntity and relational Data models: Components of ER Model. ER Modeling Symbols. Super Class and Sub class types. Attribute inheritance. Specialization. Generalization. CategorizationRelational Data Models: Introduction to Relational DBMS , RDBMS Terminology Database Normalization: Keys, Relationships, First Normal Form., Functional dependencies, Second Normal form, Third Normal Form, Boyce-Codd Normal form, Fourth Normal Form, Fifth Normal form, Case studyRelational Algebra and Relational Calculus: Relational Algebraic operations, Tuple Relational calculus, Domain Relational CalculusBack up and Recovery:-Database backups - Why plan backups? Hardware protection and redundancy. Transaction logs. Importance of backups. Database recovery. Data storage. Causes of failures. Recovery concepts and terminology. Recovery facilities. Recovery techniques. Detached transaction actions, Disaster Database Management SystemDatabase Security and Integrity: Types of Integrity constraints. Restrictions on integrity constraints. Data security Risks. Complex user management requirements. Dimensions of security. Data security requirements. Database users. Protecting data with in the database. Granting and revoking privileges and roles. System viability Factors. Authenticating users to the database.Design and Development of Database Applications on Commercial RDBMS Platforms: Module III: SQL( Theory 10 hrs.: practical 50 hrs))Introduction to SQL: History of SQL. Characteristics of SQL. Advantages of SQL. SQL data types and literals. Types of SQL commands. SQL Operators and their precedence. Tables, views and Indexes. Queries and Sub queries. Aggregate functions. Insert, Update and Delete operations. Joins, Unions, Intersection, Minus. Cursors in SQL Embedded SQL, stored procedures ,Functions(Built-in functions and user defined functions)

SEMESTER IIPAPER IV- WEB DESIGN AND PHP/ASP.NETModule I-Web Design( Theory 30 hrs.: practical 30 hrs)About HTML, Tags, HTML page creation and editing, Headings, paragraphs, Break and horizontal rules, Character formatting, List, images and links, marquee, rollover images, creating tables, frames, forms, About HTML Editors - create HTML pagesJava Script: Introduction, uses, writing JavaScript codes-steps to be followed, Enabling Java script in Internet explorer, Firefox and in Opera-importance of JavaScript enabled browser ,Where to place java script in a web page etc., Java script operators and variables, variable naming conventions, Writing simple java script codes using variables, Java script functions- advantages of using functions-syntax and writing of segments for illustrating functions, Events in JavaScript- illustrate with simple JavaScript codes, JavaScript statements-

10

conditional-Loops-object manipulation statements-comment statements-exception handling statements, Illustrate with syntax and example java script programs-if, else-if -while loop-for loop, Java script array, Creating JavaScript alert-when to use pop ups and alerts, Java script confirm, JavaScript prompt ,print etc.,Other important functions -window. open, date and time object etc., JavaScript form validation-with different options- String related functions, About java script inner HTMLCascade style sheets(CSS): CSS Fundamentals-uses-cascading order, CSS syntax, grouping, class selector, add styles to elements, CSS commentsModule II:PHP OR ASP.NET ( Theory 30 hrs.: practical 30 hrs)PHP: Introduction to PHP- advantages of using PHP-PHP installation, embedding HTML into a PHP script-PHP comments, All about PHP variables and constants, More about PHP constants-predefined, environment related constants, mathematical constants., All about PHP operators, About PHP Functions-how to write PHP functions-different methods, Arrays-creating arrays-accessing array elements, single dimensional and multi dimensional arrays, Using array pointers, Changing ,adding and removing of array elements, looping through array elements, sorting of an array, Working with strings & text in PHP, About PHP file system & file I/O, About PHP -cookies and Sessions, create / delete cookies and sessions etc., PHP-Object Oriented Programming, PHP-Object Oriented Programming, Using PHP with My SQLPAPER V: VISUAL BASIC AND VISUAL BASIC.NETModule I: VISUAL BASIC ( Theory 30 hrs.: practical 30 hrs)Introduction to Integrated Development Environment: Elements of VB IDE: Menu bar, Toolbar, Project explorer, Toolbox, Properties window, Form designer, Form layout, Immediate, Locals and Watch window, Edit, View, Run, Debug, Object Browser.Managing Projects : Concepts of VB projects-Creating the Project, Opening, Renaming and Saving the projects, Elements of user interface, Designing the User Interface, Creating forms and code modules, Aligning the controls.Managing Projects: Visual development and event-driven programming Common properties, Methods, Common events.-Customizing the environment Editor tabs, Format tab, General tab, Docking tab, Environment tab.Visual Basic Programming Elements: Variables, Declaring variables, Data Types, Converting variables types, User defined data types, Forcing variables declarations, Scope of variables, Lifetime of a variable -ConstantsCollection objects, Arrays: Declaring Arrays, Sorting Arrays, Control Arrays, And Dynamic Arrays.Procedures-Sub procedures, Function procedure, Control Structure: Control flow Statements, Looping Statements and iteration, Conditional Statements.The Input/Output: Input Box, Output Box, Form Printing methods.Working with Forms :- The appearance of forms, Form properties, Events, Methods, Controlling one form within anotherBasic ActiveX Controls :The Textbox control, Basic properties, Manipulating the control's text, Text selection, Search and replace operations, Capturing keystrokes. List Box and Combo Box Controls:Basic properties, List box control's method, Arrows, Indexing with the List Box control, Searching a sorted list. Scrollbar and Slider controls:Scrollbar control, Scrollbar control's event, Timer Control.Graphics with Visual Basic : Form-- Picture Box-- Image Box controls-- Setting picture and image properties-Exchange image through the clipboard-- Coordinate systems Scale properties and methods.The Drawing Methods:Drawing text, Drawing lines, Drawing boxes, Circle Method, Drawing Modes, Drawing Curves, Manipulating pixels, Specifying colours, Specifying gradients, Using the Paint-Picture method, Processing images, Optimizing

11

issues: refresh, Transparent Drawings.Manipulating Text:Working with files-file storing concept-record -field-I/O-types of files-opening and closing of filesDatabase applicationsModule II: VB.Net ( Theory 30 hrs.: practical 30 hrs)Introduction-.An overview of .NET frame workVariables and operatorsControl structuresAll windows formsCommon Controls: Button-Check Box-Checked List Box-Color Dialog-Combo Box-Date Time Picker-Label-Link Label-List Box-List View-Masked Text Box-Month Calendar-Notify Icon-Numeric Up Down-Picture Box-Progress Bar-Radio Button-Rich Text Box-Text Box-Tool Tip-Tree View-Web BrowserContainers: Flow Layout Panel-Group Box-Panel-Split Control-Tab Control-Table Layout PanelMenu & Toolbars: Context Menu Strip-Menu Strip-Status Strip-Tool Strip- Tool StripData: Data Set-Data Grid View-Binding Source-Binding Navigator-Report ViewerComponentsPrintingDialogs: Color Dialog-Folder Browser Dialog-Font Dialog-Open File DialogSave File DialogCrystal Reports: Crystal Report Viewer-Report DocumentBuilt tin functions, Sub Procedures &functionsString functions- Compare, Concat, Join, Insert, Remove, Replace, ToUpper, ToLower, Format, Trim, TrimStart, TrimEnd, PadLeft, PadRight

Math Functions- Math.Ceiling, Math.Exp, Math.Log10, Math.Max, Math.Min, Math.Floor, Math.RoundValidity Functions- isNumeric , isDate , isCurrency , isAlphaSub ProceduresFunctionsParametersUser control: User Control Basic-Creating User ControlClass and modules: OOP Basic-Class Declaration-Class Members- Fields, Properties, Methods, Events-Declaration type- Public, Private, Protected, Friend, Protected Friend-Object CreationWorking with ADO.net: Evolution of ADO.NET-Why ADO.NET?-The ADO.NET Data Architecture-Data Set-Data Provider-Data access with ADO.NET-The Connection Object-The Command Object-The Data Reader Object-The Data Adapter ObjectPAPER V1: DATA COMMUNICATION AND COMPUTER NETWORKS (Theory 60 hrs.)DATA COMMUNICATIONS: Multiplexing, Signaling, Encoding & Decoding, Error Detection & Recovery, Flow Control, Mode of transmission (Serial, Parallel, Synchronous, Asynchronous, Analog, Digital),Type of Communication(Simplex, Half Duplex, Full Duplex) COMMUNICATION NETWORKS: Introduction to networking, Advantages of Networking, Network Components(Cables, Hubs, Bridges, Switches, Routers), Network Topologies (Bus, Star, Ring, Star Bus, Star Ring, Mesh), Shared Medium, Peer to Peer, Hybrid Technology, Internet, ATMNETWORK TYPES: ( LAN, WAN, MAN) Ethernet Technologies, Ethernet Versions, Token Ring Technologies, Wide Area Network Technologies (Frame Relay, ISDN, PPP), Wireless Networks (Radio Frequencies, Microwave Frequencies, Infrared Waves)MULTIPLE ACCESS: Base Technology (FDMA, TDMA, CDMA), Centralized Access, Circuit Mode Access, Distributed Access, CSMA, CSMA/CA, CSMA/CD, Token Passing

12

SWITCHING: Circuit Switching (Time Division switching, Space division switching, time space switching, time space time switching), Packet Switching (Blocking, ATM Switching), Switching Fabric (Crossbar, Broadcast)NAMING & ADDRESSING: Hierarchical Naming, Addressing, IP address, TCP/IP Services and Application, Telephone Networks, Internet, Sub netting , Ipv4, Private NetworksSERVICES & APPLICATIONS: File transfer protocol, Domain Name System, DHCP, Electronic Mail, WWW, HTML, HTTP.

Paper VIISoftware Project (60 hrs )

V.SOFTWARE PROJECT DIRECTIVES

Every student should submit a project report on the concerned ATC approved topic at the end

of final semester. The project report must be based on the software developed on any ATC

approved topic in any of the programming languages covered under the CTDC curriculum. The

project must be of relevance and has to be adaptable to a ‘live environment’.

A group of 5 students can form a team to commence a project. It is intimated to the teacher

(project guide) and initial planning is done in consultation with the project guide. The project

begins with identifying the application area and the associated problems. The data involved in

the processing and the information to be attained are recognized and procedures or steps are

derived. The students explore possibilities of co-operative and collaborative learning and apply

their problem solving skills. The students are constantly in touch with the project guide

throughout the stages of project work. A project diary is to be maintained by each group and the

activities are to be recorded, which will be helpful in preparing project report. After designing

and testing the software, it should be verified by the project guide and preparation of project

report with the specified format is begun. The software project to be submitted has to be

recorded in binding (at least a spiral bind) and is to comply with a definite sequence as

mentioned below. Each of the group members should have a copy of the report and one copy

for a group should be submitted to the ATC which will be kept in the library for reference. A soft

copy of the project report for a group, has to be submitted to RUTRONIX on a compact disk,

mentioning the names of team members and the ATC they belong to.

The project report held by the student and its softcopy have to be produced for verification

during practical examination. Evaluation of the project-application and its concerned project

report will be done by RUTRONIX for a maximum of 100 marks.

Project Work --Evaluation Indicators ( distribution of marks)

13

1. Problem Study & Planning 15

(Problem definition, time scheduling, division of responsibilities)

2. Input, Output, and file design 15

(Specifying the screen layouts for input /output design,

File designing, if necessary)

3. Process design 15

(Developing logic, efficiency in language/ tools for coding,

Debugging capabilities, format and accuracy of output)

4. Ability to prepare project report 15

(Reflection of processes, Communicability and authenticity

of the report)

5. Viva Voce 40

(Knowledge of individual student on content and process)

-------------------------------------------------------------------------------------------------------

Total Score: 100

Structure of Project Report

1. Cover Page (Project Title, Name of Students, Course and Duration, Register No.: ,Year: )

2. Certificate (from Rutronix)

3. Preface/Abstract

4. Content

Introduction

Aims (Objectives)

Problem Study/Analysis

Development Tools and Facilities used

Source Code/Procedure/Steps

Outputs

Future enhancements

Conclusion

4. Annexure (Sample data, data sheet etc.)

5. Bibliography

VI. Specific guidelines from RUTRONIX regarding PGDCA/PDCA/DCA project work

14

ATCs are requested to ensure that the students take up Projects which will groom them to take

up useful Projects in future.

Ideally, the Project should involve database operations, adding new records, editing existing

records, searching for particular records, creating reports/showing details according to

various needs etc.

The front end can be in any language they have learnt like VB, VB.Net, C++, Java, PHP etc.

The data base can be Excel, MS Access, SQL, MySQL etc.

All Projects should be demonstrated and should be working satisfactorily.

Students will be required to make alterations to the program at the time of examination &

students should be able to do this.

It is compulsory to give a hardcopy (printed) of the program as well as in CD.

Mere Screen Shots will not be sufficient.

The following points must be kept in mind while preparing the Project Report.

• Description of well known general facts should be strictly avoided.

• Avoid describing about the software used like Windows, Linux, VB, VB.Net, C++, Java,

MySQL, Excel Access etc.

• If at all necessary, briefly mention why a particular Data Base or Programming Language

was selected (not exceeding one page each).

• The description should be brief and in your own language.

• Avoid unnecessary verbose.

• A brief description of the project may be given just to bring out its salient features.

All students in their final semester and who intend to do the project are requested to send the

following details before -------------(date), giving the following details. (Only one set need be

sent for a batch, if a group is doing the project).

1. Title

2. Students in the Group

3. Guide

4. User agency or Academic Exercise

5. Data Base

6. Front End Language.

15

VII. Lab record-guidelines :

Students of various courses shall be instructed to maintain one Lab record per Semester by

including all practical oriented subjects included in the respective curriculum. Lab record

can be issued from the ATC after collecting reasonable cost. Lab records duly certified by

the respective subject teachers, should be produced for evaluation during final lab

examination

1 For programming subjects like C++, Java, VB & VB.Net, necessary algorithm or flowchart for

each problem shall be neatly described before documenting the source code. Input /

Output specifications during program testing shall be Screen printed and pasted in the

record book.

2 For modules in Office Suite and DTP (word processing, spread sheet, presentation,

database management and page maker, Corel draw, photo shop ) ,suitable application level

problems for developing respective skills shall be given by the subject teachers.

For every such problem, when writing in to the record:

Commands to be used (various methods like using menu, keyboard, tool bar), steps to

be followed, other specific information relating to the problem (if any) etc. are to be

neatly documented.

Input and output documents shall be printed and pasted into the record after each

assignment.

3 All students should be compulsorily directed to create an e-mail id during their

practical training session on “Internet services” and the e-mail id thus created along with

the procedure must be written on the Lab record.

VIII. Reference Books:

Semester IPaper I

Fundamentals of Computer – Ashok Saxena, Sunil Chauhan , Kratika Gupta Digital computer fundamentals – Thomas Bartee Computer fundamentals – Rajaramam Operating System concepts-William Stallings, Pearson Windows XP- Complete Reference –BPB Publications Linux – The complete reference- Richard Petersen A Practical Guide to Red Hat Linux 8 –Mark G.Sobell

16

Ms Office XP Complete BPB Publication ISBN 81-7656-564-4 Microsoft Office 2003 all-in-one- Joseph W. Habraken

Paper II1. C++ Programming – By E.Balaguruswamy2. Java Programming - By E. Balaguruswamy3. Computer Science C++ - Sumitha Arora4. Introduction to data structures with applications-Tremblay and Sorensons, TMH5. Fundamentals of data structures- Horowitz and Sahni, Computer Science press

Paper III

1. J. Hoffer, "Modern Systems Analysis and Design", Second Edition, 2000, Joey George and Joseph Valacich, Pearson Education.

2. A. Dennis and B. H. Wixom, "Systems Analysis and Design", First Edition, 2002, John Wiley & Sons, Inc.

3.System Analysis and Design – Elias M. Awad

4.Fundamentals of Database systems- Ramez Elmasri and Shakant B.

Paper IV

1. B Underdahle and K Underdahle, Internet and Web Page/ WebSite Design, Second Edition, 2001, IDG Books India (P) Ltd.

2- D Comer, The Internet Book, Second Edition, 2001, Prentice Hall of India.

Paper V

1- E. Petroutsos, Mastering visual Basic, 1998, BPE Publication. 2002, BPB Publication.

2- Visual Basic Programming By Sumitha Arora

3. VB.Net programming black book

4. Mastering VB.Net

6. Begin .PHP5, Apache, Mysql web development by Naramore

Paper VI

1 B. Forouzan, "Data Communication and Networking", First Edition, 1999, Tata McGraw Hill

2. W. Stallings, "Data and Communication", Sixth Edition, 2002, Prentice Hall of India

17

3. Lin and Chlatmtac, "Wireless and Mobile Network Architecture", 2001, John Wiley and Sons, India.

4. Data Communication and networking by Behrouz Forouzan 2nd edition

5. Computer Networks by Andrew S.Tenenbaum -4th edition

18