Syllabus For Examination For Pgt(Commerce)

PART – I

BUSINESS STUDIES AND MANAGEMENT

• Introduction to Business– Concepts, characteristics, objectives. Classification of business as industry and commerce. Distinctive features of business - Business, profession and employment. Choice of Form of Organization .Large Scale and Small Scale Business-.Assistance by Government to Small Scale Sector.
• Form of Business Organization – Sole Proprietors, Joint Hindu Family, Partnership, Joint Stock Company and its formation, Cooperative organization.
• Business ownership– Private, public and Joint sector. Public Enterprises, Role-dynamics of Public Sector, Global Enterprises (Multinational Companies), Joint Ventures
• Business Services – banking, insurance, transportation, warehousing, communication, Impact of Technology on Business Services.
• Trade: Internal Trade Retail and Wholesale trade, Emerging modes of business-franchisee, E-business and Outsourcing. International Business–Export-Import – Procedure and documentation, EPZ/SEZ . International Trade Institutions and Agreements – WTO, UNCTAD, World-Bank, IMF.
• Business Finance: Sources – owners and borrowed fund, Sources of raising finance, Equity and preference Shares, GDR,ADR, Debentures, Bonds – Retained Profit, Public Deposits, Loan from Financial Institutions and commercial banks, Credit-rating and rating agencies, Trade credit, Micro-credit.
• Social Responsibility of Business, Business Ethics, Environment protection.
• Management – concept, objectives, nature of management as Science, Art and Profession, levels, Principles of Management general and scientific.
• Business Environment – meaning, importance, dimensions, changing business environment–special reference to liberalization, privatization and globalization, Business - a Futuristic vision.
• Management Function – Planning, organizing, staffing, directing, controlling and coordination
• Business Finance: Financial Management – meaning, scope, role and objectives, financial planning, Capital structure, leverage, Fixed and working capital – meaning and factors affecting its requirements.
• Financial Market – Money Market-nature, instruments, Capital Market- Primary and secondary, Stock exchange, NSEI, OTCEI, Procedures, SEBI.
• Human Resource Management– meaning , importance, man-power estimation , Recruitment and selection, Training and development , Compensation, Performance Evaluation
• Marketing – meaning, functions and role, Levels of Marketing , Changing facets of marketing , Product-mix, Models of Marketing. Organizational Behaviors : Individual behaviors , Motivation–concepts and applications, Personality perception, Learning and attitude, Leadership and its approaches, Communication , Group dynamics.
• Emerging Trends in Management – Business Process Reengineering, Total Quality Management, Quality Circles, Benchmarking, Strategic Management, Knowledge Management, Business Standardization and ISO.
• Consumer Protection – Meaning, importance, consumers’ rights, Consumers’ responsibilities, Consumer awareness and Legal redressal with special reference to consumer Protection Act, Role of consumer organization and NGOs.

PART –II

FINANCIAL ACCOUNTING AND FINANCIAL STATEMENT ANALYSIS

• Accounting: Meaning, objectives, qualitative characteristics of Accounting information, Accounting Principles, Accounting concepts, Accounting standards, Cash and Accrual Basis of Accounting.
• Process of Accounting :Voucher, transaction ,Accounting Equation, Rules of Debit and Credit, Book of original entry-Journal and Special Purpose Books, Ledger ,posting from Journal and subsidiary books, Balancing of Accounts, Trial Balance and Rectification of Errors .Bank Reconciliation Statement.
• Accounting for depreciation ,Provisions and Reserves ,Bills of Exchange, Non-Profit Organization , Partnership Firms - Reconstitution of Partnership (Admission ,Retirement ,Death and Dissolution),Account of Incomplete Records, Consignment and Joint ventures.
• Accounting of Joint stock Companies: Share capital types of shares, accounting for issue, allotment forfeiture and re-issue of shares. Debentures –types, issue and method of redemption .
  Final Accounts of Sole proprietor and Joint Stock Companies. Emerging trends of presentation of Final Accounts.
• Accounting for liquidation.
• Financial Statement Analysis: Meaning, significance, limitation .Tools for Financial Statement Analysis-comparative statements, common size statements, Trend analysis, accounting ratios.
• Fund Flow Statement and Cash Flow Statement: Meaning, objectives, preparation as per revised standard issued by ICAI.
• Cost Accounting- Nature, functions . Job costing, Process costing, Marginal costing, Cost-volume-profit relationship. Cost control and cost reduction techniques
• Computers In Accounting: Introduction to Computers and Accounting Information System, Application of Computers in Accounting, Automation of Accounting process, designing accounting reports, MIS reporting, data exchange with other information system. Ready made , customized and tailor made Accounting Systems.
• Accounting And Database Management System –meaning, concept of entity and relationship in an accounting system, Data Base Management System(DBMS) in accounting.
• Inflation accounting and Accounting for Human Resource of an Organization and Social Responsibility.

Syllabus For Examination For PGT (Computer Science)

COMPUTER SYSTEMS ARCHITECTURE

System buses: Computer Components, Computer function, Interconnection Structures, Bus Interconnection, PCI.

Internal Memory: Computer Memory System Overview, Semiconductor Main Memory, Cache Memory, Advanced DRAM Organization.

Input/ Output: External Devices, I/O Modules, Programmed I/O, Interrupt- Driven I/O, Direct Memory Access, I/O Channels and Producers, The External Interface.

Operating System Overview.

Computer Arithmetic: The Arithmetic and Logic Unit (ALU), Integer Arithmetic, Floating-Point Representation, Floating-Point Arithmetic.

Instruction Sets: Characteristics and Function, Machine Instruction Characteristics, Types of Operands, Types of Operation, Addressing Modes and Formats, Register Organization, The Instruction Cycle, Instruction Pipelining.

Assembly Language

The Control Unit: Micro-operations, control of the CPU, hardwired Implementation, Micro program Controller, Basic Concepts, Microinstructions, Sequencing, Microinstruction Execution.

Reduced Instruction Set Computer: An Introduction.

OPERATING SYSTEMS

Introduction: System software, resource abstraction, OS strategies; multiprogramming, batch, time sharing, personal computers and workstation, process control & real time systems, processes & threads using FORK, JOIN, QUIT.

Operating System Organization: Factors in operating system design, basic OS function, implementation consideration: process modes, kernels, methods of requesting system services, device drivers.

Device Management: Service management approaches, buffering, device drivers, performance tuning.

Process Management: System view of the process and resources, initiating The OS, process address space, process abstraction, resource abstraction, process hierarchy.

Scheduling: Scheduling Mechanisms, Strategy selection, non-pre-emptive and pre-emptive strategies.

Synchronization Principles: Interactive processes, critical section, deadlock, coordinating processes, semaphores, spread memory, multiprocessors, events, monitors and the inter-process communication.

Deadlocks: System deadlock model, prevention strategies, hold and wait, circular wait, allowing pre-emption, Banker’s Algorithm, serially reusable resources, consumable resources, general resources system recovery.

Memory Management: Mapping address space to memory space, memory allocation strategies, fixed partition, variable partition, segmentation.

File Management: Directory structure, basic file operations and their implementation.

Protection and Security: Policy mechanism, authentication, internal access authorization.

DIGITAL ELECTRONICS

Fundamental Concepts: Digital signal, NAND, NOR and Exclusive-OR operation, Boolean Algebra, Basic Digital Circuits.

Number system and Codes: Primary, Octal, Hexadecimal, Signed Numbers Codes, hamming codes.

Combinational Logic Design: K-map representation of logical functions and simplification using K-map of 4 and 5 variables, Quine- McCluskey’s method.

Multiplexers, Demultiplexers, Adders and Subtracters, multipliers, Comparators, Parity generators and checkers, Code converters, Priority Encoders, Decoders.

Races, hazards, and asynchronous behavior

Flip-Flops: Clocked RS flip flop, D-type flip flop, Excitation table of flip flop, Edge triggered flip flop, Clocked flip flop design.

Sequential Logic Designs: Registers, Shift registers, Asynchronous counters, synchronous counters, RAM, ROM.

PROGRAMMING FUNDAMENTALS

Basic Computer Organization: Functional Units, basic I/O devices and storage devices; Representation of integers, real (fixed and floating point), characters (ASCII and Unicode); Basic operations of a programming environment.

Problem Solving Approaches: Notion of an algorithm, problem solving using top-down design and decomposition into sub-problems, stepwise methodology of developing an algorithm, methodology of developing an algorithmic solution from a mathematical specification of the problem, use of recursion for problems with inductive characterization.

Programming using a modern programming language such as Java, emphasizing the following notions: Building blocks: arithmetic and logical expression, variables, assignment; Specifying the input-output interface (type); control structures including sequencing, conditionals, loops, procedural abstractions (procedures, methods); basic data structures-integers, reals, strings and arrays-and internal representation of scalar and vector data; data abstraction and encapsulation-objects, classes and packages; input/ output of data.

Numerical and non-numerical applications using above concepts.

PROGRAMMING TOOL: VISUAL BASIC

Introduction to Programming –Modular Programming, Object Oriented Programming, Event Driven Programming:

About Visual Basic (Object Based Programming Language), Rapid Application Development using Visual Basic;

Concept of Project In Visual Basic, VB Project Options- Standard EXE, ActiveX DLL, ActiveX EXE, ActiveX Control, Active X Document EXE, Addin, VB Application Wizard, IIS Application, DHTML Application;

Getting Familiar with Visual Basic User Interface-Pull-Down menus, Toolbar, Toolbox, Project Explorer, Properties Window, Form Layout Window, Form, Immediate window;

Opening and Closing window, Resizing and moving windows, Docking windows; Quitting Visual Basic;

Visual Basic Tool Box (Standard Window Controls)- Pointer, Picture Box, Lbel, Text Box, Frame, Command Button, Check Box, Option Button, Combo Box, List Box, Horizontal Scrollbar, Vertical Scrollbar, Timer, Drive List box, Directory List box, File List Box, Shape, Line, Image, Data, OLE;

Object Naming Conventions, Event Procedures;

Data Types: Integer, Long, Single, Double, Currency, String, Byte, Boolean, Date, Object, Variant;

Variables: Need to use variable, Declaring Variables, Variable Naming Convention, Assigning value to Variables, Data Types of variable, Scope and lifetime of Variables (Public and Private);

Menu Editor : Concept of menus, Shortcut menus and Popup menus Designing Menu System, Menu Editor Dialog Box Options (Name, Index, Shortcut, Help Context ID, Negotiate Position, Checked, Enabled, Visible, Window List, Right Arrow, Left Arrow, Up Arrow, Down Arrow, Menu List, Next, Insert, Delete, OK, Cancel), To Create Menu Controls in the Menu Editor, Menu Naming Conventions, Setting the Name Property, Creating a Menu Control Array, Creating Sub Menus, Separating Menu Controls, Assigning Access Keys and Shortcut Keys, Controlling Menus at Runtime-Enabling and Disabling Menu Commands, Displaying a Checkmark on a Menu Control, Making a Menu Control Invisible, Adding Menu Control at Runtime, Displaying Pop-Up Menu;

General Controls (Advance): Image List, Common Dialog Box, ADO DC, DB Combo, Media Player Control, DB Grid;

Adding a Toolbar: Creating an Image List, Adding Images to the Toolbar, To Add Code for the Toolbar Buttons;

Adding Status Bar: Adding Status Bar panels, Adding Time on the panel.

Dialog Boxes: Pre-defined dialog box, Custom dialog box;

PROGRAMMING IN C++

Introduction to the object-based and object-oriental programming paradigms; records, abstract data types and objects, data abstraction and internal representation; programming-in-the-large issues: modularity and code re-usability, classes and packages; graphical user interfaces; command-line arguments; interfacing with libraries and separate compilation; language support and OOP: Sub-typing, Inheritance, classes and subclasses, header files, function templates, overloading.

Programming with Data structures: Stacks, queues, lists, trees and balanced binary trees, specification of exception conditions and exception handling, notion of efficient algorithmic solution, efficient representations of data structures (e.g.sparse arrays), algorithms for searching and sorting.

DATA STRUCTURES

1. Object Oriented Programming: Concept of Object Oriented Programming- Data hiding, Data encapsulation, Class and Object, Abstract class and Concrete class, Polymorphism (Implementation of polymorphism using Function overloading as an example in C++); Inheritance, Advantages of Object Oriented Programming over earlier programming methodologies.

2. Implementation of Object Oriented Programming concepts in C++: definition of a class, Members of a class-Data Members AND Member Functions (methods), Using Private and Public visibility modes, default visibility mode (private); Member function definition: inside class definition and outside class definition using scope resolution operator (::); Declaration of objects as instances of a class; accessing members from object (s), Array of type class, Objects as function arguments-pass by value and pass by reference; Constructor and Destructor: Constructor: Special Characteristics, Declaration and Definition of a constructor, Default Constructor, Overloaded Constructors, Copy Constructor, Constructor with definition of destructor; Destructor: Special Characteristics, Declaration and definition of destructor; Inheritance (Extending Class): Concept of Inheritance, Base Class, Derived Class, Defining derived classes, protected visibility mode; Single level inheritance, Multilevel inheritance and Multiple inheritance, Privately derived, Publicly derived and Protectedly derived class, accessibility of members from objects and within derived class (es);

3. Data File Handling: Need for a data file, Types of data files-Text file and Binary file; Basic file operations on text file: Creating/ Writing text into file, Reading and Manipulation of text from an already existing text File (accessing sequentially); Binary File: Creation of file, Writing data into file, Searching for required data from file, Appending data to a file, Insertion of data in sorted filed, Deletion of data from file, Modification of data in a file; Implementation of above mentioned data file handling in C++; Components of C++ to be used with file handling:

4. Pointers: Declaration and Initialization of Pointers: Dynamic memory allocation/ deallocation operators: new, delete; Pointers and Arrays: Array of Pointers, Pointer to an array (1 dimensional array), Function returning a pointer. Reference variables and use of alias; Function call by reference. Pointer to structures: Deference operator: *,->; self referential structures;

RELATIONAL DATABASE MANAGEMENT SYSTEM

Introduction to database concepts: Relation/ Table, attribute, Tuple/ Rows, fields, Data, Concept of String, Number and Date values, Data type and Data Integrity (Domain and Referential Integrity). Candidate key, Alternate key, Primary Key, Foreign Keys; Data Normalization-first, second, third, BCNF normal form;

Examples of Commercially available Database Management System’s (Back-End) – Oracle, MS-SQL Server, DB2, MySQL, Sybase, INGRES.

Examples of Front End Software’s: Oracle Developer, Visual Basic, Visual C++, Power Builder, Delphi;

ORACLE: Introduction, Version, Two Tier and Three Tier support;

Interface with oracle, Login Screen, Entering Name and Password;

Classification of SQL Statements: DML (SELECT, INSERT, UPDATE, DELETE), DDL (CREATE, DROP, ALTER, RENAME, TRUNCATE), DCL (GRANT, REVOKE), TCL (COMMIT, ROLLBACK);

SQL SELECT Statement: SQL SELECT statement, Selecting All the Columns, Selecting Specific Column, Column Heading Default, Using Arithmetic Operators, Operator Precedence, Significance of NULL value, NULL values in Arithmetic Expressions, Defining and using Column Alias, Concatenation Operator (ll), Duplicate rows and their Elimination (DISTINCT keyword), Role of SQL and SQL*Plus in interacting with RDBMS, Displaying Table Structure (DESC command);

SELECT Statement Continued: Limiting Rows during selection (using WHERE clause), Working with Character Strings and Dates, Using Comparison operators, BETWEEN Operator, IN Operator, LIKE Operator, is null comparison, Logical Operators, Use of Logical Operators (AND/OR/NOT Operators), Logical Operator Precedence, ORDER BY Clause, Sorting in Ascending/Descending Order, Sorting By Column Alias Name, Sorting On multiple Columns;

Functions: SQL Functions, Types of SQL Function (Single Row/ Multiple Row), Single Row SQL Functions, Character Functions (Case Conversion/ Character Manipulation), Case Conversion Functions [lower (), InitCap (), UPPER ()] Character Manipulation Function [CONCAT (), INSTR (), LENGTH (), TRIM (), SUBSTR (), LPAD () ], Number Functions (ROUND (), TRUNC (), MOD() ), Working with Dates [LAST_DAY(), MONTHS_BETWEEN(), NEXT_DAY(), ADD_MONTHS(), ROUND(), TRUNC() ] Arithmetic Operation on Dates, Date Functions and their Usage, Data type Conversion Functions, Implicit and Explicit Conversion, TO_CHAR Function with Dates, TO_CHAR Function For Numbers, TO_NUMBER and TO_DATE Functions, NVL Function and its Usage, DECODE Function and its Usage;

Grouping Records: Concept of Grouping Records and Nested Grouping, Nested Grouping of records, Group Functions, Types of group functions [MAX (), MIN (), AVG (), SUM (), COUNT ()], using AVG and SUM Functions, Using MIN and MAX Functions, Using the COUNT Function, using COUNT(*), DISTINCT clause with Count, Group Functions and Null Values, Using NVL Function with Group Functions, Grouping Records: Group By Clause, Grouping By More than One Column, Illegal Queries with Group By Clause, Excluding Group Results: Having Clause, Nesting Group Functions.

Sub Queries: Concept of Sub-Query, Sub Query to solve a Problem, Guidelines for Using Sub Queries, Types of Sub-Queries (Single Row and Multiple Row) and (Single Column and Multiple Column); Single Row Sub-Query and its Execution;

Displaying Data From Multiple Tables: Concept of Join, Result of Join, Cartesian Product and Generating Cartesian Production example using Mathematical Set), Types of Joins (EQUL, SELF, NON-EQUI, OUTER (LEFT and RIGHT)), Equi-join, Additional Search Conditions using AND operator, Short Naming Convention for Tables (Table Aliases), Non-Equi join and its Implementation, Outer-Join and Its Usage, Self-Join (Joining a table to Itself);

Manipulating Data of A Table /Relation: Concept of DML (Data Manipulation Language), INSERT Statement, Inserting New Rows, Inserting New Rows, with Null Values, Inserting Date Values, Use OF substitution Variable to Insert Values, Copying Rows From Another Table, Update Statement to Change Existing Data of a Table, Updating Rows In A Table, Updating Rows Based on Another Table, Delete statement/ Removing Row/ Rows from a Table, Deleting, Rows Based on condition from another Table; Making Data Manipulation Permanent (COMMIT). Undo Data Manipulation Changes (ROLLBACK)

Database Objects: View, Table, Sequence, Index, and Synonyms, DDL (Data Definition Language), Naming Convention, Creating Views, Creating Synonyms, Simple Views and Complex Views, Retrieving Data From a View, Querying a View, Modifying a view.

Including Constraints: Constraints, Concept of using Constraints, Constraint Guidelines, Defining Constraints, NOT NULL, UNIQUE KEY, PRIMARY KEY, FOREIGN KEY, FOREIGN KEY Constraint Keywords, CHECK, Adding a constraint, Dropping a Constraint, Disabling Constraints, Enabling Constraints, Viewing Constraints, Viewing The Columns, Associated with Constraints;

Creation of a Table/ Relation: CREATE TABLE Statement, Data types, the DEFAULT option, Creating Tables, Referencing Another User’s Tables, Querying the Database Dictionary to view all tables in the Oracle Database, Creating a Table by Using a Sub-Query;

Managing Existing Tables and other Database Objects: The ALTER TABLE Statement, Adding a New Column in a Table, Modifying Existing Column, Dropping a Column, Renaming an Object, Truncating a Table, Adding Comments to a Table, Dropping Views, Dropping Synonyms, Dropping Tables; giving permission to other users to work on Created Tables and Revoking it (GRANT and REVOKE statement).

BUSINESS COMPUTING

General concept, User interfaces (front End), Underlying Database (back End), Integration of User Interface and Database;

More application areas of Databases:

Inventory control, Financial Accounting, Pay-Accounting System, Invoicing Management System, Personal Management System/ hard system, Fees Management System, Result Analysis System, Admission Management System, Income Tax Management System;

Advance Program Development Methodology: System Development Life Cycle, Relational Database Concept, Relational Database, Management System, Data Models (Entity Relationship Model), Entity and Entity Set, Attributes (Single, Composite and Multi-Valued), Relationship (One-to-One, One-to-Many and Many-to-Many), Entity Relationship Modeling Conventions, Communicating with an RDBMS using SQL, Relational Database Management System, SQL Statements, About programming language in SQL.

Data Dictionary, Data Warehousing, Data Mining, Meta Data;

Object Modeling: Introduction to object oriented modeling using Unified Modeling Language (Concepts only).

Client Server Computing: Concept of Client Server Computing.

WEB DEVELOPMENT

Introduction, Objectives, Introduction to Universal Resource Identifier (URI) – Fragment Identifiers and Relative URI’s, History of HTML, SGML, Structure of HTML/ DHTML Document, Switching between opened Windows and browser (Container tag, Empty tag, Attribute);

Basic Tags of HTML: HTML, HEAD, TITLE, BODY (Setting the Fore color and Background color, Background Image, Background Sound), Heading tag (H1 to H6) AND ATTRIBUTES (ALIGN), FONT tag and Attributes (Size: 1 to 7 Levels, BASEFONT, SMALL, BIG, COLOR), P, BR, Comment in HTML (), Formatting Text (B, I, U, EM, BLOCKQUOTE, PREFORMATTED, SUB, SUP, STRIKE), Ordered List-OL (L1, Type-1, I, A, a; START, VALUE), Unordered List-UL (Bullet Type- Disc, Circle, Square, DL, DT, DD), ADDRESS Tag;

Creating Links: Link to other HTML documents or data objects, Links to other places in the HTML documents, Links to places in other HTML documents;

Anchor Tag Inserting Inline Images;

Tables: Creating Tables, Border, TH,TR, TD, CELLSPACING, CELLPADDING, WIDTH, COLSPAN, CAPTION, ALIGN, CENTER;

Frames: Percentage dimensions, Relative dimensions, Frame- Src, Frameborder, height and width, Creating two or more rows Frames , Creating two or more Columns Frames , , , ;

Forms: Definition, Use- Written to a file, submitted to a database such as MS-Access or Oracle, E-mailed to someone in particular, Forms involve twoway communication;

From Tags: FORM, …, ,, , METHOD, CHECKBOX, HIDDEN, IM-AGE, RADIO, RESET, SUBMIT, INPUT ;

Concept and Importance of Document Object Model, Dynamic HTML document and Document Object Model.

Cascading Style Sheets

Introduction to Cascading Style Sheet (CSS), three ways of introducing the style sheets to your document. Basic Syntax; Creating and saving cascading style sheets.

Margins (all values), MARGIN- PROPERTY, PADDIND (all values), PADDING-PROPERTY; BORDER (all values), BORDER-PROPERTY, BACKGROUND-IMAGE, BACKGROUND-REPEAT; Additional Features, Grouping Style Sheets, Assigning Classes; Introduction to Layers, , tag;

XML: Introduction;

Features of XML: XML can be used with exiting protocols, Supports a wide variety of applications, Compatible with SGML, XML documents are reasonably clear to the layperson;

Structure of XML: Logical Structure, Physical Structure;

XML Markup: Element Markup i.e (Hello), Attribute Markup i.e. ();

Naming Rules: used for elements and attributes, and for all the descriptors, Comments Entity

Declarations: ;

Element Declarations: ;

Empty Elements: ;



Unrestricted Elements: ;

Element Content Models: Element Sequences i.e. ,

Element Choices , Combined Sequences and Choices;

Element Occurrence Indicators:- Discussion of Three Occurrence Indicators

? (Question Mark)

* (Asterisk Sign)

+ (Plus Sign)

Character Content: PCDATA (Parseable Character data)
Document Type Declaration (DTD) and Validation;

Developing a DTD: Modify and existing SGML DTD, Developing a DTD from XML Code, either automatically or manually;

Viewing: Viewing XML in Internet Explorer, Viewing XML Using the XML Data Source Object XSL (Extensible Style Sheet Language) or CSS (Cascading Style Sheet);

Browse the records: Single record at a time (Using buttons), Multiple record at a time (Using an HTML Table);

Active Server Pages (ASP): Concept of ASP, features of ASP, other equivalent tools-JSP, PHP;

Constants: String and Numeric;

Data types: Integer, Floating Point (Single, Double), String, Date, Boolean, Currency, Variant, Object;

Variables: Explicit and Implicit Declaration;

Operators:

Arithmetic: +, - (Unary and Binary), *, /, \(integer division) mod,^;

Comparison: <, >, <=, >=, <>, =;

Logical: AND, OR, NOT, XOR, EQV, IMP;

String Operator: & or + (for Concatenation);

Functions:

Conversion functions: Abs (), Cbool (), CByte (), Cint(), CStr (), CSng (), CLng (), Cdate ();

String Manipulation Functions: Ucase (), Lcase (), Len (), Left (), Right (), Mid (), Ltrim (), InStr(), Rtrim (), Ltrim ();

Time & Date Functions: Date (), Day(), Hour (), Left (), Len (), Minute (), Month (), Monthname (), Now ();

Arrays: Declaration and use of 1 dimensional and 2 dimensional arrays;

Controls: OF..THEN, IF..THEN..ELSE..END IF, IF..THEN..ELSEIF..THEN..END IF, SELECT..CASE..END SELECT,

FOR ..NEXT, FOR EACH..NEXT, DO WHILE..LOOP, DO..LOOP WHILE, DO UNTIL.LOOP;

Procedures and Functions, Passing parameters/ arguments;

Concept of object model structure (client to server and server to client);

Objects: Properties, Methods, Events, Setting Object properties, Retrieving Object properties, calling objects/ methods;

Types of Objects: Response, Request, Application, Session, Server, ASP Error;

Response Object: Write Method, Addheader, Append To Log, Binary Write, Using Shortcuts <%=value/ expr%>, Controlling information: Buffer, Flush Clear, End;

Request Object: Request Object Collection: Querystring, Form, ServerVariables, Cookies, ClientCertificate;

Application: Contents, Lock, Unlock, Remove, Remove ALL;

Asp components: AD Rotator, Content Rotator, Counter, Page Counter, Permission Checker;

Text Files: Open and Read content from a text file;

Elementary Database Concepts: Concept of Table/ Relation, Relationship, Candidate Key, Primary Key, Alternate Key, Foreign KEY

Connecting with Databases: Creation of DSN, using OLEDB.

Working on Databases: Inserting, Retrieving, Modifying/ Updation of records from Tables in Databases using server objects (ADODB. Connection, DODB. Recordset);

Server Variables: HTTP_User_Agent, REMOTE_ADDER, REMOTE_HOST, SERVER_NAME;

WEB SCRIPTING

Introduction, Adding VBScript code to HEML page, VBScript Data type-Variant Subtypes, VBScript Variables: (Declaring variable, Naming restrictions, Assigning value to variables, Scalar variables and Arrays), VBScript Constants, VBScript Operators, and Operator precedence;

MsgBox: functions of message box (Prompt, Buttons, Title, Helpline, Context), Return values of MsgBox function, button argument setting.

Conditional statement: If..Then..Else, Select case;

Loops: Do loops, While..Wend, For..Next, For..Each..Next;

VBScript variables: Sub procedures, Function procedures;

Using VBScript with HTML form controls, Data handling functions, String functions, Date and Times function;

Introduction, History of Java Script, Using Java Script in an HTML Page, Objectives, Properties Methods and Events;

Event handling, Adding Java Script in an HTML Page (Using SRC attribute within script with examples), Variable and data types- Data types and type casting, String processing, Arrays, Operators, Control flow with looping- for loop, while loop, using continue and break statement, Adding comments to scripts, The Window object, The Document Object, The Location Object, The Form Object, Working with control Objects (Button, reset and submit objects, Checkbox objects and Radio objects, Select object, Password, text and text area object, The Data object, Performing calculation.

WEB DEVELOPMENTMULTIMEDIA AND AUTHORING TOOLS

1.Graphics Devices: Monitor display configuration, Basics of Graphics Accelerator Card and its importance;

Basic concepts of Images: Digital Images
Digital Image Representation

Image Formats

TIFF, BMP, JPG/ JPEG, GIF, IC, PDF, PSD:

Graphic Formats

Theory of design, form, line, space, texture, color, typography, layout, color harmony, unity, balance, proportion, rhythm, repetition, variety, economy, still life, light and shade, Poster Design:

Still life, colored layout, Poster Design, Designing of Books, magazines brochures, children’s literature, narrative text handling, scripts in Indian Languages, picture books, comics, illustrations with photographs, scientific illustrations, conceptual illustrations, handling of assignment for the market;

Image Scanning with the help of scanner: Setting up Resolution, Size, File formats of images; image preview, Bitonal, Grey Scale and color options;

Significance of PDF-creation, modification;

Animation, Morphing and Applications

Graphic Tools: Image Editing Software (Photoshop/ CorelDraw)

Basic Concepts: An Introduction, creating, Opening and saving files, Menus, Toolbox, Color control icons, Mode control icons, Window controls icons; creating new images, Image capture (TWAIN) from scanner other files;

Image Handling: Cropping an image, adjusting image size, increasing the size of the work canvas, saving an image;

Layers: Adding layers, dragging and pasting selections on to layers, dragging layers between files, viewing and hiding layers, Editing layers, rotating selections, scaling an object, preserving layers transparency, moving and copying layers, duplicating layers, deleting layers, merging layers, using adjustment layers;

Channels and Masks: Channel palette, showing and hiding channels, splitting channels in to separate image, merging channels, creating a quick mask, editing masks using quick mask mode;

Painting and Editing: Brushes palette, brush shape, creating and deleting brushes, creating custom brushes, setting brush options, saving, loading and appending brushes, Options palette;

Opacity, pressure, or exposure, paint fade-out rate, making selections, using selection tools, adjusting selections, softening the edges of a selection, hiding a selection border, moving and copying selections, extending and reducing selections, pasting and deleting selections, Image tracing (CorelDraw).

Concept of Multimedia: Picture/ Graphics, Audio, Video;

Sound: Recording Sound using Sound Recorder (Capture), Sound capture through sound editing software (ex: Sound forge), Sound editing, Noise correction, Effect enhancement;

Voice Recognition Software Philips/ Dragon, MIDI Player, Sound Recorder, MONO & Stereo.

Sound File Format: AIFF (Audio Input File Format from Apple Mac), MIDI, WAV, MP3, ASF (Streaming format from Microsoft). Importing audio and saving audio from Audio CD.

Sound Quality: CD Quality, Radio Quality, Telephone Quality;

Picture/ Graphics/ Image files;

2. Movie File Formats: AVI, MPEG, SWF, MOV, DAT;

Movie Frames: Concept of Frame, Frame Buffer, and Frame Rate; Authoring Tools; Making Animation, Embedding Audio/Video, and Embedding on the web page;

Scene: Concept of Scene, Duplicate Scene, Add Scene, Delete Scene, and Navigating between Scenes;

Layers: Concept of Layer, Layer Properties, Layer Name, Show/ Hide/ Lock layers, Type of Layer- Normal/Guide/ Mask, Outline Color, Viewing Layer as outline, Layer Height, Adding/ deleting a layer;

Frame: Concept of Frame;

Creating a Key Frame, Inserting Text Into the Frame, Inserting Graphical Elements into the frame, Converting Text/ Graphics to symbol, Inserting Symbol into the Frame, Setting Symbol Property (Graphics/ Button/ Movie), Inserting Blank Frame, Inserting Blank Key Frame, Inserting Key Frame into the Blank frame, Selecting all/ Specific frames of a Layer, Copying/ Pasting selected Frames,

Special Effects: Motion Tweening, Shape Tweening, Color effect, Inserting Sound Layer; Testing a Scene and Movie;

Import/ Export (Movie/ Sound and other multimedia objects)

Publishing: Publishing A Flash Movie; Changing publish Settings; Producing SWF (Flash Movie), HTML page, GIF image, JPEG Image (*. Jpg), PNG Image, Windows Projector (*. Exe), Macintosh Projector (*. Hqx), Quick Time (*. Mov), Real Player (*.smil);

Testing with Publish Preview.

COMMUNICATION AND NETWORK CONCEPTS

Evolution of Networking: ARPANET, Internet, Interspace; Different ways of sending data across the network with reference to switching techniques ;

Data Communication terminologies: Concept of Channel, Baud, Bandwidth (Hz, KHz, MHz) and Data transfer rate (bps, kbps, Mbps, Gbps, Tbps);

Transmission media: Twisted pair cable, coaxial cable, optical fiber, infrared, radio link, microwave link and satellite link.

Network devices: Modem, RJ45 connector, Ethernet Card, Hub, Switch, Router, Gateway;

Different Topologies- Bus, Star, Tree; Concepts of LAN, WAN, MAN;

Protocol: TCP/IP, File Transfer Protocol (FTP), PPP, Level-Remote Login (telnet), Internet, Wireless/ Mobile Communication, GSM, CDMA, WLL, 3G, SMS, Voice mail, Electronic Mail, Chat, Video Conferencing;

Network Security Concepts: Cyber Law, Firewall, Cookies, Hackers and Crackers;

WebPages; Hyper TEXT markup Language (HTML), extensible Markup Language (EML); Hyper Text Transfer Protocol (HTTP); Domain Names; URL; Protocol Address; Website, Web Browser, Web Servers; Web Hosting.

Syllabus For Examination For PGT(ECONOMICS)

PART – A

Introductory Micro Economics and Macro Economics

• Introduction: Central problems of an economy, production possibility curve and opportunity cost.
• Consumer Behaviour and Demand: Consumer’s Equilibrium - meaning and attainment of equilibrium through Utility Approach and Indifference Approach, Demand, market demand, determinants of demand, demand curve, movement along and shifts in demand curve. Law of demand and its exceptions. Price elasticity of demand, measurement of price elasticity of demand - percentage, total expenditure and geometric method.
• Producer Behaviour & Supply: Agents of production. Production function. Cost and Revenue- meaning and various types of costs and revenue. Isoquants. Returns to a factor and returns to scale. Supply, market supply, determinants of supply, supply curve, movement along and shifts in supply curve, price elasticity of supply and its measurement. Components and theories of distribution. Welfare economics: Pareto-optimality, private and social products. Consumer surplus.
• Forms of Market and Price Determination: Forms of market – meaning and features. Price determination under perfect competition, monopoly and imperfect competitions, effects of shifts in demand and supply.
• National Income and related aggregates: Macroeconomics: Meaning. Circular flow of income, concepts of GDP, GNP, NDP, NNP (at market price and factor cost), National Disposable Income, Private Income, Personal Income and Personal Disposable Income. Measurement of National Income.
• Determination of Income and Employment: Aggregate demand, Aggregate supply and their components. Propensity to consume and propensity to save. Involuntary unemployment and full employment. Determination of income and employment. Concept of investment multiplier and its working. Problems of excess and deficient demands Measures to correct excess and deficient demands - availability of credit, change in Government spending. Inflation: meaning, causes and remedies.
• Money and Banking: Money - meaning, evolution and functions. Central bank - meaning and functions. Commercial banks - meaning and functions. Recent significant reforms and issues in Indian Banking System-privatisation and modernisation
• Government Budget and the Economy: Government budget - meaning and its components. Objectives of government budget. Classification of receipts; classification of expenditure. Types of budget. Revenue deficit, fiscal deficit and primary deficit: meaning and implications; measures to contain different deficits. Downsizing the role of government.
• Balance of Payments: Foreign exchange rate- meaning (Fixed and Flexible), merits and demerits; Determination through demand and supply. Balance of payments accounts - meaning and components.
• International Economics: Theories of international trade, free trade and protection, IMF – The World Bank and its associates. WTO.
• Concepts of shares, debentures, SEBI, NSEW, BSE and various indices.

PART-B

Statistics and Indian Economic Development

• Introduction and collection, organization of data: Meaning, scope and importance of statistics in Economics. Collection and organisation of data. Census of India and National Sample Survey Organisation.
• Statistical Tools and Interpretation: Measures of Central Tendency. Geometric mean and harmonic mean. Measures of Dispersion. Lorenz Curve: Meaning and its application. Correlation – meaning. Measures of correlation - Karl Pearson’s method, Spearman’s rank correlation. Time series analysis. Introduction to Index Numbers - meaning, types - wholesale price index, consumer price index and index of industrial production, uses of index numbers; Inflation and index numbers.
• Producer Behaviour & Supply: Agents of production. Production function. Cost and Revenue- meaning and various types of costs and revenue. Isoquants. Returns to a factor and returns to scale. Supply, market supply, determinants of supply, supply curve, movement along and shifts in supply curve, price elasticity of supply and its measurement. Components and theories of distribution. Welfare economics: Pareto-optimality, private and social products. Consumer surplus.
• Development Policies and Experience: A brief introduction of the state of Indian economy on the eve of independence. Common goals of Five Year Plans, major controversies on planning in India. Main features, problems and policies of agriculture, industry and foreign trade.
• Economic Reforms since 1991: Need & main features - liberalisation, globalisation and privatisation; an appraisal of LPG policies
• Current challenges facing Indian Economy: Poverty and programmes for poverty alleviation. Rural development: Key issues - credit and marketing - role of cooperatives; agricultural diversification; alternative farming - organic farming. Human Capital Formation. Growth of Education Sector in India. Employment: opportunities and other related issues. Infrastructural Problems and policies. Sustainable Economic Development: Meaning; Effects of Economic Development on Resources and Environment.
• Development Experience of India: A comparison with neighbours India and Pakistan, India and China, Issues: growth, population, sectoral development and other developmental indicators.

SYLLABUS FOR EXAMINATION FOR PGT (ENGLISH)

Section A

READING COMPREHENSION

Ability to comprehend, analyze and interpret unseen texts.

Three/four unseen reading passages may be set.

Section B

WEB DEVELOPMENTMULTIMEDIA AND AUTHORING TOOLS

Ability to express views/opinions in a coherent & logical manner.

B1. One out of two tasks such as factual description of any event or incident, a report or a process.

B2. Writing one formal letter. Letter types include

• Business or official letters(for making enquiries, registering complaints, asking for and giving information, placing orders and sending replies)
• Letter to the editors(giving facts/figures suggestions / opinions on an issue of public interest) on contemporary / current issues.
• Application for a job with cv.

B3. Writing personal opinion /views/stand in an article/debate/speech etc on a given socio – cultural issue –in a style/register suitable to the task set. Issues could relate to

• Environment
• Education
• Gender discrimination
• Economic disparity etc..

Section C

GRAMMAR AND USAGE

Ability to apply the knowledge of syntax and grammatical items & use them accurately in the context provided .

The following grammatical structures will be tested through error correction / editing/ gap filling / sentence completion / multiple choice questions :

Section D

LITERATURE

• Shakespeare’s works.
• Shakespeare’s works.
• 19th and 20th Century American and English Literature (e.g. Robert Frost, Hemmingway, Whitman, Hawthorne, Emily Dickinson , Bernard Shaw, Arthur Miller etc. )
• Modern Indian Writing in English (e.g. Anita Desai, Vikram Seth, Nissin Ezekiel, K N Daruwala, Ruskin Bond, R K Narayan, Mulk Raj Anand, Khushwant Singh etc)
• Modern writing in English from other parts of the world e.g. Latin America / Africa / Australia / South Asia.

Syllabus for Examination for PGT (Geography)

Topic I: Geography as a discipline-

Geographical ideas in ancient, medieval & modern periods: the contributions of Varenius, Kant, Reine, Humboldt and Ritter. Influence of Richthofen and Darwin. Videl-da-la Blache, F. Ratzel etc.

Contemporary geography: Post Second World War, Environmentalism, Areal Differentiation, spatial organization, Behavioural and perceptual Geography. Positivism in Geography. Humanistic Geography. Marxist Geography and critical social theory. Development in Indian Geography.

Topic-2 Origin and Evolution of the Earth-

Introduction to the solar system,

Motions of Earth: Rotation, Revolution, Occurrence of Day and Night; change of seasons; Latitudes and Longitudes; Finding time.

Earth’s Interior: Origin of contents and ocean basis Wagener’s Continental drift theory, Theory of Plate Tectonics Earthquakes and Volcanoes, Folding and faulting

Origin of the Earth: Nebular hypothesis (old Theory) and Big-Bang Theory. Evolution of continents, atmosphere and oceans.

Topic-3 Interior of the Earth and Distribution of oceans and continents-

Constitution of Earth’s interior (based on Seismic Evidences), origin of the continents and ocean basins. Wegner’s theory of Continental drift and Plate Tectonics. Plate movements and interactions-Volcanism and seismicity.

Topic-4 Landforms-

Mineral and rocks- classification of rocks, rock cycle. Important minerals geomorphic process of denudation Endogenic and Exogenic processes. Mass Wasting, Landslide, Work of River, Glacier Wind, Sea Waves etc, processes of soil formation.

Topic-5 Climate:

Atmosphere: Composition and structure. Insolation and temperature, Atmospheric pressure and winds, Atmospheric moisture, cyclones, classification of climate (Koeppen and Thornthwaite Schemes classification). Global climatic changes: Causes and effects.

Topic-6 Water (Ocean)

Geomorphology of the ocean floor, submarine relief features of Atlantic, Pacific and Indian Ocean. Movement of ocean water: Currents, tides and waves. Marine deposits and coral reefs.

Topic -7 Life on the Earth

Approaches in environmental Geography, landscape, ecosystem and perception approaches, Man and the Biosphere: Interactive and dynamic relationship. Human impact on biogeochemical cycles.

Topic-8 India:

Geographical basis of Indian State-territory; location, extent, shape and size.

Topic-9 Physiography:

Structure, Physiographic divisions, Drainage system and its evolution.

Topic-10 Climate, Vegetation and Soil-

Climate: factors controlling climate of India

Origin and mechanism of Indian monsoon; Seasons of India, Classification of climate of India (Koeppen’s, Thornthwaite, Triwartha).

Soils: Type and distribution (I.C.A.R.), Soil problems, conservation of soil

Vegetation- Types & Distribution; conservation

Wild Life- its conservation.

Topic-11 Natural Hazards and disasters-

Causes, Consequences and management in India Environmental Hazards: Floods, droughts, cyclones, earthquakes and landslides; human adjustment to hazards; hazards perception and mitigation; environmental institutions and legislation in India.

Topic-12 Human Geography: Nature and Scope.

Nature and scope of Human Geography, Approaches to the Human Geography, Determinism, Environmental Determinism, Possibilism, Neo-determinism, ecological and Behaviouralism.

Topic -13 People (World and India)

Trends and patterns of population growth: determinants and patterns of population distribution; theories, demographic transition; Human migration, Patterns of human development.

Topic-14 Human Activities: (World and India)

Primary: -Hunting, gathering, Herding (Nomadic & Commercial) Lumbering fishing, mining and agriculture; Agricultural practices; some major crops.

Secondary: - Industries: Classification, Theories of localization, major Industries, recent trends in industries, world comparisons.

Tertiary:-(Services)

Quaternary-Quinary activities

Planning in India: target area planning, idea of sustainable development

Topic-15 Transport, Communication and Trade(World and India)

Transport and communication Roads, railways, waterways and airways; oil and gas pipelines, national electric grids. Communication networking-radio, television, satellite and Internet.

International Trade-Basis and components, trade balance, major trading organizations, changing pattern of India’s foreign trade, sea-routes, inland water-ways, sea ports and their hinter-land.

Topic-16 Human settlements (World and India)

Unstable and stable settlements, rural settlements: origin, types and patterns; Urban settlements: Origin and growth of towns; functional classification of towns. Problems of urbanization in the world; urbanization in India; Urban slums and squatters. Morphology of cities; distribution of Mega-cities, problems of human settlements in Developing countries.

Topic -17 Geographical perspective on selected issues and problems

Environmental pollution-Land, Water, Air, Noise, Global Warning, Poverty, Food Security; Sustainable Development.

Topic -18 General Cartography (Practicals)

Elements and classification of maps, scales, map-projections, finding directions, latitudes, longitudes and calculation of local & standard time, Identification & Analysis of relief forms: Topographical Maps and interpretation. Weather-instruments and interpretation of weather maps. Digital mapping, Remote sensing, Visual interpretation. Processing of Data, Thematic mapping, representing statistical data by various diagrams-Bar, Histogram, Pie etc.

Spatial Information technology: GIS, GPS, Computers-Software and Hardware components, Data format, Raster and Vector, editing and topology etc.

Spatial Analysis; Overlay, Buffer and Proximity analysis.