Class 10 - Information Technology (402)Sample Paper - 01 (2023-24)

Class 10 - Information Technology (402)

Sample Paper - 01 (2023-24)

Maximum Marks: 50

Time Allowed: : 2 hours

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 (1 x 4 = 4 marks)

1. Which of the following is/are the symptoms of stress?

a) All of these

b) Body aches

c) Fatigue

d) Social isolation

2. Prevent others from using your computer by ________.

a) using internet

b) using anti-virus

c) using username and password

d) using UPS

3. How many steps are involved in an entrepreneurial process?

a) Six

b) Ten

c) Three

d) Two

4. Which of the following are effective components of good feedback?

i. Detailed and time-consuming

ii. Direct and honest

iii. Specific

iv. Opinion-based

a) (ii) and (iv)

b) (ii) and (iii)

c) (i) and (iii)

d) (i) and (ii)

5. WCED represents:

a) None of these

b) World Committee on Environment and Development

c) World Commission on Environment and Development

d) Weird Commission on Environmental Detoxification

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

1. Which of the following Graphic filter is used to increase the contrast of an image in a document?

a) Smooth

b) Remove Noise

c) Invert

d) Sharpen

2. It is a section of the document that appears at the bottom margin of the page:

a) Tail

b) Footer

c) Header

d) Head

3. The status of your document like current page number and number of pages are given by________.

a) Formatting toolbar

b) Status bar

c) Standard toolbar

d) None of these

4. The Insert tab symbol option from the Symbols group is used to

a) insert the footer

b) insert symbols

c) insert the header

d) format document

5. A new text document can be created by

a) File New Blank Document Create

b) Open New Create

c) None of these

d) File Open

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

a) Ctrl + F10

b) Ctrl + F1

c) Ctrl + F11

d) Ctrl + F12

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

1. AutoSum option is available in

a) Home tab

b) Insert tab

c) Layout tab

d) View tab

2. It refers to a cell or a range of cells on a worksheet and can be used to find the values or data that you want formula

to calculate.

a) Autosum

b) Cell reference

c) Row

d) Column

3. Which of the following is not a way to complete a cell entry?

a) Clicking the Enter button on the formula bar

b) Pressing enter

c) Pressing spacebar

d) Pressing any arrow key on the keyboard

4. Linked data is stored in the ________.

a) web file

b) destination file

c) source file

d) domain file

5. In which group of Insert tab, various charts are available?

a) Charts group

b) None of these

c) Type group

d) Shape styles group

6. ________ feature adds data arranged in a group of cells in Calc, with labels for columns and/or rows.

a) Goal seek

b) Subtotal

c) Solver

d) Average

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

1. The complete information about an entity in a database is called:

a) Data

b) Information

c) Field

d) Record

2. ________ is a rule in RDBMS that ensures the accuracy and consistency of data within the relationship and prevents

the users to enter the inconsistent data.

a) None of these

b) Data concurrency

c) Referential integrity

d) Data integrity

3. Which of the following will occupy more space in computer memory?

a) Bigint

b) Boolean

c) Smallint

d) Integer

4. Which field is suitable for storing records of employees?

a) EmpNo

b) Salary

c) All of these

d) Empname

5. Which command is used to display the salary of all the employees after incrementing by 1000.

a) Select

b) Update

c) Modify

d) Change

6. Which of the following is not an example of the database?

a) Customer management system

b) Cross knot game

c) Numeric calculator

d) Employee payroll management

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

1. How can you reduce the risks over the internet?

a) Using Antivirus Software

b) Strong Password

c) All of these

d) Fire walls

2. What are the types of occupational hazards?

a) Ergonomic hazards

b) Physical hazards

c) All of these

d) Biological hazards

3. Do not keep password names such as ________.

a) All of these

b) Don’t use mobile number as password

c) Name of your friends & Relatives

d) Favorite color

4. Customers can pay for online purchases using:

a) Credit Card

b) Debit Card

c) All of these

d) Internet Banking

5. What is the name of the portal that is commonly used for booking train tickets?

a) Redbus

b) IRCTC

c) EBay

d) Flipkart

6. What are some of the measures to prevent electrical hazards and accidents?

a) All of these

b) Use only electrical equipment approved by a recognized organization.

c) Train workers to handle electric equipment safely.

d) Avoid overloading circuits.

SECTION B (Employability Skills)

6. What are the factors responsible for causing barriers?

7. What are the tips for Practicing for Effective Time Management? Explain.

8. What is Trojan?

9. What are the myth of entrepreneur?

10. Enlist five ways for enhancing sustainable development.

SECTION B (Subject Specific Skills) Short Answers

11. Differentiate between Keep scale and Keep image size options while cropping an image in a document.

12. What do you mean by Page Break?

13. What is the use of Consolidate option in Calc?

14. What is DBMS?

15. What are the main types of computer networks.

16. Explain use of Antivirus and Anti Spyware.

SECTION B (Subject Specific Skills) Long Answers

17. List any five items that can be added to the header area.

18. How do you link the data of spreadsheets?

19. Describe the use of forms, list the various views used in MS Access in which the form can be displayed.

20. Consider the following table

Employee

EmpNO EmpName Designation

1              Shail           A

2              Anup          B

3              Mansi        A

4               Pooja        B

i. Which of the above field can be selected as a primary key?

ii. EmpName field also has unique values for all the records. Can it be made primary key? Give answer with reason.

21. How can anyone book the ticket online?

*****answer key******

Class 10 - Information Technology (402)

Sample Paper - 01 (2023-24)

Solution answer key

SECTION A: OBJECTIVE TYPE QUESTIONS

1. Answer any 4 out of the given 6 questions on Employability Skills (1 x 4 = 4 marks)

1. (a) All of these

Explanation: All of these

2. (c) using username and password

Explanation: using username and password

3. (a) Six

Explanation: Six

4. (b) (ii) and (iii)

Explanation: (Direct and honest) and (Specific)

5. (c) World Commission on Environment and Development

Explanation: World Commission on Environment and Development

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

1. (d) Sharpen

Explanation: Sharpen

2. (b) Footer

Explanation: Footer is a section of the document that appears at the bottom margin of the page.

3. (b) Status bar

Explanation: Status bar

4. (b) insert symbols

Explanation: Insert tab symbol option from Symbols group is used to insert symbols in a document.

5. (a) File New Blank Document Create

Explanation: New text document can be created by

File New Blank Document Create

6. (a) Ctrl + F10

Explanation: Ctrl + F10

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

1. (a) Home tab

Explanation: AutoSum option is available in the Editing group of Home tab.

2. (b) Cell reference

Explanation: Cell reference

3. (c) Pressing spacebar

Explanation: Pressing spacebar

4. (c) source file

Explanation: source file

5. (a) Charts group

Explanation: Various charts are available in the Charts group of the Insert tab.

6. (b) Subtotal

Explanation: Subtotal

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

1. (d) Record

Explanation: Record

2. (c) Referential integrity

Explanation: Referential integrity

3. (a) Bigint

Explanation: Bigint

4. (c) All of these

Explanation: All of these

5. (a) Select

Explanation: Select

6. (c) Numeric calculator

Explanation: Numeric calculator because it is used to calculate the numeric numbers only as it is unable to store

data.

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

1. (c) All of these

Explanation: All of these

2. (c) All of these

Explanation: All of these

3. (a) All of these

Explanation: All of these

4. (c) All of these

Explanation: All of these

5. (b) IRCTC

Explanation: IRCTC

6. (a) All of these

Explanation: All of these

SECTION B (Employability Skills)

6. The factors that cause barriers related to the message being conveyed include lengthy messages, language problems,

intonation issues, or the non-verbal communication used.

7. The following tips may be used for effective time management:

i. Avoid delay or postponing any planned activity.

ii. Organise your work, room and school desk.

iii. Develop a ‘NO DISTURBANCE ZONE’ to sit and complete important tasks.

iv. Use waiting time productively.

v. Prepare a ‘To-do’ list and prioritise the tasks at hand.

vi. Replace useless activities by the productive activities.

8. Trojan (Trojan horse) is any malicious PC program that misdirects clients of its actual goal. The term is taken from the

Ancient Greek story of the tricky wooden steed that prompted id the fall of the city of Troy.

9. Entrepreneurs are born that way

All entrepreneurs have great ideas

The only requirement is a good idea

Entrepreneurs take lots of risk

One must know everything before starting a business

Lot of money is required to start any business

10. Five methods for enhancing sustainable development are as follows:

i. Tree plantation to prevent soil erosion

ii. Use of solar energy, wind energy, and other alternative sources of energy

iii. Rainwater harvesting

iv. Use of bio-fuels

v. Recycling of wastes

SECTION B (Subject Specific Skills) Short Answers

11. When Keep scale is selected (default), cropping the image does not change the scale of the picture.

When Keep image size is selected, cropping produces enlargement (for positive cropping values), shrinking (for negative

cropping values), or distortion of the image so that the image size remains constant.

12. A Page Break is used to determine where the printed page ends and begins the next one, so the content before the page

break will be printed on one page and after the page break on another.

13. Data > Consolidate provides a way to combine data from two or more ranges of cells into a new range while running one

of the several functions (such as Sum or Average) on the data. During consolidation, the contents of cells from several

sheets can be combined into one place. The effect is that copies of the identified ranges are stacked with their top left

corners at the specified result position, and the selected operation is used in each cell to calculate the result value.

14. DBMS stands for the database management system. It is a computerized Record-Keeping system or software that

enables you to create, store, modify and extract information from a database. The main function of DBMS is to provide

efficient and reliable methods to the users for data retrieval. In addition, it saves your time efforts and reduces the

chances of errors creeping into the database to a great extent.

15. Following are the three main types of computer networks, based upon the geographical area as follows:

i. Local Area Network (LAN)

ii. Metropolitan Area Network (MAN)

iii. Wide Area Network (WAN)

16. Antivirus and Antispyware programs offer real-time protection monitoring your computer for any changes by malware

software. Keep your Antivirus and Antispyware software always up to date, this can help in protecting your computer

from any threats.

SECTION B (Subject Specific Skills) Long Answers

17. Five items that can be added to the header section of a document can be

i. The title of the document

ii. Name of the document

iii. Pic/logo for the document

iv. Menu (that contain home, about, services, etc.)

v. Date and time

18. To link data from one spreadsheet to another in Excel, you can:

1. Open the source and destination spreadsheets.

2. Click on the cell you want to link the source to and type "=" in your destination.

3. Navigate to the spreadsheet you wish to use as the source.

4. Click on the cell you wish to link to the destination and press enter.

You can also link data by:

Copying it from the source file and then pasting it as links.

Typing in the “=” sign (plus optionally a function name) and then jumping to another worksheet and highlighting

the arguments.

When you link a cell to another sheet, the data in this cell will be automatically synchronized and updated whenever the

data in your source cell changes.

Linking data is especially important when multiple people are working on the same spreadsheet.

19. A form is a printed or typed document with blank spaces for insertion of the required or requested information. Likewise,

Access provides forms that prompt the user to provide information that can be fed into the database. They allow you to

add and update data in one record at a time in a table.

Access provides the three main view in which a form is displayed:

Form view: this view is used to enter or edit data.

Design view: this view is used to adjust the design of your form it gives you a more detailed view of the structure of

forms like header, detail and footer sections.

Layout view: this view is used to change the look and feel of a form it is useful for setting the size of controls and

changing their appearance.

20. i. EmpNo can be selected as a primary key.

ii. EmpName is having unique values, but there is no guarantee that if more employees are included then there would

not be multiple people with similar names.

So, in future its values may be duplicate. Thus, it cannot be made as a primary key.

21. E-Ticket or electronic ticket is the digital ticket equivalent of a paper ticket. IRCTC (Indian Railway Catering and

Tourism Corporation) is used to book and cancel rail tickets.

To book the ticket on IRCTC, follow the given steps:

Step 1: Open the IRCTC site by www.irctc.co.in address. The home page of IRCTC will appear on the screen.

Step 2: Enter in From and To fields, class type and click on Find Trains option.

Step 3: Search the train and click on Check Availability and Fare to find the availability of train and book now.

Step 4: The following page will display. If you have an account on IRCTC then enter login name and password

otherwise click on REGISTER button.

Step 5: Individual Registration page will appear, fill the details and click on Register button.

Step 6: After this, a window will appear as shown below

Step 7: Enter the required fields and click on Continue Booking.

Step 8: Travelling Passengers page will be appear as shown below.

Step 9: Click on Continue Booking. Payment options page will be display on the screen. Select the appropriate option

and enter details.

Step 10: Payment Page will be appear as shown below. Fill your bank details and click on Proceed button.

Step 11: E-ticket will be generated on screen as well as sent to your registered e-mail id