Touchpad Information Technology Class 9

Published by:

Orange Education Pvt Ltd

An ISO 9001: 2015 Company

9, Daryaganj

New Delhi-110002

Phone: 43776600

8588814859

Email: [email protected]

IE Code: 0511063121

Branches:

• Chennai • Guwahati

Regional Offices:

• Ahmedabad • Bengaluru • Bhopal • Bhubaneswar • Dehradun • Hyderabad • Jaipur • Raipur • Kochi • Kolkata • Lucknow • Mumbai • Patna • Ranchi

Second Edition

© Publishers

No part of this publication may be reproduced, distributed, or transmitted in any form or by any means, including photocopying, recording, or other electronic or mechanical methods, without the prior written permission of the publisher.

Disclaimer

All product names, brand names and product logos mentioned or shown in this book are trademarks, registered trademarks, or trade names of their respective owners. The reproduction of these product names, brand names, and product logos and all instances of references of proprietary software in this book, are for educational purposes only.

Although every safety measure has been taken to verify the precision of the information contained herein, the author(s) and publisher assume no responsibility for any error or omission. No liability is assumed for damages that may result from the use of information contained within.

PREFACE

Computer literacy has become an integral part of today’s education system and prospering employment.

The chapters of this book have been selected and designed as per the CBSE curriculum of Vocational course on IT.

The main features of this book are as follows:

The language of the book is simple and easy to understand.

The book focuses on Free and Open-Source Software (Foss) with highlights of MS Office.

Notes are given for add-on knowledge.

Students are provided with fun facts about the topic.

Lab Activities are added in between the chapters to develop practical skills.

The applications of IT Tools are discussed with real-life scenarios.

The contents will help to create opportunities for better job prospects with respect to IT fields.

We hope that the book will help the students to learn the concepts and find their applications for the progressive development of computer-aided education. We look forward to any suggestions to improve the book. Here’s wishing young readers lots of tech fun and knowledge-filled journey ahead!

—Author

Dr. Sanjay Jain

(MBA, M.Sc-Comp. Sc.)

INSIDE THE SERIES

The key features of the series have been designed to ensure better learning, assessment and

Course Overview:

A Data Entry Operator/Analyst is a person who is responsible for entering data into different applications and computer databases manage and maintain effective record keeping. In addition, they are responsible for organizing files, collecting and managing data to be entered into the computer. They are also responsible for security of data and safeguard the computer network.

With every office and organization seeking to become computerized, the demand for data entry operators/analysts is on a rise. Data entry operators/analysts usually work in an indoor, office setting using a computer and other electronic machines. To be in the profession of data entry/analysis, one has to have computer literacy, high typing speed, organization skills, concentration skills, communication skills and an ability to sit for long periods of time entering and computing data.

Objectives of the Course:

In this course, the students will be introduced to the fundamental concepts of digital documentation, digital spreadsheet, digital presentation, database management and internet security.

The following are the main objectives of this course:

To familiarize the students with the world of IT and IT enabled services.

To provide an in-depth training in use of data entry, internet and internet tools.

To develop practical knowledge of digital documentation, spreadsheets and presentation.

To enable the students to understand database management system and have updated knowledge about digital record keeping.

To make the students capable of getting employment in Private Sector, Public Sector, Ministries, Courts, 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 Electronic Spreadsheet

The concept of Databases

Internet Technologies

Salient Features

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, 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, numerical and literacy skills. These skills can help one expand into a new career path in the future.

Scheme of Units

This course is a planned sequence of instructions consisting of units meant for developing employability and vocational competencies of students of Class IX opting for skill subject along with other education subjects.

The unit-wise distribution of hours and marks for class IX is as follows:

INCORPORATES NEP 2020

Created with new dimension of Joyful Learning along with completely mapped parameters of National Education Policy, 2020

DIGITAL RESOURCES

Animated Audio & Video eBook

Works offline after download

Chapter Audio & Video

Interactive Exercises with Answer Checks & Subjective Questions

Features like Spotlight, Zoom Sliders, Add Notes, Highlighter & Pencil on the eBook

Student Worksheet

Software Download Link

Visit www.touchpadwebsupport.com and enter the credentials.

Table of Contents

Part A Employability Skills

Unit-1 Communication Skills-I

Chapter-1 Communication Skills

• Importance of Communication

• Elements of Communication Cycle

• Methods of Communication

• Perspectives In Communication

• Writing Skills

Unit-2 Self Management Skills-I

Chapter-2 Self Management

• Positive Results of Self-Management

• Strength and Weakness Analysis

• Self Confidence

Unit-3 ICT Skills-I

Chapter-3 Information & Communication Technology

• Role and Importance of ICT

• ICT Tools

• What is a Mobile App?

• Internet and its Application

• Social Media

• Computer

• Components of CPU Box

• Expansion Card

• Ports

• Software

• Types of OS

• Working with Windows Operating System

• Working with Boss Linux

• Using a Computer

• Operations on a Computer

• Internet

Chapter-4 e-Mail

• e-Mail Services

• Create an e-Mail Id

• Compose and send e-Mail Message

• Managing Folder

• Reading an e-Mail

• Replying to an e-Mail

• Forwarding an e-Mail

Unit-4 Entrepreneurial Skills-I

Chapter-5 Entrepreneurship

• Types of Businesses

• Types of Businesses Found in our Community

• Characteristics of Entrepreneurs

• Importance of Entrepreneurship

• Role and Rewards of Entrepreneurship

• Limitations of Entrepreneurs

Unit-5 Green Skills-I

Chapter-6 Green Skills

• Natural Resources

• Green Economy

Part B Subject Specific Skills

Unit-1 Introduction to IT – ITeS Industry

Chapter-1 Introduction to IT & ITeS

• BPO

• Business Process Management

• Applications of IT

Unit-2 Data Entry and Keyboarding Skills

Chapter-2 Data Entry & Keyboard Skills

• Keyboard

• Mouse

• Touch Typing Technique

• Rules of Touch Typing

• Begin Lessons

• Background and Text Colour

• Result Interpretation

• Student Statistics

• Lesson Editor

• Working with Lesson

Unit-3 Digital Documentation

Chapter-3 Digital Documentation: Word Processor

• Features of a Word Processor

• Commonly used Word Processors

• Working with ‘Writer’

• Find & Replace

• Jumping to the Page Number

• Non-printing Character

• Spelling and Grammar

Chapter-4 Formatting in Word Processor

• Character Formatting

• Changing Case

• Paragraph Formatting

• Bullets and Numbering

• Header and Footer

• Page Number

• Inserting Symbol

• Inserting Date & Time

• Page Break

• Inserting Pictures

• Inserting Shapes

• Mathematical Expressions

• Dividing Pages into Column

• Tables

Chapter-5 Mail Merge

• Introducing Mail Merge

• Track Changes

Unit-4 Electronic Spreadsheet

Chapter-6 Working with Spreadsheet

• Features of Spreadsheet Package

• Parts of a Workbook Screen

• Types of Data

• Creating a Workbook

• Entering Data in Worksheet

• Moving in a Worksheet

• Range of Cell

• Saving a Workbook

• Opening an Existing Workbook

• Printing a Worksheet

• Working with Workbook

• Navigation

• Editing Contents in a Worksheet

• Formula

• Operator

• Entering Function in a Cell

• Common Errors

Chapter-7 Formatting Cells in Spreadsheet

• Changing Font

• Alignment

• Format Cell

• Auto Fill

• Custom List

• Charts and Graphs

• Making a Chart

Unit-5 Digital Presentation

Chapter-8 Working with Presentation

• Uses of Presentation Package

• Features of Impress

• Beginning with ‘Impress’ In Computer

• Slide Layouts

• Making Presentation

• Inserting Information in the Presentation

• Saving the Presentation

• Closing Impress Presentation File

• Using Help

• Template

• Viewing the Presentation

• Editing and Formatting a Slide

Chapter-9 Digital Slides

• Inserting a Slide

• Inserting a Duplicate Slide

• Copy and Move Slides

• Copying and Moving Content

• Zoom in and Out

• Working with Table

• Image in Presentation

• Formatting Images

• Drawing Graphic Object

• Grouping Object

• Animation in Presentation

Part C Practical Work

Practical Work

Viva Voce Questions

Projects (Hints for Part D)

Glossary

Sample Question Paper

PART-A

EMPLOYABILITY SKILLS

Unit-1 COMMUNICATION SKILLS-I

1

COMMUNICATION SKILLS

Ways of Expression is a characteristic that differentiates living things from non-living things.

All living beings need to express themselves to fulfill the basic needs of life. Humans express themselves in many ways. The ability to express is far ahead in humans as they express with the most important tool of communication i.e., language.

The word ‘Communication’ comes from the Latin word ‘Communicare’ which means ‘to share’.

We perform various activities in our daily lives in which we share or exchange our thoughts, ideas, information, knowledge, etc. In simple words, communication is a process by which we can express our views, emotions, information and ideas. It is a way of transferring our messages to another person or to a group. Communication is the sharing of information, facts, ideas, opinions or emotions between two or more individuals.

IMPORTANCE OF COMMUNICATION

Communication is an important tool that lets us share our thoughts, emotions and ideas in an understandable, clear and efficient way. It helps us to inform, share knowledge, express feelings and influence others.

Humans’ ability to communicate (through a language) has provided great benefits in the all-round development of mankind. A simple conversation might be considered a mere transfer of information but an influencing conversation can help you in achieving your academic or your career goals and help in developing your relationships. Hence, there is a difference between ‘to inform’ about something and ‘to influence’ about something. Communication skills are required to:

Inform: Sharing of facts and information with others.

Influence: Counselling, negotiating or simply talking to someone to help reduce the stress can make a change in other person’s outlook.

Express Feelings: Talking and expressing your feelings is considered a healthy way to interact with family and friends.

ELEMENTS OF COMMUNICATION CYCLE

Communication involves a two-way exchange of information, i.e., giving and receiving information. Speaking and writing are modus of giving information whereas listening and reading are modus of receiving information.

Communication Cycle has different elements which are divided into the following categories:

Sender: In case of a written message the person who introduces or sends the message is known as a sender. The sender sends a message or gives and can even ask for information. This is called Encoding.

Ideas: An idea is a plan or thought which may be presented as an opinion.

Communication Channel: It refers to a medium (like air, water, satellite, etc.) or a path such as a phone or face-to-face talking or written message can be used through which the message is transmitted to the person or an audience.

Receiver: It might be a person or a group of people who is the reader, listener or observer of the message. The receiver replies to the sender called Decoding of a message.

Feedback: When a receiver communicates his/her response back to the sender, the process is called feedback.

METHODS OF COMMUNICATION

You might have used different methods of communication in your daily life. There must be some methods while playing with your friends such as showing gestures, giving indications like waving, drawing images, and sketches, etc. to depict a particular situation. Such different methods of communication are classified as:

Verbal Communication

It is a common method of communication that enables direct understanding and interpretation. Verbal communication uses words to express.

Types of Verbal Communication

Following are the types of verbal communication:

Oral or Spoken Communication: When communication is established through telephonic conversation, face-to-face conversation, etc.

Written Communication: When communication is established using written or typed messages in the form of an e-mail, SMS or by using any other format including photos, videos, music, etc.

Advantages of Verbal Communication

Following are the advantages of Verbal Communication:

It is a fast method of communication.

It provides you with a quick response.

It helps you to understand the mood of the other person.

It is more reliable than other conventional methods of communication.

The speaker and the listener keep changing replies one after another, as they communicate in real-time.

Disadvantages of Verbal Communication

Following are the disadvantages of Verbal Communication:

It fails to fill the gap of cultural differences between the sender and receiver if there is a language barrier.

The different languages spoken all over the world have different accents and use different colloquial phrases which cause confusion in the receiver’s mind.

As there is not much time, the delivery may be misinterpreted if the receiver does not understand instantly.

Non-Verbal Communication

As we know, all living things communicate, the animals communicate through different types of sound, smell, sign, etc. In non-verbal communication, words are not used to communicate as the sender’s message is conveyed without using words. Non-verbal communication includes symbols, gestures, eye contact, handshake, facial expressions, body language, etc. For example:

A non-verbal way of communication can make our message stronger and it may also help to adjust our behaviour according to the listener’s reaction. It mostly helps in situations when we are unable to send a proper message verbally. Suppose you are in a room full of noise, in this case, you may easily opt to send a non-verbal message by using your hand movements.

We don’t realise the importance of non-verbal communication. We spend about 75% of our waking hours in communicating out of which 80% is non-verbal in which our expressions and movements are used.

Types of Non-Verbal Communication

Let us now learn about various types of Non-Verbal Communication.

Advantages of Non-Verbal Communication

Following are the advantages of non-verbal communication:

By using visual, audio-visual and silent means of non-verbal communication, the message can be easily presented.

Facial expressions and gestures are used to convey messages so that they can be easily understood by illiterate people.

Non-verbal communication reaches the receiver very fast. So, it reduces the wastage of valuable time of the communicator.

Disadvantages of Non-Verbal Communication

Following are the disadvantages of Non-Verbal Communication:

Non-verbal communication is unclear and imprecise since, in this communication, there is no use of words or language which expresses clear meaning to the receiver.

Long conversation and necessary explanations are not possible.

Sometimes, non-verbal communication is difficult to understand.

Visual Communication

‘Visual Communication’ is another method in which ideas are conveyed in the visual form which can be seen in the form of images or pictures. In such communication, there is no use of language. It is also considered the oldest form of communication. Visual communication uses images, drawings, signs, graphics, typography, etc. It is an easier method of communication.

Advantages of Visual Communication

Following are the advantages of Visual Communication:

Using visual communication, the attention of the audience can be grabbed.

Information can be delivered directly using visual aids.

It is more flexible.

Disadvantages of Visual Communication

Following are the disadvantages of Visual Communication:

Developing visual communication is time-consuming.

Visual methods of communication are very expensive.

Visual communication is often called incomplete because it usually requires other methods of communication to pass the complete message.

PERSPECTIVES IN COMMUNICATION

Perspective means having a predetermined idea about someone, in terms of behaviour. It is a way of thinking in which people develop their own views regarding a person which affects maintaining a perfect communication between them. For example: Communication between teacher and student.

Factors Affecting Perspective in Communication

There are certain barriers that stop us from communicating clearly, such as hesitation to share a message. These factors affect the perspective in communication:

WRITING SKILLS

When we talk about writing content for a particular topic, ideas start generating in our consciousness. This sudden reaction of our mind results in the formation of sentences, which communicates the thought. There are certain aspects through which we can improve our writing skills, like:

Phrases

It can be a short or a long sentence and give a complete meaning when attached to a principal clause or an independent sentence. Hence, a phrase may also be explained as a dependent sentence, for example: after the class is a phrase and I will meet you is a principal clause.

By joining together these sentences we get I will meet you after the class.

Active and Passive Voice

We speak many sentences in our day-to-day life but we don’t realise the diversity of sentences that we use while speaking. It can be seen through the following examples:

I taught you.

You are taught by me.

We notice that there is a difference between both sentences. In the first sentence, the subject

‘I’ is the doer of the action ‘taught’ while in the second sentence, the subject ‘You’ is the receiver of the action ‘taught’. In this way, the first sentence is in ‘Active Voice’ while the second sentence is in ‘Passive Voice’.

I taught you (Active voice).

You are taught by me (Passive voice).

In ‘Active Voice’, the subject performs the action stated by the verb. In ‘Passive Voice’, the subject is acted upon by the verb.

Read the following Active and Passive statements:

Notice the difference between the sentences in each set of examples given above. The places of subject and object change in the above set of sentences. A subject is a person or thing that the sentence talks about. An object is a person or thing that is affected by the action of the verb.

So, in the first sentence of the first set, Shreya is the subject. She becomes the object in the second sentence of the set. The object of the first sentence i.e., the novel becomes the subject in the second sentence. The first sentence shows the direct expressions (Active Voice), whereas the second sentence expresses the indirect voice combined with ‘by’ (Passive Voice).

Generally, the first type of sentence construction (Active Voice) is preferred.

Consider some examples of Active and Passive Voice:

Active I : She faxed her application for a new job.

Passive I : The application for a new job was faxed by her.

Active II : The two kings are signing the treaty.

Passive II : The treaty is being signed by the two kings.

Active III : The wedding planner is making all the reservations.

Passive III : All the reservations are being made by the wedding planner.

In Active Voice, the action expressed in the verb is performed by the subject.

Examples:

He ate an apple.

Ravi is playing football.

Prisha is reading the book.

In Passive Voice, the action expressed in the verb is received by the subject.

Examples:

An apple was eaten by him.

Football is being played by Ravi.

The book is being read by Prisha.

Kinds of Sentences (According To Their Purpose)

If you notice the sentences which you speak during a conversation with your friend, you will find it is not always the same kind of sentence, sometimes it is in the form of a question or in the form of an assertion, order, request or sudden reaction, for example:

What are you doing? (Question)

You are a nice boy. (Assertion)

Get out of the class. (Order)

Please switch off the fan. (Request)

Alas, I am ruined! (Reaction)

Such sentences can be divided into different categories:

Assertive or Declarative sentences

Interrogative sentences

Exclamatory sentences

Imperative sentences

The above-given sentences can now be classified as:

What are you doing? (Interrogative sentence)

You are a nice boy. (Assertive or Declarative sentence)

Get out of the class. (Imperative sentence)

Please switch off the fan. (Imperative sentence)

Alas, I am ruined! (Exclamatory sentence)

Parts of Sentence

A sentence may be described as a group of words that have a subject and a predicate. The construction of a basic sentence uses elements, such as Subject, Verb and Object. ‘Subject’ is a person or thing which does an action, while a ‘Verb’ describes the action done by the subject, which is received by an ‘Object’.

Types of Object

There are two types of objects in a sentence, direct and indirect. The objects which are directly ‘acted on’ by the verb are called direct objects. A direct object always answers the question ‘what’, for example, if the question is what do you eat?, then the answer will be ‘bread’, here bread is the direct object because it answers the question ‘what’.

The