Page 1 Sample Paper 7 INFORMATION TECHNOLOGY
Sample Paper 7
INFORMATION TECHNOLOGY (402)
Class X Session 2023-24
Time: 2 Hours Max. Marks: 50
General Instructions:
1. Please read the instructions carefully.
2. This Question Paper consists of 21 questions in two sections: Section A & Section B.
3. Section A has Objective type questions whereas Section B contains Subjective type questions.
4. Out of the given (5 + 16 =) 21 questions, a candidate has to answer (5 + 10 =) 15 questions in the allotted
(maximum) time of 2 hours.
5. All questions of a particular section must be attempted in the correct order.
6. SECTION A - OBJECTIVE TYPE QUESTIONS (24 MARKS):
i. This section has 05 questions.
ii. Marks allotted are mentioned against each question/part.
iii. There is no negative marking.
iv. Do as per the instructions given.
7. SECTION B – SUBJECTIVE TYPE QUESTIONS (26 MARKS):
i. This section has 16 questions.
ii. A candidate has to do 10 questions.
iii. Do as per the instructions given.
iv. Marks allotted are mentioned against each question/part.
SECTION - A
Objective Type Questions
1. Answer any 4 out of the given 6 questions based on Employability Skills
(i) Which of the following is not a solution for sustainable development?
(a) Education and awareness programs (b) Sustainable agriculture practices
(c) Deforestation and habitat destruction (d) Green technology advancements
(ii) High expectations from self can leave one with chronic anxiety and stress, thus leading to _____ stress.
(a) physical (b) emotional
(c) mental (d) financial
(iii) Non-verbal communication includes
(a) Written messages (b) Facial expressions
(c) Email communication (d) Phone calls
(iv) Which term means walking in the local park or a similar activity?
(a) Nature walk (b) Motivation
(c) Regulation (d) None of these
(v) A/An _____ creates new needs and new means to satisfy them.
(a) leadership (b) innovation
Install NODIA App to See the Solutions.
Click Here To Install
Page 2 Sample Paper 7 INFORMATION TECHNOLOGY
(c) entrepreneur (d) None of these
(vi) It is a picture or graphic representation of an application or a file.
(a) Icon (b) Taskbar
(c) Status bar (d) Desktop
2. Answer any 5 out of the given 6 questions
(i) Computer based record keeping system is known as
(a) Data Manipulation System (b) Computerised Data System
(c) Computerised Record Keeping System (d) DBMS
(ii) Facilities offered by databases are
(a) the ability to store a large amount of data in a structured format, easy update, sort query, production of
reports.
(b) easy edition, spell check, perform calculations, library of mathematical functions, replication.
(c) the ability to rotate images, copy and paste, fill scale.
(d) None of the above
(iii) Which of the following is a spreadsheet software?
(a) Lotus 1-2-3 (b) VisiCalc
(c) Both ‘a’ and ‘b’ (d) None of these
(iv) _____ is a form of electronic commerce where customers can buy or sell goods over the Internet.
(a) Online shopping (b) E-Reservation
(c) Email (d) E-banking
(v) Database servers are referred to as
(a) front-ends (b) back-ends
(c) clients (d) model
(vi) A template is a model that you use to create _____.
(a) images (b) other documents
(c) design (d) DBMS
3. Answer any 5 out of the given 6 questions
(i) It refers to a cell or a range of cells on a worksheet and can be used to find a formula.
(a) Row (b) Column
(c) Autosum (d) Cell reference
(ii) _____ is a Malware which is designed to spy on the victim’s computer.
(a) Virus (b) Spyware
(c) Worms (d) Trojan horse
(iii) Which of the following is a set of formats consisting of such things as fonts, colors etc?
Install NODIA App to See the Solutions.
Click Here To Install
Page 3 Sample Paper 7 INFORMATION TECHNOLOGY
(a) Style (b) Margin
(c) Indent (d) Leading
(iv) Which of the following is not a data type?
(a) Picture/Graphic (b) Date/Time
(c) Text (d) Number
(v) Which function cannot be performed through Subtotal in a Spreadsheet?
(a) Sum (b) Product
(c) Average (d) Percentage
(vi) Pictures can be added to Word documents and they cannot be formatted in various ways.
(a) True (b) False
4. Answer any 5 out of the given 6 questions
(i) In a document, _____ is used to apply a style to many different areas quickly without having to go back to the
Styles and Formatting window and double click every time.
(a) Fill format mode (b) Formatting window
(c) Painter mode (d) Text wrapping
(ii) A computer _____ controls access between networks.
(a) Firewall (b) Virus
(c) Spyware (d) Antivirus
(iii) When you define a field for a table, _____ are the names given to column in a table.
(a) Field Name (b) Field Size
(c) Data Type (d) Description
(iv) The _____ feature creates a summarized outline of data in a worksheet.
(a) Subtotal (b) Solver
(c) Goal Seek (d) Scenario
(v) Raj has created a worksheet where he has added all the information of his employees. He wants every employee
to go through the worksheet and update their address and phone number, if required. He also would like to know
the changes done by his employees. Which feature of spreadsheet he should enable to see the changes made by
his employees?
(a) Macro (b) Link workbook
(c) Change worksheet (d) Track changes
(vi) _____ program(s) also offer real-time protection monitoring your computer for any changes by malware
software.
(a) Antivirus (b) Antispyware
(c) Both (a) and (b) (d) None of these
5. Answer any 5 out of the given 6 questions
(i) In a document, _____ refers to the vertical or horizontal placement of a graphic in relation to the chosen anchor
Install NODIA App to See the Solutions.
Click Here To Install
Page 4 Sample Paper 7 INFORMATION TECHNOLOGY
point.
(a) arrangement (b) alignment
(c) identation (d) margin
(ii) The action of sharing your opinions contents on a blog is termed as _____.
(a) Blogger (b) Blogging
(c) Tweeting (d) Commenting
(iii) Tanu explained his class that to apply an existing style, except for _____, position the insertion point in the
paragraph, frame or page and then double-click on the name of the style in one of these lists.
(a) Window style (b) Character style
(c) Paragraph style (d) Cell style
(iv) To copy a formula from one cell to another
(a) Drag the autofill handle (b) Cut the cell
(c) Both (a) and (b) (d) None of the above
(v) A _____ is a location or a place of employment, where someone works to earn his living.
(a) Workplace (b) Home
(c) Society (d) Industry
(vi) Which of the following commands is not a Data manipulation language?
(a) Select (b) Insert
(c) Update (d) Alter
SECTION - B
Subjective Type Questions
Direction for Q 6-Q 10 : Answer any 3 out of the given 5 questions on Employability skills. Answer each question in
20-30 words.
6. What are the benefits of acquiring green skills?
7. How can empathy enhance communication skills?
8. What are the responsibilities of an operating system with respect to file management?
9. What are the skills necessary for independent working? List any six.
10. What are the disadvantages of entrepreneurship?
Direction for Q 11-Q 16 : Answer any 4 out of the given 6 questions in 20-30 words each.
Install NODIA App to See the Solutions.
Click Here To Install
Page 5 Sample Paper 7 INFORMATION TECHNOLOGY
11. What is the role of key fields in a database? Name the keys in a DBMS.
12. What is a macro?
13. How does a router help in maintaining a network ?
14. What is Mail Merge?
15. How can you prepare for emergencies?
16. Define the following terms:
(i) Active Cell (ii) Sheet Tab
Direction for Q 17-Q 21 : Answer any 3 out of the given 5 questions in 50-80 words each.
17. Write the steps for text fitting inside a shape in a word processor document. Also, describe its options.
18. Ishita is a teacher. She had entered the marks of all the students and also calculated the total of the students. Now,
she wants to sort the data so that she can find the names of the students according to their marks in descending order.
Tell her the different steps to sort the data.
19. What do you mean by data control language? Also, give its types.
20. Consider the following table : Employee Salary.
Table : EmployeeSalary
Last First Dept Payroll Salary (`) JobTitle
Name Name Number
Shen James Finance A621 19500 Payroll Clerk
Gupta Shruthi Finance M502 35000 Accountant
Bedi Reeta Human Resource M421 18500 Secretary
Walker Tia Sales W815 24000 Sales Representative
Shafia Ahmed Factory H219 39000 Factory Manager
Mittal Chavi Purchasing M134 20000 Purchasing Clerk
(i) How many fields and records are there in the table EmployeeSalary?
(ii) Write the SQL queries for the following:
(a) List all data of table EmployeeSalary.
(b) Display all the records whose salary is less than 25000.
(c) Display the FirstName and JobTitle of employees having Dept ‘Finance’.
21. How to clear web history on the Mozilla Firefox browser?
******
Install NODIA App to See the Solutions.
Click Here To Install