L-5 Generations of Programming Language / Class-6 Computer

 

Class 6^th

Subject – Computer

L-5 Generations  of Programming Languages

Make a table to show the generation of Language

Generation	Language
First	Machine Language	Machine language is the only programming language that the computer can understand directly without translation. It is a language made up of entirely 1s and 0s.
Second	Assembly language	An assembly language is a type of low-level programming language that is intended to communicate directly with a computer's hardware. Unlike machine language, which consists of binary and hexadecimal characters, assembly languages are designed to be readable by humans.
Third	High-level language	high-level languages, are very much like everyday text and mathematical formulas in appearance. They are designed to run on a number of different computers with few or no changes.
Fourth	Very High-level language	A very high-level programming language (VHLL) is a programming language with a very high level of abstraction, used primarily as a professional programmer productivity tool.
Fifth	Artificial Intelligence	The goal of fifth-generation computing is to develop devices that respond to human language input and are capable of learning new behavior patterns and self-organization

 

Fill in the blanks:-

1. In order to make computers work for us, some sort of instructions must be stored in some kind of language.

2. A programming language consists of a vocabulary and a set of rules   (called syntax) that the programmer must learn.

3. A mnemonic  is an alphabetical abbreviation used as memory aid.

4. Machine Level language  is the only programming language that the computer can understand directly without translation.

5. A fifth- generation languages or 5GL is a graphical development interface which is used to create source languages that are usually compiled with 3GL  or 4 GL  compiler.

6. A language translator is required to convert a high level language  program into machine language.

 

State True or False:

1. Humans communicate with one another in some language, like English, German or in many other languages.                              TRUE

2. 5GL is machine dependent language.                              FALSE     

3. Assembly language is a language made up of entirely 1s and 0s.         FALSE

4. Fourth generation languages increased the speed of developing programs.                                                                                        TRUE

5. Artificial Intelligence (AI) has developed in 2GL.           FALSE

 

Short answer type questions.

1. Define Programming Language.

Ans: A programming language is a set of written symbols that instructs the computer

hardware to perform specific tasks.

 

2. What do you mean by machine Language?

Ans: Machine language is the only programming language that the computer can

understand directly without translation. It is a language made up of entirely 1s

and 0s.

 

3. What is mnemonic code?

Ans: A mnemonic code is an alphabetical abbreviation used as memory aid.

 

4. Define Artificial Intelligence.

Ans: Artificial Intelligence means  natural language touches on expert systems,

computerized collection of the knowledge of many human experts in a given field, and artificial intelligence, independently smart computer systems.

 

Long answer type questions:

1. What are the differences between Machine Language and Assembly language?

Ans:

Machine Language	Assembly Language
Machine language is the only programming language that the computer can understand directly without translation. It is a language made up of entirely 1s   and 0s.	Assembly languages use mnemonic operation codes and symbolic addresses in place of 1s and 0s to represent the operation codes.

 

 

2. Write five basic language tools used in Fourth Generation languages.

Ans: Five basic types of language tools fall into the fourth generation language category.

1. Query languages

2. Report generators.

3. Applications generators.

4. Decision support systems and financial planning languages.

5. Some microcomputer application software.

 

3. Write three main objectives of High level languages.

Ans: Objectives of high-level languages

1)   To relieve the programmer of the detailed and tedious task of writing programs in machine language and assembly languages.

2)   To provide programs that can be used on more than one type of machine with

very few changes.

3)   To allow the programmer more time to focus on understanding the user's needs

and designing the software required meeting those needs.

 

4. Write some limitations of low-level languages.

Ans:Limitation /  Disadvantages of low level languages

1)    Programs developed using low level languages are machine dependent and are not portable.

2)    It is difficult to develop, debug and maintain.

3)    Low level programs are more error prone.

4)    Low level programming usually results in poor programming productivity.

 

 

L-5 Advance in Ms-Excel / Clas-5 Computer

 

Class – 5^th

Subject : Computer

L-5 Advance in Ms Excel

Paste and label components of Ms-Excel window components

Q : Define Ms-Excel.

Ans:Microsoft Excel is a software program produced by Microsoft that allows users to organize, format and calculate data with formulas using a spreadsheet system. This software is part of the Microsoft Office suite 

Q : Define Formula.

Ans : A formula is an equation that makes calculations based on the data in your spreadsheet. Formulas are entered into a cell in your worksheet. They must begin with an equal sign, followed by the addresses of the cells that will be calculated upon, with an appropriate operand placed in between.

Q : Define Function .

Ans : A function is a predefined formula that performs calculations using specific values in a particular order. Excel includes many common functions that can be used to quickly find the sum, average, count, maximum value, and minimum value for a range of cells.

Make a list of Different function

S.No.	Function	Use	Syntax
1	Sum	It is used to calculate the sum of given range similar to Autosum Function.	=SUM(Number1, Number2……)
2	Average	It is used to calculate the average of given range of numeric values.	=AVERAGE ( Number1:Number2)
3	Maximum	It is used to find out the maximum value ( Largest Value) from a given range of numeric values.	=MAX ( Number1:Number2)
4	Minimum	It is used to find out the minimum value ( smallest Value) from a given range of numeric values.	=MIN ( Number1:Number2)

 

A. Fill in the blanks :

range of, chart, ascending , tabular, sorting, descending

1. Comparison of data in Microsoft Excel can be done with the help of

Chart .

2. In MS Excel data can be arranged in tabular  form.

3. Autosum function can be used only with range of  cells.

4. Sorting can be ascending  or descending order.

5. sorting   is used to arrange data in smallest to highest order.

35B. Very Short Answer Questions:

1)  Give two uses of MS Excel.

Ans: 1) Easiest way to perform calculation

2) Automatically recalculation if altered the data.

 

2)  What is Autosum Function?

Ans: Autosum function is used to calculate the sum of given range of numeric values.

 

C. Short Answer Questions:

1) Differentiate between Max Function and Min Function.

Ans:

Max Function	Min Function
It is used to find out the maximum value ( Largest Value) from a given range of numeric values.	It is used to find out the minimum value ( smallest Value) from a given range of numeric values.
Syntax of MAX Function =MAX ( Number1:Number2)	Syntax of MIN Function =MIN ( Number1:Number2)

 

 

2) Define Average Function.

Ans: Average function is used to calculate the average of given range of numeric values.

Syntax of AVERAGE Function

=AVERAGE ( Number1:Number2)

 

D. Long Answer Questions:

1)   Define Sum Function.

Ans: In SUM function is used to calculate the range of cells to calculate their sum. Syntax of SUM Function

=SUM(Number1, Number2……)

 

2)   What is sorting?

Ans: SORTING : it is the process to arrange the data in ascending or descending order. Data can be alphabetic or Numeric

Ascending Order : It is used to arrange data from smallest to highest order.

Descending Order : It is used to arrange data from highest to smallest  order.

  

E. Name the following:

1)   Easiest way to perform calculation.

Ans: Ms-Excel

 

2)   It can be used only with contiguous cells.

Ans: Autosum

 

3)   It is used to arrange data in smallest to highest order.

Ans: Sorting : Ascending