Sample Paper 7

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) Which of the following is NOT an OS? (a) Android (b) Windows (c) AVG (d) Linux 1

(B) Self-confidence is a quality which develops due to: (a) Self-monitoring (b) Self-
regulation (c) Self-awareness (d) External motivation 1

(C) Suhas works as an app developer in an IT company. His manager appreciates his work
and always keeps on telling him that he has qualities which can make him a good
entrepreneur. Which among the following can be that quality? (a) Innovative and open
minded (b) Good looking (c) Well Educated (d) Strong technical skills 1

(D) Rajendra Singh is a Sub-Inspector in UP Police. His job forces him to deal with various
types of criminals on regular basis. Sometimes he is very stressed out from his routine work.
What among the following can be done to release his stress? (a) Healthy diet and life style (b)
Meditation (c) Positive thinking and outlook (d) All of these 1

(E) Act of imparting or interchanging thoughts, opinions or information without the use of
words: (a) Communication (b) Verbal communication (c) Non-verbal communication (d)
Feedback 1

(F) SDG's have been developed to be applied to: (a) Developed nations (b) Developing
nations (c) Third World Countries (d) All countries 1

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

(A) ............... styles impact the structure of the document. (a) Character (b) Page (c)
Paragraph (d) Frame 1

(B) A template is a blue print to create: (a) Table (b) Table of contents (c) Styles (d) Another
document 1

(C) Why Styles are used in the document? (a) It maintains consistent formatting. (b)
Formatting changes in complete document is easy. (c) The formatting can be done quickly.
(d) All of these. 1
(D) To insert a downloaded image from Google into a document ............... option of word
processor is used. (a) Drawing objects (b) Pictures (c) Charts (d) Any of these 1

(E) While preparing TOC for his document, Gagan wants to ensure proper presentation and
accessibility of the document. For this he should: (a) define hierarchy of headings in the
document. (b) define header and footer in the document. (c) define all headings as links. (d)
define all headings with different styles. 1

(F) An image's position in the document is not affected by which of the following? (a)
Anchoring (b) Alignment (c) Text Wrapping (d) Contrast 1

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

(A) Which of the following cannot be calculated through Subtotal in a Spreadsheet? (a) Sum
(b) Product (c) Average (d) Percentage 1

(B) To connect the data in form of HTML page, which of the following should be done? (a)
Copy and paste the data in a workbook. (b) Create a document hyperlink for the HTML
document. (c) Create link for the required components using link to external data. (d) All of
these 1

(C) ............... refers to a range of cells. (a) Row (b) Column (c) Cell reference (d) Formula 1

(D) Consider the hyperlink- D:\Users\Documents\[Link]. Identify the type of this

(E) ............... is arranging data in order. (a) Filtering (b) Sorting (c) Reporting (d) Querying 1

(F) Rohit has created 6 worksheets, in a single workbook, for each month for the sale of
products in his shop. To check the half yearly sales, he needs to prepare a single worksheet.
Which out of the following features will be helpful for him? (a) Goal Seek (b) Consolidate (c)
Solver (d) Macro 1

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

(A) ............... is a storage container which stores data that belongs to a single object, subject
or purpose. (a) Database (b) Table (c) Record (d) Field 1

(B) The description column in Table Design view is used to ............... (a) define data type for
each field. (b) describe data to be stored in each field. (c) describe criteria for storing data in
the field (d) None of these 1

(C) While creating a table in DBMS, which of the following is considered optional? (a) Field
Name (b) Description (c) Data Type (d) Field size 1

(D) The structure of a table, once created, can be changed using ............... SQL command. (a)
UPDATE (b) SET (c) MODIFY (d) ALTER TABLE 1

(E) SQL stands for: (a) Structured Query Language (b) Simple Query Language (c)
Structured Quick Language (d) Simple Quick Language 1
(F) When a primary key contains more than one field, it is called ............... key. (a) Alternate
(b) Foreign (c) Candidate (d) Composite 1

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

(A) Employees should be trained for how to handle and use the fire extinguisher. But what
are the preventive measures for avoiding fire? (a) Put the phone numbers of fire department
near the phone. (b) Eliminate fire hazards through good house keeping. (c) Keep inflammable
materials inside proper containers. (d) Both (b) and (c) 1

(B) The two 'S' in the acronym PASS for remembering the steps of using fire extinguisher
stand for: (a) Squeeze and Spray (b) Slip and Stand (c) Stir and Spray (d) Squeeze and Stir 1

(C) Situation which poses immediate risk and requires urgent attention: (a) Emergency (b)
Accident (c) Disaster (d) Natural calamity 1

(D) Samira is learning about safety and first aid. She knows that there are certain rules that
must be followed while handling accidents. Help her with selecting the inappropriate practice
that is not required during an emergency. (a) Preserve Life (b) Plant trees (c) Prevent further
injury (d) Promote recovery 1

(E) Krishna was educated about first aid and safety in his school assembly. He can't
remember the word used for the process of emptying a place in case of an emergency or
disaster. (a) First aid (b) Eloping (c) Evacuation (d) Recovery 1

(F) For a worker to be able to work with his full potential he must be: (a) Happy and healthy
(b) Hard working (c) Highly educated (d) With high morals 1

SECTION - B

(Subjective Type Questions) 26 marks

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

6. There are some myths about Entrepreneurship. Name any four of them. 2

7. Before the operating system takes over, a special program stored on the ROM chip
performs the booting. This program is the BIOS. What is System BIOS? 2

8. Explain 'M' in SMART. 2

9. Imagine you are a high school student and your final exams are approaching. As the time is
drawing near, anxiety and stress is taking over you. Your father takes you to a therapist who
advices you to practice meditation along with using time management. What is the
importance of time management? 2

10. Write some measures to overcome communication barriers. 2

11. List some precautions for workplace safety. 2

12. Define ergonomics. How does ergonomics help maintain work place safety? 2

13. When would you create a link to data in external worksheet. 2

14. Write differences between a flat file database and a relational database. 2

15. Anubhav has explained his brother how to use templates in word processor. Give any two
characteristics of a template. 2

16. Differentiate between goal seek and solver. 2

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

17. Imagine you have hired a data entry operator for your organisation who enters data in
worksheets on daily basis and also performs some formatting and calculations. (A) How can
Macros be used to streamline tasks? How can the data entry operator modify Macros? (B)
How to write code for macro as function? 4

18. As area sales manager of your company you need to prepare the annual report with
images. You have already inserted the images. (A) Using the word processor how can the
image be resized? (B) Is it possible to center the image in the text? How? (C) The image of
company's logo is to be given as transparent background effect. How is this achieved? (D)
You need to add an artistic title to our report. How would you do this? 4

19. Bright light sources cause contrast hazards. How can these be avoided? 4

20. What is the difference between a Query and Report? 4

21. Given below is the structure of a table named Library:

MemID CHAR(7)
MemName VARCHAR(25)
BookID CHAR(7)
IssueDate DATE
Return CHAR(1)

(A) What is the difference between Char and Varchar? (B) Identify the field that can qualify
as primary key. (C) As the database administrator you need to create another table that has
records of all the members. Name the fields from the Library table that qualify as fields for
the member table. (D) Name the field that will be foreign key in the library table. 4