CBSE Class 10th I.T Syllabus 2022

CBSE Class 10th Information Technology (Code 402) Syllabus 2022

 Information Technology(Advanced) introduced in the CBSE Class 10th Syllabus to make students Industry ready and handle a day to day work in the job by learning basics of advance Informational Technology (Code 402) Employability skill. 

CBSE Class 10th I.T (402) Syllabus 2022 - PART A

TERM UNITS No.Of Hours Max. Marks

Employability Skill

TERM I

Unit 1: Communication Skill-II

10

5

Unit 2: Self Management Skills-II

10

Unit 3: Information & Communication Technology Skills-II

10

TERM II

Unit 4: Entrepreneurial Skills-II

15

5

Unit 5: Green Skills -II

5

TOTAL

50

10

CBSE Class 10th I.T (402) Syllabus 2022 - PART B

TERM UNITS No.Of Hours Max. Marks

Subject Specific Skills

Theory/Practical

    (in hours)

Marks

TERM I

Unit 1: Digital Documentation (Advanced)

12 / 18

8

Unit 2: Electronic Spreadsheet (Advanced)

15 / 23

10

Unit 3: Database Management System

04 / 07

02

TERM II

Unit 4: Database Management System

14 / 20

10

Unit 4: Web Application 7 Security

15 / 22

10

TOTAL

60 / 90

40

CBSE Class 10th I.T (402) Syllabus 2022 - PART C

Practical Work

Practical Examination

  • Advanced Documentation : 5 Marks
  • Advanced Spreadsheet: 5 Marks
  • Database : 10 Marks

20

Viva Voce

10

TOTAL

30

CBSE Class 10th I.T (402) Syllabus 2022 - PART D

Project Work / Field Visit

Any interdisciplinary Real World case study to be taken. Summarized data reports of same can be presented in base.Input should be taken using forms and output should be done using reports using base.Documentation of the case study should be presented using writer.

10

Portfolio/Practical File:

Portfolio should contain printouts of the practical done using Writer, Calc & Base with minimum 5 problems of each

10

TOTAL

20

GRAND TOTAL (A+B+C)

200

100

CBSE Class 10th I.T Syllabus 2022 - Detailed Curriculum

UNIT 1: DIGITAL DOCUMENTATION (ADVANCED)

1. LEARNING OUTCOMES

Create and Apply Styles in the document.

THEORY:

  • Styles/ categories in Word Processor
  • Styles and Formatting window.
  • Fill Format.
  • Creating and updating new style from selection
  • Load style from template or another document.
  • Creating a new style using drag-and-drop.
  • Applying styles.

 

2. LEARNING OUTCOMES

Insert and use images in document

THEORY

  • 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 image in the text

 

3. LEARNING OUTCOMES

Create and use template

THEORY

• Templates.
• Using predefined templates.
• Creating a template.
• Set up a custom default
template.
• Updating a document.
• Changing to a different
template.
• Using the Template.

4. LEARNING OUTCOMES

Create and Customize table of contents

THEORY

• Table of contents.
Hierarchy of
headings.
Customization of
table of contents.
• Character styles.
Maintaining a table of
contents.

5. LEARNING OUTCOMES

Implement Mail Merge

THEORY

• Advance concept of mail
merge in word processing,
• Creating a main document,
• Creating the data source,
• Entering data in the fields,
• Merging the data source
with main document,
• Editing individual document,
• Printing a letter and its
address label

UNIT 2: ELECTRONIC SPREADSHEET (ADVANCED)

1. LEARNING OUTCOMES

Analyse data using scenarios and goal seek.

THEORY:

  • Using consolidating data.
  • Creating subtotals.
  • Using “what if” scenarios.
  • Using “what if” tools
  • Using goal seek and solver.

2. LEARNING OUTCOMES

 Link data and spreadsheets

THEORY

  • 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 to the sheet.
    o Linking to external data.
    o Linking to registered data sources.

3. LEARNING OUTCOMES

Share and review a spreadsheet

THEORY

  • 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. LEARNING OUTCOMES

Create and Use Macros in spreadsheet

THEORY

  • Using the macro recorder.
  • Creating a simple macro.
  • Using a macro as a function.
  • Passing arguments to a macro.
  • Passing the arguments areas values.
  • Macros to work like built-in functions.
  • Accessing cells directly.
  • Sorting the columns using macro.

UNIT 3: DATABASE MANAGEMENT SYSTEM

1. LEARNING OUTCOMES

Appreciate the concept of Database Management System

THEORY:

  • 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 Data base management system (RDBMS) software
  •  

2. LEARNING OUTCOMES

Create and edit tables using wizard and SQL commands

THEORY

  • 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 Base,
  • Option to set primary key Table Data View dialog box
    DDL Commands

3. LEARNING OUTCOMES

Perform operations on table

THEORY

  • 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.

4. LEARNING OUTCOMES

Retrieve data using query

THEORY

  • 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).

5. LEARNING OUTCOMES

Create Forms and Reports using wizard

THEORY

  • Forms in Base,
  • 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 Report using Wizard.

UNIT 4: WEB APPLICATIONS AND SECURITY

1. LEARNING OUTCOMES

Create and Apply Styles in the document

THEORY:

  • Understand various types of
    impairment that impact computer usage
  • Computer Accessibility Dialog box and its tabs
  • Serial Keys

2. LEARNING OUTCOMES

Understand Networking Fundamentals

THEORY

  • Network and its types.
  • Client Server Architecture, Peer to-peer (P2P) Architecture,
  • internet, World Wide Web,
  • benefits of networking
  • internet, getting access to internet,
  • internet terminology
  • Some of the commonly used Internet connectivity options
  • Data transfer on the Internet

3. LEARNING OUTCOMES

Introduction to Instant Messaging

THEORY

  • learn key features of instant messaging
  • Creating an instant messaging account
  • Launching Google Talk
  • Signing In into your Google Talk Account

4. LEARNING OUTCOMES

Chatting with a Contact – Google Talk

THEORY

  • 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

5. LEARNING OUTCOMES

Creating and Publishing Web Pages – Blog

THEORY

  • 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

6. LEARNING OUTCOMES

Using Offline Blog Editors

THEORY

  • Concept to create blogs using a blog application and publish the blog whenever internet connectivity is available.

7. LEARNING OUTCOMES

Online Transaction

THEORY

  • concept of e-commerce and various online applications
  • importance of secure passwords

8. LEARNING OUTCOMES

Internet Security

THEORY

  • Need of 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

9. LEARNING OUTCOMES

Maintain workplace safety

THEORY

  • Basic safety rules to follow at workplace – Fire safety,
  • Falls and slips, Electrical safety, Use of first aid.
  • Case Studies of hazardous situations.

10. LEARNING OUTCOMES.

Prevent Accidents and Emergencies

THEORY

  • Accidents and emergency,
  • Types of Accidents,
  • Handling Accidents
  • Types of Emergencies

11. LEARNING OUTCOMES.

Protect Health and Safety at work

THEORY

  • Hazards and sources of hazards,
  • General evacuation procedures,
  • Healthy living.

Leave a Reply

Your email address will not be published.