HAL NEW PUBLIC SCHOOL

Bengaluru, Karnataka - 560037

PRE-BOARD 1
CLASS 10 - INFORMATION TECHNOLOGY (402)

Time Allowed: 120 mins Maximum Marks: 50

SET A
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):
a. This section has 05 questions.
b. Marks allotted are mentioned against each question/part.
c. There is no negative marking.
d. Do as per the instructions given.
7. SECTION B - SUBJECTIVE TYPE QUESTIONS (26 MARKS):
a. This section has 16 questions.
b. A candidate has to do 10 questions.
c. Do as per the instructions given.
d. Marks allotted are mentioned against each question/part.

Page 1 of 8
 SECTION A: OBJECTIVE TYPE QUESTIONS

1 Answer any 4 out of the given 6 questions on Employability Skills (1 x 4 [4]

= 4 marks)

1. Which of the following helps to manage stress?

a) Both self-awareness of symptoms of stress and speaking out to the

well - wishes like family and friends.

b) Self-awareness programmes

c) Speaking out to the well wishers like family and friends.

d) Self-awareness of symptoms of stress.

2. Which one of the following is not a symptom of stress?

a) Increased sweating b) Cold hands or feet

c) None of these d) Dry mouth

3. Why should you clean a dirty CD-ROM drive or another disc drive?

a) Disks can collect dust and destroy the disk drive

b) Can cause read errors with CD discs

c) Because it is important to keep the surface shiny

d) All of these

4. Which of the following are the commercial functions of an entrepreneur?

a) Leadership b) Innovation d) Finance and Accounting

d) All of these

5. Which of the following is not a correct function of verbal

communication?

Page 2 of 8
 a) It helps us define reality.

b) It helps to organise complex ideas and experiences into meaningful

categories.

c) It can be used to reward and punish.

d) It hinders the maintenance of relationships.

6. The solution to these global problems like scarcity of clean water to

drink, scarcity of pure air to breathe, scarcity of unadulterated food,
rising issue of global warming is ________.

a) Stop using these resources b) To better use of resource

c) Sustainability d) To make people aware

2 Answer any 5 out of the given 6 questions (1 x 5 = 5 marks) [5]

1. Which of the following tab is used to insert a picture in a document?

a) Insert b) Review c) File d) Design

2. Choose the correct option to open picture toolbar.

a) View→ Toolbars → Picture

b) Tool→ Toolbars → Picture

c) View→ Picture → Toolbars

d) Insert→ Toolbars → Picture

3. The default tab space is ________.

a) 0.5 b) 1.25 c) 1.50 d) 1.15

4. Which of these sources can you use to insert an image into a

document?

a) The clipboard. b) A scanned image.

Page 3 of 8
 c) A file on your computer. d) All of these.

5. What is the shortcut to see non - printing characters in Writer?

a) Ctrl + F10 b) Ctrl + F1 c) Ctrl + F11 d) Ctrl + F12

6. What should you do to remove an entry from the Table of Contents?

a) Remove the corresponding heading in the document.

b) Delete it directly from the Table of Contents.

c) Use the Remove Entry tool in the Edit menu.

d) Clear the Table of Contents style.

3 Answer any 5 out of the given 6 questions (1 x 5 = 5 marks) [5]

1. Hyperlink in Calc can be used

a. to jump from one sheet to another sheet.

b. to jump from one sheet to website

c. to jump from one section to another section of same sheet

d. All of these

2. What is a simple way to create a new macro?

a) Both Use the macro recorder to record actions and Write it directly in
the LibreOffice Basic IDE

b) Write it directly in the LibreOffice Basic IDE

c) Import a pre - written macro

d) Use the macro recorder to record actions

3. How do you directly access a cell in a macro?

a) Create a hyperlink to the cell

Page 4 of 8
 b) Use the getCellByPosition or getCellRangeByName methods

c) Use its column and row numbers in a function

d) Manually input its data into the macro code

4. Which tab is used to share the worksheet data?

a) Review b) Insert c) Home d) Layout

5. Which menu is used to view and accept or reject changes in a shared

spreadsheet?

a) Data > Collaborate b) Edit > Change Log

c) View > Comments d) Tools > Track Changes

6. Find out the odd one.

a) Mixed b) AutoFill c) Relative d) Absolute

4 Answer any 5 out of the given 6 questions (1 x 5 = 5 marks) [5]

1. What do you mean by one to many relationship between Student and

class table?

a) Many classes may have many students

b) One class may have many student

c) One student can have many classes

d) Many students may have many classes

2. Which of the following is not a database programs?

a) Writer b) OObase c) Oracle d) MYSQL

3. DBMS is a program that controls the creation, maintenance and use of

database. Here, DBMS referred to

Page 5 of 8
 a) Database Management Service

b) Database Management System

c) Data Build Management System

d) Digital Base Management sytem

4. For what, Memo data type is used?

a) To add table b) To store objects created in other programs

c) For short text entries d) For long text entries

5. Which of the following is not the advantage of database?

a) Data Security b) Reduce Data Redundancy

c) Increase Data Inconsistency d) Sharing of Data

6. To create primary key for a table when in design view:

a. type PRIMARY in field type box when creating required field

b. mark the Primary check box in field name of required field

c. click the Primary Key button in Design ribbon when the cursor is
in required field

d. None of these

5 Answer any 5 out of the given 6 questions (1 x 5 = 5 marks) [5]

1. What is the basic rule for keeping the workplace safe from fire?

a) Ensure proper lighting and visibility

b) Timely repairs of machine

c) Keep the workplace a no - smoking zone

d) Use proper footwear to avoid falls and slips

Page 6 of 8
 2. A collection of web pages linked together in a random order is

a) a search engine b) a web browser

c) a web server d) a website

3. ________ is an accessibility function that tells the keyboard to ignore

brief or repeated keystrokes, making typing easier for people with hand
tremors.

a) Toggle keys b) Filter keys c) Insert key d) Sticky keys

4. Give some examples of a healthy lifestyle.

a) Healthy eating habits b) Stress Management

c) Physical activities d) All of these

5. What are the different types of hazards include ________.

a) Chemical b) Biological c) Physical d) All of these

6. d) Do not keep password names such as ________.

a) Don’t use a mobile number as a password

b) Name of your friends & Relatives

c) Favorite color d) All of these

SECTION B (Employability Skills) Answer any 3 out of the 5 given

questions.

6 What will happen when a message is not understood clearly by the receiver? [2]

7 Give one example each of following stress causal agents for students: [2]

1. Mental Social

8 Define a folder in computer science. [2]

9 What are the myths of entrepreneur? [2]

Page 7 of 8
10 Illustrate with an example the importance of sustainable development. [2]
SECTION B (Subject Specific Skills) Short Answers. Answer any 4 out of
the 6 given questions.

11 How can you position an image relative to text in LibreOffice Writer? [2]

12 Write down the formula for adding values of cells A1 to A5. [2]

13 Why do you need to freeze rows and columns in a spreadsheet? [2]

14 Write one example of each field, for which you would use [2]

1. Text data type 2. Memo data type

15 What is query in Base? Write a query to display all names ending with A. [2]

16 Give any three basic guidelines for charts in a presentation. [2]

SECTION B (Subject Specific Skills) Long Answers. Answer any 3 out of
the 5 given questions.

17 What is the need to modify the spacing of the lines or paragraphs of your text? [4]

18 How do you sort a column using macros in Calc? [4]

19 What is the utility of the primary key in a database? Write distinct features of [4]
primary keys.

20 Distinguish between one to one and one to many relationships. [4]

21 1. Give two best practices for internet safety. [4]

2. Give any two Falls and Slips Safety rules.

*******************************

Page 8 of 8