Computer Applications
Case Study 1
Neeta has to create a presentation for a project on sustainable development. She is not very familiar with digital presentation software. Help her understand some of the concepts with reference to a slide presentation.
- Presentation
- Creating a slide
- Workspace Views - any two views
- Animations
- Slide Layout
Answer
Presentation — A presentation is a collection of slides arranged in a sequential manner to convey, persuade, motivate, entertain or to provide information.
Creating a slide — A slide can be created by following the given steps:
- Click on New Slide option present in the Slide group on the Home tab. A drop-down box will appear.
- Select the required slide layout and click on it.
Workspace Views (any two views) — The two slide views in PowerPoint are as follows:
- Normal View — It is the main editing view, which is used to write and design a presentation. In Normal View, we can add text, graphics, sound, animation, and other effects as well.
- Slide Sorter View — It displays a miniature view of all the slides in a presentation arranged in horizontal rows. This view is useful in making changes to several slides in one go. We can change the order of slides, copy or delete the slides, add transitions, animation effects, and set the timings for the slide show.
Animations — Animation effects can be applied to individual elements on a slide, allowing for more dynamic and engaging presentations.
Slide Layout — Slide Layout defines the basic structure of a slide and arranges our slide content. It provides us with different ways to position our text, images, and other graphic options.
Related Questions
Shobha recently got a printer as a gift. She has connected the printer to her computer as well as to the power source. Everything seems to be in order but when she tries to print, the printer does not show up in her list of devices. What could be the problem? Can you suggest what Shobha can do to resolve this issue?
Study the spreadsheet given below and write the solutions for the specifications that follow. You can write the answers for any four specifications out of the given five.

Specification 1: Write the formula to be entered in cell H4 in order to calculate Rita's total marks out of 500. How can you easily enter the formula for totals in the four cells (H5 to H8) without typing each individually?
Specification 2: The percentage column should contain the percentage of each student. Write the formula to be entered in cell I4 to calculate the percentage for the first student.
Specification 3: Write the formula that will appear in cell I5 when we copy the formula from cell I4 to cell I5.
Specification 4: Write the formula that should be entered in cell C9 to calculate the average marks in English.
Specification 5: If a column chart is to be plotted of students name against the marks in English, write the range of cells that needs to be selected.
Study the Excel chart shown below and write the solutions for the specifications shown below it. You can write the solutions for any four specifications out of the given five:

Specification 1: Name the type of chart that has been used in the figure. What is the type of analysis that this type is giving?
Specification 2: What is the temperature in Sydney in the month of November?
Specification 3: Which is the hottest city in the month of August?
Specification 4: Which is the country which generally has the lowest temperatures across the year?
Specification 5: What is the use of charts in a spreadsheet? Name one more type of chart.
Case Study 2
Hari receives a call for verification of his bank account details. He receives a link and he fills up his account details in the form available on clicking the link. Soon he gets an OTP which he is asked to give to the caller. After some time, he is surprised to get a message from his bank that Rs. 40,000 has been deducted from his bank account for an online transaction. He realises he has been cheated.
Based on the given information, answer the questions given below. Attempt any four questions.
a. Name the above mentioned type of theft in which Hari's personal information was stolen.
b. State the mistakes Hari made, which lead to his financial loss.
c. Write two safety measures to be taken by Hari to avoid repeating such mistakes in the future.
d. Apart from the bank account details, what is the other type of data that can be stolen by imposters on the internet?
e. Write in brief about any one type of cyber crime, other than the above, that you are aware of.