Practicing the CBSE Sample Papers for Class 10 Information Technology Set 1 allows you to get rid of exam fear and be confident to appear for the exam.
CBSE Sample Papers for Class 10 Information Technology Set 1 with Solutions
Time: 2 hrs
Max. Marks: 50
Instructions:
- Please read the instructions carefully
- This Question Paper consists of 21 questions in two sections: Section A & Section B.
- Section A has Objective type questions whereas Section B contains Subjective type questions.
- 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.
- All questions of a particular section must be attempted in the correct order.
- Section A: Objective Type Questions (24 Marks)
- This section has 05 questions.
- Marks allotted are mentioned against each question/part.
- There is no negative marking.
- Do as per the instructions given.
- Section B: Subjective Type Questions (26 Marks)
- This section has 16 questions.
- A candidate has to do 10 questions.
- Do as per the instructions given.
- Marks allotted are mentioned against each question/part.
Section-A
(Objective Type Questions)
Question 1.
Answer any 4 out of the given 6 questions based on Employability Skills. [1 × 4 = 4 Marks]
(i) Identify the measure to protect computer from tand viruses. [1]
(a) Sharing password with friends
(b) Allow anyone to use your device
(c) Use Antivirus
(d) Leave computer without logging out
Answer:
(c) Use Antivirus
(ii) …………… means communication through spoken and written words. [1]
(a) Non-verbal communication
(b) Feedback
(c) Verbal communication
(d) None of these
Answer:
(c) Verbal communication
(iii) …………. is our body’s way of responding to any kind of demand. [1]
(a) Stress
(b) Self-regulation
(c) Self-motivation
(d) All of these
Answer:
(a) Stress
(iv) A/ An ………….. has to create a spirit of team work and motivate them. [1]
(a) entrepreneur
(b) government policy
(c) Both (a) and (b)
(d) None of these
Answer:
(a) entrepreneur
(v) A ……………. operating system is a computing environment that reacts to input within a specific period of time. [1]
(a) single-user
(b) real time
(c) multi-user
(d) distribute
Answer:
(b) real time
(vi) Which of the following is necessary for the maintenance of the environment? [1]
(a) Poor management
(b) Sustainable development
(c) Man made resources
(d) None of these
Answer:
(b) Sustainable development
Question 2.
Answer any 5 out of the given 6 questions [1 × 5 = 5 Marks]
(i) Which of the following is an application program that is stored on a remote server and delivered over the Internet? [1]
(a) Web application
(b) System application
(c) Internet application
(d) None of the above
Answer:
(a) Web application
(ii) Which of the following is not a good choice as a field name for a database? [1]
(a) Emp_Id
(b) Emp_dept
(c) Emp_name
(d) Emp_set
Answer:
(d)Emp_set
(iii) The data in the data source is organised in [1]
(a) text form
(b) image form
(c) tabular form
(d) paragraph form
Answer:
(c) tabular form
(iv) Shalini is working in a school. She is the class teacher of VIIIB. It is the time to enter the subject marks and grades of all students of her class in a worksheet. While entering the marks and grades, she has to scroll up again and again to the row where all subject names are entered, in order to avoid any mistakes in her entries. This process is consuming a lot of her time. Help her by letting her know about one such tool by which she can fix the field rows from the following and continue with her work without wasting much time. [1]
(a) Fix row
(b) Fix column
(c) Freeze panes
(d) Freeze all
Answer:
(c) Freeze panes
(v) Template is a ………………. document based on which one can create a new document. [1]
(a) blueprint
(b) printed
(c) suggested
(d) copied
Answer:
(a) blueprint
(vi) Which of the following is not an object of a database?
(a) Report
(b) Forms
(c) Query
(d) Functions
Answer:
(d) Functions
Question 3.
Answer any 5 out of the given 6 questions [1 × 5 = 5 Marks]
(i) Grouping drawing object can be used for which of the following? [1]
(a) Combining drawing objects as one
(b) Resizing
(c) Adding more drawing objects
(d) None of these
Answer:
(a) Combining drawing objects as one
(ii) Aanya is making a table in Access to store data of all the employees working in her organisation. She has decided on the various information that she needs to store in that table. She also has to have a field in which only unique data can be entered. Out of the given fields suggest the best field suitable that can be used as a primary key, so that it can accept only unique data. [1]
(a) Emp_name
(b) Emp_dept
(c) Emp_number
(d) Emp_DOB
Answer:
(c) Emp_number
(iii) Computer connected with LAN
(a) can work fast
(b) can go online
(c) can E-mail
(d) can share information or peripheral devices
Answer:
(d) can share information or peripheral devices
(iv) State True or False.
“A custom style displays user-defined styles.”
(a) True
(b) False
Answer:
(a) True
(v) According to Open Office Calc which of the following is not a What-if analysis tool?
(a) Conditional formatting
(b) Goal seek
(c) Scenarios
(d) Solver
Answer:
(b) Goal Seek
(vi) ……….. allows multiple users to view, edit and change in a spreadsheet.
(a) Opening
(b) Reviewing
(c) Sharing
(d) Collaborating
Answer:
(c) Sharing
Question 4.
Answer any 5 out of the given 6 questions [1 × 5 = 5 Marks]
(i) What can you do with the Internet?
(a) Exchange information with friends and colleagues.
(b) Access pictures, sounds, video clips and other media elements.
(c) Find diverse perspective on issues from a global audience.
(d) All of the above
Answer:
(d) All of the above
(ii) The Show Changes dialog box has which of the following settings?
(a) Data
(b) Comment
(c) Views
(d) All of these
Answer:
(d) All of these
(iii) Reports are generally used to show the data in ………… form.
(a) printed
(b) chart
(c) Both (a) and (b)
(d) None of these
Answer:
(a) printed
(iv) ………….. is an example of a text-based browser which provides access to the Internet in the text-only mode. [1]
(a) Mozilla Firefox
(b) Lynx
(c) Internet Explorer
(d) All of these
Answer:
(b) Lynx
(v) Anila works in a Multi National Company (MNC) and needs to work online from home also. She requires fast Internet connection. Which type of Internet connection in your view would be best suited for her? [1]
(a) Dialup
(b) Broadband
(c) Both are suitable
(d) None of these
Answer:
(b) Broadband
(vi) Manya has created a spreadsheet using Calc, to find the average of the values in a range of cells. She wants to use a function, so that it is calculated automatically and also she can copy the same formula for other range of cells. Which of these functions will give the correct result? [1]
(a) AVG
(b) Average
(c) Mean
(d) None of these
Answer:
(b) Average
Question 5.
Answer any 5 out of the given 6 questions [1 × 5 = 5 Marks]
(i) Which data type is the most appropriate to store a short bio about an employee? [1]
(a) Text
(b) String
(c) Memo
(d) Large text
Answer:
(c) Memo
(ii) If you have a safer and healthy workplace, there will be fewer days lost and it will have higher [1]
(a) employee satisfaction
(b) productivity
(c) stress levels
(d) None of these
Answer:
(b) prodctivity
(iii) When primary key constraint is applied on one or more columns, then it is known as [1]
(a) composite primary key
(b) foreign key
(c) composite foreign key
(d) connecting key
Answer:
(a) composite primary key
(iv) Naina has created a database of all the employees working in her organisation. But these entries were done randomly. Her boss wants the entire list in ascending order of employee Id. She can do this by using which of the following tools in DBMS? [1]
(a) Ordering data
(b) Sorting data
(c) Presenting data
(d) Referring data
Answer:
(b) Sorting data
(v) Rishabh wants to make a professional resume. He tried many a times but the end result was not satisfactory as he was not knowing what all points should be there and that too in which order. Which one of the following writer would you suggest him, so that his problem is solved? [1]
(a) Template
(b) Form
(c) Worksheet
(d) Format
Answer:
(a) Template
(vi) What is the full form of RSI? [1]
(a) Repetitive Strain Injury
(b) Rational Strain Injury
(c) Repetitive Stress Injury
(d) Risk Strain Injury
Answer:
(a) Repetitive Strain Injury
Section-B
(Subjective Type Questions)
Answer any 3 out of the given 5 questions on Employability skills. [2 × 3 = 6 Marks]
Answer each question in 20-30 words.
Question 6.
What are the disadvantages of non-verbal communication? [2]
Answer:
Disadvantages of non-verbal communication are as follows:
- In the absence of language, this type of communication does not convey actual meaning of the message. This makes the communication imprecise.
- It can be confusing as no clear message is conveyed.
- Long conversations are not possible in non-verbal communication.
- It can be costly as Neon signs, PowerPoint presentation movies involve huge cost.
Question 7.
Write the steps to remove the password from a file. [2]
Answer:
The steps to remove a password from a file are:
Click “File” and “Save As.” Choose the option that saves the file with the “. “xlt” extension. Uncheck the option in the bottom left corner that says “Save with password.” Press “Save”.
Question 8.
How does yoga help to manage stress? [2]
Answer:
Yoga is a mind-body practice that combines physical poses, controlled breathing and meditation or relaxation. It helps in stress management by relaxing the body and mind, develop a connection between them releasing emotional energy and helping to breathe more effectively.
Question 9.
What do you mean by entrepreneur? [2]
Answer:
An entrepreneur is an individual who creates a new business, bearing most of the risks and enjoying most of the rewards. Entrepreneurs are innovators, who use the process of entrepreneurship to shatter the status quo of existing products and services, in order to set and new products, new services.
Question 10.
Explain any two functions of an entrepreneur. [2]
Answer:
Two functions of an entrepreneur are as follows :
- Innovation It includes introducing new products, opening new markets, new sources of raw material and new organisation structure,
- Risk-taking Choosing one among various alternatives, the end results of which are unpredictable.
Answer any 4 out of the given 6 questions in 20-30 words each. [2 × 4 = 8 Marks]
Question 11.
How can you define OLE? [2]
Answer:
OLE objects Use an OLE (Object Linking and Embedding) object to insert in a presentation either a new document or an existing one. Embedding inserts a copy of the object and details of the source program in the target document, that is the program which is associated to the file type in the operating system. The major benefit of an OLE object is that it is quick and easy to edit the contents just by double-clicking on it. You can also insert alink to the object that will appear as an icon rather than an area showing the contents itself.
Question 12.
What is the use of Consolidate option in Calc? [2]
Answer:
Data > Consolidate provides a way to combine data from two or more ranges of cells into a new range while running one of the several functions (such as Sum or Average) on the data. During consolidation, the contents of cells from several sheets can be combined into one place. The effect is that copies of the identified ranges are stacked with their top left corners at the specified result position, and the selected operation is used in each cell to calculate the result value.
Question 13.
State any two ways of inserting sheets in a workbook?
Answer:
Two ways of inserting sheets in a workbook are as follows :
- Select Insert > Sheet from the Menu Bar.
- Right-click on the sheet tab and click on Insert Sheet.
Question 14.
How Entry Required and Default Value properties of a table field in a database are different from each
Answer:
Entry Required If it sets to yes then it will be necessary for the user to insert the value in the field, which means that field cannot be left blank. While Default Value can be set for a field, if user doesn’t provide any value while making entries in the table.
Question 15.
What is Referential Integrity? Explain its purposes.
Answer:
Referential Integrity is a property of data stating that all its references are valid. In the context of relational databases, it is required that if a value of one attribute of a relation references a value of another attribute, then the referenced value must exist. Referential integrity is a database concept that is used to build and maintain logical relationships between tables. It is also used to avoid logical corruption of data. It is a very useful and important part in RDBMS. Usually, referential integrity is made up of the combination of a primary key and a foreign key.
Question 16.
What is Internet Service Provider? [2]
Answer:
ISP (Internet Service Provider) is a company that provides individuals and other companies access to the Internet. Internet Service Provider is used to join the Internet. Internet services typically provided by ISPs include Internet access, Internet transit, domain name registration, web hosting and Usenet service. ISP does not provide E-mail address, e.g. MTNL, BSNL, Airtel etc.
Answer any 3 out of the given 5 questions in 50-80 words each. [4 × 3 = 12 Marks]
Question 17.
Lavish is preparing notes for his upcoming exams. Help him to write the correct answer of the following: [4]
(i) Scenario
(ii) Absolute link
(iii) Relative link
(iv) Macro
Answer:
(i) The Scenario is a tool to test “What-if” questions. Each scenario is named and can be edited and formatted separately. When you print the spreadsheet, only the contents of the currently active scenario are printed.
(ii) An absolute link contains all the information necessary to locate a resource and will stop working only if the target is moved.
(iii) A relative link locates a resource using an absolute URL as starting point will stop working only if the start and target locations change relative to each other.
(iv) A macro is a saved sequence of commands or keystrokes that are stored for later use or to be used repeatedly.
Question 18.
Samarjit wants to know about template. Tell him the definition of template and also the steps to create a document using it. [4]
Answer:
A template is a document model that you use to create other documents. For example, you can create a template for business reports that has your company’s logo on the first page. New documents created from this template will all have your company’s logo on the first page.
Templates can contain anything that regular documents can contain, such as text, graphics, a set of styles and user-specific setup information such as measurement units, language, the default printer, and toolbar and menu customization.
To use a template to create a document:
(i) From the main menu, choose File > New > Templates and Documents. The Templates and Documents dialog box opens.
(ii) In the box on the left, click the Templates icon if it is not already selected. A list of template folders appears in the center box.
(iii) Double-click the folder that contains the template that you want to use. A list of all the templates contained in that folder appears in the center box.
(iv) Select the template that you want to use. You can preview the selected template or view the template’s properties:
- To preview the template, click the Preview icon. (For the location of the Preview icon) A preview of the template appears in the box on the right.
- To view the template’s properties, click the Document Properties icon. (For the location of the Document Properties icon) The template’s properties appear in the box on the right.
(v) Click Open. The Templates and Documents dialog box closes and a new document based on the selected template opens in Writer. You can then edit and save the new document just as you would any other document.
Question 19.
Consider the following table: SHOPPE [4]
| Id | SName | Area |
| S001 | ABC Computeronics | CP |
| S002 | All Infotech Media | GK II |
| S003 | Tech Shoppe | CP |
| S004 | Geeks Tecno Soft | Nehru Place |
| S005 | Hitech Tech Store | Nehru Place |
(i) How many fields and records are there in SHOPPE table?
(ii) Write SQL commands for the following :
(a) Display Id and SName of all the shops located in Nehru Place.
(b) Display the details alphabetically by SName.
(c) Display SName of shops whose Area is CP.
Answer:
(i) There are 3 fields and 5 records in the table SHOPPE.
(ii) (a) SELECT Id, SName FROM SHOPPE WHERE Area= ’Nehru Place’;
(b) SELECT * FROM SHOPPE ORDER BY SName; ‘
(c) SELECT SName FROM SHOPPE WHERE Area=’CP’;
Question 20.
Your friend’s father owns a restaurant. He manually enters the customers records in a register. You want to explain to him the importance of creating a database in computer. Tell the advantages of using computerized database with the help of the following points: [4]
(a) Data redundancy
(b) Data inconsistency
(c) Confidentiality
(d) Sharing
Answer:
(a) Data redundancy means duplication of data avoids duplication of data and ensures that there is only one instance of certain data.
(b) Data inconsistency helps, if a single database is used by multiple users then it ensures that the same data is present for all the users.
(c) The DBMS can ensure different views for the different users of the database. This keeps the confidentiality of the data safe.
(d) Different users can use the same database to access the data according to their needs. Hence, DBMS provides sharing of data and resources.
Question 21.
Rahul and Amit are working on a school project assigned to them by their teacher. They have to send instant messages to each other and also do a video conferencing after school hours in order to complete the project on time. Tell the use of the following devices used for video conferencing. [4]
(a) Microphone
(b) Webcamera
(c) Speakers
(d) Headsets
Answer:
(a) Using microphone, the speaker,can convey their messages.
(b) Web camera is used to have a real-life image of the person.
(c) Speakers are used to listen to the words of the speaker.
(d) Headsets are used to listen to the speaker without disturbing anyone nearby.