Raju

NCERT Solutions for Class 11 Biology Chapter 22 Chemical Coordination and Integration

by

NCERT Solutions for Class 11 Biology Chapter 22 Chemical Coordination and Integration

These Solutions are part of NCERT Solutions for Class 11 Biology. Here we have given NCERT Solutions for Class 11 Biology Chapter 22 Chemical Coordination and Integration.

Question 1.
Define the following:
(a) Exocrine glands
(b) Endocrine glands Hormones
Solution:
(a) Glands with duct is known as an exocrine gland. They secrete their secretions through ducts. Eg: Pancreas.
(b) Gland without duct is known as an endocrine gland. They directly secrete their secretions. Eg: Pituitary gland.
(c) Hormones are non-nutrient chemicals which act as intercellular messengers and are produced in trace amounts. Eg: thyroxine.

Question 2.
Diagrammatically indicate the location of the various endocrine glands in our body.
Solution:
NCERT Solutions for Class 11 Biology Chapter 22 Chemical Coordination and Integration 1

Question 3.
List the hormones secreted by the following.
(a) Hypothalamus
(b) Pituitary
(c) Thyroid
(d) Parathyroid
(e) Adrenal
(f) Pancreas
(g) Testis
(h) Ovary
(i) Thymus
(j) Atrium
(k) Kidney
(l) G-ITract
Solution:
(a) Hypothalamus: Gonadotrophic releasing hormone (GnRH), somatostatin.
(b) Pituitary: Growth hormone, prolactin, thyroid-stimulating hormone, luteinizing hormone and follicle stimulating hormone, oxytocin, vasopressin.
(c) Thyroid: triiodothyronine (T3) and tetraiodothyronine (T4).
(d) Parathyroid: Parathyroid hormone.
(e) Adrenal: Adrenaline or epinephrine and noradrenaline or norepinephrine.
(f) Pancreas: Insulin and glucagon.
(g) Testis: A group of androgens mainly testosterone.
(h) Ovary: Estrogens and progesterone.
(i) Thymus: Thymosins.
(j) Atrium: Atrial Natriuretic factor (ANF)
(k) Kidney: Erythropoietin.
(l) G-I tract: Gastrin, secretin, cholecystokinin (CCK).

Question 4.
Fill in the blanks:
Hormones                      Target gland
(a) Hypothalamic hormones ……………….
(b) Thyrotrophin (TSH) ………………
(c) Corticotrophin (ACTH) ………………
(d) GonadobTjpfains(LH,FSH) ……………….
(e) MeIanotrophin(MSH) ………………..
Solution:
(a) Anterior pituitary and posterior pituitaiy.
(b) Thyroid glands
(c) Adrenal cortex
(d) Gonads (testis and ovary)
(e) Pituitary

Question 5.
Write short notes on the functions of the following hormones:
(a) Parathyroid hormone (PTH)
(b) Thyroid hormones
(c) Thymosins
(d) Androgens
(e) Estrogens
(f) Insulin and Glucagon
Solution:
(a) The secretion of PTH is regulated by the circulating levels of calcium ions. Parathyroid hormone (PTH) increases the Ca2+ levels in the blood. PTH acts on bones and stimulates the process of bone resorption. PTH also stimulates reabsorption of Ca2+ by the renal tubules and increases Ca2+ absorption from the digested food. PTH is a hypercalcemic hormone, i.e., it increases the blood Ca2+ levels. Along with TCT, it plays a significant role in calcium balance in the body.

(b) Thyroid hormones play an important role in the regulation of the basal metabolic rate. These hormones also support the process of red blood cell formation. Thyroid hormones control the metabolism of carbohydrates, proteins, and fats. Maintenance of water and electrolyte balance is also influenced by thyroid hormones. The thyroid gland also secretes the protein hormone thyrocalcitonin (TCH) which regulates blood calcium levels.

(c) Thymosins play a major role in the differentiation of T – lymphocytes, which provide cell-mediated immunity. In addition, thymosins also promote the production of antibodies to provide humoral immunity.

(d) Androgens regulate the development, maturation and functions of the male accessory sex organs like epididymis, vas deferens, seminal vesicles, prostate gland, urethra etc. These hormones stimulate muscular growth, growth of facial and axillary hair, aggressiveness, low pitch of voice etc. Androgens play a major stimulatory role in the process of spermatogenesis and act on the central neural system and influence male sexual behaviour. These hormones produce anabolic effects on protein and carbohydrate metabolism.

(e) Estrogens produce wide-ranging actions such as stimulation of growth and activities of female secondary sex organs, development of growing ovarian follicles, appearance of female secondary sex characters, mammary gland development. Estrogen also regulate female sexual behaviour.

(f) Glucagon is a peptide hormone, and plays an important role in maintaining normal blood glucose levels. Glucagon acts mainly on the liver cells and stimulates glycogenolysis resulting in increased blood sugar. In addition, this hormone stimulates the process of gluconeogenesis which also contributes to hyperglycemia. Glucagon reduces cellular glucose uptake and utilisation. Thus, glucagon is a hyperglycemic hormone.

Insulin is a peptide hormone, which plays a major role in the regulation of glucose homeostasis. Insulin acts mainly on hepatocytes and adipocytes and enhances cellular glucose uptake and utilisation. As a result, there is a rapid movement of glucose from blood to hepatocytes and adipocytes resulting in decreased blood glucose levels (hypoglycemia). Insulin also stimulates conversion of glucose to glycogen in the target cells. The glucose homeostasis in the blood is thus maintained jointly by the two insulin and glucagons.

Question 6.
Give example(s) of:
(a Hyperglycemic hormone and hypoglycemic hormone
(b Hypercalcemic hormone
(c) Gonadotrophic hormones
(d Progestational hormone
(e) Blood pressure lowering hormone
(f) Androgens and estrogens
Solution:
(a) Glucagon and insulin
(b) Parathyroid hormone
(c) LH and FSH
(d) Progesterone
(e) Atrial Natriuretic Factor (ANF)
(f) Testosterone and estradiol

Question 7.
Which hormonal deficiency is responsible for the following:
(a) Diabetes mellitus
(b) Goitre
(c) Cretinism
Solution:
Diabetes mellitus: Insulin deficiency.
Goiter: Deficiency of thyroid hormones due to deficiency of iodine.
Cretinism: Deficiency of thyroid hormones during childhood.

Question 8.
Briefly mention the mechanism of action of FSH.
Solution:
Follicle-stimulating hormone (FSH) and LH Stimulate gonadal activity. In males, FSH and androgens regulate spermatogenesis. In females, FSH is responsible for the growth and development of the ovarian follicles, maturation of egg, and secretion of estrogens

Question 9.
Match the following:
Column I Column II
(a) T4 (i) Hypothalamus
(b) PTH (ii) Thyroid
(c) GnRH (iii) Pituitary
(d) IH (iv) Parathyroid
Solution:
(a) – (ii)
(b) – (iv)
(c) – (i)
(d) – (iii)

VERY SHORT ANSWER QUESTIONS

Question 1.
Give two examples of endocrine glands.
Solution:
Examples of endocrine glands are
(i) pituitary gland
(ii) pineal gland.

Question 2.
Which gland secretes glucagon?
Solution:
Pancreas secretes glucagon.

Question 3.
What is the location of the pituitary gland?
Solution:
The pituitary gland is located in a bony cavity called Sella tursica and is attached to the hypothalamus by a stalk.

Question 4.
Which hormone is secreted by pars intermedia?
Solution:
Pars intermedia secretes melanocyte-stimulating hormone (MSH).

Question 5.
Which hormone is secreted by the pineal gland?
Solution:
Pineal gland secretes melatonin hormone.

Question 6.
Name one disorder caused by hyperfunctioning of the pituitary.
Solution:
Gigantism caused by hyperfunctioning of the pituitary.

Question 7.
How many lobes does the thyroid gland have?
Solution:
The thyroid gland is composed of two lobes which are located on either side of the trachea.

Question 8.
Which gland produces the hormone called thyrocalcitonin (TCT) which regulates the blood calcium levels?
Solution:
Thyroid gland secretes a protein hormone called thyrocalcitonin (TCT) which regulates the blood calcium levels.

Question 9.
Name the organ which secretes progesterone.
Solution:
Ovary secretes progesterone.

Question 10.
Name two hormones of pancreas.
Solution:
Glucagon and insulin are two hormones of pancreas.

Question 11.
Which gland secretes somatostatin?
Solution:
Hypothalamus secretes somatostatin.

Question 12.
Which complex is formed during the binding of hormone to a receptor ?
Solution:
Hormone-receptor complex is formed during the binding of a hormone to a receptor.

Question 13.
Name one hormone secreted by gastro-intestinal tract.
Solution:
Gastrin is secreted by gastro-intestinal tract.

Question 14.
Which hormone is secreted by testes and write the function of hormone also.
Solution:
Testosterone is secreted by testes. It controls growth and development of male secondary
v-sexual characters.

Question 15.
What are membrane bound receptors?
Solution:
Hormone receptors that are present on the cell membrane of the target cells are called membrane bound receptors.

Question 16.
How many types of cells are present in Islets of Langerhans?
Solution:
There are two types of cells present in Islets of Langerhans which are a-cells and P-cells.

Question 17.
Why is oxytocin called as birth hormone ?
Solution:
Oxytocin stimulates the contraction of smooth muscles of uterus and facilitates the child birth.

Question 18.
Why is vasopressin known as antidiuretic hormone?
Solution:
Vasopressin stimulates the reabsorption of water and electrolytes and reduces the loss of water through urine, known as diuresis. Hence it is called as anti-diuretic hormone.

Question 19.
What is cretinism ?
Solution:
Cretinism is reduction in body growth as well as underdevelopment of brain resulting in various structural and functional defects mainly due to deficiency of thyroxine (hypothyroidism) in infants and children.

Question 20.
Which hormone interacts with membrane bound receptor and does not normally enter the target cell?
Solution:
Follicle stimulating hormone interacts with membrane bound receptor and does not normally enter the target cell.

Question 21.
Which hormone opposes parathormone?
Solution:
Thyrocalcitonin opposes parathormone.

Question 22
Which hormone is known as anti-aging hormone?
Solution:
Melatonin, secreted by pineal gland is known as anti-ageing hormone.

SHORT ANSWER QUESTIONS

Question 1.
Discuss the location and function of parathyroid hormone.
Solution:
There are four parathyroid glands present on the back side of thyroid glands, two on each of the lobes of the thyroid gland.
The parathyroid glands secrete parathyroid hormone (PTH), a peptide hormone. Parathyroid hormone (PTH) increases the Ca2+ levels in the blood. PTH acts on bones and stimulates the process of bone resorption (dissolution/ demineralization. PTH also stimulates reabsorption of Ca2+ by the renal tubules and increases Ca2+ absorption from the digested food.

Question 2.
What is progesterone? Name two important functions of progesterone.
Solution:
Progesterone is a steroid hormone secreted by ovary.
Functions of progesterone are as follows:
• It supports pregnancy.
• It acts on mammary glands and stimulates the formation of alveoli (sac-like structures which store milk) and milk secretion.

Question 3.
Name the principal mineralocorticoid secreted by adrenal cortex. Give its any two functions
Solution:
Aldosterone is main mineralocorticoid secreted by adrenal cortex.
Functions of aldosterone are :
• It stimulates reabsorption of Na+ and water.
• It stimulates excretion of K+ and phosphate ions.

Question 4.
What are hormone receptors? What are the modes of their action ?
Solution:
Receptors are specific proteins present on the surface of target cell which bind with hormones and produce physiological changes in cell. Their are two types of hormone receptors which are discussed below:
NCERT Solutions for Class 11 Biology Chapter 22 Chemical Coordination and Integration 2

Question 5.
Name the gland that functions as a biological clock in our body. Where is this gland located ? Name its one secretion.
Solution:
Pineal gland functions as a biological clock in our body.

  • It is located on the dorsal side of the forebrain.
  • It secretes melatonin.

Question 6.
Where is thymus gland located in the human body ? Describe its role.
Solution:
The thymus gland is a lobular structure located on the dorsal side of the heart and the aorta.
– It secretes hormone thymosin, which has a stimulating effect on the immune system.
– Thymosin promotes proliferation and maturation of T-lymphocytes.

Question 7.
How does insulin act on high glucose content in the blood in a normal human body ?
Solution:
• Insulin is a peptide hormone, which plays a major role in the regulation of glucose homeostasis. Insulin acts mainly on hepatocytes and adipocytes (cells of adipose tissue), and enhances cellular glucose uptake and utilisation. As a result, there is a rapid movement of glucose from blood to hepatocytes and adipocytes resulting in decreased blood glucose levels (hypoglycemia)
• Insulin also stimulates conversion of glucose to glycogen (glycogenesis) in the target cells.
• The glucose homeostatasis in blood is thus maintained jointly by the two enzyme insulin and glucagon.

Question 8.
What is corpus luteum ? Name its one secretion.
Solution:
Corpus luteum is the structure formed by the ruptured ovarian follicles after ovulation.
– It mainly secretes the hormone progesterone.

Long ANSWER QUESTIONS

Question 1.
Explain briefly the structure and functions of middle ear.
Solution:
Calcitonin (from thyroid) : Essential for maintaining bone strength as it does not allow calcium mobilisation from bones. It also lowers plasma level of calcium ifthe same is high. Parathormone: Low level of parathormone secretion decreases blood plasma level of calcium, prevents reabsorption from bones and causes tetany. Higher levels of parathormone (PTH) increase plasma level of Ca2+ by withdrawal from bones resulting in (i) Inflammation and tenderness in bones due to dissolution of calcium from bones, formation of cavities which get plugged with fibrous nodes and cysts (osteitis fibrosa cystica) making bones soft deformed and prone to fracture, (ii) Excess plasma calcium gets deposited in various parts of body which often leads of obstruction and death.

Question 2.
Draw a well labelled diagram showing the location of parathyroid gland. Discuss the function/(s) of parathormone and hyperparathyroidism.
Solution:
NCERT Solutions for Class 11 Biology Chapter 22 Chemical Coordination and Integration 3
Function : Parathormone (Collip’s hormone) regulates the metabolism of calcium and phosphate between blood and other tissue.
(i) Hyperparathyroidism : It leads to demineralisation resulting in softing and bending of bones. An excess of parathormone cause osteoporosis and kidney stones.

Question 3.
What are the causes for following disorders?
(a) Acromegaly
(b) Cretinism
(c) Gigantism
(d) Myxoedema
Solution:
Disorders and their causes.
(a) Acromegaly (Acro-extremity, megaly – large) – It is caused by excess secretion of growth hormone after adulthood is reached.
(b) Cretinism : It is caused by deficiency of thyroid hormone in infant.
(c) Gigantism : It is caused by excess of growth hormone from early age.
(d) Myxoedema: It is caused by deficiency of thyroid hormone in adults.

We hope the NCERT Solutions for Class 11 Biology at Work Chapter 22 Chemical Coordination and Integration, help you. If you have any query regarding NCERT Solutions for Class 11 Biology at Work Chapter 22 Chemical Coordination and Integration, drop a comment below and we will get back to you at the earliest.

IT Sample Papers Class 10 CBSE Set 4 for Practice

by

Students can access the IT Sample Papers Class 10 CBSE with Solutions and marking scheme Set 4 will help students in understanding the difficulty level of the exam.

Computer IT Sample Paper Class 10 Set 4 for Practice

Time: 2 hrs
Maximum Marks: 50

General Instructions

  1. Please read the instructions carefully.
  2. This Question Paper consists of 21 questions in two sections: Section A & Section B.
  3. Section A has Objective Type Questions whereas Section B contains Subjective Type Questions.
  4. Out of the given (5 + 16 =) 21 questions, a candidate has to answer (5 + 10 =) 15 questions in the allotted (maximum) time of 2 hours.
  5. All questions of a particular section must be attempted in the correct order.
  6. Section A : Objective Type Questions (24 Marks)
    1. This section has 5 questions.
    2. Marks allotted are mentioned against each question/part.
    3. There is no negative marking.
    4. Do as per the instructions given.
  7. Section B : Subjective Type Questions (26 Marks)
    1. This section has 16 questions.
    2. A candidate has to do 10 questions.
    3. Do as per the instructions given.
    4. Marks allotted are mentioned against each question/part.

SECTION A: Objective Type Questions

Answer any 4 out of the given 6 questions based on Employability Skills (1 × 4 = 4)

(i) _______ skills are essential for working in an organisation.
(a) Stress
(b) Communication
(c) Good communication
(d) None of these
Answer:
(c) Good communication

(ii) Awareness about our _______ is not a kind of self-awareness.
(a) Biases
(b) Yoga
(c) Mediation
(d) None of these
Answer:
(a) Biases

(iii) The shortcut key for printing the presentation is _______
(a) Alt + P
(b) Ctrl + P
(c) Shift+ P
(d) Ctrl + A
Answer:
(b) Ctrl + P

(iv) A/An _____ has a good vision towards the achievement of his goals.
(a) entrepreneur
(b) self-confident
(c) goal-oriented
(d) None of these
Answer:
(a) entrepreneur

(v) ______ is a word for a person, place, thing or idea.
(a) Pronoun
(b) Noun
(c) Article
(d) Paragraph
Answer:
(b) 20th and 21th

(vi) Sustainable Forest Management which were developed in Europe during the ______ centuries.
(a) 18th and 16th
(b) 20th and 21th
(c) 17th and 18th
(d) None of these
Answer:
(c) 17th and 18th

2. Answer any 5 out of the given 6 questions (1 × 5 = 5)

(i) Which is the descriptive text aimed at helping user to identify the chart?
(a) Chart title
(b) Plot area
(c) Chart area
(d) Gridlines
Answer:
(a) Chart title

(ii) A document is a paper with written contents and the process of preparing a document is called _______
(a) Page break
(b) Work area
(c) Documentation
(d) None of these
Answer:
(c) Documentation

(iii) The processed form of data is known as ______
(a) value
(b) information
(c) knowledge
(d) None of these
Answer:
(b) information

(iv) Quemana works with a variety of ______ platforms.
(a) Blog
(b) WordPress
(c) Hub
(d) None of these
Answer:
(a) Blog

(v) The backbone of the www is made up of files called ______
(a) web browser
(b) web pages
(c) server
(d) client
Answer:
(b) web pages

(vi) To insert a ______ page break, select the row below where you want to insert the page break.
(a) vertical
(b) ruler
(c) horizontal
(d) None of these
Answer:
(c) horizontal

3. Answer any 5 out of the given 6 questions (1 × 5 = 5)

(i) Full form of OLE is _______
(a) Object Link and Embed
(b) Object Linking and Embedding
(c) Object Linker and Embedding
(d) Objective Linking and Embedding
Answer:
(b) Object Linking and Embedding

(ii) HTML is used to create
(a) browser
(b) server
(c) webpages
(d) None of these
Answer:
(c) webpages

(iii) ______ option allows a user to edit picture.
(a) Edit
(b) Crop
(c) Paste
(d) Format
Answer:
(b) Crop

(iv) Each worksheet contains
(a) 1048576 rows
(b) 16384 columns
(c) Both (a) and (b)
(d) None of these
Answer:
(c) Both (a) and (b)

(v) Multiple mismatching copies of the same data is known as _______
(a) data inconsistency
(b) data redundancy
(c) data integrity
(d) None of these
Answer:
(a) data inconsistency

(vi) With most LAN’s cables, ______ is used for their connectivity.
(a PIC
(b) NIC
(c) NIP
(d) None of these
Answer:
(b) NIC

4. Answer any 5 out of the given 6 questions (1 × 5 = 5)

(i) _______ is a section of the document that appears at the bottom margin of the page.
(a) Footer
(b) Header
(c) Top
(d) Center
Answer:
(a) Footer

(ii) _______ is located on left of the formula bar.
(a) Formula bar
(b) Name box
(c) Active cell
(d) Ruler
Answer:
(b) Name box

(iii) A/An _______ language is a portion of a DML involving information retrieval only.
(a) DCL
(b) TCL
(c) Query
(d) None of these
Answer:
(c) Query

(iv) Internet security prevents attacks targeted at ________
(a) browsers
(b) operating system
(c) network
(d) All of these
Answer:
(d) All of these

(v) A field or a set of fields that uniquely identify each record in a table is known as a ________
(a) primary key
(b) alternate key
(c) candidate key
(d) foreign key
Answer:
(a) primary key

(vi) ______ are web based instant messaging softwares.
(a) WeChat
(b) Skype
(c) Viber
(d) All of these
Answer:
(d) All of these

5. Answer any 5 out of the given 6 questions (1 × 5 = 5)

(i) _______ displays worksheets as they would appear if you printed them out.
(a) Layout
(b) Page layout
(c) Page break
(d) None of these
Answer:
(b) Page layout

(ii) Alignments buttons are available on the ______ tab.
(a) Home
(b) Insert
(c) Format
(d) File
Answer:
(a) Home

(iii) Out of the following, which one is the most appropriate data field in context of employee table, if only one of these is required?
(a) Age in years
(b) Date of birth
(c) Age in days
(d) Age in months
Answer:
(b) Date of birth

(iv) The main advantage of circuit switching is ________
(a) delivery
(b) guaranteed delivery
(c) power band
(d) None of these
Answer:
(b) guaranteed delivery

(v) The contents of a cell can be changed by pressing _______ key on keyboard.
(a) F5
(b) F3
(c) F2
(d) None of these
Answer:
(a) F5

(vi) MAN provides communication services upto _______
(a) 100 m
(b) 100 km
(c) 10 km
(d) None of these
Answer:
(b) 100 km

SECTION B: Subjective Type Questions

Answer any 3 out of the given 5 questions based on Employability Skills. Answer each question in 20-30 words (2 × 3 = 6)

Question 6.
What do you mean by non-verbal communication?
Answer:

Question 7.
Explain the term self-motivation.
Answer:

Question 8.
How can you create new worksheet in MS-Excel?
Answer:

Question 9.
What do you mean by entrepreneur?
Answer:

Question 10.
What are the importance of sustainable development?
Answer:

Answer any 4 out of the given 6 questions in 20-30 words each (2 × 4 = 8)

Question 11.
How to create a new blank document in MS-Word?
Answer:

Question 12.
What do you mean by paragraph alignment?
Answer:

Question 13.
How to unfreeze the rows and columns in workbook?
Answer:

Question 14.
Explain the term table used in database.
Answer:

Question 15.
Distinguish between repeater and switch.
Answer:

Question 16.
Define the following:
(i) AutoSum function
(ii) Full screen workbook view
Answer:

Answer any 3 out of the given 5 questions in 50-80 words each (4 × 3 = 12)

Question 17.
What is absolute cell referencing?
Answer:

Question 18.
Explain the following :
(i) Modem
(ii) Web page
Answer:

Question 19.
Describe three data manipulation language commands.
Answer:

Question 20.
What is header and footer? How to insert Date/Time into Header/Footer?
Answer:

Question 21.
(i) Create the table SummerCamp with the following fields:

Column Name

Data Type

ChildIDVarchar(5)
FirstNameChar(20)
LastNameChar(20)
DOBDate
GenderChar(2)
GroupVarchar(5)

(ii) Consider the following table APPLICANTS and write the queries (a) and (b).

TABLE:APPLICANTS

No.NAMEFEEGENDERC_IDJOINYEAR
1012Amandeep30000MA012012
1102Avisha25000FA022009
1103Ekant30000MA022011
1049Arun30000MA032009
1025Amber40000MA022011

(a) To display NAME, FEE, GENDER, JOINYEAR about the APPLICANTS, who have joined before 2010.
(b) To display the names of all applicants in ascending order of their JOINYEAR.
Answer:

IT Sample Papers Class 10 CBSE Set 5 for Practice

by

Students can access the IT Sample Papers Class 10 CBSE with Solutions and marking scheme Set 5 will help students in understanding the difficulty level of the exam.

Computer IT Sample Paper Class 10 Set 5 for Practice

Time: 2 hrs
Max. Marks: 50

General Instructions

  1. Please read the instructions carefully.
  2. This Question Paper consists of 21 questions in two sections: Section A & Section B.
  3. Section A has Objective Type Questions whereas Section B contains Subjective Type Questions.
  4. Out of the given (5 + 16 =) 21 questions, a candidate has to answer (5 + 10 =) 15 questions in the allotted (maximum) time of 2 hours.
  5. All questions of a particular section must be attempted in the correct order.
  6. Section A : Objective Type Questions (24 Marks)
    1. This section has 5 questions.
    2. Marks allotted are mentioned against each question/part.
    3. There is no negative marking.
    4. Do as per the instructions given.
  7. Section B : Subjective Type Questions (26 Marks)
    1. This section has 16 questions.
    2. A candidate has to do 10 questions.
    3. Do as per the instructions given.
    4. Marks allotted are mentioned against each question/part.

SECTION A: Objective Type Questions

1. Answer any 4 out of the given 6 questions based on Employability Skills (1 × 4 = 4)

(i) …… allow you to communicate your message clearly and easily to a large audience.
(a) Good writing skills
(b) Communication
(c) Document
(d) None of these
Answer:
(a) Good writing skills

(ii) The feeling of self-awareness enhances our ……..
(a) mediation
(b) stress
(c) self-confidence
(d) clarity
Answer:
(c) self-confidence

(iii) In …. filter, detailed rules are specified as a part of spreadsheet cells.
(a) Normal
(b) Advanced
(c) Both (a) and (b)
(d) None of these
Answer:
(b) Advanced

(iv) …… is the process of identifying opportunities in the market place.
(a) Decisionmaker
(b) Management
(c) Entrepreneurship
(d) None of these
Answer:
(c) Entrepreneurship

(v) The ecology can be protected through imposition of ……. and afforestation.
(a) forestation
(b) deforestation
(c) Both (a) and (b)
(d) None of these
Answer:
(b) deforestation

(vi) consists of a main clause and sometimes one or more subordinate clauses. (1)
(a) Paragraph
(b) Noun
(c) Sentence
(d) All of these
Answer:
(c) Sentence

2. Answer any 5 out of the given 6 questions (1 × 5 = 5)

(i) Which of the following run horizontally in a worksheet and are identified by a number in the row header?
(a) Column letter
(b) Row number
(c) Name box
(d) Formula bar
Answer:
(b) Row number

(ii) Picture Shape option comes under ….. tab.
(a) Picture Format
(b) Tools Format
(c) Picture Tools Format
(d) None of these
Answer:
(c) Picture Tools Format

(iii) Table is also known as ….
(a) file
(b) record
(c) field
(d) sheet
Answer:
(a) file

(iv) Web based type of software is accessed using ……
(a) web server
(b) web browsers
(c) web client
(d) None of these
Answer:
(b) web browsers

(v) In ….. topology, each node is connected to two and only too neighbouring nodes.
(a) ring
(b) tree
(c) mesh
(d) star
Answer:
(a) ring

(vi) Which of the following is a boundary that specifies that cell is active at particular moment?
(a) Formula
(b) Cell pointer
(c) Cell address
(d) None of these
Answer:
(b) Cell pointer

3. Answer any 5 out of the given 6 questions (1 × 5 = 5)

(i) Which of the following options are available in Office button?
(a) New
(b) Open
(c) Save
(d) All of these
Answer:
(d) All of these

(ii) Which of the following offers a blog services?
(a) Drupal
(b) Joomla
(c) WordPress
(d) All of these
Answer:
(d) All of these

(iii) shortcut key is used to make the selected text underline.
(a) Alt + I
(b) Ctrl + I
(c) Ctrl + U
(d) Alt + U
Answer:
(c) Ctrl + U

(iv) Which of the following is the oldest spreadsheet package?
(a) MS-Excel
(b) Quattro-Pro
(c) VisiCalc
(d) All of these
Answer:
(c) VisiCalc

(v) …. view is a simple view of data arranged in rows and columns.
(a) Datasheet
(b) Design
(c) Table
(d) None of these
Answer:
(a) Datasheet

(vi) … is a multi-port network device, that provides access to computers.
(a) Switch
(b) Hub
(c) Gateway
(d) Bridge
Answer:
(b) Hub

4. Answer any 5 out of the given 6 questions (1 × 5 = 5)

(i) After selecting the text you need to click the … in the font group to make the font size larger than the current font size.
(a) size
(b) font size
(c) font
(d) font-style
Answer:
(b) font size

(ii) Hide and Unhide option is available in …. tab in MS-Excel.
(a) Edit
(b) Format
(c) Home
(d) Insert
Answer:
(c) Home

(iii) Database is a combination of …….
(a) hardware
(b) software
(c) Both (a) and (b)
(d) None of these
(c) Both (a) and (b)
Answer:

(iv) A computer connected to a network is known as …..
(a) host
(b) data
(c) node
(d) Both (a) and (c)
Answer:
(d) Both (a) and (c)

(v) Database is made up of all the following components except ….
(a) tables
(b) queries
(c) forms
(d) formula bar
Answer:
(d) formula bar

(vi) The ….. establishes an intelligent connection between a local network and external networks.
(a) bridge
(b) router
(c) gateway
(d) hub
Answer:
(c) gateway

5. Answer any 5 out of the given 6 questions (1 × 5 = 5)

(i) While entering a formula, cell address B $ 5 represents ……
(a) relative referencing
(b) mixed referencing
(c) absolute referencing
(d) None of these
Answer:
(b) mixed referencing

(ii) are the tools which are used to produce own drawings.
(a) Drawings tools
(b) Picture tools
(c) Both (a) and (b)
(d) None of these
Answer:
(a) Drawings tools

(iii) Facilities offered by database are
(a) the ability to store a large amount of data in a structured format, easy update, sort query, production of reports
(b) easy edition, spell check, perform calculations, library of mathematical functions, replication
(c) the ability to rotate images, copy and paste, fill scale
(d) None of the above
Answer:
(a) the ability to store a large amount of data in a structured format, easy update, sort query, production of reports

(iv) web browser supports only graphics information.
(a) Text-based
(b) Graphical
(c) Both (a) and (b)
(d) None of these
Answer:
(b) Graphical

(v) Formula for adding values of cell A1 to A5 would be …..
(a) SUM (A1 : A5)
(b) = SUM (A1 : A5)
(c) = TOTAL (A 1 : A 5)
(d) = SUM (A 1 + A 5)
Answer:
(b) = SUM (A1 : A5)

(vi) Computers connected to a LAN can share information through a common …..
(a) printer
(b) data
(c) network
(d) None of these
Answer:
(a) printer

SECTION B: Subjective Type Questions

Answer any 3 out of the given 5 questions based on Employability Skills. Answer each question in 20-30 words (2 × 3 = 6)

Question 6.
Explain the types of barriers to communicate.
Answer:

Question 7.
Explain the four kinds of self-awareness.
Answer:

Question 8.
Write the steps to save a document.
Answer:

Question 9.
What are the advantages of entrepreneurship?
Answer:

Question 10.
Define the solutions for sustainable development.

Answer any 4 out of the given 6 questions in 20-30 words each (2 × 4 = 8)

Question 11.
Write the steps to modify a style in a document.
Answer:

Question 12.
How to change the layout of the chart?
Answer:

Question 13.
What do you mean by filtering data?
Answer:

Question 14.
Explain the term report in a database.
Answer:

Question 15.
Distinguish between circuit switching and packet switching.
Answer:

Question 16.
Describe the following in a document:
(i) Ruler
(ii) Scroll bar
Answer:

Answer any 3 out of the given 5 questions in 50-80 words each (4 × 3 = 12)

Question 17.
Describe all methods for saving a document in MS-Word.
Answer:

Question 18.
Define the following
(i) Blog
(ii) Mesh topology
Answer:

Question 19.
What do you mean by mixed referencing?
Answer:

Question 20.
How to rename a field into a table in a database?
Answer:

Question 21.
(i) Create the table SHOP with the following fields:

Column NameData Type
S_NoVarchar(5)
P_NameChar(20)
S_NameChar(20)
QtyInt
CostFloat
CityChar(20)

(ii) Consider the following table CUSTOMER and write the queries (a) and (b).

CIDCNAMEGENDERSIDAREA
1001R SHARMAFEMALE101NORTH
1002M R TIWARYMALE102SOUTH
1003M K KHANMALE103EAST
1004A K SINGHMALE102EAST
1005S SENFEMALE101WEST
1006R DUBEYMALE104NORTH

(a) To display CNAME, AREA of all female customers from CUSTOMER table.
(b) To display the details of all the CUSTOMER in ascending order of CNAME within SID.
Answer:

IT Sample Papers Class 10 CBSE Set 2 with Solutions

by

Students can access the IT Sample Papers Class 10 CBSE with Solutions and marking scheme Set 2 will help students in understanding the difficulty level of the exam.

Computer IT Sample Paper Class 10 Set 2 with Solutions

Time: 2 hrs
Maximum Marks: 50

General Instructions

  1. Please read the instructions carefully.
  2. This Question Paper consists of 21 questions in two sections: Section A & Section B.
  3. Section A has Objective Type Questions whereas Section B contains Subjective Type Questions.
  4. Out of the given (5 + 16 =) 21 questions, a candidate has to answer (5 + 10 =) 15 questions in the allotted (maximum) time of 2 hours.
  5. All questions of a particular section must be attempted in the correct order.
  6. Section A : Objective Type Questions (24 Marks)
    1. This section has 5 questions.
    2. Marks allotted are mentioned against each question/part.
    3. There is no negative marking.
    4. Do as per the instructions given.
  7. Section B : Subjective Type Questions (26 Marks)
    1. This section has 16 questions.
    2. A candidate has to do 10 questions.
    3. Do as per the instructions given.
    4. Marks allotted are mentioned against each question/part.

SECTION A: Objective Type Questions

1. Answer any 4 out of the given 6 questions based on Employability Skills (1 × 4 = 4)

(i) _________ is the means by which message is sent.
(a) Data
(b) Channel
(c) Receiver
(d) None of these
Answer:
(b) Channel

(ii) _______ stress is a result of unexpressed worries.
(a) Internal
(b) Environmental
(c) External
(d) Survival
Answer:
(a) Internal

You are advised to attempt this sample paper without referring the answers given here. However, cross check your answers once you complete the paper.

(iii) ______ can be used for adding pictures in the presentation.
(a) Gallery
(b) Slide
(c) ClipArt Gallery
(d) None of these
Answer:
(c) ClipArt Gallery

(iv) An entrepreneur must form contacts with the ______ to analyse the market.
(a) Planning
(b) Competitors
(c) Self-confident
(d) None of these
Answer:
(b) competitors

(v) ______ brings about changes in people’s knowledge, attitude and skills.
(a) Sustainable development
(b) Natural resources
(c) Both (a) and (b)
(d) None of these
Answer:
(a) Sustainable development

(vi) ______ plays a major role in reaction to stress.
(a) Personality
(b) Positive attitude
(c) Behaviour
(d) None of these
Answer:
(a) Personality

2. Answer any 5 out of the given 6 questions (1 × 5 = 5)

(i) Page margins are the ________
(a) cell
(b) horizontal space
(c) blank spaces
(d) Vertical space
Answer:
(c) blank spaces

(ii) _______ is the rectangular area of the document window, where you can type the text.
(a) Work area
(b) Notes area
(c) Data area
(d) None of these
Answer:
(a) Work area

(iii) The default data type for a field is _______
(a) char
(b) int
(c) text
(d) None of these
Answer:
(c) text

(iv) The term _______ is derived from the words interconnection and networks.
(a) connection
(b) Internet
(c) Both (a) and (b)
(d) None of these
Answer:
(b) Internet

(v) A/An _______ that identifies a specific computer on the Internet.
(a) user name
(b) domain name
(c) E-mail
(d) None of these
Answer:
(b) domain name

(vi) AutoSum option is available in ________
(a) Home tab
(b) View tab
(c) Insert tab
(d) Layout tab
Answer:
(a) Home tab

3. Answer any 5 out of the given 6 questions (1 × 5 = 5)

(i) The status of your document like current page number and number of pages are given by ______
(a) formatting toolbar
(b) status bar
(c) standard toolbar
(d) None of these
Answer:
(b) status bar

(ii) The first network was ______
(a) ARPANET
(b) Internet
(c)NSFnet
(d) NET
Answer:
(a) ARPANET

(iii) _______ object includes effects such as shadows, outlines, colors, gradients and 3D effects.
(a) WordArt
(b) ClipArt
(c) DataArt
(d) Clip
Answer:
(b) ClipArt

(iv) A worksheet is a _______
(a) collection of workbooks
(b) processing software
(c) combination of rows and columns
(d) None of these
Answer:
(c) combination of rows and columns

(v) ________ is a set of programs that lies between the stored data and the users of database.
(a) Software
(b) Hardware
(c) Network
(d) All of these
Answer:
(a) Software

(vi) Satellite which are orbiting around the ______, provide necessary links for telephone and television service.
(a) wire
(b) earth
(c) station
(d) All of these
Answer:
(b) earth

4. Answer any 5 out of the given 6 questions (1 × 5 = 5)

(i) Linked data is stored in the ________
(a) destination file
(b) web file
(c) source file
(d) domain file
Answer:
(c) source file

(ii) _______ shortcut key is used to enter current time in a cell.
(a) Ctrl + Shift +;
(b) Ctrl + Shift + :
(c) Shift + Ctrl + :
(d) Ctrl + ;
Answer:
(a) Ctrl + Shift + ;

(iii) Field is the individual sub component of one _______
(a) record
(b) column
(c) data
(d) None of these
Answer:
(a) record

(iv) In www, a client is called _______
(a) web server
(b) webpage
(c) web browser
(d) None of these
Answer:
(c) web browser

(v) Duplication of data is known as _______
(a) data security
(b) data incomplete
(c) data redundancy
(d) None of these
Answer:
(c) data redundancy

(iv) Internet is a network of _______
(a) networks
(b) value
(c) data
(d) pages
Answer:
(a) networks

5. Answer any 5 out of the given 6 questions (1 × 5 = 5)

(i) The workbook views options allow user to view or see the _______ differently.
(a) data
(b) cell
(c) spreadsheet
(d) None of these
Answer:
(c) spreadsheet

(ii) Template includes _______ text that is surrounded by brackets.
(a) margin
(b) placeholder
(c) data source
(d) track changes
Answer:
(b) placeholder

(iii) For what, memo data type is used?
(a) To add table
(b) To store objects created in other programs
(c) For long text entries
(d) For short text entries
Answer:
(c) For long text entries

(iv) A router passes data packets from one network to another network based on their ______ not MAC address.
(a) IP address
(b) URL
(c) Web address
(d) None of these
Answer:
(a) IP address

(v) _______ is the main region of the chart in which your data is plotted.
(a) Chart area
(b) Plot area
(c) Data label
(d) Data series
Answer:
(b) Plot area

(vi) The LAN stands for _______
(a) Large Area Network
(b) Local Area Network
(c) Local Area Networking
(d) None of these
Answer:
(b) Local Area Network

SECTION B: Subjective Type Questions

Answer any 3 out of the given 5 questions based on Employability Skills. Answer each question in 20-30 words (2 × 3 = 6)

Question 6.
What do you mean by verbal communication?
Answer:
Verbal communication means communication through spoken oral and written words. It implies use of words which make up a language. It is the ability to communicate using words in understandable language i.e. English, Hindi, French, Urdu etc. Language play a significant role in verbal communication. The effectiveness of the verbal communication depends on the tone of the speaker, clarity of speech, volume, speed, body language and the quality of words used in conversation.

Question 7.
Explain the term fatigue related stress.
Answer:
Fatigue related kind of stress builds up over a long time like by working too long or too hard at our job, school or home. It can also be caused by exercising too much or too long.

If you do not know how to manage your time well or how to take time out for rest and relaxation, you will become a victim of fatigue related stress. This can be one of the hardest kinds of stresses to avoid because many people feel that it is out of their control.

Question 8.
What is Auto Correct feature in document? How to use it?
Answer:
AutoCorrect is an automatic data validation function commonly found in Word processors and text editing interfaces. It is a useful tool in Word for applying specific formatting or spelling for certain phrases often in your text. This feature will quickly fix the mis-spelling words and punctuation marks. To use AutoCorrect, follow the below steps:

  • Click on Review tab -> Proofing group.
  • Click on Spelling & Grammar option. Spelling and Grammar dialog box will appear.
  • When a possible spelling error is encountered, the spell check dialog opens and Word processor offers some suggested corrections.
  • Select any one of the suggested word and click on Auto Correct button.

Question 9.
What are the disadvantages of entrepreneurship?
Answer:
Some of the disadvantages of entrepreneurship are as follows :

  • Huge Amount of Time You have to dedicate a huge amount of time to your own business. Entrepreneurship is not easy and for it to be successful, you have to take a level of time commitment.
  • Risk An entrepreneurship involves high risk of loss. If the business fails then it will wipe away all the personal savings.
  • Hard Work An entrepreneur has to work very hard to make the new business very successful.
  • Uncertain Income There is no regular or fixed income available to an entrepreneur. So, there is uncertain kind of income received by an entrepreneur.

Question 10.
Describe any two problems related to sustainable development.
Answer:
Two problems related to sustainable development are as follows:

  • Poor management of natural resources combined with growing economic activities will continue to pose serious challenges to environment.
  • The most significant environmental problems are associated with resources that are renewable such as air and water. They have finite capacity to assimilate emissions and wastes but if pollution exceeds this capacity ecosystem can deteriorate rapidly.

Answer any 4 out of the given 6 questions in 20-30 words each (2 × 4 = 8)

Question 11.
Write the steps to insert text wrapping.
Answer:
To insert text wrapping, follow the given steps:

  • Click where you want to text wrapping.
  • Click Page Layout tab -> Page Setup group -4 Breaks. A drop-down menu will appear.
  • Select Text Wrapping from Page Breaks section.

Question 12.
What do you mean by conditional formatting in Excel?
Answer:
Conditional formatting is a feature in Excel and other spreadsheet programs that allows to change the appearance (font, color, border, shading) of a cell, depending on certain conditions. When a conditional format is applied on a cell, it means the formatting of the cell is based on a condition.

Question 13.
Describe the term wireless fidelity.
Answer:
Wireless Fidelity (Wi-Fi) is a universal wireless networking technology that utilises radio frequencies to transfer data. Wi-Fi allows high speed Internet connections without the use of cables or wires. Wi-Fi networks can be designed for private access within a home or business. It can be used for public Internet access at ‘hotspots’ that offers Wi-Fi access such as restaurants, coffee shops, hotels, airports, convention centres and city parks.

Question 14.
How to remove header or footer from the document?
Answer:
Steps to remove header or footer are as follows:

  • Click Insert tab.
  • Select Header or Footer option from the Header & Footer group.
  • Click Remove Header or Remove Footer.
    Now, header or footer gets removed from the document.

Question 15.
How to apply a custom view in workbook?
Answer:
To apply a custom view, follow the given steps:

  • On the View tab, in the Workbook Views group, select the Custom Views.
  • The Custom Views dialog box will appear, in the Views box, select the name of the view that you want to apply and then click Show button.

Question 16.
Define the following:
(i) Delete command
(ii) DCL command
Answer:
(i) Delete Command To discard unwanted data from a database, the delete command is used,

(ii) DCL Command These commands are used to assign security levels in database which involves multiple user setups. They are used to grant defined role and access privileges to the users.

Answer any 3 out of the given 5 questions in 50-80 words each (4 × 3 = 12)

Question 17.
Write the steps to wrap text around a picture in a document.
Answer:
Steps to wrap text around a picture in a document are as follows:

  • Select the picture.
  • Select the Picture Tools Format tab. (This tab appears only after insertion of a picture).
  • Click the Text Wrapping in the Arrange group.
  • Select any one option from the drop-down list. In this example, we will select Tight.
  • Move the picture around to see how the text wraps for each setting.
  • The Position button has pre-defined text wrapping settings. The Position button is placed to the left of the Text Wrapping button.
  • Click the Position button and a drop-down list of Text Wrapping options will appear. Move your cursor over the various text wrapping styles. A live preview of text wrapping will appear in the document.
  • If you cannot get your text wrapped the way you wish, select More Layout Options… from the Position menu. You can make more precise changes from the Advanced Layout dialog box that appears.

Question 18.
Define the following:
(i) Web address
(ii) Benefit of networking
Answer:
(i) Web is a collection of documents (web pages) stored on computers around the world. Each
web page has an address describing where it can be found. This address is known as Web Address or URL (Uniform Resource Locator).
A web address identifies the location of a specific web page on the Internet, such as http://www.1earnyoga.com
On the web, web addresses are called URLs. It is the web address for a website or a web page. The URL specifies the internet address of a file stored on a host computer connected to the internet.

(ii) Computer network is very useful in modern environment, so some of the benefits of networking are discussed here:

  • File Sharing Networking of computers helps the users to share data files.
  • Hardware Sharing Users can share devices such as printers, scanners, CD-ROM drives, hard drives, etc.
  • Application Sharing Applications can be shared over the network and this allows to implement client/server applications.
  • User Communication This allows users to communicate using e-mail, newsgroups, video conferencing within the network.
  • Access to Remote Database By networking, we are able to access to the remote database. It is easy for any person using his PC to make reservations for aeroplanes, trains, hotels, etc., anywhere in the world with instant confirmation within the network.

Question 19.
How to save the workbook in MS-Excel?
Answer:
Steps to save the workbook are as follows:

  • Click at Microsoft Office button.
  • Do one of the following:
  • Choose Save As, if you would like to save the file for the first time or save the file by different name.
  • Choose Save, if the file has already been named.
  • Press Ctrl+S from keyboard.
  • Save As dialog box will appear.
  • Type the file name in File name box and choose Excel Workbook from the Save As type list box.
  • Click at Save button.
    The default extension of excel workbook is .xlsx.

Question 20.
How to open existing table in a database? Give two ways to do this.
Answer:
Existing table can be opened by two ways which are as follows:

  1. In Datasheet View To open a table in a Datasheet View, follow these steps:
    • Find a table in the All Access Objects list (the left hand window).
    • Right click on a table and select Datasheet View. Datasheet View represents the data in a table.

or
Select Home tab and click the View drop-down arrow from Views and select the Datasheet View.

2. In Design View To open a table in a Design View, follow these steps:

  • Find a table in the All Access Objects list (the left hand window).
  • Right click on the table and select Design View. Design View represents the structure of the table.

or
Select the Home tab and click the View drop-down arrow from Views group and select the Design View.

Question 21.
(i) Create a table SHOP with the following fields:

Column NameData Type
CodeVarchar(5)
NameChar(50)
TypeVarchar(3)
CostInt
MarginFloat
QtyInt

(ii) Consider the following table EmployeeSalary and write the queries (a) and (b).
Table: Employee Salary

LastNameFirstNameDeptPayrollNumberSalary (?)Job Title
ShenJamesFinanceA62119500Payroll Clerk
GuptaShruthiFinanceM50235000Accountant
BediReetaFluman ResourceM42118500Secretary
WalkerTiaSalesW81524000Sales Represen-tative
ShafiaAhmedFactoryH21939000Factory Manager
MittalChaviPurchasingM13420000Purchasing Clerk

(a) Write a command to update the salary of the employee to 25000, whose job title is secretary.
(b) List all data of table EmployeeSalary.
Answer:
(i) CREATE TABLE SHOP (Code Varchar(5), Name Char(50), Type Varchar(3), Cost Int,
Margin Float, Qty Int);

(ii) (a) UPDATE EmployeeSalary SET Salary = 25000 WHERE JobTitle = ‘Secretary’;
(b) SELECT * FROM EmployeeSalary;

IT Sample Papers Class 10 CBSE Set 3 with Solutions

by

Students can access the IT Sample Papers Class 10 CBSE with Solutions and marking scheme Set 3 will help students in understanding the difficulty level of the exam.

Computer IT Sample Paper Class 10 Set 3 with Solutions

Time: 2 hrs
Max. Marks: 50

General Instructions

  1. Please read the instructions carefully.
  2. This Question Paper consists of 21 questions in two sections: Section A & Section B.
  3. Section A has Objective Type Questions whereas Section B contains Subjective Type Questions.
  4. Out of the given (5 + 16 =) 21 questions, a candidate has to answer (5 + 10 =) 15 questions in the allotted (maximum) time of 2 hours.
  5. All questions of a particular section must be attempted in the correct order.
  6. Section A : Objective Type Questions (24 Marks)
    1. This section has 5 questions.
    2. Marks allotted are mentioned against each question/part.
    3. There is no negative marking.
    4. Do as per the instructions given.
  7. Section B : Subjective Type Questions (26 Marks)
    1. This section has 16 questions.
    2. A candidate has to do 10 questions.
    3. Do as per the instructions given.
    4. Marks allotted are mentioned against each question/part.

SECTION A: Objective Type Questions

1. Answer any 4 out of the given 6 questions based on Employability Skills (1 × 4 = 4)

(i) Karan lives at a hostel in Shimla. He calls his mother who lives in Delhi, to get her approval for the robotics class which is going to start in his school next week onwards. However, due to disruption in the phone line, his mother could not understand and reply to him. He got very upset. Which another medium can he use to get immediate approval of his mother?
(a) E-mail
(b) Letter
(c) Message through friend
(d) Fax
Answer:
(a) E-mail

(ii) Trisha is always tense during exam time. She is a sincere and studious student, but the thought of exams creates anxiety in her. Which stress management technique that you would suggest to help her?
(a) Yoga
(b) Exercise
(c) Vacation with family
(d) All of these
Answer:
(d) All of these

(iii) …. ability of a person to do the things that need to be done without someone or something influencing us.
(a) Self-motivation
(b) Self-discipline
(c) Self-awareness
(d) Self-regulation
Answer:
(a) Self-motivation

(iv) According to the concept of sustainable development, the environment and development are issues.
(a) inseparable
(b) separate
(c) independent
(d) None of these
Answer:
(a) inseparable

(v) The cleaning of software installed in the computer cannot be achieved by
(a) disk cleanup
(b) backup
(c) cleaning CPU cabinet
(d) installing antivirus software
Answer:
(c) cleaning CPU cabinet

(vi) Entrepreneurship has a crucial role in the of the society.
(a) evolution
(b) planning
(c) functioning
(d) None of these
Answer:
(c) functioning

2. Answer any 5 out of the given 6 questions

(i) …… is not an instant messaging service.
(a) Skype
(b) Yahoo! Messenger
(c) Firefox
(d) Whatsapp
Answer:
(c) Firefox

(ii) …… is the process of emptying a place in case of an emergency, disaster.
(a) Accident
(b) Evacuation
(c) Hazards
(d) Exiting
Answer:
(b) Evacuation

(iii) Richard needs to set up a network for his office where he wants to save all the data in a centralized system and other computers will take the services from the centralized system. Which architecture will be the best suitable for him?
(a) Peer-to-Peer
(b) Client-Server
(c) Point-to-Point
(d) Ring
Answer:
(b) Client-Server

(iv) A …… is a device that converts digital computer signals into a form (analog signals) that can travel over phone lines and vice-versa.
(a) repeater
(b) switch
(c) router
(d) modem
Answer:
(d) modem

(v) ….. is specifically designed to minimize or maximize the result according to a set of rules that you define in a spreadsheet.
(a) Goal Seek
(b) Scenario
(c) Solver
(d) Subtotal
Answer:
(c) Solver

(vi) ……. refers to the vertical or horizontal placement of a graphic in relation to the chosen anchor point.
(a) Alignment
(b) Footer
(c) Margin
(d) Headings
Answer:
(a) Alignment

3. Answer any 5 out of the given 6 questions (1 × 5 = 5)

(i) Krishna wants to make a flowchart for his programs in a Word document. Which option should he use to accomplish this task efficiently?
(a) Drawing / Shapes
(b) Symbols
(c) Pictures
(d) All of these
Answer:
(a) Drawing / Shapes

(ii) Fatima has inserted a picture in a document. But she wants to cut-off a part of the picture. Which option she should use to accomplish the task?
(a) Cut
(b) Copy
(c) Crop
(d) Layout
Answer:
(c) Crop

(iii) The intersection point between a row and column is called ….
(a) row
(b) column
(c) table
(d) cell
Answer:
(d) cell

(iv) Amrita is celebrating her 14th birthday. She wants to invite her friends and family members to the party. Which feature will she use to send the same invite to many people with different addresses without typing it again and again?
(a) Mail Merge
(b) Letter Wizard
(c) Document Type
(d) None of these
Answer:
(a) Mail Merge

(v) A …… is a model that you use to create other documents.
(a) Styles
(b) Template
(c) Wizard
(d) Sample
Answer:
(b) Template

(vi) Formulas in a spreadsheet must begin with a ….. sign.
(a) $
(b) @
(c) #
(d) =
Answer:
(d) =

4. Answer any 5 out of the given 6 questions (1 × 5 = 5)

(i) …… is a tool to test “what-if” questions.
(a) Scenario
(b) Solver
(c) Macro
(d) Average
Answer:
(a) Scenario

(ii) Rohit scored 25 out of 30 in English, 22 out of 30 in Maths. He wants to calculate the score in IT he needs to achieve 85 percent in aggregate. Suggest him the suitable option out of the following to do so.
(a) Macro
(b) Solver
(c) Goal Seek
(d) Sub Total
Answer:
(c) Goal Seek

(iii) …. can be used in a spreadsheet software to jump to a different location from within a spreadsheet and can lead to other parts of the current file, to different files or even to websites.
(a) Illustrations
(b) Hyperlinks
(c) Links
(d) Filter
Answer:
(b) Hyperlinks

(iv) ….. uses the keyboard as a pointing device instead of a mouse.
(a) Mouse key
(b) Toggle key
(c) Filter key
(d) Sticky key
Answer:
(a) Mouse key

(v) Krish and Kritika have done a survey of age wise literacy rates of their locality as a school project, which they have created in a spreadsheet. They both want to work simultaneously to complete it on time. Which option they should use to access the same spreadsheet to speed up their work.
(a) Consolidate worksheet
(b) Shared worksheet
(c) Link worksheet
(d) Lock worksheet
Answer:
(b) Shared worksheet

(vi) database is a type of database that stores data in several tables.
(a) Flat
(b) Relational
(c) Both (a) and (b)
(d) None of these
Answer:
(b) Relational

5. Answer any 5 out of the given 6 questions (1 × 5 = 5)

(i) In database …. helps us to retrieve the filtered data based upon some conditions.
(a) forms
(b) reports
(c) queries
(d) table
Answer:
(c) queries

(ii) A ….. is one which connects computers and devices in a limited geographical area such as home, school, computer laboratory, office building, or closely positioned group of buildings.
(a) LAN
(b) WAN
(c) MAN
(d) PAN
Answer:
(a) LAN

(iii) Rudrakshh wants that the name column of a table must not be left blank. Help him to identify the field property for this purpose.
(a) Length
(b) Default
(c) Entry required
(d) Format
Answer:
(b) Default

(iv) …. can be set for a field if the user doesn’t provide any value while entering the values in the table.
(a) Required
(b) Default
(c) Primary key
(d) Format
Answer:
(b) Default

(v) Aadya wants to create a connection between two or more tables. Suggest her the option to accomplish the task.
(a) Table
(b) Form
(c) Relationships
(d) Sorting
Answer:
(c) Relationships

(vi) data type takes the values in the form of 0 and 1 in the database.
(a) Integer
(b) Text
(c) Boolean
(d) Memo
Answer:
(c) Boolean

SECTION B: Subjective Type Questions

Answer any 3 out of the given 5 questions based on Employability Skills. Answer each question in 20-30 words (2 × 3 = 6)

Question 6.
Communication skills are very important for any business. Explain any two elements of a communication process.
Answer:

  1. Sender The person beginning the communication.
  2. Message The information that the sender wants to convey.

Queries 7.
Mention any two misconceptions about the entrepreneurship.
Answer:

  1. The misconception is that every business idea needs to be unique or special
  2. A misconception we have is that only a person having a big business is an entrepreneur.

Question 8.
Goal setting is a very essential factor in your personal life. List all the SMART methods to set the goals. Explain A’ in brief.
Answer:
SMART goals are:
S – Specific
M – Measurable
A – Achievable
R – Realistic
T – Time bound
Achievable breaking down big goals into smaller parts will make the goal achievable.

Question 9.
What are the measures to increase the performance of a computer system?
Answer:
The performance of a computer system can be increased by removing any extra files such as temporary files and images. We can use some disk cleaner software, which helps us clean up the unnecessay files.

Question 10.
How can an individual contribute to Sustainable Development Goals?
Answer:
Sustainable development can actually happen only when each one of us works towards it. One has to become a responsible environment citizen who can protect the environment through our own efforts, who can help others to get quality education by reducing inequalities in the society etc.

Answer any 4 out of the given 6 questions in 20-30 words each (2 × 4 = 8)

Question 11.
Differentiate between relative and absolute hyperlinks with the help of an example.
Answer:
Differences between relative hyperlink and absolute hyperlink are as follows:
• Relative hyperlink/URL The relative URL, on the other hand, does not use the full web address and only contains the location following the domain. It assumes that the link you add is on the same site and is part of the same root domain. The relative path starts with the forward slash and leads the browser to stay within the current site.
e.g. <a href=“/xyz.html””>
• Absolute hyperlink/URL An absolute URL is the entire address from the protocol to the domain name and includes the location within your websites in your folder system names within the URL. Basically, it is the full URL of the page that you link to.
e.g. <a href=//www.example.com/xyz.html””>

Question 12.
What is the utility of text wrapping in a document?
Answer:
Text wrapping refers to the relation of graphics to the surrounding text, which may wrap around the graphics on one or both sides, be overprinted behind or in front of the graphics, as separate paragraph or character.

Question 13.
What is the use of macros in a spreadsheet?
Answer:
Macros help in saving time in cases when the same set of tasks are to be dew repeatedly like formatting or applying a similar formula in a similar range of data. It can be used to name and record a set of actions.

Question 14.
Write any two advantages of online shopping.
Answer:

  1. Customers can purchase items from the comfort of their own homes or work place.
  2. Customers do not have to stand in queues in cash counters to pay for the products that have been purchased by them.

Question 15.
Differentiate between primary key and foreign key.
Answer:

Primary keyForeign key
It is used to uniquely identify data in the table.It is used to maintain relationship between tables.
Two or more rows can’t have same primary key.It can carry duplicate value for a foreign key attribute.

Question 16.
Define the following Hotspots:

  1. WiMAX
  2. Wi-Fi

Answer:

  1. WiMAX It is a wireless communications standard designed for creating Metropolitan Area Networks (MANs). It is similar to the wi-fi standard, but supports for greater range of coverage.
  2. Wi-FI It stands for wireless fidelity. It is a wireless networking technology that allows devices such as computers, mobile devices and other equipment to interface with the Internet.

Answer any 3 out of the given 5 questions in 50-80 words each (4 × 3 = 12)

Question 17.
Elaborate four different types of styles which can be provided in a Word Processor.
Answer:
Different types of styles in Word Processor are:

  1. Paragraph The paragraph style contains both paragraph and text formatting attributes: indents, tabs, font, text size.
  2. Character The character style formats only characters, not paragraph.
  3. Linked The linked style is a combination style that can be applied to both paragraphs and individual characters. The difference depends on which text is selected, when you apply the style.
  4. Table The table style is applied to tables, to add lines and shading to the table cells contents.
  5. List The list style is customized for presenting lists of information. The styles can include bullets, numbers, indentation and other formats typical for the parts of a document that present lists of information.

Question 18.
Define the following:

  1. Subtotals
  2. Consolidating Data

Answer:

  1. Subtotals This function returns the subtotal of the number in a column in a list or database. The subtotal function is a built-in function in Excel, that is categorized as a Math function. It can be used as a worksheet function in Excel. As a worksheet function, the SUBTOTAL function can be entered as part of a formula in a cell of a worksheet.
  2. Consolidating data It provides a graphical interface for copying data from one range of cells to another, then running one of a dozen functions on the data. During consolidating, the contents of cells from several streets can be combined in one place.

Question 19.
What precautions must be taken to improve online security?
Answer:

  1. Antivirus and antispyware programs offer real time protection monitoring your computer for any
    changes by malware software.
  2. Use strong passwords a combination of alphanumeric and special characters could be used for creating a password that is not a easy to crack or guessed by other users.
  3. Secure transactions because information, such as credit card details or personal information is sent over the network.
  4. Use encryption software to protect your data from unauthorized users.

Question 20.
What is DBMS? Explain any two advantages of DBMS.
Answer:
Database Management System (DBMS) It is a collection of programs that enables users to create, maintain database and control all the access to the database. It is a computer based record keeping system. The primary goal of the DBMS is to provide an environment that is convenient and efficient for user to retrieve and store information. It acts as an interface between the application program and the data stored in the database. DBMS is a software package that manages database, e.g. MySQL, INGRES, MS-ACCESS etc.
DBMS is actually a tool that is used to perform any kind of operation on data in database. It also maintains data consistency in case of multiple users. The purpose of a DBMS is to bridge the gap between information and data.
Advantages of DBMS are as follows:

  1. The DBMS helps create an environment in which end users have better access to more and better managed data.
  2. Such access makes it possible for end users to respond quickly to changes in their environment.

Question 21.
(i) The structure of a table “ITEM” is given below. Suggest suitable data type and size of each column.

Column NameData TypeSize
Itemno……..…………
Iname……..…………
Price……..…………
Quantity……..…………

(ii) Consider the following table “ITEM”.

ItemnoInamePriceQuantity
11Soap4080
22Powder8080
33Face Cream25025
44Shampoo120100
55Soap Box2050

Write queries to
(a) Display the total amount of each item. The amount must be calculated as the Price multiplied by Quantity for each item.
(b) Display the details of items whose Price is less than 50.
Answer:

Column Name

Data Type

Size

ItemnoInteger2
InameVarchar15
PriceInteger3
QuantityInteger3