CBSE Class 9 Information Technology (Code 402) Sample Question Paper - Set 3 (2025-26)
CBSE Class 9 Information Technology (Code 402) Sample Question Paper - Set 2 (2025-26)
SECTION A: EMPLOYABILITY SKILLS (10 MARKS)
Answer all questions. Each question carries 1 mark.
Q1. Which is a barrier to effective communication?
Correct Answer: b) Use of jargon
Q2. Goal setting is part of:
Correct Answer: a) Self-motivation
Q3. Cloud computing allows:
Correct Answer: b) Access files from anywhere via internet
Q4. Social entrepreneurship aims at:
Correct Answer: b) Solving social problems
Q5. 3R principle of green skills stands for:
Correct Answer: a) Reduce, Reuse, Recycle
Q6. Which is verbal communication?
Correct Answer: b) Phone call
Q7. Time management skill helps to:
Correct Answer: b) Prioritise tasks
Q8. Digital footprint is:
Correct Answer: b) Record of online activities
Q9. Green jobs are related to:
Correct Answer: b) Environmental protection & sustainability
Q10. Leadership quality of entrepreneur:
Correct Answer: b) Guiding and motivating team
SECTION B: SUBJECT SPECIFIC SKILLS (40 MARKS)
Q11 to Q15: Answer any 5 questions. Each question carries 2 marks. (Answer in 20-30 words each.)
Q11. What is mail merge? Give one use.
Answer: Mail merge combines a main document with a data source to create multiple personalised documents. Use: Creating identical letters with different names and addresses.
Q12. Define a worksheet and a workbook in Calc.
Answer: Worksheet is a single page/spreadsheet. Workbook is a file containing multiple worksheets.
Q13. What is the use of 'AutoFit' in tables in Writer?
Answer: AutoFit automatically adjusts column width or row height to fit the content inside the table cells.
Q14. Name any two types of charts in Calc.
Answer: Column chart, Pie chart, Line chart, Bar chart, Area chart (any two).
Q15. Why do we use slide master in Impress?
Answer: Slide master allows applying same design, font, background, logo to all slides at once for consistency.
Q16 to Q20: Answer any 3 questions. Each question carries 4 marks. (Answer in 50-80 words each.)
Q16. Describe any two IT applications in daily life. OR Write steps to insert and format a table in Writer.
Answer: 1. Online banking for money transfer. 2. E-commerce for shopping. OR Steps: Insert → Table → Select rows & columns → Enter data → Table Properties → Change border, alignment, background.
Q17. Explain any four basic arithmetic operators used in Calc formulas.
Answer: + Addition, − Subtraction, * Multiplication, / Division. Example: =A1+B1, =C2*D3 etc.
Q18. How can you protect a worksheet in Calc? Write steps.
Answer: Tools → Protect Sheet → Enter password → Select options (select locked cells, edit objects etc.) → OK. Prevents accidental changes.
Q19. Explain the steps to apply slide transition and custom animation in Impress.
Answer: Transition: Slide Transition sidebar → Choose effect → Apply. Animation: Select object → Animation sidebar → Add effect → Set timing & order.
Q20. What is the importance of digital documentation in offices?
Answer: Saves paper, easy editing, quick sharing via email, version control, searchability, professional appearance.
Q21: Case-Based Question (6 marks)
Q21. Priya is the class monitor. She maintains student attendance in a spreadsheet. She wants to calculate total present days, percentage attendance, and highlight students below 75% attendance. She also prepares a presentation for the PTA meeting. a) Write formulas for total days and percentage. (2) b) How to apply conditional formatting? (2) c) Suggest two slide layouts she can use. (2)
Answer:
a) Total: =SUM(B2:G2) Percentage: =(Total/TotalWorkingDays)*100
b) Select range → Format → Conditional Formatting → Condition: Cell value < 75 → Apply red colour.
c) 1. Title and Content 2. Title Only (for images/charts).
a) Total: =SUM(B2:G2) Percentage: =(Total/TotalWorkingDays)*100
b) Select range → Format → Conditional Formatting → Condition: Cell value < 75 → Apply red colour.
c) 1. Title and Content 2. Title Only (for images/charts).
Comments
Post a Comment