402-IT-X

402 – Information Technology - Class X Page 1 of 17 CBSE | DEPARTMENT OF SKILL EDUCATION CURRICULUM FOR SESSION 2026-2027 INFORMATION TECHNOLOGY (SUB. CODE – 402) CLASS X COURSE TITLE: DOMESTIC DATA ENTRY OPERATOR Domestic Data Entry Operator in the IT-ITeS Industry is also known as Data Entry Operator. Individuals are responsible to provide daily work reports and work on a daily hour basis. The individual is responsible for electronic entry of data from the client side to the office site or viceversa. Individual tasks vary depending on the size and structure of the organization. This job requires the individual to have a thorough knowledge of various technology trends and processes as well as have updated knowledge about database management systems and IT initiatives. The individual should have fast and accurate typing/data encoding. This job involves working in a personal computer, and appropriate software to enter accurate data regarding different issues like retrieving data from a computer or to a computer COURSE OBJECTIVES: In this course, students will be introduced to advanced concepts of digital documentation, spreadsheets, database management, and workplace safety, enhancing both technical and soft skills. The course aims to develop effective communication skills, including active listening, speaking, and presentation abilities, while fostering self-management through time management, goal setting, and stress management techniques. Students will gain proficiency in Information and Communication Technology (ICT), ensuring safe and ethical use of digital tools. The course also focuses on nurturing an entrepreneurial mindset, critical thinking, and innovation skills, along with a strong understanding of sustainable practices and environmental conservation. Learners will master advanced document creation, data analysis, and automation techniques using LibreOffice tools and develop competency in designing and managing databases. Emphasis is placed on maintaining a safe and secure work environment by understanding health, safety, and emergency protocols, thus preparing students for professional and personal growth in diverse environments. LEARNING OUTCOMES: In this course, the students will be introduced to the advanced concepts of digital documentation, digital spreadsheet, database management and internet security. The objectives of this course are to :  Develop effective verbal and non-verbal communication skills, active listening, speaking, and presentation skills. Understand the importance of feedback and improve interpersonal communication.  Enhance self-awareness, self-regulation, and self-motivation. Learn time management, goal setting, and stress management techniques. Cultivate personal and professional growth mindsets.  Understand the basics of Information and Communication Technology (ICT). Gain JOB ROLE: DOMESTIC DATA ENTRY OPERATOR402 – Information Technology - Class X Page 2 of 17 proficiency in using digital tools and platforms for communication and productivity. Learn safe, responsible, and ethical use of ICT resources.  Develop an entrepreneurial mindset and understanding of business fundamentals. Learn problem-solving, critical thinking, and innovation techniques. Understand financial literacy and risk management in business.  Understand the importance of sustainable practices and environmental conservation. Learn about the green economy and green jobs. Promote sustainable development and ecofriendly initiatives.  Master advanced document creation, formatting, and management skills. Learn to use templates, styles, tables, and images effectively. Understand document collaboration and review features.  Learn advanced data analysis using Scenarios and Goal Seek, automate tasks with macros, and manage linked data across spreadsheets. Gain skills in securely sharing and reviewing spreadsheets for effective collaboration and feedback.  Learn to design, create, and manage databases. Understand data querying, reporting, and relational database concepts. Develop skills in creating forms, reports, and managing data integrity.  Understand workplace safety, health, and security protocols. Learn hazard identification, risk assessment, and emergency response planning. Promote a culture of health, safety, and well-being at the workplace. These objectives are designed to provide comprehensive skills that enhance employability, personal development, and workplace readiness. SALIENT FEATURES: This course equips students with essential skills for a Data Entry Operator role by focusing on advanced digital documentation, spreadsheet management, and database handling using LibreOffice tools. It enhances accuracy, speed, and data management capabilities while improving communication and ICT skills for efficient workplace interaction. The course promotes responsible digital practices, problem-solving, and critical thinking, ensuring readiness for datacentric tasks. Additionally, it emphasizes workplace safety, teaching health, safety, and emergency management protocols, essential for maintaining a secure and productive work environment. SCHEME OF UNITS Total Marks: 100 (Theory-50+Practical-50) This course is a planned sequence of instructions consisting of units meant for developing employability and vocational competencies of students of Class X opting for skill subject along with other subjects. The unit-wise distribution of hours and marks for class X is as follows:402 – Information Technology - Class X Page 3 of 17 CBSE | DEPARTMENT OF SKILL EDUCATION CURRICULUM FOR SESSION 2026-2027 INFORMATION TECHNOLOGY (SUB. CODE – 402) CLASS – X (SESSION 2026-2027) UNITS NO. OF HOURS for Theory and Practical MAX. MARKS for Theory and Practical PART A Employability Skills Unit 1: Communication Skills-II 10 2 Unit 2: Self-Management Skills-II 10 3 Unit 3: ICT Skills-II 10 1 Unit 4: Entrepreneurial Skills-II 15 3 Unit 5: Green Skills-II 05 1 Total 50 10 PART B SUBJECT SPECIFIC SKILLS Theory Practical Marks 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 Total 60 90 40 PART C PRACTICAL WORK Practical Examination 20 ● Digital Documentation (Advanced) using LibreOffice Writer 5 Marks ● Electronic Spreadsheet (Advanced) using LibreOffice Calc 5 Marks ● Database Management System using LibreOffice Base 10 Marks ● Viva Voce 10 Marks 10 Total 30 PART D PROJECT WORK/FIELD VISIT: Any Interdisciplinary Real World Case Study to be taken. Summarized data reports of same can be presented in base. Input should be taken using forms and output should be done using reports using base. Documentation of the case study should be presented using writer. 10 PORTFOLIO/ PRACTICAL FILE: (Portfolio should contain printouts of the practical done using Writer, Calc and Base with minimum 5 problems of each) 10 Total 20 GRAND TOTAL 200 100402 – Information Technology - Class X Page 4 of 17 DETAILED CURRICULUM/ TOPICS: Part-A: EMPLOYABILITY SKILLS S. No. Units Duration in Hours 1. Unit 1: Communication Skills-II 10 2. Unit 2: Self-management Skills-II 10 3. Unit 3: Information and Communication Technology Skills-I 10 4. Unit 4: Entrepreneurial Skills-II 15 5. Unit 5: Green Skills-II 05 TOTA 50 Note: The detailed curriculum/ topics to be covered under Part A: Employability Skills can be downloaded from CBSE website. Part-B – SUBJECT SPECIFIC SKILLS  Unit 1: Digital Documentation (Advanced)  Unit 2: Electronic Spreadsheet (Advanced)  Unit 3: Database Management System  Unit 4: Web Applications and Security Unit 1: Digital Documentation (Advanced) using LibreOffice Writer SUB UNIT LEARNING OUTCOMES THEORY PRACTICAL Chapter 1: Introduction Learn to create, update, and  Styles/ categories in Writer  List Style Categories: Open the Styles and To Styles apply various styles in Libre  Page  Paragraph Formatting window, list available style Office Writer for effective and consistent document formatting.  Character  Frame  List  Table  Styles and Formatting  Fill Format  Creating a new style  From Selection categories, and select one style from each.  Use Fill Format: Apply a style to multiple areas of your document quickly using the Fill Format tool.  Create and Update a New Style: Create a new method  Drag and Drop style from selected text and update it by method  Updating a new style  Load style from template or document. modifying its attributes.  Load a Style from a Template or Document: Import and apply a style  Applying styles. from a template or another document to your current work.  Create a New Style Using Drag-and-Drop:402 – Information Technology - Class X Page 5 of 17 SUB UNIT LEARNING OUTCOMES THEORY PRACTICAL Create a new style by dragging and dropping formatted text into the Styles and Formatting panel. Chapter 2: Working with Images Able to insert, modify, and position images and drawing objects in a document, using various methods and options for effective document layout and formatting.  Inserting an Image in a Document  Insert Image Option  Drag and Drop option  Copy and Paste method  Inserting an image by linking  Options to modify image using image toolbar, resize, crop and delete an image.  Drawing Objects  Creating drawing objects  Setting or changing its properties.  Resizing and grouping drawing objects.  Positioning image in the text.  Arrangement  Anchoring  Alignment  Text Wrapping  Insert an Image: Insert an image into a document using options such as Insert Image, Drag and Drop, Copy and Paste, and linking.  Modify an Image: Use the image toolbar to modify an image by resizing, cropping, and deleting it.  Create Drawing Objects: Create various drawing objects within your document.  Set or Change Drawing Object Properties: Adjust the properties of drawing objects, including color, line style, and fill.  Resize and Group Drawing Objects: Resize individual drawing objects and group multiple objects together for better document organization.  Position the Image in the Text: Adjust the image's position in the text using arrangement, anchoring, alignment, and text wrapping options. Chapter 3: Advanced Features of Writer Acquire skills in creating, customizing, and managing a Table of Contents, using and editing templates, and tracking and reviewing changes in  Table of contents  Hierarchy of headings  Creating a Table of Content (ToC)  Customization of Table of Contents(ToC)  Maintaining a Table of Contents(ToC)  Create a Table of Contents (ToC): Generate and customize a Table of Contents in a document.  Maintain a Table of Contents: Update or delete the Table of Contents  Use Templates: Create,402 – Information Technology - Class X Page 6 of 17 SUB UNIT LEARNING OUTCOMES THEORY PRACTICAL documents effectively.  Updating ToC  Deleting ToC  Using templates  Creating a Template  Using In-built/Saved Templates  Using Online Templates  Importing a Template  Editing a Template  Moving a Template  Exporting a Template  Applying Templates to a Blank Document  Track Changes Feature  Preparing a Document for Review  Recording Changes  Accepting and Rejecting Changes  Adding Comments  Deleting Comments  Comparing Documents import, and apply templates to a blank document, using in-built, saved, or online templates.  Edit a Template: Modify, move, and export an existing template.  Track Changes: Prepare a document for review by recording, accepting, or rejecting changes, and manage comments by adding or deleting them.  Compare Documents: Compare two versions of a document to identify and review differences. Unit 2: Electronic Spreadsheet (Advanced) using LibreOffice Calc SUB UNIT LEARNING OUTCOMES THEORY PRACTICAL Chapter 4: Analyse data using scenario s and goal seek Learn skills in consolidating data, using groups and subtotals, performing whatif analysis and scenarios, and utilizing the Goal Seek tool for decision-making.  Consolidating Data  Groups and Subtotals  What-if Scenarios  What-if Analysis Tool  Goal Seek  Use Consolidating Data: Aggregate data from multiple sources into a single summary.  Create Subtotals: Apply subtotals to data groups to summarize and analyze information.  Use “What-If” Scenarios: Create and analyze different scenarios to forecast outcomes based on varying inputs.  Use “What-If” Tools: Use tools like Scenario Manager for detailed what-if analyses.  Use Goal Seek and Solver: Use Goal Seek to find specific input values needed to achieve a402 – Information Technology - Class X Page 7 of 17 SUB UNIT LEARNING OUTCOMES THEORY PRACTICAL desired result, and apply Solver for more complex problems. Chapter 5: Using Macros in Spreadsh eet Develop skills in recording, running, creating, and organizing macros, and using them as functions for document automation.  Recording a Macro  Running a Macro  Creating and Organising a Simple Macro  Macro as a Function  Demonstrate the Use of a Macro Recorder: Record a macro to automate repetitive tasks.  Create a Simple Macro: Develop a basic macro to perform a specific function.  Use a Macro: Execute an existing macro to automate tasks in a document.  Pass Arguments to a Macro: Provide arguments to a macro to customize its behavior.  Pass the Arguments as Values: Supply values as arguments to a macro for dynamic operation.  Write Macros as Built-in Functions: Create macros that function similarly to built-in functions for enhanced functionality.  Access Cells Directly: Write macros to directly manipulate cell data in spreadsheets.  Sort Columns Using a Macro: Develop and use a macro to sort columns in a spreadsheet. Chapter 6: Linking Spreadsh eet Data Learn to set up multiple sheets, create references and hyperlinks within and across documents, and link to external and registered data sources. • Setting up multiple sheets. • Creating reference to other sheets by using keyboard and mouse. • Creating reference to another document by using keyboard and mouse. • Hyperlinks to the Sheet  Relative and Absolute Hyperlinks  Creating Hyperlinks  Setup Multiple Sheets: Insert and organize new sheets within a workbook.  Create References to Other Sheets: Use keyboard and mouse to create references between different sheets in a workbook.  Create References to Other Documents: Use keyboard and mouse to link data from one document to another.  Create, Edit, and Remove Hyperlinks: Add, modify, and delete hyperlinks to sheets within a workbook.  Link to External Data: Connect and import data from external sources into your document.  Link to Registered Data Sources: Establish links to registered data sources for data integration.402 – Information Technology - Class X Page 8 of 17 SUB UNIT LEARNING OUTCOMES THEORY PRACTICAL  Editing a Hyperlink  Linking to External Data  Linking to Registered Data Sources Chapter Develop the • Sharing Spreadsheet • Opening and saving a shared spreadsheet. • Recording changes. • Add, Edit and Format the comments. • Reviewing Changes – View, Accept or Reject Changes • Merging and comparing.  Set Up a Spreadsheet for Sharing: Configure a spreadsheet to enable sharing with others.  Open and Save a Shared Spreadsheet: Access and save changes to a spreadsheet that has been shared with you.  Record Changes: Track modifications made to the spreadsheet.  Add, Edit, and Format Comments: Insert, modify, and format comments within the spreadsheet.  Review Changes: View, accept, or reject changes made by others in the shared spreadsheet.  Merge and Compare Sheets: Combine and compare different sheets to integrate data effectively. 7: ability to share, Share and Review a Spreadsh eet open, and save shared spreadsheets, track and review changes, and handle comments and merging for effective collaboration.402 – Information Technology - Class X Page 9 of 17 Unit 3: Database Management System using LibreOffice Base SUB UNIT LEARNING OUTCOMES THEORY PRACTICAL Chapter 8: Introduction to Database Managemen t System Understand data and information concepts, the advantages of databases, • Data and Information • Databases and DBMS • Advantages of database,  Identify Data and Information: Distinguish between data and information within a database context.  Identify Fields, Records, and Tables: Recognize and describe fields, records, and tables in a database.  Prepare a Sample Table: Create a sample table with standard fields to illustrate database structure.  Identify Different Types of Data Models: Identify and describe various data models such as hierarchical, network, and relational.  Different Types of Keys: Recognize and explain different types of keys used in databases, such as primary and foreign keys.  Identify Different Objects of RDBMS: Identify and describe different objects in a relational database management system (RDBMS), including tables, queries, and forms. various data models and key terminology and • Data Models  Hierarchical Data Model objects of relational  Network Data Model database systems.  Relational Data Model • Relational database Model  RDBS Terminology  Objects of an RDBMS Chapter 9: Starting with LibreOffice Base Learn to navigate LibreOffice Base, manage data types, create and save tables using various methods, set primary keys, and perform data entry, editing, sorting, and record deletion. • Introduction to LibreOffice Base • Data types • Starting with LibreOffice • User Interface Of LibreOffice Base • Opening a Database • Creating a Table  Start LibreOffice Base and Observe the Main Window: Launch LibreOffice Base and familiarize yourself with the main window's components.  Create a Sample Table Using Wizard: Use the wizard to create a sample table in any category.  Create Different Tables from Available List: Practice creating various tables by selecting fields from the available options.  Assign Data Types and Set Primary Key: Define data types for fields and set a primary key for the table.  Edit the Table in Design View: Modify the table structure using the design view.  Enter Data in the Fields: Input  Using a Wizard  Using design view, • Setting primary key • Saving a Table402 – Information Technology - Class X Page 10 of 17 SUB UNIT LEARNING OUTCOMES THEORY PRACTICAL • Entering data data into the fields of your table.  Delete Records from Table: Remove records from the table as needed.  Arrange Data in Ascending or Descending Order: Sort the table data in ascending or descending order into table • Navigating through the table • Editing Data • Deleting Records from Table • Sorting Data in the Table Chapter 10: Working with Multiple Tables Develop skills in editing and deleting tables, creating and • Editing and Deleting tables, • Relationships between tables  Insert Data in the Table: Add new data entries to a table.  Edit Records in the Table: Modify existing records within the table.  Delete Records from Table: Remove specific records from the table.  Sort Data in the Table: Arrange data in ascending or descending order within the table.  Create and Edit Relationships: Establish and modify relationships between tables, including one-to-one, one-tomany, and many-to-many.  Enter Various Field Properties: Set and adjust different properties for fields in the table. managing table • Types of relationships, and Relationships– ensuring one to one, one to referential many, many to integrity. many • Advantages of Relating Tables in a Database • Creating Relationships between Tables • Referential Integrity Chapter 11: Acquire skills in • Queries • Query creation using wizard • Creation of query using design view • Editing a query, • Working with Numerical Data  Prepare a Query for Given Criteria: Create a query based on specified criteria.  Create a Query Using Wizard and Design View: Demonstrate how to generate a query using both the wizard and design view.  Edit a Query: Modify an existing query to update its criteria or structure.  Apply Various Criteria in a Query: Demonstrate applying different criteria in a query, including single field, multiple fields, and wildcard searches.  Perform Calculations Using Query in Base: Execute Queries in Base creating and editing queries using both wizards and design view, and working with numerical data in queries.