Students can access the CBSE Sample Papers for Class 10 IT with Solutions and marking scheme Set 9 will help students in understanding the difficulty level of the exam.
CBSE Sample Papers for Class 10 IT Set 9 With Solutions
Time Allowed: 2 Hours
Maximum Marks: 50
General Instructions:
Read the following instructions very carefully and strictly follow them:
(a) This question paper consists of two sections viz.
Section A: Employability Skills and Section B: Subject Skills.
(b) SECTION A: EMPLOYABILITY SKILLS (10 MARKS)
(i) Answer any 4 questions out of the given 6 questions of 1 mark each.
(ii) Answer any 3 questions out of the given 5 questions of 2 marks each
(c) SECTION B: SUBJECT SKILLS (40 MARKS)
(i) Answer any 10 questions out of the given 12 questions of 1 mark each.
(ii) Answer any 4 questions out of the given 6 questions of 2 marks each.
(iii) Answer any 4 questions out of the given 6 questions of 3 marks each.
(iv) Answer any 2 questions out of the given 4 questions of 5 marks each.
(d) This question paper contains 39 questions out of which 27 questions are to be answered.
(e) All questions of a particular part/section must be attempted in the correct order.
(f) The maximum time allowed is 2 hours
Section – A (10 marks)
(Employability Skills)
Answer any 4 questions out of the given 6 questions
Question 1.
…………….. are a group of words that work together to communicate an element of speech. [1]
Answer:
Phrases
Explanation:
A phrase is a group of words that works together in a sentence but does not contain a subject or a verb.
Question 2.
…………….. refers to focusing human efforts for maintaining a healthy body and mind capable of better withstanding stressful situations. [1]
Answer:
Stress management
Good stress or eustress inspires and motivates you and enhances the performances whereas bad stress or distress can lead to anxiety, confusion and poor concentration.
Question 3.
Having conscious knowledge of your own self, capabilities, feelings and one’s own character is called as …………….. [1]
Answer:
Self awareness
Self awareness has following advantages:
- Able to manage and regulate emotions.
- Increases self confidence.
- Improves leadership skills.
- Improves decision making skills.
Question 4.
A …………….. is a software that helps you type and work with text on a computer, (word processor / spreadsheet / calculator) [1]
Answer:
Word processor
Apache OpenOffice and Libre OpenOffice are examples of open source word processor whereas MS-word is a proprietary software.
Question 5.
Entrepreneurs are not job seekers but they create opportunities of employment for people. (True/False) [1]
Answer:
True
Entrepreneurship has many advantages. Some of them are as follows:
- It allows to work in flexible schedule.
- Entrepreneurs are autonomous and are responsible for their own business.
- It improves standard of living of complete society.
- It gives sense of pride and fulfillment.
- A right business idea and execution plan can make more profit their salary.
Question 6.
…………….. defines a Green economy as one that results in “improved human well¬being and social equity, while significantly reducing environmental risks and ecological scarcities”. [1]
Answer:
UNEP (United Nations Environment Program)
A green economy is defined as low carbon, resource efficient and socially inclusive.
Answer any 3 questions out of the given 5 questions
Question 7.
Explain four types of sentences in English. [2]
Answer:
The four types of sentences in the English language are: declarative, exclamatory, imperative, and interrogatory.
- Declarative or Assertive Sentence: It is informative and ends with a period or a full stop. For example, I like fantasy novels.
- Imperative Sentence: it expresses a command, an order, or a request. For example, Please pick up the notes when you come.
- Interrogative Sentence: It is used to question something and it ends with a question mark. For example, What is the name of the movie you were watching?
- Exclamatory Sentence: It is used to express sudden and strong emotions, and it ends with an exclamation mark. For example, Wow, how good this is!
Question 8.
List any four characteristics of entrepreneurship. [2]
Answer:
The characteristics of entrepreneurship are as follows:
- Risk taking: Entrepreneurs are capable of taking risks for long term advantage.
- Decisive and action oriented: Entrepreneurs have ability of making quick decisions taking actions and making corrections.
- Vision: They have a vision for themselves and their company and their plans are always in direction to fulfill their vision.
- Creativity: Entrepreneurs are highly creative and are always open to new ideas.
Question 9.
Write steps to highlight text in an Open Office Writer. [2]
Answer:
Select the text which you want to highlight and Press Ctrl+B.
Question 10.
List any two factors that affect self-confidence. [2]
Answer:
Factors that affect self confidence are as follows:
- Friend and family.
- Childhood.
- Work environment.
- Media.
Question 11.
List any four factors causing ecological imbalance. [2]
Answer:
The various factors causing ecological imbalance are as follows:
- Destruction of forests /Deforestation
- Industrialization/ Factories
- Large scale use of pesticides
- Degradation of land / Soil erosion
- Faulty utilization of water resources
- Pollution
- Population/Over population (Any four)
Section – B (40 marks)
(Subject Skills)
Answer any 10 questions out of the given 12 questions
Question 12.
When a combination of hardware and software enables a person with a disability or impairment to use a computer, it is known as [1]
(a) Mechanical assistance
(b) Assertiveness
(c) Assistive Technology
(d) Assistance and communication
Answer:
(c) Assistive technology
Some of the examples of assistive technology are:
(1) Screen readers
(2) Screen magnification software
(3) Speech input software
(4) Motion tracking or eye tracking devices.
Question 13.
…………….. in Control Panel are used to customize the way your keyboard, display, or mouse function. [1]
Answer:
Ease of Access
Explanation:
The ease of access comprise of various settings that can make windows computer easier to use. For eg, you can adjust your screen settings keyboard settings, personalize your desktop, etc.
Question 14.
Picture and Clipart options are available under …………….. [1]
Answer:
Insert
Explanation:
The Insert menu of word processor consists of various items that you may want to insert into a document, such as table, charts, symbols, shapes, header, and footer etc.
Question 15.
Header option is available under …………….. group in Insert Tab. [1]
Answer:
Header and footer
A header is a text (title, page number etc) that you place at the top of each page. While footer is placed at the bottom of each page in a document
Question 16.
…………….. is one of the functions available in the spreadsheet to perform addition of selected numbers in the sheet. [1]
Answer:
Sum
A function is a predefined formula that performs calculations using specific values in a particular order.
Question 17.
Autosum automatically selects the values around the cells either …………….. or …………….. [1]
Answer:
Horizontally, Vertically or Rows or columns.
Auto Sum is an option to quickly calculate the sum for the values that you have a range.
Question 18.
Layout option is available under …………….. group in the Home tab. [1]
Answer:
Slides/ New slide layout
The home tab in a presentation software provides a set of the commonly used commands for work that is need to be performed.
Question 19.
Presentation software enables the user to add tables in the slides in order to represent the …………….. data meaningfully. [1]
Answer:
Statistical
Explanation:
A presentation program (also called presentation software) is a software package used to display information in the form of a slide show.
Generally, the data in the statistics can be presented in three different forms, such as textual method, tabular method and graphical method.
Question 20.
Time management is the act of planning to stay organized that will result in increased …………….. and …………….. [1]
Answer:
Efficiency, productivity
Explanation:
Time management refers to the organisng and prioritizing of one’s tasks and activities to make the efficient use of available time. It includes goal settings creating schedules and using various tools to maximize productivity.
Question 21.
…………….. appointments can be used for scheduling repetitive tasks. [1]
Answer:
Recurring
Recurring tasks are a useful way of setting regularly scheduled reminders and tracking your work progress
Question 22.
…………….. statement is used to add one or more records to a database. [1]
Answer:
INSERT INTO
Syntax of INSERT INTO:
INSERT INTO table_name(columnl, column2, . column3. ,)VALUES(valuel, value2, value3 .)
Question 23.
…………….. statement retrieves zero or more rows from one or more database tables. [1]
Answer:
SELECT
Syntax of SELECT:
SELECT<columnl>, <column2>, <column3>, <columnN> FROM table_name;
Answer any 4 questions out of the given 6 questions
Question 24.
Explain Blog. Give any two websites that offer free blog services. [2]
Answer:
A blog, also known as weblog, is a regularly updated website where an individual, group or organization share their views, feelings experience in chronological order. Blogs are similar to online journal. Blogger and Medium are the examples of free blogging sites.
Question 25.
List any four items that may be added in the Header area. [2]
Answer:
A header area can contain one or more of the following items:
(1) title
(2) page number
(3) date and time.
(4) Pictures and clipart
Question 26.
List any two conditions/formats/items that can be used for conditional formatting in a Spreadsheet. [2]
Answer:
Conditions:
• Less than (<)
• greater than (>)
• less than equal to (<=)
• greater than equal to (>=)
• equals to (=)
• not equals to (! =, < >)
• Between
• Not Between
• Top Ten
• Bottom Ten
• Above Average
• Below Average
• Text that Contains, etc.
Formats:
• Number format
• Font
• Font style
• Font color
• Fill color
• Fill pattern
• Border color
• Border style
(but not border thickness) etc. Items:
• Highlight cell rules
• Top/Bottom Rules
• Data Bars
• Colour scales
• Icon Sets etc.
(Note: Any Two from the above conditions / Formats/Items)
Question 27.
Mention two ways in which a movie file may be inserted in a presentation. [2]
Answer:
A movie file can be inserted in following ways:
• Using Insert Tab
• Using Title and Content Layout Option
• Using Insert > movie > from file
• Using Insert > movie > Clip Organizer
• Using Insert > movie > Online videos
• By Copy and Paste movie file
• By Cut and Paste movie file
• By Drag and Drop movie file (Any two)
Question 28.
Mention two ways of scheduling an appointment. [2]
Answer:
The Menu bar and Calendar view help in scheduling an appointment
Question 29.
Explain two types of languages used for creating and manipulating the data in databases. [2]
Answer:
DDL(Data Definition language) is used to create database and DML(Data Manipulation Language) is used to manipulate database.
DDL consists of commands like CREATE TABLE, ALTER TABLE, DROP TABLE, TRUNCATE TABLE and RENAME TABLE.
DML consists of commands like SELECT, INSERT, UPDATE, DELETE and MERGE.
Answer any 4 questions out of the given 6 questions
Question 30.
What are section breaks? Explain how a section break helps in formatting a document. [3]
Answer:
A section break controls the formatting of the document content that precedes it until it reaches another section break.
Section break help in following ways:
- Add flexibility to formatting a document
- We can create different footnote numbering, change the layout of columns, change page borders for different pages, and even change page layouts in the same document.
- We can separate the chapters as separate sections in our document so that the page numbering for each chapter begins at 1.
Question 31.
Differentiate between linking and embedding a document. Does embedding an object increase the size of the document ? List any two websites that offer free clipart. [3]
Answer:
The difference between linking and embedding is as follows:
Linking | Embedding |
In linking a document is stored separately from the original document. | In embedding content becomes the part of the original document. |
A hyperlink or connection is created from one document to another. | Embedding involves inserting the entire content of one document directly to another document. |
Generally used to add reference to external files or web pages. | It is useful when you want to keep the content intact with original file and do not rely on external files. |
Yes, when a file is embedded into another document the size of the target file increases. Fotor.com, OpenClipart, TinyClipart, Freepik. com, are some websites that offer free clipart
Question 32.
Give any three basic guidelines for charts in a presentation. [3]
Answer:
Some Basic guidelines are as follows:
- Convey one message per chart.
- Make the message the heading.
- Make the chart easy to read.
- Label the X and Y axis and label the lines, bars or pie wedges.
- Make the most important text largest
- Darken the most important data lines or sections. (Any three)
Question 33.
Write steps to give transition effects in a presentation software. [3]
Answer:
Steps to give transition effects:
- Click on Animations Tab / Transitions Tab
- A list of transition effects will be displayed.
- Select an effect from Transitions to this slide group and double click on it.
Question 34.
Explain any three data types in OpenOffice base. [3]
Answer:
The three types of datatypes available in OpenOffice base are as follows:
- Numbers: It stores numeric values which can include both integers and fractional numbers.
- Text: It holds textual or alphanumeric data i.e., data with the combination of text and numbers.
- Date/Time: The date-time datatype is used to store the dates in a database.
- Binary: It stores large types of data such as image, audio or video files. (Any three)
Question 35.
Explain the following with respect to Databases: [3]
(A) Forms
(B) Reports
(C) Table:
Answer:
(A) FORMS: FORMS refers to the user interface elements or templates used for inputting or displaying data. They are the way for users to interact with database in a DBMS. They are also used for data validation. The forms can be customized according to the user’s requirements.
(B) Report: Report is a structured and formatted presentation of data accessed from the database. Reports are used to summarise, analyze, and present data in human readable form. Reports are visually more attractive and can be customized according to the need. Reports may also include charts graphs, patterns, etc. to present records in more appealing way.
(C) Table: Tableis the fundamental concept of storing data in a database it is structured collection of data which is organized into rows and columns. Each row represents a record and column represents an attribute or field.
Answer any 2 questions out of the given 4 questions
Question 36.
(A) Explain any three types of impairments that impact computer usage. [5]
(B) Explain Client-Server architecture and Peer-to-Peer Architecture.
Answer:
(A) There are numerous types of impairment that impact computer usage. These include:
- Cognitive impairments and learning disabilities, such as dyslexia, attention deficit-hyperactivity disorder (ADHD) or autism.
- Visual impairment such as low-vision, complete or partial blindness and color blindness.
- Hearing impairment including deafness.
- Physical/Motor or dexterity impairment such as paralysis, cerebral palsy or carpal tunnel syndrome and repetitive strain injury. (Any three)
(B) Client-Server Architecture: Networks in which certain computers have special dedicated tasks, providing services to other computers (in the network) are called client server networks.
Peer-to-peer (P2P) Architecture: Networks in which all computers have an equal status are called peer to peer networks.
Question 37.
Given the following Spreadsheet, write the appropriate Formula/Expression/Function to be used for (a) to (e): [5]
A | B | C | D | E | F | G | H | |
1 | Quarterly sales report | |||||||
2 | Zone | Jan-Mar | Apr- Jun | Jul-Sep | Oct- Dec | Total: | ||
3 | North | 500 | 420 | 290 | 400 | |||
4 | West | 150 | 130 | 400 | 250 | |||
5 | East | 400 | 270 | 320 | 350 | |||
6 | South | 540 | 530 | 457 | 380 | |||
7 |
(a) Write the formula to calculate the Total sales of North Zone.
(b) Write the feature used for arranging the Sales from Lowest to the Highest.
(c) To find the Maximum Sales in East Zone.
(d) To find the Average Sales in Jan-Mar in cell C7.
(e) To find the difference between the sales in East Zone and West Zone in Apr-Jun.
Answer:
(a) = SUM (B3:E3)
(b) SORT / SORTING / A to Z icon
(c) = MAX (B5 : E5)
(d) = AVERAGE (B3 : B6)
(e) = C5 – C4
Question 38.
Rashika is preparing a presentation to give an annual sales report and the progress made by her zonal teams. She has to do the following in the presentation. Suggest appropriate measures to do so.
(A) She wants to show the sales data in a pictorial form. Which tool/option should she use to compare the data ?
(B) She wants to give some effect whenever the slide changes. How can she do this ?
(C) She has to show a table created in spreadsheet on her slide.
(D) She wants to take printouts such that more than one slide is printed on the page having only textual content.
(E) Give her an additional guideline for preparing a presentation. [5]
Answer:
(A) Charts /Graph
(B) Transition Effects /Slide Transition/ Transition/Animation Effect
(C) Choose Object from the Insert menu.
In the Insert Object dialog box, click the Create from File option and click Browse to locate and choose the spreadsheet that contains the table.
(D) Through Outline option
(E)
(1) Know your topic
(2) Use Key phrases about the topic
(3) Avoid too much text on each slide
(4) Limit the number of slides
(5) Avoid fancy fonts
(6) Use contrasting colors for text and background
Question 39.
(A) Create table EMPLOYEE [5]
EMPID Char(4)
EMPNAME Varchar (15) DESIGN Varchar (20) SALARY Decimal |
(B) What is a primary key ?
(C) Categorize the following commands as DDL and DML:
SELECT, ALTER, INSERT, DROP
Answer:
(A) CREATE TABLE EMPLOYEE [EMPID varchar(4)), EMPNAME varchar(15), DESIGN varchar(20), SALARY decimal(6,2)].
(B) Primary Key- A primary key is a column or columns that contain values that uniquely identify each row in a table.
(C)
SELECT-DML
ALTER-DDL
INSERT-DML
DROP-DDL