IT 402_Answer Key 10_sample Paper_1

Information Technology Code – 402
Sample Paper 1
Answer key
Class - 10
Time: 2 Hours Max. Marks: 50
Section A
1. Answer any 4 out of the given 6 questions on Employability Skills. 1×4 = 4
i. Which of the following is an antivirus?
d. All of these (Norton, Quick Heal, and McAfee Virus Scan are all antivirus
programs).
ii. Stress management prevents:
c. Both of the above (Psychological disorders and Behavioral Problems).
iii. Why are small businesses important to a country’s economy?
d. All of these (They provide outlets for entrepreneurs, support larger companies,
and innovate new products).
iv. How much % of the communication that we do in our day-to-day communication is
non-verbal?
ps
b. 93%.
v. What are green skills?
b. Skills that promote environmental sustainability.
vi. What is a primary function of an entrepreneur?
b. Identifying market trends.
2. Answer any 5 out of the given 6 questions. 1×5 = 5

i. It is a setting that sets the relation of graphics to the surrounding text:
Ki
a. Wrap Text.
ii. How many levels of headings does Writer evaluate to build the table of contents?
b. 9.
iii. State whether True/False:
“You can create your own template using a wizard in a word processor.”
True.
iv. Which of the following styles is not offered by word processing software?
d. Video Style.
v. Which of the graphic filters is used to increase the contrast of an image in a
document?
a. Sharpen.
vi. In a word processor, _________________ option is selected for a scaled resizing of
an image.
b. Keep ratio.

i. ………………… means to arrange data in either ascending order or descending order.
c. Sorting.
ii. Spreadsheet software allows the user to share the workbook and place it in the
location ……………………………… where several users can access it simultaneously.
© Kips learning Pvt. Ltd 2025
b. Network.
iii. Which of the following can be used to consolidate data in a spreadsheet software?
c. Both a and b (Row label and Column label).
iv. ……………………………… is a feature of the spreadsheet that helps to track what data
was changed, when the change was made, who made the change and in which cell
the change has occurred.
a. Record changes.
v. ……………………………… allows you to gather together your data from separate
worksheets into a master worksheet.
c. Data Consolidation.
vi. Goal seek option is available in the ……………………………… menu of a spreadsheet
software.
a. Tools

i. ……………………………… means that the data is accurate and consistent in the
database.
ps as:
b. Data Integrity.
ii. When primary key constraint is applied on one or more columns then it is known
a. Composite Primary Key.

iii. Which of the following is not an example of DBMS?
d. Impress (Impress is a presentation software).
iv. A ……………………………… is an interface in a user specified layout that lets users view,
enter, change data directly in database objects such as tables.
Ki
b. Form.
v. …………………… clause can be used with the SELECT statement in SQL to specify which
rows to retrieve from the table.
a. WHERE.
vi. ……………………………… are used to identify which type of data we are going to store in
the database.
b. Data Types.
i. ………………… is the first response to an illness or injury before proper medical care is
provided.
d. First Aid.
ii. In fire classification, electrical material and equipment comes under …………………… .
c. Class C material.
iii. In Manav’s office, regular mock drills are essential for safety preparedness. Mock
drill for which two scenarios should be carried from time to time?
a. Fire and electric.
iv. Who should be responsible for handling the evacuation process?
d. Coordinator.
v. ……………………………… should be used to mark a cord or wire that crosses a pathway.
b. Hazard tape.
vi. Modern LED monitor with ……………………………… ensures better readability.
b. High resolution
Section B
Answer any 3 out of the given 5 questions on Employability Skills 2x3 = 6

Answer each question in 20 – 30 words.
6. Emily, a college student aspiring to start her own small business. Advise Emily to dismiss
myths about Entrepreneurship and provide her with a more realistic perspective on
what it takes to be a successful entrepreneur?
Entrepreneurship is not about overnight success or being rich instantly. It requires
hard work, planning, and patience to build a successful business.
7. A college student is experiencing high levels of stress due to academic pressure and
personal responsibilities. They are looking for effective stress management techniques
to improve their well-being and academic performance. Based on the college student’s
8.
ps
situation, which two stress management techniques should they consider?
To manage stress, try deep breathing exercises and time management techniques to
balance academic and personal responsibilities effectively.
Sarah is an avid online shopper who recently fell victim to a phishing scam. She received
an email claiming to be from her favourite online store, asking her to click on a link to
update her account information. Unfortunately, Sarah entered her login credentials on a
fake website, compromising her account.
As a cybersecurity advisor, provide Sarah with step-by-step guidance on what steps
should she take to safeguard her personal information and to secure her account to
Ki
prevent further damage.
Change your passwords immediately, enable two-factor authentication, and inform
the website of the phishing attempt. Regularly monitor your accounts for suspicious
activity.
9. Identify and provide brief explanations for any four components (C’s) of the 7 C’s of
effective communication.
• Clarity: Be clear about your message.
• Conciseness: Keep your message short and to the point.
• Consistency: Ensure your message is uniform.
• Completeness: Provide all necessary information.
10. Why is it important to adopt Sustainable Development? Give any 2 points.
Sustainable development ensures resource availability for future generations and
reduces environmental damage, promoting long-term growth.
Answer any 4 out of the given 6 questions in 20 - 30 words each. 2x4 = 8
11. What are Styles? What are the advantages of using styles?

Styles in a document apply a consistent format to text. They save time and maintain
uniformity across headings, paragraphs, or lists.
12. An office manager in a busy organization wants to streamline repetitive tasks in Excel to
save time. They have heard about “Macros” but are unsure of what they are and how to
create them to automate tasks. In the context of the above situation please explain
what Macros are and write the steps of recording a Macro.
Macros automate repetitive tasks. Steps to create:
1. Go to Tools -> Macros -> Record Macro.
2. Perform tasks.
3. Stop recording.
13. Differentiate between tuples and attributes of a table. Give 2 points of differentiation
each.
• Tuples: Rows of data in a table.
• Attributes: Columns in a table, representing data categories.
14. What is the purpose of adding comments in a worksheet? How can we add comments
to the changes made?
Comments help explain cell contents or changes. Add comments by right-clicking a cell
15.
ps
and selecting "Insert Comment."
Imagine you are the safety coordinator for a large office building. During a recent fire
drill, you observed that some employees seemed disoriented and unsure of the
evacuation routes. Explain in brief the importance of demonstrating floor plans near
emergency exits and outline specific strategies to ensure that employees are familiar
with the building layout during emergency situations.
Floor plans help employees familiarize themselves with exit routes, ensuring faster,
safer evacuations during emergencies.
Ki
16. A school is upgrading its record-keeping system from traditional paper files to a
Database Management System (DBMS). Give two advantages the school might
experience with the new DBMS, and how these advantages could enhance the overall
management of student information and academic records.
DBMS reduces errors, enhances data accessibility, and makes record management
easier, improving overall efficiency.
Answer any 3 out of the given 5 questions in 50 - 80 words each. 4x3 = 12

17. Explain Subtotals and Consolidating Data.
• Subtotals: Automatically calculate subtotals for different groups in data.
• Consolidating Data: Combines data from multiple ranges into one for easier
analysis.
18. a. Explain the term “Referential Integrity”. Why is it important in a database?
b. Explain the utility of text wrapping in a document? Give the name of different types of
text wrapping available.
• Referential Integrity: Ensures relationships between tables are consistent. It prevents
orphaned records in databases.
• Text Wrapping: Ensures text fits within a cell, wrapping onto multiple lines if
necessary. Types include "wrap through," "wrap above," and "wrap below."
19. The management of STAR Medicos, a medical store, has decided to modernise their
inventory of medicines by computerising it. They seek your advice for setting up the
database.
a. Suggest two tables that should be included in the “Medical_Store” database.
b. For each of the tables, recommend at least two fields along with their data types that
should be present.
c. Highlight two benefits that STAR Medicos’ management will gain by computerising
their inventory through this database.
• Tables: Medicine Inventory and Suppliers.
• Fields: Medicine name (text), Quantity (integer), Supplier name (text), Contact
(text).
• Benefits: Efficient tracking of inventory, quick restocking from suppliers.
20. Write short notes on the following.
i. Accident ii. Emergency
• Accident: An unforeseen event causing harm or damage.
• Emergency: A situation that poses immediate risk to health or safety requiring
urgent action.
21.
ps
Consider the following table “Employee” and answer the questions based on it.
Ki
i. Fields: 4 fields, 5 records.
ii. SQL Commands:
a. SELECT Name FROM Employee WHERE Salary IS NULL ORDER BY Name;
b. SELECT DISTINCT DEPTID FROM Employee;
c. SELECT Name, Designation FROM Employee WHERE Salary > 500000;

IT 402_Answer Key 10_sample Paper_1

Uploaded by

Copyright:

Available Formats

IT 402_Answer Key 10_sample Paper_1

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

IT 402_Answer Key 10_sample Paper_1

Uploaded by

Copyright:

Available Formats

Information Technology Code – 402

2. Answer any 5 out of the given 6 questions. 1×5 = 5

3. Answer any 5 out of the given 6 questions. 1×5 = 5

4. Answer any 5 out of the given 6 questions. 1×5 = 5

a. Composite Primary Key.

Answer any 3 out of the given 5 questions on Employability Skills 2x3 = 6

Answer any 4 out of the given 6 questions in 20 - 30 words each. 2x4 = 8

© Kips learning Pvt. Ltd 2025

Answer any 3 out of the given 5 questions in 50 - 80 words each. 4x3 = 12

© Kips learning Pvt. Ltd 2025

You might also like