Take This Quiz & Predict Your Score in the coming CA CS or CMA Exam!
  • How important it is for you to pass the exam in this attempt?
  • What percentage of course you have finished well so far roughly?
  • How many hours you study in a day?
  • How many times you have revised the topics you have finished
  • Have you taken online or pen drive or live class from a renowned faculty?
  • What percentage of the classes you have watched?
  • Have you attempted mock tests or practice tests yet?
  • Are you planning to attempt mock tests conducted by external bodies- ICAI, ICSI, ICMAI or other institute?
  • How many tests you have taken?
  • Did you manage to finish the test papers on time?
  • Are you strictly following study material provided by the exam conducting authority such as ICAI/ICSI/ICMAI/Other Body?
  • How is your health in general?
  • How is your food habit?
  • Any interest in yoga or exercise or play sports regularly?
  • Planning to sleep well nights before the exams?
  • Planning to have light food and water before exams?

CBSE Class 12 Commerce Informatics Practices Paper Analysis

CBSE Class 12 Commerce Informatics Practices Paper Analysis

CBSE Class 12 Commerce Informatics Practices Paper Analysis

CBSE Class 12 Commerce Informatics Practices Paper Analysis : Informatics Practices is a course to get acquainted with computer terminologies and operation handling. 

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 Class 12 Commerce Informatics Practices Paper Analysis

Important topics for class 12 CBSE exam for Informatics Practices

  • 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 Paper Analysis

Tips to prepare well for class 12 CBSE exam for Informatics Practices

  • Make notes of all the theory related topics and know the definitions of terms like co-axial cables, LAN, WAN, MAN and PAN.
  • Practice questions related to all functions. Know what each function does. For example, length () function returns the length of the
  • 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 Paper Analysis

to score well in class 12 CBSE exam for Informatics Practices

  • 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. 
  • 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.
  • Highlight the important points and write your answer in points to enhance visibility.
  • 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.

CBSE Class 12 Commerce Informatics Practices Paper Analysis

The class XII board aspirants appeared for Informatics Practices examination today, March 27, 2017 conducted by CBSE at various examination centers. Informatics Practices was the last elective exam for science stream students. As per the feedback we received from students and teachers about the question paper, it can be concluded that the paper was not difficult and student who had prepared well and covered all the topics could easily have scored 85+. We spoke to Kulmeet Kohli, who is a PGT in Informatics Practices/Informatics Practices at G D Goenka, Greater Noida about the Informatics Practices question paper. 

For science students, this was the last elective subject exam so students were anxious and tensed about the paper in morning. But fortunately all the students who appeared for the exam were satisfied and happy with the Informatics Practices paper. Rather students found it simple and the easiest of all the papers conducted before. Programming and Boolean Algebra sections were application based and thus students found them easy to solve.

Analysis of the question paper: Each question paper was divided in three sections; Section A, B and C. There were a total of 7 questions and the students were given a choice between Section A and Section B while Section C was compulsory.

Section A: It was based on ‘C++’ programming and most questions were based on objects, coding and outputs which were to the point. Students with good logical and programming skills and who had thoroughly studied had no trouble comprehending the questions of this section. While an average student would have faced problem in getting outputs of few questions, eg:- Q.1(e),Q.1(f).

Section B: The section was for candidates with ‘Python’ programming and the section had simple application based questions.

Section C: It was a compulsory section and all examinees had to attempt it. The section had theoretical questions on networking, SQL and Boolean algebra, which they found simple and scoring. If a student had gone through CBSE sample papers, he would have found this section easy and would score good marks.

CBSE Class 12 Commerce Informatics Practices Paper Analysis

Were there any tricky or difficult questions in the paper?

Paper was good with no drawbacks, only one random function question was tricky.

Informatics Practices Learning Objectives:

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.


1. Student will become familiar with Application Development

2. Student will be able to develop & debug programs Independently.

3. Student can use SQL for storing and retrieving data from the RDBMS.

4. Ability to arrive at a normalized design of tables and other database objects in RDBMS.

5. Student will be able to develop a Client Server Application using Front end and Back end tools.

CBSE Class 12 Commerce Informatics Practices Paper Analysis

Class XII (Theory)                                   Duration: 3 hours                           Total Marks: 70   

Unit NoUnit NameMarks

CBSE Class 12 Commerce Informatics Practices Paper Analysis


Introduction to Open Source based software:

  • Terminology: OSS, FLOSS, GNU, FSF, OSI, W3C.
  • Definitions : Open Source Software, Freeware, Shareware, Proprietary software, Localisation, UNICODE
  • Softwares : Linux, Mozilla web browser, Apache server, MySQL, Postgres, Pango, OpenOffice, Tomcat, PHP, Python
  • Websites :,,,,,,

General concept, User interfaces (Front End), Underlying Database (Back End), Integration of User Interface and Database;

More application areas of Databases:

Inventory control, Financial Accounting, Pay-Accounting System, Invoicing Management System, Personal Management System / HRD System, Fees Management system, Result Analysis System, Admission Management System, Income Tax Management System;

Advanced Program Development Methodology:

System Development Life Cycle, Relational Database Concept, Relational Database, Management System, Data Models (Entity Relationship Model), Entity and Entity Set, Attributes (Single, Composite and Multi-Valued), Relationship (One-to-One, One-to-Many and Many-to-Many), Entity Relationship Modeling Conventions, Communicating with an RDBMS using SQL, Relational Database Management System, SQL Statements, About programming language in SQL.

Data Dictionary, Data Warehousing, Data Mining, Meta Data; Object Modeling:

Introduction to object oriented modeling using Unified Modeling Language (Concepts only). Client Server Computing: Concept of Client Server Computing.

UNIT 2: PROGRAMMING: Visual Basic Review of Class XI;

Programming Fundamentals Modules: Modules in Visual Basic- Form Modules, Standard Modules, and Class Modules;

Procedures: Procedures (General, Event, Function, Property); Control Structures: Decision Structure – IF, IF-THEN-ELSE, Select Case; Looping Structure- Do While…Loop, Do…Loop While, For…Next, For Each…Next;

Functions: Concept of Functions, Defining and Use of User Defined functions, function to perform calculations, Parameterized Functions;

Library Functions (System Functions)

String Function: Space( ), Str( ), Right( ), Left( ), Mid( ), InStr( ), Len( ), Ltrim( ), Rtrim( ), Ucase(), Lcase( ), String( );

Numeric Function: Sgn( ), Val( ), Int( );

Time-Related Function: Now( ), Time( ), Minute( ), Month( );

Miscellaneous Function: MsgBox( ), InputBox( );

Types of forms: Single Document Interface (SDI) and Multiple Document Interface (MDI);

MDI Applications: Creating MDI form and Child form, Arranging Child Forms;

Visual Basic Project: Properties, Component and References, Data Environment;

Accessing database from ORACLE using ODBC or ADO or OLEDB;

Accessing Databases: Using ODBC and OLE DB to connect with database.

Data Control: Accessing Data with the Data Control, Using Data-Aware Controls, Using Data Control Properties – Database Name, Exclusive, Options, Read Only, Record Source, Data Control Methods – Refresh, UpdateControls, UpdateRecord;

Bound Controls: Adding Bound Text and Bound Label Controls. Data-Bound list Boxes, Grids, and Sub-Forms

ADO (ActiveX Data Objects): Connection Object, Command Object, and Record Set Object, Special ADO Properties – Connection String (using single table), Command Text, Command Types, Cursor Locations, Cursor Types, Lock Types, Mode Types.

ADO Data Control: Simple Data linking using ADO Data Control Methods, ADO Data Control Events.


Review of RDBMS from Class XI

Database Fundamentals

Concept of Database Transaction, Committing a Transaction, Concept of “All or None” in a Transaction, Network Protocols Required (TCP/IP) for Data Communication, Stored Procedures, Concept of Database Fragmentation and Distributed Databases

PL/SQL (Programming Language in SQL)

Importance of Writing Procedures

Declaring Variables: About PL/SQL, PL/SQL Block Structure, Program Constructs, Use of Variables, Handling Variables in PL/SQL, Types of Variables, Declaration, Naming Rules, Assigning Values to Variables, Initialization, and Keywords, Scalar Data types, Base Scalar Data Types, Scalar Variable Declaration, %TYPE attribute: for variable declaration, Declaring Boolean Variables, PL/SQL Record Structure, Referencing Non-PL/SQL variables, DBMS_OUTPUT.PUT_LINE;

Writing Executable Statements:

PL/SQL Block Syntax and Guidelines, SQL functions in Code, SQL Functions in PL/SQL, PL/SQL Functions, Data type Conversion, Nested Blocks and Variable Scope, Operators in PL/SQL, Using Bind Variables, Programming Guidelines, Determining Variable Scope, SQL Statements in PL/SQL, Retrieving data in PL/SQL, Manipulating Data using PL/SQL, Inserting Data, Updating Data, Deleting Data, Naming Conventions, Commit and Rollback Statements, SQL Cursor, and Cursor Attributes;

Writing Control Structures:

Controlling PL/SQL Flow of Execution, IF statements, IF-THENELSE Statement Execution Flow, IF-THEN-ELSIF Statement Execution Flow, Building Logical Conditions, Logic Tables, Boolean Conditions,

Iterative Control:

LOOP Statement, Basic Loop, FOR Loop, While Loop;

Creating Procedures:

Overview of Procedures, Syntax for Creating Procedures, Developing Stored Procedures and its Advantages, Creating a Stored Procedure, Procedure Parameter Modes, Creating Procedures with Parameters, IN and OUT parameters and Usage, DEFAULT Option for Parameters, Removing Stored Procedures;

Writing Cursors:

Introduction to Cursors (Implicit and Explicit), Explicit Cursor Functions, Controlling Explicit Cursors, Declaring, Opening and Closing the Cursor, Fetching data from the Cursor, Explicit Cursor Attributes (%ISOPEN, %NOTFOUND, %ROWCOUNT), controlling multiple fetches, Cursors and Records, Cursor FOR Loops, Cursor FOR Loops using Sub Queries.


Types of Triggers: Row-Level Triggers, Statement Level Triggers, BEFORE and AFTER Triggers, INSTEAD of Triggers, Valid Trigger Type, Trigger Syntax, Combining Trigger Types, Enabling and Disabling Trigger, Replacing Trigger, Dropping a Trigger.

Development of Data Base Applications (Application Domain):

Student database for school, Employee database for a company, Library Database for Library Student database management system for school, Employee database management system for a company, Library Database management system for Library, Railway Reservation System, Hotel Reservation, Inventory Control System;

Reference Books:

  • Mastering Visual Basic 6 – Petroutsos (BPB)
  • Mastering Database Programming with Visual Basic 6 – Petroutsos (BPB)
  • Advanced Visual Basic 6 Project – Bay Ross (BPB)
  • Programming in Visual Basic 6 – Bay Ross (BPB)
  • Visual Basic 6 Complete – Sybex (BPB)
  • MCSD: Visual Basic 6 Desktop Applications Study Guide– Michael (BPB)
  • Successful Projects in Visual Basic – Christopher (BPB)
  • Oracle8: The Complete Reference – George Koch, Kevin Loney (TMHP)
  • Visual Basic Black Book (IDG)
  • Mastering Visual Basic.NET Database Programming – Petroutsos (BPB)
  • Programming in Visual Basic – McBride (BPB)
  • Mastering Oracle 8i – Freeman (BPB)
  • Learn Oracle 8i – Ramalho (BPB)
  • Visual Basic and ORACLE SSI Press
  • Oracle Programming with Visual Basic – Snowdon (BPB)
  • Quan Book ‘O’ Level all Vol. – DOEACC (BPB)

    CBSE Class 12 Commerce Informatics Practices Paper Analysis

    Example of how to answer a question paper can be seen here : Steps to answer question paper 

    How to Allot CBSE Class 12 Commerce Marks : CBSE Class 12 Commerce Allotment of Marks

    For more on CBSE Class 12 Commerce Informatics Practices Preparation Tips And to download Sample papers log onto

Leave a comment

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