Series : GE1FH SET-4
Roll No.
Q.P. Code 89
andidates must write the Q.P. Code
on the title page of the answer-book.
NOTE
Please check that this question
15I paper contains 15 printed pages.
(I) A-47 I Ig f fau ry-a) Q.P. Code given on the right hand
side of the question paper should be
written on the title page of the
answer-book by the candidate.
(I) 4T sa R SH SA93 À 21 99a|III) Please check that this question
paper contains 21 questions.
(IV) ChyT AA aI JR feGT T6 hÀ |(IV) Please write down the Serial
Number of the question in the
answer-book at the given place
FH 94-47 before attempting it.
YG fs 15 f4HE AI HHT|(V) 15 minute time has
been allotted to
read this
10.15 G f question paper. The
gT | 10.15 question paper will be distributed
at 10.15 a.m. From 10.15 a.m. to
10.30 a.m., the candidates will read
the question paper.only and will not
write any answer on the answer
book during this period.
INFORMATION TECHNOLOGY
yferhaH 3j5 : 50
Timeallowed : 2 hours
Maximum Marks : 50
89 580 1| Page P.T.0.
General Instructions :
() Please read the instructions carefully.
(i) This question paper consists of 21 questions in two Sections : Section A and
Section B.
(i) Section Ahas Objective type questions, whereas Section B contains Subjective
bype questions.
(iv) Out of the given (5 + 16) = 21 questions, a candidate has to answer
(5+ 10) = 15 questions in the allotted (maximum) time of2 hours.
() Allquestions of aparticular section must be attempted in the correct order.
(vi) Section A:0bjective Type Questions (24 marks):
(a) This section has 5 questions.
(b) There is no negative marking.
(c) Do as per the instructions given.
(d) Marks allotted are mentioned against each
(vi) Section B: Subjective Type Questions (26 marks) :
question/part
(a) This section has 16 questions.
(b) A candidate has to do 10questions.
() Doas per the instructions given.
() Marks allotted are mentioned against each question/part.
Section A
(Objective Type Questions) (24 Marks)
1, Answer any 4 out of the given 6 questions on Employability Skills.
() 4x1=4
The school is organizing a Career Counselling Workshop.
Which of the
following will be the most effective method of communication to inform all
students of the school ?
(A) Face-to-face informal communication
(B) Notice/Poster
(C) Phone call
(D) Meet everyone in
person
(ii) Which of the following is the most
suitable term for the ability to regulate
one's own emotions and help others also to do the
same?
(A) Managing emotions (B) Harnessing emotions
(C) Knowing emotions (D) Supressing emotions
89 P.T.0.
3| Page
Roshin studies in class Xand is practising hard with a lot of sample papers
(iüi)
study
to get good marks in her exams. She gets up early in the morning to
and completes her revision work. This is an example of.
(B), Self-motivation
(A) Self-awareness
(C) Influential motivation (D) Emotional intelligence
be stored in the
(iv) A is a location where agroup of files can
computer.
(A). Folder (B) SMPS
(C) CMOS (D) UPS
(v) Which of the following is a myth about entrepreneurs ?
to take
(A) An entrepreneur should be confident and should be able
decisions.
(B) Every business idea must be unique or special.
C) An entrepreneur should keep trying new ideas.
different
(D) An entrepreneur should be creative and should have
solutions to the problem.
(vi) Which one of the following is the most important factor for sustainable
development and helps us become aware of our role as a responsible
citizen ?
(A) Sports (B) Education
(C) Business (D) IMiteracy
2. Answer any 5 out of the given 6 questions. 5x1=5
0) Ravi has to prepare a project report. He wants to save certain formatting
features and then apply them on the project report. He can use the
feature of OpenOffice Writer.
(A) Styles (B) Image
(C) Mail Merge (D) Preview
(i) During a recent excursion, Roshni has taken some pictures for making a
report in Writer. She wants to increase the contrast of the images. Which
one of the following image filters should she use in Writer ?
(A) Aging (B) Mosaic
(C) Sharpen (D) Smooth
P.T0.
89
5| Page
(ii) Which one of the following image arrangement options in Writer sends the
drawing object behind the text ?
(A) To background (B) Toforeground
(D) Back one
(C) Behind the text
and
(iv) feature of Writer is based on different types of heading styles
is used togive the listing of the contents of the document.
(A) Table of Heading (B) Index
(C) Label of Contents (D) Table of Contents
(v) is the default template for the files being created in Writer.
(A) Resume template (B) Project Report
(C) Blank document (D) Chapter
(vi) Shanta is creating a project report in Writer and wants to apply the same
style on headings / titles in the entire document as she has done at the
beginning of the document. She can use the feature of Writer to
apply the same format on each line/ word, wherever needed.
(A) Fill Style (B) Fill Format
(C) Apply Feature (D) Apply Character
3. Answer any 5 out of the given6 questions. 5x1=5
() To add your own commentsin Calc, select ’ Track changes ’
Comment.
(A) File (B) Edit
(C) Insert (D) Data
(i) To add a newsheet in the
the left bottom of the
spreadsheet, click on the sign located at
(A)
spreadsheet.
(B) /
(C) %
(D). +
(i) is a set of values that can
be used within the
spreadsheet to explore and compare various calculations in the
changing conditions. alternatives depending on
(A) Sort
(B) Filter
(C) What-if Scenarios
89 (D) Comments
7| Page P.T0.
(iv) The recorded macros are actually stored as
(A) aset of instructions in a programming language
(B) a sequence of data cells
(C) adocument
(D) a list ofvalues
the complete path along with filename
() While creating a hyperlink in Calc, if
is given then it is an example of
(A) Relative hyperlink (B) Mixed hyperlink
(D) Folder hyperlink
(C). Absolute hyperlink
Calc allowS you to create a group of cells automatically and
(vi) This tool in
common functions like sum, average on the grouped data. It is
apply
known as tool.
(A) Sum
(B). Subtotal
(D) Common
(C) Function
5x1=5
4. Answer any 5 out of the given 6 questions.
and
(1) is the database software that is used to create, manipulate
manage data.
(A) Ingress (B) Writer
(C) Paint (D) Windows
(i) The process of arranging data in ascending or descending order is known
as
(A) Filtering (B) Tracking
(C) Purification (D) Sorting
(iii) With reference to LibreOffice Base, which of the following is a valid data
type to indicate the monetary values?
(A) Money (B). Currency
(C) Rupee (D) Dollar
(0) Data can be retrieved and displayed from one or more tables in a DBMS
using a
(A) Referential integrity (B) Domain
(C) Query (D) Field
P.T.0.
89
9|Page
input by adding the
(v) While designing a formn, it is suggested to get the date
to the date field to prevent entering invalid dates.
(B) Text input
(A) Calendar (D) Number input
(C) Timer
designing a forn, titles, headings or sub-headings may be added
(vi) While tool boX.
using toolavailable on the Form Controls
(A) Textbox (B) Label
(C) Title
(D) Heading
5×1=5
5. Answer any 5 out of the given 6 questions.
is a state of physical, mental and social well-being.
()
(B) Popularity
(A) Richness
(D) Activity
(C) Health
(ii) Which one of the following isa class B ignition material ?
(A) Paper (B) Gas
(C) Electrical equipment (D) Potassium
(iii) The has prepared the policy to provide employees with a healthy
and safe work environment.
(A) GoIT (B) DoIT
(C) TolT (D) SoIT
(iv) RSI stands for:
(A) Recurring Syndrome Injury (B) Repetition Symptom Injury
(C) Recessive Stress Injury (D) Repetitive Strain Injury
(v) is the science that deals with
designing and
at workplace so that people can use them easily and arranging the things
(A) Health science
safely.
(B) Ergonomics
(C) Fixture science
(D) Work Economics
(vi) Which one of the following isa wrong safety
(A) Store all cleaning guideline ?
chemicals in tightly closed containers in separate
cupboards.
(B) Never distract the
attention of people who are working near a fire or
with some machinery,tools or
(C) Wear loose clothing or equipment.
(D) Make sure all areas have jewellery while working with machines.
89 proper lighting
11|Page P.TO.
Section B (26 marks)
(Subjective Type Questions)
words
3 out of the given 5 questions on Employability Skills in 20 -30 3×2=6
Answer any
each.
meaning of any 2 C's out of the 7 C's of effective
6. Briefly explain the
Communication.
7. What is Stress management ?
in perfect working condition.
8. Give any four tips to keep the computer
entrepreneur.
9. Mention any four main functions of an
sustainable development.
10. Explain any two problems related to
4x2=8
20- 30words each.
Answer any 4 out of thegiven 6 questions in
Writer, explain Frame style category
11. Out of various style categories provided by
in brief.
should be followed while naming a
12. What is a Macro ? Give any two rules that
Macro or module in Calc.
an example to support your
13. What is the main purpose of Goal Seek in Calc ? Give
answer.
setting a relationship between two
14. What are the important prerequisites for
tables in LibreOffice Base ? Mention any two.
requirements while
15. For a computer workplace, give any two health and safety
using a keyboard.
16. Excessive use of computers might have a bad impact on your vision. Give any two
eye-related problems that might arise due to long hours spent on a computer.
wordseach. 3x4=12
Answer any 3 out of the given 5 questions in 50 - 80
objects in Writer ?
17. (a) What is the benefit of grouping drawing
image alignment feature in
(b) Differentiate between text wrapping and
Writer.
18. Mr. Amit, Sales Manager of ABC Sales Corporation has created a spreadsheet in
LibreOffice Calc that lists Sales for different years in different regions in
based
different worksheets, He wants to summarize and make certain decisions
on it.
Help him by answering the following questions :
(a) Which tool in Calc can be used to combine the sales data from multiple
sheets into a single summary sheet 7 P.TO
89 13|Page
Name the Menu Option and Sub-Menu Option
that can be used to
(b) worksheets.
generate combined summary of all the
total of all sales.
Name the function that can be usedto display
(c) document stored at a different location
(a) He wants to open asummary a text stored in a cell. How can it be
the sheet by clicking on
from within
done?
been signed a contract of handling fire safety and
Imagine that you have and
19.
company. You need to spread awareness on fire safety
emergency in a
emergency handling to the employees.
Answer the following questions :
Give any two fire prevention measures at the workplace.
(a) the workplace.
handling procedures at
(b) Give any twobasic emergency
relating twotables in adatabase.
Give any twoadvantages of
20. (a)
many-to-many relationship between the tables in a database.
(b) Explain
21. Consider the following table: Table: Student
Phone_Number
Student ID Name Age
9876543210
Amit 15
SO01 8765432109
16
SO02 Priya
7654321098
Priya 15
S003
Answer the following questions : database for your school in
task to design the student
(a) You are given the structure, suggest the datatype
LibreOffice Base. Based on the given table store student's-id
would be suitable to
of student_id and age field that
and age respectively.
need to ensure each student has a
(b) As a database administrator, vou
would you choose as the
unique identifier. Which field in the table
primary key and why?
(c) ldentity the field that can serve as an alternate key. Justify your answer.
table ?
(d) How many attributes andrecords are present in the above shown
89
15| Page
