CBSE Class 10 IT 402 syllabus 2022-23 | Information Technology code 402 class 10 syllabus 2022-23 PDF

Class 10 IT 402 syllabus 2022-23 PDF has been officially released by CBSE. Here are all the details for the Information Technology syllabus Class 10 CBSE 2022-23 session.

Here we will discuss the latest Information Technology syllabus for class 10 CBSE 2022-23 session. CBSE has made some big changes in the latest syllabus and it has been reduced a lot. So it is important for us to note every detail of the new class 10 IT syllabus and prepare accordingly.

Download link for IT 402 class 10 syllabus PDF is given at the end of the post. Along with the latest book PDF officially released by CBSE for this new session.

Class 10 IT 402 syllabus 2022-23

Class 10 IT 402 syllabus 2022-23

The Class 10 IT 402 syllabus 2022-23 is divided into two parts –

Part A – Employability Skills

Part B – Subject Specific Skills.

There are 5 units in Part A, and 4 units in Part B. But we don’t have to study all of these for our board exams. I will explain to you clearly what you need to study.

Part A – Employability Skills

UNITSMAX. MARKS
Unit 1: Communication Skills-II*
Unit 2: Self-Management Skills-II3
Unit 3: ICT Skills-II3
Unit 4: Entrepreneurial Skills-II5
Unit 5: Green Skills-II*
Total10

Unit 1 – Communication Skills and Unit 5 – Green Skills are not to be assessed in Theory Exams. These units are to be assessed through Internal Assessment/ Student Activities.

Part B – Subject Specific Skills.

UNITSMAX. MARKS
Unit 1: Digital Documentation8
Unit 2: Electronic Spreadsheet10
Unit 3: Database Management System12
Unit 4: Web Applications and Security10
Total40

There are some topics within these units of section B, which are specifically highlighted in the official syllabus PDF released by CBSE. Have a close look over the Class 10 IT 402 syllabus 2022-23 in the official PDF itself.

IT 402 class 10 syllabus PDF

NOTES – CLASS 10 IT 402 NOTES PDF

Information Technology code 402 class 10 syllabus [Removed Topics]

Detailed List of removed topics from Information Technology code 402 class 10 syllabus.

In UNIT 1: DIGITAL DOCUMENTATION (ADVANCED) – (Note: * To be assessed in Practicals only. No question shall be asked from this portion in Theory Exams)

LEARNING
OUTCOMES
THEORYPRACTICAL
Create and Apply
Styles in the
document
• Styles/ categories in Word Processor
• Using the Styles and Formatting window.*
• Using Fill Format.*
• Creating and updating new styles from a selection
• Load style from a template or another document.
• Creating a new style using drag-and-drop.*
• Applying styles.
• List style categories. Select the style from the Styles and Formatting window.
• Use Fill Format to apply a style to many different areas quickly.
• Create and update a new style from a selection.
• Load a style from a template or another document.
• Create a new style using drag and drop.
Insert and use
images in the document
• Options to insert images to document from various sources.
• Options to modify, resize, crop, and delete an image.
• Creating drawing objects, setting, or changing their properties. Resizing and grouping drawing objects.
• Positioning image in the text.
• Insert an image to document from various sources.
• Modify, resize, crop, and delete an image.
• Create drawing objects
• Set or change the properties of a drawing object
• Resize and group drawing objects
• Position the image in the text
Create and use
the template
• Templates.
• Using predefined templates.
• Creating a template.*
• Set up a custom template as the default.
• Editing a template
• Changing to a different template.
• Updating a Document*
• Create a template.
• Use predefined templates.
• Set up a custom default template.
• Update a document.
• Change to a different template.
• Use the Template.
• Update the document and save the changes.
Create and
customize the table of
contents
• Table of contents. Hierarchy of headings. Customization of
the table of contents.
• Character styles. Maintaining a table of contents.
• Create a table of contents. Define a hierarchy of headings.
• Customize a table of contents.
• Apply character styles. Maintain a table of contents.
Implement Mail
Merge
• Advance concept of mail merge in word processing,
• Creating the main document,
• Creating the data source,
• Entering data in the fields,
• Merging the data source with the main document,
• Editing individual documents.*
• Printing a letter and its address label.
• Demonstrate to print the label using
mail merge, do the following to achieve
• Create the main document,
• Create the data source,
• Enter data in the fields,
• Merge the data source with the main document,
• Edit individual documents,
• Print the letter and address label

In UNIT 2: ELECTRONIC SPREADSHEET (ADVANCED)

LEARNING
OUTCOMES
THEORYPRACTICAL
Analyze data using
scenarios and goal
seek.
• Using consolidating data. Creating subtotals.
• Using “what if” scenarios.
• Using “what if” tools
• Using goal seek and solver.
• Use consolidating data and Create subtotals
• Use “what if” scenarios Use “what if” tools
• Use goal seek and solver
Link data and
spreadsheets
• Setting up multiple sheets. Creating references to other sheets by using a keyboard and mouse.
• Creating references to another document by using a keyboard and mouse.*
• Relative and absolute hyperlinks
• Hyperlinks to the sheet.
o Linking to external data.
o Linking to registered data sources.
• Setup multiple sheets by inserting new sheets.
• Create references to other sheets by using a keyboard and mouse.
• Create references to other documents by using a keyboard and mouse.
• Create, Edit, and Remove hyperlinks to the sheet.
• Link to external data.
• Link to the registered data source.
Share and review a
spreadsheet
• Setting up a spreadsheet for sharing.*
• 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.
• Open and save a shared spreadsheet.
• Record changes.
• Add, Edit, and Format the comments.
• Review changes – view, accept or reject changes.
• Merge and compare sheets.
Create and Use
Macros in
spreadsheet
• Using the macro recorder. Creating a simple macro. Using a macro as a function.
• Discuss Passing arguments to a macro.
• Discuss Passing the arguments’ area values.
• Discuss Macros to work with built-in functions.
• Accessing cells directly.
• Sorting the columns using macro.
• Demonstrate the use of a macro recorder.
• Create a simple macro.
• Use a macro
• Access cells directly
• Using a macro.
• Sort the columns using macro.

(Note: * To be assessed in Practicals only. No question shall be asked from this portion
in Theory Exams)

In UNIT 3: DATABASE MANAGEMENT SYSTEM

LEARNING
OUTCOMES
THEORYPRACTICAL
Appreciate the concept of a Database Management System• Concept and examples of data and information,
• Concept of the database,
• Advantages of the database,
• Features of the database,
• Concept and examples of Relational database,
• Concept and examples of field, record, table, database,
• Concept and examples of Primary key, composite primary key, foreign key,
• Relational Database management system
(RDBMS) software.
• Identify the data and information,
• Identify the field, record, and table in the database,
• Prepare the sample table with some standard fields.
• Assign the primary key to the field,
• Identify the primary key, composite primary key, and foreign key.
Create and edit
tables using
wizard and SQL
commands
• Introduction to an RDBMS
• Database objects – tables, queries, forms, and reports of the database,
• Terms in database – table, field, record,
• Steps to create a table using table wizard*
• Data types in the database.,
• Option to set primary key Table Data View dialog box
• Start the RDBMS and observe the parts of the main window,
• Identify the database objects Create the sample table in any
category using wizard, Practice creating different tables from the available list, and choose fields from the available fields.
• Assign data types of field, Set primary key,
• Edit the table in design view, Enter the data in the fields.
• Create and edit table using DDL Commands
Perform operations
on table
• Inserting data in the table,
• Editing records in the table,
• Deleting records from the table,
• Sorting data in the table, Referential integrity,
• Creating and editing relationships – one to one, one to many, many to many
• Field properties(default, required, and format)
Demonstrate to:
• Insert data in the table, Edit records
in the table, Delete records from
table, Sort data in the table,
• Create and edit relationships
• one to one, one to many, many to many,
• Enter various field properties.
Retrieve data using
query
• Database query,
• Defining query,
• Query creation using wizard,*
• Creation of query using design view,*
• Editing a query,
• Applying criteria in query – single field, multiple fields, using a wildcard,
• Performing calculations,
• Grouping of data,
• Structured Query Language (SQL).
• Introduction to DDL (purpose of- Create database, Create table, Alter the table and Drop table)
• Prepare a query for given criteria,
• Demonstrate to create a query using wizard, and using design view,
• Edit a query,
• Demonstrate to apply various criteria in query – single field, multiple fields, using a wild card,
• Performing calculations using the query in Base,
• Demonstrate to group data,
• Use basic SQL commands,
Create Forms and
Reports using wizard
• Introduction to Forms in DBMS.
• Creating a form using wizard,*
• Steps to create form using
Form Wizard, *
• Options to enter or remove
data from forms
• Modifying form,
• Changing label, background,
• Searching records using Form,
• Inserting and deleting a record using Form View,
• Concept of Report in Base,
• Creating Report using wizard, *
• Steps to create a Report using Wizard. *
• Insert date and time
• Illustrate the various steps to create
Form using Form Wizard,
• Enter or remove data from Forms,
• Demonstrate to modify Forms,
• Demonstrate to change label,
background,
• Search record using Form,
• Insert and delete record using
Form View,
• Illustrate the various steps to create
Report using Report Wizard,
• Demonstrate various examples of
Report.

In UNIT 4: WEB APPLICATIONS AND SECURITY

LEARNING
OUTCOMES
THEORYPRACTICAL
Working with
Accessibility
Options.
• Understand various types of an impairment that impacts computer usage
• Computer Accessibility Dialog box and its tabs
• Serial Keys
• Illustrate use of various options under Computer Accessibility like Keyboard, mouse, sound, display setting serial keys, cursor options
• use of toggle keys, filter keys, sticky keys, sound sentry, show sounds, etc.
Understand
Networking
Fundamentals
• Network and its types.
• Client-Server Architecture, Peer-to-peer (P2P) Architecture,
• internet, World Wide Web,
• benefits of networking
• internet, getting access to the internet,
• internet terminology
• Some of the commonly used Internet connectivity options
• Data transfer on the Internet
• Identify applications of the Internet
• comparing various internet technologies
• identifying types of networks and selecting an internet
Introduction to
Instant Messaging
• learn key features of instant messaging
• Creating an instant messaging account
• Launching Google Talk*
• Signing in to your Google Talk
Account*
• Illustrate steps to create an instant messaging account
• Signing In to your Google Talk Account
Chatting with a
Contact –Google Talk
• learn to chat with a contact that is already added to your contact list.
• sending text chat messages instantly by double-clicking on a contact.
• general rules and etiquette to be followed while chatting.
• chatting on various types of
messengers
• Illustrate chat with contact and send messages,
• chatting with various messenger services
Creating and
Publishing Web
Pages – Blog
• learn and appreciate a blog and its creation with the help of some blog providers*
• set up title and other parameters in a blog posting comments
• using offline blog editors
• Illustrate Blog Creation and
setting various parameters in it
Using Offline Blog
Editors
Concept to create blogs using a
blog application and publish the
blog whenever internet
connectivity is available.
• Demonstration on how to create blogs using a blog application offline.
• posting messages in an offline application
• Publish the blog whenever internet connectivity is available using various examples
Online Transaction• concept of e-commerce and
various online applications
• importance of secure passwords
• Illustration of online shopping using various eCommerce sites
• Demonstration of securing passwords for online transactions.
Internet Security• Need for internet security
• Cyber threats like phishing, email- spoofing, char spoofing, etc.
• best practices for internet security and secure passwords
• concept of browser, cookies, backup, antivirus
• clearing data in browsers
• illustration of internet security threats through various ways
• cyber security tips
• tips for secure passwords
• demonstration of strong
passwords using various websites.
• clearing data stored in the browser applications.
Maintain workplace safety• Basic safety rules to follow at
workplace – fire safety,
• Falls and slips, Electrical safety,
Use of first aid.
• Case Studies of hazardous
situations.
• Practice following basic safety rules at the workplace to prevent accidents and protect workers – Fire safety,
• Falls and slips, Electrical safety, Use of first aid.
Prevent Accidents
and Emergencies
• Accidents and emergencies,
• Types of Accidents,
• Handling Accidents
• Types of Emergencies.
• Illustrate to handle accidents at
workplace,
• Demonstrate to follow
an evacuation plan and procedure
in case of an emergency.
Protect Health
and Safety at
work
• Hazards and sources of hazards,
• General evacuation procedures,
• Healthy living.
• Identify hazards and sources of hazards,
• identify the problems at a workplace that could cause accidents,
• Practice the general evacuation procedures in case of an emergency.

So these were all the details regarding Class 10 IT 402 syllabus 2022-23. Prepare for your board exams according to this, and ace the Information Technology Subject.

If you find this post helpful then consider sharing this Class 10 IT 402 syllabus 2022-23 with your friends.

Bookmark this Class 10 Information Technology syllabus and read this whenever you need it.

Leave a Comment