CBSE Class 12 Informatics Practices Syllabus & Marks
CBSE Class 12 Informatics Practices Syllabus
The unit wise marks allocation and updated syllabus for CBSE Class 12 Commerce Informatics Practice is given in the link below.
UNIT 1: NETWORKING AND OPEN STANDARDS
Computer Networking: Networking - a brief overview, Basic concept of domain name, MAC, and IP Address, 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 (OSS), common FOSS/FLOSS examples (e.g. Gnu/Linux, Firefox,
Open Office), common open standards (open document format Ogg Vorbis)
Indian Language Computing: character encoding, UNICODE, different types of fonts (open type vs true type, static vs dynamic), Entering Indian Language Text - phonetic and key map based.
UNIT 2: PROGRAMMING
Review of Class XI Programming Fundamentals
Basic concept of Access specifier for classes, Members and methodsasic concept of Inheritance: need, Method Overloading and Overriding, Abstract Class and Interfaces,use of interfaces.
Commonly used libraries: String class and methods: to String(), concat(), length(), to LowerCase(),toUpperCase(), trim(), substring()
Math object: pow(), round()
Accessing MySQL database using ODBC/JDBC 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), LineBreak (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 XIDatabase 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: Cartesian product, Union, concept of Foreign Key, Equi-Join
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
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 Demonstration and development of appropriate Front-end interface and Back-end Database for e-Governance, e-Business and e-Learning applications