Section-A [24 Marks]

(Objective Type Questions)

IT Board Papers
Question 1.
Answer any 4 out of the given 6 questions on Employability Skills (4×1=4)
(i) 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
Answer:
(b) Notice/Poster

(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
Answer:
(a) Managing emotions

(iii) Roshni studies in class X and is practising hard with a lot of sample papers to get good marks in her
exams. She gets up early in the morning to study and completes her revision work. This is an example of
……………..
(a) self-awareness
(b) self-motivation
(c) influential motivation
(d) emotional intelligence
Answer:
(b) self-motivation

(iv) A ………… is a location where a group of files can be stored in the computer.
(a) folder
(b) SMPS
(c) CMOS
(d) UPS
Answer:
(a) folder

(v) Which of the following is a myth about entrepreneurs?

(a) An entrepreneur should be confident and should be able to take decisions.
(b) Every business idea must be unique or special.
(c) An entrepreneur should keep trying new ideas.
(d) An entrepreneur should be creative and should have different solutions to the problem.
Answer:
(b) Every business idea must be unique or special

(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) Illiteracy
Answer:
(b) Education

Question 2.

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

(i) 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
Answer:
(a) Styles

(ii) 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
Answer:
(c) Sharpen

(iii) Which one of the following image arrangement options in Writer sends the drawing object behind the
text?
(a) To background
(b) To foreground
(c) Behind the text
(d) Back one
Answer:
(a) To background

(iv) ………………….. feature of Writer is based on different types of heading styles and is used to give
the listing of the contents of the document.
(a) Table of Heading
(b) Index
(c) Label of Contents
(d) Table of Contents
Answer:
(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
Answer:
(c) Blank document

(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
Answer:
(b) Fill Format

Question 3.
Answer any 5 out of the given 6 questions (5×1=5)
(i) To add your own comments in Calc, select ………………….. Track changes Comment.
(a) File
(b) Edit
(c) Insert
(d) Data
Answer:
(b) Edit

(ii) To add a new sheet in the spreadsheet, click on the ………………….. sign located at the left bottom
of the spreadsheet.
(a) *
(b) /
(c) \%
(d) +
Answer:
(d) +

(iii) ………………….. is a set of values that can be used within the calculations in the spreadsheet to
explore and compare various alternatives depending on changing conditions.
(a) Sort
(b) Filter
(c) What-if Scenarios
(d) Comments
Answer:
(c) What-if Scenarios

(iv) The recorded macros are actually stored as …………………..

(a) a set of instructions in a programming language.
(b) a sequence of data cells
(c) a document
(d) a list of values
Answer:
(a) a set of instructions in a programming language.

(v) Which creating a hyperlink in Calc, if the complete path along with file name is given then it is an
example of …………
(a) Relative hyperlink
(b) Mixed hyperlink
(c) Absolute hyperlink
(d) Folder hyperlink
Answer:
(c) Absolute hyperlink

(vi) This tool in Calc allows you to create a group of cells automatically and apply common functions like
sum, average on the grouped data. It is known as ………… tool.
(a) Sum
(b) Subtotal
(c) Function
(d) Common
Answer:
(b) Subtotal

Question 4.
Answer any 5 out of the given 6 questions (5×1=5)
(i) ………… is the database software that is used to create, manipulate and manage data.
(a) Ingress
(b) Writer
(c) Paint
(d) Windows
Answer:
(a) Ingress

(ii) The process of arranging data in ascending or descending order is known as …………
(a) Filtering
(b) Tracking
(c) Purification
(d) Sorting
Answer:
(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
Answer:
(b) Currency

(iv) 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
Answer:
(c) Query

(v) While designing a form, it is suggested to get the date input by adding the ………… to the date field
to prevent entering invalid dates.
(a) Calendar
(b) Text input
(c) Timer
(d) Number input
Answer:
(a) Calendar

(vi) While designing a form, titles, headings or sub-headings may be added using ………… tool available
on the Form Controls tool box.
(a) Textbox
(b) Label
(c) Title
(d) Heading
Answer:
(b) Label

Question 5.
Answer any 5 out of the given 6 questions (5×1=5)
(i) ………… is a state of physical, mental and social well-being.
(a) Richness
(b) Popularity
(c) Health
(d) Activity
Answer:
(c) Health

(ii) Which one of the following is a class B ignition material?

(a) Paper
(b) Gas
(c) Electrical equipment
(d) Potassium
Answer:
(b) Gas

(iii) The ………… has prepared the policy to provide employees with a healthy and safe work
environment.
(a) GolT
(b) DolT
(c) TolT
(d) SolT
Answer:
(b) DolT

(iv) RSI stands for ………..

(a) Recurring Syndrome Injury
(b) Repetition Symptom Injury
(c) Recessive Stress Injury
(d) Repetitive Strain Injury
Answer:
(d) Repetitive Strain Injury

(v) ………… is the science that deals with designing and arranging the things at the workplace so that
people can use them easily and safely.
(a) Health science
(b) Ergonomics
(c) Fixture science
(d) Work economics
Answer:
(b) Ergonomics

(vi) Which one of the following is a wrong safety guideline?

(a) Store all cleaning 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
equipment.
(c) Wear loose clothing or jewellery while working with machines.
(d) Make sure all areas have proper lighting.
Answer:
(c) Wear loose clothing or jewellery while working with machines.

SECTION-B [26 Marks]

(Subjective Type Questions)

Answer any 3 out of the given 5 questions on Employability Skills. Answer each question in 20-
30 words. (3×2=6)
Question 6.
Briefly explain the meaning of any 2 C’s out of the 7 C’s of effective communication.
Answer:
Clarity Ensuring the message is simple, clear, and easy to understand.
Conciseness Communicating information in a brief, yet complete, manner without unnecessary
details.

Question 7.
What is Stress management?
Answer:
Stress management is the process of identifying stressors, coping with challenges, and using
techniques like relaxation or time management to reduce stress levels.

Question 8.
Give any four tips to keep the computer in perfect working condition.
Answer:
Four tips to keep a computer in perfect working condition:

 Regularly update software and security patches.

 Clean hardware components to prevent dust buildup.
 Backup important files frequently.
 Use antivirus software to prevent malware.

Question 9.
Mention any four main functions of an entrepreneur.
Answer:
Four main functions of an entrepreneur are:

 Identifying business opportunities.

 Organizing resources for production.
 Managing and overseeing operations.
 Taking financial risks and making strategic decisions.

Question 10.
Explain any two problems related to sustainable development.
Answer:
Two problems related to sustainable development.

 Resource depletion due to overconsumption.

 Environmental pollution from industrial activities.

Answer any 4 out of the given 6 questions in 20-30 words each (4×2=8)
Question 11.
Out of various style categories provided by Writer, briefly explain Frame style category in brief.
Answer:
The Frame style category in Writer refers to text and graphic containers, like text boxes or
images, which can be positioned, resized, and formatted independently within the document.

Question 12.
What is a Macro? Give any two rules that should be followed while naming a Macro or module
in Calc.
Answer:
A Macro is a sequence of commands that automate tasks.
Rules for naming a macro or module in Calc:

 Names must start with a letter.

 Avoid using spaces or special characters like underscores.

Question 13.
What is the main purpose of Goal Seek in Calc? Give an example to support your answer.
Answer:
Goal Seek in Calc helps determine the necessary input value to achieve a specific result. For
example, it can find the interest rate needed to reach a specific investment goal.

Question 14.
What are the important prerequisites for setting a relationship between two tables in LibreOffice
Base? Mention any two.
Answer:
Prerequisites for setting relationships in LibreOffice base include:

 Identifying common fields in both tables.

 Ensuring both tables are correctly structured with primary and foreign keys.

Question 15.
For a computer workplace, give any two health and safety requirements while using a keyboard.
Answer:
Health and safety requirements when using a keyboard include:

 Maintaining a neutral wrist position.

 Taking regular breaks to reduce strain and prevent repetitive stress injuries.

Question 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.
Answer:
Two eye – related problems from excessive computer use are
  Eye strain (Computer vision syndrome).
 Dry eyes due to reduce blinking while storing at screens.

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

Question 17.
(a) What is the benefit of grouping drawing objects in Writer?
(b) Differentiate between text wrapping and image alignment feature in Writer.
Answer:
(a) Grouping drawing objects in Writer allows for easier management, alignment, and
positioning of multiple objects as a single unit. This improves the efficiency of layout adjustment
and prevents objects from moving independently, ensuring a more organized document.

(b) Text wrapping in Writer allows text to flow around an image or object, making the layout
more dynamic. Image alignment, on the other hand simply positions the image in relation to the
surrounding text without affecting text flow. Text wrapping directly interacts with text, whereas
image alignment affects the position of the image.

Question 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 different worksheets. He wants to
summarise and make certain decisions based 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?
(b) Name the Menu Option and Sub-Menu Option that can be used to generate combined
summary of all the worksheets.
(c) Name the function that can be used to display total of all sales.
(d) He wants to open a summary document stored at a different location from within the sheet by
clicking on a text stored in a cell. How can it be done?
Answer:
(a) To combine the sales data from multiple sheets into a single summary sheet, Mr. Amit can
use the consolidate tool in Calc.
(b) The Menu option is Data, and the sub-menu option is consolidate to generate combined
summary of all the worksheets.
(c) The SUM function can be used to display the total of all sales.
(d) To open a summary document stored at a different location, Mr. Amit can insert a hyperlink
in the cell by using Insert → Hyperlink option. He can link the text to the file path of the
summary document.

Question 19.
Imagine that you have been signed a contract of handling fire safety and emergency in a
company. You need to spread awareness on fire safety and emergency handling to the
employees.
Answer the following questions:
(a) Give any two fire prevention measures at the workplace.
(b) Give any two basic emergency handling procedures at the workplace.
Answer:
(a) Two fire prevention measures at the workplace include:

 Regular maintenance and inspection of electrical wiring and equipment to avoide potential
electrical fires.
 Storing flammable materials properly and ensuring they are away from heat sources.

(b) Two basic emergency handling procedures at the workplace include:

 Evacuating the building immediately upon hearing a fire alarm or if there’s a fire threat.
 Calling emergency services (such as the fire department) and providing them with accurate
information about the situation.

Question 20.
(a) Give any two advantages of relating two tables in a database.
(b) Explain many-to-many relationship between the tables in a database.
Answer:
(a) Two advantages of relating two tables in a database are

 It reduces data redundancy by linking tables based on shared attributes.

 It enhances data integrity and accuracy by ensuring data consistency across tables.

(b) A many-to-many relationship in a database occurs when multiple records in one table relate
to multiple records in another table. For example, a student can enroll in multiple courses, and
each course can have multiple students enrolled. This relationship requires a junction table to
link the two tables.

Question 21.
Consider the following table:
Table Student:

Student_ID Name Age Phone Number

S001 Amit 15 9876543210

S002 Priya 16 8765432109

S003 Priya 17 7654321098

Answer the following questions:
(a) You are given the task to design the student database for your school in LibreOffice Base. Based on
the given table structure, suggest the data type of student_id and age field that would be suitable to store
student’s-id and age respectively.
(b) As a database administrator, you need to ensure each student has a unique identifier. Which field in
the table would you choose as the primary key and why?
(c) Identify the field that can serve as an alternate key. Justify your answer.
(d) How many attributes and records are present in the above shown table?
Answer:
(a) Suggested datatype for Student_ID and Age fields

 Student_ID The datatype for Student_ID should be Text because student IDs typically
consist of alphanumeric characters (e.g., “S001”, “S002”). The text datatype in
LibreOffice Base allows storing these mixed characters without restriction.
 Age The datatype for Age should be Integer, as age is represented by whole numbers, and
Integer is used to store numeric values without decimals.

(b) Primary key selection The Student_ID field should be the primary key since it uniquely identifies each
student.
(c) Alternate key identification The phone number field could serve as an alternate key, assuming it’s
unique to each student. While phone numbers may sometimes repeat, they are generally unique to each
individual in a school database, making it a good candidate for this role.
(d) The table has 4 attributes (Student_ID, Name, Age, Phone Number) and 3 records (Amit, Priya,
Priya).