Find CBSE and other IT Sample Papers for Class 10 – Code 402 with Complete Solution. Prepare for IT Code 402 Class 10 by Downloading PDF Sample Papers for Pre Board or Annual Exams and Understand the complete pattern of Board Exams for all Sessions. Here, LearnCSE.in website is a one platform to get all Class 10 IT Code 402 Previous Year Question Papers and Solutions related to computer science, Information Technology or Informatic Practices.
CBSE | DEPARTMENT OF SKILL EDUCATION
INFORMATION TECHNOLOGY (SUBJECT CODE – 402)
Pre Board Sample Question Paper for Class X (Session 2024-2025) – SET 1 by KIPS Publication – Solution
Max. Time: 2 Hours
Max. Marks: 50
General Instructions:
- Please read the instructions carefully.
- This Question Paper consists of 21 questions in two sections: Section A & Section B.
- Section A has Objective type questions whereas Section B contains Subjective type questions.
- 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. - All questions of a particular section must be attempted in the correct order.
- 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. - 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 (1X4=4 marks)
i) Which of the following is an antivirus?
a. Norton
b. Quick Heal
c. McAfee Virus Scan
d. All of these
ii) Stress management prevents ______.
a. Psychological disorders
b. Behavioural Problems
c. Both of the above
d. None of these
iii) Why are small businesses important to a country’s economy?
a. They give an outlet to entrepreneurs.
b. They can provide specialist support to larger companies.
c. They can be innovators of new products.
d. All of these
iv) How much % of the communication that we do in our day-to-day communication is non-verbal?
a. 55%
b. 93%
c. 7%
d. 38%
v) What are green skills?
a. Skills related to the color green
b. Skills that promote environmental sustainability
c. Skills used in the gardening industry
d. Skills related to renewable energy
vi) What is a primary function of an entrepreneur?
a. Managing human resources
b. Identifying market trends
c. Developing software programs
d. Conducting financial audits
2 Answer any 5 out of the given 6 questions (1X5=5 marks)
i) It is a setting that sets the relation of graphics to the surrounding text.
a. Wrap Text
b. Anchoring
c. Alignment
d. Book Mark
ii) How many levels of headings does document Writer evaluate to build the table of contents?
a. 8
b. 9
c. 10
d. 11
iii) State whether True or False:
“You can create your own template using a wizard in a word processor”.
Answer: True
iv) Which of the following styles is not offered by word processing software?
a. Page style
b. Frame style
c. Presentation style
d. Video Style
v) Which of the graphic filters is used to increase the contrast of an image in a document?
a. Sharpen
b. Smooth
c. Invert
d. Solarization
vi) In a word processor, ______ option is selected for a scaled resizing of an image.
a. Original Size
b. Keep ratio
c. Image Size
d. Relative
3 Answer any 5 out of the given 6 questions (1X5=5 marks)
i) _____ means to arrange data in either ascending order or descending order.
a. Filtering
b. Report
c. Sorting
d. Forms
ii) Spreadsheet software allows the user to share the workbook and place it in the location _____ where several users can access it simultaneously.
a. Local
b. Network
c. Global
d. None
iii) Which of the following can be used to consolidate data in a spreadsheet software?
a. Row label
b. Column label
c. Both a and b
d. None of these
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
b. Repeat changes
c. Change record
d. Macro
v) _____ allows you to gather together your data from separate worksheets into a master worksheet.
a. Foreign Key
b. Data Range
c. Data Consolidation
d. None of these
vi) Goal seek option is available in the _____ menu of a spreadsheet software.
a. Tools
b. Format
c. Data
d. Insert
4 Answer any 5 out of the given 6 questions (1X5=5 marks)
i) _____ means that the data is accurate and consistent in the database.
a. Data Redundancy
b. Data Integrity
c. Data Security
d. Data Sharing
ii) When primary key constraint is applied on one or more columns then it is known as:
a. Composite Primary Key
b. Foreign Key
c. Candidate Key
d. None of the above
iii) Which one of the following is not an example of DBMS?
a. PostgresQL
b. SQLite
c. Foxpro
d. Impress
iv) A _____ is an interface in a user specified layout that lets users view, enter, change data directly in database objects such as tables.
a. frame
b. form
c. file
d. report
v) _____ clause can be used with the SELECT statement in SQL to specify which rows to retrieve from the table.
a. WHERE
b. GROUP
c. SAME
d. SIMILAR
vi) _____ are used to identify which type of data we are going to store in the database.
a. Field Name
b. Data Types
c. Data element
d. None of the these
5 Answer any 5 out of the given 6 questions (1X5=5 marks)
i) _____ is the first response to an illness or injury before proper medical care is provided.
a. Rescue
b. Evacuation
c. Emergency
d. First Aid
ii) In fire classification, electrical material and equipment comes under _____ .
a. Class A material
b. Class B material
c. Class C material
d. Class D 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
b. Fire and fall
c. Slip, trip and fall
d. Handling equipment
iv) Who should be responsible for handling the evacuation process?
a. Government
b. Management
c. Employees
d. Coordinator
v) _____ should be used to mark a cord or wire that crosses a pathway.
a. Red marker
b. Hazard tape
c. Sign board
d. Some obstacle
vi) Modern LED monitor with _____ ensures better readability.
a. Medium resolution
b. High resolution
c. Low resolution
d. None of these
SECTION B: SUBJECTIVE TYPE QUESTIONS
Answer any 3 out of the given 5 questions on Employability Skills (2X3=6 marks)
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?
Answer: 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 situation, which two stress management techniques should they consider?
Answer: To manage stress, try deep breathing exercises and time management techniques to balance academic and personal responsibilities effectively.
8. 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 prevent further damage.
Answer: 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.
Answer: 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.
Answer: 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 marks)
11. What are Styles? What are the advantages of using styles?
Answer: 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.
Answer: 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.
Answer: 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?
Answer: Comments help explain cell contents or changes. Add comments by right-clicking a cell and selecting “Insert Comment.”
15. 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.
Answer: Floor plans help employees familiarize themselves with exit routes, ensuring faster, safer evacuations during emergencies.
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.
Answer: 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 marks)
17. Explain the following with respect to Spreadsheet Software:
a. Subtotals
Answer: Automatically calculate subtotals for different groups in data.
b. Consolidating Data
Answer: Combines data from multiple ranges into one for easier analysis.
18. a. Explain the term “Referential Integrity”. Why is it important in a database?
Answer: Ensures relationships between tables are consistent. It prevents orphaned records in databases.
b. Explain the utility of text wrapping in a document? Give the name of different types of text wrapping available.
Answer: 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.
Answer: Medicine_Inventory and Suppliers
b. For each of the tables, recommend at least two fields along with their data types that should be present.
Answer: Medicine name (text), Quantity (integer), Supplier name (text), Contact
(text)
c. Highlight two benefits that STAR Medicos’ management will gain by computerising their inventory through this database.
Answer: Efficient tracking of inventory, quick restocking from suppliers
20. Write short notes on the following.
a. Accident
Answer: An unforeseen event causing harm or damage.
b. Emergency
Answer: A situation that poses immediate risk to health or safety requiring urgent action.
21. Consider the following table name Employee and write the queries for the following:
i. How many fields and records are there in the table?
Answer: 6 Fields and 5 Records
ii. Write SQL commands for the following.
a. To display the names of employees whose salary is not known, in alphabetical order.
Answer: SELECT Name FROM Employee WHERE Salary IS NULL ORDER BY Name;
b. To display DEPTID from the table EMPLOYEE without repetition.
Answer: SELECT DISTINCT DEPTID FROM Employee;
c. To display the name and designation of each employee whose salary is more than 500000.
Answer: SELECT Name, Designation FROM Employee WHERE Salary > 500000;
Note: According to us, the answers are not in sufficient word limit. Please check the notes.