Submit

CBSE Class 12 Informatics Practices Syllabus & Marks

CBSE Class 12 Informatics Practices Syllabus

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



Subscribe to our Newsletter
×