ODISHA ADARSHA VIDYALAYA SANGATHAN

HALF YEARLY EXAMINATION, 2023-24

Class:X Maximum Marks:50

Subject: Information Technology (IT- 402) Time: 2 Hrs
General Instructions:
1. Please read the instructions carefully.
2. This Question Paper consists of 21 questions in two sections: Section A & Section B.
3. Section A has Objective type questions whereas Section B contains Subjective type questions.
4. Out of the given (5 + 16 =) 21 questions, a candidate has to answer (5 + 10 =) 15 questions in the allotted
(maximum) time of 2 hours.
5. All questions of a particular section must be attempted in the correct order.
6. Section A - Objective Type Questions (24 Marks):
(i) This section has 05 questions.
(ii) Marks allotted are mentioned against each question/part.
(iii) There is no negative marking.
(iv) Do as per the instructions given.
7. Section B – Subjective Type Questions (26 Marks):
(i) This section has 16 questions.
(ii) A candidate has to do 10 questions.
(iii) Do as per the instructions given.
(iv) Marks allotted are mentioned against each question/part.

Section-A
(Objective Type Questions)
1. Answer any 4 out of the given 6 questions on Employability Skills 4x1=4
(a) __________ refers to focusing human efforts for maintaining a healthy body and mind, capable of
withstanding stressful situation.
(i) Artificial Intelligence (ii) Stress management
(iii) Motivation (iv) Emotional intelligence
(b) Which of the following is not the benefit of stress management?
(i) Boosts immunity (ii) Reduces efficiency
(iii) Improves mood (iv) prevent behavioral problems
(c) ____________contains all the deleted files and folders.
(i) Computer (ii) Control Panel
(iii) Recycle Bin (iv) None of these
(d) __________ act as an interface between the user and the computer.
(i) Keyboard (ii) Mouse
(iii) Monitor (iv) Operating System
(e) __________ is the type of self-employment where one is running a business to satisfy the needs and
looking for way to make the business better.
(i) Entrepreneurship (ii) Entrepreneur
(iii) Business Idia (iv) Entrepreneurist
(f) Which of the following are the qualities of successful entrepreneurs?
(i) They are confident (ii) They take responsibility for their action
(iii) They work hard (iv) All of these
2. Answer any 5 out of the given 6 questions 5x1=5
(a) Which option is used to undo the task?
(i) Ctrl + Z (ii) Ctrl + Y
(iii) Ctrl + X (iv) None of these
Page 1 of 4
 (b) Which of the following is not used when creating a mail-merge document?
(i) Spreadsheet (ii) Paint
(iii) Document (iv) Database
(c) ___________ controls all aspects of a paragraphs appearance, such as text alignment, tab stops, line
spacing, and borders, and can include character formatting.
(i) Page style (ii) Character style
(iii) Cell Style (iv) Paragraph style
(d) How many levels of heading does Open Office Writer evaluate to build the Table of contents?
(i) 8 (ii) 9
(iii) 10 (iv) 12
(e) Which of the following feature of Writer helps us to create a letter for multiple people with personalized
touch?
(i) Letter Merge (ii) Templet
(iii) Mail-Merge (iv) Style
(f) Shortcut to copy image is Ctrl + ____________
(i) V (ii) X
(iii) C (iv) None of the these
3. Answer any 5 out of the given 6 questions 5x1=5
(a) Which of the following office tool is known for data analysis.
(i) writer (ii) Calc
(iii) Impress (iv) Darw
(b) ____________ feature add data arranged in a group of cells in calc, with labels for columns and/or rows.
(i) Sheet (ii) Subtotal
(iii) Goal seek (iv) Solver
(c) A _____ refers to a cell or a range of cells on a worksheet whose data values can be used in a formula.
(i) Sheet (ii) cell
(iii) cell reference (iv) cell data
(d) ______ feature of Calc is used to test ‘what –if’ questions
(i) Solver (ii) Goal seek
(iii) Scenario (iv) All of these
(e) By default, _________ sheets are present in spread sheet.
(i) 1 (ii) 2
(iii) 3 (iv) 4
(f) Macros are especially useful to _________ a task.
(i) do (ii) repeat
(iii) Simplify (iv) Complicate
4. Answer any 5 out of the given 6 questions 5x1=5
(a) A data base is an organized collection of _______________.
(i) data (ii) attributes
(iii) Records (iv) None of the above
(b) Which one of the following is not an example of DBMS?
(i) My SQL (ii) FoxPro
(iii) Writer (iv) Oracle
(c) Duplication of data is called ____________
(i) Inconsistency (ii) Redundancy
(iii) Consistency (iv) Foreign Key
(d) Which of the following will help to maintain unique record in a table?
(i) Primary Key (ii) Foreign Key
(iii) Composite Key (iv) Alternate Key
(e) Which of the following is the expanded for of SQL?
Page 2 of 4
 (i) Systematic Query Language (ii) Structured query Language
(iii) Software Query language (iv) Structural Query Language
(f) In RDBMS, data is organized in the form of ____________.
(i) Fields (ii) Record
(iii) Table (iv) None of these
5. Answer any 5 out of the given 6 questions 5 x 1= 5
(a) ___________ are computer programs that can damage the data and software programs or steal the
information stored on a computer.
(i) Spam (ii) Virus
(iii) Junk mail (iv) BIOS
(b) Which of the following activity can helps us to reduce the risk of online Threats?
(i) use strong password (ii) use antivirus and spyware
(iii) use encryption software (iv) all of these
(c) __________ is a global system of interconnected computer networks.
(i) ARPANET (ii) Intranet
(iii) Internet (iv) None of these
(d) A _________ is an unplanted event that may happened all of a sudden and may lead to unwanted or
unprecedented result/outcomes.
(i) emergency (ii) hazard
(iii) accident (iv) illness
(e) A _________ worker will always perform to the best to his ability.
(i) fast working (ii) happy and healthy
(iii) highly educated (iv) stressed
(f) ___________ is the process of emptying a place in case of an emergency, disaster.
(i) Emergency (ii) Accident
(iii) Drill (iv) Evacuation

Section-B
(Subjective Type Questions)
Answer any 3 out of the given 5 questions on Employability Skills. 3 x 2= 6
Answer each question in 20 – 30 words.
6. What is self-awareness? Also give any two benefits of self-awareness.
7. Give one example each of following stress casual agents for students:
(a) Mental
(b) Social
8. Differentiate between file and folders.
9. Give any two qualities of a successful entrepreneur.
10.Give any two promotional functions of an entrepreneur.

Answer any 4 out of the given 6 questions in 20-30 words each. 4 x 2=8
11.Differentiate between keep scale and keep image size options while cropping an image in a document.
12.Give any two characteristics of a template in Writer.
13.Why do we need to merge worksheets?
14.What is a primary key? How it is different from foreign key?
15.Expand and explain the term WAN.
16.(a)Identify the following network/ Internet connectivity as wired or wireless:
(i) Dial-up
(ii) WiMax
(b)Give any one feature of Instant messaging

Page 3 of 4
Answer any 3 out of the given 5 questions in 50-80 words each. 3 x 4 =12
17. Explain the following terms with respect to positioning the graphics in a document:
(a) Arrangement
(b) Text Wrapping
18.Distinguish between the following with respect to spreadsheets:
(a) Relative and Absolute hyperlink
(b) Internet hyperlink and Document hyperlink.
19.Explain any four types of DBMS.
20.(a) Structure of a table “Orders” is given below. Suggest suitable data type of each column.
Table: Orders
Order ID Order date Customer ID Amount
A101 12/12/19 C3445 1200.00
A202 11/9/19 C1245 3456.00
A303 09/07/09 C2121 2312.00
(b) Consider the following table: “Books”.

BkId BkName Author Qty Price

B101 Learning with Fun Jacobins 5 355.00
B103 How I Live Now Meg Rosoff 4 400.00
B104 I Capture the Castle Dodie Smith 5 520.00
B106 Mortal Engines Philip Reeve 4 260.00
B110 The Kite Rider Geraldine McCaughrean 3 270.00
Write SQL queries to
(i) Display data of all books whose quantity is more than 3.
(ii) Display total amount of all books whose price is less than 500.
(Hint: Amount = Qty x Price)
21.(a) Give two best practices for Internet Safety.
(b)Give any two Falls and Slips Safety rules.

<All the Best>

Page 4 of 4