Information Technology Code 402 Class IX & X
Information Technology
CBSE Code: 402 (NSQF)
Class IX and X
Contents
Class IX .................................................................................................................................................................................. 2
PART A: Employability Skills ........................................................................................................................................... 2
Unit 1: Communication Skills ............................................................................................................................................ 2
Unit 2: Self-Management Skills ....................................................................................................................................... 10
Unit 3: Basic ICT Skills .................................................................................................................................................... 14
Unit 4: Entrepreneurial Skills ........................................................................................................................................... 23
Unit 5: Green Skills .......................................................................................................................................................... 28
PART B: Vocational Skills .............................................................................................................................................. 33
Unit 1: Introduction to IT-ITeS Industry .......................................................................................................................... 33
Unit 2: Mastering Typing ................................................................................................................................................. 39
Unit 3: Word Processing ................................................................................................................................................... 39
Unit 4: Spreadsheet ........................................................................................................................................................... 42
Unit 5: Digital Presentation .............................................................................................................................................. 45
Unit 6: Email Messaging .................................................................................................................................................. 47
Class X .................................................................................................................................................................................. 52
PART A: Employability Skills ......................................................................................................................................... 52
Unit 1a: Communication Skills - II ................................................................................................................................. 52
Unit 1b: Self-Management Skills – II ............................................................................................................................... 60
Unit 1c: Basic ICT Skills – II ........................................................................................................................................... 66
Unit 1d: Entrepreneurial Skills – II................................................................................................................................... 69
Unit 1e: Green Skills ........................................................................................................................................................ 74
PART B: Vocational Skills .............................................................................................................................................. 80
Unit 2: Web Applications (Basic) ..................................................................................................................................... 80
Unit 3: Word Processing (Intermediate) .......................................................................................................................... 86
Unit 4: Spreadsheet (Intermediate) .................................................................................................................................. 89
Unit 5: Digital Presentation (Intermediate) ...................................................................................................................... 94
Unit 6: Email Messaging (Intermediate) .......................................................................................................................... 98
Unit 7: Database Development (Basic)........................................................................................................................... 101
1
,Information Technology Code 402 Class IX & X
Class IX
PART A: Employability Skills
Unit 1: Communication Skills
SESSION 1: Communication Cycle
Exercise
1. List the main components of communication process.
The main components or elements of communication process are sender, message, encoding,
communication channel, receiver, decoding and feedback.
2. Who is responsible for the encoding of the message?
Encoding of the message is done by the sender before sending it to the receivers.
3. Who is responsible for decoding the message?
Decoding of the message is done by the receiver after receiving the message.
4. List 3 scenarios of technology based communication?
Three scenarios of technology communication are conversation over telephone, online chat and
video conferencing.
5. What do you mean by the channel of communication? Give some examples.
The medium of communication is called communication channel such as oral, written, technology
based.
Exercise
1. Describe a scenario where all the major factors of effective communication come
in effect.
One such scenario is classroom. Sender and receiver are teacher and students respectively. The
mutually accepted communication code is the discipline in the classroom wherein students will pay
attention to what teacher is explaining. Teachers encodes the message ie simplifies the concept to
be taught with her explanation. Students receive the message and with their attentive mind, try to
understand the explanation given by the teacher (decoding). Then teacher enquired whether they
understood the concept or not by asking questions. This is feedback.
2. List any 4 most important characteristics of effective communication.
1. Communication should be clear in content and purpose.
2. Communication should be complete with least scope of questions.
3. Communication should be based on right facts and should not be vague.
4. Effective communication leads to desired output and achievements.
3. Relate a real life scenario depicting communication barrier of environment.
During summers, a hot classroom is there with students and teachers. Due to the heat, students
find it difficult to concentrate on what teacher is explaining and teacher is also uncomfortable.
2
,Information Technology Code 402 Class IX & X
4. Give real life example of communication barrier due to personality traits of the
communicators.
A person who is not well conversant in English is trying to sell an item to a customer who
understands English only. Another example: two persons from vastly different culture say Japan
and India, trying to exchange their ideas for the first time.
SESSION 2: Methods of Communication
Exercise
1. Describe a scenario where oral communication is most effective as compared to
written.
Teacher’s explanation in the classroom, a leader addressing a gathering of people, two persons
discussing a matter to resolve a dispute between them.
2. List any 3 scenarios where written communication is most effective.
Written communication is most effective in formal setups like official orders, legal notices, agreement
with terms and conditions, pact signed between two governments etc.
3. List any 2 major advantages and disadvantages of non-verbal communication.
Advantages of Non-verbal Communication
1. Non-verbal communication complements oral and audio visual communication.
2. It substitutes for the verbal communication like speaking with proper eye contact and tone.
Disadvantages of Non-verbal Communication
1. Sometimes non-verbal communication becomes vague and send wrong signals.
2. You cannot stop non-verbal communication.
4. List any 3 major advantages and disadvantages of AV communication.
Advantages of AV Communication
1. Use of internet and video conferencing saves cost incurred otherwise on scaling geographical
barriers, physical movement of participants and other related expenses like lodging, food etc.
2. It is an effective way to explain complex ideas and concepts easily.
3. Technology makes it reusable and easy to distribute.
Disadvantages of AV Communication
1. It incurs a lot of cost in infrastructure.
2. It needs maintenance of equipment.
3. Technology and equipment can be complex to operate and learn.
SESSION 3: Communication Perspectives
Exercise
1. Describe a scenario where your visual perspective affected your decoding of a
message.
Seeing a man in plain, simple clothes with ordinary personality and we assume that the person is
not very bright and not sufficiently wealthy while actually he could be a learned college professor
earning a handsome salary.
3
, Information Technology Code 402 Class IX & X
2. Relate an example where you interpreted a message depending on your past
experiences.
After receiving a bad response from the customer care persons of the company which sold me a TV,
I did not buy air conditioner from them.
3. What do you mean by prejudice?
Believing the information about someone without verifying the facts and disliking the person
accordingly is called prejudice.
4. How our beliefs, emotions and environment influence our communication
perspective?
We relate with people according to our value system and beliefs. During communication, our
negative emotions affect the process badly. Reacting in anger spoils the conversation. Our
environment determines how we communicate. When we are with friends on a picnic, our style of
communication is different as compared to that in the classroom in front of teacher.
SESSION 4: Basic Writing Skills
Exercise
1. Types of Phrase: pleasantly surprised (adverbial), meeting her friend (verb), at the
airport (prepositional), had been sitting (verb), the waiting lounge (noun), Lata
spotted her (verb), both shared (verb), a lot of experiences (adjective), of their exciting
lives (adjective), time flied very fast (noun, verb and adverb mix), boarded the same
flight (verb), bound to Mumbai (noun).
2.
NOUN PRONOUN VERB ADJECTIVE ADVERB PREPOPSITION CONJUNCTION INTERJECTION
Girl Her Lived Poor Very much On Who Wow
Anna She Thought New Suddenly In So Alas
Mother Loved Useful To And
Year Thinking Beautiful Which
Gift Sew Long But
Hair Buying Colourful
hair ribbons Wished Too old
Clothes Buy Shining
Villagers Did Enough
set of needles Got Short
Threads Called
glass box Said
Money Have
Idea Saying
eve of new year Removed
Cap Showed
Barber Bought
Selling
Exercise
A. Fill in the blanks with the suitable article:
1. the 2. The 3. An 4. A 5. The 6. An 7. An, the 8. the
B. Is there anything wrong with these sentences? Why?/ Why not?
“The” will not be used before nouns here.
1. My brother plays cricket. Abstract Noun
2. She likes chocolates. Plural noun
3. Everything that glitters is not gold. Name of metal
4. I returned the book to Ram. Proper noun - Ram
5. Breakfast is ready. Abstract noun - breakfast
6. My favourite colour is blue. Name of the colour
4
Information Technology
CBSE Code: 402 (NSQF)
Class IX and X
Contents
Class IX .................................................................................................................................................................................. 2
PART A: Employability Skills ........................................................................................................................................... 2
Unit 1: Communication Skills ............................................................................................................................................ 2
Unit 2: Self-Management Skills ....................................................................................................................................... 10
Unit 3: Basic ICT Skills .................................................................................................................................................... 14
Unit 4: Entrepreneurial Skills ........................................................................................................................................... 23
Unit 5: Green Skills .......................................................................................................................................................... 28
PART B: Vocational Skills .............................................................................................................................................. 33
Unit 1: Introduction to IT-ITeS Industry .......................................................................................................................... 33
Unit 2: Mastering Typing ................................................................................................................................................. 39
Unit 3: Word Processing ................................................................................................................................................... 39
Unit 4: Spreadsheet ........................................................................................................................................................... 42
Unit 5: Digital Presentation .............................................................................................................................................. 45
Unit 6: Email Messaging .................................................................................................................................................. 47
Class X .................................................................................................................................................................................. 52
PART A: Employability Skills ......................................................................................................................................... 52
Unit 1a: Communication Skills - II ................................................................................................................................. 52
Unit 1b: Self-Management Skills – II ............................................................................................................................... 60
Unit 1c: Basic ICT Skills – II ........................................................................................................................................... 66
Unit 1d: Entrepreneurial Skills – II................................................................................................................................... 69
Unit 1e: Green Skills ........................................................................................................................................................ 74
PART B: Vocational Skills .............................................................................................................................................. 80
Unit 2: Web Applications (Basic) ..................................................................................................................................... 80
Unit 3: Word Processing (Intermediate) .......................................................................................................................... 86
Unit 4: Spreadsheet (Intermediate) .................................................................................................................................. 89
Unit 5: Digital Presentation (Intermediate) ...................................................................................................................... 94
Unit 6: Email Messaging (Intermediate) .......................................................................................................................... 98
Unit 7: Database Development (Basic)........................................................................................................................... 101
1
,Information Technology Code 402 Class IX & X
Class IX
PART A: Employability Skills
Unit 1: Communication Skills
SESSION 1: Communication Cycle
Exercise
1. List the main components of communication process.
The main components or elements of communication process are sender, message, encoding,
communication channel, receiver, decoding and feedback.
2. Who is responsible for the encoding of the message?
Encoding of the message is done by the sender before sending it to the receivers.
3. Who is responsible for decoding the message?
Decoding of the message is done by the receiver after receiving the message.
4. List 3 scenarios of technology based communication?
Three scenarios of technology communication are conversation over telephone, online chat and
video conferencing.
5. What do you mean by the channel of communication? Give some examples.
The medium of communication is called communication channel such as oral, written, technology
based.
Exercise
1. Describe a scenario where all the major factors of effective communication come
in effect.
One such scenario is classroom. Sender and receiver are teacher and students respectively. The
mutually accepted communication code is the discipline in the classroom wherein students will pay
attention to what teacher is explaining. Teachers encodes the message ie simplifies the concept to
be taught with her explanation. Students receive the message and with their attentive mind, try to
understand the explanation given by the teacher (decoding). Then teacher enquired whether they
understood the concept or not by asking questions. This is feedback.
2. List any 4 most important characteristics of effective communication.
1. Communication should be clear in content and purpose.
2. Communication should be complete with least scope of questions.
3. Communication should be based on right facts and should not be vague.
4. Effective communication leads to desired output and achievements.
3. Relate a real life scenario depicting communication barrier of environment.
During summers, a hot classroom is there with students and teachers. Due to the heat, students
find it difficult to concentrate on what teacher is explaining and teacher is also uncomfortable.
2
,Information Technology Code 402 Class IX & X
4. Give real life example of communication barrier due to personality traits of the
communicators.
A person who is not well conversant in English is trying to sell an item to a customer who
understands English only. Another example: two persons from vastly different culture say Japan
and India, trying to exchange their ideas for the first time.
SESSION 2: Methods of Communication
Exercise
1. Describe a scenario where oral communication is most effective as compared to
written.
Teacher’s explanation in the classroom, a leader addressing a gathering of people, two persons
discussing a matter to resolve a dispute between them.
2. List any 3 scenarios where written communication is most effective.
Written communication is most effective in formal setups like official orders, legal notices, agreement
with terms and conditions, pact signed between two governments etc.
3. List any 2 major advantages and disadvantages of non-verbal communication.
Advantages of Non-verbal Communication
1. Non-verbal communication complements oral and audio visual communication.
2. It substitutes for the verbal communication like speaking with proper eye contact and tone.
Disadvantages of Non-verbal Communication
1. Sometimes non-verbal communication becomes vague and send wrong signals.
2. You cannot stop non-verbal communication.
4. List any 3 major advantages and disadvantages of AV communication.
Advantages of AV Communication
1. Use of internet and video conferencing saves cost incurred otherwise on scaling geographical
barriers, physical movement of participants and other related expenses like lodging, food etc.
2. It is an effective way to explain complex ideas and concepts easily.
3. Technology makes it reusable and easy to distribute.
Disadvantages of AV Communication
1. It incurs a lot of cost in infrastructure.
2. It needs maintenance of equipment.
3. Technology and equipment can be complex to operate and learn.
SESSION 3: Communication Perspectives
Exercise
1. Describe a scenario where your visual perspective affected your decoding of a
message.
Seeing a man in plain, simple clothes with ordinary personality and we assume that the person is
not very bright and not sufficiently wealthy while actually he could be a learned college professor
earning a handsome salary.
3
, Information Technology Code 402 Class IX & X
2. Relate an example where you interpreted a message depending on your past
experiences.
After receiving a bad response from the customer care persons of the company which sold me a TV,
I did not buy air conditioner from them.
3. What do you mean by prejudice?
Believing the information about someone without verifying the facts and disliking the person
accordingly is called prejudice.
4. How our beliefs, emotions and environment influence our communication
perspective?
We relate with people according to our value system and beliefs. During communication, our
negative emotions affect the process badly. Reacting in anger spoils the conversation. Our
environment determines how we communicate. When we are with friends on a picnic, our style of
communication is different as compared to that in the classroom in front of teacher.
SESSION 4: Basic Writing Skills
Exercise
1. Types of Phrase: pleasantly surprised (adverbial), meeting her friend (verb), at the
airport (prepositional), had been sitting (verb), the waiting lounge (noun), Lata
spotted her (verb), both shared (verb), a lot of experiences (adjective), of their exciting
lives (adjective), time flied very fast (noun, verb and adverb mix), boarded the same
flight (verb), bound to Mumbai (noun).
2.
NOUN PRONOUN VERB ADJECTIVE ADVERB PREPOPSITION CONJUNCTION INTERJECTION
Girl Her Lived Poor Very much On Who Wow
Anna She Thought New Suddenly In So Alas
Mother Loved Useful To And
Year Thinking Beautiful Which
Gift Sew Long But
Hair Buying Colourful
hair ribbons Wished Too old
Clothes Buy Shining
Villagers Did Enough
set of needles Got Short
Threads Called
glass box Said
Money Have
Idea Saying
eve of new year Removed
Cap Showed
Barber Bought
Selling
Exercise
A. Fill in the blanks with the suitable article:
1. the 2. The 3. An 4. A 5. The 6. An 7. An, the 8. the
B. Is there anything wrong with these sentences? Why?/ Why not?
“The” will not be used before nouns here.
1. My brother plays cricket. Abstract Noun
2. She likes chocolates. Plural noun
3. Everything that glitters is not gold. Name of metal
4. I returned the book to Ram. Proper noun - Ram
5. Breakfast is ready. Abstract noun - breakfast
6. My favourite colour is blue. Name of the colour
4
