Computer IT Sample Paper Class 10 Set 1 with Solutions
Time: 2 hrs
Maximum Marks: 50
SECTION A: Objective Type Questions
1. Answer any 4 out of the given 6 questions based on Employability Skills
(i) ______ is essential to complete the cycle of communication.
(a) Encoding
(b) Decoding
(c) Feedback
(d) Sender
Answer:
(c) Feedback
(ii) The good stress is called _______
(a) eustress
(b) emstress
(c) Both (a) and (b)
(d) None of these
Answer:
(a) eustress
(iii) _______ means to make a duplicate of a file.
(a) Deleting
(b) Editing
(c) Pasting
(d) Copying
Answer:
(d) copying
(iv) _____ describes entrepreneurs as innovators.
(a) Howard W. Johnson
(b) Joseph Schumpter
(c) Both (a) and (b)
(d) None of these
Answer:
(b) Joseph Schumpter
(v) Sustainable development requires the judicious use of _____.
(a) resources
(b) natural resources
(c) verbal resources
(d) None of these
Answer:
(b) natural resources
(vi) _______ conveys a statement, question, exclamation or command.
(a) Sentence
(b) Equation
(c) Formula
(d) None of these
Answer:
(a) Sentence
2. Answer any 5 out of the given 6 questions.
(i) If you want to locate a range of cells by its name, then you will enter its name in _______
(a) formula bar
(b) name box
(c) cell
(d) None of these
Answer:
(b) name box
(ii) We can italic the text by ______
(a) Ctrl + IT
(b) Shift + I
(c) Ctrl + I
(d) Alt + I
Answer:
(c) Ctrl + I
(iii) _______ command is used to restore database to original since the last COMMIT.
(a) REVIEW
(b) SELECT
(c) ROLLBACK
(d) None of these
Answer:
(c) ROLLBACK
(iv) ______ provides the physical connection between the network and computer workstation.
(a) LIC
(b) NIC
(c) NC
(d) None of these
Answer:
(b) NIC
(v) URL is the ______ for a website or a web page.
(a) web address
(b) website
(c) web page
(d) Both (a) and (c)
Answer:
(a) web address
(vi) How many types of views are available in the spreadsheet?
(a) 3
(b) 4
(c) 5
(d) 2
Answer:
(c) 5
3. Answer any 5 out of the given 6 questions
(i) Which tab of MS-Word contains the Shapes option?
(a) Home
(b) Review
(c) Insert
(d) Mailings
Answer:
(c) Insert
(ii) Digital information is converted into analog information by the modem at
(a) destination computer
(b) source computer
(c) Both (a) and (b)
(d) None of these
Answer:
(b) source computer
(iii) ______ is the indent, the paragraph except first line.
(a) Left indent
(b) Hanging indent
(c) Right indent
(d) None of these
Answer:
(b) Hanging indent
(iv) The default page orientation in spreadsheet is _______
(a) landscape
(b) horizontal
(c) portrait
(d) None of these
Answer:
(c) portrait
(v) The key field is a unique identifier for _______
(a) each column
(b) each record
(c) Both (a) and (b)
(d) None of these
Answer:
(b) each record
(vi) Every computer is protected by a ________
(a) firewall
(b) software
(c) server
(d) network
Answer:
(a) firewall
4. Answer any 5 out of the given 6 questions
(i) ______ is a GUI based software used in the windows environment.
(a) Word processor
(b) DOS
(c) Both (a) and (b)
(d) None of these
Answer:
(a) Word processor
(ii) ______ is referenced by a combination of row number and column letter.
(a) Data
(b) Work cell
(c) Cell
(d) Document
Answer:
(c) Cell
(iii) ______ leads to data inconsistency.
(a) Data integrity
(b) Data redundancy
(c) Data sharing
(d) Data recovery
Answer:
(b) Data redundancy
(iv) _______ is a computer program that provides services to other computer programs.
(a) Server
(b) Client
(c) Network
(d) None of these
Answer:
(a) Server
(v) Which of the following is not the main building block of a database?
(a) Lists
(b) Queries
(c) Reports
(d) Forms
Answer:
(a) Lists
(vi) Blog Desk is an offline blog editor which is used for _______ operating system.
(a) Linux
(b) Unix
(c) Windows
(d) None of these
Answer:
(c) Windows
5. Answer any 5 out of the given 6 questions
(i) _______ preview displays the page breaks as blue line.
(a) Break
(b) Page break
(c) Page
(d) None of these
Answer:
(b) Page break
(ii) The ________ alignment makes sure that none of the edges of text appear ragged.
(a) left
(b) right
(c) center
(d) justify
Answer:
(d) justify
(iii) Key field is a unique identifier for each record. It is defined in the form of
(a) rows
(b) columns
(c) tree
(d) query
Answer:
(b) columns
(iv) abc@mnc.co.in represents an ________
(a) MAC address
(b) URL
(c) E-mail address
(d) None of these
Answer:
(c) E-mail address
(v) The bar located at the top of the application window is called ________
(a) title bar
(b) status bar
(c) menu bar
(d) None of these
Answer:
(a) title bar
(vi) A web page is located using a
(a) Universal Record Linking
(b) Uniform Resource Locator
(c) Universal Record Locator
(d) Uniformly Reachable Links
Answer:
(b) Uniform Resource Locator
SECTION B: Subjective Type Questions
Question 6.
What are the basic principles of an effective communication?
Answer:
The most basic principle for a communication to be effective is that the intended message of the sender and the interpreted message of the receiver are one and the same. Although this should be the goal in any communication, it is not always achieved. Thus, a set of principles needs to be followed to ensure it. The most popular name of these basic principles is known as 7C’s of Effective Communication.
Question 7.
How nature walk does help to manage stress?
Answer:
Nature Walks means walking in the local park or similar such activity. These walks may be done more than once a day for short periods of time during which we indulge in ‘thought-stopping’, i.e. not to think about our day-to-day activities. Such an activity will help us to avoid ‘burn out’, promote adequate sleep, ease muscle tension and decrease mental worries.
Question 8.
Write the steps to insert header and footer.
Answer:
To insert a header or footer, follow these steps :
- Select the Insert button.
- Click either Header & Footer command. A drop-down menu will appear.
- From the drop-down menu, select Blank to insert a blank header & footer, or choose one of the built-in options.
- The Design tab will appear on the ribbon and the Header & Footer will appear in the document.
Question 9.
Define the following functions of an entrepreneur:
(i) Establishing relations with Government
(ii) Establishing contacts with Competitors
Answer:
(i) Establishing Relations with Government An entrepreneur must establish good relations with government and its functionaries. His functions are to obtain licences, payment of taxes, selling the product to government, provision for export-import etc.
(ii) Establishing Contacts with Competitors An entrepreneur must form contacts with the competitors to analyse the market. He must be in a position to make opportunities out of the given situation.
Question 10.
What are the long term solutions for sustainable development?
Answer:
Following are the long term solutions for sustainable development:
- Government should make policies against illegal activities.
- Awareness campaigns should be launched for farmers and industrialists.
- Ecology must be protected through imposition of taxes and fines.
- Practice of sustainable agriculture must be promoted such as permaculture, agroforestry, mixed farming, multiple cropping and crop rotation.
Question 11.
How to change the prefilled information?
Answer:
To change the prefilled information, follow the given steps:
- Select the Microsoft Office button.
- Click the Word Options button. The Word Options dialog box will appear.
- Enter the User name and/or Initials in the Personalise your copy of Microsoft Office section from Popular.
- Click OK button.
Question 12.
What do you mean by chart?
Answer:
A chart is a tool that is used in Excel for representing data graphically. Charts allow anyone to more easily see the meaning behind the numbers in the spreadsheet and to make showing comparisons and trends much easier. It is one of the most impressive features of MS-Excel.
Endless variations are available, allowing you to produce a chart, edit and format it, include titles and many more.
Question 13.
Write the steps to format the font size.
Answer:
Steps to format the font size of text are as follows:
- Select the text that you want to modify.
- Click the drop-down arrow next to the Font Size box in the Font group on the Home tab. The Font Size drop-down menu will appear.
- Move your cursor over the various font sizes. A live preview of the font size will appear in the document.
- Choose the Font Size that you want to use.
Question 14.
How to change the type of chart?
Answer:
To change the chart type, follow the given steps:
- Select the chart and click on the Design tab.
- In the Type group, click on the Change Chart Type command.
- Change Chart Type dialog box will appear. Select the type of chart, you want to use.
- Click on the OK button.
Question 15.
Explain the term modulator/demodulator.
Answer:
Modem is a device that converts digital signal to analog signal (modulator) at the sender’s site and converts back analog signal to digital signal (demodulator) at the receiver’s end, in order to make communication possible via telephone lines.
Question 16.
Define the following:
(i) Text data type
(ii) Memo data type
Answer:
(i) Text data type It allows to store text or combination of text and numbers as well as numbers that don’t require calculations such as phone number. This data type allows maximum 255 characters to store.
e.g. If Employee is a table and Emp_No, Name and Description are fields, then name will be a Text field. Because, Name is a character entry field.
(ii) Memo data type It allows long blocks of text that uses text formatting, e.g. In the Employee table, the field Description will be of Memo data type, because the length of description of employee may be large.
Question 17.
How to apply a picture style in a document?
Answer:
Steps to apply a picture style in a document are as follows:
- Select the picture.
- Click the Picture Tools Format tab.
- Click More drop-down arrow in Picture Styles group to display all the Picture Styles.
- However, when a cursor moves over different picture styles, the live preview of the style will be displayed on the picture in a document.
- Choose any style as per the requirement.
Question 18.
Define the following:
(i) Star topology
(ii) Web browser
Answer:
(i) In star topology, there persists a central node called server or hub, which is connected to the
nodes directly. If a node has to take information from other node, then the data is taken from that node through the central node or server.
(ii) Web browser is a software application that is used to locate, retrieve and display some content on the World Wide Web, including web pages. These are programs used to explore the Internet. It is an interface that helps a computer user to gain access over all the content on the Internet. We can install more than one web browsers on a single computer. The user can navigate files, folders and websites with the help of a browser.
Question 19.
Write the steps to sort more than one columns.
Answer:
To sorting more than one columns, follow the given steps:
- Select those cells, which you want to sort.
- Click on Sort & Filter option from Editing group in Home tab. By this, you will get a drop-down menu.
- From this menu, select Custom Sort option and then Sort dialog box will appear.
- Click on Add Level button and then select next column (which you want to sort).
- Click on OK button.
Question 20.
What are the disadvantages of DBMS?
Answer:
There are many advantages of database, but database also have some minor disadvantages. These disadvantages are as follows:
- Cost of Hardware and Software Through the use of a database system, new costs are generated due to additional hardware and software requirements.
- Complexity A database system creates additional complexity and requirements.
- Database Failures If database is corrupted due to power failure or it is corrupted on the storage media, then our valuable data may be lost or the system will stop working.
- Lower Efficiency A database system is a multi-user software, which is less efficient.
Question 21.
(i) Create a table CUSTOMER with following details:
| Column Name | Data Type |
| CustNo | Varchar(5) |
| Name | Char(20) |
| Address | Char(50) |
(ii) Consider the following table SummerCamp and write the queries (a) and (b).
Table: SummerCamp
| Child ID | First Name | Last Name | DOB | Gender | Group |
| 109 | Vedansh | Gupta | 30/06/10 | M | 2A |
| 214 | Mack | Tyagi | 09/12/08 | M | 1B |
| 115 | Aditi | Thakur | 13/04/09 | F | 1A |
| 108 | Vikrant | Chauhan | 02/02/09 | M | 2A |
| 141 | Swati | Saini | 06/05/10 | F | 2B |
| 233 | Vishakha | Tyagi | 01/08/10 | F | 3A |
| 274 | Madhur | Gupta | 06/03/10 | M | 3B |
(a) Write a command to insert a new record with the following values:
(105, ‘Shyam’, ‘Sharma’, 07/09/10, ‘M’, ‘1A’)
(b) Write a query to display all the record of table SummerCamp whose DOB between 02/02/09 and 06/03/10.
Answer:
(i) CREATE TABLE CUSTOMER (CustNo Varchar(5), Name Char(20), Address Char(50));
(ii) (a) INSERT INTO SummerCamp VALUES (105, ‘Shyam’, ‘Sharma’, 07/09/10, ‘M’, ‘1 A’);
(b) SELECT * FROM SummerCamp WHERE DOB BETWEEN 02/02/09 AND 06/03/10;