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.
INFORMATION TECHNOLOGY (SUBJECT CODE – 402)
Pre Board Sample Question Paper for Class X (Session 2023-24) – SET 2 by LearnCSE Click here for 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) Neha is a brilliant student. She studies well, has joined many extra curricular activity groups, learns swimming etc. You can say that she has too much on her place. What type of stress she might suffer from?
a) Survival stress
b) Internal stress
c) Fatigue related stress
d) Environmental stress
(ii) Mohita never resends others because she is pretty clear about her ambitions, emotions, abilities, interest etc. She also makes conscious efforts to learn more about her on beliefs, likes and dislikes. This is called ____.
a) stress
b) self-awareness
c) self-motivation
d) self-regulation
(iii) Jacqueline wants to replace some data in her world document. What shortcut keys could she use?
a) Ctrl + F
b) Ctrl + V
c) Ctrl + Z
d) Ctrl + H
(iv) Garvit wants to have his own business and become an entrepreneur. His father won him about one disadvantage of this career. What it might be?
a) Independence
b) Ambition fufillment
c) Uncertainty
d) None of the above
(v) How would you describe feedback that helps the learner understand what they need to improve?
a) Descriptive
b) Specific
c) General
d) Sign
(vi) Energy demand is developing countries will increase to ____ times the current levels by 2030.
a) four
b) five
c) six
d) eight
Q. 2 Answer any 5 out of the given 6 questions (1X5=5 marks)
(i) A ____ is a model that you use to create other documents.
a) template
b) document
c) design
d) copy paste
(ii) In a document, ____ is used to apply a style to many different areas quickly without having to go back to the styles and formatting window and double click every time.
a) Fill format mode
b) Formatting window
c) Painter mode
d) Text mapping
(iii) In a document, ____ refers to the vertical or horizontal placement of a graphic in relation to the chosen anchor point.
a) arrangement
b) anchoring
c) alignment
d) text wrapping
(iv) Tanish explained his class that to apply and existing style, except for ____, position the insertion point in the paragraph, frame or page and then double click on the name of the style in one of these lists.
a) Windows style
b) Character style
c) Paragraph style
d) Style style
(v) Symbol option is available under ____ group in the insert tab.
a) Symbols
b) Font
c) Header
d) Footer
(vi) After selecting the text you need to click the ____ in the font group to make the font size larger than the current font size.
a) Text size
b) Font size
c) Font type
d) Capital letters
Q. 3 Answer any 5 out of the given 6 questions (1X5=5 marks)
(i) Arguments passed to a macro from calci are always ____.
a) strings
b) references
c) numbers
d) values
(ii) ____ function takes data from a series of worksheets or workbooks and summarizes it into a single worksheet that you can update easily.
a) Summation
b) Data consolidation
c) Data format
d) Data chart
(iii) Autosum option is available in
a) Home tab
b) View tab
c) Insert tab
d) Layout tab
(iv) Which of the following component provides additional information in the chart?
a) Legend
b) Gridlines
c) Data label
d) Plot area
(v) Which function cannot be performed through Subtotal in a spreadsheet?
a) Sum
b) Product
c) Average
d) Percentage
(vi) For enter the current time in Calc, you need to press
a) Ctrl + Allt + ;
b) Shift + Alt + ;
c) Ctrl + shift + ;
d) None of these
Q. 4 Answer any 5 out of the given 6 questions (1X5=5 marks)
(i) The ____ evolved since the 1960s to ease increasing difficulties in designing, building and maintaining complex information systems.
a) Knowledge concept
b) Formula concept
c) Database concept
d) Forms concept
(ii) Out of the following, which one is the most appropriate data field in context of employee table, if only one of these is required.
a) Age in years
b) Date of birth
c) Age in days
d) Age in months
(iii) Saloni wants to store a huge amount of information about her zone in a database. Her friend Mohita explain to her about various benefits of storing data in RDBMS. It helps in preventing/controlling duplication of data. Which of the following terms is used to refer to duplication data?
a) Data sharing
b) Data privacy
c) Data integrity
d) Data redundancy
(iv) For what, memo data type is used?
a) To add table
b) To store objects created in other programs
c) For long text entries
d) For short text entries
(v) Attribute is a unique identifier for each tuple. It is identified in the form of
a) rows
b) columns
c) tree
d) query
(vi) Which of the following command is used to retrieve data from a database?
a) Select
b) Copy
c) Open
d) Retrieve
Q. 5 Answer any 5 out of the given 6 questions (1X5=5 marks)
(i) Which of the following is the first network?
a) ARPANET
b) Internet
c) NSFnet
d) NET
(ii) Which of these services will not be provided by the typical Internet Service Provider (ISP)?
a) An email address
b) Modem
c) A connection to the internet
d) Technical help
(iii) ____ is an example of text-based browser which provides access to the Internet in the text-only mode.
a) Mozilla Firefox
b) Lynx
c) Internet Explorer
d) All of these
(iv) John connects to the internet at home using a laptop computer with a wireless connection. John is going to change to a desktop computer using a 1 Gbps internet cable connection. Which of these should be the result of making the changes?
a) Increased portability and decreased speed
b) Decreased portability and increased speed
c) Increased portability and increased speed
d) Decreased portability and decreased speed
(v) Which of the following websites is used for booking train tickets?
a) Nykaa
b) IRCTC
c) RedBus
d) Myntra
(vi) Qumana is an offline blog editor which is used for ____ operating system(s).
a) Windows
b) Mac
c) Both a and b
d) None of the above
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. How can one adapt their communication style to different audiences?
7. It is important to be in charge of your own self and not to be charge of your own self and not be dependent on anyone else in life. List any two reasons for which self-regulation is a must.
8. General precautions should you take while cleaning the computer/components?
9. Can green skills help in achieving the Sustainable Development Goals (SDGs)?
10. Write about any two myths and their truth regarding entrepreneurship.
Answer any 4 out of the given 6 questions in 20–30 words each (2X4=8 marks)
11. Differentiate between the Save and Save As option.
12. What makes a workbook different from a worksheet?
13. What is the use of cell reference?
14. Describe the significance of primary key in a database.
15. Elucidate the following terms:
(i) PAN (ii) WIMAX
16. Why is it important to secure internet? What are the used of it?
Answer any 3 out of the given 5 questions in 50–80 words each (4X3=12 marks)
17. How to resize an image?
18. Elucidate the following with examples:
(i) Goal seek (ii) Scenario
19. Write SQL queries for the questions from (a) to (d) on the basis of table Class.
(a) Select all the non-medical stream students from the class table.
(b) List the names that have grid a stored by stipend.
(c) Arrange the records of class name wise.
(d) List records whose grade is B or C.
20. Discuss the components of a database.
21. Garvit wants to know the functions of the following terms. Tell him the correct answer:
(i) Modem (ii) Webpage (iii) Wi-Fi (iv) GPS