Celebration of Birthday

Rishita : My Daughter 

Syllabus: Informatics Practices

KENDRIYA VIDYALAYA SANGATHAN

SPLITUP SYLLABUS

FOR

INFORMATICS PRACTICE CLASS XII

Month	Content	Theory Periods	Practical Periods
April	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 - BlueTooth, 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 LanguageText - phonetic and keymap based. UNIT 2: PROGRAMMING Review of class XI (Suggested Topics) Programming Fundamental, Variables, Control Structures, Class, Methods. (Single Class only)	23	8

Month	Content	Theory Periods	Practical Periods
June	Basic GUI components – jFrame, jPanel, jButton, jTextField, jLabel, jRadioButton, jCheckBox, jComboBox, jListBox, Events: ActionEvent, FocusEvent, KeyEvent Methods associated with Swing Components. Note: Sample Form based problems can be given to the students to solve, as was done in earlier IP syllabus	9	2
July	UNIT 2: 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.	26	8
Aug	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 RDBMS Concepts and Review of Class XI	25	8
Sep	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 ColumnsAssociated with Constraints; ALTER TABLE for deleting a column,ALTER TABLE for modifying data types of a column DROP Table for deleting a table;	25	8
Oct and Nov (till 15th Nov )	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 Project: Java Swing and MySQL Based application development. Menu based Multi-frame application may be developed in the fields of e-business, e-learning or e-governance.	25	8
Dec Jan	Revision, Pre-Board, Project Submission	35