Join Your Exam WhatsApp group to get regular news, updates & study materials HOW TO JOIN

CBSE Class 12 Commerce Informatics Practices topics for theory

CBSE Class 12 Commerce Informatics Practices topics for theory 

CBSE Class 12 Commerce Informatics Practices topics for theory 

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.

CBSE Class 12 Commerce Informatics Practices topics for theory 

Important topics

  • Relational Database Management System
  • Programming
  • Networking and open standards
  • IT Application

Marks allocation to these topics is as follows:

  • Relational Database Management System – 30 marks
  • Programming – 25 marks
  • Networking and open standards – 10 marks
  • IT Application – 5 marks

CBSE Class 12 Commerce Informatics Practices topics for theory 


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.


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

CBSE Class 12 Commerce Informatics Practices topics for theory 


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;


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

CBSE Class 12 Commerce Informatics Practices topics for theory 

The aim of the subject is to make a student:

  1. To understand the application development environment.
  2. To gain programming Skills in GUI Programming Tool and Database Creation in RDBMS.
  3. To design, program and develop database application using GUI Programming Tool and RDBMS.
  4. To learn database connectivity using Visual Basic as Front-end tool.
  5. To develop ability to use the Open Source Technology.

CBSE Class 12 Commerce Informatics Practices Preparation tips

  • Follow a pattern. For example, in case you start with long answer questions, complete that section and only then move to short or very short answer section.
  • Substantiate your answer with an example. For example, in a question where you have been asked to define concat() function, give an example for the same.
  • Highlight the important points and write your answer in points to enhance visibility.
  • Before you start the exam, utilize the first 15 minutes to scan the paper. Read the question paper thoroughly before jumping to write the answers.
  • Among the questions with internal choices, select the ones that you plan to attempt, and frame skeletons of the answers you are going to write for these questions.

CBSE Class 12 Commerce Informatics Practices Preparation tips-Tips to prepare well

  • Practice questions related to all functions. Know what each function does. For example, length () function returns the length of the
  • Make notes of all the theory related topics and know the definitions of terms like co-axial cables, LAN, WAN, MAN and PAN.
  • Prepare the unit on DBMS well. It is easy and is worth 30 marks. Know how each and every query affects the output. Know the function of all queries.
  • To master HTML, make HTML pages on your own.

CBSE Class 12 Commerce Informatics Practices topics for theory 

Recommended for such an enthusiastic audience:

CBSE Class 12 Commerce Informatics Practices topics for theory 

CAKART provides India’s top class XII commerce  faculty video classes – online Classes – at very cost effective rates. Get class XII commerce Video classes from to do a great preparation for your exam.
Watch class XII commerce Economics sample video lectures cbse lecture videos
Watch class XII commerce Accounting Sample video lecture class 11 video lectures
Watch class XII commerce Mathematics Sample video lecture cbse class 11 video lectures
For any questions chat with us by clicking on the chat button below or give a missed call at 9980100288

Leave a comment

Your email address will not be published. Required fields are marked *