Class 12 Information Technology (802) – CBSE Syllabus 2026–27
Comprehensive curriculum blueprint for CBSE Class 12 Information Technology (Subject Code 802). Master Database Concepts & MySQL RDBMS (15 Marks), Operating Web Based Applications (10 Marks), Fundamentals of Java OOP Programming (20 Marks), Work Integrated Learning IT / DMA (5 Marks), Employability Skills (10 Marks), and the 40-mark Practical Exam including Java NetBeans Projects and SQL lab queries.
Job Role: Domestic IT Helpdesk Assistant & Course Outcomes
Aligned with National Skills Qualifications Framework (NSQF Level 4) for IT-ITeS industry readiness.
Role & Responsibilities of a Domestic IT Helpdesk Assistant
In the modern IT-ITeS sector, a Domestic IT Helpdesk Assistant possesses thorough knowledge of computer hardware, software systems, and technology trends. This desk-based role involves entering, retrieving, and sharing data, assisting software developers or database engineers, interacting independently with clients, inspecting and maintaining computer networks, and troubleshooting hardware, software, printer, and connectivity issues in strict adherence to company SLA policies.
Technical Competencies (Part B)
- Advanced RDBMS & SQL: Create, alter, and query relational databases in MySQL; apply grouping, aggregate functions, and multi-table joins.
- Web Based Applications: Analyze online reservation systems, E-Governance, payment gateways, and project management development lifecycles.
- Java OOP Programming: Master classes, inheritance, method overloading/overriding, arrays, constructors, and the 4 pillars of OOP.
- Advanced Java Features: Implement exception handling (try-catch), multithreading, string manipulation, wrapper classes, and assertions.
- Helpdesk Troubleshooting: Inspect network fly leads, configure printer IP addresses, manage system utilities, and resolve client tickets.
Soft Skills & Employability (Part A)
- Communication Skills-IV: Professional telephone etiquettes, handling difficult customer complaints, active listening, and technical documentation.
- Self-Management Skills-IV: Advanced time management, self-motivation, goal setting under pressure, and emotional intelligence.
- ICT Skills-IV: Spreadsheet data management, software installation, cloud backup protocols, and cybersecurity hygiene.
- Entrepreneurship & Green Skills: Business model generation, financial accounting fundamentals, and green computing protocols in IT offices.
Course Structure & Marks Distribution (Class XII · Session 2026–27)
Total Marks: 100 (60 Theory Paper + 40 Practical Exam) | Total Instructional Hours: 260 Hours
| Part | Unit Name | Theory Hours | Practical Hours | Total Hours | Max Marks |
|---|---|---|---|---|---|
| Part A: Employability Skills | Unit 1: Communication Skills-IV | 10 | 10 | 2 | |
| Unit 2: Self-Management Skills-IV | 10 | 10 | 3 | ||
| Unit 3: Information & Communication Technology Skills-IV | 10 | 10 | 1 | ||
| Unit 4: Entrepreneurial Skills-IV | 15 | 15 | 3 | ||
| Unit 5: Green Skills-IV | 05 | 05 | 1 | ||
| Part A Sub-Total | 50 Hours | 50 Hours | 10 Marks | ||
| Part B: Subject Specific Skills | Unit 1: Database Concepts – RDBMS Tool (MySQL) | 30 | 45 | 75 | 15 |
| Unit 2: Operating Web Based Applications | 15 | 20 | 35 | 10 | |
| Unit 3: JAVA - Fundamentals of Java ProgrammingHighest Weightage | 30 | 50 | 80 | 20 | |
| Unit 4: Work Integrated Learning IT – DMA | 10 | 10 | 20 | 5 | |
| Part B Sub-Total | 85 | 125 | 210 Hours | 50 Marks | |
| THEORY EXAMINATION (Part A 10M + Part B 50M) | 260 Instructional Hours | 60 Marks | |||
| Part C: Practical Work | ● Java Program | Hands-on Lab | 10 | ||
| ● SQL Queries (Table Creation + 5 Queries) | MySQL Lab | 10 | |||
| ● Practical File (Min 15 Java Programs + Min 15 MySQL Queries) | Student Portfolio | 10 | |||
| ● Viva Voce | Oral Examination | 5 | |||
| Part C Sub-Total | Practical Examination | 35 Marks | |||
| Part D: Project Work | Any Software Application made using Java in NetBeans IDE | Project Submission | 5 | ||
| GRAND TOTAL (Theory 60 + Practical 40) | 260 Total Hours | 100 Marks | |||
Class 12 IT (802) – Subject Specific Skills (50 Marks)
Comprehensive breakdown of the 4 units prescribed for the CBSE Class XII Board Examination.
Database Concepts – RDBMS Tool (MySQL)
1. RDBMS Fundamentals
- ● Relational Concepts: Table / Relation, Tuples (Rows), Attributes (Columns).
- ● Metrics: Degree (number of columns) vs Cardinality (number of rows).
- ● Key Constraints: Primary Key, Candidate Key, Alternate Key, Foreign Key.
- ● Referential Integrity: Rules enforcing consistent relationships across linked tables.
2. DDL & DML Commands
CREATE DATABASE school;
CREATE TABLE student (
rollno INT PRIMARY KEY,
name VARCHAR(30) NOT NULL
);
INSERT INTO student VALUES (1, 'Aarav');
ALTER TABLE student ADD age INT;
3. Grouping & Multi-Table Joins
SELECT dept, COUNT(*)
FROM emp
GROUP BY dept
HAVING COUNT(*) > 5;
SELECT e.name, d.dname
FROM emp e, dept d
WHERE e.deptno = d.deptno;
Operating Web Based Applications
Core Real-World Web Platforms
Web Project Management & Case Studies
● Case Study 1: Online Game (event handling, score keeping, user sessions).
● Case Study 2: Online Quiz (question bank arrays, timer, radio validation).
● Case Study 3: Online Bill Calculator (multi-item tax, discount, total calculation).
Fundamentals of Java Programming (OOP & NetBeans)
Object Oriented Concepts
- ● 4 Pillars: Encapsulation, Inheritance, Polymorphism, Abstraction.
- ● Class Design: Methods, constructors (default & parameterized),
thiskeyword. - ● Static Members: Static variables and static methods shared across instances.
Flow Control & Arrays
- ● Selection:
if-else, nested-if,switch-case. - ● Loops:
for,while,do-while,break,continue. - ● Arrays: 1D & 2D array allocation, traversal, linear/binary search.
Advanced Java Core
- ● Exception Handling:
try,catch,finally,throw,throws. - ● Assertions: Debugging using
assertstatement. - ● Multithreading: Extending
Threadvs implementingRunnable.
Strings & Autoboxing
- ● Wrapper Classes:
Integer,Double,Boolean. - ● Autoboxing / Unboxing: Automatic primitive-to-object mapping.
- ● String Methods:
length(),substring(),compareTo(),equals().
public class BankAccount {
private int accNo; private double balance;
public BankAccount(int accNo, double balance) {
this.accNo = accNo; this.balance = balance;
}
public void withdraw(double amt) throws Exception {
if (amt > balance) throw new Exception("Insufficient balance!");
balance -= amt;
}
}
Work Integrated Learning IT – DMA
Identification of Work Areas
Understanding enterprise IT workstations, computer hardware assembly, cabling standards, network fly leads, RJ-45 crimping, hubs/switches, and local printer installation protocols.
Work Experience & Ticket Resolution
Managing user support tickets, diagnosing driver faults, printer spooler troubleshooting, software installations, remote desktop support, and professional customer escalation etiquette.
Part A: Employability Skills (10 Marks / 50 Hours)
Mandatory senior secondary foundation skills prescribed across all CBSE Class 12 Vocational subjects.
Communication Skills-IV
Active listening, written technical correspondence, conflict resolution, professional customer service phone communication.
Self-Management Skills-IV
Stress coping mechanisms, self-motivation factors, prioritizing urgent vs important tasks, emotional resilience.
ICT Skills-IV
Spreadsheet advanced formulas, database maintenance, cloud security, cyber threats, and antivirus administration.
Entrepreneurial Skills-IV
Identifying business opportunities, marketing strategy, accounting basics, overcoming enterprise risks.
Green Skills-IV
Green jobs in IT, e-waste management rules, energy-efficient data centers, UN Sustainable Development Goals.
Part C & D: Practical Examination & Project Blueprint (40 Marks)
Practical assessment guidelines prescribed by CBSE Department of Skill Education for Class XII.
| Component | Evaluation Details | Requirements | Marks |
|---|---|---|---|
| Java Program | Hands-on coding problem testing OOP, arrays, control flow, or exception handling | Lab Execution | 10 Marks |
| SQL Queries | MySQL lab test: Table creation with constraints + 5 data retrieval & modification queries | MySQL Prompt | 10 Marks |
| Practical File | Student record file containing printed code and execution outputs | Min 15 Java + 15 SQL | 10 Marks |
| Viva Voce | Oral examination based directly on the practical file, Java concepts, and MySQL | External Examiner | 05 Marks |
| Part C Practical Sub-Total | 35 Marks | ||
| Part D: Project Work | Any functional GUI software application developed using Java in NetBeans IDE | NetBeans Application | 05 Marks |
| Total Practical Examination Marks | 40 Marks | ||
Lab Equipment, Career Roles & Vertical Mobility
Lab Setup & Tools
Prescribed hardware and software requirements:
- ● Hardware: Desktops/Laptops, Scanner, Projector, Network Hub/Switch, Internet.
- ● Software: Java NetBeans IDE, MySQL Server & Client, OpenOffice suite.
Career Opportunities
Industry roles accessible after Class XII certification:
Vertical Academic Mobility
Higher education pathways following Class 12 IT:
- ● Undergraduate Degrees: BCA (Bachelor of Computer Applications), B.Sc IT / CS, B.Voc in Software Development.
- ● Corporate Growth: Progress from Desktop Entry Operator to Application Developer and Software Engineer.
Class 12 IT Practice MCQs & Solutions
Q1. In MySQL, which SQL clause is used to filter records AFTER grouping has been performed by a GROUP BY clause?
Q2. What is the degree and cardinality of a relation with 5 columns (attributes) and 25 rows (tuples)?
Q3. Which Object-Oriented Programming (OOP) feature in Java allows a subclass to inherit methods and properties from a parent class using the 'extends' keyword?
Q4. What happens when you compile and run a Java program where an array index is accessed outside its allocated boundary (e.g., arr[10] when array size is 5)?
Q5. In Java multithreading, which method is invoked to transition a newly instantiated Thread into the Runnable state?
Q6. What is the primary difference between a String and a StringBuffer object in Java?
Q7. What is the conversion of a primitive data type into its corresponding Wrapper class object called in modern Java (e.g., int to Integer)?
Q8. Which of the following is an example of an E-Governance web application in India?
Q9. What is the primary job role assigned to the CBSE Class 12 Information Technology (Code 802) course?
Q10. In the 40-mark Practical Examination for Class 12 IT, how many marks are allocated to the Java Programming lab problem?
Frequently Asked Questions (Theory & Viva)
Need 1-on-1 Help with Class 12 IT, Java OOP & MySQL?
TeacherColab provides personalized live mentoring for CBSE Class 12 IT (802), Java NetBeans projects, MySQL queries, and board exam scoring strategies.
Curriculum Reference
This page is based on the CBSE Information Technology (Subject Code 802), Class XII (Session 2026–2027), Job Role: Domestic IT Helpdesk Assistant, Department of Skill Education, Central Board of Secondary Education (CBSE), Shiksha Sadan, 17, Rouse Avenue, New Delhi – 110002.
TeacherColab is an independent educational platform and is not affiliated with or endorsed by CBSE.