Computer Class-8 Guess Paper (Subjective)

 

 (25 VVIP) Short Response Questions and Answers:

Q1. Differentiate between LAN and WAN? 

Ans:

LAN	WAN
1. LAN covers a limited area	1. WAN covers a large geographical area
2. Data transfer speed is faster	2. Data transfer speed is slow in WAN
3. LAN is inexpensive	3. WAN is expensive
4. LAN is usually connected through wires.	4. WAN is usually connected through telephone lines

 

Q4. Differentiate between wired and wireless networks.

Ans:

WIRED NETWORK	WIRELESS NETWORK
1. Wired required a physical path for transmission.	1. Wireless does not require a physical path for transmission.
2. Wired network is more secure	2. Wireless network is less secure
3. Wired network is faster	3. Wireless network is slower than a wired network
4. twisted pair, coaxial, and fiber optic medium is used in a wired network.	4. Satellite and microwave communication media is used in wireless networks.

 

Q3. List different tasks that can be performed by robots?

Ans:
There are different tasks performed by robots. Robots are widely used in automobile manufacturing, Packaging, laboratory research, and cleaning home.

Q4. Why distributed applications are used? List some distributed applications?

Ans: 

It is used when the workload is too much for a single server to handle. Some example of distributed applications is cellular networks, online banking, social networks, supermarket check-out system, etc.

 

Q5. What is the purpose of block chain technology?

Ans: 
Purpose of block chain:

It is a type of database that provides a secure digital information recording. The block chain database is used in banks and financial services for the secure recording and sharing of digital information such as transactions.

 

Q6.  What is the purpose of the formula bar?

Ans:.

The formula bar is located above the frame. It is used to enter or show the formula or function in a cell.

 

Q7. Differentiate between workbook and worksheet.

Ans:

Worksheet: 

The collection of rows and columns is called a worksheet. It consists of
cells to enter data. By default, there are three worksheets in a workbook.

Workbook: 
It is a collection of worksheets. By default, it has 3 worksheets but we
can add more sheets. An Excel document is called a workbook.

 

Q.8. What do you mean by spreadsheet?

Ans:

A spreadsheet is a digital form of a paper-based worksheet. It consists of rows and columns. The intersection of row and column is known as a cell where all the data is filled to apply operations. Commonly used spreadsheet software are: 

Microsoft Excel, Open Office Calc, Google sheets

 

Q9. Differentiate between copy and cut commands.

Ans:

Cut: 
The cut command removes the selection and puts it on the clipboard. Which can be pasted anywhere. It simply moves the data

 

Copy: 
It makes a duplicate of the selection and puts it on a clipboard which can be pasted anywhere in many places.

 

Q10. Define a function in MS Excel?.

Ans: 

A function is a predefined formula that quickly calculates the result of the given values. e.g. SUM(C5: E5)

 

Q11. Write the purpose and syntax of the following functions:
SUM(), AVERAGE(), IF(), MAX(), MIN()

Ans: 

SUM(): 
It is used to calculate the sum of the given values.
Examples: SUM(C5:B10) will find the sum of all the values of cells B5 to B10.

AVERAGE(): It is used to find the average of the selected cells.
Examples: AVERAGE(B5:B10) will find the average of all the values of cells B5 to B10.

IF(): 

It is used to return a value out of given values depending upon applied conditions.

e.g. IF(B5>=33, “PASS, FAIL”) will show PASS if marks are greater and FAIL otherwise.

 

MAX(): 

It is used to find the greatest value in the selected cells.
Examples: MAX(B5:B10) will find the greatest values among all values in cells B5 to B10.

MIN(): It is used to find the smallest values in the given range of cells.
Examples: MIN(B5:B10) will find the smallest values among all values in cells B5 to B10.

Q12. Demonstrate the main steps to solve the problem.

Ans:

To solve a problem, we follow the following steps

1.   Understand the problem

2.   Formulate the model

3.   Develop an algorithm

4.   Write the program

5.   Test the program

6.   Evaluate the solution

 

Q13. Define Program.

Ans: A program is a set of instructions that are written in a programming language to solve a problem.

 

Q14. Define Pseudo code.

Ans: 

“Pseudo code” is helpful for programmers to interpret the algorithm in any programming language of the programmer’s choice. Pseudocode is pronounced by keeping the first character ‘P’ silent and breaking the reaming word into two parts so ‘pseudo’ and ‘code’.

 

Q15.  Define Algorithm.

Ans:

The algorithm is the step-by-step procedure to solve a problem. We can write it in any general language.

 

Q16. Who is a cyber-scout? How can he/she assist in the prevention of cybercrime?  

Ans:

A cyber scout is a person with a unique aim to promote awareness about cybercrime in society. A cyber is trained to identify cybercrime activities and equipped with adequate preventive knowledge to help fight this menace. He understands the risks associated with virtual socializing and works to promote cyber safety in his surrounding environment. A cyber scout plays a vital role to create cyber awareness among fellow students, teachers, and parents.

 

Q17. How spyware can be harmful?

Ans: 

Spyware will track web browsing history, passwords, and other private information, such as E-mail addresses, credit cards number, personal identification numbers, or banking records. All of this information can be gathered and used for identity theft or sold to third parties.

 

Q18.  Define cyber-crime?

Ans: It is a criminal activity carried out by means of a computer or the internet. For example, pishing, emails, cyberstalking, identity theft, etc.

 

Q19. Define computer ethics?

Ans:

It is the application of moral principles to the use of computers and the internet.
Examples include intellectual property rights, privacy policies, online etiquette, etc

Q20.  Define digital plagiarism?

Ans:.

Plagiarism is an act of copying and publishing another person’s work without proper citation. It’s like stealing someone else’s work and releasing it as your own work.

 

Q21.  Define cyber-bullying?

Ans:.

Copyright law understands an intellectual copyright granted by the government that gives the owner exclusive rights to use the original expressive work with some limited exceptions.

 

Q22. What is the difference between payment and transactions?

Ans:

Payment:

It is the transfer of money against the purchase of goods and services.

Transactions:

It is an agreement between a buyer and seller to exchange goods, services, or financial assets in return for money.

 

Q23. Write down the three advantages and three disadvantages of digital marketing?

Ans:

Advantages: 

1.    Removed all sorts of geographical barriers.

2.    Extremely low risks

3.    Wins customer loyalty

Disadvantages:

1.    Depends on technology

2.    Security, and privacy issues

3.    Worldwide competitions through globalization

Q24.  Define digital marketing?

Ans:

Digital marketing is a tool used to promote brands and connect with potential customers online

 

Q25.  Define digital plagiarism?

Ans:.

Plagiarism is an act of copying and publishing another person’s work without proper citation. It’s like stealing someone else’s work and releasing it as your own work.

Q1.  

A. What is a chart? How can you insert a chart in MS Excel?

Ans:

The chart is a graphical representation of data in a worksheet. It is used for easy and quick analysis. Some types of charts are:

• Bar chart
• Line chart
• Pie chart

The chart can be inserted as:

1.    Select the cells containing data.

2.    Click on the “chart option” in the insert ribbon.

3.    Select the type of chart you want to insert.

B.  What are the steps to create a Pie chart?

Ans:

The steps to create a Pie chart are:

1.    Select the cells that contain data to be used in the chart.

2.   Click on the Chart button from the INSERT tab.

3.    Click on the Pie chart button from the list.

4.    Hence the Pie chart will be inserted.

 

Q2. Take a 4-digit number as input for a year and check if the year is a leap year or not. Display your output as: the year 1979 is not a leap year or the year 2020 is a leap year.

Ans:

program:

# Python program to check if the year is a leap year or not 
Year = 1979 and 2020

# To get the year (integer input) from the user
# year = int (input (“Enter a year: “))

# Divided by 100 means century year (ending with 00)
# Century year divided by 400 is a leap year 
If (year % 400 == 0) and (year % 100 == 0) : 
        Print (“{0} is a leap year”. Format(year))

# Not divided by 100 means, not a century year
# year divided by 4 is a leap year 
elif (year % 4 == 0) and (year % 100 != 0) :
        Print (“{0} is a leap year”. Format(year))

# if not divided by both 400 (century year) and 4 (not century year)
# Year is not leap year 

Else: 
        Print (“{0} is not a leap year”. Format (year))

 

Output:
1979 is not a leap year
2020 is a leap year

 

 

Q3. Why do we need cybercrime laws? 

Ans:

Cybercrime laws are the standard of acceptable behavior for information and communication technology (ICT) users. 

 

These laws include:

• Establish socio-legal sanctions for cybercrime. 
• Protect ICT users, in general, and mitigates and/or prevent harm to people, data, systems, services, and infrastructure. 
• Protect human rights. 
• Enable the investigation and prosecution of crimes committed online. 
• Facilitate cooperation between countries on cybercrime matters.

 

 

Q4.  Describe the basic components of a business plan?

Ans:

1. Customer needs:

A customer needs analysis is the process of identifying the requirement of the customer about a product or service. The need can be known or unknown. The goal of the customer need analysis is to determine the market gaps for new products to launch and penetrate the existing market.

2. Product design:

Product design is the process that involves steps to launch a successful product based on user requirements and ultimately acquires customer satisfaction, theoretically. The key to successful product design is to understand the exact requirement of the end-user for whom the product is being designed

3. Costing:

A business plan includes the set-up estimated costs like legal costs, attorney fees, license fees, etc. The plan should also include funding to cover other expenses, revenue collected against sales, and profit or loss.

4. Operations:

The operation includes the objectives, goals, procedures, and timeline of your organization. An operation plan assists the businessman to meet deadlines. The operation component of the plan would include procurement, manufacturing, and logistics strategies that enable the firm to boost production to support revenue growth.

5. Marketing:

It is the action or business of promoting and selling products or services, including market research and advertising. The marketing plan includes the identification of a product, determining demand, deciding on its price, and selecting distribution channels.

 

Q5. Describe the four elements of marketing?

Ans:

1. Product:

A product (goods and services) is the main entity that your business offers to the end-users. 

2. Price:

Price is an important element to decide to keep in mind the competitive price of the product. For example, a cheaper product is always less in quantity.

3. Promotion:

This includes the packaging and position/place of the product or service in the marketplace, where customers can be attracted. Marketing tools are used to promote the sales of a particular product or service.

4. Place:

The success of the business is also based on the location of the outlet and the made of sale either by e-commerce or telephone or your product being carried in retail outlets.

 

Q6. a. Explain the feature of the information processing model.

Ans:

A computer is a problem-solving machine. The main features of the Computer process model are Input, Processor, output, and Memory.

Input is data that we enter with the help of input devices like a keyboard, mouse, scanner, etc. while the processor process data, and output are the processed data or information. While data and information are stored in a memory location.

 

b. Demonstrate the main steps to solve the problem.

Ans:

To solve a problem, we follow the following steps

1.   Understand the problem

2.   Formulate the model

3.   Develop an algorithm

4.   Write the program

5.   Test the program

6.   Evaluate the solution