Practicing the CBSE Sample Papers for Class 10 Information Technology Set 6 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 6 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) ……………… is the process in which the receiver interprets and understands the message. [1]
(a) Encoding
(b) Decoding
(c) Sender
(d) Receiver
Answer:
(b) Decoding
(ii) …………… generates within the human regarding the unreasonable matters. [1]
(a) Internal stress
(b) Survival stress
(c) Environmental stress
(d) None of these
Answer:
(a) Internal stress
(iii) An …………. is a software program that manages the hardware and software resources of a computer. [1]
(a) Application
(b) Operating system (OS)
(c) System
(d) None of these
Answer:
(b) Operating system (OS)
(iv) An entrepreneur must establish good relations with …………. and its functionaries. [1]
(a) customer
(b) government
(c) Both (a) and (b)
(d) None of these
Answer:
(b) government
(v) The overall effects of economic activities on the environment are continuously ………….. [1]
(a) editing
(b) changing
(c) formatting
(d) All of these
Answer:
(b) changing
(vi) Energy demand in developing countries will increase to ……….. times the current levels by 2030. [1]
(a) four
(b) five
(c) six
(d) eight
Answer:
(c) six
Question 2.
Answer any 5 out of the given 6 questions [ 1 × 5 = 5 Marks]
(i) Every computer is protected by a …………….. [1]
(a) firewall
(b) software
(c) server
(d) network
Answer:
(a) firewall
(ii) The structure line displays the elements for entries in the level column. The ………….. button represents the page number. [1]
(a) #
(b)
(c) %
(d) @
Answer:
(a) #
(iii) …………. command is used to restore database to original since the last COMMIT. [1]
(a) REVIEW
(b) SELECT
(c) ROLLBACK
(d) None of these
Answer:
(c) ROLLBACK
(iv) Default name of first scenario created in Sheetl of Calc is ……………… [1]
(a) Sheet_l_Scenario
(b) Sheet_Scenario_l
(c) Sheeti_Scenario_l
(d) None of these
Answer:
(c) Sheeti_Scenario_l
(v) To delete a template, ……………… on a template in the Templates window and select delete. [1]
(a) Right-click
(b) Double-click
(c) Left-click
(d) None of these
Answer:
(a) Right-click
(vi) Which of the following fields will not make a suitable primary key? [1]
(a) A customer’s account number
(b) A date-field
(c) An auto number field
(d) A student’s admission number
Answer:
(b) A date-field
Question 3.
Answer any 5 out of the given 6 questions [1 × 5 = 5 Marks]
(i) Under Insert tab, ……………. group contains the features like Shapes, ClipArt etc. [1]
(a) Illustrations
(b) Shapes
(c) Paragraph
(d) Clipboard
Answer:
(a) Illustrations
(ii) …………. command is used to retrieve data from a database. [1]
(a) SELECT
(b) INSERT
(c) UPDATE
(d) None of these
Answer:
(a) SELECT
(iii) Instant messaging service accepts instant messages from …………….. [1]
(a) external sites
(b) internal sites
(c) Both (a) and (b)
(d) None of these
Answer:
(a) external sites
(iv) Two other toolbars can be opened from Picture Tool bar are : the …………. and ……………… [1]
(a) Edit picture. Color picture
(b) Format, drawing
(c) Graphic Filter toolbar, Color toolbar
(d) Floating toolbar, Color toolbar
Answer:
(b) Format, drawing
(v) In the Subtotal dialog box, the ……………. box is used to select the column on which you want to add the Subtotal to. [1]
(a) group by
(b) filter by
(c) consolidate by
(d) update by
Answer:
(a) group by
(vi) Commands are a set of instructions that is used to interact with database. [1]
(a) SQL
(b) Java
(c) Mac
(d) DBMS
Answer:
(a) SQL
Question 4.
Answer any 5 out of the given 6 questions [1 × 5 = 5 Marks]
(i) Type of software is accessed using browsers [1]
(a) Open source
(b) Both (a) and (c)
(c) Web based
(d) None of these
Answer:
(c) Web based
(ii) Under …………….. tab, Bullet and Numbering, Autocorrect etc options are present. [1]
(a) Tools
(b) Format
(c) Window
(d) Table
Answer:
(b) Format
(iii) …………. is a collection of related information [1]
(a) base
(b) Database
(c) web-base
(d) None of these
Answer:
(b) Database
(iv) Which of the following network devices is used to connect to dissimilar networks? [1]
(a) Gateway
(b) Switch
(c) Bridge
(d) Router
Answer:
(a) Gateway
(v) You should uninstall any …………… and services which you are not using from long time. [1]
(a) hardware
(b) software
(c) system
(d) None of these
Answer:
(b) software
(vi) In Goal seek dialog box, the ………….. we enter the reference of the cell that contains the value to be changed. [1]
(a) variable cell
(b) modifying cell
(c) changing cell
(d) replacing cell
Answer:
(a) variable cell
Question 5.
Answer any 5 out of the given 6 questions [1 × 5 = 5 Marks]
(i) Key field is a unique identifier for each record. It is defined in the form of [1]
(a) rows
(b) Columns
(c) tree
(d) query
Answer:
(b) Columns
(ii) ……….. is used to text-to-speech utility that reads what is displayed on the screen. [1]
(a) Start Narrator
(b) Web page
(c) Website
(d) None of these
Answer:
(a) Start Narrator
(iii) Computer based record keeping system is known as ………….. [1]
(a) Data Manipulation System
(b) Computer Data System
(c) Computerised Record Keeping System
(d) DBMS
Answer:
(d) DBMS
(iv) The comments that are added while creating a scenario is displayed in the …………. while using scenario. [1]
(a) preview pane
(b) navigator box
(c) comment window
(d) None of these
Answer:
(b) navigator box
(v) Which of the following is not a type of text wrapping option? [1]
(a) Wrap off
(b) Optimal wrap
(c) Page wrap
(d) Wrap center
Answer:
(d) Wrap center
(vi) …………… is a free personal publishing platform. [1]
(a) Zoomla
(b) WordPress
(c) Blogger
(d) None of these’
Answer:
(b) WordPress
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 verbal communication? [2]
Answer:
Following are the disadvantages of verbal communication are:
- It has no legal validity and hence will lead to problems in certain situations. Emotions are visible and hence leads to trouble in certain cases.
- It has issues when communicating with distant people.
- It does not provide permanent record unless it is recorded with modern means of storage.
- This form of communication is not suitable for lengthy message.
Question 7.
What do you mean by environmental stress? [2]
Answer:
Environmental stress is a response to happenings around us that cause stress, such as noise, pollution, crowding, pressure of work, family tensions etc. Some of these may be under our control if we try to control them, whereas some may not be controllable. Identifying these environmental stresses and learning to avoid them or deal with them will help lower our stress level.
Question 8.
Write any two main advantages of an operating system. [2]
Answer:
The main advantages of an operating system include:
- Allows multiple programs to run concurrently.
- Simplifies the programming of application software because the program does not have to manage the hardware. The operating systems manages all hardware and the interaction of software. It also gives the program a high-level interface to the hardware and ways of interacting with other programs.
Question 9.
Describe the following functions of an entrepreneur: [2]
(i) Innovation
(ii) Risk-Taking
Answer:
(i) Innovation It includes introducing new products, opening new markets, new sources of raw material and new organisation structure.
(ii) Risk-Taking An entrepreneur has to take risk by choosing one among various alternatives.
Question 10.
Explain long lasting development as an importance of sustainable development. [2]
Answer:
Sustainable development aims at achieving the goal of economic and social development without destroying the Earth’s means and resources. It attempts to create the concept of maintaining the present work for the future and conserving the natural resources for future generation.
Answer any 4 out of the given 6 questions in 20-30 words each. [2 × 4 = 8 Marks]
Question 11.
Write some features of spelling checker in open office writer. [2]
Answer:
- You can right-click on a word with a wavy underline, to open a context menu. If you select from the suggested words on the menu, the selection will replace the misspelled word in your text.
- You can change the dictionary language (for example, to Spanish, French or German) on the Spelling dialog box.
- You can add a word to the dictionary. Click Add in the Spelling dialog box and pick the dictionary to add it to.
- The Options dialog of the Spelling tool has a number of different options, such as whether to check uppercase words and words with numbers. It also allows you to manage custom dictionaries; that is, add or delete dictionaries, and add or delete words in a dictionary.
Question 12.
Write the steps for identifying duplicates in excel. [2]
Answer:
To identify duplicates :
1. Select the cells you want to check for duplicates.
2. Click Home > Conditional Formatting > Highlight Cells Rules > Duplicate Values.
3. In the box next to values with, pick the formatting you want to apply to the duplicate values, and then click OK.
Question 13.
What is data analysis in a spreadsheet software? [2]
Answer:
Data analysis is a process of inspecting, cleansing, transforming, and modeling data with the aim of deriving useful information from it, which can further be used in an organization’s decision making process. In the previous class we have learnt to use formulas and functions for manipulation and analysis of data. Calc offers several other tools for analyzing and manipulating spreadsheets including data consolidation, subtotals, scenarios, Goal seek and Solvers etc. All these tools are organized in two menus-Tools menu and data menu.
Question 14.
Explain the term relational database management system. [2]
Answer:
RDBMS (Relational Database Management System) is a type of DBMS that stores data in the form of relations (tables). Relational databases are powerful, so they require few assumptions about how data is related or how it will be extracted from the databases. An important feature of relational database system is that a single database can be spread across several tables. Base, Oracle, DB2, SAP, Sybase, ASE, Informix, Access etc. are the examples of RDBMS.
Question 15.
What do you mean by data control language? Also, give its types. [2]
Answer:
DCL (Data Control Language) commands are used to assign security levels in database which involves multiple user setups. They are used to grant defined role and access privileges to the users.
Two types of DCL commands are :
(i) GRANT Used to give user’s access privileges to database.
(ii) REVOKE Used to withdraw access privileges given with the GRANT command.
Question 16.
Describe the term wireless fidelity. [2]
Answer:
Wireless Fidelity (Wi-Fi) is a universal wireless networking technology that utilises radio frequencies to transfer data. Wi-Fi allows high speed Internet connections without the use of cables or wires. Wi-Fi networks can be designed for private access within a home or business. It can be used for public Internet access at ‘hotspots’ that offers Wi-Fi access such as restaurants, coffee shops, hotels, airports, convention centres and city parks.
Answer any 3 out of the given 5 questions in 50-80 words each. [4 × 3 = 12 Marks]
Question 17.
Simran wants to know about Subtotal. Answer the given questions for her. [4]
(i) What is SUBTOTAL( ) function?
(ii) Names of any 5 functions with their function index number.
Answer:
(i) The SUBTOTAL function is listed in the mathematical category of functions. It is used to calculate subtotals for a
given range with the help of another function defined within it. The general syntax of the SUBTOTAL function is as follows: .
SUBTOTAL (Function; Range)
Here, Function is the index number for one of the following functions:
(ii) Any 5 functions with their function index number are:
| Function | Function index |
| Average ( ) | 1 |
| Count ( ) | 2 |
| Counta ( ) | 3 |
| Max ( ) | 4 |
| Min ( ) | 5 |
Question 18.
Ram wants to compress a picture. Write the steps through which he can do so. [4]
Answer:
To resize an image:
1. Click one time on the image to select it.
2. From the Menu bar select: Format ? Position and Size.
3. Choose the Position & Size tab.
4. Insert the desired image size and click the OK button.
Or
1. Click one time on the image to select it. Little green squares will appear around the image.
2. Drag one of the squares to resize the image.
Question 19.
Consider the following table: MASTER [4]
| Name | Age | Department | Salary |
| Shyam | 21 | Computer | 12000 |
| Shiv | 25 | Maths | 15000 |
| Rakesh | 31 | Hindi | 14000 |
| Sharmila | 32 | History | 20000 |
| Dushyant | 25 | Software | 30000 |
(i) How many fields and records are there in the table MASTER?
(ii) Write the SQL queries to:
(a) Display all the records according to Age.
(b) Display Name and Department of the person having salary less than 20000.
(c) Display the Name of the person having age less than 30.
Answer:
(i) There are 5 fields and 5 records in the table MASTER.
(ii) (a) SELECT * FROM MASTER ORDER BY Age;
(b) SELECT Name, Department FROM MASTER WHERE Salary<20000;
(c) SELECT Name FROM MASTER WHERE Age <30;
Question 20.
Yuan is learning about database. But, he didn’t understand the concept of field, records and table. Answer to him the following queries: [4]
(i) How are fields, record and a table related to each other? Explain with the help of an example.
(ii) What are the main purposes of a database system?
Answer:
(i) Fields are a type of information. A record contains logically related fields.
A table contains logically related records.
| Name | Salary |
| Shridha | 20,000 |
| Raghav | 40,000 |
In table Emp, EmpNo, Name and Salary are three different fields. 1, Shridhar, 20,000 represents one complete record.
(ii) The main purposes of a DBMS are
(a) Storage of information
(b) Retrieval of information quickly.
(c) Sorting, selecting data that satisfies certain and readable format.
(d) Produce the report in some standardised and readable format.
Questions 21.
Reema has been appointed as SME in an IT based company. Tell her the following: [4]
(i) What is workplace emergency?
(ii) Name the workplace emergencies that may happen.
Answer:
- A workplace emergency is an unforeseen situation that threatens your employees, customers, or the public; disrupts or shuts down the workplace operations; or causes physical or environmental damage.
- Emergencies may be natural or manmade and include the following:
- Floods,
- Hurricanes,
- Tornadoes,
- Fires,
- Toxic gas releases,
- Chemical spills,
- Radiological accidents,
- Explosions,
- Civil disturbances, and
- Workplace violence resulting in bodily harm and trauma.