SAMPLE QUESTION PAPER 3
INFORMATION TECHNOLOGY (402)
Class X (Session 2022-2023)
Max. Time: 2 Hours Max. Marks: 50
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.
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.
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.
Page 1 of 7
Section A: OBJECTIVE TYPE QUESTIONS
Q – 1 Answer any 4 out of the given 6 questions on Employability Skills:
(1 x 4 = 4 marks)
i. Which of the following stress is mostly found in youngsters? 1
a. mental stress b. social stress
c. physical stress d. financial stress
ii. Which of the following is one of the physical stresses? 1
a. irritation
c. Palpitation
b. managing pocket money
d. delay in work
iii. Which of the following files are created automatically while using computers?1
a. Temp Files b. Database Files
c. Text Files d. Program Files
iv. Dhruvraj is working in computer. Accidently he deleted a file from a folder.
Now he wants to recover deleted file. Suggest him from where he get the file.1
a. This PC c. File Explorer
b. Recycle Bin d. Windows File Manager
v. Ekta owned a jewellery shop and she undertakes risks and organize factors of
production and generating employment opportunities. Here she is associated
with which type of entrepreneurship? 1
a. Social b. Agricultural c. women d. small scale
vi. An Entrepreneur conducts research, investigates and evaluates an idea
considering various factors and estimates the total demand for a new product
or a service. This function is a part of
a. Promotional Functions c. Commercial Functions
b. Managerial Functions d. Entrepreneurial Functions
Q – 2 Answer any 5 out of the given 6 questions: (1 x 5 = 5 marks)
i. Which method is quite useful when you need to format many scattered
paragraphs, cells, or other items with the same style. 1
a. Fill Format c. Selection from Style
b. Drag & Drop d. Custom Style
ii. Yesha wants to make picture appear like a painting by reducing the number
of colours used. Which graphics filter she has to use to do this task in open
office
Page 2 of 7
writer document? 1
a. Invert b. Sharpen
c. Smooth d. Posterization
Page 3 of 7
iii. The template management dialog opens from menu 1
a. File b. Edit c. Tools d. View
iv. To set the attributes of table of content’s table, a tab is used. 1
a. Entries b. Styles c. Index/Table d. Attributes
v. Which of the following is the last step of the mail merge wizard? 1
a. Select the document b. Edit the document
c. Personalize document d. Save, Print or send
vi. The step of mail merge wizard allows to modify in the document. 1
a. Select a document type
c. Adjust layout
b. Create Salutation
d. Edit Document
Q – 3 Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
i. A is essentially a saved set of cell values for your calculations. 1
a. Scenario b. Source Data range
c. Cell References d. Column Labels
ii. Which of the following option deals with multiple unknown variables? 1
a. Multiple operations b. Macros c. Goal Seek d. Solver
iii. A cell reference in formula refers to 1
a. Data from one or more contiguous cells on the worksheet
b. Data from Open office Database
c. Data from mail merge data source
d. Data from fields of a database
iv. Which of the following symbol is used to create a reference? 1
a. + b. = c. / d. *
v. Which of these is not a type of hyperlinks supported in a spreadsheet? 1
a. Internet b. Email c. Document d. System File
vi. Which of the following statement describes comment in spreadsheet? 1
a. A comment indicates red border when any changes made by anyone
b. Authors and reviewers can add their comments to explain their changes
c. A comment is saved sequence of commands
d. Comments copies the text written in the cell automatically
Q – 4 Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
i. Data accessed through command line or graphical user interface. This
interface is known as 1
a. Front-end b. Back-end
c. Database Server d. Database Engine
Page 4 of 7
ii. Which of the following represent a single, data item in a table. 1
a. Field b. Attribute
c. Record d. Relation
iii. Which of the following is option is not present in OO base window when
tables options is selected? 1
a. Create table in Design View c. Create View
b. Use wizard to create table d. Create table using SQL
iv. Which of the following data type stores the values as exactly the length is
provide by user and pads with trailing spaces for shorter strings. 1
a. char c. varchar_ignorecase
b. varchar d. longvarchar
v. Which of the following is part of DML command used retrieve data? 1
a. Insert
c. Delet
b. Update
e
d.Select
Page 5 of 7
vi. Priya wants to display the records of students according to their scores in
descending order in exam. Which of the following statement is correct? 1
a. select * from students sorted by score in desc
b. select * from students arrange by score desc
c. select * from students group by score desc
d. select * from students order by score desc
Q – 5 Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
i. Which option enables sound cues when the locking keys such as caps lock,
num lock or scroll lock are pressed? (OMITTED) 1
a. Sticky b. Toggle keys
c. Filter Keys d. Mouse Keys
ii. helps in maintain contacts with friends and relatives who live
across different locations via internet chatting systems and email software.
(OMITTED) 1
a. Internet b. Peer to Peer
c. Web d. Browser
iii. Find odd one out of the following? 1
(OMITTED)
a. WiMAX b. DSL c. WiFi d. WAN
iv. ensures that differently-abled are assisted and guided out of the
premises or the impacted area properly. (OMITTED) 1
a. Assistive Technology b. Accessibility Options
c. Buddy System d. Instant Messaging
v. Which of the following is not a type hazard? 1
a. Physical
c. Mathematical
b. Chemica
d. Biological
l
vi. can be defined as an unfortunate incident that occur
Page 6 of 7
unintentionally causing hazardous result or injury or unwanted results. 1
a. First Aid b. Emergency
b. Evacuation d. Accident
SECTION B: SUBJECTIVE TYPE QUESTIONS
Answer any 3 out of the given 5 questions on Employability Skills
(2 x 3 = 6 marks)
Answer each question in 20 – 30 words.
Q – 6 Mahek is class 10 student. She is preparing for oral test. Her teacher asked
her about self-management and what it includes? Help her to answer
these questions in details. 2
Q – 7 List out the skills of emotional intelligence. 2
Q – 8 Umang wants to know the concept of file system. Help him by writing the
naming conventions and file hierarchy with example. 2
Q – 9 Differentiate between shortcut and folder. 2
Q–10 Mohit wants to be an entrepreneur to help the society. He wants to know
some positive impacts of entrepreneur in society. Write any four impacts
to help him. 2
Answer any 4 out of the given 6 questions in 20 – 30 words each
(2 x 4 = 8 marks)
Q–11 What are the different ways to create a style supported by OpenOffice
writer? Enlist them and explain any one in short. 2
Q–12 Yug is a data entry operator in a multinational company. He has crated 6
different worksheets to store month wise sales data. His boss asked him to
make total of all six-month sales in a separate worksheet and prepare a
sales report. Answer the below given questions to help Yug to accomplish
his task. 2
a) Which concept of spreadsheet Yug can use to complete the task?
b) Name the menu he can complete this task.
Q–13 What are ways of create table in OO base? 2
Q–14 What is primary key? How to set primary key? 2
Q–15 Parul is an artist. She wants share her knowledge with target audience
through a website. Write any four online tools/websites from where she
can start her website and publish her articles to help the audience? 2
Q–16 Differentiate between web based and application based IM Software.
(OMITTED)
2 Answer any 3 out of the given 5 questions in 50– 80 words each
Page 7 of 7
(4 x 3 = 12 marks)
Q–17 Chirag is class 10 student. His teacher asked him to prepare a project on
online transactions. Show he prepared some questions for the same. Help
him answer these questions. (OMITTED)
a) What is the full form of OLTP? 1
b) Name any two websites you have performed online transactions. 1
c) Write various online payment methods. 1
d) Write any two benefits of online transactions. 1
Q–18 Word processing software allows to create tables and indexes. Answer the
following questions based on table of contents:
a) Which styles are must be created to use table of contents? 1
b) Name menu and submenus options to create table of contents. 1
c) How to restrict manual changes in table of contents? 1
d) Write steps to set an image as background in the table of contents. 1
Q–19 Here some facts are given related to spreadsheets. Answer the given
questions based on the facts.
a) Sometimes working with spreadsheets, we are getting this message:
“The document[filename] is locked for editing by another user. To open a
read-only copy of this document, click!”.
Why this message appears?
b) Write step to enable spreadsheet where users can work simultaneously.
c) Write any two situations occurs when multiple users work on same
spreadsheet.
d) If user wants to know the changes done by other users should
highlighted, which option is used?
Page 8 of 7
Q–20 Write queries based on the following table - Product:
ProNo ProName SuppCode Quantity
I001 Denim Jeans 101 150
I002 Levi’s Jeans 102 175
I003 Ruff n Tuff 103 250
I004 Wrangler 104 150
I005 Diesel 106 80
I006 Spykar 107 125
I007 Lee 105 75
Write queries to display data as follows:
i) Product number, Product name and supplier code which contains quantity
between more than 100. 1
ii) Count the products belongs to 101. 1
iii) Product name and supplier code in the descending order of quantity 1
iv) Change the supplier code to 102 for spykar and Lee products 1
Q–21 Analyze database requirements for a result making software. Write a at
least two tables required for this database and maintain relationship
between tables. Mentions table names and its structure including
constraints required by database. 4
For Visually Impaired Students
Q–21 Explain any four datatypes used in OO base. 4
--------------- X -------------
Page 9 of 7
