Notesale: Turn your study into money

Document Preview

Extracts from the notes are below, to see the PDF you'll receive please use the links above

---

MODEL TEST PAPER 1

Information Technology (402)
Max
...
Marks: 50

General Instructions:
1
...

2
...

3
...

4
...

5
...

6
...

(ii) Marks allotted are mentioned against each question/part
...

(iv) Do as per the instructions given
...
SECTION B – Subjective Type Questions (26 Marks):
(i) This section has 16 questions
...

(iii) Do as per the instructions given
...


SECTION A: OBJECTIVE TYPE QUESTIONS
1
...








(1 × 4 = 4 Marks)

(i) Pragya wants to know which of the following refers to your knowledge and understanding about yourself,
your emotions, beliefs, values, biases, knowledge, abilities, motivation, interests, etc
...
Help him identify
the method out of the following
...
She later discovers that bulbs are cheaper in Bareilly
...
What action is described here?
(a) Makes Decision
(b) Divides Income
(c) Manages the Business
(d) Takes Risk
(1)





(iv) Positive impact of entrepreneurship on society—
(a) Contributes to Economic Growth
(b) Encourages Welfare of Society
(c) Solves problems of society
(d) All of these



(v) High expectations from oneself can lead to chronic anxiety which can further lead to
...

(a) Physical
(b) Emotional
(c) Mental
(d) Financial
(1)






(1)

(vi) Ishita is a bank employee dealing with thousands of customer records and data every day
...

(a) Share passwords with friends
(b) Allow anyone to use her device
(c) Use Antivirus
(d) Leave her computer without logging out
(1)

Model Test Paper 1

M
...
Answer any 5 out of the given 6 questions
...
Help her find various ways to do it
...
He now wants to delete it
...
from the insert menu
...
You also need to store information about pricing, stock levels for reordering, old stocks, etc
...
Which of the following database programs will you use to organize the data as per
your business need?
(a) Open Office Base & Writer
(b) Open Office Base & MySQL
(c) MS Access & Excel
(d) Open Office Writer & Calc
(1)
(iv) Atharva wants to create a table in Open Office Base
...
Help him identify suitable field properties for the following task
...
Which of the following online website or platforms can they use to create their
blog?
(a) Canva
(b) WordPress
(c) Qumana
(d) None of these
(1)





(vi) Which property, if set to yes, requires that the value must be inserted into the field?
(a) Entry Required
(b) Size
(c) Default Value
(d) Length

(1)

3
...

(1 × 5 = 5 Marks)

(i) Which is the correct step in Calc if we want to review edited versions of multiple reviewers at once?
(a)
Edit → Changes → Merge document (b)
Edit → Changes → Compare
(c)
Edit → Changes → Reject (d)
Edit → Changes → Comment(1)

(ii) If we want to know at what interest rate we can borrow a loan of 50,000,000 that must be repaid in
20 years with a monthly instalment of 50,000, which feature of Spreadsheet will be used to calculate
the interest rate?
(a)
Multiple Operations (b)
Macro
(c)
Goal Seek
(d) Hyperlink
(1)
(iii)

...

(a)
Goal Seek
(b) Scenario
(c) Solver
(d) Subtotal
(1)

(iv) The
...

(a)
Serial Key (b)
Start
(c)
Filter Key
(d) Ease of Access Center
(1)

(v) While consolidating data, we are continually working with the same range of cells
...
instead of using cell references
...
option, entering a value into a field becomes mandatory and the field cannot be left
blank
...
2

Information Technology–X

 4
...

(1 × 5 = 5 Marks)

(i) A
...

(a)
Template (b)
Document (c)
Design (d)
Copy Paste(1)

(ii) IM (Instant Messaging) software are broadly classified into
...

-based IM services
(a)
Application, Web (b)
Security, Web
(c)
Application, Security (d)
Text, Sound(1)

(iii) Scenarios are a tool to test
...

(a)
Auto
(b) Goal Seek (c)
What-if
(d) Drop-down
(1)

(iv) Nakul has created a worksheet in which he has added all of his employees’ details
...
He also
wants to know what changes his employees have made
...
Which type of table
organization would be most suitable for this purpose?

(a) Relational

(b) Flat File

(c) Either Relational or Flat file
(d) Hierarchical
(1)

(vi) Rekha is a Chartered Accountant
...
She needs
to follow a number of steps repeatedly
...
Answer any 5 out of the given 6 questions
...
odt
(b)
...
oot

(1)




(iv) The
...

(a) Database
(b) Table
(c) Query
(d) Form

(1)





(v) Which of the following file(s) are database types?
(a) Only Flat File
(b) Flat File and Relational
(c) Only Relational
(d) Flat File, CSV and Relational

(1)





(vi) Which of the following columns allows selecting data type for your column in table design?
(a) Field Name
(b) Field Type
(c) Description
(d) Field Properties

(1)

(d)
...


(2 × 3 = 6 Marks)

Answer each question in 20 – 30 words
...
List the types of Operating Systems
...


(2)

7
...


(2)

8
...
 (2)

Model Test Paper 1

M
...
Give any four positive impacts of Entrepreneurship on society
...
Differentiate between Eustress and Distress
...


(2)
(2)
(2 × 4 = 8 Marks)

11
...
Explain the difference between PAN and LAN
...
An automobile showroom wants to calculate total car sales for the first quarter for 2020 and 2021 as shown
below
...

(2)

Sales for the Year 2020
CARS

JAN

FEB

MARCH

Santro

340

200

350

WagonR

456

800

230

i10

790

300

160

Swift

100

290

167


Sales for the Year 2021
CARS

JAN

FEB

MARCH

Santro

122

250

110

WagonR

450

120

150

i10

100

320

165

Swift

300

100

200

14
...
What is the use of Solver in a Spreadsheet? How it is different from Goal Seek tool?

(2)

16
...


(2)

Answer any 3 out of the given 5 questions in 50 – 80 words each
...
What is the purpose of the following tools in Writer?
(i) Mail Merge and its two documents
(ii) Table of Contents and its five tabs

(4 × 3 = 12 marks)

(4)

18
...
Which feature in the spreadsheet will help
them here? How will it be performed?
(4)
19
...
Due to the pandemic, everyone was bound to stay at home
...

(i) What is meant by WWW? Write the names of any two web browsers
...

(4)
21
...
Describe the significance of using templates
...
Define the following:
(i) Flat File Database
(ii) Relational Database
(iii) Primary Key
(iv) Foreign key

M

---