Class 10 Information Technology (402) – CBSE Syllabus 2026–27
Complete curriculum guide for CBSE Class 10 Information Technology (Subject Code 402) for Academic Session 2026–27. Master LibreOffice Writer (Digital Documentation), LibreOffice Calc (Electronic Spreadsheets), LibreOffice Base (RDBMS), Workplace Health & Safety, Practical Examination blueprints, and Data Entry Centre field visits.
Job Role: Domestic Data Entry Operator & Learning Outcomes
Aligned with National Skills Qualifications Framework (NSQF) for IT-ITeS sector readiness.
Role & Responsibilities of a Domestic Data Entry Operator
In the IT-ITeS industry, a Domestic Data Entry Operator (DEO) is responsible for electronic data entry from the client side to the office site or vice-versa on a daily work report and hourly basis. Individuals must possess thorough knowledge of office technology trends, database management systems (DBMS), rapid keyboard typing accuracy, safe data encoding, and data retrieval protocols to ensure data integrity across personal computer systems.
Technical Competencies
- Advanced Digital Documentation: Master LibreOffice Writer styles, images, drawing objects, custom Table of Contents (ToC), templates, and Track Changes for professional document review.
- Electronic Spreadsheets: Consolidate multi-sheet data, subtotals, What-If Scenarios, Goal Seek reverse calculations, Solver optimization, macros automation, and linked data in Calc.
- Database Management (RDBMS): Design relational tables in LibreOffice Base, set Primary Keys, establish 1:1, 1:N, and N:M relationships with referential integrity, and build queries, forms, and reports.
- Workplace Health & Safety: Identify physical, electrical, and fire hazards, follow office ergonomic standards, and execute emergency evacuation and first aid protocols.
Soft Skills & Employability
- Communication Skills-II: Develop active listening, persuasive speaking, effective non-verbal communication, and constructive feedback loops in office environments.
- Self-Management Skills-II: Cultivate self-awareness, goal setting via SMART framework, time management, and stress management techniques for continuous professional growth.
- ICT Skills-II: Safe, responsible, and ethical use of digital platforms, computer maintenance, antivirus configuration, and cyber safety practices.
- Entrepreneurship & Green Skills: Nurture business problem-solving, financial literacy, risk management, green economy awareness, and sustainable development initiatives.
Course Structure & Marks Distribution (Session 2026–27)
Total Marks: 100 (50 Theory + 50 Practical) | Total Instructional Hours: 200 Hours
| Part | Units | Theory (Hrs) | Practical (Hrs) | Max Marks |
|---|---|---|---|---|
| Part A: Employability Skills | Unit 1: Communication Skills-II | 10 | 2 | |
| Unit 2: Self-Management Skills-II | 10 | 3 | ||
| Unit 3: Information & Communication Technology Skills-II | 10 | 1 | ||
| Unit 4: Entrepreneurial Skills-II | 15 | 3 | ||
| Unit 5: Green Skills-II | 05 | 1 | ||
| Part A Total | 50 Hours | 10 Marks | ||
| Part B: Subject Specific Skills | Unit 1: Digital Documentation (Advanced) using LibreOffice Writer | 12 | 18 | 8 |
| Unit 2: Electronic Spreadsheet (Advanced) using LibreOffice Calc | 15 | 23 | 10 | |
| Unit 3: Database Management System using LibreOffice Base | 18 | 27 | 12 | |
| Unit 4: Maintain Healthy, Safe and Secure Working Environment | 15 | 22 | 10 | |
| Part B Total | 60 Hours | 90 Hours | 40 Marks | |
| Part C: Practical Work | ● Digital Documentation (Advanced) using LibreOffice Writer | Hands-on Lab | 5 | |
| ● Electronic Spreadsheet (Advanced) using LibreOffice Calc | Hands-on Lab | 5 | ||
| ● Database Management System using LibreOffice Base | Hands-on Lab | 10 | ||
| ● Viva Voce | Oral Examination | 10 | ||
| Part C Total | Practical Examination | 30 Marks | ||
| Part D: Project & Portfolio | Project Work / Field Visit (Interdisciplinary Case Study via Base & Writer) | Case Study Report | 10 | |
| Portfolio / Practical File (Printouts with min 5 problems of Writer, Calc & Base) | Min 15 Problems | 10 | ||
| Part D Total | Project & Portfolio | 20 Marks | ||
| GRAND TOTAL (Theory 50 + Practical 50) | 200 Hours | 100 Marks | ||
Class 10 IT (402) – Subject Specific Skills (40 Marks)
Comprehensive chapter-by-chapter curriculum covering 15 chapters across LibreOffice Writer, Calc, Base, and Workplace Safety.
Direct Navigation to All Unit Hubs & 15 Dedicated Chapters
Click any Unit Hub to view comprehensive subject notes and revision cheat sheets, or open any individual chapter for specialized theory, lab steps, and interactive practice MCQs.
Digital Documentation (Advanced)
LibreOffice Writer Styles, Image Filters, Tables of Contents, and Track Changes.
Electronic Spreadsheet (Advanced)
LibreOffice Calc Consolidation, Scenarios, Goal Seek, Macros, and Document Sharing.
Database Management System
LibreOffice Base Relational Tables, Data Types, Relationships, SQL Queries, Forms & Reports.
Workplace Health & Safety
Occupational Hazards, Office Ergonomics, PASS Fire Safety, Evacuation, and First Aid.
Employability Skills
Communication, Self-Management, ICT Skills, Entrepreneurship, and Green Skills.
Mandatory 10-mark section covering 7 Cs of communication, SMART goals, OS maintenance, and UN Sustainable Development Goals.
Practicals & Project Work
Lab Exam (30M: Writer, Calc, Base & Viva) + Portfolio File & Field Visit Report (20M).
Step-by-step practical guides, minimum 15 printed problem templates, viva voce questions, and data entry center guidelines.
Digital Documentation (Advanced) using LibreOffice Writer
Introduction to Styles
Learn to create, update, and apply various styles in LibreOffice Writer for effective and consistent formatting.
Page, Paragraph, Character, Frame, List & Table styles; Styles and Formatting window; Fill Format; New style from selection & drag-and-drop; Loading styles from templates.
List style categories, apply Fill Format, create and update styles, import style from another document.
Working with Images
Insert, modify, and position images and drawing objects using multiple methods for professional publication layouts.
Inserting images (file dialog, drag & drop, copy-paste, linking); Image toolbar modifications (resize, crop, delete); Drawing objects (properties, grouping); Arrangement, Anchoring, Alignment & Text Wrapping.
Insert and link images, adjust line/fill properties of shapes, group objects, configure image wrap around text.
Advanced Features of Writer
Create and customize automated Tables of Contents (ToC), use and edit templates, and track review changes with comments.
Table of Contents creation & maintenance; Hierarchy of headings; Customizing ToC entries; Template creation, import, export; Track Changes feature (record, accept/reject, comments, compare documents).
Generate multi-level ToC, apply template to blank doc, record review edits, compare two versions of a document.
Electronic Spreadsheet (Advanced) using LibreOffice Calc
Scenarios & Goal Seek
Consolidate multi-source data, create mathematical subtotals, execute What-If Scenarios, and utilize Goal Seek & Solver.
Theory: Consolidating Data, Groups and Subtotals, What-if Scenarios, Scenario Manager, Goal Seek, Solver tool.
Practical: Aggregate data into summary tables, create subtotals for categories, run Scenario Manager, solve target values via Goal Seek.
Using Macros in Spreadsheet
Record, run, create, and organize macros, and build custom functions to automate repetitive calculation routines.
Theory: Recording macros, running macros, organizing simple macros, macros as functions, passing arguments as values.
Practical: Use Macro Recorder, create custom function macros, access spreadsheet cells via macro code, sort columns automatically.
Linking Spreadsheet Data
Manage multiple sheets, create cross-sheet and external document references, and link to external web/database sources.
Theory: Multi-sheet setup, keyboard/mouse sheet references, Relative vs Absolute hyperlinks, External Data, Registered Data Sources.
Practical: Setup multiple sheets in workbook, build formula links across documents, add/edit hyperlinks, connect to registered databases.
Share & Review Spreadsheet
Enable workbook sharing, track cell edits, manage collaborative review comments, and merge conflicting sheet revisions.
Theory: Sharing spreadsheets, recording changes, cell comments formatting, reviewing changes (accept/reject), sheet merging & comparing.
Practical: Set up spreadsheet for sharing, save collaborative edits, record change history, merge two conflicting versions.
Database Management System using LibreOffice Base
Introduction to DBMS & RDBMS
Understand data vs information, DBMS advantages, data models (Hierarchical, Network, Relational), and key RDBMS concepts.
Theory: Data & Information; Advantages of database; Hierarchical, Network & Relational models; RDBMS Terminology (Fields/Attributes, Records/Tuples, Tables/Relations); Keys (Primary, Foreign, Candidate); RDBMS Objects (Tables, Queries, Forms, Reports).
Practical: Distinguish data vs info, identify fields/records in sample tables, explain key constraints.
Starting with LibreOffice Base
Navigate the Base UI, manage data types, create tables via Wizard & Design View, set Primary Keys, and perform data entry.
Theory: Base UI, data types (Text, Number, Date/Time, Boolean, Binary), table creation via Wizard and Design View, setting Primary Key, record operations (enter, edit, delete, sort).
Practical: Launch Base, create sample table with Wizard, assign field data types, designate Primary Key, enter and sort records.
Working with Multiple Tables
Establish and manage table relationships (1:1, 1:N, N:M), maintain referential integrity, and configure field properties.
Theory: Table relationships types (one-to-one, one-to-many, many-to-many); Benefits of linked tables; Creating relationships in Base; Referential Integrity principles.
Practical: Link tables via common keys, edit and delete relationships, enforce integrity rules, set field default values.
Queries in Base
Construct and execute database queries using Query Wizard and Design View, apply filter criteria, and perform mathematical calculations.
Theory: Query creation via Wizard and Design View, editing queries, applying single & multi-field criteria, wildcard queries, numerical calculations.
Practical: Build queries with comparison operators (>, <, =), execute wildcard searches, calculate totals and averages across records.
Forms and Reports in Base
Design user-friendly data entry forms with the Form Controls toolbar, and generate publication-ready printable reports using the Report Wizard.
Forms:
Creating forms via wizard, modifying form layouts, Form Controls toolbar (text boxes, buttons, labels), search records via form view, record insertion and deletion.
Reports:
Generating reports using Report Wizard, customizing headers and footers, adding dates/times, grouping data, producing formatted summary printouts.
Maintain Healthy, Safe and Secure Working Environment
Health, Safety & Security at Workplace
Understand safety policies, identify physical, electrical, fire, and health hazards, and implement risk controls in computer environments.
Theory: Workplace hazards (physical, falls/slips, electrical, fire, health), hazards using computers, handling equipment/objects, stress at work, hazard control checklists.
Practical: Apply fire safety measures, prevent slips and falls, ensure electrical safety, practice basic first aid procedures.
Workplace Quality & Ergonomics
Monitor air/water quality, master office ergonomics, and prevent occupational overuse syndrome (OOS) and visual computer strain.
Theory: Air and water quality monitoring; Office ergonomics; Computer health tips; Musculoskeletal disorders (OOS, RSI, eye strain); Visual fatigue & lifestyle risks.
Practical: Demonstrate steps to handle workplace incidents, follow building evacuation plans in simulated drills.
Prevent Accidents & Emergencies
Detect and report emergency situations, follow corporate escalation rules, manage fires and electrical shock, and execute evacuations.
Theory: Accident identification, reporting protocols, accident types (trips, slips, elevators, falling goods), emergency response, fire prevention & ignition sources, electrical rescue.
Practical: Identify workplace hazard sources, assess risk severity, execute evacuation protocols during simulated crises.
Part A: Employability Skills (10 Marks / 50 Hours)
Mandatory vocational foundation skills common across all CBSE Class 10 Skill Subjects.
Communication Skills-II
Verbal & non-verbal communication, active listening, feedback loops, overcoming communication barriers, professional phone & email etiquette.
Self-Management Skills-II
Stress management techniques (yoga, meditation, nature walks), self-reliance, goal setting using SMART principles, time management matrix.
ICT Skills-II
Computer operating system navigation, file and folder organization, disk cleanup, antivirus updates, spam protection, cyber safety.
Entrepreneurial Skills-II
Characteristics of successful entrepreneurs, role of entrepreneurship in societal growth, business planning, financial literacy, overcoming risk.
Green Skills-II
Sustainable development goals (SDGs), green economy concepts, sustainable agricultural and energy practices, eco-friendly lifestyle habits.
Part C & D: Practical Examination, Project Work & Portfolio (50 Marks)
Practical competency assessment blueprint prescribed by CBSE Department of Skill Education.
Practical Examination & Viva Voce (30 Marks)
LibreOffice Writer Practical
Advanced styles, image placement, templates, or ToC creation
LibreOffice Calc Practical
Data consolidation, subtotals, Goal Seek, or linking sheets
LibreOffice Base Practical
Table creation, primary key, relationships, query criteria, forms/reports
Viva Voce
Oral examination on Writer, Calc, Base & workplace safety concepts
Project Work / Field Visit & Student Portfolio
Interdisciplinary Case Study Project
10 MarksStudents undertake a real-world case study (e.g., school inventory, library records, health clinic data). Input forms must be built in Base, summarized data reports extracted via Base, and the final analytical project report documented using Writer.
Portfolio / Practical File
10 MarksStudents must prepare and submit a hardcopy Practical File containing verified printouts of practical problems: minimum 5 problems in Writer, minimum 5 problems in Calc, and minimum 5 problems in Base (Total 15+ hands-on solutions).
Organisation of Field Visits to Data Entry Centres
CBSE mandates at least 3 educational / industrial field visits per year for Class X students.
9-Point Field Visit Observation & Inquiry Checklist
During visits to a commercial Data Entry Centre or BPO facility, students must observe and document:
Data Entry Centre Overview
Location, site accessibility, office building layout and physical organization.
Computer Infrastructure
Hardware configurations, networking switches, servers, high-speed scanners and printers.
Sitting Posture & Ergonomics
Ergonomic adjustable seating, screen heights, wrist rests, and operator fatigue reduction.
Assistive Technology
Accessibility tools, specialized software, speech-to-text, and adaptive input peripherals.
Manpower Engaged
Organizational hierarchy, operator shifts, supervisory roles, and technical support staff.
Total Operational Expenditure
Recurring costs of electricity, broadband lines, software licenses, and machine maintenance.
Total Annual Income
Revenue models, billing structures per entry/page, and commercial client contracts.
Annual Profit / Loss Analysis
Business financial viability, margins, volume scalability, and market competition.
Operational & Security Workflows
Client data privacy protocols, backup mechanisms, confidentiality agreements, and shift handovers.
List of Prescribed Equipment, Software & Furniture
Official suggestive specifications prescribed on Page 14 of the CBSE Class X IT Curriculum.
A. Hardware Equipment
- Desktop Computers: Latest / Pentium, min 2GB RAM, 512GB HDD, 17" LED, NIC, 3-button mouse, 105-keys keyboard, speakers & mic15
- Laser Printer (Black)01
- Inkjet Printer (Colour & B/W)01
- Flatbed Scanner01
- Online UPS (5 KVA)01
- 16-Port Network Switches01
- Air Conditioner (1.5 Tonne)02
- Broadband Telephone Line01
- Fire Extinguisher01
B. Software Suite
- Operating SystemLinux (e.g. Ubuntu / Boss Linux) and Windows 10/11 operating systems.
- Antivirus SoftwareLatest version active antivirus software with scheduled definition updates.
- Office Productivity SuiteLibreOffice (Writer, Calc, Base) or Apache OpenOffice suite for word processing, spreadsheets, and database management.
C. Furniture Norms
- Classroom Chairs & Desks25
- Computer Workstation Tables15
- Ergonomic Revolving Chairs15
- Dedicated Printer Tables02
- Trainer's Table & Chair01 each
- Steel Cupboard (Drawer type)02
- Lockable Storage Cabinet01
- Steel Almirah (Big & Small size)01 each
Career Opportunities & Vertical Mobility
Top employment sectors and educational advancement pathways for certified Domestic Data Entry Operators.
Top Hiring Sectors
Data Entry Operators and Data Processing Analysts input, verify, organize, query, and maintain critical records across diverse public and private enterprises:
Vertical Educational Mobility
Completing Class X IT (402) provides direct advancement into specialized polytechnic and vocational degrees:
Teacher's / Trainer's Qualifications & Norms (RMSA Guidelines)
Diploma in CS / IT OR Bachelor's Degree in Computer Application / Science / IT (BCA, B.Sc CS/IT) OR Graduate with PGDCA / DOEACC A-Level Certificate.
Minimum 1 year of work experience in the same job role, proficiency in English and local regional language, comprehensive safety, health and hygiene awareness.
18–37 years (age relaxations per Govt. rules). Mandatory 20-day induction training in NSQF pedagogy and 5-day annual in-service training.
Frequently Asked Questions (Class 10 IT Code 402)
Book a Free Demo Class for Class 10 IT (402)
Score 100/100 in your CBSE Board Information Technology (402) examination. Master LibreOffice Writer formatting, Calc Goal Seek & macros, Base relational tables & queries, and viva voce with expert mentors.
Curriculum Reference
This page is based on the official CBSE Information Technology (Subject Code 402), Class X (Session 2026–2027), Job Role: Domestic Data Entry Operator, 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.