Sunday, March 8, 2015

Creating a Pie Chart in Microsoft Excel Tutorial With Pictures

Why Do We Use Excel Pie Charts?

Excel Pie Charts are used in a Microsoft Excel Worksheet to display the contribution of each cell value to the total value. Today, we will discuss the procedure of creating a Pie chart in Microsoft Excel. Start Microsoft Excel and perform the following steps as explained with the help of nice clear pictures.
Create Pie chart in MS Excel in easy practical steps
Creating Excel Pie Charts Easy Tutorial With Pictures

Steps To Create Pie Chart in Excel


1. Prepare Example Excel Worksheet For Pie Chart

Start Microsoft Excel with a new blank workbook. Microsoft Excel is a part of Microsoft Office.
Prepare a new Excel Worksheet as shown in the figure below to show Serial Numbers, Batsman and their Scores got in a cricket match. Fill in the sample data as you wish.

2. Select Cell Range To Prepare Excel Pie Chart

Select The Two Columns named Batsman and Scores with filled values and column titles, as shown in the figure above.

3. Use Insert Tab To Create Pie Chart

Click on Insert Tab and click on Pie Chart tool. Select a suitable type of Pie Chart, say we select the very first type from 2D pie charts. When you will click on this type of pie chart, the Pie Chart will be crated and shown in the you Excel worksheet as shown below.
Creating Excel Pie Charts Easy Tutorial With Pictures
Steps to create a PIE Chart in MS Excel

Making and Showing Excel Pie Charts
Explain the use of Pie Charts in Excel spreadsheet software

4. Changing Layout of Excel Pie Chart

You can change the layout of your Pie chart easily by selecting a suitable layout on Chart Tools as shown in the figure below
Changing Layouts of Pie Charts in Excel

5. Getting the Final Excel Pie Chart

As soon as you click on your selected layout, the Pie chart will be changed to new layout look as shown in the figure below.

How To Prepare an Excel Pie Chart
Thank you for coming and staying with us at Www.ForFreeEducation.Blogspot.Com a totally free blog for Perfect Computer Notes and much more.

You may also like to read:

Electricity Bill Calculator Formulas in Excel 
Microsoft Excel Formulas and Functions Fast and Easy Way -1

Using Simple Formulas in Excel With Arithmetic Operators 2

How Functions are Used in Excel Fast and Easy Way 3

Create Bar Chart in Excel Easily by Example

Employee Pay sheet Formulas in Microsoft Excel 

Students Test Score Grades Result Sheet in Excel

Microsoft Office Word Processing Practicals

Tuesday, March 3, 2015

Explain Procedural and Non Procedural Programming Languages

After reading this topic you will be able to clearly understand the meanings of Procedural and Non Procedural Languages and the differences between procedural and non procedural languages
Here is a brief note on procedural and Non Procedural Computer Languages:

Procedural Languages

Explain Procedural Languages and Non Procedural Languages in Computer Programming
Explain Differences between Procedural Languages and Non Procedural Languages in Computer Programming


In procedural languages a program is written as a sequence of instructions. We have to specify what to do and how to do. In procedural languages a program will tell the whole step by step procedure to perform a particular task or job.  So we provide a sequence of instructions and these instructions are executed in the given specified order. These instructions are written in order to solve a specific problem.
Procedural languages are also called 3rd Generation languages or 3GL.3GL languages are

Examples of procedural languages 

Examples of Procedural languages are FORTRAN, COBOL, BASIC, Pascal, C Language, C++, and Java etc.

a)    FORTRAN (FORrmula TRANslation)

FORTRAN is generally used by mathematicians to solve mathematical problems.

b)    COBOL (Common Business Oriented Language)

COBOL is one of the first popular programming languages for businesses.

c)    C – Language

C Language is one of the most popular high level programming languages. C language is used for System programming as well as for application programming. C language can be used to develop operating systems and application programs.

d)    BASIC (Beginners All Purpose Symbolic Language)

BASIC was developed for teaching purposes. It was used to teach how to program to students and beginners.

 Non-Procedural Languages

In non-procedural languages we have to specify only “what to do” and not “how to do”.  For example, SQL (structured query language) is a non procedural language. It is used in database systems.

Non Procedural languages are Fourth Generation Languages called 4GLs. In Non procedural languages we do not have to write whole set of instructions according to the logic of the program. But only one statement may be enough in a non procedural language to perform the whole job, for example select statement of SQL. Another example of non procedural languages is RPG

    a) SQL

SQL is the short form of Structured Query Language. Structured Query Language is the mopst popular database query language. SQL is used in Database Management Systems like Microsoft Access, ORACLE, MS SQL Server and MySQL.

    b) RPG

RPG is another example of a non procedural language. RPG stands for Report Program Generator. It is used for generating professional business reports.
   

Monday, March 2, 2015

Explain Different Types and Differences of Programming Languages and Differences

Topic: Explain Different Types of Programming Languages and Differences
What is a programming language?
Types of programming languages : Low level and high level programming languages with examples
Differences between low level and high level programming languages

What is a Programming Language?

A set of words, symbols and codes used to write programs is called programming language. Different programming languages are available for writing different types of programs.

Learn Programming now in easy steps from Perfect Programming Tutorial on EasyCodeBook.com

Explain different types of programming languages in detail
Explain different types of programming languages


With the help of computer language, a programmer tells a computer what to do. Some popular computer programming languages are C++, Java, Visual Basic etc. These are examples of high level programming languages. Whereas machine language and assembly language are called low level programming language.

Another Definition of a Programming Language

A programming language is a language that is designed to be used (read and written) by humans to create programs that can be executed by computers. In other words we can say that programming languages provides the way so that the users may interact with the computer to give it commands and instructions to perform certain tasks.

Types of Programming Languages

There are two main types of computer programming languages.
•    low-level languages
•    high-level languages.

Low Level Programming Languages

These languages are near to computer hardware and far from human languages. Computer can understand these languages easily.

Following are two low-level languages:
•     Machine Language
•     Assembly Language

Machine Language

Types of programming languages - Machine language

A computer language in which instructions are written in binary form (0 and 1) is called machine language. It is the only language that is directly understood by the computer. Machine language is the native language of computer.
A computer language in which instructions are written in binary form (0 and 1) is called machine language. It is the only language that is directly understood by the computer.

Advantages of  Machine Languages

a)    Very fast program execution: Because the machine language is the native language of computer that computers directly understand and execute. There is no need of a translator program, because computer can already understand and execute the machine language instructions directly without the need of translation.  

Disadvantages of  Machine Languages:

a)    Machine Language is difficult to understand
b)    Machine Language is difficult to learn
c)    Programs of Machine Language are difficult to modify
d)    Machine Language requires deep knowledge of hardware
e)    Programs of Machine Language are difficult to remove errors
f)    Programs of Machine Language are Machine dependent
Machine language is also known as first generation language.

 Assembly Language

Types of Programming Languages - Assembly Language
Assembly Language Example Code

Assembly language is a low-level language. In assembly language, symbols are used instead of binary code. These symbols are easy to remember. For example Add instruction is used to add two numbers.
Assembly language is also known as second generation language

Advantages of Assembly Langauge:

a) Assembly language programs are executed with fast speed
b) Assembly language programming is easier to learn, understand and modify than machine language
Disadvantages:
a)    Assembly language programs are machine dependent
b)    Assembly language programming requires deep knowledge of hardware

 High Level Programming Languages

A type of language that is close to human languages is called high level language. High-level languages are easy to understand. Instructions of these languages are written in English-like words e.g. Print, Display, Write etc.

  Examples of High Level Programming Languages



Types of Programming Languages - High Level Programming Language

 

Advantages of High Level Programming Languages:

Types of Programming Languages - Advantages of High Level Programming Language

a) High Level Programming Languages are Easy to learn and understand
b) Programs written in High Level Programming Languages are Easy to modify
c) It is Easy to remove errors in the Programs written in High Level Programming Languages
d) Programs written in High Level Programming Languages are Machine independent
e) High Level Programming Languages have Better documentation

Disadvantages of High Level Programming Languages

a) A disadvantage of High Level Programming Languages is slower program execution.
b) High Level Programming Languages provide programming facilities for performing Certain operations.

An Introduction To High Level Programming Languages

FORTRAN

FORTRAN stands for FORmula TRANslation. It is mainly used for writing applications related to science and engineering fields.

BASIC

BASIC stands for Beginners All-purpose Symbolic Instruction Code. It was invented in late 1960's to teach programming skills to students.


COBOL


COBOL stands for Common Business Oriented Language. It was especially designed for business applications.


C Language



C Language is one of the most popular programming language among students and beginners in the field of computer programming. C Language was designed by Dennis Ritchie at AT&T Bell Labs in 1972. Sometimes C Language is called a middle level language because it provides facilities to develop application software as well as system software. So C Language combines some important qualities of a high level language and a low level programming language.

Difference between Low-level and High-level Programming Language


High-level Language

Low-level Language

1.   High-level languages are easy to learn

1. Low-level languages are difficult to learn.

2.   near to human languages.

2, far from human languages.

3.    Programs in high-level languages are slow in execution.

3. Programs in low-level languages are fast in execution.

4.    Programs in high-level languages are easy to modify.

4. Programs   in   low-level   languages   are difficult to modify.

5.    Deep   knowledge   of hardware   is  not required to write programs.

5. Deep knowledge of hardware is required to write programs.


Topic: Explain Different Types of Programming Languages and Differences What is a programming language? Types of programming languages : Low level and high level programming languages with examples Differences between low level and high level programming languages