Class 11 Information Technology (802) – CBSE Syllabus 2026–27
Complete curriculum guide and reference handbook for CBSE Class 11 Information Technology (Subject Code 802) for Academic Session 2026–27. Master Computer Organization & Hardware, Networking & Internet Protocols, Office Automation Tools (OpenOffice Writer, Calc & Impress), Relational Database Management with MySQL, and Java GUI Rapid Application Development using NetBeans IDE.
Course Overview & Learning Outcomes
Job Role: Domestic IT Helpdesk Assistant | NSQF Aligned Curriculum for Class XI
Course Preamble & Scope
Computer literacy and information systems are instrumental in bringing revolutionary changes across industry, scientific research, and modern commerce. The Class 11 Information Technology course equips students to independently troubleshoot computer hardware, deploy office productivity workflows, query relational databases, and architect interactive graphical applications in Java.
- Master core functional & computational components of modern Von Neumann architecture.
- Diagnose and resolve common hardware, printer, network fly lead, and software issues.
- Build automated spreadsheets using formulas, mathematical functions, charts, and macros.
Graduate Competencies
On successful completion of the Class XI IT curriculum, students develop both vocational job-ready competencies and strong academic foundations for Class XII and undergraduate computer studies:
- Design relational databases and execute DDL & DML commands in MySQL.
- Develop event-driven Java desktop GUI applications on NetBeans IDE using Swing containers.
- Understand network topologies, communication protocols, cyber threats, and Indian IT Act norms.
- Communicate professionally with end-users and manage helpdesk client tickets.
Course Structure & Marks Distribution (Session 2026–27)
Total Marks: 100 (60 Theory + 40 Practical) | Total Instructional Hours: 260 Hours
| Part | Unit Name | Theory (Hrs) | Practical (Hrs) | Max Marks |
|---|---|---|---|---|
| Part A: Employability Skills | Unit 1: Communication Skills-III | 10 | 2 | |
| Unit 2: Self-Management Skills-III | 10 | 3 | ||
| Unit 3: ICT Skills-III | 10 | 1 | ||
| Unit 4: Entrepreneurial Skills-III | 15 | 3 | ||
| Unit 5: Green Skills-III | 05 | 1 | ||
| Part A Total | 50 Hours | 10 Marks | ||
| Part B: Subject Specific Skills | Unit 1: Computer Organization | 15 | 15 | 5 |
| Unit 2: Networking and Internet | 15 | 25 | 10 | |
| Unit 3: Office Automation Tools | 15 | 30 | 10 | |
| Unit 4: RDBMS (MySQL) | 15 | 20 | 10 | |
| Unit 5: Fundamentals of Java Programming | 25 | 35 | 15 | |
| Part B Total | 85 Hours | 125 Hours | 50 Marks | |
| Part C: Practical Work | Office Automation Tools (Writer / Calc / Impress) | Hands-on lab test | 15 | |
| Java NetBeans GUI Programme Execution | Swing UI + Event code | 10 | ||
| MySQL Command Queries (DDL & DML) | SQL Table & Queries | 5 | ||
| Part C Total | Practical Examination | 30 Marks | ||
| Part D: Project Work | Practical File / Student Portfolio | Min. 15 Java + 15 MySQL + Calc | 5 | |
| Viva Voce (Oral Defense) | External / Internal Examiner | 5 | ||
| Part D Total | Portfolio & Viva | 10 Marks | ||
| GRAND TOTAL (Theory 60 + Practical 40) | 260 Instructional Hours | 100 MARKS | ||
Part A: Employability Skills (50 Hours)
Mandatory soft skills and workplace competencies common across all CBSE senior secondary vocational courses.
Communication Skills-III
Active listening, verbal & non-verbal communication, writing professional emails, barrier resolution, and business etiquette for IT client coordination.
Self-Management Skills-III
Stress management techniques, emotional intelligence, time prioritization, self-motivation, and goal-setting frameworks for technical support roles.
ICT Skills-III
Spreadsheet handling, online collaboration platforms, digital file organization, system maintenance, and information security best practices.
Entrepreneurial Skills-III
Entrepreneurial mindsets, business opportunity identification, market research, risk assessment, and basic financial planning for freelance tech services.
Green Skills-III
Sustainable green practices, electronic waste (e-waste) management, energy conservation in computing facilities, and environmental laws supporting sustainable development.
Part B: Detailed Subject Specific Units
Comprehensive breakdown of Theory, Lab Practicals, and Learning Outcomes prescribed by CBSE for Class XI.
Unit 1: Computer Organization
30 Hours (15 Theory + 15 Practical) • 5 Marks
Core Theory Concepts
- Computer Fundamentals & Block Diagram: CPU components (Arithmetic Logic Unit, Control Unit, Internal Registers), Von Neumann architecture, input and output pipelines, and the Fetch-Decode-Execute instruction cycle.
- Memory Hierarchy & Storage Units: Primary memory (RAM volatile, ROM non-volatile), Secondary storage (HDD, SSD, Optical, Flash). Data units: Bit, Nibble (4 bits), Byte (8 bits), KB, MB, GB, TB, PB (PetaByte).
- Operating Systems (OS): Need, resource management functions (Processor, Memory, File, Device), types (Single-user, Multi-user, Real-Time OS, Mobile OS like Android/iOS vs Desktop OS Windows/Linux/macOS).
- Hardware & System Troubleshooting: Diagnostic procedures for display blanking, unresponsive keyboard/mouse, audio failure, printer IP configuration, print spooler queue clearing, network fly lead cable continuity, and NIC card drivers.
- Disk Utilities & File Management: Disk Space analysis, Disk Cleanup, Recycle Bin recovery, Disk Defragmentation, disabling rogue background services, Task Manager force-kill, and Command Prompt file searches using wildcards (
*and?).
Lab Practicals & Demonstrations
Hands-on Exercises in Computer Lab:
- Identify and inspect peripheral I/O ports, RJ45 jacks, RAM sticks, and motherboard expansion slots.
- Set up a local network printer, assign a static printer IP address, and modify print resolution & spooler settings.
- Forcefully restart hanging processes using Windows Task Manager / CLI commands.
- Execute Disk Cleanup and verify reclaimed hard drive space.
- Use Command Prompt to locate lost files using wildcard patterns (e.g.,
dir *.docx /s).
Unit 2: Networking and Internet
40 Hours (15 Theory + 25 Practical) • 10 Marks
Core Theory Concepts
- Networking Fundamentals & Media: Sender, Receiver, Channel, Message, Protocols. Guided Media (Twisted pair UTP/STP, Coaxial, Optical Fiber) vs Unguided Media (Radio Waves, Microwaves, Infrared, Satellite).
- Generations of Mobile Networks: Evolution from 1G (analog voice), 2G (digital voice, SMS, GPRS), 3G (mobile internet, video calls), 4G (LTE, VoLTE, high-speed broadband), to 5G (ultra-low latency, massive IoT connectivity).
- Network Hardware Devices: RJ45 connector, Modem (Modulation/Demodulation), Repeater, Hub (passive/active), Switch (intelligent packet forwarding via MAC addresses), Bridge, Gateway (protocol translation), and Router.
- Topologies & Geographical Types: Bus, Star, Ring, Tree, Mesh topologies. Network classification: PAN (Personal Area Network), LAN (Local), MAN (Metropolitan), WAN (Wide), and VAN (Vehicular Ad-hoc Network).
- Protocols & Data Transfer Rates: TCP/IP, FTP, HTTP, HTTPS, SMTP, POP3, PPP, UDP. Bandwidth units (Hz, KHz, MHz, GHz) and speed metrics (bps, Kbps, KBps, Mbps, MBps, Gbps).
- Cyber Security & Cyber Laws: Digital Footprint, Malware (Viruses, Worms, Trojans, Adware, Spyware), DoS Attacks, Phishing, Pharming, Spoofing, Cyber Bullying, Stalking, Antivirus, Firewalls, Netiquettes, and the Indian IT Act 2000 (cyberlawsindia.net).
Practical Network Diagnostics
Lab Practice & Safety Tasks:
- Identify transmission cables, patch panels, switches, and routers in the school computer lab.
- Configure a Wi-Fi mobile hotspot, secure with WPA2/WPA3 pre-shared key, and connect client devices.
- Measure effective network bandwidth and download/upload throughput using speed testing utilities.
- Inspect browser security certificates (SSL/TLS padlock) and configure firewall rules.
- Explore national cyber safety reporting portals and analyze real-world cybercrime case studies.
Unit 3: Office Automation Tools
45 Hours (15 Theory + 30 Practical) • 10 Marks
- GUI layout: work area, ruler, status bar, and Navigator window.
- Document formatting: fonts, line spacing, margins, header/footer.
- Creating and styling tables: inserting/deleting rows and columns, merging/splitting cells, borders.
- Document views: Print Layout, Web Layout, Full Screen.
- Exporting documents to PDF format.
- Spreadsheet fundamentals: workbook, worksheets, cells, and ranges.
- AutoFill handle for date, month, and numeric series.
- Cell Referencing: Relative (
A1), Absolute ($A$1), Mixed ($A1). - Predefined functions:
SUM,AVERAGE,SQRT,ROUND,PRODUCT,POWER,LOG,ABS. - Data sorting, filtering (AutoFilter), and creating charts (Column, Pie, Bar).
- Recording and executing macros for workflow automation.
- Presentation interface, slide master, and layout templates.
- Multiple slide views: Normal, Outline, Notes, Handout, Slide Sorter.
- Custom slide transitions and entrance/exit animations.
- Formatting slide text, bullet points, headers, and footers.
- Configuring automated slideshow timings and rehearsing presentations.
Unit 4: Relational Database Management System (RDBMS)
35 Hours (15 Theory + 20 Practical) • 10 Marks
Relational Concepts & Keys
- Database Advantages: Eliminates data redundancy, maintains data consistency, ensures data integrity, and facilitates secure concurrent access compared to traditional file systems.
- Relational Model Terminology: Relation (Table), Tuple (Row/Record), Attribute (Column/Field), Degree (number of columns), Cardinality (number of rows), and Domain (pool of valid values).
- Keys in RDBMS: Primary Key (uniquely identifies tuples, cannot be NULL), Candidate Key (minimal superkey eligible to become primary key), Alternate Key (candidate keys not chosen as primary), and Foreign Key (enforces referential integrity between related tables).
MySQL SQL Command Reference
-- 1. DDL: Create Database & Table
CREATE DATABASE SchoolDB;
USE SchoolDB;
CREATE TABLE Student (
RollNo INT PRIMARY KEY,
Name VARCHAR(30) NOT NULL,
Marks DECIMAL(5,2),
Stream VARCHAR(15)
);
-- 2. DML: Insert & Select
INSERT INTO Student VALUES (101, 'Aarav', 92.5, 'Science');
SELECT * FROM Student WHERE Marks >= 80 ORDER BY Marks DESC;
SELECT DISTINCT Stream FROM Student WHERE Stream LIKE '%c%';
Unit 5: Fundamentals of Java Programming (NetBeans IDE)
60 Hours (25 Theory + 35 Practical) • 15 Marks (Highest Weightage)
NetBeans Rapid Application GUI Components
- JFrameForm Container: Top-level window onto which graphical UI controls are dragged from the NetBeans Palette window.
- Swing Controls:
jLabel(display labels),jTextField(input box),jTextArea(multi-line text),jButton(trigger action),jRadioButtonwithButtonGroup,jCheckBox,jPasswordField,jComboBox,jListBox, andJOptionPanedialogs. - Component Properties: Modifying
text,font,foreground,background,editable, andenabledin the Properties Inspector.
Java Core Language Elements
- 8 Primitive Data Types:
byte,short,int,long,float,double,char, andboolean. - Operators: Arithmetic (
+ - * / %), Relational (== != > < >= <=), Logical (&& || !), and Assignment (= += -=). - Decision Selection Statements:
if,if-else, nested conditionals, and multi-branchswitch-casewithbreakanddefaultclauses. - Parsing & Event Wiring:
Integer.parseInt(),Double.parseDouble(),getText(),setText(), andactionPerformedbutton event handlers.
Practical Examination & Project Work (40 Marks)
Conducted in the school computer lab under external and internal supervision.
Office Automation Tools
Hands-on tasks in OpenOffice Calc (formula calculations, functions, charts) and OpenOffice Writer (table formatting & document layouts).
Java NetBeans Programme
Designing a Swing JFrame GUI, setting component properties, handling button click events, and executing decision/arithmetic logic.
MySQL SQL Queries
Table schema creation with primary key constraints, populating records with INSERT, and executing selective SELECT queries with WHERE and ORDER BY.
Portfolio & Viva Voce
Practical File (5 Marks) with minimum 15 Java programs & 15 MySQL queries + Oral Viva Voce defense (5 Marks) covering computer theory and code.
Java NetBeans GUI Practical Lab Recipes
Core GUI programming problems prescribed by the CBSE Class 11 Information Technology curriculum.
// Read inputs from jTextFields, parse to double, compute SI
double p = Double.parseDouble(txtPrinciple.getText());
double r = Double.parseDouble(txtRate.getText());
double t = Double.parseDouble(txtTime.getText());
double si = (p * r * t) / 100.0;
double total = p + si;
txtSI.setText(String.valueOf(si));
txtTotal.setText(String.valueOf(total));
JOptionPane.showMessageDialog(null, "Interest Calculated!");
// Sum 5 subjects, determine grade using if-else
double total = m1 + m2 + m3 + m4 + m5;
double pct = total / 5.0;
String grade = "";
if (pct >= 90) grade = "A+";
else if (pct >= 80) grade = "A";
else if (pct >= 70) grade = "B";
else if (pct >= 50) grade = "C";
else grade = "Needs Improvement";
lblResult.setText("Total: " + total + " | %: " + pct + " | Grade: " + grade);
// Extract first char, evaluate with switch-case
char ch = txtChar.getText().toLowerCase().charAt(0);
switch(ch) {
case 'a': case 'e': case 'i': case 'o': case 'u':
lblStatus.setText("The character is a Vowel.");
break;
default:
lblStatus.setText("The character is a Consonant.");
}
// Change button background from selected dropdown item
String color = cmbColors.getSelectedItem().toString();
if (color.equalsIgnoreCase("Red"))
btnAction.setBackground(java.awt.Color.RED);
else if (color.equalsIgnoreCase("Green"))
btnAction.setBackground(java.awt.Color.GREEN);
else if (color.equalsIgnoreCase("Blue"))
btnAction.setBackground(java.awt.Color.BLUE);
// Exit Application Confirmation Dialog
System.exit(0);
Class 11 IT Practice MCQ Quiz
Test your conceptual knowledge across Computer Organization, Networking, Calc, MySQL, and Java.
In computer memory terminology, how many bits constitute one 'Nibble'?
Which of the following commands in MySQL is categorized as a Data Definition Language (DDL) command?
Which network device operates at the Physical layer to regenerate weakened electrical or optical signals over long transmission distances?
In OpenOffice Calc / Spreadsheets, which character is prefixed to lock column and row references for absolute addressing (e.g., $A$1)?
In NetBeans Java GUI development, which Swing control is used to group Radio Buttons so that only one option can be selected at any time?
What is the degree and cardinality of a database table containing 6 columns and 40 rows?
Which protocol is primarily utilized to transfer files reliably between a local client and a remote server on the Internet?
In Java GUI, which method is used to extract textual content typed by a user inside a jTextField component?
Which system utility reorganizes fragmented files on a magnetic hard disk drive to boost read/write performance?
Which SQL pattern matching wildcard symbol in the LIKE clause matches any sequence of zero or more characters in MySQL?
Recommended Lab Equipment & Software Support
Hardware Setup
- Personal Computers / Laptops: Core i3/i5 or equivalent processor, 8GB RAM, 256GB SSD storage.
- High-resolution laser printer & optical flatbed scanner for hardware troubleshooting demos.
- Local Area Network infrastructure with manageable Ethernet switches, RJ45 patch cables, and Wi-Fi routers.
- Dedicated digital projector or interactive smart display panel for classroom instruction.
Prescribed Software Stack
- Office Suite: Apache OpenOffice (Writer, Calc, Impress) or LibreOffice open-source suite.
- Java IDE: Apache NetBeans IDE (v8.2 or NetBeans 12+) with Java Development Kit (JDK 8 / 11).
- Database Engine: MySQL Server 5.7 / 8.0 Community Edition and MySQL Workbench / Command Line Client.
- Operating System: Windows 10/11 or Ubuntu Linux 20.04/22.04 LTS.
Career Opportunities & Vertical Mobility
Direct Employment Roles
Trained as Domestic IT Helpdesk Assistants, students qualify for entry-level technology and customer coordination roles:
Academic Vertical Progression
Students advance vertically to Class XII IT (Code 802) covering RDBMS SQL Joins, Web Applications, Advanced Java OOP (Multithreading, Exceptions, Collections), and Work Integrated Learning DMA.
Post-schooling, students possess priority foundational readiness for undergraduate degree programs: BCA (Bachelor of Computer Applications), B.Sc (Computer Science / IT), B.Voc (Software Development), and B.Tech / B.E. (Computer Science & IT).
Class 11 Information Technology FAQs
Common questions from CBSE students and parents answered by subject experts.
Master Class 11 IT (802) with TeacherColab Mentors
Gain mastery over Java GUI application coding, complex MySQL queries, and OpenOffice automation. Get dedicated exam preparation, live debugging assistance, and practical project guidance.