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 2023-2024) – 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
Q. 1 Answer any 4 out of the given 6 questions on Employability Skills (1X4=4 marks)
i) Feedback is an important part of the communication cycle. A good feedback is always ____ .
a. Generic
b. Specific
c. Ignored
d. Impolite
ii) ____ provide us with energy and motivation to achieve our goals.
a. Stress
b. Distress
c. Eustress
d. Depression
iii) To be a successful entrepreneur, you must be .
a. Goal – Oriented
b. Rich
c. Technology Driven
d. Visionaries
iv) What is self-motivation?
a. External pressure to perform tasks
b. The force within you that drives you to do things
c. Influence from others to achieve goals
d. The ability to avoid doing things without external influence
v) What does the “R” in SMART signify when setting goals?
a. Rigorous
b. Resourceful
c. Realistic
d. Rewarding
vi) 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. Ingnoring the management of renewable resources
Q. 2 Answer any 5 out of the given 6 questions (1X5=5 marks)
i) Which of the following is true about a Table of Contents?
a. Usually located at the end of a document.
b. Provides an organized list of chapters along with their page numbers.
c. Useful only for shorter documents.
d. Primarily used for fiction books.
ii) The document is creating by combining the main document with the data source fields.
a. Merged
b. Combined
c. Collated
d. Blank
iii) A file saved with the extension .ott is called a ____ .
a. Style
b. Theme
c. Template
d. Object
iv) Mail merge feature can help you in printing multiple addresses ____ on a single sheet.
a. Stickers
b. Objects
c. Labels
d. Details
v) Which category of styles will you click to set the font and size of text in a paragraph?
a. Tablet Styles
b. Paragraph Styles
c. Character Styles
d. Indent Styles
vi) ____ is a combination of title, heading, and paragraph styles.
a. Style Set
b. Font Set
c. Color Set
d. Index Set
Q. 3 Answer any 5 out of the given 6 questions (1X5=5 marks)
i) Which step should you follow before using the subtotal command?
a. Consolidate Data
b. Sort data
c. Filter data
d. both A & C
ii) Sarah, a project manager, needs to combine data from various team progress reports into a master worksheet for an overall project overview. To achieve this, she will utilize the feature of a spreadsheet known as ____.
a. Consolidate
b. Subtotal
c. Columns
d. Data Provider
iii) The ____ feature of spreadsheet enables you to keep track of the changes made by you or the other users in a spreadsheet.
a. Changes
b. Track Changes
c. Record Changes
d. Show Changes
iv) A hyperlink in a spreadsheet can be ____ .
a. Text
b. Picture
c. both a and b
d. none of these
v) ____ allows you to record a set of actions that you perform repeatedly in a spreadsheet.
a. Mail Merge
b. Review
c. Macro
d. Solver
vi. An argument can be passed through a macro function ____ .
a. By Value
b. By Reference
c. Both a and b
d. None of these
Q. 4 Answer any 5 out of the given 6 questions (1X5=5 marks)
i) In a database, the information is stored in the form of ____ :
a. Rows
b. Columns
c. Tables
d. All of the above
ii) In which type of database, can you retrieve the data from the related tables?
a. Database Management System
b. Relational Database Management System
c. Rational Database Management System
d. None of the above
iii) A table can have only one ____ key.
a. Primary
b. Secondary
c. Composite
d. Concatenation
iv) Which of the following database objects are used to retrieve data from database?
a. Queries
b. Tables
c. Reports
d. Layouts
v) The ____ SQL command is used to create a table in the database.
a. Select
b. Create table
c. Insert table
d. Add table
vi) The data type is used to store date or time or combination of date and time.
a. Date/Time
b. Calendar
c. Interval
d. Table
Q. 5 Answer any 5 out of the given 6 questions (1X5=5 marks)
i) Which of these is a psychological factor at work that can prove Hazardous?
a. Conflicts at workplace
b. Lasers
c. Presence of allergens
d. None of these
ii) Mehul is a remote worker who needs to join a virtual team meeting. He connects his laptop to a device that helps transmit digital signals over the internet. This device is referred to as a ____ .
a. Hub
b. Switch
c. Repeater
d. Modem
iii) Communication over the internet is governed by a set of rules known as ____ .
a. Topology
b. Network
c. Protocols
d. Internet
iv) The process of selling and buying products over the internet is called ____ .
a. Online Shopping
b. E- banking
c. E- reservation
d. None of these
v) The Qumana blog ____ window helps you to add a blog.
a. Helper
b. Both a and b
c. Manager
d. None of these
vi) What is the act of sending an email to a user, misleading them to believe it originates from a trusted person or organisation?
a. Phishing
b. Cracking
c. Hacking
d. Malware
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. Write two ways to overcome barriers to effective communication.
7 Define extrinsic motivation.
8 What do you understand by the term ‘Computer Maintenance’? Differentiate between hardware and software maintenance.
9 What are the two types of risks usually faced by an entrepreneur?
10 “Natural occurrences can pose a threat to sustainability.” Explain.
Answer any 4 out of the given 6 questions in 20–30 words each (2X4=8 marks)
11. What is Table of Contents? List any two characteristics of a good TOC.
12 Mention any two operations that can be performed using Macros in a spreadsheet.
13 Sharing a spreadsheet is useful. Why?
14 Differentiate between DML and DDL.
15 Why do you need to back-up your data?
16 Mention two preventive measures that can be taken to prevent accidents at the workplace.
Answer any 3 out of the given 5 questions in 50–80 words each (4X3=12 marks)
Q. 17 List the different styles categories available in document.
Q. 18 What is a solver? How is it different from Goal Seek?
Q. 19 What precautions must be taken to improve the internet security?
Q. 20 Sudheer is not clear about the use of a database. Explain to him the following to give him a better understanding of the DBMS concepts.
a. Describe any four advantages of DBMS.
b. State the relationship and difference between a primary and foreign key.
Q. 21 Consider the following table name Employee and write the queries for the following:
i. Write an SQL command to display the employees in descending order of their salary.
ii. Write a query to display the details of employees who belong to the ‘HR’ department.
iii. Write an SQL query to display the details of the employees whose salary falls within the range of 50000 and 60000.
iv. Write a query to delete the employee with EmployeeID 3 from the table.