SAMPLE QUESTION PAPER—2 cbse Class X (Session 2024-2025) Information Technology (SUBJECT CODE

SAMPLE QUESTION PAPER—2

Class X (Session 2024-2025)

Information Technology (SUBJECT CODE - 402)

Max. Time : 2 Hours Max. Marks : 50

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. What is the process of interpreting the message communicated in the communication cycle?

(a) Encoding (b) Decoding

ii. Which type of motivation arises from personal interest and satisfaction ?

(a) Intrinsic motivation (b) Extrinsic motivation

iii. What do icons represent on the computer Desktop ?

(a) Programs, files or folders (b) Wallpaper designs

iv. Which career option in entrepreneurship involves specialized services offered on a project basis ?

(a) Content creator (b) E-commerce entrepreneur

v. Which organization introduced the Sustainable Development Goals (SDGs) ?

(a) World Bank (b) International Monetary Fund (IMF)

vi. Which function of an operating system ensures programs run efficiently without interfering with each other ?

(a) Memory Management (b) Device Management

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

i. Which of the following is NOT a style category in LibreOffice Writer ?

(a) Paragraph Styles (b) Image Styles

ii. What is the benefit of using paragraph styles like ‘Heading 1’ and ‘Heading 2’ while creating a document ?

(a) Enhances page layout (b) Defines font colors

(d) Allows inserting footnotes

iii. What is the purpose of the “Load Styles” function in LibreOffice Writer ?

(a) Deletes existing styles from the document

(b) Replaces existing styles with new ones

(d) Disables all formatting within the document

iv. Which of the following is NOT true about Table of Contents, Index or Bibliography dialog box ?

(a) It has four tabs

(b) On the Type tab, by default, the checkbox for Protected against Manual Changes option will be selected.

(d) The Background color can be changed using the Background tab.

v. What does setting a default template in LibreOffice Writer allow you to do ?

(a) Change the font size of the document

(b) Set the document’s language preference

(d) Create new documents based on a specific template by default

vi. What is the purpose of the “Update Style” option in LibreOffice Writer ?

(a) Refreshes the document content

(b) Updates the application interface

(d) Updates the selected style with new formatting effects

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

i. Which feature in Calc is used for merging information from multiple worksheets into a single

location ?

(a) Sort (b) Merge Cells

ii. What type of hyperlink guides you to a particular location in the current or another existingworksheet ?

(a) Internet (b) Mail and News

iii. Which menu option in Calc is used to record a series of user actions and automate repetitive tasks ?

(a) Tools > Macros (b) Edit > Automation

iv. Which feature in Calc allows you to track modifications like additions, deletions, and formatting adjustments ?

(a) Track Edits (b) Record Changes

v. What is the extension of a spreadsheet file in Calc ?

(a) .odb (b) .odt

vi. What is the primary advantage of linking data and spreadsheets in Calc ?

(a) Reducing errors (b) Making sheets look organized

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

i. What does data refer to in the context of database management ?

(a) Processed information (b) Raw facts and figures

ii. The primary key in a table :

(a) Must contain NULL values (b) Cannot be NULL

iii. What is the primary purpose of a foreign key in a database ?

(a) To ensure data consistency (b) To uniquely identify each row

iv. What does the COUNT function in LibreOffice Base do ?

(a) Calculates the average of a field (b) Counts the number of records in a table

v. Which numeric data type is used to store two values - TRUE and FALSE ?

(a) BOOLEAN (b) TINYINT

vi. What is the purpose of the Criterion row in the Query Design View of LibreOffice Base ?

(a) To specify field names (b) To filter records based on conditions

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

i. What is the main purpose of water quality monitoring ?

(a) Improving employee morale (b) Ensuring water is free from contaminants

ii. What is the purpose of an emergency evacuation plan ?

(a) To train employees on equipment usage (b) To outline steps for safely leaving the building

iii. What should be done if a workplace hazard is identified ?

(a) Ignore it and continue working (b) Immediately report it to supervisors

iv. What guideline helps maintain clean air in the workplace ?

(a) Limit ventilation to conserve energy (b) Avoid using plants indoors

v. What is the primary goal of workplace health, safety and security ?

(a) Reducing employee salaries (b) Maximizing work hours

vi. What is the last line of defense in the hierarchy of hazard controls ?

(a) Engineering Controls (b) Administrative Controls

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. Why is seeking feedback considered an important principle in effective communication ?

Q. 7. What does the ability to work independently involve ?

Q. 8. Define Real-Time Operating Systems (RTOS) and state their application areas.

Q. 9. What is entrepreneurship ?

Q. 10. Mention any two ways to get clean and affordable energy.

Answer any 4 out of the given 6 questions in 20 – 30 words each. (2 x 4 = 8 marks)

Q. 11. Describe the Fill Format Mode in LibreOffice Writer and its significance in applying styles.

Q. 12. What is the purpose of the Consolidate data feature in LibreOffice Calc ?

Q. 13. When is the “Merge Document” feature in Calc useful, and how does it work ?

Q. 14. What is referential integrity, and why is it essential in relational databases ?

Q. 15. Explain the significance of the Objects Relationship Pane and the Design Grid in the Query Design View of LibreOffice Base.

Q. 16. What is the primary goal of first aid in an emergency situation ?

Answer any 3 out of the given 5 questions in 50– 80 words each. (4 x 3 = 12 marks)

Q. 17. Explain the steps involved in customizing a table of contents in Writer.

Q. 18. How can you enable sharing mode in Calc for a spreadsheet ?

Q. 19. What are the essential database objects, and what roles do they play in managing data ?

Q. 20. Explain the purpose of numeric data types in a database and provide any three examples of their usage.

Q. 21. What are the common Types of Health Hazards ? Mention any four.

*****************ANSWER KEY*****************

SECTION—A OBJECTIVE TYPE QUESTIONS

Q. 1. Answer any 4 out of the given 6 questions on Employability Skills.

1. (b) Decoding

2. (a) Intrinsic motivation

3. (a) Programs, files or folders

4. (c) Freelancer

5. (c) United Nations (UN)

6. (c) Process Management

Q. 2. Answer any 5 out of the given 6 questions.

1. (b) Image Styles

2. (c) Helps in creating a TOC with hierarchical headings

3. (c) Copies styles from a template or another document 4. (a) It has four tabs

5. (d) Create new documents based on a specific template by default

6. (d) Updates the selected style with new formatting effects

Q. 3. Answer any 5 out of the given 6 questions.

1. (c) Consolidate

2. (c) Document

3. (a) Tools > Macros

4. (b) Record Changes

5. (d) .ods

6. (a) Reducing errors

Q. 4. Answer any 5 out of the given 6 questions.

1. (b) Raw facts and figures

2. (b) Cannot be NULL

3. (c) To establish relationships between tables

4. (b) Counts the number of records in a table

5. (a) BOOLEAN

6. (b) To filter records based on conditions

Q. 5. Answer any 5 out of the given 6 questions.

1. (b) Ensuring water is free from contaminants 2. (b) To outline steps for safely leaving the building

3. (b) Immediately report it to supervisors

4. (c) Regularly clean HVAC systems

5. (c) Preventing accidents and ensuring well-being

6. (c) Personal Protective Equipment (PPE)

SECTION—B SUBJECTIVE TYPE QUESTIONS

6. Feedback is the response or the reaction given by the audience after receiving the message. It helps the sender to

analyse the effectiveness of the delivered message. Feedback can be verbal, written or non-verbal in form of

words, letters, emails, reactions, opinions or even expressions. Feedback is essential as it can impact decision

making or affect results in competitive situations. It is also valuable in its ability to help the speaker/performer to

find their weaker areas and improve upon them.

7. The ability to work independently refers to an individual’s capacity to perform tasks, make decisions, and complete

responsibilities without constant supervision or guidance from others. This skill encompasses the capacity to initiate and carry out tasks, solve problems, prioritize assignments, and make decisions without relying heavilyon external input. Name three key aspects of working independently.

8. Real-time operating systems are specially crafted for applications where immediate and predictable responses to

inputs are crucial. They are used in robotics, industrial automation, medical devices, or aerospace control systems.

RTOSs ensure that critical tasks happen within precise timeframes, making them ideal for situations where timing

is everything.

9. Entrepreneurship is the process of conceptualizing, creating, and managing a new business venture or enterprise.

It involves identifying opportunities, taking calculated risks, and organizing resources to transform innovative

ideas into viable products, services, or solutions that fulfill market needs or solve problems.

10. i. Promote Renewable Energy Sources : Utilize solar, wind, and hydroelectric power to generate clean energy,

reducing reliance on fossil fuels.

ii. Enhance Energy Efficiency : Implement energy-saving technologies like LED lighting, energy-efficient appliances,

and better insulation to minimize energy consumption.

11. Fill Format Mode feature proves particularly helpful when you need to apply a style to multiple scattered objects

in the document. Fill Format Mode is used to apply a style to many different areas quickly without having to go

back to the Styles and Formatting pane and double-click every time.

12. Consolidating data involves merging information from multiple worksheets into a single location. In Calc, you can

effortlessly achieve this using the Consolidate feature. It collects data from various worksheets and compiles it

into a master worksheet.

13. At times, when you receive multiple edited versions of a sheet from reviewers simultaneously, it can be challenging

to review them individually. To address this issue, Calc offers the Merge Document feature, which allows you to

combine these multiple files. This way, you can efficiently review all the changes in one consolidated document

instead of going through them one by one. It’s important to note that all the edited documents should have

recorded changes for this feature to work effectively.

14. Referential integrity is a critical concept in Relational Database Management Systems (RDBMS) that ensures the

accuracy, consistency, and integrity of data relationships between tables. It enforces rules and constraints to

maintain the integrity of data within a relational database.

15. 1. Objects Relationship Pane : Located at the top, this pane displays the tables selected for the query and the

relationships between them. These relationships are indicated by joined lines that link the key fields that share

the same field name.

2. Design Grid : Positioned at the bottom, this is where you build your query. You can add fields from the selected

tables to the Design Grid by either dragging and dropping them or double-clicking on the fields.

16. First aid is the immediate care and assistance provided to an injured or ill person before professional medical help

arrives. The primary goal of first aid is to provide immediate care that can make a significant difference in the

outcome of an injury or illness. Rapid response can prevent conditions from worsening and improve the chances

of a full recovery.

17. To customise the table of contents, follow these steps :

1. Right-click on the table of contents and select the Edit Index option.

2. The Table of Contents, Index or Bibliography dialog box appears.

3. The Table of Contents, Index or Bibliography dialog box consists of five tabs. You can use the options given

under each tab to customise the table of contents :

(a) The Type tab helps to set the attributes of the TOC, for example, the type of index.

(b) The Entries tab provides you with the ability to format and set exactly how each entry in the table of

contents will be displayed.

tab is used to arrange the TOC into more than one column.

(d) The Background tab has the options to add colour or a graphic to the background of the TOC.

4. After making all of your changes, click OK to save the table of contents.

18. 1. Create a spreadsheet and save it in a network location so that the other users can access it easily.

2. Click on the Tools menu.

3. Choose Share Spreadsheet… to activate the collaboration features for this file.

4. The Share Document dialog box opens. Select the Share this spreadsheet with other users checkbox to enable

sharing.

5. Click on OK.

6. A message appears ‘The spreadsheet must be saved now to activate sharing mode.’

7. Click on Yes to continue.

8. If the spreadsheet has not been saved previously, the Save As dialog box appears. Give an appropriate name

and save the spreadsheet.

9. The word (shared) is shown on the title bar next to the spreadsheet’s title.

10. Now, all the users can work together on the same spreadsheet.

19. Database objects are the basic building blocks of a database. They are used to store, organize, and manage data.

Some common database objects are as follows :

Tables : Tables are the core storage units in a database. They represent collections of related data organized into

rows and columns. Each row in a table is called a record or tuple, while each column is known as an attribute or

field. Tables store the actual data.

Queries : Queries are used to retrieve, manipulate, and analyze data from one or more tables. They can filter,

sort, aggregate, and join data, enabling users to extract meaningful information from the database.

Forms : Forms are user interfaces designed for data entry and manipulation. They provide a userfriendly way to

interact with the database by presenting data in a structured and visually appealing manner. They can be used to

create new records, update existing records, or delete records.

Reports : Reports are used to display data from a database in a formatted way. They can be used to generate

formatted documents for printing or for viewing on screen, based on the data stored in the database.

20. A numeric data type is a data type that is used to store and represent numbers. Numeric data types are used to

store and represent numbers, which can include phone numbers, admission numbers, house numbers, years of

birth, true or false statements, and statistical values. The different types of numeric data type are listed below :

21. (i) Chemical Exposure : Contact with hazardous substances, such as cleaning agents, industrial chemicals,

pesticides or solvents, can cause respiratory problems, skin irritation or poisoning. Longterm exposure may

lead to chronic conditions like cancer or organ damage.

(ii) Biological Hazards : Exposure to bacteria, viruses, fungi or other pathogens, especially in industries like

healthcare, food processing or research, can lead to infections, allergies or serious illnesses.

(iii) Ergonomic Risks : Poorly designed workstations or repetitive tasks can lead to musculoskeletal disorders,

such as carpal tunnel syndrome, back pain or neck strain. Improper lifting techniques or prolonged sitting can

exacerbate these issues.

(iv) Air Quality Issues : Poor ventilation or exposure to dust, fumes or pollutants in the workplace can lead to

respiratory conditions.

Search This Blog

ASK IN DETAIL

SAMPLE QUESTION PAPER—2 cbse Class X (Session 2024-2025) Information Technology (SUBJECT CODE - 402) Max. Time : 2 Hours Max. Marks : 50

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