Class 10 IT syllabus

Download as pdf or txt
Download as pdf or txt
You are on page 1of 13

CBSE | DEPARTMENT OF SKILL EDUCATION

CURRICULUM FOR SESSION 2024-2025


INFORMATION TECHNOLOGY (SUB. CODE – 402)
JOB ROLE: DOMESTIC DATA ENTRY OPERATOR
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 vice-
versa. 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

402 – Information Technology - Class X Page 1 of 13


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 eco-
friendly 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 data-
centric 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 2 of 13


CBSE | DEPARTMENT OF SKILL EDUCATION
CURRICULUM FOR SESSION 2024-2025
INFORMATION TECHNOLOGY (SUB. CODE – 402)
CLASS – X (SESSION 2024-2025)

NO. OF HOURS MAX. MARKS


UNITS for Theory and for Theory and
Practical Practical
Employability Skills
Unit 1: Communication Skills-II 10 2
PART A

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
SUBJECT SPECIFIC SKILLS Theory Practical Marks
Unit 1: Digital Documentation (Advanced)
12 18 8
using LibreOffice Writer
PART B

Unit 2: Electronic Spreadsheet (Advanced)


15 23 10
using LibreOffice Calc
Unit 3: Database Management System
18 27 12
using LibreOffice Base
Unit 4: Maintain Healthy, Safe and Secure
15 22 10
Working Environment
Total 60 90 40

402 – Information Technology - Class X Page 3 of 13


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-II 10
4. Unit 4: Entrepreneurial Skills-II 15
5. Unit 5: Green Skills-II 05
TOTAL 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

LEARNING
SUB UNIT THEORY PRACTICAL
OUTCOMES
Chapter 1: Learn to create,  Styles/ categories in  List Style Categories:
Introduction update, and Writer Open the Styles and
To Styles apply various  Page Formatting window, list
styles in Libre  Paragraph available style
Office Writer for  Character categories, and select
effective and  Frame one style from each.
consistent  List  Use Fill Format: Apply a
document  Table style to multiple areas of
formatting.  Styles and Formatting your document quickly
 Fill Format using the Fill Format tool.
 Creating a new style  Create and Update a
 From Selection New Style: Create a new
method style from selected text
 Drag and Drop and update it by
method modifying its attributes.
 Updating a new style  Load a Style from a
 Load style from Template or Document:
template or document. Import and apply a style
from a template or
 Applying styles. another document to
your current work.
 Create a New Style
Using Drag-and-Drop:
402 – Information Technology - Class X Page 4 of 13
LEARNING
SUB UNIT THEORY PRACTICAL
OUTCOMES
Create a new style by
dragging and dropping
formatted text into the
Styles and Formatting
panel.
Chapter 2: Able to insert,  Inserting an Image in a  Insert an Image: Insert
Working with modify, and Document an image into a
Images position images  Insert Image document using options
and drawing Option such as Insert Image,
objects in a  Drag and Drop Drag and Drop, Copy
document, using option and Paste, and linking.
various methods  Copy and Paste  Modify an Image: Use
and options for method the image toolbar to
effective  Inserting an image modify an image by
document layout by linking resizing, cropping, and
and formatting.  Options to modify deleting it.
image using image  Create Drawing
toolbar, resize, crop Objects: Create various
and delete an image. drawing objects within
 Drawing Objects your document.
 Creating drawing  Set or Change Drawing
objects Object Properties:
 Setting or changing its Adjust the properties of
properties. drawing objects,
 Resizing and grouping including color, line style,
drawing objects. and fill.
 Positioning image in  Resize and Group
the text. Drawing Objects:
 Arrangement Resize individual drawing
 Anchoring objects and group
 Alignment multiple objects together
 Text Wrapping 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: Acquire skills in  Table of contents  Create a Table of
Advanced creating, Contents (ToC):
Features of
 Hierarchy of headings
customizing, Generate and customize
Writer and managing a  Creating a Table of a Table of Contents in a
Table of Content (ToC) document.
Contents, using  Customization of  Maintain a Table of
and editing Table of Contents: Update or
templates, and Contents(ToC) delete the Table of
tracking and Contents
 Maintaining a Table of
reviewing  Use Templates: Create,
changes in Contents(ToC)
402 – Information Technology - Class X Page 5 of 13
LEARNING
SUB UNIT THEORY PRACTICAL
OUTCOMES
documents  Updating ToC import, and apply
effectively. templates to a blank
 Deleting ToC
document, using in-built,
 Using templates saved, or online
 Creating a Template templates.
 Using In-built/Saved  Edit a Template: Modify,
move, and export an
Templates
existing template.
 Using Online  Track Changes: Prepare
Templates a document for review by
 Importing a Template recording, accepting, or
rejecting changes, and
 Editing a Template
manage comments by
 Moving a Template adding or deleting them.
 Exporting a Template  Compare Documents:
 Applying Templates to Compare two versions of
a document to identify
a Blank Document
and review differences.
 Track Changes
Feature
 Preparing a Document
for Review
 Recording Changes
 Accepting and
Rejecting Changes
 Adding Comments
 Deleting Comments
 Comparing Documents

Unit 2: Electronic Spreadsheet (Advanced) using LibreOffice Calc


SUB LEARNING
THEORY PRACTICAL
UNIT OUTCOMES
Chapter Learn skills in  Use Consolidating Data:
4:  Consolidating Aggregate data from multiple
consolidating
Analyse Data sources into a single summary.
data, using
data
groups and  Groups and  Create Subtotals: Apply subtotals
using to data groups to summarize and
subtotals, Subtotals
scenario analyze information.
s and performing what-  What-if
 Use “What-If” Scenarios: Create
goal seek if analysis and Scenarios
and analyze different scenarios to
scenarios, and  What-if forecast outcomes based on
utilizing the Goal Analysis Tool varying inputs.
Seek tool for  Goal Seek  Use “What-If” Tools: Use tools
decision-making. like Scenario Manager for detailed
what-if analyses.
 Use Goal Seek and Solver: Use
Goal Seek to find specific input
values needed to achieve a
402 – Information Technology - Class X Page 6 of 13
SUB LEARNING
THEORY PRACTICAL
UNIT OUTCOMES
desired result, and apply Solver for
more complex problems.
Chapter Develop skills in  Demonstrate the Use of a Macro
5:  Recording a Recorder: Record a macro to
recording,
Using Macro automate repetitive tasks.
running,
Macros in  Create a Simple Macro: Develop
creating, and  Running a
Spreadsh a basic macro to perform a
organizing Macro
eet specific function.
macros, and  Use a Macro: Execute an existing
 Creating and
using them as macro to automate tasks in a
Organising a
functions for document.
Simple Macro
document  Pass Arguments to a Macro:
automation.  Macro as a Provide arguments to a macro to
Function 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 Learn to set up • Setting up  Setup Multiple Sheets: Insert and
6: multiple sheets, multiple sheets. organize new sheets within a
Linking create • Creating workbook.
Spreadsh
references and reference to other  Create References to Other
eet Data Sheets: Use keyboard and mouse
hyperlinks within sheets by using
to create references between
and across keyboard and
different sheets in a workbook.
mouse.
documents, and  Create References to Other
link to external • Creating Documents: Use keyboard and
and registered reference to mouse to link data from one
data sources. another document document to another.
by using keyboard  Create, Edit, and Remove
and mouse. Hyperlinks: Add, modify, and
delete hyperlinks to sheets within
• Hyperlinks to
a workbook.
the Sheet
 Link to External Data: Connect
 Relative and and import data from external
Absolute sources into your document.
Hyperlinks  Link to Registered Data
 Creating Sources: Establish links to
registered data sources for data
Hyperlinks
integration.
402 – Information Technology - Class X Page 7 of 13
SUB LEARNING
THEORY PRACTICAL
UNIT OUTCOMES
 Editing a
Hyperlink
 Linking to
External Data
 Linking to
Registered Data
Sources

Chapter Develop the • Sharing  Set Up a Spreadsheet for


7: ability to share, Spreadsheet Sharing: Configure a spreadsheet
Share open, and save to enable sharing with others.
• Opening and
and
shared  Open and Save a Shared
Review a saving a shared Spreadsheet: Access and save
Spreadsh spreadsheets, spreadsheet. changes to a spreadsheet that has
eet track and review been shared with you.
• Recording
changes, and  Record Changes: Track
changes.
handle modifications made to the
• Add, Edit and
comments and spreadsheet.
Format the  Add, Edit, and Format
merging for
comments. Comments: Insert, modify, and
effective
• Reviewing format comments within the
collaboration.
Changes – View, spreadsheet.
Accept or Reject  Review Changes: View, accept,
Changes or reject changes made by others
in the shared spreadsheet.
• Merging and
 Merge and Compare Sheets:
comparing. Combine and compare different
sheets to integrate data effectively.

402 – Information Technology - Class X Page 8 of 13


Unit 3: Database Management System using LibreOffice Base
LEARNING
SUB UNIT THEORY PRACTICAL
OUTCOMES
Chapter 8: Understand data • Data and  Identify Data and Information:
Introduction and information Information Distinguish between data and
to Database • Databases and information within a database
concepts, the DBMS
Managemen context.
t System advantages of • Advantages of  Identify Fields, Records, and
databases, database, Tables: Recognize and describe
various data • Data Models fields, records, and tables in a
models and key database.
 Hierarchical
terminology and Data Model  Prepare a Sample Table:
objects of  Network Data Create a sample table with
relational Model standard fields to illustrate
database database structure.
 Relational Data
Model
 Identify Different Types of
systems.
Data Models: Identify and
• Relational describe various data models
database Model such as hierarchical, network,
 RDBS and relational.
Terminology  Different Types of Keys:
 Objects of an Recognize and explain different
RDBMS 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.
Chapter 9: Learn to navigate • Introduction to  Start LibreOffice Base and
Starting LibreOffice Base, LibreOffice Base Observe the Main Window:
with manage data Launch LibreOffice Base and
• Data types
LibreOffice
types, create and familiarize yourself with the main
Base • Starting with window's components.
save tables using LibreOffice  Create a Sample Table Using
various methods, Wizard: Use the wizard to
• User Interface
set primary keys, create a sample table in any
Of LibreOffice
and perform data category.
Base
entry, editing,  Create Different Tables from
• Opening a Available List: Practice creating
sorting, and Database
record deletion. various tables by selecting fields
• Creating a from the available options.
Table  Assign Data Types and Set
 Using a Wizard Primary Key: Define data types
 Using design for fields and set a primary key
view, for the table.
• Setting primary
 Edit the Table in Design View:
Modify the table structure using
key the design view.
• Saving a Table  Enter Data in the Fields: Input
402 – Information Technology - Class X Page 9 of 13
LEARNING
SUB UNIT THEORY PRACTICAL
OUTCOMES
• Entering data data into the fields of your table.
into table  Delete Records from Table:
Remove records from the table
• Navigating as needed.
through the table  Arrange Data in Ascending or
• Editing Data Descending Order: Sort the
table data in ascending or
• Deleting descending order
Records from
Table
• Sorting Data in
the Table
Chapter 10: Develop skills in • Editing and  Insert Data in the Table: Add
Working with editing and Deleting tables, new data entries to a table.
Multiple deleting tables, • Relationships  Edit Records in the Table:
Tables between tables Modify existing records within
creating and
the table.
managing table • Types of
 Delete Records from Table:
relationships, and Relationships–
Remove specific records from
ensuring one to one, one to the table.
referential many, many to  Sort Data in the Table: Arrange
integrity. many data in ascending or descending
• Advantages of order within the table.
Relating Tables in  Create and Edit Relationships:
a Database Establish and modify
relationships between tables,
• Creating
including one-to-one, one-to-
Relationships many, and many-to-many.
between Tables  Enter Various Field
• Referential Properties: Set and adjust
Integrity different properties for fields in
the table.
Chapter 11: Acquire skills in • Queries  Prepare a Query for Given
Queries in creating and • Query creation Criteria: Create a query based
Base editing queries using wizard on specified criteria.
using both • Creation of  Create a Query Using Wizard
query using and Design View: Demonstrate
wizards and
design view how to generate a query using
design view, and both the wizard and design view.
working with • Editing a query,
 Edit a Query: Modify an existing
numerical data in • Working with query to update its criteria or
queries. Numerical Data 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

402 – Information Technology - Class X Page 10 of 13


LEARNING
SUB UNIT THEORY PRACTICAL
OUTCOMES
calculations within a query in
LibreOffice Base.
Chapter 12: Able to create • Forms in  Create a Form Using Form
Forms and and modify forms BASE. Wizard: Generate a form by
Reports and reports in • Creating form following the steps in the Form
LibreOffice Base, using wizard, Wizard.
• Modifying a  Enter or Remove Data from
use the Form
Forms: Input new data or delete
Controls Toolbar, Form
existing data using forms.
and insert • Form Controls  Modify Forms: Demonstrate
additional Toolbar how to adjust and customize
controls, titles, • Report in Base forms.
headings, and • Inserting other  Change Label and
date/time controls in report Background: Modify the label
• Inserting Titles text and background color or
elements in
& Headings design of a form.
reports.
• Inserting Date  Search Records Using a Form:
& Time Use the form to find specific
records based on search criteria.

 Insert and Delete Records
Using Form View: Add new
records or remove existing ones
through the Form View.
 Create a Report Using Report
Wizard: Illustrate the steps to
generate a report using the
Report Wizard.
 Demonstrate Various Report
Examples: Provide examples of
different types of reports created
using the Report Wizard.

Unit 4: Maintain Healthy, Safe and Secure Working Environment


LEARNING
SUB UNIT THEORY PRACTICAL
OUTCOMES
Chapter 13. Understand • Introduction to Health, Safety,  Practice Basic
Health, workplace and Security At Workplace Safety Rules:
Safety and • Policies and Procedures for Implement fire
Security at
health, safety,
Healthy, Safety and Security safety measures,
Workplace and security
• Reasons for Health, Safety, prevent falls and
policies, identify and Security Programs or slips, ensure
various Policies in the Workplace electrical safety,
hazards, and • Workplace Safety Hazards and apply first aid
learn how to • Physical Hazards procedures to
manage risks • Falling Off Heights, Slipping protect workers and
and maintain a and Tripping prevent accidents.
• Electrical Hazards
safe working
• Fire Hazards
environment. • Health Hazards

402 – Information Technology - Class X Page 11 of 13


LEARNING
SUB UNIT THEORY PRACTICAL
OUTCOMES
• Potential Sources of Hazards
in an Organisation
• Hazards using Computers
• Handling Office Equipment
• Handling Objects
• Stress at Work
• Working Environment
• Hazard Control
• Safety Guidelines Checklist
Chapter 14. Learn about air • Introduction  Illustrate Handling
Workplace and water • Air and Water Quality Accidents at
Quality Monitoring Process Workplace:
Measures
quality
monitoring, • Guidelines for Clean Air and Demonstrate the
Clean Water steps to manage
office
• Importance of Cleanliness at and respond to
ergonomics, accidents in the
Workplace
health and • Office Ergonomics workplace.
safety • Computer Health and Safety  Demonstrate
guidelines for Tips Following
computer use, • Musculoskeletal Problems: Evacuation Plan:
and methods to Occupational Overuse Show how to
Syndrome, effectively follow
reduce risks
Strain in Legs and Feet, Eye the evacuation plan
associated with and procedures
Strain,
musculoskeletal during an
• To reduce the risks of visual
problems and problems: emergency.
other work- Headaches, Obesity, Stress
related issues. Disorders, Injuries from Laptop
Use, Sleeping Problems
• Health and Safety
Requirements for Computer
Workplace
• Cautions while Working on the
Computer
Chapter 15. Able to identify • Accident and Emergencies:  Identify Hazards
Prevent and handle  Notice and Correctly Identify and Sources of
Accidents accidents and Accidents and Emergencies Hazards:
and emergencies,  Get help Promptly and in the Recognize potential
Emergencie Most Suitable Way
follow company hazards and their
s
policies,  Follow Company Policies and sources in the
manage Procedures for Preventing workplace.
different types Further Injury While Waiting for  Identify Problems
of accidents and Help to Arrive at Workplace:
emergencies,  Act within the Limits of your Assess workplace
and apply fire Responsibility and Authority issues that could
safety and first when Accidents and lead to accidents.
aid procedures Emergencies Arise,  Practice General
effectively.  Promptly Follow Instructions Evacuation
given by Senior Staff and the Procedures:
Emergency Services Execute evacuation

402 – Information Technology - Class X Page 12 of 13


LEARNING
SUB UNIT THEORY PRACTICAL
OUTCOMES
• Types of Accidents procedures in
 Trip and Fall simulated
 Slip and Fall emergency
 Injuries caused due to situations.
Escalators or Elevators (or lifts)
 Accidents due to Falling of
Goods
 Accidents due to Moving
Objects
• Handling Accidents:
 Attend to the Injured Person
Immediately,
 Inform your Supervisor
 Assist your Supervisor
• Types of Emergencies
 First Aid,
 Electrical Safety
 Evacuation
• General Evacuation
Procedures
• Fire Hazards in the Workplace
• Fire Prevention
• Identification of Material and
Ignition Sources
• First Aid for Electrical
Emergencies
• Electrical Rescue Techniques

402 – Information Technology - Class X Page 13 of 13

You might also like