class 7th 1st Q&A | Computer Virus | Html Element

RAO's MY TECHNO SCHOOL Class: VII COMPUTER FUNDAMENTALS Chapter: 1 Question and Answers 1) What are supercomputers? Write two differences between supercomputers and mainframes? A) Super computer is one that is capable of working at high speeds, and can process a very large amount of data within an acceptable time. Differences 1) Super computers are structured to support very complicated and complex calculation that are processed and stored largely in the memory. 2) Super computers are used for processing scientific and military data. 1) Mainframes aim to handle huge amounts of  external data accessed from databases involving simple calculations. 2) Mainframes are meant for business and civilian government applications.

2) What is an operating system? Why is an operating system a must for a computer? A) •

•

Operating system is the interface between user of computer and computer hardware. It is an important i mportant component component of the computer system, because it sets the standards for the application programs that run on it. Operating system controls the execution of programs.

3) What are the main functions of a compiler and an interpreter? i nterpreter? Write the difference between them? A) Compiler is a program that takes a program written in a high-level language and translates into Machine language. •

•

An interpreter is a program that analyzes each line of code in the high level language program the source program and then carries out the specified actions.

Difference The program produced by the compiler is saved permanently for future reference. Compiler works faster. •

•

The object code of the statement produced by an interpreter is not saved. An interpreter works slower.

4) Name the two types of low-level languages? A) Machine languages Assembly languages • •

5) What are high level languages? Write three examples? A) High level languages emerged in mid-1950s.they are widely used in developing programs. The high level language is easier for the programmer to use than the low level languages. High-level languages are machine independent. EX: BASIC, COBOL, FORTRAN, C++

Class: VII

FORMULAS IN MS EXCEL Chapter: 2

QUESTION AND ANSWERS 1) Write the four elements that an excel formula can contain? A) Value:-numeric (such as 3, 32, 3.3) or, string (such as ‘poonam’, Rajan’) Cell/Range of cell reference: A5, A6... Function: SUM, AVG, MIN, MAX... Operator: +,-,*... •

• • •

2) What things should we remember while writing a formula in a formula bar? A) Values may be numeric or string. All four mathematical functions are possible only with numeric values. Only addition is possible with a text string or text values. •

•

A reference identifies a cell or a range of cells in a worksheet. It tells MS Excel where to find values or data that are needed in a formula.

3) What do you understand by concatenation? Explain with an example. A) •

•

•

No mathematical function except addition can be performed on a sequence of characters. The process of joining text values in a series is called concatenation. Ex:-to create a simple text value, type words in double quotes ex English. To concatenate two text values, we use the ampersand (&) character. =”English” & “Hindi”. In the formula bar and pressing enter will produce the result as English Hindi.

4) Describe the AutoSum feature of MS Excel? A) The auto sum feature automatically calculates the Sum of numbers. 5) What is a function? A) A function is a predefined formula for performing a particular task.

Class: VII

MORE ON MS EXCEL 2007 Chapter: 3

QUESTION AND ANSWERS 1) What do you mean by the term sorting of  data? A) Arranging the given data in a specified order is called sorting. 2) What is data filtering in MS Excel? A) The filter feature helps us to hide that part of the information entered in the worksheet that we do not want to see. Filtering is an easy method for finding and working with parts of data in a range. 3) Name the two options available in MS Excel for data filtering? A) Auto filter Advanced filter • •

4) What is the difference between filtering and sorting data? A) •

•

The filter feature helps us to hide that part of  the information entered in the worksheet that we do not want to see. Filtering is an easy method for finding and working with parts of  data in a range. Sorting is a very important feature of MSExcel. Sorting means arranging the given data in a specified order. The data may be textual, numeric or alphanumeric.

5) What do you understand by the term conditional Formatting? A) Conditional formatting is an important feature in MS Excel. It determines a cell’s format according to the specified conditions specified by the user.

Class: VII CHARTS IN MS EXCEL 2007 Chapter: 4 QUESTION AND ANSWERS 1) Write the use of charts in MS Excel? A) Charts represent any information in very interesting and effective manner. They make the information easier for the readers to understand and interpret. 2) Build any five charts in MS Excel? A) • • • • •

Column chart Pie chart Bar chart Area chart Scatter chart

3) Write short notes on A) (i) column chart A) A column chart represents the changes in data over a period of time. (ii) Doughnut chart A) A doughnut chart displays the relationship of  parts or a whole.

(iii) Scatter chart A) It is similar to XY chart. No lines appear in this type of chart to represent the data marks.

(iv) Pie chart A) A pie chart is useful to plot data for a single data series. 4) Write the difference between a column chart and a bar chart? A) Column chart mainly illustrates a comparison among items. In this chart, categories are taken horizontally values vertically. In a column chart, each of the columns that rise from the X-axis represents data point in a series. •

•

Bar chart is also used to see comparisons among individual items. Categories are organized on the Y-axis and values are organized on the X-axis. We can also describe it as a column chart drawn sideways.

5) Name and briefly describe any five components of a chart? A) • • • • •

Data series X-Axis Chart title Axis title Chart Area

1) Data series:A) It refers to those data series from which a chart is derived. 2) X-Axis:- x-axis is the horizontal axis of the chart. It is also called the category axis. 3) Chart title: - it is usually written at the top of the chart and helps the reader to understand what the chart represents. 4) Axis title:It is the title given to the axes. A 2-D graph has two axes(X and Y) and a 3-D graph has three (X, Y and Z). 5) Chart Area: - it refers to the area within which all chart components are found.

6) What steps do we use to change the chart style? A) Step1:-The chart tools under design top appear automatically. •

•

•

•

Step-2:-click change chart style in Design if you want to change the chart style for your data. Step-3:-a change chart style dialog box appears with many figures. Step-4:-select a chart style for a change and click OK. The selected chart will be constructed on the basis of your selected range.

7) What steps do we follow to move a chart from one location to another? A) •

•

•

Step-1:-your chart can be moved to a new location. For this click on Location. A Move Chart dialog box appears. Here you can choose whether the chart is placed on a new worksheet or on any of the existing worksheets.

Class: VII

HTML BASICS

Chapter: 5

QUESTION AND ANSWERS 1) What do you understand by a website? What are its three main sections? A) A collection of web pages containing text, graphics, sound and video content is called website. •

The home page

•

The main section

•

Subsection

2) What is a Home Page? A) Home page is the first page of the website. This page usually tells the visitors what the site is about. 3) Define HTML? A) Html stands for Hyper Text Markup Language which is used for organaising, formatting and linking pages of text, graphics and other information. 4) Name the two types of HTML editors giving an example of each? A) WYSIWYG Text Editor

5) Write the difference between container elements and empty elements? A) Container elements:The HTML elements that include both ON and OFF tags called the container elements. These tags wrap around the text in the document. (ON tag) types of computer (OFF tag) Empty elements:The HTML elements that need only an ON tag and do not OFF tag are called the empty elements. For example, tag does not required closing tag. The tag is used for line break. 6) List any four rules for writing an HTML page? A) 1) Element names are not case sensitive. It means they can be given in upper or lower cases. 2) Similarly, either case can be used to specify attribute names. 3) Attribute values can be sensitive. 4) Element names cannot contain spaces. 7) Describe the basic structure of an HTML page? A)

Class: VII BASIC HTML COMMANDS Chapter: 6 QUESTION AND ANSWERS 1) Name any three attributes used with the BODY tag. A) BGCOLOR (value: Color Name) BGCOLOR (value: Hexadecimal code) TEXT (value: Color name) 2) What is the use of line break and tags? A) The tag is used to insert a line break in a document. is used to draw a horizontal line across the page. 3) Write the HTML code to set the background colour pink and text color green? A) 4) How would you insert a comment in an HTML document? notepad is very useful software. 5) Describe the Bold, Underline and Italic tags by giving at least one exam A) The bold tag is used to make the text in bold face. Susana The italic tag is used to make the text italicized.

Susana The underlined tag is used to make text underlined. srujana

Class: VII

INTERNET

Chapter: 9

QUESTIONS AND ANSWERS 1) What does the term surfing mean in context of the internet? A) Navigating for information on the internet or simply exploring the internet is known as surfing. 2) What are search engines? What are their uses? A) A search engine is a software that helps us in web surfing. It looks for WebPages and online sites for specified keywords and displays a list of websites. 3) Write any two examples of search engines. A) Google Yahoo 4) Write about any three means of  communication on the Internet? A) Chatting is a very popular form of  communication. It is a conversation between two or more people. It is different from sending and receiving email. Newsgroups are discussion groups on the net. The topics used for discussion can range from recreational activities to scientific research. Article there are thousands of forums for a number of subjects. Queries on the topics to discuss can be sent in by the members of the forum through email.

5) Write some examples of acronyms and emotions. A) AFAIK As Far As I Know BRB Be Right Back LOL Laughing Out Loud A face to show that you are happy.  A sad face to show that you are not happy. :-( It shows that you are very sad and crying. 

6) How are newsgroups different from emails? A) The difference is that instead of sending your messages to someone’s mail box, the message is posted on a bulletin board where anyone can read it and respond. 7) How does a video conference take place? A) A camera records the video of the sender. This video is changed into compressed digital signals. These signals are transmitted to the other computers. In the other computer, the signals are converted back into the video and are displayed on the computer screen.

Class: VII COMPUTER VIRUS

CH: 10

Question and Answers 1) What are viruses? Give some examples? A) This is the programmed that can spoil your toil for years. Trojan Nimada Stoned. 2) To what extent can a virus harm us? A) It can infect executable program files such as word processors, spreadsheets, windows. It can infect disks by attaching itself to special programs in the hard disk called boot record. It can infect a file before it is attached to an email message or transferred to a disk. 3) To what extent can a virus not harm us? A) It cannot harm files on write-protected disk such as a CD-ROM. It cannot infect computer hardware such as a monitor or a keyboard. It infects only software’s. 4) How do viruses spread? A) People who write virus programs create harmful programs and store them in floppies or CD-ROMs. When these floppies or CD ROMs are circulated in the market with virus programs, viruses find place in other computers in which they are used.

5) Name any four types of viruses? A) Program viruses. Boot virus Macro virus 6) What do you understand by an antivirus Software? A) The antivirus software refers to the application package that is designed to detect and remove viruses from a computer system.