CBSE | DEPARTMENT OF SKILL EDUCATION

CURRICULUM FOR SESSION 2020-2021

INFORMATION TECHNOLOGY (CODE – 402)
JOB ROLE: DOMESTIC DATA ENTRY OPERATOR

RATIONALIZED CURRICULUM FOR

CLASS–X FOR SESSION 2020-21
Total Marks: 100 (Theory-50 + Practical-50)

MAX. MARKS
NO. OF HOURS
for Theory and
UNITS for Theory and Practical
Practical
200
100
Employability Skills
Unit 1 : Communication Skills-II 10
Part A

Unit 2 : Self-Management Skills-II 10

Unit 3 : Information and Communication
10 10
Technology Skills-II
Unit 4 : Entrepreneurial Skills-II 15
Unit 5 : Green Skills-II 05
Total 50 10
Theory Practical
Subject Specific Skills Marks
(In Hours) (In Hours)
Unit 1: Digital Documentation
Part B

12 18 8
(Advanced)
Unit 2: Electronic Spreadsheet
15 23 10
(Advanced)
Unit 3: Database Management System 18 27 12
Unit 4: Web Applications and Security 15 22 10
Total 60 90 40
Practical Work
Part D Part C

Practical Examination 15
Written Test 10
Viva Voce 10
Total 35
Project Work/Field Visit
Practical File/ Student Portfolio 10
Viva Voce 05
Total 15

GRAND TOTAL 200 100

Page 1 of 9
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 DURATION 50

NOTE: For detailed Curriculum/ Topics to be covered under Part A: Employability

Skills can be downloaded from CBSE website.

Part-B – SUBJECT SPECIFIC SKILLS

S. No. Units Duration in Hours

1. Unit 1: Digital Documentation (Advanced) 30
2. Unit 2: Electronic Spreadsheet (Advanced) 38
3. Unit 3: Database Management System 45
4. Unit 4: Web Applications and Security 37
TOTAL DURATION 150

UNIT 1: DIGITAL DOCUMENTATION (ADVANCED)

S. LEARNING
THEORY PRACTICAL
No. OUTCOMES
1. Create and Apply  Styles/ categories in Word  List style categories. Select the
Styles in the Processor style from the Styles and
document  Styles and Formatting Formatting window.
window.*  Use Fill Format to apply a style to
 Fill Format.* many different areas quickly.
 Creating and updating new  Create and update new style from
style from selection a selection.
 Load style from template or  Load a style from a template or
another document. another document.
 Creating a new style using  Create a new style using drag-
drag-and-drop.* and-drop.
 Applying styles.
(* To be assessed in Practicals only. No question shall be asked from this portion in Theory Exams)

402 – Information Technology Class X - 2020-2021 Page 2 of 9

 S. LEARNING
THEORY PRACTICAL
No. OUTCOMES
2. Insert and use  Options to insert image to  Insert an image to document from
images in document document from various various sources.
sources.  Modify, resize, crop and delete an
 Options to modify, resize, image.
crop and delete an image.  Create drawing objects
Drawing objects and its  Set or change the properties of a
properties. drawing object
 Creating drawing objects  Resize and group drawing
and changing its properties. objects
Resizing and grouping  Position the image in the text
drawing objects.
 Positioning image in the
text.

3. Create and use  Templates.  Create a template.

template  Using predefined templates.  Use predefined templates.
 Creating a template. *  Set up a custom default template.
 Set up a custom default  Update a document.
template.  Change to a different template.
 Updating a document.*  Use the Template.
 Changing to a different
template.
 Using the Template.

4. Create and  Table of contents. Hierarchy  Create table of contents. Define a

customize table of of headings. Customization hierarchy of headings.
contents of table of contents.  Customize a table of contents.
 Character styles.  Apply character styles. Maintain a
Maintaining a table of table of contents.
contents.

5 Implement Mail  Advance concept of mail  Demonstrate to print the label

Merge merge in word processing, using mail merge, do the
 Creating a main document, following to achieve
 Creating the data source,  Create a main document,
 Entering data in the fields,  Create the data source,
 Merging the data source  Enter data in the fields,
with main document,  Merge the data source with main
 Editing individual document,
document,*  Edit individual document,
 Printing a letter and its  Print the letter and address label
address label
(* To be assessed in Practicals only. No question shall be asked from this portion in Theory Exams)

402 – Information Technology Class X - 2020-2021 Page 3 of 9

 UNIT 2: ELECTRONIC SPREADSHEET (ADVANCED)
S. LEARNING
THEORY PRACTICAL
No. OUTCOMES
1. Analyse data using  Using consolidating data.  Use consolidating data Create
scenarios and goal Creating subtotals. subtotals
seek.  Using “what if” scenarios.  Use “what if” scenarios Use
Using “what if” tools “what if” tools
 Using goal seek and solver.  Use goal seek and solver
2. Link data and  Setting up multiple sheets.  Setup multiple sheets by
spreadsheets Creating reference to other inserting new sheets.
sheets by using keyboard  Create reference to other sheets
and mouse. by using keyboard and mouse.
 Creating reference to other  Create reference to other
document by using document by using keyboard and
keyboard and mouse.* mouse.
 Relative and absolute  Create, Edit and Remove
hyperlinks hyperlinks to the sheet.
 Hyperlinks to the sheet.  Link to external data.
o Linking to external data.  Link to registered data source.
o Linking to registered
data sources.

3. Share and review a  Setting up a spreadsheet for  Set up a spreadsheet for sharing.
spreadsheet sharing.*  Open and save a shared
 Opening and saving a spreadsheet.
shared spreadsheet.  Record changes.
Recording changes.  Add, Edit and Format the
 Add, Edit and Format the comments.
comments.  Review changes – view, accept
 Reviewing changes – view, or reject changes.
accept or reject changes.  Merge and compare sheets.
Merging and comparing.

4. Create and Use  Using the macro recorder.  Use the macro recorder. Create a
Macros in Creating a simple macro. simple macro. Use a macro as a
spreadsheet Using a macro as a function.
function.  Pass arguments to a macro.
 Passing arguments to a  Pass the arguments are as
macro. values.
 Passing the arguments  Write macros that act like built-in
areas values. functions
 Macros to work like built-in  Access cells directly.
functions.  Sort the columns using macro.
 Accessing cells directly.
 Sorting the columns using
macro.
(* To be assessed in Practicals only. No question shall be asked from this portion in Theory Exams)

402 – Information Technology Class X - 2020-2021 Page 4 of 9

 UNIT 3: DATABASE MANAGEMENT SYSTEM
S. LEARNING
THEORY PRACTICAL
No. OUTCOMES
1. Appreciate the  Concept and examples of  Identify the data and information,
concept of data and information,  Identify the field, record, table in
Database  Concept of database, the database,
Management  Advantages of database,  Prepare the sample table with
System  Features of database, some standard fields.
 Concept and examples of  Assign the primary key to the field,
Relational database,  Identify the primary key,
 Concept and examples of composite primary key, foreign
field, record, table, key.
database,
 Concept and examples of
Primary key, composite
primary key, foreign key,
 Relational Data base
management system
(RDBMS) software.
2. Create and edit  Introduction to a RDBMS  Start the RDBMS and observe
tables using  Database objects – tables, the parts of main window,
wizard and SQL queries, forms, and reports  Identify the data base objects
commands of the database, Create the sample table in any
 Terms in database – table, category using wizard, Practice
field, record, to create different tables from the
 Steps to create a table available list and choosing fields
using table wizard, * from the available fields.
 Data types in Base,  Assign data types of field, Set
 Option to set primary key primary key,
Table Data View dialog box  Edit the table in design view,
 DDL Commands Enter the data in the fields.
 Create and edit table using DDL
Commands
3. Perform  Inserting data in the table, Demonstrate to:
operations on  Editing records in the table,  Insert data in the table, Edit
table  Deleting records from the records in the table, Delete
table, records from table, Sort data in
 Sorting data in the table, the table,
Referential integrity,  Create and edit relationships
 Creating and editing  one to one, one to many, many
relationships – one to one, to many,
one to many, many to  Enter various field properties.
many,
 Field properties.
(* To be assessed in Practicals only. No question shall be asked from this portion in Theory Exams)

402 – Information Technology Class X - 2020-2021 Page 5 of 9

 S. LEARNING
THEORY PRACTICAL
No. OUTCOMES
4. Retrieve data  Database query,  Prepare a query for given criteria,
using query  Defining query,  Demonstrate to create query
 Query creation using using wizard, and using design
wizard,* view,
 Creation of query using  Edit a query,
design view,*  Demonstrate to apply various
 Editing a query, criteria in query – single field,
 Applying criteria in query – multiple fields, using wild card,
single field, multiple fields,  Performing calculations using
using wildcard, query in Base,
 Performing calculations,  Demonstrate to group data,
 Grouping of data,  Use basic SQL commands,
 Structured Query Language
(SQL).

5. Create Forms and  Forms in Base,  Illustrate the various steps to

Reports using  Creating form using wizard,* create Form using Form Wizard,
wizard  Steps to create form using  Enter or remove data from
Form Wizard,* Forms,
 Options to enter or remove  Demonstrate to modify Forms,
data from forms  Demonstrate to change label,
 Modifying form, background,
 Changing label,  Search record using Form,
background,  Insert and delete record using
 Searching record using Form View,
Form,  Illustrate the various steps to
 Inserting and deleting create Report using Report
record using Form View, Wizard,
 Concept of Report in Base,  Demonstrate various examples
 Creating Report using of Report.
wizard,*
 Steps to create Report
using Wizard.*

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

402 – Information Technology Class X - 2020-2021 Page 6 of 9

 UNIT 4: WEB APPLICATIONS AND SECURITY
S. LEARNING
THEORY PRACTICAL
No. OUTCOMES
1. Working With  Understand various types of  Illustrate use of various
Accessibility impairment that impact computer options under Computer
Options. usage Accessibility like Keyboard
 Computer Accessibility Dialog box , mouse, sound, display
and its tabs setting serial keys, cursor
 Serial Keys options
 use of toggle keys, filter
keys, sticky keys,
 sound sentry, show sounds
etc.
2. Understand  Network and its types.  Identify applications of
Networking  Client Server Architecture, Peer- Internet
Fundamentals to-peer (P2P) Architecture,  comparing various internet
 internet, World Wide Web, technologies
 benefits of networking  identifying types of networks
 internet, getting access to and selecting internet
internet,
 internet terminology
 Some of the commonly used
Internet connectivity options
 Data transfer on the Internet
3. Introduction to  learn key features of instant  Illustrate steps to create
Instant Messaging messaging instant messaging account
 Creating an instant messaging  Signing In into your Google
account Talk Account
 Launching Google Talk *
 Signing In into your Google Talk
Account*
4. Chatting With a  learn to chat with a contact that is  Illustrate chat with a
Contact – Google already added to your contact list. contact and send
Talk  sending text chat messages messages,
instantly by double-clicking on a  chatting with various
contact. messenger services
 general rules and etiquettes to be
followed while chatting.
 chatting on various types of
messengers
5 Creating and  learn and appreciate a blog and  Illustrate Blog Creation and
Publishing Web its creation with the help of some setting various parameters
Pages – Blog …- blog providers* in it
 set up title and other parameters
in a blog posting comments
 using offline blog editors

402 – Information Technology Class X - 2020-2021 Page 7 of 9

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

S. LEARNING
THEORY PRACTICAL
No. OUTCOMES
6 Using Offline Blog  Concept to create blogs using a  Demonstration on how to
Editors blog application and publish the create blogs using a blog
blog whenever internet application offline.
connectivity is available.  posting messages in an offline
application
 Publish the blog whenever
internet connectivity is
available using various
examples
7 Online  concept of e-commerce and  Illustration of online
Transaction various online applications shopping using various e-
 importance of secure passwords commerce sites
 Demonstration of securing
passwords for online
transactions.
8. Internet Security  Need of internet security  Illustration of internet security
 Cyber threats like phishing, threats through various ways
email-spoofing, char spoofing  Cyber security tips
etc.  Tips for secure passwords
 best practices for internet  Demonstration of strong
security and secure passwords passwords using various
 concept of browser, cookies, websites.
backup, antivirus  Clearing data stored in
 clearing data in browsers browser applications.
9. Maintain  Basic safety rules to follow at  Practice to follow basic safety
workplace safety workplace – Fire safety, rules at workplace to prevent
 Falls and slips, Electrical safety, accidents and protect workers
 Use of first aid. – Fire safety,
 Case Studies of hazardous  Falls and slips, Electrical
situations. safety, Use of first aid.
10. Prevent  Accidents and emergency,  Illustrate to handle accidents
Accidents and  Types of Accidents, at workplace,
Emergencies  Handling Accidents  Demonstrate to follow
 Types of Emergencies. evacuation plan and
procedure in case of an
emergency.
11. Protect Health  Hazards and sources of  Identify hazards and sources
and Safety at hazards, of hazards,
work  General evacuation procedures,  identify the problems at
 Healthy living. workplace that could cause
accidents,

402 – Information Technology Class X - 2020-2021 Page 8 of 9

  Practice the general
evacuation procedures in case
of an emergency.
(* To be assessed in Practicals only. No question shall be asked from this portion in Theory Exams)

402 – Information Technology Class X - 2020-2021 Page 9 of 9