INFORMATION TECHNOLOGYSample Paper 6 INFORMATION TECHNOLOGY (402)Class X Session 2023-24

INFORMATION TECHNOLOGY (402)

Class X Session 2023-24

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.

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 based on Employability Skills

(i) Which of the following is an example of green building design?

(a) Constructing buildings with no regard for energy efficiency

(b) Using renewable materials for construction

(d) Ignoring water conservation measures

(ii) From the following statements, which one is not the positive impact of entrepreneurship on society?

(a) Stimulates Innovation and Efficiency

(b) Creates jobs and Employment Opportunities

(d) Discourages welfare of the society

(iii) Stress management infuses a sense of _____and accomplishment.

(a) pressure (b) control

(iv) _____ are the people who are too focused on what others think and they fail to focus on their internal matters.

(a) Seekers (b) Introspectors

(v) A _____ is a network security device that monitors incoming and outgoing network. It restricts access to

unwanted sites.

(a) firewall (b) anti-virus

(vi) Effective communication is important in the workplace because it:

(a) Enhances personal relationships

(b) Improves productivity and efficiency

(d) All of the above

2. Answer any 5 out of the given 6 questions

(i) Which one of the following is an example of RDBMS ?

(a) MongoDB (b) Windows registry

(ii) Which of the following fields will not make a suitable primary key?

(a) A customer’s account number

(b) A date-field

(d) A student’s admission number

(iii) Goal Seek is also called as _____ is one of the What-if analysis tools that is available in Calc.

(a) back-solving (b) solver

(iv) abc@mnc.co.in represents an _____.

(a) MAC address (b) URL

(v) If you choose styles, and then change the base style then all the _____ styles will change as well.

(a) linked (b) edited

(vi) A _____ allows you to present data retrieved from one or more tables so that, it can be analysed and printed, if

required.

(a) report (b) form

3. Answer any 5 out of the given 6 questions

(i) Which of the following tab is used to run Macro?

(a) Tools (b) Home

(ii) If you see #### in place of data in a cell, it means you need to _____ the cell width.

(a) increase (b) decrease

(iii) To delete a template, Right click on a template in the _____ window and select Delete.

(a) Templates (b) Design

(iv) Which tab of writer contains the Hyperlink option?

(a) File (b) Format

(v) When a user inserts a new worksheet in spreadsheet software, the new worksheet will be inserted _____.

(a) at the end of sheet tab (b) in the beginning of sheet tab

(vi) To insert a symbol like © (copyright), you need to click on the _____ option of the Insert tab.

(a) Special Character (b) Character

4. Answer any 5 out of the given 6 questions

(i) A primary key field cannot be null, which also means that it cannot be _____.

(a) invalid (b) positive

(ii) Which of the following is not a style type in Writer?

(a) Frame style (b) Image style

(iii) Which of the following websites is not used for buying clothes?

(a) Nykaa (b) IRCTC

(iv) A group of computers connected together with the help of cables within an office building is called

(a) PAN (b) MAN

(v) In the given formula, identify the type of reference and the cells that are passed as arguments.

= Average($A$5, $B$5)

(a) Absolute reference; cells are-A5 and B5

(b) Relative reference; cells are-A5 and B5

(d) Absolute reference; cells are-A5 to B5

(vi) Which of the following is an application based instant messaging software?

(a) Google Talk (b) eBuddy

5. Answer any 5 out of the given 6 questions

(i) DBMS provides various key fields as

(a) primary key and candidate key (b) alternate key and foreign key

(ii) You can move a dockable window to a convenient position on the screen by holding down the _____ key and

drag it by the title bar to where you want it docked.

(a) Ctrl (b) Alt

(iii) Instant messaging service accepts instant messages from

(a) external sites (b) internal sites

(iv) Information is the processed form of _____.

(a) words (b) data

(v) _____ is the act of posting content on a blog.

(a) Edublog (b) Posting

(vi) In order to use data from a worksheet, you need to use its _____ name.

(a) alias (b) representative

SECTION - B

Subjective Type Questions

Direction for Q 6-Q 10 : Answer any 3 out of the given 5 questions on Employability skills. Answer each question in

20-30 words.

6. How can green skills be acquired?

7. Write any two main advantages of an operating system.

8. What role does non-verbal communication play in effective communication?

9. Describe the following functions of an entrepreneur:

(i) Innovation

(ii) Risk-Taking

10. How can we self-motivate ourselves for completing a task which appears to be too large or too complex to be done

by us?

Direction for Q 11-Q 16 : Answer any 4 out of the given 6 questions in 20-30 words each.

11. How to create the reference with the mouse in Calc?

12. Explain the term relational database management system.

13. Describe the term wireless fidelity.

14. Differentiate between wired and wireless access. Give one example for each type.

15. What is data analysis in a spreadsheet software?

16. Write some features of spelling checker in OpenOffice Writer.

Direction for Q 17-Q 21 : Answer any 3 out of the given 5 questions in 50-80 words each.

17. Ram wants to compress a picture. Write the steps through which he can do so.

18. Yuan is learning about database. But, he didn’t understand the concept of field, records and table. Answer to him

the following queries:

(i) How are fields, record and a table related to each other? Explain with the help of an example.

(ii) What are the main purposes of a database system?

19. Consider the following table: MASTER

(i) How many fields and records are there in the table MASTER?

(ii) Write the SQL queries to:

(a) Display all the records according to Age.

(b) Display Name and Department of the person having salary less thin 20000.

20. Simran wants to know about Subtotal.

Answer the given questions for her.

(i) What is SUBTOTAL() function?

(ii) Names of any 5 functions with their function index number.

21. Reema has been appointed as SME in an IT based company. Tell her the following:

(i) What is workplace emergency?

(ii) Name the workplace emergencies that may happen.

*******

Search This Blog

ASK IN DETAIL

INFORMATION TECHNOLOGYSample Paper 6 INFORMATION TECHNOLOGY (402)Class X Session 2023-24

Comments

Post a Comment

Popular posts from this blog

operating system written notes pdf bcs bca mca mcs srtmun pdf computer science bsc cs it

Web technology HTML CSS JavaScript written notes bcs bca mca mcs srtmun pdf

distributed systems written notes pdf bcs bca mca mcs srtmun pdf computer science bsc cs it