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)
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 a mobile operating system?
a. Linux
b. Unix
c. Mac OS
d. iOS
ii) What is the importance of feedback in communication?
a. It allows the speaker to dominate the conversation.
b. It helps in avoiding any further communication.
c. It facilitates understanding, clarification and improvement.
d. It discourages active listening.
iii) Nirmala gets up at 5 am and goes for her dance class. Then she comes home and finishes her homewor before going to school. She does this all by herself. No one tells her to do it. Nirmala is _____
a. Self-confident
b. Self-motivated
c. Self-aware
d. Self-reliable
iv) Stress cannot be _____ , but ________.
a. Cured, practiced
b. Eradicated, managed
c. Learnt, forgotten
d. Avoided, welcomed
v) Which of the following is a key component of sustainable development?
a. Expanding the excessive use of resources
b. Disregarding the need for resource conservation
c. Recycling and reusing waste materials
d. Ignoring the management of renewable resources
(vi) How can an entrepreneur get the work done from his/her team?
a. By creating a spirit of teamwork.
b. By motivation.
c. Using harsh word and actions.
d. Both a. and b.
2 Answer any 5 out of the given 6 questions (1X5=5 marks)
i) A _______ is a predefined layout that contains sample content, themes, colours, font styles, background styles etc and gives an initial foundation to build a document.
a. Gallery
b. Template
c. Style
d. Format
ii) Which of the following extensions is used to save a document as template?
a. .oot
b. .ott
c. .otd
d. .odd
iii) These handles are used to resize an image diagonally.
a. Corner Handles
b. Side Handles
c. Center Handles
d. Both a. and b.
iv) What does TOC stand for?
a. Terms of Contract
b. Table of Contents
c. Terms & Conditions
d. All of these
v) The process of deleting unwanted areas of a photograph or image in order to improve its appearance is called
a. deleting
b. resizing
c. cropping
d. rotating
vi) The templates created by user are saved in ______ folder.
a. Templates
b. My Templates
c. Writer Templates
d. My Documents
3 Answer any 5 out of the given 6 questions (1X5=5 marks)
i) Macros are especially useful to ________ a task.
a. do
b. complicate
c. repeat
d. simplify
ii) Scenario, Solver, and Goal seek are all tools of ________.
a. Formula analysis
b. What-if analysis
c. Result analysis
d. Computing
iii) The feature _______ of Calc selects the contents of cells from several worksheets and maintains the collected data in a master sheet.
a. Subtotals
b. Consolidate
c. Data Provider
d. Merge Data
iv) The cell reference for cell range of G2 to M12 is ______.
a. G2.M12
b. G2;M12
c. G2:M12
d G2,M12
v) In a spreadsheet, the authors and reviewers can add their own ______ to the changes that they have made to explain why they have made this change.
a. comments
b. reviews
c. tracks
d. copies
vi) By default, sheets tabs are present at the _______ of the spreadsheet.
a. top
b. bottom
c. centre
d. right
4 Answer any 5 out of the given 6 questions (1X5=5 marks)
i) A ______ helps us join information from different tables and filter that information.
a. query
b. report
c. database
d. forms
ii) A table can have only one _____ key.
a. primary
b. composite
c. secondary
d. concatenation
iii) Which of the following is not a Database object?
a. Tables
b. Handouts
c. Reports
d. Queries
iv) It is an interactive way of entering data.
a. Form
b. Report
c. Query
d. Record
v) In a database, information is stored in the form of _______.
a. rows
b. columns
c. tables
d. forms
vi) It determines what type of data you can enter into a field.
a. Data type
b. Attribute
c. Alias
d. Record
5 Answer any 5 out of the given 6 questions (1X5=5 marks)
i) What is the primary reason of having workplace health, safety and security policy?
a. To increase organization cost.
b. To comply with all applicable laws and regulations.
c. To boost revenue for the company.
d. To encourage employees to work for longer hours.
ii) Which factor is important in preventing slips, trips and falls in the workplace?
a. Keeping the walking surfaces clean, clear and dry.
b. Wearing high heeled shoes.
c. Ignoring wet or oily floors.
d. Working in poorly lit areas.
iii) Which of the following should be done regularly to maintain fire safety?
a. Disabling smoke detectors.
b. Conducting fire drills and Training.
c. Ignoring equipment overheating.
d. Allowing open flames near combustible material.
iv) _______ is the process or practice of ensuring the most optimal setup (i.e. settings, equipment, etc.) to allow human beings to work to their full potential.
a. Office Environment
b. Ergonomics
c. Office Safety
d. Safety & Well-being Audit
v) Glare and _______ on the screen should be prevented.
a. reflection
b. water
c. dirty hands
d. scratching
vi) What should be the first step in the evacuation procedure during an emergency?
a. Open all doors for ventilation.
b. Activate the emergency alarm or inform a senior officer.
c. Assist the injured people.
d. Collect personal items.
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. It is believed that “entrepreneurs are high risk takers”. Do you consider this to be a myth? Comment.
Ans: The idea that “entrepreneurs are high risk takers” is not entirely true. Entrepreneurs do take risks, but they are careful and plan before taking them. They think about the possible results, find ways to reduce risks, and make smart decisions to succeed. They are not reckless; they take risks only when it makes sense for their business.
7. Briefly discuss the significance of self-awareness.
Ans: Self-awareness is crucial for personal and professional growth as it helps individuals understand their emotions, strengths, and weaknesses. It fosters better decision-making, improves relationships, enhances emotional intelligence, and enables effective communication and adaptability in various situations.
8. What are the 7Cs of communication?
Ans: The 7Cs of communication are Clear, Concise, Concrete, Correct, Coherent, Complete and Courteous.
9. How a multitasking Operating System works?
Ans: A multitasking operating system (OS) allows multiple tasks (jobs, processes or programs) to run concurrently by rapidly switching between them using process scheduling. It allocates CPU time slices to each task, manages resources, and ensures efficient execution and responsiveness.
10. Name the four objectives of Sustainable Development.
Ans: i. Quality education
ii. Economic growth
iii. Clean water and Sanitation
iv. Zero hunger
Answer any 4 out of the given 6 questions in 20–30 words each (2X4=8 marks)
11. List the different ways of inserting images in Writer.
Ans: There are some ways to insert images in Writer are as follows:
Insert Image: Use the “Insert” menu to add images from your computer or other locations.
Drag and Drop: Simply drag the image file into your document.
Copy and Paste: Copy an image from one location and paste it into your document.Screen Capture: Capture screenshots using keyboard shortcuts (e.g., “Print Screen” on Windows).
12. Give any three examples of workplace hazards.
Ans: (i) Slips, trips, and falls – Caused by wet floors, uneven surfaces, or cluttered walkways.
(ii) Chemical exposure – Handling hazardous substances like fumes, liquids, or gases without proper protection.
(iii) Electrical hazards – Risks associated with faulty wiring, exposed cables, or improper use of electrical equipment.
13. Sunita is confused between the two types of hyperlinks in Calc — absolute and relative. Help her understand the difference between the two.
Ans: The Absolute Hyperlink is a hyperlink that contains the full address of the destination file or webpage.
Example: https://learncse.in/about-us/ or D:\Entrance\New Folder\winter.jpg
The Relative Hyperlink contains a partial address, which is relative to the address of the destination file. Example: If you have saved a worksheet/workbook “abc.xlsx” and an image file “winter.jpg” in D: drive. To create a relative hyperlink of the image file to the workbook, the relative path will be “\winter.jpg”.
14. Consider a relation Student having following fields: Rollno, Admno, Name, Class, Marks. Identify the Primary Key from the above fields and give reason for choosing it.
Ans: The Primary Key for the relation Student can be Rollno or Admno as both uniquely identify each student. Typically, “Admno” is preferred because it remains constant throughout the student’s academic record and that can be used to identify each record uniquely.
15. Mr. Lakhan a Database Administrator has created a spreadsheet to prepare the results of annual exam. Suggest him a feature of Calc which he can use to allow the teachers to access and use the spreadsheet at the same time.
Ans: Mr. Lakhan can use the “Share Spreadsheet” feature in Calc. This feature allows multiple users to access, manipulate, and collaborate on the spreadsheet simultaneously. Changes made by one user may visible to others in real time.
16. How can fire safety be ensured at the workplace?
Ans: Fire safety at the workplace can be ensured by installing fire alarms, extinguishers, and sprinklers, conducting regular fire drills, maintaining clear emergency exits, storing flammable materials safely, and training employees on fire safety protocols.
Answer any 3 out of the given 5 questions in 50–80 words each (4X3=12 marks)
17. What are Styles in Writer? How its beneficial to the users?
Ans: Styles refer to pre-defined sets of formatting attributes such as font type, size, color, paragraph spacing, and more that can be applied to text or objects in a document or presentation. They help to ensure consistency in the formatting of a document or presentation, making it easier to create professional-looking materials quickly and efficiently. Styles ensure consistency by applying uniform formatting to elements like headings and paragraphs. They improve efficiency and save time by allowing quick, repeated application of predefined formats. Styles are easy to update, enabling global changes without manual adjustments. Additionally, they enhance accessibility, making documents easier to navigate for users with assistive technologies.
18. What is solver? How it is different from Goal seek in Calc?
Ans: Solver is another What-if Analysis tool. It follows the Goal Seek method to solve the equations but more elaborately. It is the elaborate form of Goal Seek tool. The only difference between Goal Seek and Solver is that Goal Seek adjusts a single variable to achieve a desired result in a formula, while Solver works with multiple variables and constraints, providing more advanced problem-solving capabilities.
19. Explain the following database objects:
a. Table – A table is a structured database object consisting of rows and columns used to store data in a relational database. Each column represents a field, and each row holds a record.
b. Query – A query is a database object used to retrieve, filter, manipulate, or analyze data from one or more tables based on specific conditions.
c. Form – A form is a user-friendly database object designed to input, modify, or view data interactively, often presenting data fields in a structured layout.
d. Report – A report is a formatted database object used to organize and present data in a structured manner, often for printing or sharing summaries and insights.
20. What are the general procedures for evacuating a workplace during an emergency?
Ans: Regular drills help reinforce these procedures. The general procedures for evacuating a workplace during an emergency include:
1. Stay calm and follow instructions from emergency personnel.
2. Immediately stop work and secure hazardous materials.
3. Use designated evacuation routes and exits; avoid elevators.
4. Proceed to the assembly point and check in with your supervisor.
5. Assist individuals with special needs, if safe.
6. Do not re-enter the building until authorized by emergency officials.
21. Write SQL commands for the following based on the given table CLUB.
| COACH_ID | COACHNAME | AGE | SPORTS | DATEOFAPP | PAY | GENDER |
|---|---|---|---|---|---|---|
| 1 | KUKREJA | 35 | KARATE | 27/03/1996 | 1000 | M |
| 2 | RAVINA | 34 | KARATE | 20/01/1998 | 1200 | F |
| 3 | KARAN | 34 | SQUASH | 19/02/1998 | 2000 | M |
| 4 | TARUN | 33 | BASKETBALL | 01/01/1998 | 1500 | M |
| 5 | ZUBIN | 36 | SWIMMING | 12/01/1998 | 750 | M |
| 6 | KATAKI | 36 | SWIMMING | 24/02/1998 | 800 | F |
| 7 | ANKITA | 39 | SQUASH | 20/02/1998 | 2200 | F |
| 8 | ZAREEN | 37 | KARATE | 22/02/1998 | 1100 | F |
| 9 | KUSH | 41 | SWIMMING | 13/01/1998 | 900 | M |
| 10 | SHAILYA | 37 | BASKETBALL | 19/02/1998 | 1700 | M |
a. To display names of all female coaches.
Ans: SELECT COACHNAME FROM CLUB WHERE GENDER = “F”;
b. To display coach’s name and their sports who are getting salary more than 1500.
Ans: SELECT COACHNAME, SPORTS FROM CLUB WHERE PAY > 1500;
c. To display details of Basketball coaches.
Ans: SELECT * FROM CLUB WHERE SPORTS = “BASKETBALL”;
d. To remove records of coaches older than 40 years.
Ans: DELETE FROM CLUB WHERE AGE > 40;