XII - IP SYLLABUS

Class XII

Informatics Practices (Code 065)

Unit	Unit Name	Period		Marks
		Theory	Practical	Theory	Practical
1	NETWORKING AND OPEN STANDARDS	20	-	10	-
2	PROGRAMMING	42	40	25	16
3	RELATIONAL DATABASE MANAGEMENT SYSTEM	42	40	30	9
4	IT APPLICATIONS	6	20	5	5
		110	100	70	30

UNIT 1: NETWORKING AND OPEN STANDARDS

Computer Networking: Networking - a brief overview, Identifying computers and users over a

network (Domain Name, MAC 'Media Access Control' and IP address), domain name resolution,

Network Topologies, Types of network - LAN, MAN, WAN, PAN; Wired Technologies - Co-

Axial, Ethernet Cable, Optical Fiber; Wireless Technologies - Blue Tooth, Infrared, Microwave, Radio

Link, Satellite Link; Network Devices - Hub, Switch, Repeater, Gateway - and their functions;

Network security - denial of service, intrusion problems, snooping;

Open Source Concepts:

Open Source Software (OSI norms), common FOSS examples (Gnu/Linux, Firefox, OpenOffice),

common open standards (open document format, Ogg Vorbis)

Indian Language Computing: character encoding, UNICODE and Indian Language, different types of

fonts (open type vs true type, static vs dynamic), Entering Indian Language Text - phonetic and keymap

based.

UNIT 2: PROGRAMMING

Review of Class XI;

Programming Fundamentals

Access specifier for classes, Members and methods, Concept of package

Inheritance: need and implementation, Method Overloading and Overriding, Abstract Class and Interfaces, use of interfaces

Commonly used libraries: String class and methods: toString(), concat(), length(), toLowerCase(),

toUpperCase(), trim(), substring()

Math object: pow(), round()

Simple GUI Objects: Dialog

Accessing MySQL database using ODBC to connect with database.

Web application development: URL, Web Server, Communicating with the web server, concept of

Client and Server Side.

HTML based web pages covering basic tags - HTML, TITLE, BODY, H1..H6, Paragraph (P), Line

Break (BR), Section Separator (HR), FONT, TABLE, LIST (UL, OL), FORM;

Creating and accessing static pages using HTML and introduction to XML

UNIT 3: RELATIONAL DATABASE MANAGEMENT SYSTEM

Review of RDBMS from Class XI

Database Fundamentals

Concept of Database Transaction, Committing and revoking a Transaction using COMMIT and

REVOKE,

Grouping Records: GROUP BY, Group functions - MAX(), MIN(), AVG(), SUM(), COUNT();using COUNT(*), DISTINCT clause with COUNT, Group Functions and Null Values,

Displaying Data From Multiple Tables: Equi-Join and Cartesian Products; concept of Foreign Key;

Creating a Table with PRIMARY KEY and NOT NULL constraints, adding a Constraint, enabling

Constraints, Viewing Constraints, Viewing the Columns Associated with Constraints;

ALTER TABLE for deleting a column, ALTER TABLE for modifying data types of a column

DROP Table for deleting a table;

UNIT 4: IT APPLICATIONS

Revisiting the features of e-Governance, e-Business and e-Learning

Front-end Interface - Introduction; content and features; identifying and using appropriate component

(Text Box, Radio Button, CheckBox, List) for data entry, validation and display;

Back-end Database - Introduction and its purpose; exploring the requirement of tables and its essential

attributes;

Front-End and Database Connectivity - Introduction, requirement and benefits