Sample Paper 8
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) Ankit owns a shoe and leatherwear store in Agra, where many similar stores exist. To
attract customers and increase sales, he has offered discounts. What could be his objective?
(a) Growth (b) Survival (c) Expansion (d) All of these 1
(B) Sustainable development requires development in four dimensions namely: (I) Social (II)
Educational (III) Economic (IV) Ecological (V) Entertainment (VI) Political (VII) Industrial
(a) (I), (II), (III), (VII) (b) (I), (III), (IV), (VI) (c) (II), (III), (IV), (V) (d) (III), (IV), (V),
(VII) 1
(C) ............... is not a symptom of stress. (a) Increased sweating (b) Cold hands or feet (c)
Dry mouth (d) All of these 1
(D) Karishma is preparing for her interschool debate competition. She asked her father to
listen to her debate during practice and give her suggestions to improve. Her father told her
that she was doing very well except that she needs to improve her confidence level. He didn't
particularly tell her at what point of speech she is lagging. The feedback that talks about the
whole thing while giving a general overview. (a) Formal (b) Informal (c) Specific (d) Non-
specific 1
(E) ............... is known as stress hormone. (a) Adrenaline (b) Endorphins (c) Dopamine (d)
Serotonin 1
(F) Which of the following is NOT required to keep a device cool? (a) Unplug the device
when in use. (b) Do not cover a laptop in blanket. (c) The computer's CPU fan should
properly work. (d) The device should not be kept in direct heat. 1
2. Answer any 5 out of the given 6 questions. (1 × 5 = 5 marks)
(A) ............... helps improve consistency in a document. (a) Style (b) Template (c) Table of
content (d) Images 1
(B) To cancel the last edit, we use ............... as shortcut key. (a) Ctrl + Y (b) Ctrl + U (c) Ctrl
+ E (d) Ctrl + Z 1
(C) To add an image into a document you can use ............... method. (a) Drag and Drop (b)
Insert picture (c) Both (a) and (b) (d) None of these 1
(D) The toolbar to format picture does not consists of ............... option. (a) Grayscale (b)
Original (c) Black and White (d) Watermark 1
(E) A pamphlet for school fare has to be designed. Which out of the following Office Suite
components will help to complete the task? (a) Spreadsheet (b) Digital Documentation (c)
Database Management (d) Mail Merge 1
(F) In a Word processor, scale refers to the ............... of an image. (a) angle (b) size (c) color
(d) both (a) and (b) 1
3. Answer any 5 out of the given 6 questions. (1 × 5 = 5 marks)
(A) Consider the hyperlink ..\[Link]. It is a ............... type of link. (a) Relative (b)
Absolute (c) Mixed (d) Dynamic 1
(B) In a spreadsheet, changes can also be made temporarily. This working mode is called: (a)
Shared mode (b) Formatting mode (c) Record changes mode (d) View mode 1
(C) Which of the following is an advantage of a macro? (a) They automate the repetitive key
strokes (b) Reduces possibility of human error (c) Saves time (d) All of these 1
(D) In a spreadsheet, by default, the data is entered in ............... form. (a) Forms (b) Queries
(c) Macro (d) Tabular 1
(E) In a worksheet, while performing consolidation, if same data range is selected from
multiple worksheets, then consolidation is done by ............... (a) Applying average function
on the range. (b) Copying data below the selected range (c) Replacing data from the selected
range. (d) Applying Sum function on the range. 1
(F) A cell reference outside the worksheet is written as ............... (a) <col> <row> (b) <row>
<col> (c) <sheetname>.<row> <col> (d) <sheetname>.<col> <row> 1
4. Answer any 5 out of the given 6 questions. (1 × 5 = 5 marks)
(A) ALTER TABLE command is used to ............... . (a) Add new columns in table (b)
Modify existing columns in table (c) Change the name of existing column (d) All of these 1
(B) ............... are the numeric data types of a table field in a DBMS. (a) Integer (b) Decimal
(c) String (d) Both (a) and (b)1
(C) Which of the following is not specified while creating a report? (a) Sorting (b) Grouping
(c) Layout (d) Form 1
(D) Shalini wants to set the value for the roll number to be incremented itself when a new
row will be inserted. Which of the following field types should she use for this purpose? (a)
Integer (b) AutoNumber or AutoValue (c) Decimal (d) Primary 1
(E) ............... command of SQL shows the table structure. (a) SELECT (b) CREATE (c)
DROP (d) DESC 1
(F) The default date format in database is ............... . (a) YYYY/MM/DD (b) YYYY-MM-
DD (c) YYYY-DD-MM (d) YYYY/DD/MM 1
5. Answer any 5 out of the given 6 questions. (1 × 5 = 5 marks)
(A) A company can refer to ............... on occupational health & safety of government of India
for its own safety policy. (a) Manual (b) Guidelines (c) National policy (d) Local policy 1
(B) Which of the following is an impact of hazardous workplace? (a) Impaired hearing (b)
Damages to eyes (c) Damages to lungs (d) All of these 1
(C) Proper security procedures will: (a) increase the operational cost (b) increase the business
revenue (c) decrease the number of working days lost. (d) all of these 1
(D) One of the major air pollutants that is also referred to as Smog is: (a) Smoke (b) Ozone
(c) Dust particles (d) All of these 1
(E) Most common causes for headaches for a professional can be: (a) Pain in the neck (b)
Binge watching TV shows (c) Strain on the eyes (d) Both (a) and (c) 1
(F) Why electrical equipment should not be touched with wet hands? (a) It increases the
electrical conductivity of the body. (b) The equipment may slip from wet hands. (c) It makes
the equipment dirty. (d) It reduces electrical conductivity.1
SECTION - B
(Subjective Type Questions) 26 marks
Answer any 3 out of the given 5 questions on Employability Skills (2 × 3 = 6
marks) Answer each question in 20 – 30 words.
6. What are your favourite stress management techniques? Elaborate any two. 2
7. What is the importance of effective communication skill? 2
8. Mention any two tips for the success of startup? 2
9. Since Anu entered her teenage, her father has been telling her that she should set some
achievable goals. What do you understand by Goal Setting? What do you think Anu's father
means when he says achievable goals? 2
10. Differentiate between CUI and GUI. 2
Answer any 4 out of the given 6 questions in 20 – 30 words each. (2 × 4 = 8 marks)
11. The flowchart consists of many symbols and text along with the symbols. Ankit wants to
change the size of all the symbols but selecting each of them together is very tedious. What
can he do to select them together on a single click? 2
12. Suvidha slipped in her office and fractured her leg. This was second incident of its kind in
their office. Suggest her two safety measures against slips and falls. 2
13. Name the two ways of referencing cells in other worksheets. Describe any one. 2
14. Sitting long hours in front of the computer screen is inevitable for most of us and so are
its hazards. Write any two measures to follow at your work place that can help mitigate the
risks related to this. 2
15. To create a form or report in database you need some prerequisites. What are these? 2
16. What is the significance of What-if analysis? 2
Answer any 3 out of the given 5 questions in 50–80 words each. (4 × 3 = 12 marks)
17. Imagine you have just passed your class 9th and are now going through the text books of
class X. You find certain terms in your IT book, about which you ask one of the senior
student. (A) What is an absolute hyperlink? (B) What is a relative hyperlink? (C) What is
data consolidation? (D) What do you understand by what-if analysis? 4
18. Out of many ways of making a document look professional and presentable Styles and
Templates are most commonly used. Differentiate between styles and template. 4
19. Garima is a budding entrepreneur. She wants to know the importance of the safety policy
for a company. 4
20. Shamita wants to present the data of sales table to her manager. Which database feature
should she use? How can she arrange sales records in descending order of sales? Name the
feature should she use to group the records of sales table according to the city. 4
21. Consider the following table named 'Product' with details about baby products being sold
in the showroom.
Pro_Code Pro_Name Colour Price Gender
1091 Shoes Pink 275.00 Girl
1092 Shoes White 350.00 Boy
1093 T-Shirt Yellow 565.00 Boy
1094 Frock Light blue 750.00 Girls
1095 Baby soap White 55.00 Uni
1096 Hair oil NA 125.00 Uni
(A) How many fields and records are in the given table? (B) What would be the structure of
the given table? (C) As the database administrator you need to define a new table supplier
that contains the details of a supplier along with the products it supplies. Name any two fields
of this table that would be the most important to identify a supplier. (D) Which field of the
supplier table must be added to the 'Product' table so that both the tables can be linked? 4