CBSE Class 10 · Information Technology · board exam 2027
CBSE Class 10 Information Technology Question Paper 2023
The board’s 2023 question paper, set 89 — all 46 questions as printed; 27 objective answers from the board’s own key; full model answers for 3 written questions, how the answer begins for 13 more. Each question names its chapter, where that chapter’s most-asked questions are.
Full marks 50 · Time 2 h
Section A · Written questions (30)
________ refers to focussing human efforts for maintaining a healthy body and mind, capable of withstanding stressful situations.
- (A) Artificial Intelligence
- (B) Stress management ✓
- (C) Motivation
- (D) Emotional intelligence
Answer (the board’s key): (B)
Which of the following is not the benefit of stress management ?
- (A) Boosts immunity
- (B) Reduces efficiency ✓
- (C) Improves mood
- (D) Prevents behavioural problems
Answer (the board’s key): (B)
________ are computer programs that can harm data and software or steal information stored in the computer.
- (A) Spam
- (B) Virus ✓
- (C) Junk mail
- (D) BIOS
Answer (the board’s key): (B)
________ is the horizontal bar present at the bottom part of the Windows 7 desktop.
- (A) Status bar
- (B) Menu bar
- (C) Task bar ✓
- (D) Recycle bin
Answer (the board’s key): (C)
State whether the following statement is a myth or a fact: "Entrepreneurs are born in a special way."
Medha Ma’am
Ask Medha’s AI teacher
Model answer · entrepreneurs: myth or fact
- 1.This statement is a myth. Entrepreneurship is a learnable process, and entrepreneurs are made, not born.1 mark
- Begin by clearly writing the word 'myth'.
- Use the exact phrase 'learnable process' and the idea 'made, not born' to earn full credit.
Marks split from a structure derived from past papers (checked twice); not CBSE’s official scheme
Which of the following statements about an entrepreneur is false?
- (A) They create need and demand.
- (B) They provide raw material.
- (C) They do not create employment. ✓
- (D) They help society by supporting infrastructure.
Answer (the board’s key): (C)
________ controls all aspects of a paragraph's appearance, such as text alignment, tab stops, line spacing, and borders, and can include character formatting.
- (A) Page Style
- (B) Character Style
- (C) Cell Style
- (D) Paragraph Style ✓
Answer (the board’s key): (D)
How many levels of headings does Open Office Writer evaluate to build the Table of contents ?
- (A) 8
- (B) 9
- (C) 10 ✓
- (D) 12
Answer (the board’s key): (C)
Reema has created a pamphlet on 'Tour to West India'. She has inserted many images to make it more presentable but the size of images is occupying a lot of space. Her friend has suggested her to reduce the size of images. Which of the following options will help her in doing the task without losing any content of the image ?
- (A) Recolor
- (B) Docking
- (C) Resize ✓
- (D) Rotate
Answer (the board’s key): (C)
Which of the following graphic filters is used to increase the contrast of an image on a document?
- (A) Smooth
- (B) Sharpen ✓
- (C) Remove Noise
- (D) Invert
Answer (the board’s key): (B)
Which of the following is not used to create a mail merge document?
- (A) Spreadsheet
- (B) Document
- (C) Paint ✓
- (D) Database
Answer (the board’s key): (C)
Which mode is used in Writer to apply a style instantly to different areas of a document without going back to the Styles and Formatting window?
Medha Ma’am
Ask Medha’s AI teacher
Model answer · Fill Format mode, Writer styles
- 1.Fill Format Mode is used in Writer to apply a style instantly to different areas of a document without going back to the Styles and Formatting window. Fill Format is used to style scattered – Pages, Frames, Tables, Lists, Paragraphs or Characters in a document.1 mark
- Write the exact term 'Fill Format Mode' (or 'Fill Format') as the answer.
- Mention that it is used to style scattered Pages, Frames, Tables, Lists, Paragraphs or Characters.
Marks split from a structure derived from past papers (checked twice); not CBSE’s official scheme
A colored border, with ____, appears around a cell where changes are made in a shared worksheet.
- (A) a dot in the upper left-hand corner ✓
- (B) a dot in the lower left-hand corner
- (C) a cross in the upper left-hand corner
- (D) a cross in the upper right-hand corner
Answer (the board’s key): (A)
____ feature adds data arranged in a group of cells in Calc, with labels for columns and/or rows.
- (A) Average
- (B) Subtotal ✓
- (C) Goal seek
- (D) Solver
Answer (the board’s key): (B)
A ____ refers to a cell or a range of cells on a worksheet whose data values can be used in a formula.
- (A) sheet
- (B) cell
- (C) cell reference ✓
- (D) cell data
Answer (the board’s key): (C)
____ feature of Calc is used to test ‘what-if’ questions.
- (A) Solver
- (B) Goal seek
- (C) Scenario ✓
- (D) Styles
Answer (the board’s key): (C)
Macros are used especially to ____ repeatedly in the same form.
- (A) repeat the task ✓
- (B) reject the task
- (C) report the task
- (D) comment on the task
Answer (the board’s key): (A)
The ____ feature of Calc is used to find out which data was changed, when it was changed, who made the change and in which cell the change was made.
- (A) Record Changes ✓
- (B) Edit Record
- (C) Change Record
- (D) Macro
Answer (the board’s key): (A)
Which one of the following is not an example of DBMS ?
- (A) PostgresSQL
- (B) SQLite
- (C) FoxPro
- (D) Impress ✓
Answer (the board’s key): (D)
A ____ is an interface in a user specified layout that lets users to view, enter, and change data directly in database objects such as tables.
- (A) frame
- (B) form ✓
- (C) relation
- (D) report
Answer (the board’s key): (B)
Which of the following is expanded form of SQL ?
- (A) Systematic Query Language
- (B) Structured Query Language ✓
- (C) Software Query Language
- (D) Structural Query Language
Answer (the board’s key): (B)
____ is usually suitable for less amount of data. (Relational/Flat file)
Medha Ma’am
Ask Medha’s AI teacher
Model answer · flat file vs relational database
- 1.Flat file is usually suitable for less amount of data.1 mark
- Write the exact term 'Flat file' as the answer.
- Do not add extra explanation since this is a very short, 1 mark answer.
Marks split from a structure derived from past papers (checked twice); not CBSE’s official scheme
Binary data types in a database can be using for storing ____.
- (A) photos, music files, etc. ✓
- (B) integer values
- (C) only image files
- (D) only video files
Answer (the board’s key): (A)
____ clause can be used with the SELECT statement in SQL to specify which rows to retrieve from the table.
- (A) WHERE ✓
- (B) GROUP
- (C) SAME
- (D) SIMILAR
Answer (the board’s key): (A)
______ is an accessibility function which is designed for people who have vision impairment or cognitive disabilities.
- (A) Filter Keys
- (B) Sound Key
- (C) Toggle Keys ✓
- (D) Sticky Keys
Answer (the board’s key): (C)
Networks in which certain computers have special dedicated tasks, providing services to other computers (in the network) are called ______ networks.
- (A) hierarchical
- (B) dedicated server
- (C) peer to peer
- (D) client server ✓
Answer (the board’s key): (D)
______ provides Internet access by transmitting digital data over wires of a local telephone network.
- (A) HSDPA
- (B) P2P
- (C) DSL ✓
- (D) Modem
Answer (the board’s key): (C)
A ______ is an unplanned event that may happen all of a sudden and may lead to unwanted or unprecedented results/outcomes.
- (A) emergency
- (B) hazard
- (C) accident ✓
- (D) illness
Answer (the board’s key): (C)
A ______ worker will always perform to the best to his ability.
- (A) fast working
- (B) highly educated
- (C) happy and healthy ✓
- (D) stressed
Answer (the board’s key): (C)
______ is the process of emptying a place in case of an emergency, disaster.
- (A) Emergency
- (B) Accident
- (C) Drill
- (D) Evacuation ✓
Answer (the board’s key): (D)
Section B · Written questions (16)
What is self-awareness ? Also give any two benefits of self-awareness.
How the model answer begins
1. Self-awareness means that you can identify your strengths and weaknesses. It means knowing yourself: who you are, what you like or dislike, and what your beliefs and opinions are. Being self-aware means knowing your…
The full answer from Medha Ma’am →Give one example each of following stress causal agents for students : (a) Mental (b) Social
How the model answer begins
1. (a) Mental stressor: A student may be unable to handle examination grades and submission deadlines. For example, the exams are very close, but the student feels unprepared and worries about not passing.
The full answer from Medha Ma’am →Differentiate between files and folders.
How the model answer begins
1. Files and folders differ as follows: 1. File: all information stored in a computer is kept in files, and different types of files store different types of information; Folder: a folder is a location where a group of…
The full answer from Medha Ma’am →Give any two qualities of a successful entrepreneur.
How the model answer begins
1. Two qualities of a successful entrepreneur are: (i) Confident: A successful entrepreneur is confident. He or she believes in himself or herself and in his or her abilities, and takes business decisions without fear.…
The full answer from Medha Ma’am →Give any two promotional functions of an entrepreneur.
How the model answer begins
1. Two functions of an entrepreneur are making decisions and creating a new method, idea or product. (i) Making decisions: An entrepreneur makes decisions every day. This includes what to produce or sell, how much to sell…
The full answer from Medha Ma’am →Differentiate between Keep scale and Keep image size options while cropping an image in a document.
How the model answer begins
1. Keep scale: while cropping, the scale of the image stays the same, so the size of the image on the page changes. The cut part is simply removed and the image becomes smaller. Keep image size: while cropping, the size of…
The full answer from Medha Ma’am →Give any two characteristics of a template in Open Office Writer.
Why do we need to merge worksheets ?
What is a Primary Key ? How is it different from foreign key ?
How the model answer begins
1. A primary key is a field that uniquely identifies a row in a table. No two rows can have the same value for it, and it cannot be left blank. Difference – Primary key: uniquely identifies each record of its own table;…
The full answer from Medha Ma’am →Expand and explain the term WAN.
(a) Identify the following network / Internet connectivities as wired or wireless : (i) Dial-up (ii) WiMax (b) Give any one feature of Instant messaging.
How the model answer begins
1. (a) (i) Dial-up: wired. It connects the computer to the Internet through a telephone line and a modem. (ii) WiMax: wireless. It connects to the Internet through radio signals sent from a tower, with no cable needed.
The full answer from Medha Ma’am →Explain the following terms with respect to positioning the graphics in a document : (a) Arrangement (b) Text Wrapping
How the model answer begins
1. (a) Arrangement: In overlapping objects, arrangement determines the position of the current drawing with respect to other drawings or text. The arrangement tools are on the Drawing Object Properties toolbar. There are…
The full answer from Medha Ma’am →Distinguish between the following with respect to spreadsheets : (a) Relative and Absolute hyperlink. (b) Internet hyperlink and Document hyperlink.
How the model answer begins
1. A relative hyperlink stores the location with respect to the current location. For example, Admin\Downloads\try.ods is a relative hyperlink as it is dependent on the current location and thus the folder admin is…
The full answer from Medha Ma’am →Explain any four data types of DBMS.
(a) Structure of a table "Orders" is given below. Suggest suitable data type of each column Table : Orders | Order_ID | Order_date | Customer_ID | Amount | | --- | --- | --- | --- | | A_101 | 12/12/19 | C3445 | 1200.00 | | A_202 | 11/09/19 | C1245 | 3456.00 | | A_402 | 09/07/19 | C2121 | 2312.00 | (b) Consider the following table "Books". | BkID | BkName | Author | Qty | Price | | --- | --- | --- | --- | --- | | B_101 | Learning with Fun | Jacobins | 5 | 355.00 | | B_103 | How I Live Now | Meg Rosoff | 4 | 400.00 | | B_104 | I Capture the Castle | Dodie Smith | 5 | 520.00 | | B_106 | Mortal Engines | Philip Reeve | 4 | 260.00 | | B_110 | The Kite Rider | Geraldine McCaughrean | 3 | 270.00 | Write SQL queries to (i) Display data of all books whose quantity is more than 3. (ii) Display total amount of all books whose price is less than 500. (Hint : amount = Qty x Price) For visually impaired candidates. Explain various relationships that can be created between two tables in a database.
How the model answer begins
1. (a) Suitable data types for the columns of the table "Orders": Order_ID – Varchar, because values such as A_101 mix letters, digits and the underscore, so they are stored as text. Order_date – Date, because values such…
The full answer from Medha Ma’am →(a) Give two best practices for internet safety. (b) Give any two Falls and Slips Safety rules.
How the model answer begins
1. (a) Two best practices for internet safety are: 1. Use a strong password that others cannot guess, and never share it with anyone. Change it from time to time so that no one else can get into your account. 2. Do not…
The full answer from Medha Ma’am →
The same preparation, with Medha Ma’am — on your phone
Every question of every chapter with its model answer, practice questions in the board’s own shapes, 45 minutes of class a day, written answers marked, a test every Sunday and a WhatsApp report to parents.
Medha Ma’am is an AI teacher, not a live tutor. Every answer is checked twice; a person takes responsibility.