Information Technology – Solved Paper PYQs - CBSE Board 2024

CBSE Class 10 IT Solved Paper PYQs 2024 | Information Technology Solutions
By Pratap Sanjay Sir

Information Technology – Solved Paper PYQs - CBSE Board 2024

📥 Download Information Technology -PYQs 2024


CBSE Board 2024 — Complete solved paper (MCQs + Subjective answers)

SECTION A — Objective Type Questions

Q1. Attempt any 4
  1. (i) Dot (.)
  2. (ii) Visual
  3. (iii) Emotional Intelligence
  4. (iv) Self-Motivation
  5. (v) Wealthy
  6. (vi) 17
Q2. Attempt any 5
  1. (i) Styles
  2. (ii) Format
  3. (iii) Hold down Ctrl key while dragging
  4. (iv) Raster image
  5. (v) Two
  6. (vi) F4
Q3. Attempt any 5
  1. (i) Define name
  2. (ii) Track changes
  3. (iii) Solver
  4. (iv) Return
  5. (v) Edit → Compare document
  6. (vi) Conditional formatting
Q4. Attempt any 5
  1. (i) Delete
  2. (ii) Asc
  3. (iii) Boolean
  4. (iv) SELECT
  5. (v) LONGVARBINARY
  6. (vi) Varchar
Q5. Attempt any 5
  1. (i) Blog
  2. (ii) Evacuation drill
  3. (iii) Sticky keys
  4. (iv) Peer-to-Peer architecture
  5. (v) Cookies
  6. (vi) Digital Subscriber Line

SECTION B — Subjective Type Questions

Q6.
Cultural differences can be a barrier to communication because language, gestures, traditions, and values differ across regions. A message clear in one culture may be misinterpreted in another, causing misunderstanding and reduced effectiveness of communication.
Q7.
  1. Misconception 1: Entrepreneurs are born, not made — real fact: entrepreneurial skills can be learned through training and experience.
  2. Misconception 2: Entrepreneurship means instant success — real fact: success generally requires hard work, persistence, and learning from failure.
Q8.
Time management is significant because it helps prioritize tasks, reduce stress, improve productivity, and balance personal and professional responsibilities. Effective time management leads to achieving goals more efficiently.
Q9.
Spam mails are unsolicited bulk emails often used for advertising or fraud. They can contain malicious links. Recommended actions: mark as spam, delete them, and never click suspicious links or provide personal information.
Q10.
  1. Use solar panels to harness clean solar energy.
  2. Promote and implement wind energy solutions.
Q11.
Steps to group drawing objects in Writer:
  1. Select the objects to be grouped (click & drag or Shift+click to multi-select).
  2. Choose Format → Group → Group (or right‑click and select Group).
  3. The grouped objects behave as a single unit for moving/resizing/formatting.
Q12.
Consolidating data combines information from multiple sheets or ranges into one summary sheet. It helps summarize, compute totals, and compare data from different sources for analysis and reporting.
Q13.
LAN (Local Area Network) covers a small geographic area (office, school). WAN (Wide Area Network) spans large geographic areas (cities, countries) using telecommunication links and ISPs to connect multiple LANs.
Q14.
Two parts of a cell reference when referencing other sheets:
  1. Sheet name (for example: Sheet2)
  2. Cell address (for example: A1)
Example: Sheet2.A1
Q15.
Two benefits of creating relationships between tables:
  1. Reduces data redundancy by linking related information instead of duplicating it.
  2. Maintains referential integrity and consistent updates across related tables.
Q16.
Two basic fire safety rules:
  1. Keep emergency exits unobstructed and clearly marked.
  2. Ensure fire extinguishers are accessible and staff are trained to use them.
Q17. (Mail Merge)
Concept: Mail Merge combines a fixed document template (e.g., letter) with a data source (names/addresses) to generate multiple personalized documents automatically.
Benefits:
  1. Saves time by producing many personalized documents at once.
  2. Reduces manual errors and ensures consistency in formatting.
Q18.
Four types of hyperlinks in spreadsheets:
  1. Web hyperlink — links to an external website (URL).
  2. Email hyperlink — opens the default email client with a prefilled address.
  3. Document hyperlink — links to another document or file.
  4. Place in document — links to a specific cell or sheet inside the same workbook.
Q19.
Four guidelines for strong passwords:
  1. Use a mix of uppercase, lowercase, digits and special characters.
  2. Avoid personal information (names, birthdays) and common words.
  3. Prefer longer passwords (8–12+ characters) or passphrases.
  4. Change passwords periodically and do not reuse them across sites.
Q20.
Forms: User interfaces for entering, viewing and editing records easily.
Reports: Structured, printable outputs that summarize and present database data for analysis.
Q21. SQL Queries
-- (a) Display names of all products whose category is 'DOMESTIC'
SELECT PNAME FROM Product WHERE CATEGORY = 'DOMESTIC';

-- (b) Display product name and price whose quantity is less than 50
SELECT PNAME, PRICE FROM Product WHERE QUANTITY < 50;

-- (c) Display price and quantity of Laptop
SELECT PRICE, QUANTITY FROM Product WHERE PNAME = 'LAPTOP';

-- (d) Display name and quantity of those products whose price is above 5000
SELECT PNAME, QUANTITY FROM Product WHERE PRICE > 5000;
🔔 Subscribe to My Channel