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-2024) – SET 2 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) 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) Window 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?
Answer: Adapting communication style involves understanding the audience’s need, preferences and cultural background. It requires using appropriate language, tone and examples to ensure the message is understood and well received.
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.
Answer: Self-regulation is important in life due to the following reasons:
(i) self-regulation allows you to keep a tab on your own emotions.
(ii) self-regulation enables to develop the idea about ‘what is appropriate behaviour’ and ‘what is inappropriate behaviour’ in a given social condition.
8. General precautions should you take while cleaning the computer/components?
Answer: (i) Always power of the computer system before cleaning.
(ii) Never spray cleaning fluid directly on the component of the computer. First spray the liquid on the cloth and then wipe the computer components.
(iii) Do not allow the cleaning liquid to drip near the circuit board.
(iv) Preferably use anti-static wrist band which helps to prevent building up of static electricity near electronic device.
9. Can green skills help in achieving the Sustainable Development Goals (SDGs)?
Answer: Yes, green skills are essential for achieving the SDGs, and they contribute to goals related to clean energy, sustainable cities, responsible consumption and production, climate action and life below water and on land.
10. Write about any two myths and their truth regarding entrepreneurship.
Answer: (i) The misconception is that every business idea needs to be unique or special.
In reality, many successful businesses thrive by offering existing products or services with unique twists or better execution.
(ii) The misconception we have is that a person needs a lot of money to start a business.
Contrary to this notion, many successful ventures have started small and grown gradually, emphasizing resourcefulness and effective financial management over large initial investments.
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.
Answer: ‘Save’ means the file get saved under its current name, in whatever folder is was saved before or in the default folder of that computer, whereas ‘Save As’ gives you the opportunity to save the file under a different name and in another folder. ‘Save As’ allows you to name the updated version with a new name and at the same time preserving the old version.
12. What makes a workbook different from a worksheet?
Answer: Workbook: A workbook is an excel file with one or more worksheets. It would be the entire binder with everything in it.
Worksheet: A worksheet is a single sheet of data. It would be like one section in that binder.
13. What is the use of cell reference?
Answer: In order to avoid writing the data again and again for calculating purpose, cell reference is used. When you write any formula, for specific function, you need to direct excel and specific location of that data. This location is referred as, cell reference. So, every time a new value added to the cell, the cell will calculate according to the reference cell formula.
14. Describe the significance of primary key in a database.
Answer: Primary key is used to uniquely identify the record in a database. It can be a column or a set of columns in the table. Main features of primary key are as follows:
(i) It must contain a unique value for each record of table.
(ii) It does not contain null values.
15. Elucidate the following terms:
(i) PAN (ii) WIMAX
Answer: PAN It stands for Personal Area Network. It is a computer network used for communication among computer and different technology and devices close to it.
WIMAX It stands for world wide Introperability for Microwave Access. It is a wireless transmission of data using a variety of transmission modes.
16. Why is it important to secure internet? What are the used of it?
Answer: Your passwords are the most common way to prove your identity when using website, email accounts and your computer itself. The use of strong password is there for essential in order to protect your security in identity.
Answer any 3 out of the given 5 questions in 50–80 words each (4X3=12 marks)
17. How to resize an image?
Answer: Resizing a drawing object is done same as image resizing. To resize the drawing object, follow The below steps:
Step 1: Click the object to show the green resizing corner handles.
Step 2: Position the pointer over one of the corner handle.
Step 3: Click and Drag slanting to resize the object.
Step 4: Release the mouse button when satisfied with the new size.
18. Elucidate the following with examples:
(i) Goal seek (ii) Scenario
Answer: (i) Click here to learn about Goal Seek
(ii) Click here to learn about 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.
Answer: SELECT * from Class WHERE Subject = 'Non-Medical';
(b) List the names that have grid a stored by stipend.
Answer: SELECT Name from Class WHERE Grade = 'A' ORDER BY Stipend;
(c) Arrange the records of class name wise.
Answer: SELECT * from Class WHERE ORDER BY Name;
(d) List records whose grade is B or C.
Answer: SELECT * from Class WHERE Grade = 'A' OR Grade = 'C';
20. Discuss the components of a database.
Answer: Database consists of several components. Each component plays an important role in the database system environment. The major components of database are as follows:
Data is a row numbers, characters or facts represented by value. Most of the organisations generate, store and process large amount of data. The data acts as a bridge between the hardware and the software. Data maybe of different types such as user data.
Software is a set of programs that lies between the Stored data and the users of the database. It is used to control and manage the over all computerized database. It uses different types of software such as MySQL, Oracle etc.
Hardware is the physical aspect of computer telecommunication and database, which consists of the secondary storage devices such as magnetic discs, optical discs etc., on which data is stored.
Users who can access or retrieve the data on demand using the application and the interfaces provided by DBMS.
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
Answer: (i) Modem: MODEM stands for MOdulation DEModulation. It is a device that connects your computer to the internet. It changes digital information from your computer into signals that can travel over telephone or cable lines, allowing you to browse the web.
(ii) Webpage: A webpage is like a digital page on the internet. It shows information when you open a website. You can see text, pictures, and links on a webpage, making it a key part of online browsing.
(iii) Wi-Fi: It stands for Wireless Fedelity. It is a technology that lets you connect to the internet without using cables. It allows devices like smartphones and laptops to access the internet wirelessly, providing flexibility and convenience for online activities.
(iv) GPS: GPS, or Global Positioning System, helps you find your location on Earth. It uses signals from satellites to determine where you are. GPS is used in navigation systems to guide you on maps and find directions.
2 thoughts on “CBSE Class 10 IT Code 402 Sample Question Paper 2024 – SET 2 – Solution”