Please wait, loading...

12 Information practice

CBSE Class 12 Informatics Practices

 

Informatics Practices is a course to get acquainted with computer terminologies and operation handling.

The course aims at teaching students the skills in Relational Databases, generating queries, helping students gain a working knowledge of a computer system and its peripherals. The CBSE syllabus for Informatics Practices also aims at developing programming skills in front-end application development in students.

The course is designed so that the students learn how to design, program and develop database driven web applications using GUI Programming.

The aim of the subject is to make a student:

  • Understand the application development process.

  • Gain programming skills in front-end application development

  • Gain skills in Database Creation and querying using ANSI SQL.

  • Design, program and develop database driven web applications using GUI Programming Tool and RDBMS.

  • Understand and appreciate open source and open standard concepts.


 

CBSE Informatics Practices Syllabus For Class 12

 

Unit-wise allocation of marks for CBSE Class 12 Informatics Practices:

 Unit No.

 Unit Name

 Theory Marks

 Practical Marks

 1

 NETWORKING AND OPEN STANDARDS

 10

 02

 2

 PROGRAMMING

 25

 16

 3

RELATIONAL DATABASE MANAGEMENT SYSTEM

 30

 08

 4

IT APPLICATIONS

 05

 04


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