Sample paper · Class 10 · CBSE Information Technology (402)

Information Technology (402) · Sample Paper 4

Theory paper (50 marks) on the CBSE board pattern — employability skills, Writer and Calc (advanced), Base and web security, a fresh set of questions.

33 questions · 50 marks · 120 minutes

Timed, marked on submit · free with an account

General instructions

  1. This theory paper carries 50 marks; the practical exam (50 marks) is assessed separately.
  2. Section A — Q1 to Q24: objective questions, 1 mark each.
  3. Section B — Q25 to Q29: short answer questions, 2 marks each. Answer in 20–30 words.
  4. Section C — Q30 to Q33: long answer questions, 4 marks each. Answer in 30–50 words.
  5. Internal choice is given in Q25, Q27, Q30 and Q31. Answer only one alternative.

Section A · Objective

Questions 1–24 carry 1 mark each. Choose the correct option.

  1. Question 11 mark

    Which of these is a pronoun?

    1. A.run
    2. B.they
    3. C.happy
    4. D.quickly
  2. Question 21 mark

    A sentence that gives an order is

    1. A.declarative
    2. B.imperative
    3. C.interrogative
    4. D.exclamatory
  3. Question 31 mark

    Which is a sign of positive self-esteem?

    1. A.avoiding challenges
    2. B.accepting compliments graciously
    3. C.blaming others
    4. D.fear of failure
  4. Question 41 mark

    Doing the most important task first is called

    1. A.procrastination
    2. B.prioritisation
    3. C.multitasking
    4. D.delegation
  5. Question 51 mark

    Which of these protects data from being lost in a disk failure?

    1. A.deleting files
    2. B.regular backups
    3. C.shutting down
    4. D.changing wallpaper
  6. Question 61 mark

    A program that spreads by attaching itself to other files is a

    1. A.virus
    2. B.firewall
    3. C.browser
    4. D.compiler
  7. Question 71 mark

    An entrepreneur who copies successful ideas and improves them plays the role of

    1. A.innovator
    2. B.imitator / adapter
    3. C.investor only
    4. D.employee
  8. Question 81 mark

    Green jobs aim to

    1. A.increase pollution
    2. B.reduce environmental impact
    3. C.use more fossil fuels
    4. D.cut forests
  9. Question 91 mark

    Which style category applies to whole pages, including margins and headers?

    1. A.character style
    2. B.paragraph style
    3. C.page style
    4. D.list style
  10. Question 101 mark

    Which feature updates automatically when headings change?

    1. A.table of contents
    2. B.footnote
    3. C.header
    4. D.page break
  11. Question 111 mark

    To combine two documents' edits, which feature is used?

    1. A.Compare Document / Merge
    2. B.Find & Replace
    3. C.Spelling
    4. D.Styles
  12. Question 121 mark

    Which option inserts an image with text flowing around it?

    1. A.Wrap
    2. B.Anchor only
    3. C.Crop
    4. D.Rotate
  13. Question 131 mark

    The tool used to summarise large data by grouping and calculating is

    1. A.Pivot Table
    2. B.Goal Seek
    3. C.Scenario
    4. D.Macro
  14. Question 141 mark

    Which feature finds the input value required to achieve a desired output?

    1. A.Goal Seek
    2. B.Solver only
    3. C.Consolidate
    4. D.Subtotals
  15. Question 151 mark

    A reference to cell B3 in the sheet 'Marks' of the same file is written as

    1. A.$Marks.B3
    2. B.Marks:B3
    3. C.Marks!B3
    4. D.B3@Marks
  16. Question 161 mark

    Which menu is used to record a macro in Calc?

    1. A.Tools > Macros > Record Macro
    2. B.Data > Macro
    3. C.Insert > Macro
    4. D.Format > Macro
  17. Question 171 mark

    A database table's structure is defined in

    1. A.Design View
    2. B.Form View
    3. C.Report View
    4. D.Slide View
  18. Question 181 mark

    Which data type stores True/False values?

    1. A.Text
    2. B.Boolean (Yes/No)
    3. C.Integer
    4. D.Date
  19. Question 191 mark

    Which SQL clause sorts the result of a query?

    1. A.WHERE
    2. B.ORDER BY
    3. C.GROUP BY
    4. D.SELECT
  20. Question 201 mark

    A field that uniquely identifies each record is the

    1. A.foreign key
    2. B.primary key
    3. C.index only
    4. D.composite field
  21. Question 211 mark

    Which command changes existing data in a table?

    1. A.INSERT
    2. B.UPDATE
    3. C.DELETE
    4. D.CREATE
  22. Question 221 mark

    Which of these is a web browser?

    1. A.Firefox
    2. B.LibreOffice
    3. C.Windows
    4. D.Calc
  23. Question 231 mark

    Sending fake emails to steal bank details is

    1. A.spamming
    2. B.phishing
    3. C.hacking a server
    4. D.cyberbullying
  24. Question 241 mark

    Which practice protects your online accounts the most?

    1. A.using the same password everywhere
    2. B.two-factor authentication
    3. C.writing passwords on paper
    4. D.short passwords

Section B · Short answer

Questions 25–29 carry 2 marks each.

  1. Question 252 marks

    Differentiate between active and passive voice. Convert 'Ravi wrote a letter.' into passive voice.

  2. OR

    Question 252 marks

    What is self-motivation? Give two ways to stay motivated.

  3. Question 262 marks

    Give two precautions to keep your computer healthy.

  4. Question 272 marks

    Name two green sectors and one green job in each.

  5. OR

    Question 272 marks

    What is a business plan? Give two of its parts.

  6. Question 282 marks

    What is a form in LibreOffice Base? Give one advantage.

  7. Question 292 marks

    What is netiquette? Give two rules.

Section C · Long answer

Questions 30–33 carry 4 marks each.

  1. Question 304 marks

    Write the steps to create a table of contents in LibreOffice Writer and to update it.

  2. OR

    Question 304 marks

    What is a style? Write the steps to create a new paragraph style from a formatted paragraph.

  3. Question 314 marks

    What is a scenario in LibreOffice Calc? Write the steps to create one.

  4. OR

    Question 314 marks

    Explain how to link data from another sheet and from another spreadsheet file in Calc.

  5. Question 324 marks

    A table BOOKS has fields BookID, Title, Author, Price. Write SQL statements to:

    (a) display all books by 'R.K. Narayan', (b) display titles of books costing more than ₹300, (c) increase the price of all books by ₹20, (d) delete the book with BookID 'B07'.

  6. Question 334 marks

    Explain any four online safety measures while using public Wi-Fi.

Ready to attempt this paper?

Take it as a timed test of 120 minutes. Your answers are saved as you go and every answer is marked when you submit.

You'll be asked to log in or sign up first if needed.