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 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.
INFORMATION TECHNOLOGY (SUBJECT CODE – 402)
Pre Board Sample Question Paper for Class 10 (Session 2023-2024) – SET 3 by LearnCSE 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) Incompetent staff means
(a) experienced staff
(b) qualified staff
(c) not experienced and not qualified
(d) None of the above
(ii) Regular exercise helps pep up your mood and can take your mind off a lot of worry and negativity which are the main feed of stress. Which of the following activity is not considered as exercise?
(a) Walking
(b) Swimming
(c) Jogging
(d) Talking
(iii) Moving a folder or a file means ____ it from its original location and placing it at another location.
(a) Removing
(b) Leaving
(c) Pointing
(d) None of these
(iv) Society plays a role in boosting entrepreneurship by
(a) creates needs and demands
(b) provides raw materials
(c) creates a need for education
(d) All of the above
(v) What is visual communication dependent on among people?
(a) Signs, symbols, and pictures
(b) Text messages
(c) Posture
(d) Body language
(vi) Which of the following is a social benefit of sustainable development?
(a) Increased income inequality
(b) Improved access to education and healthcare
(c) Limited job opportunities
(d) Neglected social infrastructure
Q. 2 Answer any 5 out of the given 6 questions (1X5=5 marks)
(i) A person who writes a blog or a weblog is known as ____.
(a) program
(b) blogger
(c) user
(d) None of these
(ii) The ____ command is used to modify the existing rows in a table.
(a) UPDATE
(b) ALTER
(c) INSERT
(d) REVIEW
(iii) A ____ is a database element that is used to view, enter and edit records in a table.
(a) Form
(b) Report
(c) Query
(d) None of these
(iv) Neeta is planning to take a car loan to buy a new car. But she is not sure about the payback time, i.e. whether to pay it back in 5 or 6 years considering that her monthly fuel cost will also increase. In such cases, which of the following features of spreadsheet can she use to get an idea about it?
(a) Consolidation
(b) Macros
(c) Templates
(d) What-if analysis
(v) ____ styles are used to format graphics and text frames, including text wrap, borders, backgrounds and columns.
(a) Border
(b) Table
(c) Frame
(d) Text
(vi) A ____ language is a portion of a DML involving for defining only.
(a) DDL
(b) DCL
(c) DML
(d) None of these
Q. 3 Answer any 5 out of the given 6 questions (1X5=5 marks)
(i) This is a type of hyperlink available in Hyperlink dialog box, which creates a new worksheet.
(a) New document
(b) New file
(c) New worksheet
(d) New data
(ii) The processed form of data is known as ____.
(a) value
(b) information
(c) knowledge
(d) None of these
(iii) ____ service can integrate both video calling and instant messaging abilities.
(a) Web conferencing
(b) Web page
(c) Web browser
(d) None of these
(iv) ____ is a list, usually found on a page before the start of a written work, of its chapter or section titles or brief descriptions with their commencing page numbers.
(a) Preface
(b) Table of contents
(c) Acknowledgements
(d) Page title
(v) For sorting through macro, the selected cell range must be ____.
(a) identical
(b) different
(c) Both (a) and (b)
(d) formatted
(vi) To add a new image to the Gallery, you can click on the ____ button.
(a) New image
(b) Add image
(c) New theme
(d) Add theme
Q. 4 Answer any 5 out of the given 6 questions (1X5=5 marks)
(i) A collection of web pages linked together in a random order is ____.
(a) a website
(b) a web server
(c) a search engine
(d) a web browser
(ii) The ____ alignment makes sure that none of the edges of text appear ragged.
(a) left
(b) right
(c) center
(d) justify
(iii) State whether True or False.
Duplicate values can be entered in column marked as primary key.
(a) True
(b) False
(iv) ____ are used for transmitting data across networks.
(a) Circuit switching
(b) Switching techniques
(c) Channel
(d) None of these
(v) A worksheet is a ____.
(a) collection of workbooks
(b) processing software
(c) combination of rows and columns
(d) None of the above
(vi) ____ controls how graphics are stacked upon each other or relative to the text.
(a) Arrangement
(b) Anchoring
(c) Alignment
(d) Wrapping
Q. 5 Answer any 5 out of the given 6 questions (1X5=5 marks)
(i) ____ function takes data from a series of worksheets or workbooks and summaries it into a single worksheet that you can update easily.
(a) Summation
(b) Data Format
(c) Data Consolidation
(d) Data Chart
(ii) Wireless broadband can be ____.
(a) mobile
(b) fixed
(c) Both (a) and (b)
(d) None of the above
(iii) The candidate key, which is not used as primary key is called ____ key.
(a) primary
(b) foreign
(c) alternate
(d) super
(iv) Scenarios are tool test for ____ questions.
(a) Auto
(b) Goal Seek
(c) What-if
(d) Drop Down
(v) A ____ can also be a quick way to take a list of people’s mailing addresses and generate labels or envelopes with the address for a different person on each label or envelope.
(a) data source
(b) database
(c) mail merge
(d) E-mail
(vi) ____ is the formation of networks.
(a) Server
(b) Networking
(c) Client
(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. What is the role of green skills in mitigating climate change?
7. Explain the term self-motivation.
8. Define multi-processing and multi-user operating system.
9. What do you mean by the term entrepreneur?
10. How can communication skills impact career success?
Answer any 4 out of the given 6 questions in 20–30 words each (2X4=8 marks)
11. Describe the significance of using templates in your documents.
12. State the use of Consolidating Data in a spreadsheet.
13. What is cell reference? Also, write the use a cell reference in one or several formula.
14. Explain the term table used in database.
15. Distinguish between switch and repeater.
16. What are the steps to apply first aid roller bandage to a wound?
Answer any 3 out of the given 5 questions in 50–80 words each (4X3=12 marks)
17. Harmanpreet had inserted an image in a word processor application. Now, she wants to know the use of the following terms. Tell her the correct answer.
(i) Alignment (ii) Anchoring
18. Samiksha wants to know the use of the following terms. Describe them for her.
(i) Goal Seek (ii) Subtotal (iiI) Scenario (iv) Solver
19. Consider the following table APPLICANTS
TABLE WILL BE ADDED SOON
(i) How many records and fields are there in the table APPLICANTS.
(ii) Write the SQL queries to:
(a) Display NAME, FEE, GENDER, JOINYEAR about the APPLICANTS, who have joined before 2010.
(b) Display the NAMES of all APPLICANTS in ascending order of their JOINYEAR.
(c) Display the details of APPLICANTS of female.
20. Prashant wants to know about Data Manipulation language commands. Solve the following queries for him.
(i) What is DML? (ii) Explain any three DML commands.
21. Chetanya wants to know the functions of the following terms. Tell him the correct answer.
(i) Modem (ii) Web page (iii) Wi-fi (iv) GPS
1 thought on “CBSE Class 10 IT Code 402 Sample Question Paper 2024 – SET 3 – Solution”