Information Technology – Solved Paper PYQs - CBSE Board 2023

CBSE Class 10 Information Technology – Solved PYQs 2023
By Pratap Sanjay Sir

Information Technology – Solved Paper PYQs - CBSE Board 2023

📥 Download Information Technology -PYQs 2023


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

SECTION – A

Objective Type Questions – Detailed Solutions

  1. Q1. Employability Skills (Attempt any 4 out of 6)
    1. (i) Maintaining healthy body and mind; Stressful situations:
      Refers to: (b) Stress management
      Explanation: Stress management involves methods and measures to keep body and mind healthy and resilient during stressful situations.
    2. (ii) Which is NOT a benefit of stress management?
      Correct Answer: (b) Reduces efficiency
      Explanation: Stress management improves mood, boosts immunity, and prevents behavioral problems, but does not reduce efficiency; instead, it enhances it.
    3. (iii) Programs that damage data or steal information:
      Correct Answer: (b) Viruses
      Explanation: Computer viruses are programs that harm data and software or steal saved information.
    4. (iv) Horizontal bar at bottom of Windows 7 desktop:
      Correct Answer: (c) Task Bar
      Explanation: The Task Bar at bottom shows running applications and provides quick access.
    5. (v) Statement "Entrepreneurs are born a certain way":
      Correct Answer: Myth
      Explanation: Entrepreneurship is learned and developed, not just inherent at birth.
    6. (vi) Which statement is NOT true for entrepreneurs?
      Correct Answer: (c) They do not create jobs.
      Explanation: Entrepreneurs create jobs, besides meeting needs/demands and supporting infrastructure.
  2. Q2. (Answer any 5 out of 6)
    1. (i) Controls all paragraph aspects:
      Correct Answer: (d) Paragraph Style
      Explanation: Paragraph Style manages alignment, spacing, borders, and character formatting.
    2. (ii) Levels of headings for Table of Contents in Writer:
      Correct Answer: (b) 9
      Explanation: OpenOffice Writer supports up to 9 heading levels for tables of contents.
    3. (iii) Resize images without losing content:
      Correct Answer: (c) Resize
      Explanation: Resize reduces image size but retains all content. Recolor/Rotate change color/orientation.
    4. (iv) Graphic filter to increase contrast:
      Correct Answer: (b) Sharpen
      Explanation: Sharpen filter enhances contrast and makes edges more distinct.
    5. (v) Not used in mail-merge document creation:
      Correct Answer: (c) Paint
      Explanation: Mail-merge uses Spreadsheet, Document, Database, but not Paint.
    6. (vi) Fast style application mode in Writer:
      Correct Answer: Fill Format Mode
      Explanation: Fill Format Mode lets you apply styles quickly to various parts of document.
  3. Q3. Calc/Spreadsheet (Answer any 5 out of 6)
    1. (i) Shared worksheet cell border indicator:
      Correct Answer: (a) a dot in the upper left-hand corner
      Explanation: Colored border with dot in upper left appears for edited cell in shared worksheet.
    2. (ii) Feature for grouped data with labels:
      Correct Answer: (b) Subtotal
      Explanation: Subtotal adds and organizes summary data by groups.
    3. (iii) Cell or range reference in worksheet/formula:
      Correct Answer: (c) Cell reference
      Explanation: Cell reference lets formula use values from specific cells.
    4. (iv) 'What-if' question feature in Calc:
      Correct Answer: (c) Scenario
      Explanation: Scenario feature helps compare different possible outcomes based on changes.
    5. (v) Use of Macros:
      Correct Answer: (a) repeat a task
      Explanation: Macros automate repetitive tasks.
    6. (vi) Tracks data changes in Calc:
      Correct Answer: (a) Record Changes
      Explanation: Record Changes feature logs what, when, and who changed data in spreadsheet.
  4. Q4. Database (Answer any 5 out of 6)
    1. (i) Not a DBMS example:
      Correct Answer: (d) Impress
      Explanation: Impress is for presentations, not for databases.
    2. (ii) Interface to view/enter/change data in tables:
      Correct Answer: (b) Form
      Explanation: Forms let users interact with database tables.
    3. (iii) Expansion of SQL:
      Correct Answer: (b) Structured Query Language
      Explanation: SQL stands for Structured Query Language.
    4. (iv) Suitable for less data:
      Correct Answer: Flat file
      Explanation: Flat files are better for small, simple datasets.
    5. (v) Binary data type storage:
      Correct Answer: (a) photos, music files, etc.
      Explanation: Binary types store non-text data like images/music.
    6. (vi) Clause to specify row selection in SQL SELECT:
      Correct Answer: (a) WHERE
      Explanation: WHERE clause filters row retrieval in SELECT.
  5. Q5. (Answer any 5 out of 6)
    1. (i) Accessibility function for impaired users:
      Correct Answer: (a) Filter Keys
      Explanation: Filter Keys assist users with vision/cognitive impairments in keyboard input.
    2. (ii) Networks with dedicated service computers:
      Correct Answer: (d) client server
      Explanation: Client-server networks allocate dedicated tasks to certain computers.
    3. (iii) Provides internet via telephone wires:
      Correct Answer: (c) DSL
      Explanation: Digital Subscriber Line (DSL) uses phone wires for internet.
    4. (iv) Unplanned event with unwanted results:
      Correct Answer: (c) accident
      Explanation: Accident is a sudden, unplanned event with undesirable consequences.
    5. (v) Worker who performs best:
      Correct Answer: (c) happy and healthy
      Explanation: Happy and healthy workers tend to perform better.
    6. (vi) Emptying a place during emergency/disaster:
      Correct Answer: (d) Evacuation
      Explanation: Evacuation is the process of vacating for safety.

SECTION – B

Subjective Type Questions – Detailed Solutions

  1. Q6. What is self-awareness? Two benefits.

    Answer: Self-awareness refers to the ability to recognize and understand one’s emotions, strengths, weaknesses, values, and drivers.
    Two benefits: Better decision-making and improved relationships, as self-aware people manage reactions and communicate effectively.

  2. Q7. Examples of stress causal agents for students.

    (a) Mental: Examination pressure or overload of study work.
    (b) Social: Peer pressure or difficulty in socializing with classmates.

  3. Q8. Difference between files and folders.

    Files are containers for storing data, such as documents or images. Folders are organizational structures that hold multiple files or other folders, helping arrange files systematically.

  4. Q9. Two qualities of a successful entrepreneur.

    • Innovative thinking: Ability to develop unique solutions and products.
    • Risk-taking ability: Readiness to invest time and resources despite uncertainty.

  5. Q10. Two promotional functions of an entrepreneur.

    • Advertising: Enhance visibility and appeal of products/services.
    • Sales promotion: Encourage customer purchases through discounts/offers.

  6. Q11. Difference between Keep scale and Keep image size while cropping

    Keep scale: maintains the scaling of the image after cropping, potentially resizing the image to fit original dimensions.
    Keep image size: retains the cropped part at its natural pixel size, which may change the overall image dimension.

  7. Q12. Two characteristics of a template in Open Office Writer.

    • Predefined formatting: Templates offer consistent design and layout for documents.
    • Reusable: Templates can be used repeatedly to create documents with similar structure.

  8. Q13. Why do we need to merge worksheets?

    We need to merge worksheets to consolidate information from multiple sheets for easy analysis, reporting, or summary, eliminating redundancy.

  9. Q14. What is Primary Key? Difference from Foreign Key.

    Primary Key: Uniquely identifies each record in a table and cannot be NULL.
    Foreign Key: Creates a link between tables and refers to Primary Key in another table, allowing relational connections.

  10. Q15. Expand and explain WAN.

    WAN (Wide Area Network): A network that covers a large geographical area, connecting computers and devices across cities, regions, or countries, using leased telecommunication lines.

  11. Q16.

    (a) Identify as wired or wireless:
    (i) Dial-up: Wired
    (ii) WiMax: Wireless
    (b) One feature of Instant messaging:
    Instant messaging enables real-time text communication and multimedia sharing between users online.

  12. Q17. Graphics Positioning in Document

    (a) Arrangement: Organizing images in specific positions (front, back, align) relative to text and other elements.
    (b) Text Wrapping: Deciding how text flows around an image, e.g., wrap, break, or appear above/below graphics.

  13. Q18. Distinction in spreadsheets

    (a) Relative vs Absolute Hyperlink:
    Relative hyperlink changes based on file location; absolute hyperlink remains fixed no matter where the file is moved.
    (b) Internet Hyperlink vs Document Hyperlink:
    Internet hyperlinks open web pages; document hyperlinks navigate within or to another document.

  14. Q19. Four DBMS Data Types

    • Integer: Stores whole numbers.
    • Varchar: Variable-length text.
    • Date: Stores dates.
    • Binary: Stores non-text data like images or files.

  15. Q20.

    (a) Orders Table Data Type:

    ColumnSuitable Data Type
    Order_IDVarchar/Text
    Order_dateDate
    Customer_IDVarchar/Text
    AmountDecimal/Float

    (b) Books Table SQL Queries:
    (i) Data of all books with quantity > 3:
    SELECT * FROM Books WHERE Qty > 3;
    (ii) Total amount for books price < 500:
    SELECT SUM(Qty * Price) AS Total_Amount FROM Books WHERE Price < 500;

    Database Relationships: Tables can be related as One-to-One, One-to-Many, or Many-to-Many depending on how records in one table map to records in another.

  16. Q21.

    (a) Two best practices for Internet safety:
    • Use strong, unique passwords.
    • Update software and antivirus regularly.
    (b) Two Falls and Slips Safety rules:
    • Keep floors dry and free of obstacles.
    • Wear appropriate non-slip footwear in work areas.

🔔 Subscribe to My Channel