Split up syllabus Information Technology 402 Class 10 A Comprehensive Guide

In this article, I will talk about the Split up syllabus Information Technology 402 Class 10. CBSE has released a skill courses syllabus on 17.04.2023 for all skill courses. IT 402 is one of them. So let’s discuss Split up syllabus Information Technology 402 Class 10 . Here we go!

Split up syllabus Information Technology 402 Class 10

As you know syllabus 2022-23 IT 402 class 10 is divided into 2 parts:

1. Employability Skills
2. Subject Specific Skills

Marks and periods distributions for syllabus Information Technology 402 Class 10

Observe the following tables in which units, periods and marks are given for the particular part. This table is indicating theory marks.

In the next table, I will discuss the practical marks distribution.

So now let us distribute the topics month wise which helps the educators to make lesson plans.

As the new academic year started on the 1st of April, 2023, we have started the classes. So I have chosen topics according to my school’s annual calendar. So let us see them month-wise!

April 2023

In the month of April 2023, I have planned to complete the Part A Employability skills topic Unit 1 Communication Skills – II. The topics covered in April are as follows:

• Methods of communication
• Verbal communication
• Non-verbal communication
• Communication Cycle and Importance of Feedback
• Barriers of effective communication
• Writing Skills – Part of Speech
• Writing Skills – Sentences

1. Create and Apply Styles in digital 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

The activities are planned as given in the CBSE study material.

In the month of May, we have summer vacations for the entire month. The school is reopening after the vacation in June. So next month we have June. The lesson plan for June 2023 for the Split up syllabus Information Technology 402 Class 10 are as follows:

June 2023 – Split up syllabus Information Technology 402 Class 10

In June 2023 I have planned to cover the topics to be covered are as follows:

Part A – Employability Skills

Unit 2: Self-management Skills

• Stress Management
• Self-awareness
• Self-motivation
• Self-regulation

1. Insert and use images in digital 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 images in the text

Now in the next section of Split up syllabus Information Technology 402 Class 10 we are going to discuss topics to be covered in July 2023.

July 2023 – Split up syllabus Information Technology 402 Class 10

The topics to be covered in July 2023 are as follows:

1. Create and use the template
   • Templates
   • Using predefined template
   • Creating a template
   • Set up a custom template as the default
   • Editing a template
   • Changing to a different template
   • Updating a Document
2. 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
3. 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

In the next section, I am going to talk about topics to be covered in August 2023 for Split up syllabus Information Technology 402 Class 10.

August 2023 Split up syllabus Information Technology 402 Class 10

In the month of August, we have a complete month. So I have planned these topics to be completed:

Unit 2 – Electronic Spreadsheet Advanced

1. Analyse data using scenarios and goal seek
   • Using consolidating data
   • Creating subtotals
   • Using “what if” scenarios
   • Using “what if” tools
   • Using goal seek and solver
2. Link data and spreadsheets
   • Setting up multiple sheets
   • Creating reference to other sheets by using keyboard and mouse.
   • Creating reference to other document by using keyboard and mouse
   • Relative and absolute hyperlinks
   • Hyperlinks – Linking to external data & registered data sources

The topics assessed in the practicals are creating references to other documents by using a keyboard and mouse.

The next month is September and this month is also having more working days. I have planned the following activities for the same.

September 2023

The topics to be covered in the month of September are:

Part A : Employability Skills

1. Information and Communication Technology Skills
   • Basic Computer Operations
   • Performing Basic File Operations
   • Computer Care and Maintenance
   • Computer Security and Privacy

Part B – Subject Specific Skills

Unit 2 – Electronic Spreadsheet Advanced

1. 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
2. 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 like built-in functions
   • Accessing cells directly
   • Sorting the columns using macro

In the month of October, we have Periodic test 2 followed by Diwali vacation. So the next topics I have planned in November. The topic planned for November forSplit up syllabus Information Technology 402 Class 10 are as follows:

November 2023

Part A – Employability Skills

1. Entrepreneurial Skills
   • Entrepreneurship and Society
   • Qualities and Functions of an Entrepreneur
   • Myths about Entrepreneurship
   • Entrepreneurship as a Career Option

PART B – SUBJECT-SPECIFIC SKILLS

1. Appreciate the concept of a Database Management System
   • Concept and examples of data and information
   • Concept of database
   • Advantages of database
   • Features of 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
2. Create and edit tables using wizard and SQL commands
   • Introduction to a 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 database
   • Option to set primary key
   • Table Data View dialog box
3. 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 & editing relationships: one to one, one to many, many to many
   • Field properties(default, required and format)
4. 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 wildcard
   • Performing calculations, Grouping of data
   • Structured Query Language (SQL)
   • Introduction to DDL (purpose of- Create database, Create table, Alter table and Drop table)

• query creation using wizard

Now in the next section of Split up syllabus Information Technology 402 Class 10 I am going to talk about the topic to be covered in December 2023.

December 2023

December month is also having more working days as per our school calendar. So I have planned these topics:

Part A: Employability Skills

1. Unit 5 Green Skills
   • Sustainable Development
   • Our Role in Sustainable Development

Part B: Subject Specific Skills
Unit 3 Database Management System

1. Create Forms and Reports using wizard
   • Introduction to Forms in DBMS
   • Creating form using wizard, Steps to create form using Form Wizard
   • Options to enter or remove data from forms
   • Modifying form, Changing label, background
   • Searching record using Form
   • Inserting and deleting record using Form View
   • Concept of Report in Base, Creating Report using wizard
   • Steps to create a Report using Wizard
   • Insert date and time
2. Unit 4 Web applications and Security – Working with Accessibility Options
   • Understand various types of impairment that impact computer Usage
   • Computer Accessibility Dialog box and its tabs, Serial Keys
3. Understand Networking Fundamentals
   • Network and its types, Client Server Architecture, P2P Architecture
   • Internet, WWW, benefits of internet, getting access to internet, internet terminology, Some of the commonly used Internet connectivity options
   • Data transfer on the Internet

Now in the next section of Split up syllabus Information Technology 402 Class 10, I am going to cover these topics.

January 2024 Split up syllabus Information Technology 402 Class 10

The topics covered in January 2024 are :

Part B Subject Specific Skills
Unit 4 Web applications and Security

1. Introduction to Instant Messaging
   • learn key features of instant messaging
   • Creating an instant messaging account, Launching Google Talk
   • Signing in into 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 etiquettes to be followed while chatting
   • chatting on various types of messengers
2. Creating and Publishing Web Pages – Blog
   • learn & appreciate a blog, creation with the help of some blog providers
   • set up title and other parameters in a blog posting comments
   • using offline blog editors
   • Concept to create blogs using a blog application and publish the blog whenever internet connectivity is available
3. Online Transaction
   • concept of e-commerce and various online applications
   • importance of secure passwords
   • internet Security
   • Need of internet security
   • Cyber threats like phishing, email spoofing, chat spoofing etc.
   • best practices for internet security and secure passwords
   • concept of browser, cookies, backup, antivirus, clearing data in browsers
4. 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
5. Prevent Accidents and Emergencies
   • Accidents and emergency, Types of Accidents, Handling Accidents
   • Types of Emergencies
6. Protect Health and Safety at work
   • Hazards and sources of hazards, General evacuation procedures
   • Healthy living

By ending of January 2024 the syllabus will be completed as the board exam will be starting in February 2024.

Download Split up syllabus Information Technology 402 Class 10

Download document through this link:

So I hope this article Split up syllabus Information Technology 402 Class 10, will help you in planning the lesson. If you have any queries or doubts for this article Split up syllabus Information Technology 402 Class 10, feel free to ask in the comment section.

If you want to share your views about this article Split up syllabus Information Technology 402 Class 10, feel free to write in the comment box.

If your needs are satisfied by this article Split up syllabus Information Technology 402 Class 10 like and share this article with IT 402 educators.

Thank you for visiting my blog.