Sample Paper 10

Self-Assessment सू चना प्रौद्योगिकी INFORMATION TECHNOLOGY

Time Allowed: 2 Hours | Maximum Marks: 50

General Instructions: Same instructions as given in Sample Paper 1.

SECTION - A

(Objective Type Questions) 24 marks

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

(A) Every time before his exams Siddhant faces the issues of sleeplessness and loss of
appetite. He is facing distress. Distress is the term given to ............... (a) Good stress (b) Bad
stress (c) Eustress (d) Positive stress 1

(B) Self-awareness refers to awareness about one's own ............... (a) Strengths or
weaknesses (b) Interests or capabilities (c) Values (d) All of these 1

(C) Susheela owns a manufacturing and packaging unit for Indian food items. She decides to
sell her products in Dubai, Mexico, and Russia. However, the products did not sell well,
resulting in a loss. She apologises to her employees and promises to plan better next time.
Susheela is: (a) taking responsibility for her mistakes. (b) thinking before making a decision.
(c) not giving up. (d) being creative. 1

(D) ............... is the dashboard of your computer. (a) Taskbar (b) Start menu (c) Recycle bin
(d) File explorer 1

(E) Select which of the following is not an element in the process of communication. (a)
Channel (b) Sender (c) Time (d) Receiver 1

(F) Which of the following is not a challenge faced in implementing SDGs? (a) Social
Inclusion (b) Lack of effective leadership (c) Undefined scope of SDGs (d) No organisation
to monitor the implementation and progress of SDGs. 1

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

(A) You can ............... a text selection into the Styles and Formatting window to create a new
style. (a) Drag and drop (b) Cut and paste (c) Copy and paste (d) Update 1

(B) Kritika is creating an annual sales report for her company. She uses the reports and charts
of all the branch offices to create the final report. Now she wants all the reports to be
identical. Which of the following word processor features would help her to create such
identical documents? (a) Mail merge (b) Graphics (c) Template (d) Spelling and grammar
check 1
(C) In word processors the drag and drop method will ............... the image into a document.
(a) save (b) embed (c) delete (d) cut 1

(D) You can add an image into a document from: (a) Scanner (b) Gallery (c) Clipboard (d)
All of these 1

(E) Siddhant learnt about images and how to use them in his document. He has inserted an
image in his document and now he wants to change the size of the image without cutting off
the parts of the image. He wants to do ............... of the image. (a) scaling (b) cropping (c)
slicing (d) brightening 1

(F) Who am I? I control how images are stacked upon one another. One of my options can
send all the images behind the selected graphic. (a) Anchoring (b) Text wrapping (c)
Alignment (d) Arrangement 1

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

(A) An absolute hyperlink contains the ............... of the linked sheet. (a) Full address (b)
Address from the current location (c) Web address (d) File name 1

(B) Which of the following formula refers to cell B1 in sheet Sales? (a) =Sales.B1 (b)
=Sales."B1" (c) B1 (d) None of the above 1

(C) A company has its offices in four major cities in India. The data of all regional offices is
stored on separate worksheets. The company wants to consolidate this data. To use data from
another worksheet, which of the following is most appropriate? (a) Copying data from all the
sheets into a new one. (b) Creating Links to the data from another sheet. (c) Copy data into
same sheet and then create link. (d) Deleting data from the original sheets 1

(D) ............... adds data arranged in an array – that is a group of cells with labels for columns
or rows. (a) Consolidate (b) Group data (c) Subtotal (d) Query 1

(E) Manu named one of her worksheets as 'Mydata'. Now she has to use the data form cell
range B5:F11 from this sheet in her worksheet named 'Project'. The reference she should use
is: (a) Project.B5:F11 (b) Mydata.B5:F11 (c) [Link].B5:F11 (d)
Mydata!Project.B5 1

(F) Who am I? Multiple users can view, edit and review the changes in me. Any editing done
on me is shown as comment. (a) Linked Document (b) Shared Document (c) Absolute
Hyperlink (d) Scenario 1

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

(A) A relational database is defined as: (a) Relation between numbers in two tables. (b)
Relation between fields of tables. (c) Consisting of separate tables of related data. (d)
Consisting of separate fields with common data. 1

(B) ............... is not a DML command. (a) INSERT (b) DELETE (c) CREATE (d)
UPDATE 1
(C) Which of the following defines a primary key? (a) The first field in the database (b) The
date field in the database (c) The field which consists of numeric values (d) The field which
stores unique value for each record 1

(D) Primary key and alternate key together are called ............... keys. (a) Foreign (b)
Candidate (c) Non-primary (d) Composite 1

(E) Which of the following is not an advantage of a database? (a) It supports data redundancy
(b) Allows sharing of data (c) Ensures data security (d) Enhances data fragmentation 1

(F) Which of the following fields in the table "Book" can act as a primary key? (a)
Book_number (b) Subject (c) Price (d) Author_name 1

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

(A) To keep the health of an employee in good condition it is not necessary to have: (a) Clean
washrooms (b) Clean and fresh air (c) Good Food (d) Nice entertainment system 1

(B) Sleeping disorders is one of the most common reasons for stress. These disorders are
caused due to: (a) excessive use of screen (b) using screen right before the bed time (c)
working for long hours without a break (d) Both (a) and (b) 1

(C) Tishya is preparing a First-Aid box for her office. Which of the following is not needed
in a First-Aid box? (a) Crepe Bandage (b) Antiseptic lotion (c) Oxygen cylinder (d) Tablet
for headache 1

(D) Responsibility of security and safety of a workplace lies with: (a) organization (b) safety
and security department (c) employees (d) All of these 1

(E) Proper security procedures increase the ............... and reduce ............... . (a) operation
costs, liabilities (b) liabilities, profits (c) operation cost, profits (d) profits, liabilities 1

(F) Many accidents at work place occur while using stairs. Which of the following are
accident preventing measures while using stairs? (a) Take only one step at a time (b) Carry
only limited load (c) Grip the handrail while using stairs (d) All of these 1

SECTION - B

(Subjective Type Questions) 26 marks

Answer any 3 out of the given 5 questions on Employability Skills (2 × 3 = 6

6. Prerna accidentally deleted some important files. Her brother told her to restore them.
What is meant by restoring? 2

7. What does 'R' mean in SMART goals? 2

9. What are different types of fire and their possible causes? 2

10. How do entrepreneurs help in creating more entrepreneurs? 2

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

11. Write a short note on Emergency action plan. 2

12. What is the importance of Vocabulary and Domain knowledge in communication? 2

13. What is referential integrity? 2

14. In a finance company five users are working on the same shared document. Three of them
are working on common overlapping data. What happens when they try to save the
document? 2

15. What is the wrap setting? Mention the types of wrap settings available in Word
processors. 2

16. You want to add a link to a table in HTML namely [Link]. How would you do it in
Calc? 2

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

17. Imagine you are working on a school project with some of your friends. For this you have
created a shared worksheet. (A) What is the purpose of sharing a worksheet? (B) Who can
view changes made by a specific user? (C) What features are restricted in sharing mode? (D)
How is a document typically opened in sharing mode? 4

18. Imagine you have been assigned the task of designing brochure of your university. (A)
When creating a brochure, how can unwanted parts be removed from a picture? How can
some common actions be performed on drawing objects? (B) Can the image possibly be
placed in the background of the text? How? 4

19. Tanu's Manager is explaining the guidelines for identifying and reporting an accident or
emergency to the new joinees. What points should he include in his briefing? 4

20. What is the special name given to the field that uniquely identifies a students record in a
database. How is it generally referred to in a linked table? 4

21. Consider the following table named 'House' with details about houses allotted to the
students in a school.

StuID StuName Class HName

(A) Which column can be set as a primary key in the given table? (B) Write SQL query to
display the name, house, class in ascending order of the name of the house. (C) How will you
Change the house name of Student with ID 11004 to Yellow? (D) Apart from StudID which
key/keys can be used as primary key? 4