Source document: https://docs-lawep.s3.us-east-2.amazonaws.com/1697806341763.pdf (India)
STUDY MATERIAL OF EMPLOYABILITY SKILL Class - XII Part A Employability Skills (XII) S.No Units 1.

Unit 1: Communication Skills – IV 2.

Unit 2: Self-management Skills – IV 3.

Unit 3: Basic ICT Skills- IV 4.

Unit 4: Entrepreneurial Skills – IV 5.

Unit 5: Green Skills – IV Total Duration (Hrs.)

Marks 10 13 9 6 16 6 50 Unit 1: Communication Skills - IV Learning Outcome 2 MKS 1.

Describe the steps to active listening skills Theory ( Periods) 1.

Importance of active listening at workplace 2.


Steps to active listening 2.

Demonstrate basic writing skills 1.

Writing skills to the following:  Sentence  Phrase  Kinds of Sentences  Parts of Sentence  Parts of Speech  Articles  Construction of a Paragraph Total Practical ( Periods) 1.

Demonstration of the key aspects of becoming active listener 2.

Preparing posters of steps for active listening 1.


Demonstration and practice of writing sentences and paragraphs on topics related to the subject Total Duration 6 7 13 Unit 2: Self-management –IV Learning Outcome Theory ( Periods) Practical ( Periods) Total Duration (11 Periods) 1.

Group discussion on identifying needs and desire 2.

Discussion on sources of motivation and inspiration 1.

Demonstrate the knowledge of different personality types 1.

Describe the 1.
Describe the 1.

Finding and listing various factors influencing self- motivation 2.

Describe the basic personality traits, types and disorders motives (needs and desires); 2.

Finding sources of motivation and inspiration (music, books,activities);expansi ve thoughts; living fully in the present moment;dreaming big 1.

Describe the meaning of personality 2.

Describe how personality influence others 3.

Describe basic personality traits 4.


Describe common personality disorders- paranoid, antisocial, schizoid, borderline, narcissistic, avoidant, dependent and obsessive Total 4 5 9 Unit 3: Information & Communication Technology – IV Learning Outcome Theory ( Periods) 1.

Perform tabulation using spreadsheet application 1.

Introduction to spreadsheet application 2.

Spreadsheet applications 3.

Creating a new worksheet 4.

Opening workbook and entering text 5.

Resizing fonts and styles 6.


Copying and moving 7.

Filter and sorting 8.

Formulas and functions 9.

Password protection.

10.

Printing a spreadsheet.

11.

Saving a spreadsheet in various formats.

Total Duration 3 Practical ( Periods) 1.


Demonstration and practice on the following:  Introduction to the spreadsheet application  Listing the spreadsheet applications  Creating a new worksheet  Opening the workbook and enter text  Resizing fonts and styles  Copying and move the cell data  Sorting and Filter the data  Applying elementary formulas and functions  Protecting the spreadsheet with password  Printing a spreadsheet  Saving the spreadsheet in various formats 2.
Prepare presentation using presentation application 1.

Introduction to presentation 2.

Software packages for presentation 3.

Creating a new presentation 4.

Adding a slide 5.

Deleting a slide 6.

Entering and editing text 7.

Formatting text 8.

Inserting clipart and images 9.

Slide layout 10.

Saving a presentation 11.

Printing a presentation document.

1.


Demonstration and practice on the following:  Listing the software packages for presentation  Explaining the features of presentation  Creating a new presentation  Adding a slide to presentation.

 Deleting a slide  Entering and edit text  Formatting text  Inserting clipart and images  Sliding layout  Saving a presentation  Printing a presentation document 12.

2.
2.

Total 3 6 Practical Total Duration (16 Periods) Unit 4: Entrepreneurship Development – IV Learning Outcome Theory ( Periods) 1.

Identify the general and entrepreneurial behavioural competencies 2.

Demonstrate the knowledge of self- assessment of behavioural competencies 1.

Barriers to becoming entrepreneur 2.


Behavioural and entrepreneurial competencies – adaptability/decisiv e ness, initiative/ perseverance, interpersonal skills, organizational skills, stress management, valuing service and diversity 1.
Entrepreneurial competencies in particular : self - confidence, initiative, seeing and acting on opportunities, concern for quality, goal setting and risk taking, problem solving and creativity, systematic planning and efficiency, information seeking, persistence, influencing and negotiating, team building Total ( Periods) 1.

Administering self- rating questionnaire and score responses on each of the competencies 2.

Collect small story/ anecdote of prominent successful entrepreneurs 3.
Identify entrepreneurial competencies reflected in each story and connect it to the definition of behavioural competencies 4.

Preparation of competencies profile of students 1.

Games and exercises on changing entrepreneurial behavior and development of competencies for enhancing self- confidence, problem solving, goal setting, information seeking, team building and creativity 8 8 16 Unit 5: Green Skills – IV Learning Outcome Theory ( Periods) Practical ( Periods) Total Duration (06 Periods) 1.
Identify the role and importance of green jobs in different sectors 1.

Listing of green jobs and preparation of posters on green job profiles 2.

Prepare posters on green jobs.

1.

Role of green jobs in toxin-free homes, 2.

Green organic gardening, public transport and energy conservation, 3.

Green jobs in water conservation 4.

Green jobs in solar and wind power, waste reduction, reuse and recycling of wastes, 5.

Green jobs in green tourism 6.

Green jobs in building and construction 7.


Green jobs in appropriate technology 8.

Role of green jobs in Improving energy and raw materials use 9.

Role of green jobs in limiting greenhouse gas emissions 10.

Role of green jobs minimizing waste and pollution 11.

Role of green jobs in protecting and restoring ecosystems 12.

Role of green jobs in support adaptation to the effects of climate change Total 6 6 What is communication?
Communication is the act of conveying meanings from one entity or group to another through the use of mutually understood signs, symbols, and semiotic rules.

*The following figure represents types of communication Learning objectives of Effective communication 1.

Development of Interpersonal Skills 2.

To express effectively with maximum efficiency Communication skills are beneficial in and out of the workplace.
Having the ability to clearly communicate instructions, ideas and concepts can help you find success in any career.

With practice, anyone can enhance their communication skills.

One of the most critical skills in effective communication is Active listening.

Developing this soft skill will help build and maintain relationships, solve problems, improve processes and retain information such as instructions, procedures and expectations.
1 Communication skills – XII Why is active listening important in the workplace?

Whether we are seeking a new job opportunity, striving to earn a promotion or working to improve in our current role, improving our active listening skills will help us succeed.

Much like critical thinking and conflict resolution, this soft skill will help to improve our personality..

Here are several benefits of being an active listener:  It helps us build connections.
2 Communication skills – XII Active listening helps others feel comfortable sharing information with us.

When we demonstrate our ability to sincerely listen to what others have to say, people will be more interested in communicating with us on a regular basis.

This can help open up opportunities to collaborate with others, get work done quickly or start new projects.

All of these things can help lead us to success in our career.

 It helps you build trust.


When people know that they can speak freely with us without interruptions, judgment or unwelcome interjections, they’ll be more likely to confide in us.

This is especially helpful when meeting a new customer or business contact with whom we want to develop a long-term working relationship.

 It helps you identify and solve problems.

Actively listening to others will help you detect challenges and difficulties others are facing, or problems within projects.
The more quickly you’re able to spot these issues , the sooner you can find a solution or create a plan to address it.

Four Steps to Active Listening Active listening requires four discrete steps.

CONTACT—connect with the participant who is contributing; eye contact, open posture, and non - verbal responses.

ABSORB—take in all aspects of the spoken message, implicit and explicit and non - verbal clues.

Do not judge or evaluate.


REFLECTIVE FEEDBACK—mirror, reflect, or give feedback on what you have heard and why the contributor claims to be valid.

CONFIRM—receive confirmation from the speaker that you heard the participant’s message accurately.

If not, start the method over again from the beginning by having the speaker restate their view.
Demonstrating Active Listening skills 1.The Storytelling Listening Game In this game, the teacher starts a story with a beginning phrase, and then each child in the classroom adds one word to the story in turn.

Students must be active participants and follow the story closely so that when their turn comes to add a sentence, the story will make sense.

Another way to practice this is by playing a traditional game of Telephone where a message is passed around the room to see if it stays the same.
Active Listening Skills(game) Directions: Read and listen to the statements below.

After reading and listening to the teacher, read the statements, write a response for each statement, demonstrating reflective listening on part of you as listener.

Your answer should demonstrate the response.

Remember a dialogue is a conversation between two people.

One person sends a message (the statement).

The person who receives the message then responds (your written response).
Make sure to include all of the points each speaker makes.

Do not assume any facts.

(Note: offering reasons, solutions or excuses for behaviour is not part of the reflective listening response and must be avoided.

In each of your responses, underline all words that show you will restate the points made by the original speaker.

Look at the example below.

Note each part of the sender’s statement is also mentioned in the reflective listening statement.
• (Statement) I get furious with him when he says things that suggest that I don’t takegood care of the kids.

• (Active Listening Response) What I think I hear you saying is, that you feel furious when he implies that you’re not a good caregiver for your kids.

From the statements listed below, select a different phrase to use for each of the dialogues you need to complete.
• “What I think I hear you saying is…” • “In other words, you think that…” 3 Communication skills – XII • “Correct me if I’m wrong, but aren’t you saying…” • “Let me review what I’ve heard you say.

Please correct me if I leave anything out.” • “I hear you saying…Is that right?” 1.

Father to Son/Daughter: “I am sick and tired of you asking to borrow the car/bike when you haven’t completed your homework or your chores, you leave your room in a total wreck and you have been disrespectful to your family.
You need to grow up and learn to show some respect.

Response:_______________________________________________ 2.Teacher to Student: “I am very concerned about your lack of progress in this course.

You haven’t been keeping up with your work and the work that you have been submitting is of poor quality.

You are a senior and this course is a graduation requirement.
If you don’t start turning in your work, you are going to fail this course and possibly miss graduation.” Response:________________________________________________________ 3.

Friend to Friend: I just don’t know what to do about my parents.

It seems like they just don’t understand me.

Everything I like seems to go against their values, and they just won’t accept my feelings as being right for me.

It’s not that they don’t love me, they do, but they just don’t accept me.
Response:______________________________________________ Designing poster on steps of Active Listening Case Studies – Ask students to do some research on good communicators according to them.

List out their names.

They can work in pairs.

List the good aspects of these communicators which make them influential orators.

Students present their work in front of classmates and give a chance for questions.

Self -check on the qualities students possess so as to become good and effective communicators.
List out the ones they lack and need to build up to be an effective communicator.

This activity gives a scope for active listening as well as skills that each student has to develop to improve their communication skills.

Writing Skills What is Writing?

Writing is a form of communication that allows students to put their feelings and ideas on paper, to organize their knowledge and beliefs into convincing arguments, and to convey meaning through well-constructed text.
In its most advanced form, written expression can be as vivid as a work of art.

1.Sentences The main focus here is to improve basic sentence composition skills.

One can review the types of sentences and the functions of their component parts listed below.

Simple, compound, and complex sentences a) Simple sentence A simple sentence is one independent clause that has a subject and a verb and expresses a complete thought.
There are some important requirements for a simple sentence:  Must have a subject and a verb.

4 Communication skills – XII  Must express a complete thought.

 Must only have one clause.

Examples I am out of paper for the printer.

  Will you help me with the math homework?

b) Compound Sentence A compound sentence allows us to share a lot of information by combining two or more related thoughts into one sentence.
It combines two independent clauses by using a conjunction like “and.” This creates sentences that are more useful than writing many sentences with separate thoughts.

Example of Compound Sentences We use compound sentencesquite often.

.

Here are some examples: the independent clause is green, the second is purple, and the conjunctions are orange:1.I drove to the office, and then I walked to the cabin.
c) Complex sentence – A complex sentence is a sentence that combines one independent clause with at least one dependent clause.

Example  Although Rohan had some doubts, he found the courses very useful.

The above example is a complex sentence: it has a dependent clause (a subject ' Rohan' and a verb 'had'), followed by an independent clause (subject 'he' and a verb 'found') and forms a complete thought.

 Computers have come a long way since they first came to the market.
This example begins with an independent clause (subject 'computers' and verb 'have come') that forms a complete thought, followed by a dependent clause (subject 'they' and a verb 'came').
https://study.com/academy/lesson/types-of-sentences-simple-compound-complex.html#lesson The link mentioned above will further help the students to strengthen their concept on the above-mentioned topics Writing skills Activity Mini sagas Sometimes when we ask students to write a composition, they spend very little time in the important editing stage.

In this lesson students will do a couple of ‘short writing’ activities with the focus on editing and accuracy.
A mini saga is a piece of writing with exactly fifty words.

It has to tell a story, has a beginning, middle and an end.

Mini sagas were ‘invented’ by the Science fiction writer Brian Aldiss, who thought it would be fun and challenging to tell/write a story in very few words.

Students work alone to write a mini saga.

First, they should spend few minutes thinking of what they are going to write about.
The teacher will discuss few ideas on the board to help: A description of a favourite object, place, person; joke, something funny or scary that happened with the student; a synopsis of a film they have watched or a book they have read; a letter to an old school teacher, friend or relative.

Students write their first draft, then spend time editing, cutting out or adding words until the text has exactly 50 words.
5 Communication skills – XII The above figure is an example of a Mini saga It will help students to learn how to edit their writing and understand that ‘quality’ is more important than ‘quantity’ when it comes to writing A worksheet can be taken up in the class to test the conceptual clarity.

Worksheet Identify the following sentences as simple, compound or complex.

1.

The production of a single pound of honey requires nectar from approximately two million flowers.

2.
2.

The vibrant trumpet-shaped blooms of the trumpet vine make it ideal for attracting humming birds.

3.

We can watch the boxing match, which will be broadcasted at nine o'clock, or we can view the documentary about the greatest innovations of the twenty-first century.

4.

Russia has a variety of natural resources, including oil, natural gas, timber, iron ore, copper and lead.

5.

The right hemisphere of the human brain typically controls muscle movement on the left side of the body.

6.
6.

Aaron has an unconventional swing, but he manages to drive the ball farther than some professional golfers.

7.

During last night's thunderstorm, a flurry of tiny hailstones danced across the roof of our house.

8.

An avid reader, Thomas attends weekly book club meetings, and he finishes several novels every month.

2.Phrases - Phrases are a group of words that work together to communicate an element of speech.
Types of phrases 1.Noun Phrase A noun phrase is any noun or pronoun along with its modifiers.

Example –   The school children Yesterday’s newspaper 2.

Verb Phrase A verb phrase is any number of verbs working together.

6 Communication skills – XII Example Had been sleeping   Will contact  May have written 3.

Prepositional Phrase A prepositional phrase always starts with a preposition and ends with a noun or pronoun (and its modifiers) that is called the object of the preposition.
Example  Through the wheat field(here the Preposition: through andObject of the preposition: the wheat field) Some more examples of prepositional phrases:   During the year Despite complaints 4.

Verbal Phrases There are three types of verbal phrases: participial phrases, gerund phrases, and infinitive phrases.

Each is explained below.

a) Participial Phrase Participial phrases start with either a present or past participle.

Here are some examples of each.


Phrase with present participles:  Watching silently Phrases with past participles:  Driven to succeed b) Gerund Phrase A gerund phrase is a present participle (and its modifiers) that acts like a noun.

It can take on a variety of jobs in the sentence.

Here are a couple of examples:   Infinitive Phrase Practicing helped a lot.

(subject) I love reading.


(direct object) c) An infinitive phrase is a group of words that uses the infinitive and its modifiers: Example   To sing To walk all that way 4.

Appositive Phrase An appositive phrase is a phrase that renames an earlier noun or pronoun My best friend, Nick Palacio, loves scuba diving.

We watched Sirius, the brightest star in the sky 5.

Absolute Phrase Absolute phrases are the trickiest to identify.
These phrases are not closely connected to rest of the sentence; they don’t describe a specific word, but modify the whole sentence.

They add extra information and are usually separated by commas (or dashes).

7 Communication skills – XII Example The semester finished; Karen sold all her textbooks.

Absolute phrase: The semester finished A worksheet can be taken up in the class to further build the concept For each sentence, Identify the phrase and state its kind.

1.

He was a man of great wealth.

2.


The principal was an old man of friendly disposition.

3.

The workers belonged to a tribe dwelling in the hills.

4.

There I met a boy with red hair.

5.

Only a man with plenty of money can buy a car of such beauty and power.

6.

He was a young man of great promise.

7.

He wore a turban made of gold.

8.

He ran with great speed.

9.

You can buy it in all places.

10.

He replied in a very rude manner.

11.

How does he live without any worries?


Writing skills - Branding and Brand names It explores the theme of branding and brand names.

Students will have an opportunity to read and discuss the context of a text and create and brand their own imaginary product.

It involves some discussion, reading and writing.

It explores the area of 'brands' and the associations we have with particular brand names.

Students will rank their favourite brand names and discuss what they like/dislike about them.
They will read and discuss the context of a text about brand naming and complete related vocabulary building exercises.

Lastly, students will create and brand their own imaginary product which they will present to rest of the class.

8 Communication skills – XII Example Task 1: Reading The name is the most important element of a successful brand.

Packaging changes, advertising changes, products even change but brand names usually do not change.

Where do great brand names come from?


For example, McDonald’s is a family name, Adidas was created from the inventor’s name Adi Dassler, Volvo means “to roll” in Latin.

Task 2: Discussion Discuss the following questions in pairs: 1.

Why are brand names important?

2.

Name three different sources of brand names.

3.

Do you think brands are important?

Why?

4.

Do you have a favourite brand?

What is it and why do you like it?


Task 3: Mini write up In pairs students will invent a new product(imaginary) and give it a name.

They will think about the following points: • What is special or unique about their product?

• Why would people want to use or buy it?

• How does the name relate to the product?

Once they have chosen a name for their product, they will prepare a short write up to be presented in front of the class.
Here are some useful phrases that may help them with their presentation: • We would like to introduce our new product… • We chose the name… because… • You can use it to…  Some of the idea for a new product A digital watch with a built-in mobile phone and mini-computer A new digital homework personal organiser3.Kinds of sentences – In writing and speaking, there are four basic kinds of sentences:  Declarative sentences 9 Communication skills – XII Interrogative sentences Imperative sentences Exclamatory sentences    a) A declarative sentence is the most basic type of sentence.
Its purpose is to relay information, and it is punctuated with a period.

For example: I walked home.

b) c) d) Interrogative sentences interrogate, or ask questions.

These are direct questions, and they are punctuated with a question mark.

For example:  Why haven’t you completed your work?

Exclamatory sentences are like declarative sentences in that they make a statement instead of asking a question, but their main purpose is to express strong emotion.
They are easily recognized because they end in an exclamation point instead of a period: For example  Wow,he just got an appraisal!

Imperative sentences do not simply state a fact but rather tell someone to do something.

These can be in the form of friendly advice, basic instructions or more forceful commands.

For example:  Turn left at the bridge.


Using different types of sentences to add variety to writing Writing skill - E - mail writing Activity Students will learn the rules of writing e mails and will compose and send an e - mail.

The main focus of this lesson will be on writing semi-formal e - mails.

Example  The students will send an e - mail to a language school offering part - time language courses.
Some hints a) Do you do a part - time course for school students, which helps them with their essay writing skills?

b) What would be the duration of courses and schedule of classes?

c) d) e) Which are the available courses in after school hours?

f) Will they help me to improve my communications skills?

g) What is the actual cost of the course?

Do you offer any scholarship?

*I’m hoping to join the course soon, so if you can get back to me as soon as possible, it would be great.

Thanks for your help.


Format of a Semi formal E- mail 10 Communication skills – XII This will help them to study the difference between writing a Formal, informal and semi-Formal e - mail writing using different kind of sentences.

4.. Parts of a sentence- Every sentence can be broken into two parts a) Complete Subject b) Complete Predicate The complete subject consists of simple subject and its modifiers  The complete predicate is made up of verb and its modifiers.
The subject of a complete sentence is who or what the sentence is about, and the predicate tells about that subject.

Yesterday, after lunch the students were complaining about the short recess.

“The students” is the subject (red) of the sentence.

The predicate always includes verb, and tells something about the subject; in this example, the students (purple)“were complaining about the short recess.” After explaining the concept of parts of sentence, an activity will be taken up to strengthen the topic.
Writing skills - Creating a professional portfolio Finding employment can be challenging for anyone, but the job market can be especially tough for recent college graduates/ Undergraduates, people re-entering the workforce after a gap , or someone who has been in a position for a long time.

Competition is stiff; the market is filled with other strong job candidates, too.

So how can students increase their chances of getting a great job in the field they love?
For almost everyone, it starts with a resume (The following Flowchart 11 Communication skills – XII will help the students to create a professional resume) 12 Communication skills – XII (Sample of Resume writing format) The following link will further help the students to understand how to create professional resume better (https://youtu.be/VjdlraonW2s) Speaking skills (Interview skills) 13 Communication skills – XII Good interview skills are crucial for every high school student to learn.
Any job they apply for will involve some sort of interview process, so students need to be prepared.

To teach interview skills in high school, we should follow these four steps:     Introduce interview skills Talk about why good interview skills matter Explore what good job interview skills look like Group project A practical, and interactive activity for participants to learn how to prepare for a job interview.

This activity will help them avoid some common mistakes before or during a job interview.
 Warm- up Activity: Words “ Interview” will be written on the Whiteboard/blackboard which will be followed by discussion..

The participants will be subjected to questions like: a.

When was the last time you had an interview?

b.

Did you have good or bad experiences?

c. Do you have any interview- related stories?

d. Brainstorm some common mistakes before or during an interview and write them down.
A small video clip will be played for a few times and then the Students will prepare five questions of their own on what they should and 14 Communication skills – XII should not do during an interview .

For example, “What should you prepare for your interview?” “What should you do at the interview?” “What shouldn’t you do at the interview?” On the whiteboard, write the following questions and ask the students to repeat with you a few times, and then pair the students to do the questions and answers.
(Optional: The teacher can write down the participants answers on the white board.)

A.

What should you do before the interview?

B.

What should you do at the beginning of the interview?

C. What should you do during the interview?

D. What shouldn’t you do at the interview?

… E. What should you do after the interview?


https://www.youtube.com/watch?v=S3l7COBI77U Activity ( Group Project) All about me One of the first steps in an application process is telling the school /college/company a little bit about yourself.

The students write a paragraph about themselves giving whatever information they think a potential school or employer would want to know including their education.
Then, they will write a second version of their paragraph that leaves out some of the information in the first and also includes other information not in the first version.

Collect students’ papers and choose some of the best papers to share with the class.

Have students work in pairs to look at the two versions of ”about me” paragraph with each person in possession of one version.
Without reading each other’s copies, the students will talk until they can point out which information each version has that is different from their partner’s and what information each version is lacking.

5.

Parts of speech- A category to which a word is assigned in accordance with its syntactic functions.

In English the main parts of speech are noun, pronoun, adjective, , verb, adverb, preposition, conjunction, and interjection.
The following figure represents eight parts of speech 15 Communication skills – XII 1.

NOUN- A noun is the name of a person, place, thing, or idea.eg - London,Flower,Happiness 2.

.PRONOUN- A pronoun is a word used in place of a noun.eg - She, we,they, it 3.

VERB- A verb expresses action or being.eg - Jump ,is,become 4.

ADJECTIVE -An adjective modifies or describes a noun or pronoun.eg - Pretty,old 5.
ADVERB -An adverb modifies or describes a verb, an adjective, or another adverb.eg - Gently, extremely 6.

PREPOSITION -a preposition is a word placed before a noun or pronoun to form a phrase modifying another word in the sentence.eg - By,with, 7.

CONJUNCTION -A conjunction joins words, phrases, or clauses.

eg - The young girl brought me a very long letter from the teacher, and then she quickly disappeared.

8.

INTERJECTION - An interjection is a word used to express emotion.eg.- Oh!

Wow!
Wow!

The following link will help to reinforce the concept (https://www.youtube.com/watch?v=v9fCKTwytJA) Writing skill Activity Adopt a word Students will be given templates with a heading Word Meaning Part of speech Example of usage    The students choose a word that they would like to adopt and do some research on it using the template as above.

Each student then gives a short presentation on his or her adopted word until the students get a chance.
The words are then stuck to a large paper chart on the wall In between, quizzes can be organised about the new words.

The students greatly enjoy contributing words, researching and presenting.

This activity will help the students to streamline their thoughts and build up their vocabulary.

6.Article writing Article writing is the process of creating a non-fiction text about current or recent news, items of general interest or specific topics.
The following figure represents the format of Article writing 16 Communication skills – XII The following link will help to build up the concept https://youtu.be/q2197KT1iNE?list=RDQMaJwsUDCsYv4 Example You are Renu/Ronit.

Write an article in 1OO-120 words for your school magazine on journalism as a career.
• • Hints – Journalism suitable for those who are good at language Ones who desire to present truth to the public Activity Media diary Students write about the different ‘media’ that they have been watching or reading.

This could include TV programmes, films at the cinema or on DVD,websites that they have been looking at, magazines, books etc.

This will help the students to have clarity about present day situations and organise their thoughts in a more constructive way.
7.. Construction of a Paragraph What is a paragraph?

A paragraph is a series of sentences that are organized and coherent, and are all related to a single topic.

17 Communication skills – XII Activity – Argument essay This activity will help students organise their argument essays and hence improve their writing Following points can help students to write/pen down their thoughts in a constructive manner.

    Explain the overall organisation of an argument essay to students.
Explain paragraph organisation.

Give students a list of connectives which they could use in their essays.

Make sure that they understand the relationships that are implied by these connectives.

Give students a model argument essay.

Once they have read it, ask them to draw a spider-diagram of the essay in the following way:  First, students will identify the thesis.

They will write it in a circle in the middle of a blank piece of paper.
 Next, identify the claims or statements that are made to support this thesis.

Students will write these   around the thesis.

Then they will identify and list the details and examples which are given to support each claim/statement.

Finally, students will write relevant connectors between the thesis and the claims/statements and between the claims/statements themselves.
This activity aims to help students recognise their own problems with paragraph construction and to identify errors, which improves their own re-drafting skills.

Summary: A classroom environment relies heavily on the quality of communication taking place within it.

As an instructor, taking steps towards improving the communication skills of students will contribute positively towards your classroom climate.
Students with effective communication skills will be more likely to contribute to class discussions, will be more productive 18 Communication skills – XII members in group projects, and will ultimately gain more from their experience in the class.

Learning and practicing writing skills help students to handle professional and social tensions.
References : Google : You tube : British council Library 19 Communication skills – XII Self-motivation Motivation is defined as the drive required to engage in goal-oriented behaviour.

Motivation is inner urge to do something and self-motivation is ability to do what needs to be done without the influence or thrust from other people or situations.

Self-motivated individuals are asset to the world, their country, their families and to themselves.

Self-motivated individuals practice righteousness.


They do what is required to accomplish their goals.Self-motivated people have elevated spirit and are full of positivity.

For them nothing is impossible.

They are focused on their goals and objectives and diligently achieve their aims.

Self-motivation is important because     It increases individual’s energy and activity.

It directs an individual towards specific goals.


It results in initiation and persistence of specific activities It affects cognitive processes and learning strategies used for completing similar tasks.

Finding and listing motives Motivation is classified in different types by different authors such as motivation based on physiological and psychological needs.

Physiological motivation is based on the physical needs to satisfy hunger or thirst.
Physiological motivation directs the behaviour towards satisfying specific bodily needs.

Psychological motivations can be guided by need for achievement and need for affiliation.

The need for achievement is a social form of motivation involving a competitive drive to meet the standards of excellence.

The need for affiliation involves the need to seek and enjoy close and cooperative relationships with others and be loyal to a friend.

Motivation is also classified as internal or external motivation.
In case of internal motivation, an individual demonstrates a desire to do his/her work without any external reward.

External motivation occurs when we feel driven by outside forces, performing an activity either to obtain a reward or to avoid punishment.

For example, a student who is internally motivated will learn, complete the assignments on his/her own, whereas a student who is externally driven will be completing lessons to avoid punishment or to gain reward.
Motivation, basically answers “why”, the reason behind doing a task.

A person, may be internally or externally motivated.

in different situations or may be driven by physiological and psychological needs.

One should identify the motivation in every occasion to handle oneself better.

Finding sources of motivation and inspiration Following are the sources of motivation and inspiration.

1 Self Management - XII  Music : Music is the language of the soul.
A good inspiring piece touches everyheart and can help create miracles.

 Books : Books are said to be best friends.

They expand our horizon of thinking.

They help us visualize the unknown and unchartered territories beyond our capacities.

Books about heroic acts, inspiring lives and stimulating creativity help readers move beyond their routine lives.

 Activities : Engaging in positive and skill enhancing activities keep our spirits high.
Competitions, games, simulations, interviews for various committee positions are found to encourage, motivate and inspire students.

 Expansive thoughts: Thinking and discussing big and positive ideas motivate us to reach our highest potential.

 Living in the present : Being present where we are rather than where we are not, brings in peace and calmness in our life.

A calm and peaceful mind can help us achieve wonders.
This quality of being aware and conscious of one’s self in present moment is also called mindfulness.

Mindfulness helps students to pay attention, reduce stress and helps promote thoughtful approach towards life.

 Dreaming big : Dreaming big is a journey not a destination.

Dreaming big helps us to be mentally prepared to take that big leap forward.

Only when we aim high, we get motivated to work hard and achieve big things in life.
Personality types, traits and disorders Meaning of personality Personality is relatively enduring set of traits.

These traits are made up of emotional, behavioral and mental set of characteristics.

Heredity has been found to be determining personality apart from environmental forces.

Personality is shaped through family, culture, society, education and other environmental factors.
Influence of personality Personality affects all aspects of an individual’s performance, even how he/she reacts to situations in life.

Individuals shall set clear goals for themselves and diligently pursue them.

Behavioral tendencies like anxiety, stress, perseverance and conscientiousness reflected in personality traits can influence academic performance.

Basic personality traits According to trait theory, combining a set of observable traits into a group forms an individual’s personality.
One popular personality classification is big five.

The Big Five, global traits associated with work .

are listed below:  Extraversion: Gregarious, assertive and sociable.

(Opposite reserved, timid, quiet.)

 Agreeableness : Cooperative, warm and agreeable.


(Opposite cold, disagreeable and antagonistic)  Conscientiousness : Hardworking, organized and dependable(lazy, disorganized and unreliable)  Emotional stability : Calm, self-confident and cool(insecure, anxious and depressed) 2 Self Management - XII  Openness to experience : Creative, curious and cultured(narrow interests) Common personality disorders Following are the common personality disorders.
If anyone is identified with these disorders, counselling shall be provided by family members, teachers and counsellors.

Paranoid Feeling extremely nervous and worried because you believe that other people do not like you or are trying to harm you.

Antisocial Is characterized by a pattern of persistent disregard for and violation of the rights of others.

Schizoid Is characterized by a lack of interest in social relationships and people tend to be distant, detached and indifferent.
Borderline Is marked by an ongoing pattern of varying moods, self-image and behaviour.

These symptoms result in impulsive actions and problems in relationships.

Narcissistic Is a condition in which people have an inflated sense of their own importance, a deep need for excessive attention and admiration and lack of empathy.

Avoidant Avoidant personality disorder is characterized by feelings of extreme social inhibition, inadequacy, and sensitivity to negative criticism and rejection.
Dependent Dependent personality disorder is a condition marked by an overreliance on other people to meet one's emotional and physical needs.

Obsessive Obsessive-compulsive personality disorder (OCPD) is a personality disorder that's characterized by extreme perfectionism, order, and neatness.

Activities Session A.

Group Discussion on identifying needs and desires in general Session B.
Discussion on sources of motivation and inspiration, finding their own sources Session C. Demonstrate the knowledge of different personality types.

Try to identify your own personality Session D. Essay on reflections on self-personality type 3 Self Management - XII 4 Self Management - XII Unit 1 - PERFORMING TABULATION USING SPREADSHEET APPLICATION 1.1 INTRODUCTION TO SPREADSHEET APPLICATION OpenOffice Calc is a spreadsheet program, a part of the free OpenOffice suite.
The program is easy to use and contains most of the commonly used features found in commercial spreadsheet programs.

OpenOffice Calc is a software that helps in performing calculations using formulae and in analysing the data.

Do you remember your Mathematics notebook of your primary class?

It has small boxes to practice mathematics.

These boxes are intersection of horizontal rows and columns.

A spreadsheet or electronic Spreadsheet is also a long sheet of rows and columns on the computer screen.
This helps to manage and organize data in rows and columns.

Spreadsheets can be used to do calculations on data, create data reports, manage accounting documents, do data analysis etc.

You can also create graphical representation of data.

Another term that is used in a spreadsheet software is Workbook.

A Workbook is another name for OpenOffice Calc file.

A Workbook is a collection of one or more worksheets in a single file.

Each sheet can have many cells arranged in rows and columns.
In this chapter we will be discussing about Apache OpenOffice Calc 4.1.5.

You regularly get updates of these software.

1.2 SPREADSHEET APPLICATIONS Spreadsheet programs have become very popular because of the following features: • Built-in functions make calculations easier, faster and more accurate.

• Large volumes of data can be easily handled and manipulated.

• Data can be exported to or imported from other similar software applications.
• Data can be easily represented in pictorial form like graphs or charts.

• Formulae cells get automatically recalculated whenever underlying data values are changed.

1.3 CREATING A NEW WORKSHEET 1 ICT- XII In this section, we will discuss how to start OpenOffice Calc, components of Calc screen.

Also we will learn how to create a new workbook and save it.

1.3.1 Starting OpenOffice Calc To start OpenOffice Calc: 1.

Click Start  All Programs  OpenOffice 4.1.5  OpenOffice Calc.

2.
2.

A spreadsheet workbook named Untitled1 opens up in an OpenOffice Calc application window (Fig.

1).

Columns Title bar Menu bar Standard bar Formatting bar Name box Active cell Rows Sheet tabs Status bar Formula bar Side bar Fig.

1 OpenOffice Calc worksheet 1.3.2 Components of a Calc Screen Title bar The title bar is located at the top of Calc window.

It displays name of the workbook on which you are currently working.

When you create a new worksheet, it is named as Untitled 1, Untitled 2 and so on.
A workbook is a collection of one or more worksheets.

The right side of the title bar contains e Minimize, (Restore Down) or Maximize, and Close buttons.

Menu bar Clicking on each menu option displays a list of commands.

The menu bar is located below the Title bar.

It has commands like File , Edit, etc.

Standard bar This bar contains icons (buttons) to provide quick access to commands such as New, Open, Print, Copy and Paste etc.
Formatting bar It has buttons and drop-down menus that allow you to select a formatting option like, font, font color, alignment, number format, border, and background color.

Formula bar It contains the Name Box and a long white box, known as the Input line.

2 ICT- XII Name Box It is present to the left of Formula bar and displays the address of selected cell.

The rest of the window contains spreadsheet.


It is divided into rows that have a number at the left of each row, and columns with a letter at the top of each column.

Worksheet tabs A workbook, by default, opens three worksheets named as Sheet1, Sheet2, and Sheet3.

You can click any sheet tab to open that worksheet.

To insert a new worksheet, the steps are: 1.

Clicking the empty area after the sheet tab.

2.

The Insert Sheet dialog box appears.

(Fig 2) 3.


Select the required option and click OK Click on blank area to add more sheets Fig 2 Inserting a new sheet You can also rename the sheet..

Simply, double-click the Sheet name and type new name.

Rows and columns A worksheet in OpenOffice 4.1.5 Calc has 1,048,576 rows and 1,024 columns.

The rows are numbered from top to bottom along the left edge of the worksheet as 1, 2, and so on.

Columns are ABA…ABZ…AMA…AMJ.


letters A…Z, AA…AZ, A…BZ…AAA…AAZ, to right with labelled from left Cell and Cell Address A cell is formed by the intersection of a row and a column.

Each cell has a unique address which is formed by the intersection of row number and column letter.

For example, a cell formed by intersection of column F and row 5 will have address F5.

Active Cell: Data is entered in a cell.

To enter data in a cell, we have to first select it.
The selected cell is called the active cell and is highlighted with a thick border.

Also, address of the active cell is displayed in the Name box.

3 ICT- XII Range of cells: A block of adjacent cells which are selected is called range of cells.

For example, if the cells from A1 to B5 are selected, then the range of selected cells is referred as A1:B5.

The cells in this range are;A1, A2, A3, A4, A5, B1, B2, B3, B4, and B5.

1.3.3 Creating a New Workbook The steps to create a new Calc workbook are: 1.
Select File  New Spreadsheet.

Or Click the New Document drop-down menu arrow on the Standard bar and select Spreadsheet.

(Fig 3) Or Press CTRL + N. Fig 3 New button on Standard bar New button on Standard bar 1.3.4 Saving a workbook The steps to save a workbook are: 1.

Select Save option from the File menu.

Or Click the Save icon on the Standard bar.

Or Press Ctrl + S If you are saving a workbook for the first time, a Save As dialog box will appear.

2.
2.

Type the file name and choose a location to save the file.

Notice that the file extension is .ods.

1.4 OPENING WORKBOOK AND ENTERING TEXT In this section, we will learn how to open an already saved workbook.

Also, how to enter data in a cell.

4 ICT- XII 1.4.1 Opening a Workbook The steps to open an already saved workbook are: 1.

Select Open option from the File menu.

Or Click Open icon on the Standard bar.

Or Press Ctrl + O 2.

The Open dialog box appears.

3.


Select the drive and folder from where you want to open the file.

4.

Select the file and click Open button.

1.4.2 Entering text To enter data in a cell, 1.

Select the cell.

2.

Type the content.

3.

Press ENTER key.

You can enter numbers, text, and formula in a cell.

By default, the text is left-aligned in a cell and numbers are right-aligned.

Left-aligned right-aligned To cancel the data you have entered before pressing the ENTER key, press the ESC key.
1.5 RESIZE FONTS AND STYLES We can always change the font, style and size of the text or data entered in a worksheet.

This can be done before typing or after typing the content.

The options for formatting data/text are available on the Formatting bar (Fig 4).

The use of each of the options is shown in the figure.

Italic Bold Underline Text color Font Font size 5 ICT- XII Fig.

4 Formatting bar 1.6 COPYING AND MOVING In this section, we will learn how to select cells, rows and columns.
We will also discuss how to insert and delete cells, rows and columns.

How to change the row height and column width is also discussed here.

Before performing any operation, like, making text bold, changing text color etc, on a range of cells, you need to select the range.

A range is a rectangular block of contiguous cells, i.e., cells that touch each other, especially along a line.

Multiple ranges can also be selected simultaneously.
1.6.1 Selecting Cells You can select range of cells in any one of the following ways:  Using the mouse  Using the keyboard Using the mouse To select a range of cells using the mouse, the steps are: 1.

Click the cell you wish to start your selection from.

2.

Bring the mouse pointer to the bottom right corner on the black square.

Click and hold the left mouse button down, drag the mouse pointer (a thick plus sign will appear) to the diagonally opposite corner cell.
For example, if the range A1 to D3 is to be selected, place the mouse pointer at cell A1.

Hold the left mouse button down and drag it to the cell D3.

The range A1 to D3 is represented as A1:D3.

When you select the range, all the cells appear highlighted (Fig.

5).

6 ICT- XII Fig 5 Selecting range using mouse Using the Keyboard To select a range of cells using the keyboard, do the following: 1.

Place the cell pointer at one of the corner cells of the range to be selected.

2.
2.

Press the SHIFT key and move to the diagonally opposite corner cell using the arrow keys.

3.

Release the SHIFT key when the required range has been selected.

Selecting Multiple Ranges Simultaneously To select multiple ranges, do the following: 1.

Select the first range of cells.

2.

Hold the CTRL key and select another range of cells.

3.

Repeat step 2 to select more ranges if required (Fig.

6).
6).

Fig 6 selecting multiple range of cells Selecting the entire row To select the entire row in which cell pointer is positioned, click the row heading.

Selecting the entire column To select the entire column in which cell pointer is positioned, click the column heading.

7 ICT- XII Selecting the entire worksheet To select the entire worksheet: CTRL + A Or Click the blank button (called the Select All button) at the junction of the row and column headers.
(Fig 7) Select All button Fig 7 Select All button Let’s Try Start OpenOffice Calc and create a new worksheet.

Now, try the following: 1.

Select cell B3.

2.

Select the range of cells from A1 to D3.

3.

Select the range of cells from C5 to F5.

4.

Select multiple range of cells B4:D7 and C4:F8.

5.

Select row 5.

6.

Select row 3 and 8.

7.

Select column D. 8.

Select column B and G. Worksheet 1.

By default, how many worksheets are there in a Calc workbook?

2.

How are rows numbered in Calc?

3.


Name the column after column Z.

4.

What is the address of a cell formed by the intersection of 3rd column 5th row?

5.

Name the cells in the range A2:B5.

6.

How can you select entire worksheet using keyboard?

7.

How can you select entire column number B?

8.

Which key will you press if you want to select multiple ranges of cells?

9.

Name the column after BZ?

8 ICT- XII 10.

What is the extension of a file saved in Calc?


1.6.2 Copying Cell Contents You can copy content of cell(s) to another cell(s).

To copy cell contents in Calc, the steps are: 1.

Select the cell(s) that contain(s) the data you want to copy.

2.

Select Copy option from the Edit menu.

Or Click the Copy button on the Standard bar.

(Fig 8) Or Press CTRL + C to copy the data.

3.

Click on the cell(s) where you want to paste the data.

4.

Select Paste option from the Edit menu.


Or Click the Paste button on the Standard bar.

Or Press CTRL + V. Cut Copy paste Fig 8 Standard bar 1.6.3 Moving Cell Contents To move cell contents from one cell to another in Calc, the steps are: 1.

Select the cell that contains the data you want to cut.

2.

Select Cut option from the Edit menu.

Or Click the Cut button on the Standard bar.

Or Press CTRL + X to cut the data.

3.

Click on the cell where you want to paste the data.

4.
4.

Select Paste option from the Edit menu.

Or Click the Paste button on the Standard bar.

Or Press CTRL + V. 1.6.4 Inserting and Deleting Cells To insert cells, the steps are: 1.

Select the range of cells where you want to insert a block of cells.

2.

Select Cells option from the Insert menu.

9 ICT- XII 3.

The Insert Cells dialog box appears.

4.

Select the appropriate option and click OK. To delete cells, the steps are: 1.

Select the range of cells where you want to delete a block of cells.

2.
2.

Select Delete Cells option from the Edit menu.

3.

The Delete Cells dialog box appears.

4.

Select the appropriate option and click OK. 1.6.5 Inserting Rows and Columns The steps to insert rows are: 1.

Select the row where you want to insert a new row.

2.

Select Rows option from the Insert menu.

Or Right-click the row header and select Insert Rows in the shortcut menu.

A new row is inserted above the selected/highlighted row.
Cells in the new row are formatted similar to the corresponding cells in the row before which new row is inserted.

Multiple rows can be inserted at once by selecting multiple rows using the CTRL key or by dragging the mouse while holding down left mouse button.

To insert columns, the steps are: 1.

Select the column where you want to insert a new column.

2.

Select Columns option from the Insert menu.

Or Right-click the column header and select Insert Columns in the shortcut menu.
When you insert a new column, it is inserted to left of the selected/highlighted column.

Cells in the new column are formatted similar to the corresponding cells in column to the left of which the new column or row is inserted.

Multiple columns can be inserted at once by selecting multiple columns using the CTRL key or by dragging the mouse while holding down left mouse button.

1.6.6 Deleting Rows and Columns To delete rows, the steps are: 1.

Select the row to be deleted.

2.


Right-click on the selected column header.

3.

Select Delete Rows option in the shortcut menu.

To delete multiple rows, select them using the CTRL key, or by dragging the mouse while holding left mouse button.

To delete columns, the steps are: 1.

Select the column to be deleted.

2.

Right-click on the selected column header.

3.

Select Delete Columns in the shortcut menu.


10 ICT- XII To delete multiple columns, select them using the CTRL key, or by dragging the mouse while holding left mouse button.

Deleting Content Instead of deleting a row or column, you may want to delete the contents of cells but keep the empty row or column.

This can be done in the following manner: 1.

Select the cell(s), the contents of which you want to delete.

2.

Press the DELETE key.

Or Select Delete Contents option of Edit menu.

3.


The Delete Contents dialog box appears.

3.

Check the boxes of the kind of data you want to delete (e.g., checking Formats will remove the formatting changes such as bold, italics, font colors, and borders).

4.

Click OK. 1.6.7 Changing Row Height and Column Width You can change the row height in a Calc worksheet in any of the following ways: • Drag the divider below the row (Fig 9).
• To fit the row height to the cell contents, double-click the divider.

• Select Format  Row  Height.

The Row Height dialog box appears (Fig.

10).

Enter the value for row height in the Height spinbox.

Click Ok button.

Fig 9 Changing row height 11 ICT- XII Fig.

10 Row Height dialog box Changing Column Width You can change the column width in a Calc worksheet in any of the following ways: • Drag the divider to the right of column header (Fig 11).
2• To fit the column width to the cell contents, double-click the divider.

• To change the column width, select Format Column  Width.

The Column Width dialog box appears.

Enter the value for column width in the Width spinbox.

Click Ok button.

Fig 11 Changing column width Let’s Try 1.

Create the following worksheet.

Insert a column after column D. 2.

3.

Move the marks of Maths in the newly inserted column.

12 ICT- XII 4.

5.

Insert a new row after row 5.


Insert following details in the new row 1105 Tiya 69 64 59 54 6.

Change row height of all the rows.

7.

Change the column width of columns A to F. 1.7 FILTER AND SORTING 1.7.1 Filtering Data Filtering is a quick and easy way to find and work with selected data based on the criteria you specify.

The filter feature selectively blocks out the data you do not want to see and displays only the rows or columns that meet the conditions or criteria you specify.
Sorting rearranges the range of cells but filtering only hides temporarily the rows/columns you do not want.

Different ways in which filtering can be done in Calc are:  AutoFilter  Standard Filter AutoFilter To apply AutoFilter in a worksheet, the steps are: 1.

Select cell, say, A1.

2.

Select Data  Filter  AutoFilter.

3.

A drop-down menu arrows appear in each column heading (Fig 12).

Fig.

12 Drop-down menu arrows in column Headings 4.


Click the drop-down menu arrow for Total Sales and select an item (Fig 13).

5.

Only those rows whose contents meet the filter criteria are displayed.

13 ICT- XII a.

To display all the records again, select the All option in the filter drop-down menu.

b.

Select Top 10 to display the highest 10 values.

Fig.

13 Drop-down menu for Total Standard Filter To apply standard filter in your worksheet, the steps are: 1.

Select Data  Filter  Standard Filter.


2.

The Standard Filter dialog box appears (Fig.

14).

a.

You can use the dialog box to connect multiple conditions with either a logical AND or a logical OR operator.

3.

Select the options in the Standard Filter dialog box.

The records with Total Sales greater than 4000 will be displayed (Fig.

15).

Fig.

14 Standard Filter dialog box 14 ICT- XII Fig.

15 Rows after applying Standard Filter To remove the filter, 1.

Select Data  Filter Remove Filter.


To hide the filter, 1.

Select Data  Filter  Hide AutoFilter.

To remove the filter from column headings, 1.

Select Data  Filter  Clear AutoFilter.

1.7.2 Sorting Data Once you have entered data and applied relevant formula in a worksheet, you can arrange the data in ascending or descending order.

This is called sorting of data.

Sorting on numerical and textual values is a one of the main features of any spreadsheet software.
In Calc, sorting can be done in the following manner.

Sorting on One Column 1.

Enter data in a worksheet (Fig.

16).

2.

Select any cell, say C1.

3.

Click the Sort option from the Data menu (Fig.

17) 15 ICT- XII Fig.

16 Data in worksheet Fig.

17 Sort option in the Data menu 3.

The Sort dialog box appears (Fig.

18).

Notice that column Marks appears under Sort by section.

4.

Select the Descending option under Sort by and click OK. 5.

The data in column Marks is sorted in descending order.
(Fig 19) 16 ICT- XII Fig 18 Sort dialog box Fig 19 Data arrangement in descending order of Marks You can also sort the data on one column by using the sorting icons on Standard bar.

On the Standard bar, click (Fig 20) • The Sort Ascending button to sort the data in ascending order.

• The Sort Descending button to sort the data in descending order.

Sort Ascending Sort Descending Fig 20 Sort buttons on Standard bar 17 ICT- XII Sorting on Multiple Columns You can sort the data on multiple columns.

1.
1.

Consider the following worksheet.

(Fig 21) Fig 21 Worksheet 2.

Select cell, say C1.

3.

Select Sort option from Data menu.

4.

The Sort dialog box appears.

5.

The Sort Criteria tab on the Sort dialog box has options to sort the data on multiple columns.

6.

Select the options as shown in Figure 22.

7.

The data is sorted in descending order of column Total Sale, and where total sale is shown , sorting is done in ascending order of column Salesman Name.

(Fig 23) 18 ICT- XII Fig.


22 Multiple columns selected in the Sort dialog box Fig 23 Data sorted on multiple columns Let’s Try!

1.

Create following worksheet and perform the following operations: 19 ICT- XII a.

Sort the table in ascending order of height.

b. Filter the data to view only those rows where height is more than 8500 mm.

1.8 FORMULAS AND FUNCTIONS The most important feature of Spreadsheet software is that you can perform arithmetic operations on the data in a worksheet.
1.8.1 Formulas Formulae are used to calculate results through arithmetic operations.

A formula in Calc always starts with an equal to (=) sign.

If you forget to put = sign before the formula, it will be treated as text and no calculation will be performed.

Also, you should not write anything before the = sign.

Again, it will be treated as text and no calculation will be performed.
The data in a formula consists of one or combination of the following: Value Numeric (e.g., 45) or string (e.g., “Smiling”) Cell Address B4, A2:C6 Function SUM, AVERAGE, MIN, MAX, etc.

Operator +, -, *, /, >, =, etc.

Parenthesis To control the left to right order of precedence in a formula (e.g., = (B2*B3)*2) Numeric Formulae In numeric formulae, you have to make use of operators.

The results are calculated based on the order of precedence of the operators.
Mathematical Operators Used in Formulae The mathematical operators used in Calc and their order of evaluation in formulae are given below: Operation Exponent Multiplication Division Addition Subtraction Operator ^ Order of evaluation 1 * / 2 2 + - 3 3 Formula = 2 ^ 3 = 3 * 5 = 12 + 15 = 18 - 15 Result 8 15 3 27 3 = 9/ 3 20 ICT- XII Order of evaluation 1.

Any operation contained within brackets will be carried out first 2.

Then any exponent.

3.

Then follow division and multiplication operations.
Multiplication and division are given equal importance.

They are carried out in the order they occur in the formula, from left to right.

Whichever appears first in the formula is carried out first.

4.

After that, addition and subtraction operations are given equal importance.

They are also carried out in the order they occur in the formula, from left to right.

Following are some examples of how Calc evaluates formulae.
Formula = (3 + 7) * 2 = 4 * 3 + 5 = 3 + 3 ^ 2 = 5 + 3 * 4 – 2 = 6 + 14/2 * 3 - 4 Output 20 17 12 15 23 Error Results Sometimes a formula displays an error result rather than a proper value.

This happens when the formula or data has a problem and Calc cannot evaluate it.

Some common errors are shown below: Error ##### #DIV/0!

#VALUE!

required.

Reason The column is not wide enough to display the value.

The formula contains an invalid operation, i.e., division by zero.
The formula has invalid argument, e.g., text in a cell where numeric value is Text Formulae A text string or a text value is a sequence of characters.

You can join two strings together.

This is called concatenation.

We use the ampersand (&) character to concatenate strings.

For example, if you type = “Keep” & “ “ & “Smiling” in a cell and press ENTER, you will see the result as Keep Smiling.

You cannot do operations such as subtraction, multiplication, and division on strings.
Cell and Range References A cell reference identifies a cell or a range of cells.

Each cell in the worksheet has a unique address formed by the combination of its intersecting row and column.

When a cell address is referred to in a formula, it is called cell referencing.
Consider the following examples: Cell or a Range of Cells The cell in column B and row 4 All cells in row 5 All cells in rows 5 through 9 All cells in column B The range of cells in column F and rows 1 through 7 The range of cells in row 5 and columns C through E All cells in columns C through G The range of cells in columns B through G and rows 4 through 8 B4:G8 Reference B4 5:5 5:9 B:B F1:F7 C5:E5 C:G 21 ICT- XII Entering a Formula All formulae in OpenOffice Calc begin with an equal to (=) sign.
A formula can contain number, text, arithmetic operators (+, -, *, /), or functions.

The order of precedence is as already discussed.

To enter a formula: 1.

Select the cell and enter the formula directly in the cell or in the Formula Bar.

2.

Press the Enter key.

3.

The cell will show the result of the formula and the formula itself.

You can see the formula in the Formula bar when the cell is selected.

Consider the following worksheet.

(Fig 24) Fig 24 Worksheet To find the total marks: 1.
Select cell D3.

2.

Type the formula =B3+C3.

3.

To copy this formula in other cells: a.

Select cell D3.

b. Click the AutoFill handle and drag till cell D6.

(Fig 25) Fig 25 Copying formula c. The formula copied in cell D4 will be =B4+C4.

d. The formula copied in cell D5 will be =B5+C5.

e. The formula copied in cell D6 will be =B6+C6.

Let’s Try 22 ICT- XII 1.

Create the following worksheet.

2.

Now, type the formula =45+67+77 in cell D2.

Press Enter key.

3.

Now change the value 88 in cell C2.


4.

Did you notice any change in the cell D2?

5.

Now, type the formula =A2+B2+C2 in cell D2 and press Enter key.

6.

Notice the result in cell D2.

7.

Now, change the value in cell A2 to 89.

8.

Notice the change in cell D2.

9.

Notice the benefit of giving cell address in a formula.

Let’s Try Create the following worksheet in Calc.

1.

Write the formula to calculate area of a rectangle in cell C3 (=A3*B3).

Then press Enter key.

2.


To copy the formula to cells C4 and C5: a.

Select cell C3.

b. Click and drag the AutoFill handle to cells C4 and C5.

3.

Write the formula to calculate perimeter of rectangle in cells D3 (=2*(A3+B3)).

Then press the Enter key.

4.

Now, copy the formula in cell D3 to D4 and D5.

5.

Save the worksheet as ‘rectangle’.

Let’s Try 1.

Open the file ‘rectangle’.

2.

Change the values of length and breadth in cells A3, A4, B3 and B4.

3.
3.

Observe the change in results in cells C3, C4, D3 and D4.

Let’s Try 23 ICT- XII Create following worksheet and perform the following operations a. Filter the records according to the following condition:marks in all subjects equal to or more than 65 b.

Add another column at the end with heading ‘Total marks’ c. Calculate total marks for each student.

d. Now, arrange the data in descending order of Total marks.
1.8.2 Using Functions to do calculations Functions are predefined formulae that perform calculations using specific values called arguments.

The format of writing any function in Calc is: =function_name(Argument1;Argument2; Argument3;…..) Arguments These are the values passed to a function so that the function carries out the intended calculation or manipulation to give results.

Arguments can be constants, formulae, or function.

SUM You have already learnt how to find total using the formula.
You can also obtain sum of the values in a range of cells by: • Clicking the Sum button on the Formula bar (Fig 26) • Using the SUM( ) function SUM function is used to find total of numbers in a range of cells.

For example: Formula =SUM(5;6;12) 23 =SUM(A1;B1;C1) where A1, B1 49 and C1 contain the values 12, 23 and 14 respectively Result SUM button 24 ICT- XII Fig 26 Formula bar Let us consider an example.

1.

Consider the worksheet shown in Figure 27.

Fig 27 Creating a worksheet 2.

Select the cell D2.
Select the cell D2.

3.

Click the Sum button on the Formula bar.

Notice it will select the range A2:C2.

(Fig 28).

Fig 28 4.

Select the correct range B2:C 2 or type the correct range (Fig 29).

25 ICT- XII Fig 29 5.

Press ENTER (Fig.

30) to perform the operation.

The sum of the range B2:C2 will appear in cell D2.

Fig 30 4.

Select cell D2 and using the AutoFill handle, drag the formula through D7.

The respective sums will appear in the respective cells.
(Fig 31) 26 ICT- XII Fig 31 AVERAGE Function Average function is used to find the average of numbers in a range of cell.

For example: Formula =AVERAGE(3;6;9) =AVERAGE(A1;B1;C1) where A1, B1 and C1 contain the values 4, 5 and 6 respectively Result 6 5 COUNT Function The COUNT function is used to count the number of numeric values in a range of cells.

For example: Formula =COUNT(5;8;14;19) =COUNT(A1:A10) Result 4 MAX Function The MAX function is used to find the maximum of numbers in a given range of cells.
For example, Formula =MAX(74;102;134) =MAX(A1;B1;C1) Or =MAX (A1:C1) where A1, B1 and C1 contain the values 4, 5 and 6 respectively 6 Result 134 MIN Function The MIN function is used to find the minimum of values in the given range of cells.

For example; 27 ICT- XII Result 74 4 Formula =MIN(74;102;134) =MIN(A1;B1;C1) Or =MIN (A1:C1) where A1, B1 and C1 contain the values 4, 5 and 6 respectively Worksheet 1.

Every formula in Calc starts with which symbol?

2.

The formula in cell B6 is ‘=MIN(B1:B5)’.


When copied to C6, the formula changes to 2.

________________.

If A1:A4 contains the numbers 11, 13, 15, 17, the formula =AVERAGE(A1:A4) in cell A5 will display ______________.

3.

Cell B1 contains 12 and C1 contains 8.

What will be the content of cell D1, if the formula =B1*C1/2 is entered in cell C1?

4.

The contents of cell B2, C2, D2, and E2 are 13, 15, 17, 19 respectively.
What will be the value in cell E2, if the formula =MAX(B2:E2) is entered in cell E2?

5.

What is the difference between MAX and MIN functions in Calc.

1.9 PASSWORD PROTECTION In OpenOffice Calc, you can protect your spreadsheet with a password.

To protect your data, you can either assign a password to a sheet or Calc document.

This can be done using Tools menu and aslo while saving the document.

1.9.1 Using Tools menu The steps to protect worksheet or Calc document using option of Tools menu are: 1.
Select Tools menu  Protect document Choose whether to protect Sheet or Document.

(Fig 32 ).

Fig 32 Tools menu 2.

If you select Sheet, the Protect Sheet dialog box appears.

(Fig 33 ).

28 ICT- XII Fig 33 Protect Sheet dialog box If you select Document, the protect Document dialog box appears.

3.

Type the password in Password text box.

Again type the password in Confirm text box.

Note that the password is case sensitive.

4.

Click OK button.


Undoing Password Protection To remove a password, open the document, then save without password 1.9.2 Protecting Calc doument while Saving Tip Rules to select a password: Length of 8 or more characters   Mix of lowercase and uppercase letters, numbers and special characters You can also protect your spreadsheet with a password while saving the document.

The steps are: 1.

Select Save As option from File menu.

2.

The Save As dialog box appears.


Select the drive and the folder where you want to save the file.

3.

Select Save with password check box.

(Fig 34) Fig 34 Save As dialog box 29 ICT- XII 4.

Click Save button.

5.

The Set Password dialog box appears.

(Fig 35) Fig 35 Set Password dialog box 6.

Enter the password to open.

Again type the password in Confirm password text box.

7.

Next, click on More options.

The dialog box expands as shown below in figure 36.
30 ICT- XII Fig 36 More options of Set Password dialog box 8.

Here, you can give file sharing password.

You can select the check box of Open file read-only option, if you want the recipient to only read the file and make no changes.

You can also enter password to allow editing.

9.

Click OK button.

1.10 PRINTING A SPREADSHEET Select File  Page Preview to view a worksheet so as to get an idea of how it will look when printed.

or Click the Page Preview button on the Standard bar (Fig 37).
Print button Page Preview Fig 37 31 ICT- XII To print a worksheet, the steps are: 1.

Click File  Print.

2.

The Print dialog box will appear (Fig.

38).

3.

Select the printer, the range to be printed, and the number of copies.

4.

Click the Print button.

To quickly print without getting the Print dialog box, click the Print button on the Standard bar.

(Fig 37) Fig.

38 Print dialog box Let’s Try it 1.

Create the following worksheet and calculate total and percentage for each student.

2.
2.

Create the following worksheet.

Calculate area and perimeter of square.

32 ICT- XII 3.

Create the following worksheet.

Calculate area and perimeter of rectangle.

4.

Create the following worksheet and perform calculations using functions in Calc.

Worksheet 1.

How will you refer to a cell in column B and row 3?

33 ICT- XII 2.

How will you refer to range of cells in row 5?

3.

How will you refer to range of cells in column D through F and rows 3 through 8?

4.
4.

Write mathematical operator for the following operation: a. Multiplication b.

Division 5.

If formula in cell C3 is =A3+B3, what formula will be copied in cell D3?

6.

How will you write a function to find average of numbers 5, 12, and 17?

7.

Name the function used to find total of numbers in the range of cells A1 to A10.

8.

Name the menu used to print the document.

9.

What error will you get if the column is not wide enough to display the value?

10.
10.

What happens if you write the formula =45/0 in cell A1?

1.11 SAVING A SPREADSHEET IN VARIOUS FORMATS We have already learnt how to save a document in OpenOffice Calc.

The default extension of a Calc file is .ods 1.11.1 Saving in Microsoft Excel Format If you want to save the file in the Microsoft Excel file format, then do the following while saving: 1.

Select Save As option from the File menu .

2.

The Save As dialog box appears.

(Fig 39) 3.


Change the Save as type to Microsoft Excel 97/2000/XP(.xls) 4.

5.

Type the filename and clcik Save button.

Select the drive and the folder where you want to save the file.

Fig 39 Save AS dialog box 34 ICT- XII 1.11.2 Saving in PDF format Sometimes, when saving a document, you do not want the recipient to modify it.

The safest way is to save the document in PDF (Portable Document Format) format and then share it.

The simplest way to do this is: 1.


Click on the Export Directly as PDF icon on the Standard bar.

This will export the entire document using the default PDF settings.

2.

The Export dialog box appears.

3.

Select the drive and the folder where you want to save the file.

4.

Type the file name and clik OK button.


35 ICT- XII ICT Skills - XII - Performing Tabulation Using Spreadsheet Application Introduction All entrepreneurs are different but there are some characteristics and qualities that have been observed to be common among successful entrepreneurs over the years.

Along with the qualities and traits, the motivation to choose the path of entrepreneurship as well as the journey to success is also different for each entrepreneur.
However, one thing that drives all entrepreneurs is the sense of purpose behind their venture as well as willingness to take the leap and implement their ideas.

More than anything, most entrepreneurs follow a basic process of entrepreneurship to kick start their ventures.

Barriers to Becoming an Entrepreneur Recognizing a need and having an idea of how to fill the gap or need, are rarely a strong enough basis for launching a new venture, particularly if the entrepreneur needs to borrow capital.
Most successful entrepreneurs also create a business plan, a formal document that contains a statement of purpose, a description of the products or services to be offered a market analysis, financial projections and some management procedures designed to attain the firm’s goals.

Before they can write a business plan, though, entrepreneurs must be aware of the barriers to entry.
Unsupportive business environment: Lack of supportive and market-augmenting governmental regulations serve as a barrier to entrepreneurship.
For example, Russia leads all other large nations in having an unsupportive business environment because they lack rule of law, enforce regulations inconsistently, allow rampant corruption and bribing, allow regulatory authorities and inspectors to act in a predatory nature which therefore requires friendly ties with government officials and bureaucrats to smooth the way for businesses to operate.
Employee related difficulties: Building an employee asset base for the enterprise is one of the more daunting and sometimes overlooked tasks.

Entrepreneurs must find and select the best-qualified employees who are motivated and willing to grow with the venture.

Then they must ensure the employees do not leave.

This task becomes a barrier when employee expectations increase, governmental regulations related to labor employment are hardened, and employee costs grow.
Market entry regulations: Governmental rules, taxation, environmental regulations, lending requirements and licensing are all barriers to entrepreneurship.

Most countries license market entry and the creation of new firms to protect incumbents in certain industries and professions.

Other barriers to entrepreneurship are predatory tax behavior of authorities, lack of property rights and tax disadvantages.
Shortage of funds and resources: Finding the money to start up an enterprise is a leading barrier to entrepreneurship.

Without funds, any person cannot begin to organize, train, develop and sell product.

Lack of Entrepreneurial Capacity: Entrepreneurial capacity is the existence of people with entrepreneurship qualities, willingness and motivation to initiate new ventures.

Opportunities go untried until someone comes along with an eye for possibility and a can-do attitude.
Some cultures may discourage entrepreneurial capacity resulting in a low rate of new firm entrance.

Lack of Adequate Entrepreneurship Training: Training and education can be a robust incubator for new ventures.

This includes training in technical skills, managerial skills, entrepreneurial skills and entrepreneurship.

Lack of Appropriate Technical and Practical Skills: People tend to use the skills they have acquired to pursue entrepreneurial initiative.
Lacking the appropriate skills and knowledge inhibits economic development.

Fear of Failure: Entrepreneurs have to decide whether to take action so they don’t miss the boat, while knowing that hasty action may cause them to sink the boat.

1 Entrepreneurial Skills - XII Aversion to Risk: A psychological barrier closely related to the fear of failure is aversion to risk.

Entrepreneurs must take initiative, create structure with a social-economic mechanism and accept risk of failure.
Entrepreneurs have to be risk takers while those who are risk averse will seek the security in an existing establishment.

Fear as a barrier Fear is defined as an unpleasant feeling triggered by the perception of danger, real or imagined.

It is a fundamental part of human psychology.

Our brains are wired to feel fear because it helps us avoid calamity; it keeps us safe.

But fear can also hold us back if we let it.


Fear feeds on fear, meaning the more we try to avoid something we’re afraid of, the bigger and deeper our anxiety grows.

To overcome this, we must face our deep- seated misgivings and worries.

We have to acknowledge our fears and find ways to move beyond them.

In the process of entrepreneurship, many fears serve as obstacles in taking action.

If entrepreneurs don’t confront them, the fears can ultimately consume them.
Some common fears seen in entrepreneurs are as follows: Fear of failure: The fear of failure is like a tiny voice whispering into your ears that everything could go wrong in the business.

The best way to overcome this fear is to accept that failure is possible, even for the most gifted entrepreneurs.

With every failure comes an added value in strength, courage, wisdom and knowledge.
Whenever you experience any setback, do a little soul searching to find out what mistakes were yours, why you made them and what you learnt.

The Fear of not being an expert: Even though you probably know enough about your business or product to make important decisions or solve most of the nagging issues that may arise, many entrepreneurs still face the fear of not being considered as experts in their line of business.
This fear, however minor it may seem, has a way of limiting your potential as an entrepreneur.

For the things about a business one might not know, there is no shame in constantly learning and finding answers to them.

Learning about the business is a continuous process that will surely lead to perfection in the long.

Fear of being pushed into uncomfortable situations: Many people fear public speaking more than death.

Just the thought of it puts us on edge and makes us anxious.
With practice, however, we can become comfortable pushing ourselves outside our comfort zones.

But it won’t happen without getting into the right mindset and prepping to take on this challenge.

One can start by taking small steps and doing things just outside of their comfort zone.

Fear of taking risks: A risk can pay off with amazing success, or it can lead to a downward spiral and failure.

But there is an important difference between dangerous, unmitigated risk and thoughtful, calculated risk.
Dangerous risk takers are like gamblers, betting it all on something that isn’t proven.

With a calculated risk, you have strategized each step of the way.

One must move incrementally towards their goal, carefully assessing their level of investment and overhead.

Calculated risks are key to every success.

Fear of the unknown: Uncertainty registers in our brain like a blaring alarm.

We often avoid the unknown because we fear change.


We are afraid of losing control and being unable to manage potential outcomes.

Allowing ourselves to take a massive leap into the unknown is terrifying because we have no guarantees of how things will turn out.

The unknown will certainly lead to change of some kind.

Entrepreneurial Competencies Entrepreneurial behavior requires certain knowledge, skills or personality profile.

Generally, it is called entrepreneurial competence or traits.
A competence may be defined as underlying characteristics of a person which results in effective and/or superior performance in a job.

Entrepreneurial competencies play a key role in the success of an entrepreneur and in achievement of entrepreneurial goals.
Common Entrepreneurial Competencies 2 Entrepreneurial Skills - XII In a study conducted by David C. McClelland, a reputed behavioural scientist, and Entrepreneurship Development Institute of India (EDII), certain competencies were identified that were found in successful entrepreneurs who exhibited superior performance.

These competencies can be developed through training, experience and guidance in a budding entrepreneur.

Some of these competencies include: 1.


Taking Initiative: It is an inner urge in an individual to do or initiate something.

It is the entrepreneur who takes the first move towards setting up of an enterprise.

Most innovative entrepreneurs have this urge to do something different.

An entrepreneur basically is an innovator who carries out new combinations to initiate and accelerate the process of economic development.

2.
2.

Seeking and Acting on Opportunity: An entrepreneur is always on the look-out or searching for opportunity and is ready to exploit it in the best interests of the enterprise.

3.

Persistence: An entrepreneur is never disheartened by failures and keeps trying, adapting and iterating to overcome obstacles that come in the way of achieving goals.

4.

Information Seeking: A successful entrepreneur always keeps his/her eyes and ears open and is receptive to new ideas which can help in realizing his goals.
He/she is always open to consult with experts and mentors to get the right guidance and advice.

5.

Concern for High Quality: Successful entrepreneurs are seen to be not satisfied with moderate or average performance.

They set high quality standards for themselves and then put in their best for achieving these standards.

They believe in excellence, which is reflected in everything they do.

6.

Commitment: Entrepreneurs exhibit high level of commitment towards their work and decisions.
For an entrepreneur to succeed, they have to stay committed to their venture and their goal.

7.

Concern for Efficiency: Many entrepreneurs are always keen to devise new methods aimed at promoting efficiency.

They try and create new methods that aim at making working easier, simpler, better, and economical.

8.

Systematic Planning: Successful entrepreneurs decide future course of action keeping in mind the goals to be achieved.
They believe in developing relevant and realistic plans and ensure proper execution of the same in pursuit of running a successful enterprise.

9.

Problem Solving: An entrepreneur takes each problem as a challenge and put in best for finding out the most appropriate solution for the same.

He/she will first of all understand the problem and then evolve appropriate strategy dealing with the same.

10.
10.

Self-confidence: Entrepreneurs are not cowed down by difficulties as they believe in their own abilities and strengths.

They have full faith in their knowledge, skill and competence and have the confidence to handle future uncertainties.

11.

Assertiveness: An assertive person knows what to say, when to say, how to say and whom to say.
Entrepreneurs exhibit assertiveness in situations around decision making to ensure that interests of the organization are aligned with decisions and actions of the entrepreneur and its team.

12.

Persuasiveness and Influencing Others: Entrepreneurs have to persuade different cohorts of people at different stages, such as employees, customers, clients, suppliers etc.

Through sound opinions and logical reasoning, an entrepreneur manages to convince others about what he/she wants.

13.
13.

Effective Strategist: A successful entrepreneur possesses the ability to formulate relevant strategies, aimed at safeguarding or promoting the organization’s interests and goals.

Strategy may be with respect to facing future uncertainties or challenges posed by competitors etc.

3 Entrepreneurial Skills - XII 14.

Effective Monitoring: Entrepreneurs monitor that everything is carried out in their organizations as per their decisions but at the same time give some flexibility to the employees.
They ensure regular monitoring of the working so that the goals of the organization are achieved in best possible manner.

15.

Concern for Employees Welfare: Future of the organisation depends on its employees.

If the employees are dedicated, committed and loyal, the organisation is bound to perform well.

A successful entrepreneur tries to promote organisation’s interest through promotion of interests of the workers.
He/she takes personal interest in solving problems confronting workers and generates the feeling that there is interdependence of the interest of workers and the management.

16.

Adaptability: Adaptability refers to the capacity to adjust one’s thoughts and behaviours in order to effectively respond to uncertainty, new information, or changed circumstances.

In business, adaptability becomes a survival skill as the nature of businesses is dynamic.
Uncertainty around globalization, new technologies, market trends, etc., poses a tremendous challenge for applying the right business strategy.

Entrepreneurs learn to disrupt, pay the price and bring change.

It is impossible to accomplish this without developing the skill of adaptability.

17.

Decision Making: One of the most important traits of being an entrepreneur is being able to take decisions that more often than not, decide the fate of the company.
At the helm of the company, entrepreneurs often have to take that one decision at the right time which can define the future of their company.

And then they also have to quickly act upon their decisions.

18.

Goal Setting: Goal setting refers to establishing short or long-term objectives, usually along with incorporating deadlines and quantifiable measures to indicate if they have been achieved.

For a business, the ultimate goal is to make profit.
For a social enterprise, the ultimate goal might be to sustain itself and create the impact that it aims to.

Entrepreneurs set various goals with different timelines.

Each action and decision is taken to achieve a certain goal.

19.

Team Building: Team building is any action or method that brings a group of individuals together and motivates them to work cooperatively as a team.

It refers to the various activities undertaken to motivate the team members and increase the overall performance of the team.
Teams are formed when individuals with a common interest come together on a common platform to achieve a predefined target.

The main goals of team-building are to improve productivity and motivation.

20.

Interpersonal Skills: For smooth functioning of a team, each member must be consistent and clear in their communications and interpersonal skills.

Clear communication helps everyone in the team to understand what’s expected and how it’s measured.
It must also be ensured that no member offends the other.

21.

Creativity: Creativity is a process of continually improving ideas and solutions by making gradual alterations and refinements.

Entrepreneurs exhibit creativity by applying the process of design thinking, thinking of alternatives, trying unconventional ways to do things and continuously improvise and iterate.

22.

Risk Taking: Entrepreneurs take enough risk but it is a calculated risk.
They use risk management principles to assess the loss and return of the risk.

23.

Perseverance: It is important to be perseverant and patient and ready to continue even if the first battle is lost.

Entrepreneurs need to stay put, be patient and believe in their vision.

It is only by trying different things and ways to do them, that a solution can be found.

24.

Negotiation skills: Negotiation skills for entrepreneurs are critically important to business success.
There a number of scenarios where an entrepreneur's negotiation skills come into play such as supplier relations, customer sales, employee hiring, securing investors etc.

Some essential negotiating techniques that can be applied to nearly any business situation include - inviting the other person to share their perspective, clearly stating your own needs, and considering options in advance can all play an important role in helping your business run more smoothly and profitably etc.
4 Entrepreneurial Skills - XII 25.

Organizational skills: Organizational skills for entrepreneurs are not just about structuring and prioritizing their daily work, but mainly about managing teams, delegating, setting targets, continually reviewing and leading and motivating the people around them.

26.

Stress management: Entrepreneurs have a hectic work life and thus, it is important for them to manage and handle stress.
This refers to taking systematic brakes, maintaining work-life balance, setting achievable goals, connecting with other like-minded entrepreneurs etc.

27.

Valuing service and diversity: Diversity is about how an organization treats its people authentically down to the roots of its business model.

It is key for an entrepreneur to remember that a person working for him/her is actually providing their service.

At the same time, people of all cultures, race, religion, gender etc.
have to be treated equally and with respect, such that they mutually flourish and grow together.

Benefits of Entrepreneurial Competencies Taking actions to implement your ideas.

Strategizing and planning the steps that need to be taken.

Preparing an action plan and timeline.

  Understanding the need or the problem your offering is fulfilling or solving.

   Networking with stakeholders.

 Interacting with customers.

 Gaining and analyzing insights.


      Gaining the know-how of creating, building, launching, sustaining, managing and growing a business.

Looking for alternatives and adjusting plans according to analysis and feedback.

Evaluating and calculating the risk involved.

Building and motivating a team.

Being patient and staying motivated to overcome and work around various obstacles.

Showing the value that the business is creating for stakeholders and customers.
Activity I – Self Reflection Self-reflect and check if you relate to the statements given below: I like to give myself challenges when I take on a new project.

Where others see problems, I see possibilities.

I do not worry about what others will think before doing something important.

I am fairly curious and I am continually in search of discovery.

I want to build something that will be recognized publicly.

When I take on a project I have confidence that I will carry it out successfully.
I feel that am capable of seeing many solutions to a problem.

I always try to learn lessons from my failures.

I am not afraid to take on initiatives.

I manage my stress well in ambiguous and uncertain situations.

After some self-reflection, consider the competencies of entrepreneurs given above.

Self-evaluate yourself on these competencies by giving a rank number to each.
For example: Self-confidence – 1 Commitment – 4 Problem Solving – 6 5 Entrepreneurial Skills - XII According to the above ranking, one thinks that self-confidence is their strongest competency.

Commitment comes at the 4th rank and problem solving at the 6th.

Thus, problem solving as a competency is weaker than commitment for the person in the example given above.
___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ Activity II – Understanding competencies Let us look at the example of Byju Raveendran, who started the famous education platform, Byju’s.
He took some action steps that helped him develop these competencies and make Byju’s a successful startup.

Example: Byju’s learned English, Math and science on his own during his school years.

Especially, he learnt English by listening to commentaries.

With this, he realized how for many students in the Indian education system, learning is involved rote learning and then reproducing the learnt information in the exams, with bare minimum application.
With Byju’s, he successfully tackled the root of the problem of learning.

Which competency did he develop?

Ans.

Problem Solving Please write the competencies, among the competencies given below, that you think match with the action step taken by Byju Raveendran in the section below.

When Byju’s started, it was in the offline format.

With classrooms with a large capacity, interaction was limited and rather not really possible.
Thus, Byju Raveendran started to think of ways to solve this problem, by predicting what kind of doubts a student could have and visualized and conceptualized the teaching material beforehand.

___________________________________________________________________ ___________________________________________________________________ In 2003, Byju’s helped a few friends study for the CAT exam, which is the common entrance exam for Indian business and management schools.
With his tutoring, his friends did well in the exam, after which he wrote the exam and ended up scoring in the 100th percentile.

However, he returned to his job in the UK, but came back to India two years later, and helped some more people with the CAT exam.

By this stage, he got immense positive 6 Entrepreneurial Skills - XII feedback and had coached enough number of people who got good results.

This made Raveendran realize that he actually felt passionate about teaching.
He quit his IT job in the UK, took to an entrepreneurial path and stayed committed to it.

___________________________________________________________________ ___________________________________________________________________ Teaching for entrance exams such as CAT, Raveendran realised that the problem was much deep rooted.

The insight he gained was that students were not learning basics and fundamentals at the school level, and this led to Byju’s expand into subject-wise coaching for classes 6th to 12th.
___________________________________________________________________ ___________________________________________________________________ Raveendran started by conducting workshops on the weekend.

Once he got to a stage when one classroom wasn’t enough to accommodate students, he booked an auditorium with a seating capacity of 1,200.

From a classroom of 40, he was confident enough to the leap of going 30x but did not worry about whether it would fill in.
It was only by the sixth or seventh week the auditorium was full.

___________________________________________________________________ ___________________________________________________________________ Once Byju’s started targeting 6th to 12th standards, they had to reach out to students directly.

Not just by engaging children, but even by convincing parents that an app is suitable for real-world coaching, Byju’s started to make some progress.
Raveendran had to influence all stakeholders of education such as students, parents, tutors, educators and schools to communicate his vision and make them trust the product.

___________________________________________________________________ ___________________________________________________________________ Interacting with some of the brightest students and taking feedback on Byju’s courses, Raveendran realised that most of them, unfortunately, studied only because of the fear of exams.
They are taught to solve a problem but aren’t enabled to find a problem.

He realised that if his strategy of self-learning was adopted in early years at school, it could potentially create a huge impact.

___________________________________________________________________ ___________________________________________________________________ Byju believes that it is important to execute things in a business, keeping the pace faster than slower.
In the initial stages, there is a need of a strong idea and a team.

Byju’s made a dynamic and detailed business plan in the initial stages, in order to avoid making any huge mistakes.

At the same time, he was flexible to making quick or midway changes, throughout the plan.

However, he thinks it is best to try out multiple things and keep making changes, but some clarity should be there about the core idea.
___________________________________________________________________ ___________________________________________________________________ Raveendran started his education career as a teacher tutoring for CAT.

The initial workshops were free and students paid for advanced workshops once they liked it.

From there, once his classes started being recognized as “Byju’s classes”, he thought of turning it into a venture.

With great perseverance, he overcame challenges, especially in entering the school space.
In this highly regulated system, marketing to students was difficult, but he kept moving forward taking one step at a time.

___________________________________________________________________ ___________________________________________________________________ Initially, Raveendran didn't have any drive or passion to start a business, but when he started teaching, he realised that it was his passion and it gave him a lot of satisfaction and enjoyment.
When his classes started creating an impact, he turned it into a business proposition and launched Think and Learn, the parents company of Byju’s.
___________________________________________________________________ ___________________________________________________________________ 7 Entrepreneurial Skills - XII As a teacher turned entrepreneur, Raveendran not only has to create and deliver good courses, but also build and manage the team, strategize marketing campaigns, ensure quality, get continuous funding and scale the company.
___________________________________________________________________ ___________________________________________________________________ Activity III - Taking Initiative Have you taken initiative towards anything?

Consider the following statements to think about it: - Think about a time you went above and beyond what was expected of you.

- Think about a situation when you were creative.

What did you do?
What did you do?

- Can you remember a situation when you took responsibility for something and had negative consequences?

What did you learn from it?

- Have you ever noticed and raised issues in a project/activity/discussion?

- Think about a time when you worked on a group project and made improvisations in it.

Write a situation when you took initiative.

Mention what you liked/disliked about it.

Share your learnings (if any) from the experience.
___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ 8 Entrepreneurial Skills - XII Activity IV - Taking Initiative Are there any activities/ideas/events/projects etc.
that you want to try and have not got the chance to?

In the space given below, make a list of things you want to take an initiative for, in the next 1 to 5 years.
___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ Activity V – Information Seeking Read the situations below and write answers to the questions given below: - Who should the entrepreneur seek information from?
- What information should the entrepreneur acquire?

Simaya has started a company which makes bags and wallets using fish leather.

Fish leather is made by using the waste material from the fishing industry.

Simaya is trying to understand who her customers are.

She is not sure if she should start selling the products online or supply to offline stores or do both.

She does not know what will be the touch points where people could buy the products she is planning to design.
She wonders what preferences and choices people would have.
___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ Dhruv has started a brand that customizes kid’s shoes.
While he has made sales on some online websites selling kids products, he is unable to make a sustainable profit.

He is also looking for ways to raise some capital to start selling from his own website and retail store.
___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ 9 Entrepreneurial Skills - XII Janvi is thinking about starting a business that conducts training workshops for working professionals.
She plans to teach business-related topics and develop employability skills through the workshops.

However, Janvi does not know what kind of competition will be there.

She wonders if she will be able to get enough customers to beat the competition in such a crowded space.
___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ Activity VI – Goal Setting SMART Goals S.M.A.R.T.
is an acronym for the 5 steps of specific, measurable, attainable, realistic, and timely goals.

It’s a simple tool used by businesses to go beyond the realm of fuzzy goal- setting into an actionable plan for results.

Specific: Great goals are well-defined and focused.

The moment one focuses on a goal, the goal becomes a magnet, pulling resources towards it.

The more focused one’s energies, the more power one generates.
Measurable: A goal without a measurable outcome is like a sports competition without a scoreboard or scorekeeper.

Numbers are an essential part of business.

Concrete numbers should be put in the goals to know if one is on track.

Attainable: A goal must be achievable.

Far too often, small businesses can set goals beyond reach.

No one has ever built a multi–crore business overnight.

Venture capitalists and angel investors discard countless business plans of companies with outlandish goals.
Realistic: Achievable business goals are based on the current conditions and realities of the business climate.

One may desire to have the best year in business or increase revenue by 50%, but if a recession is looming and three new competitors open in the market, then the goals are not as per the realities of the market.

Timely: Business goals and objectives just don’t get done when there's no time frame tied to the goal-setting process.

Every plan or project must follow a timeline.


Whether the business goal is to increase revenue by 20% or find 5 new clients, a time-frame or deadline to accomplish the goal must be set.

Let us do small exercises to understand SMART goals better.

Specific: Look at the examples below.

Underline the goals that are specific.

Get in shape.

I will go to the recreational centre Monday, Wednesday, and Friday at 6:00 a.m. and walk around the track for 30 minutes.

Get good grades.
Get good grades.

I will sit at the table every day at 3:30 p.m. and work on assignments given that day in school until 4:30.

Upon completion, I will place the assignments in the correct folder, take to school and turn in before class starts.

Get rich.

I will save 25% of my paycheck every month and invest in mutual funds until I am 55 years old.

10 Entrepreneurial Skills - XII Measurable: The above examples give good indications.

Write in the measurable outcomes from the above examples of #2, #4, #6.
#2.

______________________________________________________________ #4.

______________________________________________________________ #6.

______________________________________________________________ Attainable: Which of these goals seem attainable?

Earn 10 times the money I make compared to this month.

Exercise daily for one hour.

Eat an apple a day.

Watch television for all night but wake up early every morning.

Live in Antarctica for a year, after I have lived in Mumbai all my life.
Realistic: If I wanted to run a marathon and I haven’t done any training, which goal would better represent my reality?

I will walk every day for 30 minutes for one week, jog for 30 minutes for two weeks, add five minutes to my work out every week until I reach 60 minutes and continue training for three months.

I will run the marathon on Saturday.

Timely: Give yourself a deadline.

When you have an end date, you will finish your goal.

Look at the above examples (all of them).


Write the goals that have a time frame.
__________________________________________________________________________________________ __________________________________________________________________________________________ __________________________________________________________________________________________ __________________________________________________________________________________________ __________________________________________________________________________________________ Activity VII – Goal Setting Write an academic or personal goal below in the SMART manner: S – My SPECIFIC Goal __________________________________________________________________ __________________________________________________________________ __________________________________________________________________ – How M __________________________________________________________________ __________________________________________________________________ __________________________________________________________________ MEASURE will I my progress?
– What ACTIONS A __________________________________________________________________ __________________________________________________________________ __________________________________________________________________ __________________________________________________________________ must take to I accomplish this goal?

R – Is my goal REALISTIC and attainable?


____ Yes ____ No 11 Entrepreneurial Skills - XII – Is my goal T ______________________________________________________________________ ______________________________________________________________________ ______________________________________________________________________ When TIMELY?

goal this will be accomplished?

Activity VIII – Decision Making Decision Making……..
The Lunar Disaster On April 11, 1970 astronauts James Lovell, John L. Swigert, and Fred W. Haise blasted off from Cape Kennedy aboard Apollo 13.

At 54 hours and 54 minutes into the mission a large explosion crippled the spacecraft.

Four days the attention of the world was riveted on the disabled spacecraft.

Because of quick thinking and the use of computers, mission control was able to get the crippled spacecraft safely back to Earth.
In this activity, you are a member of the crew of a spaceship scheduled to rendezvous with the mother ship, located on the lighted surface of the moon.

Due to mechanical difficulties, your ship is forced to land on the dark side of the moon, 200 miles (~ 322 km) from the mother ship.

During the emergency landing much of the equipment aboard was damaged and since survival depends on reaching the mother ship, only the most critical items must be chosen for the 200 mile trip.
Below is a list of 15 items left undamaged by the crash.

Rank each of these items in order of importance from 1 the most important to 15 the least important.

Here is some background information, which may be useful.

There is no atmosphere or water on the moon, and the moon has almost no magnetic field.

A FM transmitter uses straight-line communication and has a range of less than 100 miles on the Earth, so on the moon the range would be considerably less.
The gravity on the moon is 1/6th that of the Earth.

The items below are in no particular order.
My Ranking | (Individual score) Group ranking | (group score) | | Item Box of matches Food concentrate Nylon rope, 50 feet Parachute silk Portable heater | | | | Two 0.45 caliber pistols | Dehydrated pet milk, One case | Two 100-Pound oxygen tanks | Star Map-Moon Constellations | Life raft Magnetic compass 5 gallons of water Signal flares | | | | First-aid kits, injection needles | Solar powered FM transmitter | 12 Entrepreneurial Skills - XII | | | | | | | | | | | | | | After ranking each item 1-15, get together with another student and re-rank the items remember 1 is the most important and 15 is the least important.
With your partner(s) AGREE on a ranking (Do not change your individual score) and place the number under group rank (each person in the group should have the same GROUP rank).

After completing both individual and group ranking your teacher will give you the actual ranking determined by NASA.

To score subtract the difference between the number written with the actual number given by your teacher.
Place the difference in the column labeled score (Individual and group) After completing the scoring add up the numbers in each score column and place the total in the spaces below.

Individual score _______________ Group score _________________ Reflect on the decision-making process you followed.

Discuss why the scores increased or decreased after working together.

Discuss ways of thinking critically in the future.

Note: The answer key of actual ranking/score is given at the end of the chapter.
Activity IX – Team Building For this activity, you have to work on the following problem: How can the problem of waste generation be solved?

This could greenery/kitchen waste, hazardous waste etc.

include e-waste, plastic waste, Get into groups of 7.

Take a piece of paper.

Any one member has to start with writing an idea to solve the problem on the paper.

Then, pass the paper to the next person in the group.
The next person has to build on the idea written by the first person and then pass it to the third person.

The third person will then build on the idea written by the second person and so on.

This will continue once all people in the group have built on the idea of the previous person.

The final idea will then be discussed and refined by the group and shared with the class.

Activity X - Adaptability In this activity, we will make a story using other classmates’ inputs.
To do this, please follow the steps given below: Get in groups of 10.

Any one person in the group has to start a story from “Once upon a time…..” and stop after speaking for around 1 minute.

As the first person stops, the second person has to continue the story started by the first person.

Similarly, after the second person speaks for 1 minute, the third person has to continue the story from where the second person stopped and so on.

This goes on until the story is completed by the tenth person.
After doing this exercise, reflect on the following questions: Did you find challenging to adapt to someone else’s story?

Why?

What did you learn about yourself from this exercise?

One a scale of 1 to 10, how would you rate your skill of adaptability?

13 Entrepreneurial Skills - XII Activity XI – Problem Solving Read the statements below about different startups of India and how they define themselves.

Based on that, and your own research, enlist the problems that these startups are trying to solve: 1.
Interview Bit is an interview preparation platform, especially designed for software engineers.

It provides support to job candidates via a range of practice questions and on-demand mentors.

___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ 2.

Cure.Fit is a startup in the fitness and healthcare industry.
It has a chain of fitness centres which offer different types of fitness activities and classes everyday.

It also has an part of called Eat.fit, where a customer can order healthy meals everyday.

___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ 3.
1mg is India’s leading consumer health platform by offering an online pharmacy network and generic medicine engine.

It aspires to be the trusted health partner for all Indians and its mission is to make healthcare accessible, understandable and affordable for all Indians.

Users can find information about medicines based on ailments, class, companies, and brands, and buy them.
___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ 4.

EduKart is an online marketplace for education that aims to democratize education and bring more flexibility into the system.

It offers both short certification courses and degree programmes for which it has partnered with renowned institutions.
___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ 5.

Recyclebank is encouraging people to recycle household waste by using gamification.

The methods around gamification include rewards in the form of discount coupons on daily goods and services, points for making progress and a competitive element to encourage people to recycle household waste.
Currently, Recyclebank has improved the process of recycling in more than three hundred communities and has more than four million members.
___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ Activity XII – Problem Solving Read any daily newspaper of the last three days and make a list of problems that you think can be solved by starting a business or through an entrepreneurial project.

Which problems did you come up with?
14 Entrepreneurial Skills - XII ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ Activity XIII - Creativity Scamper is a technique that guides you to think creatively about any existing product or service.
It was created by Bob Eberle, an author of books about creativity for children.

Scamper is a set of seven thinking techniques mean to assist those who utilize them in discovering atypical solutions to problems.

SCAMPER is an acronym, with each letter representing a different technique that can used to trigger creative ideas: Substitute: Take one thing or part away and add something else.

Combine: Put one or two things together to create something completely new.
Adapt: Change something so that it can be used in a specific situation.

Modify/Minify/Magnify: Change size, shape or colour or any specific trait and reimagine it.

Purpose/Put to Other Use: Use it in a way that it wasn’t meant to be used.

Change the purpose it is used for.

Eliminate: Remove any unnecessary element that might create an issue or a problem.

Reverse/Rearrange: Change the direction or orientation.

Look at it differently.

May be move it upside down or use it backwards.


Example: 15 Entrepreneurial Skills - XII Use S.C.A.M.P.E.R.

to build a better school desk/table or chair.

Feel free to draw or write your ideas!

1.

What will you substitute?

Can you change any parts?

Can you change its shape, color or thickness?


___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ 2.

What will you combine?

Can you combine any materials, parts or ideas?


___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ 3.

What will you adapt?

What else is like this?

What other ideas does it suggest?

Can you incorporate something?


___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ 4.

Will you modify, minimize or maximize?

Can you make something higher, bigger or stronger?

Can you simplify something or make it smaller?


___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ 5.

What else could I use it for?

Can it be used in an unconventional way?


___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ 6.

What will you eliminate?

Can you think of something unnecessary that can be removed or omitted?
___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ 16 Entrepreneurial Skills - XII ___________________________________________________________________ 7.

Will you reverse or rearrange any parts?

What if you moved or turned it upside down?

Can you imagine another layout or sequence?

Can you interchange components or patterns?


___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ Activity XIV - Creativity Think of 10 unconventional uses of the following objects….

1.
1.

Paper Clip ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ 2.

Tennis Ball ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ 3.
Clothes Hanger ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ 4.

Feather __________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ 5.
Water bottle ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ Skill-based Activities:      Research and administer a self- rating questionnaire and score responses on entrepreneurial competencies.

Collect a small story/ anecdote of prominent successful entrepreneurs.
Identify entrepreneurial competencies reflected in each story and connect it to the definition of entrepreneurial competencies.

Prepare a competency profile of yourself.
Participate in games and exercises on changing entrepreneurial behavior and development of competencies for enhancing self- confidence, problem solving, goal setting, information seeking, team building and creativity 17 Entrepreneurial Skills - XII Answer Key for Activity VIII Item Box of matches Food concentrate Nylon rope, 50 feet Parachute silk Portable heater Two 0.45 caliber pistols Dehydrated pet milk, One case Two 100-Pound oxygen tanks Star Map-Moon Constellations Life raft Magnetic compass 5 gallons of water Signal flares First-aid kits, injection needles Solar powered FM transmitter Actual Score | (Individual score) Actual Score | (group score) 15 | 4 | 7 | 8 | 5 | 11 | 12 | 1 | 3 | 6 | 14 | 2 | 13 | 9 | 10 | 15 | 4 | 7 | 8 | 5 | 11 | 12 | 1 | 3 | 6 | 14 | 2 | 13 | 9 | 10 | 18 Entrepreneurial Skills - XII INTRODUCTION: To achieve the aim of more sustainable economy and society, the concept of Green Jobs came into existence.
As discussed previously, the main objective of a sustainable society is judiciously using the natural resources for the present and future generation.

In 2008 the United Nations Environment Programme (UNEP), the International Labour Organization (ILO), the International Trade Union Confederation (ITUC), and the International Employers Organization (IEO) jointly launched the Green Jobs Initiative.
The purpose is to bring a just transition to a green economy by providing space for workers, employers, and governments to negotiate on policy effective in providing equitable opportunity to green jobs.

Green Jobs: Towards Decent Work in a Sustainable, Low-Carbon World is the first comprehensive report on the emergence of a ―green economy‖ and its impact on the world of work in the 21st Century.
The report defines ―green jobs‖ as work in agriculture, industry, services and administration that contributes to preserving or restoring the quality of the environment.

Green jobs reduce the environmental impact of enterprises and economic sectors, ultimately to levels that are sustainable.

Green jobs are found in many sectors of the economy from energy supply to recycling, from agriculture and construction to transportation and hospitality to tourism.
They help to cut the consumption of energy, raw materials and water through high-efficiency strategies, de-carbonize the economy and reduce greenhouse-gas emissions, minimize or avoid altogether all forms of waste and pollution, protect and restore ecosystems and biodiversity.

Green jobs play a crucial role in reducing the environmental footprint of economic activity.

This reduction is gradual and the different jobs contribute to different degrees.
Workers manufacturing fuel-efficient or hybrid cars, for example, contribute less to reducing emissions from transport than those working in public transport systems.

Moreover, what is considered fuel-efficient today will no longer qualify in ten years‘ time.

The notion of a green job is thus not absolute, but there are ‗shades‘ of green and the notion will evolve over time.
Until now, there has been much anecdotal evidence indicating that the pattern of employment is indeed changing—and that new jobs are beginning to emerge in favour of greener, cleaner and more sustainable occupations.

What are the key drivers of green employment?

Green innovation helps businesses stay at the cutting edge, retaining existing jobs and creating new ones 1 Green Skill - XII Modern economies mobilize enormous quantities of fuel, metals, minerals, lumber, and agricultural raw materials.
Although some changes have been made in past decades to reduce the world economy‘s environmental impact, these gains are insufficient and may simply be overwhelmed by continued economic growth.

In view of the gathering environmental crisis, and especially the spectre of climate change, there is an urgent need to make economies far more sustainable and thus to re- examine the prevailing production and consumption model.
Concepts such as dematerialization, remanufacturing, ―zero waste‖ closed-loop systems, durability, and replacing product purchases with efficient services (such as ―performance contracting‖) have been discussed for some time and tested in some instances, but by and large have yet to be translated into reality.

Economic systems that are able to churn out huge volumes of products but require less and less labour to do so pose the dual challenge of environmental impact and unemployment.
In the future, not only do jobs need to be greener, their very essence may need to be redefined.

ACTIVITY TIME:  Hold a group discussion on possible ways to promote Sustainable Development.

Do not forget to highlight the role of changing careers in propelling the idea of Sustainability  Discuss about probable green jobs that exist today and imagine that will emerge in next 10 years.

.

GREEN JOBS: i.

Urban Growers: They manage terrace top gardens to grow fruits and vegetables in urban areas.
They use environment friendly ways to grow fruits and vegetables.

Today there is a shift in the demand of consumers.

The rising instances of food adulteration and use of pesticides in fruits and vegetables has paved a way for need of Organic food.

Many people have their own organic gardens on roof tops to grow seasonal vegetables and fruits, while many do it as a hobby and love for gardening, there are many who do it for a living.

ii.
ii.

Clean Car Engineers: Recent initiations by Government on restricting the vehicular movement around Diwali time through ‗Odd-Even‘ Scheme says a lot about the need of Clean Car Engineers.

These people explore ways and means in which the cars don‘t emit poisonous gases and keep the air clean to breathe.

The Clean Car Engineers job is to design future transport that will be sustainable.
This would not only mean to help keep air clean but also how to keep natural resources available future generation without compromising the quality – as in average engine life, durability etc.

for 2 Green Skill - XII iii.

Alternative Sources of Jobs: Biofuel Energyiii non- Biofuel the is is conventional sought for to run vehicles without creating pollution.

and petrol Since fuel that 3 Green Skill - XII diesel create lot of pollution, there is a need to have clean fuel.
It is felt that fuel from bio mass or natural matter can help resolve this problem.

ivBuilding Roads with Plastic wastes: Engineers have found ways and means to solve two problems at one go.

The waste plastic generated in tons over the globe can be utilized to make roads.

This will not only provide better roads for vehicles to move but also solves the problem of waste generation.

iv.

vSolar Cell Technician: Use of solar energy is in high demand these days.
This calls for the services and knowledge of Solar Cell Technicians.

Using the right substance in the panels that is durable and affordable is a challenge.

These people test the same on different substances for better results.

v. vi.

vii.

viSolar Panel Engineers & Installer: Solar Power Plant engineers and installers play very important role in successfully designing and installing solar plants to produce electricity.
viiWind Energy Workers: After the solar energy, wind energy is also sought for to produce electricity.

Hence, the wind energy workers would be needed to lay down the plan for same.

viiiWave Energy Producers: Another way to generate electricity without exhausting resources could be using the energy of waves from oceans.

Since, 70% of our planet consists of water bodies, this could be useful in creating sustainable society.

viii.

ixWater Quality Technicians: Water Pollution is in its alarming state.
This has given rise to the need of Water Quality Technicians to help monitor the water quality and treat it.

ix.

xRain Water Harvesting Engineers: With the rising problem of scarcity of water, need to build Rain Water pits are on demand.

These are specialised to lay the plan and construct rain water harvesting systems (RWHS) for collecting the rain water and reusing same in buildings.

The RWHS may also be used to replenish ground water level.

x. xi.
x. xi.

xiWaste Water Treatment Workers: People involved in planning and constructing a system in green building to retreat the waste water from the same building and for secondary purposes.

reutilizing it xiiRecyclers: Waste generation across the globe has given rise to need of segregating waste.

The recycler‘s job is to segregate and collect the 4 Green Skill - XII recyclable products.

These days many recyclers are upcycling the waste products.

Over time, the need of recyclers is going to increase.
xii.

xiiiE-Waste Recyclers: With advancing technology, organizations and industries across the globe are facing the threat to dispose the e-waste generated by them.

Many organizations have now started contacting special recyclers who collect all the electronic waste and recycle it.

It is expected that in coming years, we will need more e-waste recyclers.

Gold is being extracted from e waste and is being used in various places.

xiii.
xiii.

xivSewage Treatment Plants: The process to treat the waste in its impure form at a sewage treatment plant involves human engineering.

People involved in the process will also have Green collar jobs.

xvEco-Tourism: Eco-Tourism is relatively new area focussing on socially responsible travel, personal growth and environmental sustainability.

This includes visiting fragile, pristine and undisturbed areas of nature.

xiv.

xv.
xiv.

xv.

xviGreen Builders: Green Builders ensure that environmental friendly things are used to build houses and buildings.

xviiGreen Design Professionals: The Green design professionals work in collaboration with Green Builders.

They lay the idea of how a building will look like after its completion.

The green design professionals also provide artistic beauty to buildings to make them look innovative and interesting.

xvi.
xvi.

xviiiEnergy Auditors: Energy Auditors inspect the buildings and measure heat, cooling, electrical and gas usage and find energy leakages in a structure and advise for corrective measures.

xvii.

xixEnergy Consultants: They help organizations Basic Principles of Green Building analyze their energy consumptions with aim to reduce the same.

xviii.

xxEnvironmental Engineers: Environmental engineers provide solutions to environmental problems by using engineering, biology and chemistry.
Providing solution to improve the quality of soil for better productivity, devising strategies to generate public electricity using renewable resources like solar street lights etc.

is a part of environmental engineering.

xix.

Xxi Nature Scientists: As we take step towards using sustainable means to create a sustainable society, it is very important to record and analyse the impact of our steps on environment.

Nature Scientists help in achieving this aim.

5 Green Skill - XII xx.

xxi.


xxiiWorking with a Non- Governmental Organisation (NGO): Working with an NGO the cause of Environment provides opportunity to closely work for creating a sustainable and better society.

for xxiiiEnvironmental Education Teacher: A teacher who takes up the role of sensitising young minds and creates acceptance amongst them to contribute in protecting environment.
Activity Choose any 4-5 Green Careers and prepare a brochure elaborating all the aspects like Educational Qualifications, Skills, Universities and colleges where these courses are available.

ROLE OF GREEN JOBS: i.

In toxin free homes: Collins English Dictionary defines Toxin as “any poisonous substance produced by bacteria, animals, or plants.‖ Do you think there are toxins in our environment?

What is your view of toxins in our homes?


Well, yes, there are toxins present in our environment and environment includes our homes also.

Hence, the role of green jobs in our homes is to make them toxin free so that we have a healthy life.
Toxins may be present in our homes in many ways such as – refrigerators releasing CFCs, cleaning and washing products, cosmetics, upholstery fabrics, rugs, mattresses, paint used on the walls, chemicals used to polish the fragrances, some kind of clothes that uses chemicals, use of RO and Microwaves in our kitchens etc.

floors, So, in order to ensure that our homes are safe from toxins and healthy places to breathe people with green collar jobs help us maintain a healthy environment.

ii.
ii.

In improving energy and raw material use: The exhaustive list of Green jobs mentioned above elaborately describes their role in improving the quality of energy.

The energy 6 Green Skill - XII produced through hydro-electric power plants, thermal power plants, nuclear power plants has grave consequences on the environment.

Using alternate source of energy to produce electricity will not only minimize the exploitation of resources but will help the economy to flourish.

iii.
iii.

greenhouse Limiting gas emission: The alternates that the green jobs provide for sustainable development definitely help curb the emission of greenhouse gases.

With the promotion of use of renewable sources in our homes and daily life, green jobs promise to limit the emission of harmful gases.

iv.

v. vi.

Minimizing waste and pollution: This problem has come a long way and the probable solution to this has been provided in 4Rs of sustainable development – REFUSE, REDUCE, REUSE & RECYCLE.
Following these has definitely helped minimize the waste and pollution.

But, the recyclers job at its best is trying to put a full stop to this problem.

The concept of upcycling and the avenues it has created for a green market are luring and helps resolve this problem to a great extent.

Protecting and restoring ecosystems: Various NGOs across the globe are working day and night to protect the wildlife, forests, endangered species etc.
With their efforts we have been able to protect and restore the degrading eco system that would otherwise have collapsed much earlier.

Their conscious efforts have certainly helped create awareness and sensitize masses to join hands together to have a sustainable ecosystem.

Support adaptation to the effects of climate change: Nature Scientist at every point of time keeps us aware about the changes happening in our environment.
It is because of them that we are able to prepare ourselves for the worst of the environmental changes and take measures to curb our ways to undo climate changes.

Activity :   In groups, prepare a power point presentation elaborating and discussing the role of green jobs in our daily life.

Remember to incorporate how Sustainable Development will be impacted in their absence.

Identify one area of difference you want to make.

How would you do that?

What is your idea?


What are the resources required to bring in the changes you think would work?

SOURCES https://en.wikipedia.org/wiki/Green_job#UNEP_Green_Jobs_Initiative 7 Green Skill - XII https://www.ilo.org/wcmsp5/groups/public/---dgreports/--- dcomm/documents/publication/wcms_098504.pdf https://www.ilo.org/wcmsp5/groups/public/@ed_emp/@emp_ent/documents/publication/wcms_15873 3.pdf 8 Green Skill - XII