Series GE1FH
Question Paper Code 89 Set 4
INFORMATION TECHNOLOGY (402) – PYQP 2025
(Session 2024-25)
Time allowed : 2 hours
Maximum Marks : 50
General Instructions :
- Read the following instructions carefully.
- This question paper consists of 21 questions in two sections: Section A & Section B
- Section A has Objective Type Questions whereas Section B contains Subjective Type Questions.
- Out of the given (5+16=) 21 questions, a candidate has to answer (5+10=) 15 questions in the alloted (maximum) time of 2 hours.
- All questions of a particular section must be attempted in the correct order.
- Section – A : Objective Type Questions (24 Marks)
- This section has 5 questions.
- Marks alloted are mentioned against each question/part.
- There is no negative marking.
- Do as per instructions given.
- Section – B : Subjective Type Questions (26 Marks)
- This section has 16 questions.
- A candidate has to do 10 questions.
- Do as per instructions given.
- Marks alloted are mentioned against each question/part.
SECTION A (Objective Type Questions)
1. Answer any 4 questions out of the given 6 questions on Employability Skills : (1X4=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
(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
(iii) Roshin 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
(iv) A _____ is a location where a group of files can be stored in the computer.
a) Folder
b) SMPS
c) CMOS
d) UPS
(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.
(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
2. Answer any 5 out of the given 6 questions (1X5=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
(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
(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
(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
(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 given 6 questions (1X5=5)
(i) To add your own comments in Calc, select _______ → Track changes → Comment.
a) File
b) Edit
c) Insert
d) Data
(ii) To add a new sheet in the spreadsheet, click on the ______ sign located at the left bottom of the spreadsheet.
(A) *
(C) %
(B) /
(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
(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
(v) While creating a hyperlink in Calc, if the complete path along with filename is given then it is an example of ______.
a) Relative hyperlink
b) Mixed hyperlink
c) Absolute hyperlink
d) Folder 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
4. Answer any 5 out of the given 6 questions (1X5=5)
(i) ______ is the database software that is used to create, manipulate and manage data.
a) Ingress or ingres
b) Writer
c) Paint
d) Windows
(ii) 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
(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
(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
(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
5. Answer any 5 out of the given 6 questions (1X5=5)
(i) ______ is a state of physical, mental and social well-being.
a) Richness
b) Popularity
c) Health
d) Activity
(ii) Which one of the following is a 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) DolT
c) TolT
d) SolT
(iv) RSI stands for:
a) Recurring Syndrome Injury
b) Repetition Symptom Injury
c) Recessive Stress Injury
d) Repetitive Strain Injury or Repetition Strain Injury
(v) ______ is the science that deals with designing and arranging the things at workplace so that people can use them easily and safely.
a) Health science
b) Ergonomics
c) Fixture science
d) Work Economics
(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.
SECTION B (Subjective Type Questions)
Answer any 3 out of the given 5 questions on Employability Skills in 20 – 30 words. (2X3=6)
6. Briefly explain the meaning of any 2 C’s out of the 7 C’s of effective communication.
Ans: 7 C’s of effective communication are:
i) Clear/Clarity : Be clear about what you want to say.
ii) Concise/Conciseness : Use simple words (say only what is needed)
7. What is Stress management?
Ans: Stress management means finding ways to handle stress and stay healthy, both mentally and physically. By doing this, you are able to deal with daily stress triggers and meet these challenges head on.
8. Give any four tips to keep the computer in perfect working condition.
Ans: Tips to keep the computer in perfect working condition are :
i) Uninstall unused programs and apps.
ii) Run disk-cleaner software.
iii) Keep your computer clean by wiping off dust from the keyboard and screen.
iv) Keep your computer software/apps updated.
v) Install licensed antivirus software.
vi) Do not overcharge your battery.
9. Mention any four main functions of an entrepreneur.
Ans: The main functions of an entrepreneur are:
i) Taking decisions – like what to make, how to make, and where to sell.
ii) Managing the business – arranging things like raw materials, money, and workers.
iii) Handling money – spending on raw materials, paying salaries and rent.
iv) Taking risks – starting something new and facing possible loss.
10. Explain any two problems related to sustainable development.
Ans: Problems related to sustainable development are:
i) Food : The amount of rich, fertile land needed to grow crops, such as wheat, rice, etc., is becoming less as we are using up more and more land for other purposes.
ii) Water : We use fresh water from rivers and ponds for drinking and cleaning but dump garbage into them.
iii) Fuel : We are using a lot of wood from trees as fuels and for construction of homes and furniture. As more and more trees are being cut, it is affecting the climate of the place.
(Note: Any problem related to 17 SDG’s should also be considered.)
Answer any 4 out of the given 6 questions in 20 – 30 words each (2X4=8)
11. Out of various style categories provided by Writer, explain Frame style category in brief.
Ans: Frames are like containers, which can hold text, graphics and lists. Using frame style, a document can be organised in sections, so that each section of the page can have a different appearance.
12. What is a Macro? Give any two rules that should be followed while naming a Macro or module in Calc.
Ans: A macro is a single instruction that executes a set of instruction. A macro is like an algorithm or a set of actions that we can use or run multiple times. A macro helps in automating or repeating tasks by recording or storing our input sequences like mouse strokes or keyboard presses.
Rules for naming a macro are : The name should (a) Begin with a letter (b) Not contain spaces (c) Not contain special characters except for (underscore)
13. What is the main purpose of Goal Seek in Calc? Give an example to support your answer.
Ans: It is a useful data analysis tool of Calc software. It is used to set a goal to find the optimum (correct) value for one or more target variables, given with the certain conditions. Simply it helps you obtain the input value that results in the target value that you want.
For example, if you want to know the number of units produced to get the desired output then use Goal seek analysis tool.
14. What are the important prerequisites for setting a relationship between two tables in LibreOffice Base? Mention any two.
Ans: Important prerequisites for setting a relationship between two tables in LibreOffice Base are :
(a) both the tables must have a common column
(b) the data type of the common field/column in the table must be the same
15. For a computer workplace, give any two health and safety requirements while using a keyboard.
Ans: For a computer workplace, give any two health and safety requirements while using a keyboard.
i) The keyboard should tilt and separate from the screen to find a comfortable working position and avoid fatigue in the arms or hands.
ii) Maintain proper posture and wrist positioning to prevent strain.
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.
Ans: Eye-related problems that might arise due to long hours spent on a computer are:
i) Computer’s bright light, glare and flickering images can cause eye strain and visual fatigue.
ii) Computer Vision Syndrome is caused by poor lighting and glare on the computer screen.
iii) When you constantly focus on screen, you forget about blinking your eyes that can cause of drying eyes.
Answer any 3 out of the given 5 questions in 50– 80 words each (4X3=12)
17. (a) What is the benefit of grouping drawing objects in Writer ?
Ans: LibreOffice Writer allows grouping different shapes, to behave as a single entity without affecting their size and position. Once grouped, all shapes belonging to that group become its member and a change applied on one-member works on all.
(b) Differentiate between text wrapping and image alignment feature in Writer.
Ans: Text Wrapping : It allows the placement of image in relation to text.
Image alignment : It allows the vertical or horizontal placement of the image with respect to its anchor.
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 summarize 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?
Ans: Consolidate data
(b) Name the Menu Option and Sub-Menu Option that can be used to generate combined summary of all the worksheets.
Ans: Data Menu -> Consolidate
(c) Name the function that can be used to display total of all sales.
Ans: Sum() or sum
(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?
Ans: It can be done by creating a hyperlink
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.
Ans: Fire prevention measures are :
i) All employees must know where the fire extinguishers are located, and how to properly use them.
ii) Fire extinguishers and First Aid Stations should be clearly marked with signs.
iii) Never block access to Exits, fire extinguishers, electric switches and panels.
(b) Give any two basic emergency handling procedures at the workplace.
Ans: Emergency handling procedures are :
i) Employees must be provided instructions about electrical safety.
ii) First Aid kit/box should be quickly accessible to the employees.
iii) Keep a list of numbers to call during emergency.
20. (a) Give any two advantages of relating two tables in a database.
Ans: Advantages of relating two tables in a database are:
i) It helps prevent missing data by keeping deleted data from getting out of sync.
ii) To maintain Referential Integrity.
iii) To prevent Data Redundancy.
(b) Explain many-to-many relationship between the tables in a database.
Ans: Many-to-many relationship : there will be multiple records in the master table that correspond to multiple records in the transaction table.
21. Consider the following table:
Table: Student
| Student_ID | Name | Age | Phone_Number |
|---|---|---|---|
| S001 | Amit | 15 | 9876543210 |
| S002 | Priya | 16 | 8765432109 |
| S003 | Priya | 15 | 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 datatype of student_id and age field that would be suitable to store student’s-id and age respectively.
Ans: Suitable Datatype
Age : Integer/ Tinyint/ Smallint/ Bigint/ Numeric
Student_ID : Char/ Varchar/ Longvarchar
(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?
Ans: Primary Key: Student_ID or Phone_Number. It uniquely identifies each student in the table.
(c) Identify the field that can serve as an alternate key. Justify your answer.
Ans: If Primary Key: Student_ID then Alternate Key Phone_Number
(d) How many attributes and records are present in the above shown table?
Ans: Attributes : 4, Records : 3