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