Students can access the CBSE Sample Papers for Class 10 IT with Solutions and marking scheme Set 8 will help students in understanding the difficulty level of the exam.
CBSE Sample Papers for Class 10 IT Set 8 With Solutions
Time Allowed: 2 Hours
Maximum Marks: 50
General 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.
- Maries 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 (24 marks)
Question 1.
Answer any 4 out of the given 6 questions on Employability Skills.
(A) Which of the following is not a type of feedback? [1]
(a) Positive feedback
(b) Negative feedback
(c) No feedback
(d) None of the above
Answer:
(d) None of the above
Explanation:
Feedback is important in letting your employees know how they are doing. There are three types of feedback: positive, negative and no feedback.
No feedback is technically not a type of feedback, as it is the absence of feedback.
(B) In SMART goals, what does “A” stands for? [1]
(a) Artificial
(b) Aim
(c) Alignment
(d) Achievable
Answer:
(d) Achievable
Explanation:
SMART is an acronym that stands for specific, measurable, achievable, realistic, and time bound. The goals should be achievable in a specific time frame.
(C) Neha works hard to get the best student award at the end of the year. What type of motivation is this? [1]
(a) Internal
(b) External
(c) Both (Internal & External)
(d) None of the above
Answer:
(b) External
Explanation:
The motivation which is attained from the source outside yourself is called external motivation. Punishment, reward, promotion, and criticism are examples of external motivation.
Love, joy, fear, and passion, are examples of internal motivation.
(D) Which of the following shortcut keys is used to select all content of a file? [1]
(a) Ctrl + A
(b) Ctrl + X
(c) Ctrl + V
(d) Ctrl + Y
Answer:
(a) Ctrl+A
Explanation:
Ctrl+A when pressed together, selects all the context of a file or document.
The keyboard shortcut for copying is Ctrl+C, for cutting is Ctrl+X and for pasting is Ctrl+V.
(E) __________ means a product or service that people want. [1]
Answer:
Demand
Explanation:
Entrepreneurs identify the need or demand of the market and build a product or service for it.
(F) Full form of SDGs is _________. [1]
Answer:
Sustainable Development Goals.
Explanation:
The Sustainable Development Goals (SDGs) are a universal call to action to end poverty, protect the planet, and ensure that all people enjoy peace and prosperity.
Question 2.
Answer any 5 out of the given 6 questions.
(A) ________ includes margins, headers and footers, borders and backgrounds. [1]
(a) Page style
(b) Paragraph style
(c) Character style
(d) Frame style
Answer:
(a) page style.
Style is a named collection of various formatting features that defines the looks and behavior of various components of a document, associated with the style.
(B) _________ is used to format graphic and text frames, including wrapping type, borders and backgrounds. [1]
(a) Paragraph style
(b) Cell style
(c) Frame style
(d) Character style
Answer:
(c) Frame style
Explanation:
Frame styles are used to format graphic and text frames, including wrapping type, borders, backgrounds, and columns.
A character is collection of character formatting attributes, while paragraph style includes both character and paragraph formatting attributes.
(C) _________ refers to the vertical or horizontal placement of a graphic in relation to the chosen anchor point. [1]
(a) Arrangement
(b) Anchoring
(c) Text wrapping
(d) Alignment
Answer:
(d) Alignment
Explanation:
Alignment refers to the vertical or horizontal placement of an image while arrangement controls how image are placed upon each other. Arrangement options are- Bring to front, Send to back, etc.
(D) A/An __________ is a model that you use to create other documents. [1]
(a) page
(b) template
(c) format
(d) anchoring
Answer:
(b) Template
Explanation:
A template is a pre-formatted document designed to create frequently used documents such as revenue letters, fax, etc. Templates help simplify the process of document creation and formatting.
(E) Character style is used to format graphics and text frames. (True/False) [1]
Answer:
False
Explanation:
You can format graphics and text frames using frame style these are also used to format borders, wrapping type, background and columns.
(F) _________ refers to the reference point for the graphic. [1]
(a) Alignment
(b) Anchoring
(c) Arrangement
(d) Text wrapping
Answer:
(b) Anchoring
Explanation:
In word processors, an anchor symbol is used to indicate that an image is tied to the text at a specific point in your document which means that if the text is moved, the image, which is anchored with that text will also move.
Question 3.
Answer any 5 out of the given 6 questions.
(A) A/An __________ link will stop working only if the target is moved. [1]
Answer:
Absolute link
Explanation:
An absolute link defines the path of the file from the topmost folder. Whereas the relative link tells the path of a document with respect to the current active document. Therefore, if two spreadsheets are in the same folder linked to each other and the entire folder is moved to a new location, then the relative link will not break the link but the absolute link will not work.
(B) Which of the following options is not available in hyperlink dialog box? [1]
(a) Internet
(b) Document
(c) New document
(d) Download
Answer:
(d) Download
Explanation:
The hyper Link dialog box consists of following options:
- Edit Hyperlink
- Open Hyperlink
- Copy Hyperlink
- Remove Hyperlink
(C) You can access a variety ________ of and other data sources and link them into Calc worksheets. [1]
Answer:
Databases
Explanation:
Calc allows linking of files from external sources such as HTML files, MS Excel files, CSV file, etc.
To link external data use insert ->Link to External data.
(D) A macro is a saved sequence of commands or keystrokes that are stored for later use. (True/False) [1]
Answer:
True
Explanation:
In Spreadsheet, macros are referred to a named, recorded and saved sequence of keystrokes. These are very useful to repeat similar set of actions.
(E) The file name extension of OpenOffice database is .odb. (True/False) [1]
Answer:
True
Explanation:
The .odb file extension is most commonly associated with the OpenOffice database application.
(F) We can arrange our data in ascending or descending order with the help of __________. [1]
Answer:
Sorting
Explanation:
Sorting is the process of arranging data in ascending or descending order. In OpenOffice sorting feature can be accessed by clicking on Data tab-> Sort and File groups Sort.
Question 4.
Answer any 5 out of the given 6 questions.
(A) A ___________ is an organized collection of data. You can visualize it as a container of information. [1]
Answer:
Database
Explanation:
A database is a collection of interrelated data. This data is organized in a systematic manner in form of tables.
Database management System(DBMS) is a program that efficiently manages a database.
(B) Which one of the following options is different from the other options? [1]
(a) Columns
(b) Attributes
(c) Tuples
(d) Fields
Answer:
(c) Tuples
Explanation:
In a table, rows are known as tuples while columns are referred to as fields or attributes.
(C) In this relationship, both the tables must have primary key columns. [1]
(a) One-to-many
(b) One-to-one
(c) Many-to-many
(d) None of the above
Answer:
(b) One-to-One
Explanation:
In One-to-One relationship, each record of first table can have only one matching record in second table and record in second table can have only one matching record in first table.
(D)________ data types are used for describing numeric values for the field used in the table of a database. [1]
Answer:
Numeric
Explanation:
Tinyint, Smallint, integer, and Bigint are numeric data types to store integer values. Real, float or double datatypes are used to store real values.
(E) A ___________ is a set of data values of a particular simple type, one for each row of the table. [1]
Answer:
Column
Explanation:
A column in a table is a set of similar datatypes. A column is also called attribute or field.
(F) Which of the following is/are the advantage of database? [1]
(a) Recovery
(b) Backup
(c) Data security
(d) All of the above
Answer:
(d) All of the above
Explanation:
A DBMS provides backup and recovery features that enable organizations to recover damaged or lost data. It also ensures data security by giving authorization feature to access data.
Question 5.
Answer any 5 out of the given 6 questions.
(A)_________ is an accessibility feature that assists people that have difficulty using a keyboard or a mouse (or both). [1]
(a) Toggle key
(b) Filter key
(c) Sticky key
(d) Serial key
Answer:
(d) Serial key
Explanation:
The serial key accessibility feature allows user to use special devices such as sip, puff, and breath switches to provide input to the computer through serial ports.
(B) __________ is an accessibility function which is designed for people who have vision impairment or cognitive disabilities. [1]
(a) Toggle key
(b) Filter key
(c) Sticky, key
(d) Serial key
Answer:
(a) Toggle key
Explanation:
Toggle key accessibility feature which is designed for visually impaired people. When toggle keys are on, the computer provides sound cues, when the locking keys Capslock, Numlock or Scrolllock are pressed.
(C) Full form of ISP is __________. [1]
Answer:
Internet Service Provider.
Explanation:
An internet service provider (ISP) is an organization that provides services for accessing, using, managing, or participating in the Internet.
BSNL AirteL MTNC, and Reliance are some examples of ISP.
(D) Which of the following is not a wireless technology? [1]
(a) DSL
(b) 3G
(c) WiMAX
(d) WiFi
Answer:
(a) DSL
Explanation:
DSL is a network technology that user existing telephone lines to transit high bandwidth data. The subscribers has to use modern to connect their computer to this type of network.
(E) Mouse key is an accessibility feature that assists people who have difficulty using a mouse. (True/False) [1]
Answer:
True
Explanation:
Mouse key is an accessibility feature that uses the keyboard’s numeric keypad as a pointing device. It replaces the mouse as a pointing device for the people who have difficulty in using mouse.
(F) To create a strong password, we should use numbers, capital and small letters and some symbols (if allowed). (True/False) [1]
Answer:
True
Explanation:
It is always recommended to secure your online accounts and data with a good password. A good password is one which is longer and is a mix of uppercase, lowercase letters with numbers and other symbols.
Section – B (26 Marks)
Answer any 3 out of the given 5 questions on Employability Skills
Answer each question in 20 – 30 words.
Question 6.
What do you mean by visual communication? [2]
Answer:
Visual communication design is the process of using visual elements to convey ideas, information, and data. Visual elements can encompass photos, videos, graphs, typography, charts, maps, illustrations, and so much more.
Question 7.
Wht is ‘self-motivation’? [2]
Answer:
Self motivation is referred to as an inner drive that leads us to take actin towards a goal. It is the ability to do things on your own.
Question 8.
Define worm. [2]
Answer:
Worm is a type of malicious code that enters into a computer through external source. Its primary function is to replicate itself and passes to other computers to infect them.
Question 9.
Define entrepreneurship. [2]
Answer:
Entrepreneurship is the process of running a business or a startup venture using a new idea. It is about identifying and working towards fulfilling the needs of society.
Question 10.
What do you mean by organic farming? [2]
Answer:
Organic farming is a system which avoids or largely excludes the use of synthetic inputs (such as fertilizers, pesticides, hormones, feed additives etc) and to the maximum extent feasible relies upon crop rotations, crop residues, animal manures, off-farm organic waste, mineral grade rock additives and biological system of nutrient mobilization and plant protection.
Answer any 4 out of the given 6 questions in 20-30 words.
Question 11.
What do you understand by styles? [2]
Answer:
Style is a set of formatting characteristics that you can apply on different text components of a word orocessor such as tables, paragraphs, lists etc. Usually, a word processor has following types of styles: (a) Character style (b) paragraph style (c) frame style (d) page style (e) list styles
Question 12.
Define cell reference. [2]
Answer:
Cell reference in a spreadsheet refers to the value of different cell or cell range on the current or different worksheet. Cell reference are two types: Absolute reference and relative reference.
Question 13.
Differentiate between relative and absolute hyperlink. [2]
Answer:
Relative Hyperlink | Absolute hyperlink |
A relative hyperlink defines path of a document respect to the current or active document. | An absolute hyperlink path of the file from the topmost folder |
If the file is moved this link will not break. | It will stop working if the target is moved. |
Question 14.
Define RDBMS. [2]
Answer:
RDBMS stands for Relational Database Management System. It refers to the software that handles multiple linked tables called relational databases. It is used to store, manage, query, and retrieve data stored in Relational Database.
For Example:
MYSQL, MSAccess, OpenOffice Base etc
Question 15.
What is client-server architecture? [2]
Answer:
Client -Server architecture is a type of computer network in which each computer has a fixed or designated role. It may either serve as client or as server. Once the role is assigned, the computer cannot switch it.
Question 16.
What do you mean by high contrast? [2]
Answer:
The high contrast is an accessibility feature of Windows. It is built for people with vision impairment. This feature uses a limited colour pallet with contrasting colours to make an interface easier to uses for visually impaired people.
Answer any 3 out of the given 5 questions in 50-80 words. (4 × 3 = 12)
Question 17.
Write down the process for resizing an image. [4]
Answer:
Steps to resize an image in a word processor are as follows:
- Select the image by clicking on it. The image will be selected with sizing handles around it.
- Position the pointer over any one of the sizing handle. The pointer shape will change to a double headed arrow.
- Drag the sizing handles to increase/decrease the image size.
- Release the mouse button when desired size is achieved.
Question 18.
How can an original and edited worksheet be compared? [4]
Answer:
To compare worksheets, you must have both the worksheets – original and the edited one.
Follow the given steps to compare them:
- Open the edited worksheet that you want to compare with the original worksheet.
- Select Edit -> Compare Document.
- An open worksheet dialog appears.
- Select the original worksheet and click Insert.
- Calc finds and marks the changes as:
- Inserted: The data that occurs in the edited worksheet but not in the original one.
- Deleted: The data that is in your original worksheet but is not in the edited worksheet.
- Changes: The data that is changed.
Question 19.
What do you mean by relationship? Explain the different types of relationships. [4]
Answer:
In DBMS, relationships refer to the connection between one or more tables through a common field. Three types of relationships can be formed in a database. These are as follows:
- One-to-One: In this type of relationship, each record in the first table can have only one matching record in the second table, and in the second table each record can have only one matching record in the first table.
- One-to-Many: In this type of relationship, a record in the first table can have many matching records in the second table, however a record in the second table can have only one matching record in the first table.
- Many-to-Many: In this type of relationship, each record in the first table have many matching records in the second table and a record in the second table can have many matching records in the first table.
Question 20.
Write short notes on the following: [4]
(A) Privacy
(B) Data Consistency
Answer:
(A) Privacy: Privacy is the protection of personal information given online. It is the branch of data security that deals with the proper handling of data. The data privacy is all about how data is shared with third parties.
(B) Data Consistency: Data consistency refers to the multiple copies of same database. The same database appears consistently among all the users at a time.
Question 21.
State any four rules or etiquettes to be followed while chatting on the Internet. [4]
Answer:
Rules or etiquette to be followed while chatting on the Internet:
- Always begin your conversation with short greeting.
- You should avoid the frequent use of abbreviations.
- Always avoid use of Caps Lock in chatting, as Caps Lock is equivalent to shouting.
- Be patient when someone is typing.
- Avoid doing long conversations.
- Always end your conversation with a short closing like “Bye”, “Take Care” etc.