CBSE Class 10 IT 2020 Solved Paper with Detailed Answers (Code 402)

Answer: Phrases (or sentences – but “phrases” is the best fit).

A phrase is a group of words that works together like a single part of speech (for example, in the morning, the big house). It does not have a full subject–verb pair, but it still communicates a small unit of meaning within a sentence.

Answer: Stress management (you may also write yoga / meditation / exercise type practices).

Stress management means using healthy methods (like yoga, meditation, exercise, talking to friends/family, breaks or nature walks) to maintain a balanced body and mind so that you can handle difficult or stressful situations more effectively.

Answer: Self-awareness

Self-awareness means clearly knowing your own strengths, weaknesses, thoughts, emotions and personality. A self-aware person understands what they can do, what they feel, and how they react in different situations.

Answer: Word processor

A word processor (like MS Word, LibreOffice Writer, Google Docs) is used to type, edit, format and print text documents such as letters, reports, essays and notices.

Answer: True

Entrepreneurs start and run businesses. When their businesses grow, they hire workers and thus create jobs instead of just searching for jobs themselves.

Answer: United Nations Environment Programme (UNEP)
(You may also write United Nations Environment Programme / UNEP.)

According to UNEP, a green economy improves human life and social fairness while reducing environmental damage and resource shortages.

You can explain any four common types. One standard way is:

1. Declarative / Assertive sentence –
   It states a fact or opinion.
   Example: “The Internet is very useful.”

2. Interrogative sentence –
   It asks a question and usually ends with a question mark (?).
   Example: “What is your name?”

3. Imperative sentence –
   It gives a command, request or advice.
   Example: “Please save your work.”

4. Exclamatory sentence –
   It expresses strong feelings or emotions and usually ends with an exclamation mark (!).
   Example: “What a beautiful presentation!”
   

Any four valid characteristics will do, for example:

1. Ambition and vision – Desire to achieve something big and a clear idea of future goals.

2. Risk-taking ability – Willingness to take calculated risks to start or grow a business.

3. Innovation and creativity – Ability to bring new ideas, products or better ways of doing things.

4. Leadership and team management – Capability to guide, motivate and manage people.

Other acceptable characteristics include confidence, self-motivation, decision-making ability, discipline, strong work ethics, optimism, etc. CBSE

One possible method:

1. Select the text you want to highlight (using mouse drag or Shift + arrow keys).

2. Click the Highlight Color icon (or Font Color / Bold / Italic / Underline icons) on the formatting toolbar.

Anything that makes the selected text stand out — for example, changing the background color, making it bold, italic or underlined — is considered highlighting in the exam. CBSE

Any two of the following (or similar) are correct:

• Family and childhood experiences

• Friends and social circle

• Academic performance / work environment

• Physical and mental health

• Society and media influence

• Stress and life events

Self-confidence can increase with positive feedback and success, and decrease with constant criticism or failure. CBSE

Any four valid factors, for example:

1. Deforestation – Cutting down forests on a large scale.

2. Industrialization and pollution – Smoke, chemicals and waste from factories.

3. Urbanization and overpopulation – More cities, vehicles and crowding.

4. Overuse of pesticides and fertilizers – Damages soil, water and biodiversity.

Other factors like overgrazing, soil erosion, faulty mining practices and careless use of water resources are also acceptable. CBSE

Correct option: (C) Assistive Technology

Assistive technology refers to specialized hardware and software (like screen readers, screen magnifiers, alternative keyboards, speech input) that help people with disabilities use computers more easily. CBSE

Answer: Accessibility Options (or Ease of Access)

The Accessibility / Ease of Access settings in the Control Panel let you change how the keyboard, mouse and display work so that the computer becomes easier to use for people with special needs.

Answer: Insert tab – Illustrations group

In presentation or word-processing software like MS Office, picture and clipart tools are normally found under the Insert tab, in a section often called Illustrations.

Answer: Header & Footer group

In many office applications, page headers and footers are controlled from the Header & Footer group within the Insert tab.

Answer: SUM (or Autosum)

The SUM() function adds a range of numbers. For example, =SUM(A1:A5) adds the values from cells A1 to A5.

Answer: Horizontally or vertically
(You may also write rows or columns.)

Autosum looks at the nearest continuous range of numbers either across the row or down the column and uses that range in the formula.

Answer: Slides / New Slide Layout
(“Page Setup” is also accepted when software is not specified.)

In presentation software, the Layout option is typically found in the Slides group, allowing you to change the arrangement of placeholders (title, text, content) on a slide.

Answer: Statistical / tabular / comparative data
(Any similar word like raw or simple data is acceptable.)

Tables help organize numbers and facts in rows and columns so the audience can understand and compare the data easily. CBSE

Answer: Any two of: productivity, efficiency, capability, strength

Effective time management helps you do more work in less time and improves the quality and quantity of your output.

Answer: Recurring appointments

A recurring appointment repeats automatically (daily, weekly, monthly or yearly) and is used for tasks like regular meetings, classes, or check-ups.

Answer: INSERT statement

For example, in SQL:

This adds a new record (row) into the table.

Answer: SELECT statement

For example:

This retrieves records from the table Student. If no data matches the condition, it may return zero rows.

A blog is a type of website where a person or group regularly posts content (articles, opinions, news, updates) in the form of entries called posts. It usually shows posts in reverse chronological order (newest first) and can act like an online diary, news feed or knowledge-sharing platform.

You can use a blog to:

• Share personal thoughts and experiences

• Publish educational or technical articles

• Post news, announcements and reviews, etc.

Two websites that offer free blog services (any two):

• wordpress.com

• blogger.com

Other acceptable examples: blog.com, weebly.com, wix.com, tumblr.com, medium.com, etc. CBSE

Any four from the following (or similar) are correct:

• Picture or logo

• Page number

• Total number of pages

• Date

• Time

• File path or file name

• Sheet name (in spreadsheet)

• Author’s name

• Company or department name

These items usually appear at the top of each page in the document.

You can mention two from any of these categories:

Conditions (examples):

• Less than < / greater than >

• Less than or equal <= / greater than or equal >=

• Equal to = / not equal to <>

• Between / Not between

• Above average / Below average

• “Text that contains …”

Formats (examples):

• Changing number format

• Changing font, font style or font color

• Changing fill color or pattern

• Changing border color or style

Items (menu options):

• Highlight cell rules

• Top / Bottom rules

• Data bars

• Color scales

• Icon sets

Any two correct examples (from any of these groups) score full marks. CBSE

Any two of the following are correct:

1. Use Insert → Movie / Video → From File, then select the video file.

2. Use a slide layout that includes “Content” and click the movie/video icon to insert the file.

3. Insert from Clip Organizer or Online Videos.

4. Copy and paste the movie file object into the slide.

5. Drag and drop the video file from a folder onto the slide.

All of these methods attach a movie file to the presentation slide.

Any two correct methods:

1. Using the Menu bar / Calendar menu → select New Appointment.

2. Using Calendar view and double-clicking on a date/time slot to create an appointment.

3. Using Home tab → New Appointment within the calendar application.

4. Creating daily / weekly / monthly / yearly recurring appointments.

All these allow you to add appointments to a digital calendar.

The two main categories are:

1. DDL – Data Definition Language

   • Used to define or change the structure of a database (tables, fields, constraints).

   • Common commands: CREATE, ALTER, DROP.

   • Example:

     CREATE TABLE Student (RollNo INT, Name VARCHAR(20));


2. DML – Data Manipulation Language

   • Used to work with the data inside tables.

   • Common commands: INSERT, UPDATE, DELETE, SELECT (for retrieval).

   • Example:

     INSERT INTO Student VALUES (1, 'Ravi');


Section breaks are markers in a document that divide it into separate sections. Each section can have its own formatting.

They help in formatting a document in these ways:

• You can use different page layouts (portrait/landscape) in different sections.

• You can change margins, page borders or number of columns section-wise.

• You can restart page numbering or have different footnote numbering per section.

• You can create different headers and footers for different sections (for example, separate for each chapter).

So, section breaks act like mini-documents inside one large document, allowing very flexible formatting. CBSE

Difference between linking and embedding:

• Embedding:

  • The object (like a spreadsheet, image, or another document) becomes part of the main file.

  • Changes made later in the original (source) file do not automatically update in the embedded copy.

  • The object is stored inside the document itself.

• Linking:

  • The object is stored separately, and the document only keeps a link to it.

  • If the source file is updated, the linked object in the main document can also show updated content.

  • The main document stays smaller, but it needs access to the source file.

Does embedding increase the size of the document?
Yes. Embedding stores the whole object inside the document, so the file size becomes larger.

Any two websites that offer free clipart:

• openclipart.org

• clker.com

(Other acceptable sites: pdclipart.org, freeclipartnow.com, wpclipart.com, etc.) CBSE

Any three correct guidelines, for example:

1. Focus on one main message per chart – don’t overload it with many ideas.

2. Use the message as the chart title – make it clear what the chart shows.

3. Label axes and data clearly – X and Y axes, bars, lines or pie slices should all be clearly labeled.

4. Keep it simple and readable – avoid unnecessary grid lines, decorations or extra effects.

5. Use only a few colors – normally not more than four main colors to avoid confusion.

These make charts easy to understand for the audience. CBSE

General steps (names may vary slightly by software):

1. Open your presentation and select the slide you want to apply a transition to.

2. Click on the Transitions tab (or Animations tab in some versions).

3. In the Transition to this slide group, choose a transition effect from the list.

4. Click on the effect (or double-click) to apply it to the selected slide.

5. Use options like Duration, Sound or Apply to All if needed.

This adds an effect when moving from one slide to another.

You can explain any three of these categories:

1. Numeric types

   • Used to store numbers.

   • Examples: Integer, Decimal, Float, Double, Single.

   • Ideal for fields like marks, age, salary.

2. Alphanumeric / Text types

   • Store combination of letters, numbers and symbols.

   • Examples: CHAR, VARCHAR, TEXT, MEMO.

   • Used for names, addresses, descriptions, etc.

3. Binary / Boolean types

   • Used for Yes/No or data stored in binary form (like images or flags).

   • Examples: Image, Binary, Yes/No.

4. Date & Time types

   • Store date and/or time values.

   • Examples: DATE, TIME, TIMESTAMP.

Any three with short explanation and examples are enough. CBSE

(a) Forms
Forms are user-friendly screens used to enter, edit and view data in the database. They provide a structured layout that makes data entry easier and safer than directly editing tables.

(b) Reports
Reports are used to present selected data in a printable, well-formatted way. They summarize and display data from one or more tables or queries so it can be printed or shared.

(c) Table
A table is the basic storage structure in a database. Data is stored in rows and columns (like a grid), where each row is a record and each column is a field/attribute.

(a) Three types of impairments affecting computer usage (any three):

1. Cognitive and learning impairments –
   Conditions like dyslexia, ADHD, or autism may make it difficult to read, concentrate or understand complex interfaces.

2. Visual impairment –
   Includes low vision, partial or complete blindness, and color blindness, making it hard or impossible to see normal text and images on the screen.

3. Hearing impairment –
   Persons with partial or complete loss of hearing may not benefit from audio alerts, videos with sound, etc.

4. Physical / Motor impairments (also acceptable) –
   Problems with movement or coordination (paralysis, cerebral palsy, severe arthritis, etc.) make it hard to use a mouse or standard keyboard.

(b) Client–Server vs Peer-to-Peer architecture:

• Client–Server architecture

  • Some computers act as servers that provide services (like files, printing, web pages).

  • Other computers are clients that request and use those services.

  • Example: logging into a central file server to access shared documents.

• Peer-to-Peer (P2P) architecture

  • All computers are equal (peers). There is usually no dedicated server.

  • Each computer can act both as a client and as a server; they share resources directly with each other.

  • Example: two PCs sharing files over a simple LAN without a main server. CBSE
    

We assume the table is:

• Row 2: headings – Zone, Jan-Mar, Apr-Jun, Jul-Sep, Oct-Dec, Total

• Rows 3–6: North, West, East, South

• Cells B3:E6 contain sales figures.

(a) Write the formula to calculate the Total sales of North Zone.

North Zone is in row 3, Jan–Dec sales in B3:E3.

Formula (any one):

or

---

(b) Write the feature used for arranging the Sales from Lowest to the Highest.

Use Sort feature:

• Answer: Sorting (A to Z) or SORT

---

(c) To find the Maximum Sales in East Zone.

East Zone is in row 5, months in B5:E5.

Formula:

---

(d) To find the Average Sales in Jan–Mar in cell C7.

Jan–Mar values are in column B for all zones (rows 3–6).

Formula (any one):

or

---

(e) To find the difference between the sales in East Zone and West Zone in Apr–Jun.

Apr–Jun is column C.
West = C4, East = C5.

Formula:

(a) Showing sales data in pictorial form

She should use Charts / Graphs in the presentation software. They convert numerical data into bar charts, pie charts, line graphs etc., making comparison easy.

---

(b) Giving effect when the slide changes

She should apply slide transition effects:

• Go to the Transitions (or Animations) tab.

• Select a transition and apply it to the slide(s).

---

(c) Showing a table created in a spreadsheet on a slide

Two possible methods:

1. In the presentation software, choose Insert → Object → Create from File, then browse and select the spreadsheet file that contains the table.

2. Or copy the table from the spreadsheet and paste it into the slide.

Either way, the table appears on the slide.

---

(d) Printing more than one slide per page with only textual content

Use the Outline option in the Print settings:

• Go to File → Print, choose Outline (or Outline view)
  – this prints multiple slides’ text on one page.

---

(e) One additional guideline for preparing the presentation

Many guidelines are acceptable. For example:

• Avoid too much text on each slide; use key phrases only.

Other valid guidelines: know your topic well, limit the number of slides, avoid fancy fonts, use contrasting colors for text and background, use animations sparingly, run spell-check, remove irrelevant images, add speaker notes, etc. CBSE

(a) SQL command to create table EMPLOYEE

This defines a table EMPLOYEE with four fields and appropriate data types.

---

(b) Definition of primary key

A primary key is a field (or combination of fields) in a table that uniquely identifies each record (row). No two rows can have the same primary key value, and it cannot be NULL.

---

(c) Categorization of commands

• DDL (Data Definition Language):

  • ALTER

  • DROP

• DML (Data Manipulation Language):

  • SELECT

  • INSERT

DDL changes the structure of database objects, while DML works with the data stored in them.