Students must start practicing the questions from CBSE Sample Papers for Class 10 Information Technology with Solutions Set 8 are designed as per the revised syllabus.
CBSE Sample Papers for Class 10 IT Set 8 with Solutions
Max. Time : 2 Hours
Max. Marks: 50
Section A
Objective Type Questions
Question 1.
Answer any 4 out of the given 6 questions on Employability Skills. (1 × 4 = 4 Marks)
(i) Which of the following is not an operating system.
(a) Android
(b) Windows
(c) AVG
(d) Linux
Answer:
(c) AVG
(ii) Self confidence is a quality which develops due to ………………
(a) Self-monitoring
(b) Self-Regulation
(c) Self-awareness
(d) All of these
Answer:
(c) Self-awareness
(iii) Suhas works as an app developer in an IT company. His manager appreciates his work and always keeps on telling him that he has one quality which can make him a good entrepreneur.
= Which among the following can be that quality?
(a) Innovative and open minded
(b) Good looking
(c) Well Educated
(d) All of these
Answer:
(a) Innovative and open minded
(iv) Rajendra Singh is a Sub Inspector in UP Police. His job forces him to deal with various types of criminals on regular basis. Sometimes he is very stressed out from his routine work. What among the following can be done to release his stress?
(a) Healthy diet and life style
(b) Meditation
(c) Positive thinking and outlook
(d) All of these
Answer:
(d) All of these
(v) The shortcut key used to create a duplicate copy of file is ………………
(a) Ctrl + X
(b) Ctrl + C
(c) Ctrl + V
(d) Ctrl + U
Answer:
(b) Ctrl + C
(vi) Ramesh owns a showroom of electronic items. Sharad, his friend, owns a small shop of home appliances. Sharad does not call himself an entrepreneur. What type of misconception is this?
(a) Every business idea needs to be unique or special.
(b) Entrepreneurs are bom, not made.
(c) A person needs to have a big business to be called an entrepreneur.
(d) It is not a misconception
Answer:
(c) A person needs to have a big business to be called an entrepreneur.
Question 2.
Answer any 5 out of the given 6 questions. (1 × 5 = 5 Marks)
(i) ……………… styles impact the structure of the document.
(a) Character
(b) Page
(c) Paragraph
(d) Frame
Answer:
(b) Page
(ii) A template is a blue print to create ………………
(a) Table
(b) Table of contents
(c) Styles
(d) Another document
Answer:
(d) Another document
(iii) ……………… refers to a range of cells.
(a) Row
(b) Column
(c) Cell reference
(d) Formula
Answer:
(c) Cell reference
(iv) ………….. is a storage container which stores data that belongs to a simple object, subject or purpose.
(a) Database
(b) Table
(c) Record
(d) Field
Answer:
(b) Table
(v) ……………… option in Windows 10 is used to turn off animations and background images.
(a) Narrator
(b) Closed captioning
(c) Magnifier
(d) Other options
Answer:
(d) Other options
(vi) ……………… is a group of computers that are connected in small area with the help of some cables.
(a) LAN
(b) WAN
(c) VAN
(d) RCN
Answer:
(a) LAN
Question 3.
Answer any 5 out of the given 6 questions. (1 × 5 = 5 Marks)
(i) Which function cannot be performed through Subtotal in a Spreadsheet?
(a) Sum
(b) Product
(c) Average
(d) Percentage
Answer:
(a) Sum
(ii) Sarita is a poet. She wants her poems to reach the right people . For this she wants to start writing a blog. Which of the following sites can be used for the same?
(a) Blogger
(b) Word Press
(c) Type Pad
(d) All of these
Answer:
(d) All of these
(iii) The description column in Table Design view is used to ………………
(a) Define data type for each field.
(b) Describe data to be stored in each field.
(c) Describe criteria for storing data in the field.
(d) None of these
Answer:
(b) Describe data to be stored in each field
(iv) Consider the hyperlink-D:\Users\ DocumentsVmysheetxlsx. Identify the type of this document hyperlink.
(a) Absolute
(b) Relative
(c) Fixed
(d) None of these
Answer:
(a) Absolute
(v) The final document produced after mail merge is called ………………
(a) Main document
(b) Data source
(c) Merged document
(d) Merge field
Answer:
(c) Merged document
(vi) Rohit has created 6 worksheets, in a single workbook, for each month for the sale of products
in his shop. To check the half yearly sales, he needs to prepare a single worksheet. Which out of the following features will be helpful for him? ‘
(a) Goal Seek
(b) Consolidate
(c) Solver
(d) Macro
Answer:
(b) Consolidate
Question 4.
Answer any 5 out of the given 6 questions. (1 × 5 = 5 Marks)
(i) Why Styles are used in the document?
(a) It maintains consistent formatting
(b) Formatting changes in complete document is easy
(c) The formatting is done very fast
(d) All of these
Answer:
(d) All of these
(ii) In a worksheet, while performing consolidation, if same data range is selected from multiple worksheets, then consolidation is done by
(a) Applying Average function on the range.
(b) Copying data below the selected range.
(c) Replacing data from the selected range.
(d) Applying Sum function on the range.
Answer:
(d) Applying Sum function on the range.
(iii) While creating a table in DBMS, which of the following is considered optional?
(a) Field Name
(b) Description
(c) Data Type
(d) Field size
Answer:
(b) Description
(iv) The structure of a table, once created, can be changed using ……………… SQL command.
(a) UPDATE
(b) SET
(c) MODIFY
(d) ALTER TABLE
Answer:
(d) ALTER TABLE
(v) Which of the following is not a type of blog?
(a) Macro
(b) News and views
(c) Personal
(d) Company
Answer:
(a) Macro
(vi) Saumya wants to use network banking for some transactions. She forgot the site address and searched it on Google. The search list is showing three websites with different starting symbols. Which of the following symbol should be in the beginning of URL?
(a) HTTPS
(b) FTP
(c) HTTP
(d) Any of these
Answer:
(a) HTTPS
Question 5.
Answer any 5 out of the given 6 questions. (1 × 5 = 5 Marks)
(i) To insert a downloaded image from Google into a document ……………… option of word processor is used.
(a) Drawing objects
(b) Pictures
(c) Any of these
(d) None of these
Answer:
(b) Pictures
(ii) To connect the data in form of HTML page, which of the following should be done?
(a) Copy and paste the data in a workbook.
(b) Create a document hyperlink for the HTML document.
(c) Create link for the required components using link to external data.
(d) All of these
Answer:
(c) Create link for the required components using link to external data.
(iii) When a primary key contains more than one field, it is called ……………… key.
(a) Alternate
(b) Foreign
(c) Candidate
(d) Composite
Answer:
(d) Composite
(iv) ……………. is arranging data in order.
(a) Filtering
(b) Sorting
(c) Reporting
(d) Querying
Answer:
(b) Sorting
(v) SQL sands for ………..
(a) Structured Query Language
(b) Simple Query Language
(c) Structured Quick Language
(d) Simple Quick Language
Answer:
(a) Structured Query Language
(vi) Which of the following impairments effects the computer usage?
(a) Speech
(b) Vision
(c) Mobility
(d) All of these
Answer:
(d) All of these
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.
There are some myths about Entrepreneurship. Mention any four of them.
Answer:
Myths regarding entrepreneurship are as follows:-
- Every Business Idea Needs to be Unique or Special : A person can take an existing idea in the market and do something different with it
- A Person Needs a lot of Money to Start a Business : Entrepreneurship is about passion, commitment and execution of idea. Money related problems can be solved by funding, debts, loan, investors etc.
- Entrepreneurs are Born Talented : Entrepreneurship starts with thinking of an idea that you want to work on and making it different. A person who is self-aware and can develop certain qualities can become an entrepreneur.
- It is an Easy Way to Get Rich : Entrepreneurship does not mean making quick money. It needs patience and time to make a business successful. Sometimes the venture results into failure.
Question 7.
Define organisational skills. Name some of the organisational skills.
Answer:
Organizational skills are the skills of using the available resources efficiently and effectively. Being organized refers to managing time, energy and workspace well and completing all the assigned tasks successfully. Organizational skills can vary depending on a particular workplace and job title, but they typically involve maintaining an orderly workspace, meeting deadlines and communicating well with the team.
Types of organizational skills are: Time management, Communication, Setting goals, Self-motivation, Decision-making and Strategic planning.
Question 8.
Explain ‘M’ in SMART.
Answer:
SMART is an acronym in which M stands for Measurable which means that the goals should have clear criteria for measuring the progress towards the achievement of goals. The measure of an objective can be qualitative and quantitative. Measuring the goals, ’makes it easier to track the progress.
Question 9.
What is the importance of time management?
Answer:
Time management is important due to following benefits:-
- It helps us to prioritize the tasks and allot required time to complete the task.
- Properly scheduling the time helps in completing the work in due time.
- Good time management gives us enough time to accomplish the tasks. This helps in reducing the stress levels.
- Timely accomplishment of tasks ensures the confidence and effciency of workforce.
- Time management also improves the performance of workforce.
Question 10.
Briefly explain the terms:
(A) Worms (B) Trojan Horse
Answer:
(A) Worms : Worms is a type of computer virus that does not modify the program like virus does. Its main objective is to eat the system resources. It replicates itself more and more and slows down the computer system.
(B) Trojan : A Trojan Horse is also a type of malware which uses fake names to mislead users from its true intent and execute them. Trojan Horses generally gets installed on the system as legitimate and useful software and gives unauthorised access and control of the system to the hackers.
Answer any 4 out of the given 6 questions in 20-30 words each (2 × 4 = 8 Marks)
Question 11.
Differentiate between a web server and a web client.
Answer:
Webserver | Web Client |
A web server is a computer that serves web pages, web sites or web services. | A web client is a user program thatconnects to a server to access a service. |
It receives requests from the client computer, processes and sends the output. | It sends requests to the web server and uses the services provided by the server. |
Question 12.
What do you understand by the following:
(a) Magnifier (b) Speech recognition
Answer:
(a) Magnifier : Magnifier is a tool of Windows that makes the part of computer screen or an entire computer screen bigger. Using this tool the images and words can be seen better. This tool is an accessibility feature for people with low vision impairments.
(b) Speech Recognition : Speech recognition is a tool of windows that identifies the words spoken aloud and then convert them into readable text. People who are visually impaired can use this tool to type text by speaking the words and sentences to the system.
Question 13.
When would you create a link to data in external worksheet.
Answer:
When you are working on multiple worksheets, there would be a situation when you would like to use data of one sheet into another. Linking will dynamically pull data from one sheet to another. It will also update the data in your destination sheet whenever you change the contents of a cell in your source sheet.
Question 14.
Write differences between a flat file database and a relational database.
Answer:
Flat File Database | Relational Database |
In flat file database all data is stored in a single table. | In relational database the data is stored in multiple tables. |
There is no linking between data. | The data in one table is linked to data in another table. |
Cannot avoid data redundancy. | Data redundancy does not take place in RDBMS |
Question 15.
What are Clip arts? List any two websites that offer free clipart.
Answer:
Clip art is a collection of pictures or images that can be imported into a document or another program
websites that offers free clip arts:
https://www.mycutegraphics.com/
https://www.graphicsfactory.com/
Question 16.
Differentiate between goal seek and solver.
Answer:
Goal Seek | Solver |
Goal seek is used on single variable. | Solver can solve equations that use multiple variables. |
It allows to vary the values only in one cell. | It allows values to vary in 200 cells. |
Answer any 3 out of the given 5 questions in 50-80 words each (4 × 3 = 12 Marks)
Question 17.
Jaskeerat is a smart worker. He keeps on updating his knowledge and uses it to uplift his ‘ work practices. As a data entry operator, he has to perform similar tasks on a group of worksheets.
(A) How will Macros help him to do his work faster?
(B) Using his programming skills, he wants to make some changes in macro that he has created. How can he do it?
(C) How can he write a macro as a function?
(D) How are keystrokes stored in a macro?
Answer:
(A) Macros are used to record the sequence of commands or keystrokes and save it for later use. These automate the repetitive keystrokes and tasks and thus reduces time spent in repetitive tasks and makes the work faster.
(B) To make changes in Macro he first needs to open the code of macro which he has created using the Macro dialog box. It will display the code of Macro in the editing window, where he can edit the code as needed.
(C) To use the macro code as a function the code is written between the clauses Function and End Function.
E.g., Function Dept( ) Dept()= “Production”
End Function
(D) Calc internally creates equivalent commands for the recorded keystrokes and stores in a programming code. These codes are stored inside Sub and End Sub clauses
Question 18.
Vinay has to prepare a sales report in which he has added some images. The size of the image is too large so he wants to resize the image?
(A) Which option of word processor will change the size of image from both the dimensions?
(B) Which tool he should use to keep the image in the centre of the text?
(C) He wants to keep the image in the background with a transparent effect on it. Which tool should he use?
(D) He wants to give a title to his report. Which tool offers artistic style of text?
Answer:
(A) You can resize an image using sizing handles. If comer sizing handles are used, then the image will be resized from both the dimensions. You can also resize the image from the menu. While resizing the image from the menu click on “Keep image size” or “Keep Ratio” option in word processor. This will maintain the ratio while changing the size of the image.
(B) To place the image between text, you can use Text Wrapping features. There are many options, e.g., behind. After, top/ bottom etc.To place the image in the center of the text click on “Wrap through” option in Text Wrap settings.
(C) The image can be made transparent and kept in the background of the text. To perform this you have to change the Color Mode of the image. By changing the Color Mode to Watermark the image will be totally transparent that and will give the background effect with text placed on it.
(D) The decorative text can be added using Text Art/ Word Art feature of the word processor. This feature creates shadowed, skewed, rotated and stretched text in variant colours.
Question 19.
Given below is the structure of a table named Library:
MemID | CHAR(7) |
MemName | VARCHAR(25) |
BookID | CHAR(7) |
IssueDate | DATE |
Return | CHAR(1) |
(A) What is the difference between Char and Varchar?
(B) Write SQL queries to:
(a) Create the table Library with Primary key MemID and the default value of Return as “N”.
(b) Add record with given details (“Ml01”, “Manya Gupta”, “B1151”, “2022-09-06”, “N”)
(c) Change the value of Return as “Y” in the record of “Manya Gupta”.
Answer:
(A) A CHAR is a fixed length string data type, while VARCHAR is variable length string data type. In CHAR data type. If the length of the string is less than fixed length then it is padded with extra blanks while, in VARCHAR, If the length of the string is less than the fixed length then it will store as it is without padded with blanks.
(B) (a) CREATE TABLE Library (MemID Char(7) PRIMARY KEY,
MemName VARCHAR(25), Book ID CHAR (7)
IssueDate DATE,
Return CHAR(l) DEFAULT “N”) ;
(b) INSERT INTO Library VALUES (“M101”, “Manya Gupta”, “BU51”, “2022-09-063, “N”);
(c) UPDATE Library SET Return =”Y” WHERE MemName= “Manya Gupta”;
Question 20.
Mohan is a shoe manufacturer and also runs his factory outlets. The company uses databases to maintain the sales records of their product. The data operator who enters the records of daily sales does not know how to work on tables in datasheet view.
(A) What can be the other way to enter and modify the records in database?
(B) The manager of the company wants to see the sales of last month. Which feature will be helpful to view records for the same?
(C) The manager wants the hard copy of sales for present month. Name the feature to perform this.
(D) What is the difference between a Query and Report?
Answer:
(a) Form view can also be used to enter and modify records in database. It is an interactive
screen which allows user to work on single record at a time.
(b) To view records based on a particular condition, queries are used in database.
(c) To print the records, database provides Reports feature. Reports are the effective way to print records in formal and formatted way.
(d) A query is a question which is defined and sent to the table or data source to retrieve the data, whereas, a report is an organized and formatted view of the data retrieved by a query. A report is generally a printed form of a query.
Question 21.
Suhail uses Internet for his School Project but he is not aware of security issues regarding the Internet. Help him by solving the following queries.
(A) What is a secure connection?
(B) How you can recognize a secured connection?
(C) Suggest any two security measures to ensure safety from online threats.
(D) What is Firewall?
Answer:
(A) A secure connection is one that is designed to protect data sent between two computers through the internet. It ensures the confidentiality of information and also that the data is made accessible only to authorized users.
(B) A URL or web address that contains HTTPS and a pad lock sign is considered to be a secured connection.
(C)
• Use strong passwords because strong passwords are not easy to hack and’avoids unauthorisd entry to your account.
• Control access to data and systems by giving authorization. This can be done by providing login ids and password to authorized users.
• Put up a firewall. A firewall is a security wall in form of software that checks and prevents malicious software to enter into system.
(D) A firewall is a software for network security that controls incoming and outgoing network traffic and permits or blocks data packets based on security.