Sample Question Paper

Using free online applications

Reason — Cybercrime refers to any online illegal activity facilitated by the use of electronic communication devices. Using free online applications is not a cybercrime as a free application can be used by anyone.

Chatting

Reason — Talking to other people who are using internet at the same time as you are is called Chatting.

Microwaves

Reason — Microwaves are a medium of unguided data transmission while coaxial cable, optical fiber and twisted pair cables are mediums of guided data transmission.

Payroll System

Reason — Payroll System manages an employee's salary.

Bluetooth

Reason — Jayu can use Bluetooth to directly share a video from her mobile to her friend's mobile without using the internet.

Protocol

Reason — Protocol is the set of rules that is used for transmission of data over a network.

GIF

Reason — The image format that supports animation is GIF (Graphics Interchange Format).

by an author to type a novel

Reason — A word processor application will most likely be used by an author to type a novel as a word processor facilitates creating, editing, saving, and printing documents.

Slide Sorter

Reason — Slide Sorter view shows a thumbnail of each slide.

A column name followed by a row number

Reason — A column name followed by a row number constitutes a cell reference.

Both Assertion (A) and Reason (R) are true, and Reason(R) is a correct explanation of Assertion (A).

Reason — Presentation graphics software indeed provides options to include multimedia features, and one of these features is animation, which enhances presentations by allowing objects to move or change on a slide, making the presentation more engaging.

Assertion (A) is true and Reason (R) is false.

Reason — Assertion (A) is true as images can indeed enhance the appearance of a document created using a word processing application and make it more meaningful. Reason (R) is false as some tools/features of word processing applications allow us to draw shapes and pictures within the application.

An e-reservation system refers to an electronic reservation system that allows users to make reservations or bookings through online platforms. Users can access the system via the internet to book services, accommodations, tickets, or appointments.

The two benefits of an e-reservation system are:

1. 24/7 accessibility of services
2. Convenient and time saving

Two differences between RAM and ROM are:

Two advantages of a computer network are as follows:

1. Hardware Sharing — In a network, we can share almost every peripheral device, such as a printer, scanner, modem, CD writer, etc., among several computers.
2. Reduces Redundancy — Since people use the same data in a common workplace, they can share it over a network by saving and storing it centrally.

Differences between a compiler and an interpreter are:

Chatting is an online textual conversation happening in realtime.

Two advantages of chatting are:

1. Users can communicate instantly.
2. It is an inexpensive method of communication.

Two symptoms of virus infection on a computer are:

1. The speed of the processor becomes comparatively slow.
2. The programs may not run. Even if they run, they don't function properly.

A header appears at the top of each page, while a footer appears at the bottom of each page.

The different elements that can be included in a header and footer are page numbers, date, title of a book/chapters, author's name, etc.

A Relative Reference formula changes its cell references based on its position when copied to another cell. This makes it flexible for copying and pasting in different cells.

For example, if we have a formula in cell C1 as $= \text{A1} + \text{B1}$ and copy it to cell C2, the formula in C2 will automatically adjust to $= \text{A2} + \text{B2}$. The references will adjust relative to the original position.

An Absolute Reference formula maintains fixed cell references regardless of its position when copied to another cell. It utilizes dollar signs $(\text{\textdollar})$ to anchor the references, ensuring they do not change.

For example, if we have a formula in cell C1 as $= \text{\textdollar A\textdollar1} + \text{\textdollar B\textdollar1}$ and copy it to cell C2, the formula in C2 will remain as $= \text{\textdollar A\textdollar1} + \text{\textdollar B\textdollar1}$. The references do not adjust; they stay fixed as these are absolute references.

Confidentiality of information means that only authorized users can access the personal and sensitive information of any person like their bank details, credit card numbers, aadhaar number, etc.

Three methods by which we can safely use a social networking site are:

1. We should avoid sharing excessive personal details, such as home address or phone number, on public profiles and be cautious when accepting friend requests and ensure connections are from known and trusted individuals.
2. We should adjust our social media privacy settings to control who can view our profile, posts, and personal information and limit the audience for our posts to trusted connections only.
3. We should use a strong, unique password for our social networking account and enable two-factor authentication (2FA) when available to add an extra layer of security.

The different features of the Word processing application that can be utilized for the given tasks are:

1. Sarita can use the 'Bold' option from the 'Font' group on the 'Home' tab.
2. She can use 'Numbering' option from the 'Paragraph' group on the 'Home' tab.
3. She can use 'Line Spacing' feature from the 'Paragraph' group on the 'Home' tab.

Karan can use the following features of word processor to quickly achieve the given tasks:

1. He can click 'Add Page Number' option and select 'Bottom of Page' from the 'Header and Footer' group present in the 'Insert' tab.
2. He can use 'Header' feature from the 'Header and Footer' group present in the 'Insert' tab.
3. He can use 'Replace' feature present in the 'Editing' group on the 'Home' tab.

A possible issue can be that Shobha's computer cannot recognise the new printer. She can resolve this issue by following the given possible solutions:

1. She can install the necessary printer drivers on the computer. Sometimes, printers require specific drivers to communicate with the operating system. She can check the printer manufacturer's website for the latest drivers and install them.
2. Sometimes antivirus software or firewall blocks the communication between the computer and the printer. If the drivers for the printer are installed correctly and still it is not showing up in the list of devices, then Shobha can temporarily disable the antivirus/firewall to quickly check if that is causing the issue.

Specification 1 — The formula to be entered in cell H4 in order to calculate Rita's total marks out of 500 is = SUM (C4 : G4).

We can easily enter the formula for totals in the four cells (H5 to H8) without typing each individually by copying the formula of cell H4 in cell range H5 : H8. To copy the formula, we must select it and drag the cell handle to cell H8.

Specification 2 — The formula to be entered in cell I4 to calculate the percentage for the first student is = (H4 / 500) * 100.

Specification 3 — The formula that will appear in cell I5 when we copy the formula from cell I4 to cell I5 is = (H5 / 500) * 100.

Specification 4 — The formula that should be entered in cell C9 to calculate the average marks in English is = AVERAGE (C4 : C8)

Specification 5 — The range of cells that needs to be selected to plot a column chart of students name against the marks in English is B4 : C8.

Specification 1 — The chart that has been used in the figure is line chart. It illustrates trends in data at equal intervals. The given chart illustrates the variation in temperature in a given year.

Specification 2 — The temperature in Sydney in the month of November is 20 degree Celcius.

Specification 3 — Dubai is the hottest city in the month of August.

Specification 4 — The country which generally has the lowest temperatures across the year is Paris.

Specification 5 — A chart is a graphical representation of data in a worksheet. It helps to provide a better understanding of large quantities of data. Charts make it easier to draw comparison and see growth, relationship among the values and trends in data. They provide an accurate analysis of information.

Another type of chart is column chart.

1. Presentation — A presentation is a collection of slides arranged in a sequential manner to convey, persuade, motivate, entertain or to provide information.

2. Creating a slide — A slide can be created by following the given steps:

   1. Click on New Slide option present in the Slide group on the Home tab. A drop-down box will appear.
   2. Select the required slide layout and click on it.

3. Workspace Views (any two views) — The two slide views in PowerPoint are as follows:

   1. 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.
   2. 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.

4. Animations — Animation effects can be applied to individual elements on a slide, allowing for more dynamic and engaging presentations.

5. 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.

a. Hari has been a victim of phishing.

b. The mistakes made by Hari include the following:

1. He clicked on an unverified link.
2. He did not check if the URL was secure i.e., had an 'https' in the web address.
3. He provided personal and sensitive information (bank account details) on an unsecured form
4. He shared the received OTP with the unknown caller.

c. Two safety measures Hari can take to avoid such mistakes in the future are:

1. Engage in safe web browsing — Do not open any link from unknown sources or any pop up that appears. Both could be spyware used to plant tracking cookies on our machine, which can steal our information, direct us to bogus phishing sites, and pound us with pop-ups.
2. Avoid sharing personal and sensitive information over phone call — Never share sensitive information such as OTP, bank account details, credit card numbers, usernames, passwords, etc. over a phone call with an unverified caller.

d. Apart from bank account details, other types of data that can be stolen are credit card numbers, usernames, passwords, aadhaar numbers, etc.

e. Another type of cyber crime is cyber stalking. It refers to online stalking where someone uses Internet, chat rooms, social networking sites, emails etc. to stalk his/her victim. Cyber stalker follows the victim online everywhere and keeps posting/sending something which are unsolicited.