The main objectives of CBSE IT 402 Class 10 Course are:
Familiarize the students with the world of IT and IT-enabled services. Provide in-depth training in the use of data entry, internet, and internet tools. Develop practical knowledge of digital documentation, spreadsheets and presentation. Enable the students to understand the database management system and have updated knowledge about digital record keeping. To make the students capable of getting employment in the Private Sector, Public Sector, Ministries, Courts, the House of Parliament, and State Legislative Assemblies.
To develop the following skills: Data Entry and Keyboarding skills The concept of Digital Documentation The concept of Digital Presentation The concept of an Electronic Spreadsheet The concept of Databases Internet Technologies
Important Features of the course CBSE IT 402 Class 10 To be a data entry operator/analyst, one requires a lot of hard work and practical hands-on experience. One should have an intensive knowledge of Office applications, computer operations, and knowledge of clerical, and administrative techniques, and data analysis. Along with this, as a data entry operator/analyst, you will be expected to have fast typing speed, accuracy, and efficiency to perform tasks. As a data entry operator/analyst, one should improve their computer skills, and numerical and literacy skills. These skills can help one expand into a new career path in the future.
The curriculum of CBSE Information Technology Class 10 Code – 402 consists of the following 4 main parts: Part A – Employability Skills Part B – Subject-Specific Skills Part C – Practical Work Part D – Project Work/Field Visit
In this course, you will study the basic office automation features of Documentation software, Electronic spreadsheet, database concepts, and web applications.
You will be introduced to the fundamental concepts of digital documentation, digital spreadsheets, digital presentation, database management, and internet security.
Part A – Employability Skills
Part B – Subject-Specific Skills
Unit 1: Digital Documentation (Advanced) Unit 1 Digital Documentation Advanced is the first unit of Part B Subject Specific Skills for CBSE IT 402 Class 10. This unit has important learning outcomes like styles, inserting images, templates in documents, table of contents and implement the mail merge. From this unit, there will be 8 marks of questions that can be asked in the board exam.
Unit 2: Electronic Spreadsheet (Advanced) Unit 2 Electronic Spreadsheet (Advanced) focuses on the concepts of spreadsheets. Students are able to analyse the data, understand the uses of various linking in a spreadsheet, share the data, review the changes as well as create and use macros in spreadsheet software. From this unit, 10 marks questions can be asked in the board exam.
Unit 3: Database Management System Unit 3 Database Management System offers Database creation, managing databases, and manipulating databases including queries, forms, and reports. The learning outcomes focus on the basics of databases, creating databases, queries, forms and reports. From this unit, 12 marks questions can be asked in the board exam.
Unit 4: Web Applications and Security Unit 4 web applications and security have learning outcomes like working with accessibility options, understanding networking fundamentals, introducing instant messaging, chatting, creating web pages, online transactions, internet security, workplace safety, accidents and emergencies, protect health and safety at work. From this unit, 10 marks questions can be asked in the board exam.
What is the syllabus of information technology class 10? The syllabus of Information technology class 10 includes two parts: 1 Employability Skills – This part has 5 units like Communication Skills, Self-Management Skills, Basic ICT Skills, Entrepreneurial Skills and Green Skills 2 Subject Specific Skills – This part has 4 main units Digital Documentation (Advanced), Electronic Spreadsheet (Advanced), Database management System and Web application and security.
Is information technology main subject in class 10? Information Technology in a skill course offered by Skill department of CBSE.
What is the importance of information technology class 10? The importance of information technology class 10 is if a student fail in any subject like Maths, Science or Social Science, the marks can be replaced by this subject. Students will learn basic concepts of data entry operator level job which helps them lot in the future.
What is the subject code of information technology class 10? The subject code for information technology class 10 is 402.
Unit 1: Digital Documentation Class 10 1 Create and Apply Styles in the document 2 Insert and Use images in document 3 Create and Use template 4 Working with tables in digital documents 5 Create and Customize table of contents 6 Implement the mail merge
Unit 1: Digital Documentation Class 10 Unit 1: Digital documentation class 10 is a part of CBSE IT 402 part of CBSE skill education of subject-specific skills. All of these topics are explained in Open Office and MS Office.
1 Create and Apply Styles in the document Create and apply styles in the document is the first learning outcome of digital documentation class 10. Styles/Categories in the word processor Style formatting window Fill Format Creating updating new style from a selection Load styles from the template or another document Creating a new style using drag-and-drop Applying styles
2 Insert and Use images in document Options to insert image to document from various sources Options to modify, resize, crop and delete an image Drawing objects and its properties Creating drawing objects and changing its properties Resizing and grouping drawing objects Positioning the image in text
3 Create and Use template Templates Using predefined templates Set up a custom default template Updating a template Changing to a different template Using the template
4 Working with tables in digital documents Tables in Document Insert table Auto-fit Options Entering text into tables Select, Insert, Delete a row, column, cell, and table Merge and Split Cells
5 Create and Customize table of contents Table of contents Hierarchy of headings Customization of table of contents Character styles Managing table of contents
6 Implement the mail merge Advanced concept of mail merge in word processing Creating the main document Creating the data source Entering the data in the fields Merging the data source with the main documents Editing individual document Printing a letter
Unit 2 Electronic Spreadsheet Class 10 What are the learning outcomes of electronic spreadsheet class 10? 1 Analyse data using scenarios and goal seek 2 Link data and Spreadsheets 3 Share and Review a spreadsheet 4 Create and Use macro in a spreadsheet (HOT topic for Electronic Spreadsheet (Advanced) Class-10)
Unit 2 Electronic Spreadsheet Class 10 Electronic Spreadsheet Class 10 is the second unit of the CBSE IT 402 curriculum.
What are the learning outcomes of electronic spreadsheet class 10? Analyse data using scenarios and goal seek Link data and spreadsheets Share and review a spreadsheet Create and Use macros in spreadsheet
1 Analyse data using scenarios and goal seek Consolidating Data | ASSIGNMENTS Create Subtotal | Assignments Using “what-if” scenarios | Assignments Goal seek and solver | Assignments Practical Questions
2 Link data and Spreadsheets Setting up multiple sheets Create a reference to other sheets by using a keyboard and mouse Creating a reference to other documents by using keyboard and mouse Relative and absolute hyperlinks Hyperlinks to the sheet Linking external data Linking to registered data sources
3 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
4 Create and Use macro in a spreadsheet (HOT topic for Electronic Spreadsheet (Advanced) Class-10) Using the macro recorder Creating simple macro Read more… Assignments Using a macro as a function Passing arguments to a macro Macros to work like built-in functions Accessing cell directly Sorting the columns using macro
Learning outcomes of Unit 3 Database Management System Class 10
This unit has the following learning outcomes: Appreciate the concept of a Database Management System Create and edit tables using wizard and SQL Perform operations on the table Retrieve data using the query Create forms and Reports using the wizard
Topics Covered 1 Appreciate the concept of Database Management System 2 Create and edit tables using wizard and SQL 3 Perform operations on table 4 Retrieve data using query 5 Create forms and Reports using wizard
1 Appreciate the concept of Database Management System This learning outcome has the following theoretical concepts: 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 Introduction to an RDBMS Database objects – tables, queries, forms, and reports of the database Terms in the database – table, field, record Steps to create a table using table wizard, Data types in Base Option to set the primary key Table Data View dialogue box DDL Commands
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 Field properties
Referential integrity Creating and editing relationships – one to one, one to many, many to many
4 Retrieve data using query Database query Defining query Query creation using a 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)
5 Create forms and Reports using wizard Forms in Base Creating a form using the wizard Steps to create a form using Form Wizard Options to enter or remove data from forms Modifying form Changing label Changing background Searching records using Form Inserting and deleting records using Form View
Concept of Report in Base Creating Report using the wizard Steps to Create Report using Wizard
Unit 4 Web Applications and Security According to CBSE curriculum Unit 4 web applications and security have a weightage of 10 marks out of 40 marks from subject-specific skills.
Working with accessibility options Understand Networking Fundamentals Introduction to Instant Messaging Creating and Publishing Web Pages – Blog Online Transaction Internet Security Maintain workplace safety Prevent Accidents and Emergencies
There are 11 learning outcomes in Unit 4 Web Applications and Security. These skills are important for all working people nowadays. These all learning outcomes you will get as follows:
Working with accessibility options Understand various types of impairment that impact computer usage Computer Accessibility Dialog box and its tabs Sticky Keys Filter Keys Mouse keys High Contrast Cusror Options
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
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 learn to chat with a contact that is already been added to your contact list. sending text chat messages instantly by double-clicking on a contact. general rules and netiquettes to be followed while chatting chatting on various types of messengers
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 Concept to create blogs using a blog application and publish the blog whenever internet connectivity is available.
Concept of e-commerce and various online applications importance of secure passwords
Internet Security The need for 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
Maintain workplace safety Basic safety rules to follow at the workplace – Fire safety Falls and slips, Electrical safety Use of first aid Case Studies of hazardous situations
Prevent Accidents and Emergencies Accidents and emergencies Types of Accidents Handling Accidents Types of Emergencies
Also check out:
Employability Skills
COPA (Computer Operator and Programming Assistant)
Course on Computer Concepts (CCC)
Information Technology (IT) Support Executive
Join 4M+ learners. Unlock unlimited quizzes, wrong-answer tracking, flashcards + reminders, study guides, and 1-on-1 challenges.