Adwit baphwole

Podar International SchoolChinchwad

Information Technology(402)
Periodic Exam il: Class X(Session 2023-2024)
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 Ahas Objective type questions whereas Section Bcontains 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.
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. There is no negative marking.
ii. Do as per the instructionsgiven.
iv. Marks allotted are mentioned against each question/part.
7.SECTION B-SUB.ECTIVE TYPEQUESTIONS (26 MARKS):
i. This section contains 16 questions.
ii. Acandidate has to do 10 questions.
iiü. Doas per the instructions given.
iv. Marks allotted are mentioned against each question/part.

SECTION A: 0BJECT|VE TYPE QUESTIONS

Q. 1 Answer any 4out of the given 6 questionson Employability Skills(1 x4=4marks)

1
Which of the following is an element of communication within the communication
process cycle?
a. channel b. receiver C. sender d. all of these

Concise communication is one which: 1

use simple words (say only what is needed)
b. use exact words and facts
C use correct spelling and grammar
d. is clear about what you want to say
1
iii On Gandhi Jayanti, Suresh donated blood in hospital which made him happy. It is an
example of
self awareness
b. self motivation
C. self regulation
d. none of these

iv In the SMART method to set a goal, Rstands for 1

a. ready
b. relevant
C. realistic
d. recurring
 V.
Prevent others from using your PC by 1
a. using antivirus
b. using UPS
using username and password
d. all of the above
vi. Sneha created afile in the notepad and saved it with thenarme 'hello'. The
name of the fill will be complete 1
a. hello.doc
b. hello.docx
C. hello.odt
d. hello.txt

Q. 2 Answer any 5 out of thegiven 6 questions (1 x5=5 marks)

Name the following:
1

Softensthe contrast of an image.

Increases the conlrast of an image

a. Sharpen, Aging
b. Smooth, Sharpen
C. Sharpen, Smooth
d. Aging, Sharpen
ii. What is a saved sequence of commands or keystrokes in Calc
a. Solver
called? 1

b. Macro
C. Autosum
d. Consolidate

iii. are dedicated computers that hold the actual

the DBMSand related software.
databases and run only 1

a. Database Server
b. Decided Server
c. Web Server
d. None of the above

iv.
totals/adds data arranged in an array that is, a group of cells with 1
labels for columns and/or rows Which step one must follow before
using the
Subtotal option?
a. Consolidate
b. Rename Data
c. Filter Data
d. Subtotal
V. Raj has produced a worksheet in which he has entered all of his employees' details 1
He wants each employee to look over the spreadshect and, if necessary, change
their address and phone number. He'd also like to know what modif1cations his
employees have made. Which aspect of the spreadsheet should he enable so that he
can view the changes that his staff have made?
a. Macro
b. Link VWorkbook
c. Change Worksheet
d. Track Changes

vi A is asoftware package that can be used for creating and managing 1

databases.
a. Database Management System
b. Basedata Management System
c. Database Manage System
d. None of the above

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

i. is aset of formats that you can apply to selected pages, text, frames, 1

and other elements in your document.

a. Style
b. Format
c. Design
d. None of the above

ii. What is the default name of the first scenario created in Sheet1 of Calc? 1

a. Sheet_1_Scenario_1
b. Sheetl_Scenario1
c. Sheet_1 Scenario1
d. Sheet1_Scenario_1

1
ii. Which of the style include header, footer, borders, margins?
a. Page style
b. Character style
C. Frame style
d. Presentation style

IV. These are dedicated computers that hold the actual databases and run only the
DBMS and related software.
a. Database Server
b. RDBMS Server
c. Data Security
d. None of Above
 1
V.
How can youreference 'F4' cell of a sheet named "Class X*?
a. Class X.F4
b. 'Class X.F4'
c. 'Class X'.F4
d. "Class X.F4"

vi. ACyber Awareness brochure must be created. Which of the Office Suite 1
components should be used to complete this task:
a. Spreadsheet
b. Digital Documentation
c. Database Management
d. Mail Merge

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

To quit fill format mode of styles, press key. 1

e. Control
f. Shift
g. Escape
h. Alter

i. Which of the following functions are available in consolidate window? 1

Max
b. Min
C. Count

d. All of these

ii. In which option we have to specify the target range (where we want the result to be 1
displayed) in data consolidation?
a.. Source data range
b. Copy result to
C. Need result at
d. Target range

iv Sunita is working on a spreadsheet project. Her friend taught her how to rename a 1
spreadsheet, which will make it easier for her to identify the worksheet data. She was
excited and told her brother about it. Aworksheet in spreadsheets can be renamed
different ways, according to her brother.
a. 2
b. 3
C. 4
d. 1
 Only authorized users should be allowed to access the database and their identity 1
should be authenticated using a username and password known as
a. Data Redundancy
b. Data Consistency
c. Data Security
d. None of the above
vi. We can shift from one scenario to another scenario by 1
a. Navigator
b. Findand replace
C. Data source
d. None of the above
Q.5 Answer any 5out of the given 6 questions (1 x5 =5marks)
0. Which of the following elements are present in "Insert Sheet" dialog box? 1
a. After current sheet
b. Before current sheet
C. Number of sheets
d. Allof the above
ii As a school project, Krish and Kritika conducted a survey of their neighborhood's 1

literacy rates by age, which they recorded in a spreadsheet. They both want to work
on it at the same time to finish it on time.Which option should they use to access the
same Spreadsheet in order to save time?
a. Consolidate Worksheet
b.Shared Worksheet
c. Link Worksheet
d. Lock VWorksheet
ii. Duplication of data is called as 1

a. Inconsistency
b. Consistency
c. Redundancy
d. Foreign key
iv. How can we register adata source in OpenOffice.org? 1
a. Choose View >Options > OpenOffice.org Base > Databases
b. Choose Format >Databases >Options > OpenOffice.orgBase
c. Choose Tools > Options > OpenOffice.org Base > Databases
d. None of the above
1
V. Which of the following field of table "Book" can act as a primary key?
a. Book number
b. Author_name
c. Subject
d. price
vi How can users activate the Record Changes feature in a shared worksheet? 1

a. Edit >Changes >Record

b. View >Changes >Record
c.File >Changes >Record
d. Insert > Changes > Record
 SECTION B: SUBJECTIVE TYPE QUESTIONS

Answer any 3 out of thegiven 5 questions on Employability Skills (2 x3=6 marks)

Answer each question in 20- 30 words.

Q.6 What is public speaking? Explain the 3P method.

Q.7 What are the four steps for effective time 2
management?
Q.8 Name and explain any two barriers of effective
communication.
Q.9 How can we protect our data from theft and viruses?
2
Q.10 What is BIOS?
2
Answer any 4out of the given 6 questions in 20-30
words each (2 x 4 =8 marks)
Q.11 Write a note on following:
a. data consolidation 2
b. subtotal
Q.12 a. What is the difference between
Primary Key and Composite Primary Key?
b. In ClientTable, the fields are ClientID, 1

In PurchaseTable, the fields are PurNo, ClientName,

Addr, Contact. 1
PurDate, ClientlD, Item.
Which fields are the primary key and foreign key in
Q.13 Write a macro function to find the area of the PurchaseTable?
square. 2
Q.14 What is the difference between a flat file and a
relational file? 2
Q.15 What are the two ways to create our own style in 00Writer?
Q.16 Observe the following image:

Original Image 1
Answer the following questions.
a. Which feature is used for changing the original image to 1 and 2 images? 1
b. Which options are used to convert the original image to image 1 and 2? 1

Answer any 3 out of thegiven 5 questions in 50- 80 words each (4 x3 = 12marks)

Q. 17 a. Write the advantages of DBMS (any four). 2

b. What is the difference between Tuple and Attribute? 2

Q. 18 a. Explain the feature of accepting or reject changes.

b.Explain any four filters available in "Show Changes'dialog box. 2
Q.19 Observe the following Insert Index/Table dialogbox:
Insert Inder Table

Indes/ atle Entries Styles Cotumn Bacrgound

Iypt And ttle
Tabie of (ontents
1atble of Contente
lype Tabte of (ontent
HProtected sganst many at rhange:
Cteate ndey/tstbte
Hesdino 1
fotce docurn#ot

Headine reAte frem

JOytne
Headinp 1
OAddeional Styles
AInder marks

Cancel Help 2eset

Answer the following questions: 1

a. ldentify this feature of 0OWriter and write the steps to insert it in the
document.
1
b. By default how many levels of headings are evaluated when it builds the
table of contents? 2
C. Explain any four buttons available on the structure line of the Entries tab.

Q.20 The multiple reviewers returnedited versions ofa worksheet at the same time. In 4
thiscase, it may bequicker to review allof these changes at once, rather than one
review at a time. Based onthe above sentence ansvwer the following:

1. ldentify the feature used in.Calcto review the worksheets at a time.

2. Mention the correct path to review the worksheet.
3. Give one difference between merging and comparing documents.
4. Do the reviewer has rights toaccept or reject changes.
Q.21 Raman is astudent of class X. He was doing an assignment of IT. He has done all the
questions except the one given below. Being afriend help Raman.
funtion OK
Max
Cancel
Consolidation ranges
Help

Source data range

Add
|- undefined Sheetl.SNS3
iciete
Copy results $o
undefined SSheetl.SAS1 More

Write the steps to display this dialog box.

b. What is the default function infunction list box? Name two more functions
1
that are available in function list box.
C. Name any two options which are visible on clicking "More" button.
1
d. What will happen if you click on "Add" button?
1