Class 12 Typography & Computer Application 817 Previous Year Question Paper 2022 – Term 2 – Solution

by

Series ∊ABA€
Question Paper Code 341 Set 4

TYPOGRAPHY & COMPUTER APPLICATION – TERM 2 – SOLUTION
(Session 2021-22)

Time allowed : 1.5 hours
Maximum Marks : 30

General Instructions :

  1. Please read the instructions carefully.
  2. This question paper is divided into three sections, viz. Section A, Section B and Section C.
  3. Section A is of 5 marks and has 6 questions on Employability Skills.
    (a) Questions number 1 to 4 are one mark questions. Attempt any three questions.
    (b) Questions number 5 and 6 are two marks questions. Attempt any one question.
  4. Section B is of 17 marks and has 16 questions on Subject Specific Skills.
    (a) Questions number 7 to 13 are one mark questions. Attempt any five questions.
    (b) Questions number 14 to 18 are two marks questions. Attempt any three questions.
    (C) Questions number 19 to 22 are three marks questions. Attempt any two questions.
  5. Section C is of 8 marks and has 3 Competency-Based Questions.
    Questions number 23 to 25 are four marks questions. Attempt any two questions.
  6. Do as per the instructions given in the respective sections.
  7. Marks allotted are mentioned against each section/question.

SECTION A – Employability Skills (3+2=5 marks)

Answer any 3 questions out of the given 4 questions. (3X1=3)

1. What are the 4 R s which can contribute in creating a sustainable society ?
Answer: Reduce, Reuse, Recycle, Rethink

2. Suggest one best way to overcome the fear of failure by an entrepreneur.
Answer: Reframe Failure: Instead of viewing failure as a final, negative outcome, see it as an opportunity to learn and grow. Understand that setbacks and failures are part of the entrepreneurial journey.

3. What are entrepreneurial competencies ?
Answer: Entrepreneurial competencies, also known as entrepreneurial skills or capabilities, refer to the specific qualities, knowledge, and abilities that individuals need to excel in entrepreneurial ventures.

4. What is the role of an Environmental Education Teacher ?
Answer: An Environmental Education Teacher plays a crucial role in educating students and the community about environmental issues, sustainability, and the importance of preserving and protecting the natural world.

Answer any 1 question out of the given 2 questions. (1X2=2)

5. What are the barriers which an entrepreneur faces to kickstart his venture ?
Answer: If you’re new to business, it can be harder to run venture. The business world is uncertain, and the fear of failing can hold you back. Finding money and people to support you can also be a struggle. To overcome these difficulties, you need to be tough, think creatively, and be ready to adapt to change.

6. Do you think toxins are present in our homes ? Give two cases.
Answer: Yes, toxins can be present in our homes, and there are various common cases of this. Here are two examples:
(a) Household Cleaning Products: Many household cleaning products contain chemicals and toxins that can be harmful to both human health and the environment. These chemicals, such as ammonia, chlorine, and phthalates, can contribute to indoor air pollution.
(b) Lead-Based Paint: When lead-based paint deteriorates, it can create lead dust and chips, which are harmful if ingested or inhaled, particularly for young children.

SECTION B – Subject Specific Skills (5+6+6=17 marks)

Answer any 5 questions out of the given 7 questions. (5X1=5)

7. What type of chart is useful for comparing values over categories ?
Answer: A bar chart or a column chart is typically the most useful type of chart for comparing values over categories.

8. Which function in Excel tells how many numeric entries are there ?
Answer: In Microsoft Excel, you can use the COUNT function to count how many numeric entries are in a range of cells.
Example: =COUNT(A1:A10)

9. What extension is used to save the PowerPoint file ?
Answer: “.ppt” or “.pptx“

10. What is E-Commerce ?
Answer: E-commerce, short for electronic commerce, is the buying and selling of goods and services over the internet. It involves a wide range of online activities, including online shopping, electronic payments, digital storefronts, and the exchange of data and information.

11. What does ‘VIRUS’ stand for?
Answer: Vital Information Resources under Siege

12. What do you understand by ‘Logic Bombs’ ?
Answer: A “logic bomb” is a type of malicious code or software that is intentionally inserted into a computer system or software application with the purpose of executing a harmful action when certain conditions are met.

13. Name any two famous Antivirus Softwares.
Answer: Quick Heal, AVG, Avast, Norton etc.

Answer any 3 questions out of the given 5 questions. (3X2=6)

14. What is the difference between Trojan Horse and Worms ?
Answer: A Trojan Horse pretends to be something harmless or useful to trick you into letting it in. Once inside, it carries out harmful actions, like stealing your data or giving a hacker access. Examples: keyloggers, remote access Trojans (RATs) etc.
Worms are like self-replicating bugs; they don’t need your help to spread. They sneak into your system and quickly move to other computers, often slowing things down as they go. Examples: ILOVEYOU, Conficker etc.

15. What are the probable effects of Computer Virus on computers after a virus attack ?
Answer: Some of the common effects of Computer Virus on computers after a virus attack.
• Slower operating speed
• Issues with programs and files
• Weird behavior etc.

16. What is a Slide Sorter view ?
Answer: A Slide Sorter view is a feature in presentation software, that allows you to view and manage all the slides in your presentation as thumbnails on a single screen. It provides a complete visual overview of your presentation slides and is particularly useful for reordering, organizing and managing the flow of your presentation, and quickly navigating through your slides.

17. Write the steps to add an Image from Clip Art.
Answer: To add an image from Clip Art to a document or presentation, you can follow these general steps.
Step 1: Go to the Insert Tab.
Step 2: You’ll see a “Clip Art” or “Online Pictures” option in the Insert tab. Click on it.
Step 3: Search for images by typing keywords in the search bar.
Step 4: Click on the image to select it.
Step 5: After selecting the image, click the “Insert” or “Add” button to place it in your document or presentation.

18. Differentiate between Relative Referencing and Absolute Referencing.
Answer: In relative cell referencing, cell references in a formula change relative to the position of the formula when you copy it to another cell.
For example, if you have a formula in cell C1 that adds the values in cells A1 and B1 as =A1+B1, and you copy this formula to cell C2, it will automatically adjust to =A2+B2.
In absolute cell referencing, cell references are locked to specific cells, and they do not change when you copy the formula to another cell.
For example, if you have a formula in cell C1 that adds the values in cells A1 and B1 as =$A$1+B1, and you copy this formula to cell C2, it will lock the cell address A1 as =$A$1+B2.

Answer any 2 questions out of the given 4 questions. (2X3=6)

19. What do you understand by ‘Functions’ in MS Excel ? Explain Average() Function and Sumif() Function.
Answer: In Microsoft Excel, functions are built-in, predefined formulas that perform specific calculations, operations, or tasks on data in your spreadsheet.
Here’s an explanation of two common Excel functions:
(a) AVERAGE() Function: The AVERAGE() function is used to calculate the arithmetic mean (average) of a range of numbers in Excel.
Syntax: =AVERAGE(number1, [number2], ...)
Example: If you have a list of numbers in cells A1 to A5 (e.g., 10, 15, 20, 25, 30), you can use the AVERAGE() function to find the average of these numbers. Enter the formula =AVERAGE(A1:A5) into a cell, and Excel will calculate the average, which is 20 in this case.
(b) SUMIF() Function: The SUMIF() function is used to sum values in a range based on a specified condition or criteria.
Syntax: =SUMIF(range, criteria, [sum_range])
Example: Suppose you have a list of sales figures in cells A1 to A10 and a corresponding list of product names in cells B1 to B10. If you want to calculate the total sales for a specific product, say “Product X,” you can use the SUMIF() function. Enter the formula =SUMIF(B1:B10, "Product X", A1:A10) into a cell. This formula sums all the sales figures in column A where the corresponding product in column B is “Product X.”

20. Write the steps to modify animation effect.
Answer: Steps for modifying animation effects in Microsoft PowerPoint:
Step 1: Select the slide with the animation you want to change.
Step 2: Access the Animation Pane by clicking on the “Animations” tab and then “Animation Pane.”
Step 3: In the Animation Pane, click on the animation you want to modify.
Step 4: Right-click on the selected animation and choose “Effect Options,” “Timing,” or “Start” to adjust the animation’s settings.
Step 5: Make your desired modifications and click “OK” to save.
Step 6: Save your presentation to keep your changes.

21. What is the importance of Email ?
Answer: Email, short for electronic mail, is a widely used communication tool with significant importance in various aspects of personal, professional, and academic life.
Email is super important because it helps us talk to people, whether they’re our friends, family, or colleagues, quickly and easily through the computer. You can send messages and documents without having to be in the same place at the same time. It’s like writing a letter, but it arrives almost instantly. It’s also a way to keep records of conversations, and you can even use it to apply for jobs or get help from companies when you have a problem. So, email is like your friendly digital mailbox where you get all kinds of information and stay in touch with the world.

22. Briefly explain three email service providers.
Answer: Gmail is an email service provided by Google. It offers a user-friendly interface, robust spam filtering, and integration with other Google services like Google Drive, Calendar and many more. It provides ample storage space, efficient organization features, and support for both personal and business use. Gmail is known for its strong security measures, including two-factor authentication.
Outlook is Microsoft’s email service, often used with Microsoft Office. It provides a clean and organized interface, seamless integration with other Microsoft applications, and features like focused inbox to prioritize important emails. Outlook offers both web-based and desktop email client versions and is popular among professionals and businesses.
Yahoo Mail is an email service from Yahoo, offering a straightforward and user-friendly platform. It includes features like customizable themes, a calendar, and a news feed. While it has a free version, Yahoo Mail also offers a paid option called Yahoo Mail Pro, which removes ads and provides additional features.

SECTION C – Competency-Based Questions (2X4=8 Marks)

Answer any 2 questions out of the given 3 questions.

23. Computers are very important nowadays and everyone is using them. In this context, explain the following terms :
(a) Merge and Center:
Answer: It is a formatting option in Excel that allows you to combine multiple cells into one and center the contents horizontally and vertically within the merged cell. You can find the Merge and Center option in the “Alignment” group on the “Home” tab in Excel.
(b) Alignment Tab:
Answer: The Alignment Tab refers to a section of the Format Cells dialog box in Excel where you can customize the alignment and orientation of text within a cell. You can control horizontal alignment (left, center, right), vertical alignment (top, center, bottom), text orientation, and various other formatting options for the content inside the cell.
(c) Drag and Drop:
Answer: Drag and Drop is a user-friendly feature in Excel that allows you to move or copy cells, rows, columns, or other data by selecting the content and then dragging it to a new location. It is a quick and intuitive way to rearrange data within a spreadsheet.
(d) Workbook:
Answer: A Workbook is the excel file that can contain one or more worksheets. Workbooks are saved with the file extension “.xlsx” and serve as a container for organizing and storing data. You can have multiple workbooks open at the same time, each with its own set of worksheets.

24. Nowadays Presentation is used in all offices and educational institutes. In this context, give the definition of Presentation and its use.
Answer: A presentation is a method of communicating information, ideas, or messages to an audience using visual and verbal elements. It typically involves a presenter delivering content to a group of people with the goal of informing or engaging them. Presentations can take various forms, including slide-based presentations, oral speeches, lectures, and multimedia displays.
Presentations have a wide range of applications in both office and educational settings:
Business and Corporate: In offices, presentations are means of conveying business strategies, project updates, financial reports, and marketing plans to colleagues, clients, and stakeholders.
Education: Teachers and professors use presentations to deliver lectures and educational content to students. These presentations may include slideshows, multimedia elements, and interactive activities to enhance the learning experience.
Training and Workshops: Training sessions and workshops often involve presentations to educate employees or participants about specific skills, processes, or topics.
Sales and Marketing: Sales and marketing professionals use presentations to showcase products, services, and marketing campaigns.
Research and Conferences: In the academic and research community, presentations are used to share research findings, insights, and discoveries at conferences and symposiums.

25. Chart in MS Excel is used to represent data in graphical form. Explain the major components of a Chart in MS Excel.
Answer: The major components of a chart in MS Excel include the following:
Chart Title: The title of the chart provides a brief description of what the chart represents. Title can be placed above or below the chart, depending on your preference.
Data Series: Data series are the sets of data points you want to visualize in the chart. These data points can represent categories, values, or labels, depending on the chart type.
Chart Type: The chart type, also known as the chart category, determines how your data is displayed. Excel offers a variety of chart types, such as bar charts, line charts, pie charts, and scatter plots.
Chart Area: The chart area is the entire space within which the chart and all its elements are contained. It can include the plot area, axes, title, legend, and other chart components.
Plot Area: The plot area is the specific area where the data points are plotted. It’s the core part of the chart that visually represents the data.
Axes: A chart typically has two axes: the horizontal axis (X-axis) and the vertical axis (Y-axis). The X-axis usually represents categories or labels, while the Y-axis represents values or quantities.
Data Labels: Data labels can help clarify the information presented and are particularly useful in bar charts, column charts, and scatter plots.
Legend: The legend is a key that explains the various data series or categories in the chart.
Gridlines: Gridlines are horizontal and vertical lines that help with the visual alignment of data points on the chart.

Find Class 12 Typography & Computer Application Previous Year Question Papers

Find Class 12 Typography & Computer Application Previous Year Question Papers Solution

Find Class 12 Typography & Computer Application Previous Year Compartment Question Papers

Find Class 12 Typography & Computer Application Previous Year Compartment Question Papers Solution

Leave a Comment