Perfect Computer Notes

Find Your Correct Age From Date of Birth

2023-09-16T18:44:00.008+05:00

First of all click on First two digits to type Month number from keyboard like any number from 1 to 12. . Now click on next two digits and type day number of month that is date from 1 to 31. In the last step type the year of your birth in four digits like 1995.

Now click on the blue button with text "Calculate Age". Your accurate age will be displayed below the button. For example. If today is 09-16-2023 that is September 16, 2023 and you type birth date as 11-01-2000 that is November 1, 2000, your accurate age will be displayed as:Your age is 22 years, 10 months, and 15 days.

Age Calculator

Calculate Your Age Now!

Enter your date of birth:

As shown in the image below:

Convert Centimeters to Inches Python Programming | Python Program Conver...

2020-10-08T08:16:00.004+05:00

YouTube Video Tutorial How to write a Python program to convert centimetres to inches

Formula to convert centimetres to inches

Explanation of this Python Program

This Python program prompts the user to enter a height in inches, converts it to centimeters, and then prints the converted value. It uses the conversion factor of 2.54 to perform the conversion and rounds the result to two decimal places before displaying it to the user.

Here's an explanation of the provided Python program line by line:

python
inches = float(input('Enter the Height in inches to convert into centimeters:'))

This line prompts the user to enter a height in inches and assigns the entered value to the variable inches.
The input() function is used to receive input from the user, and float() is used to convert the input into a floating-point number.

python
centimeters = inches * 2.54

This line calculates the equivalent value in centimeters by multiplying the inches variable by the conversion factor 2.54.
The result is assigned to the variable centimeters.

python
centimeters = round(centimeters, 2)

This line rounds the value in centimeters to two decimal places using the round() function.
The rounded value is then assigned back to the centimeters variable.

python
print(inches, 'Inches =', centimeters, 'Centimeters')

This line displays the result of the conversion to the user.
The print() function is used to output a formatted string that includes the original inches value, the equal sign, and the converted centimeters value.

Use Microsoft Excel Online [ 2020 ] Free Spreadsheet

2020-04-30T10:40:00.002+05:00

Topic: Use Microsoft Excel Online Free Spreadsheet

How To Create Excel Worksheet Online Free

Don't worry if you are to prepare a worksheet in Microsoft Excel and you have not purchased Microsoft Office software. You can use free online version of Microsoft Excel Online and create
worksheets as you like. Following are the instructions on how to use Microsoft Excel Online.

Use Microsoft Excel Online Free Spreadsheet

Here are the easy steps to create power calculator worksheet using Microsoft Excel Online free.

1. for this purpose you need to have a Microsoft Account.

2. Type or copy paste the following address in your web

browser's address bar
https://office.live.com/start/excel.aspx

Login To Your Microsoft Account. If you are not using any Microsoft account, please create an account now.

3. Login to your Microsoft account ( like abc@hotmail.com or xyz@hotmail.com) or read this post to Create a new Microsoft account in easy steps.

Chose your Microsoft account

Select New Blank Workbook

4. Click on the New Blank Workbook option.

5. A blank Workbook will open. The worksheet named 'sheet1' is here to use for entring and processing your data.

6. Let's create a simple Power calculator worksheet.

7. Enter the sample data and apply some formatting as shown in the figure. Apply Merge and Center Option on the heading.

Enter Sample Data in Excel Worksheet Online

8. similarly, you can apply font color and fill color options as shown in the figure while selecting the text.

Insert a Function Power(number, power/exponent) in the required cell of the excel worksheet

9. This worksheet will use the function power(b3,c3) to calculate power of a number. The first number is in cell b3. the first power or exponent is in the cell C3.

10. After inserting the function in the cell D3, press Enter.

11. the result will be shown in the cell.

Copy the Formula Downwards in Excel Sheet

12. Now copy the formula by taking the mouse pointer to bottom right corner of the cell containing the formula. When a + sign appears, click left mouse button and drag down for the cells to copy formula. Note that you must keep the left mouse button pressed as long as you drag down.

Save Excel worksheet / Workbook Online

13. Now click on nine dot button from top left corner and save the excel workbook. This workbook will bbe saved inOneDrive online storage provided free by Microsoft.

Download Excel worksheet / workbook to your computer

14. You can rename the workbook or download your workbook in your own computer. For this purpose use the nine dot button and the options as shown in the figure.

Introduction to Algorithms and Algorithmic Notation With Examples

2020-04-14T23:42:00.003+05:00

Topic: Introduction to Algorithm and Algorithmic Notation With Examples

What is an Algorithm?

The step by step procedure to solve a particular problem is called an Algorithm. A Good Programmer always writes algorithms before developing programs.

Algorithmic Notation with example algorithms

Advantages of writing an Algorithm

The process of solving a problem becomes simpler and easier with the help of algorithm.
There are less chance of errors in the program, if we design algorithms before writing our programs in any programming language.
We can convert an algorithm into a program of any programming language.
It is not dependent on any programming language. Therefore it is easy to understand for anyone even without programming knowledge.

What is the Relationship between an Algorithm and a Program

Sponsored Links

An algorithm is the sequenc of steps to perform a task, whereas a program is the set of statements to perform a specific task. Normally, we will use a programming statement (instruction of a programming language) for each step of an algorithm.

For example, consider the following four steps of an algorithm of a program to find square of a number:

Print "Enter a number:"
Input a number in n.
Calculate square = n * n
Print "Square=",square

Now we will write the program instructions for the above steps of the algorithm:

1. printf("Enter a number:");
2. scanf("%d",n);
3. square = n * n;
4. printf("Square=%d",square);

Introduction to Algorithmic Notation

The algorithms are written using an algorithmic noataion. Normally there is no standard algorithmic otation. Every author uses his own set of algorithmic statements to design the algorithms.

For example, we will use the following set of statements as algorithmic notation to design the algorithms:

The Name of Algorithm

First of all we will write the name of the algorithm for example:
Algorithm square.

The Description of Algorithm

Here we will describe the purpose of the algorithm.
For example:
// This algorithm is used to input a number and display its square.

The Comments

The comments are used to explain the purpose of a step of an algorithm. For example:
// Compute square of the number n
square = n * n
We will use double slash // to start a single line comment.

The Variables

A variable is an entity whose value can be changed. It is used to store data. We do not need to declare variables. We simply use variables in an algorithm according to the requirements. We will use simple variable names in small letters. For example, n or num1, num2, square, factorial, first_name etc.

The Statements

There are differnt statements in an algorithmic notation to perform differnt tasks.

Input Statement

Inmput statement is used to input data into different variables.
For example:
Input a number in n.
Or more precisely
Input n
Input radius of circle in rad.
Note: rad is a variable to store the value of the radius of the circle.
Or more precisely,
Input rad

Output statement

The output statement is used to display string messages and the values of variables:
For example:
Print "Enter a number"
or
Print "Sum=",sum

Assignment statement

Assignment statement is used to assign a value to a variable or to calculate a formula. For example,
i = 1
or
sum = num1 + num2

If statement

If statement is used to decide the execution of a statement or a set of statements if the given condition is true.
For example:
If (num1 == num2)
Print "both numbers are equal"
End If

If Else Statement

If else statement is a two way selection. If condition is true, the if block is executed otherwise, the else block of statements is executed:
If (num1 == num2)
Print "both numbers are equal"
Else
Print "numbers are different"
End If

Repeat - For

A Repeat - for construct is a looping statement. It is used to execute a block of one or more statements repeatedly for a fixed number of times. For example: the following for statement print 1 to 5 numbers.
Step 1. Repeat steps 1.1 For i = 1 to 5 step 1
Step 1.1 Print i
End For

Repeat - While

A Repeat - While statement is used to execute a block of one or more statements as long as the given condition remains true. For example: Input a number, and sum it as long as we enter a number gretare than zero.


Step 1. sum = 0

Step 2. Print "Enter a number:"

Step 3. Input n

Step 3. Repeat Step 3.1,3.2,3.3 While ( n > 0)

               Step 3.1  sum = sum + n

               Step 3.2  Print "Enter a number:"

               Step 3.3  Input n

End While

Step 4. Print "Sum=",sum

Algorithm to Add Two Numbers

Algorithm Sum

//This algorithm inputs two numbers and display their sum.

// It uses three integer variables num1, num2 and sum.

Step 1. Start

Step 2. Print "Enter two numbers to Add="

Step 3. Input num1, num2

step 4. Calculate sum = num1 + num2

Step 5. Print "Sum=", sum

Step 6. End

Algorithm to Check whether Two Numbers are Equal

Algorithm Check_Equal

//This algorithm inputs two numbers and display if they are equal or not

// It uses two integer variables num1, num2

Step 1. Start

Step 2. Print "Enter two numbers to Add="

Step 3. Input num1, num2

step 4. If ( num1 == num2 )

Print "Both numbers are equal"

Else

Print "Both numbers are different"

End If

Step 5. End

Algorithm To Find Factorial of a Number

Algorithm Factorial

//This algorithm inputs a number and displays its factorial using Repeat-While

Step 1. Start

Step 2. Print "Enter a number:"

Step 3. Input n

Step 4. Set fact = 1, i = 1

Step 5. Repeat Step 5.1 To 5.2 While (i<=n)

Step 5.1 Set fact = fact * i

Step 5.2 Set i = i + 1

End While

Step 6. Print "Factorial =", fact

Step 7. End

Algorithms, Algorithmic Notation and Problem Solving

We have discussed the following concepts in this Algorithms and Algorithmic Notation tutorial:
Algorithms, Importance of Algorithm, Notation used to describe algorithms and some important examples of algorithms.

Converting Decimal Number system to Binary, Octal and Hexa Decimal with Examples and Vice Versa

2019-06-01T07:30:00.003+05:00

Topics covered with examples: Converting Decimal Number system to Binary, Octal and Hexa Decimal with Examples and Vice Versa

Number Systems in Computer Science and Conversion Method
Conversion of Decimal number system to other number systems

Conversion of Decimal number system to binary number systems

Conversion of Decimal number system to octal number systems

Conversion of Decimal number system to hexadecimal number systems

Conversion of non-decimal Number system to Other non-decimal number system

Conversion of other number systems to Decimal number system

Conversion of binary number systems to Decimal number system

Conversion of octal number systems to Decimal number system

Conversion of hexadecimal number systems to Decimal number system

Q1. What is a Number System? What are different types of number system?

Number system

A number system is a set of digits, symbols and rules to express quantities in counting and calculations. Following are the most commonly used number systems:

Number-systems-in-computer-science-easy-conversion-methods-with-pictures

Decimal Number System

It is most commonly used number system. It has 10 symbols{0,1,2,3,4,5,6,7,8,9}. It is also called base 10 number system. People normally use decimal number system to represent numbers.

Binary Number System

In binary number system there are only two symbols {0 and 1}. In a computer all data is represented by Binary number system. This is because computer’s electronic switches have only two states on and OFF. When a switch is ON it represents a 1 and when a switch is OFF, it represents a Zero.

Octal Number System

Octal number system consists of 8 digits{0,1,2,3,4,5,6,7}. Its base is 8. It is used as shorthand for long binary numbers. Each octal digit represents 3 binary digits.

Octal	Binary
0	000
1	001
2	010
3	011
4	100
5	101
6	110
7	111

Hexadecimal Number System

Hexadecimal number system is used to represent long binary numbers in an easy and short form. Its base is 16. It has sixteen symbols{0,1,2,3,4,5,6,7,8,9,A,B,C,D,E,F}. Each hexadecimal digit represents 4 binary digits.

Hexadecimal	Binary	Hexadecimal	Binary
0	0000	8	1000
1	0001	9	1001
2	0010	A	1010
3	0011	B	1011
4	0100	C	1100
5	0101	D	1101
6	0110	E	1110
7	0111	F	1111

Q2. Conversion of Decimal (Integer part) to other systems

a) 45₁₀= (?)₂

b) 119₁₀=(?)₈

c) 190₁₀=(?)₁₆

2	45
2	22-1
2	11-0
2	5 -1
2	2 -1
2	1 -0
	0 -1

8	119
8	14-7
8	1 -6
	0 -1

16	190
16	11-14(E)
	0 -11(B)

=> 45_{10 =}(101101)₂119₁₀=(167)₈190₁₀=(BE)₁₆

Q3. Conversion of Decimal system (Fraction part) to other systems

a) (.23)₁₀ = (?)₂

b) (.225)₁₀ = (?)₈

c) (.225)₁₀ = (?)₁₆

	Fraction	Integer
.23 X 2 = 0.46	.46	0
.46 X 2 = 0.92	.92	0
.92 X 2 = 1.84	.84	1
.84 X 2 = 1.68	.68	1
.68 X 2 = 1.36	.36	1

=> (.23)₁₀ = (.00111)₂[Similar method is used for decimal (fraction) to Octal (multiply by 8)and hexadecimal(multiply by 16)]

Q4. Conversion of Other systems (Integer part) to Decimal

a) (101101)₂=( ? )10 b) (167)₈= (?)₁₀(BE)₁₆=(?)₁₀

a) (101101)₂ =1x2⁵+0x2⁴+1x2³+1x2²+0x2¹+1x2⁰ = 32 + 0 + 8 + 4 + 0 +1 = 45	b) (167)8 =1x8²+6x8¹+7x8⁰ = 64 + 48 + 7 = 119
c) (BE)₂ =Bx16¹+Ex16⁰ = 11x16¹+14x16⁰ = 176 + 14 = 190

Q5. Conversion of Other systems(Fraction part) to Decimal number system

a) (.110)₂=( ? )10 b) (.75)₈= (?)₁₀(.13)₁₆=(?)₁₀

a) (.110)₂ =.{1x2^-1+1x2^-2+0x2^-3} =.{ 1/2 + 1/4 + 0} =.{ .5 + .25 + 0} =.75	b) (.75)₈ =.{7x8^-1+5x8^{-2 }} =.{ 7/8 + 5/64 } = .{.875 + .0781} = .9531
c) (.13)₁₆ =.{1x16^-1+3x16^{-2 }} =.{1/16 +3/256} = .{.0625 + .01171} = .0742

Conversion of non-decimal Number system to Other non-decimal number system

For example to convert OCTAL into HEXADECIMAL, use the follwing steps:

1) Convert octal into decimal

2) Convert decimal into hexadecimal

Topics covered with examples: Number Systems in Computer Science and Conversion Method

Conversion of Decimal number system to other number systems

Conversion of Decimal number system to binary number systems

Conversion of Decimal number system to octal number systems

Conversion of Decimal number system to hexadecimal number systems

Conversion of non-decimal Number system to Other non-decimal number system

Conversion of other number systems to Decimal number system

Conversion of binary number systems to Decimal number system

Conversion of octal number systems to Decimal number system

Conversion of hexadecimal number systems to Decimal number system

C Plus Plus Programming Practical ACS Advanced Computer Studies

2018-09-16T09:38:00.001+05:00

C Plus Plus Programming Practical Advanced Computer Studies

Here is a sample old question paper for guiding the students about the practical examination.

C++ Programming Practical will be of 20 marks.
Time allowed will be 1 hour 30 Minutes.
Section One contains only one compulsory question of Viva Vice ( Oral questioning)
Question No: 1 will be compulsory , VIVA VOCE of 5 marks.

In Section -II , You have to attempt any two questions(programs) out of 3 questions
Question No 2: C++ Program of 7.5 Marks
Question No 3: C++ Program of 7.5 Marks
Question No 4: C++ Program of 7.5 Marks

C++ Programming Practical for Advanced Computer Studies

A sample solution to program 1:

Count number of vowels in a string c program

Count number of vowels in a string output of c program

Short Notes on Microsoft Word's Important Practicals Part - I

2018-06-24T16:23:00.000+05:00

Topic: Short Notes on Microsoft Word's Important Practicals Part - I
Microsoft is one of the most popular word processing software by Microsoft. It is used to prepare different types of documents efficiently. Today we will learn some important practicals under Home Tab.

1. Some Basic Tasks - New, Save, Open

Click on Start button.
Select Microsoft Office Word 2007.
A new blank document will be opened with Microsoft Word User Interface.
Type your text in this MS Word document.
Click on Office button.
Select Save option.
Type Filename in filename box.
Select location like Desktop etc.
Click on Save button or press Enter.

To Open an Existing Word Document

Press CTRL+O, or click on Office button, select from recent documents, or click on open option
Select location / folder containing the required file / Word document.
Double click on the document to open.

2. Copy Paste, Cut Paste

Select text.
Click on Home tab.
Click on Copy command or Cut command.
Place cursor where you wish to copied or cut text.
Click on Paste command.

Short cut key for Copy is CTRL+C
Short cut key for Cut is CTRL+X
Short cut key for Paste is CTRL+V

3. Basics about Font

Simple Easy Procedures to Perform Basic Text Formatting in MS Word

Change Font Style

Select text for which we need to change the font.
Click on Home Tab.
Click on down arrow with Font style box and select a font style.

To Change Font Size

Select text.
Click on Home Tab.
Click on down arrow with Font Size box and select a font size.

To Change Font Color

Select text.
Click on Home Tab.
Click on down arrow with Font Color tool and select a font color.

To Highlight Text

Select text.
Click on Home Tab.
Click on down arrow Text Highlight Color tool and select a highlight color.

4. Text formatting Options Bold Italic Underline Strikethrough Subscript Superscript

Bold Text

Select the text.
Press CTRL+B or
Click on Home Tab. Click on Bold option

Italic Text

Select the text.
Press CTRL+I or
Click on Home Tab. Click on Italic option

Underline Text

Select the text.
Press CTRL+U or
Click on Home Tab. Click on text Underline command

Strikethrough Text

Select the text.
Click on Home Tab. Click on Srikethroug command

Subscript

Select the text.
Press CTRL+ = or
Click on Home Tab. Click on Subscript command X₂

Superscript

Select the text.
Press CTRL+ Shift + = or
Click on Home Tab. Click on Superscript command X²

5. Text Alignment

Select text.
Click on Home tab.
Click on command of Align Text Left, Align Text Right, Center and Justified

6. Preparing Lists of Items - Bulleted Lists and Numbered Lists

Microsoft Word provides two main types of lists:

Bulleted Lists that use different symbols called bullets in beginning of list items.

Numbered Lists that use different numbers / alphabets / roman numbers in beginning of list items.

How To Prepare Bulleted List

Click on Home tab.
Click on Bulltes command from font group.
Select a bullet style.
Type first list Item. Press Enter.
Type next item and press Enter and so on.
If you wish to stop list, Press Enter once again.

How To Prepare Numbered List

Click on Home tab.
Click on Numbered command from font group.
Select a numbering style.
Type first list Item. Press Enter.
Type next item and press Enter and so on.
If you wish to stop list, Press Enter once again.

7. Changing Line Spacing

Line spacing options also exist on Home Tab's Paragraph group. Normally we use line spacing of 1 or 1.15. Line spacing is the space between two lines of a paragraph. Sometimes, when we have small amount of text with respect to a large page size, we may increase line spacing to 2, so that page will look like in a good format showing more text on spreading on more page space.

How to Change Line Spacing

For example, consider the page in following picture with 1.15 line spacing option.

How To Change Line Spacing Options in MS Word

If we set the line spacing to 2, the same page will look like as follows:

Place Cursor in the paragraph.
Click on Home tab
Click on drop down arrow of Line Spacing box in paragraph group.
Select the required line spacing option, for example 2.

Changing Line spacing and set line spacing option to 2

Paper Codes and Titles of B.Sc. Double Computer Islamia University IUB Bahawalpur

2018-06-23T13:25:00.000+05:00

Download Paper Codes and Titles of B.Sc. Double Computer Islamia University IUB Bahawalpur

Note: View the image below for ACTUAL details of Computer A Course and Computer B Course Papers with respective Paper codes and their Titles.

Picture of Syllabus paper codes of B.Sc. Double Computer ( Computer A Course + Computer B Course ) with course titles.

Download Paper Codes and Titles of B.Sc. Double Computer Islamia University IUB Bahawalpur

Computer A Course:
Total Marks = 200
Details of Paper Codes and Titles of Computer A Course

Paper Code	Title	Marks
Computer A Course Paper-I	Structured Programming With ANSI C	50
Computer A Course Paper-II	Computer Fundamentals and Operating System	50
Computer A Course Paper-III	Systems Analysis and Design	50
Computer A Course Paper-IV	Accounting Fundamentals and Business Applications	50
	Total Marks	200

Computer B Course:
Total Marks = 200
Details of Paper Codes and Titles of Computer B Course

Paper Code	Title	Marks
Computer B Course Paper-I	Visual Programming	50
Computer B Course Paper-II	Database Management Systems	50
Computer B Course Paper-III	Data Structure and Algorithms	50
Computer B Course Paper-IV	Practical and Viva Voce	50
	Total Marks	200

Paper Pattern For B.Sc. ACS - Advanced Computer Studies Class Islamia University Bahawalpur

2018-06-23T06:40:00.000+05:00

Download Paper Pattern For B.Sc. Advanced Computer Studies ACS Class Islamia University Bahawalpur

The Islmia University of Bahawapur

REVISED CURRICULUM of ADVANCED COMPUTER STUDIES (ACS)

For B.A / B.SC.EXAMINATION 2005 & ONWARDS

Paper Pattern For ACS, B.Sc. Advanced Computer Studies, Islamia University Bahawalpur

COURSE MARKS: 200

THEORY: 160

PRACTICAL & PROJECT: 40

ACS - Third Year (B.Sc Part-I)

Paper I, II and C++ practical will be offered in the third year

ACS - Fourt Year (B.Sc Part-II)

Paper III. IV and project work will be offered in fourth year.

Paper I, II, III and IV all have two sections each which carry equal mark.

THIRD YEAR

PAPER – I Introduction to information Technology 40

PAPER -II Programming using C++ 40

PROJECT PRACTICAL using C++ 20

FOURTH YEAR

PAPER -III Data Base Management system 40

PAPER-IV Introduction to Web Programming 40

PROJECT 20

ASSESSMENT METHOD

THEORY PAPERS FOR THIRD & FOURTH YEAR

Marks: 40 (Section A: 20 marks + Section B: 20 Marks)

Time : 2 hrs.

Total Question : 8

Question to be attempted : 4

Each paper shall consist of two sections: Section A and Section B. Each section shall

consist of four questions and student will be required to attempt from each section.

PRACTICAL using C++ (Offered in 3rd Year)

Marks : 20

Time : 90 minutes

Total Questions : 3

Question to be attempted :2

Writing programs on an answer sheet: 45 minutes (Marks: 7.5)

Editing, Compiling & Executing programs on a PC and via: 45 minutes (Marks: 7.5 + 5)

Solution of two question to be written on an answer sheet and then edited, compiled &

executed those Programs on a PC. Each question to be written carries 7.5 marks and via is

of 5 marks. Via will be related to the concerned C++ language.

PROJECT (Offered in 4 Year)

Marks : 20

Time : 90 minutes

Evaluation of the project work by Examiner is done as: Report Writing (7.5 marks) +

Coding (7.5 marks) +Viva (5 marks)

PROJECT (related to Data Base or Web Programming using Data Base) is assigned by the

department. Work is done extensively and completely in the said area but which has limited

scope. Four Students will work on a single project and will contribute equally during all the

stages of development life cycle.

Download Paper Pattern For B.Sc. Advanced Computer Studies ACS Class Islamia University Bahawalpur

Happy Mothers Day Sayings New and Nice Mothers Day Quotes

2018-05-12T14:00:00.001+05:00

Happy Mothers Day Cool Sayings

To a child’s ear, ‘mother’ is magic in any language.
By: Arlene Benedict

To the world you are a mother, but to your family you are the world.
By: Unknown

I believe in love at first sight - Mothers day quotes

I believe in love at first sight, because I’ve been loving my mother since I opened my eyes.
By: Unknown

Happy Mothers Day Sayings New and Nice Mothers Day Quotes

Happy Mothers Day Quotes

Mama was my greatest teacher, a teacher of compassion, love and fearlessness. If love is sweet as a flower, then my mother is that sweet flower of love.

By: Stevie Wonder

Cool Mothers Day Quotes

All that I am, or hope to be, I owe to my angel mother.
By: Abraham Lincoln

New Mothers Day Quotes

I remember my mother's prayers and they have always followed me. They have clung to me all my life.
By: Abraham Lincoln

Nice Mothers Day Quotes

Mother love is the fuel that enables a normal human being to do the impossible.
By: Marion C. Garretty

Happy Mothers Day Sayings Cool Mothers day quotes

Cute Mothers Day Quotes

Mother : that was the bank where we deposited all our hurts and worries.
By: T. Dewitt Talmage

New and Nice Mothers Day Quotes

No matter how old a mother is, she watches her middle-aged children for signs of improvement.
By: Florida Scott-Maxwell

Sweet Mothers Day Quotes

Mother: the most beautiful word on the lips of mankind.
By: Kahlil Gibran

Great Mothers Day Quotes

A Mothers arms

A mother’s arms are made of tenderness and children sleep soundly in them.
By:Victor Hugo

Life began with waking up and loving my mother’s face.

Life began with waking up and loving my mother’s face.
By: George Eliot

A mother understands

A mother understands what a child does not say.
By: Unknown

A mom forgives us

A mom forgives us all our faults, not to mention one or two we don’t even have.
By: Robert Brault

Mothers possess a power

Mothers possess a power beyond that of a king on his throne.
By: Mabel Hale

The mother’s heart

The mother’s heart is the child’s school-room.
By: Henry Ward Beecher

Mothers hold

Mothers hold their children’s hands for a short while, but their hearts forever.
By: Unknown

When your mother asks

When your mother asks, ‘Do you want a piece of advice?’ it’s a mere formality. It doesn’t matter if you answer yes or no. You’re going to get it anyway.
By: Erma Bombeck

A mother’s love

A mother’s love is more beautiful than any fresh flower.
By: Debasish Mridha

Everything I am, you helped me to be.

Everything I am, you helped me to be.
By: Unknown

Date Sheet M.A / M.Sc 2nd Annual 2017 Held in May 2018 IUB Islamia University Bahawalpur

2018-04-27T23:19:00.000+05:00

The Islamia University of Bahawalpur ( IUB Bahawalpur) has announced and published
Date Sheet For the fresh and failed Private and Late College candidates of

M.A. / M.Sc. (Comprehensive/Composite)
2nd Annual Examination 2017 to be held in May, 2018

Date Sheet of M.A / M.Sc 2nd Annual 2017 Held in May 2018 IUB Islamia University Bahawalpur

Page-1 of 8
The Islamia University of Bahawalpur ( IUB Bahawalpur)
Date Sheet
M.A. / M.Sc. (Comprehensive/Composite)
2nd Annual Examination 2017 to be held in May, 2018

Date Sheet M.A / M.Sc 2nd Annual 2017 Held in May 2018 IUB Islamia University Bahawalpur

Page-2 of 8
The Islamia University of Bahawalpur ( IUB Bahawalpur)
Date Sheet
M.A. / M.Sc. (Comprehensive/Composite)
2nd Annual Examination 2017 to be held in May, 2018

Page-3 of 8
The Islamia University of Bahawalpur ( IUB Bahawalpur)
Date Sheet
M.A. / M.Sc. (Comprehensive/Composite)
2nd Annual Examination 2017 to be held in May, 2018

Page-4 of 8
The Islamia University of Bahawalpur ( IUB Bahawalpur)
Date Sheet
M.A. / M.Sc. (Comprehensive/Composite)
2nd Annual Examination 2017 to be held in May, 2018

Page-5 of 8
The Islamia University of Bahawalpur ( IUB Bahawalpur)
Date Sheet
M.A. / M.Sc. (Comprehensive/Composite)
2nd Annual Examination 2017 to be held in May, 2018

Page-6 of 8
The Islamia University of Bahawalpur ( IUB Bahawalpur)
Date Sheet
M.A. / M.Sc. (Comprehensive/Composite)
2nd Annual Examination 2017 to be held in May, 2018

Page-7 of 8
The Islamia University of Bahawalpur ( IUB Bahawalpur)
Date Sheet
M.A. / M.Sc. (Comprehensive/Composite)
2nd Annual Examination 2017 to be held in May, 2018

Page-8 of 8
The Islamia University of Bahawalpur ( IUB Bahawalpur)
Date Sheet
M.A. / M.Sc. (Comprehensive/Composite)
2nd Annual Examination 2017 to be held in May, 2018

Date Sheet M.A / M.Sc 2nd Annual 2017 Held in May 2018 IUB Islamia University Bahawalpur

Remove USB Virus Easily by Free Software SMADAV 2018 USB Antivirus

2018-04-25T13:28:00.000+05:00

SMADAV is a secondary level protection anti virus software especially good for viruses that enter into computer system through USB pen drive.
Download Smadav 2018 Free USB Antivirus and Clean your USB easily from viruses:

Smadav 2018 : The Best Free Anti Virus For cleaning USB from viruses

Smadav 2018 USB Antivirus Free Download

Some Features of Smadav 2018 Free USB Antivirus Protection Software

انسٹال کرنا اور استعمال کرنا انتہائی آسان ہے۔ جیسے ہی کوئی یو ایس بی لگائی جاتی ہے یہ اس کو سکین کر تا ہے اور وائرس کو کمپیوٹر میں داخل ہونے سے بچاتا ہے۔

Smadav 2018 Antivirus especially for USB helps you detect and clean virus in USB.

Smadav 2018 will also recover hidden files in USB.

Smadav 2018 Free Antivirus will work together with other popular Antivirus programs already installed on your computer smoothly.

Smadav Free antii virus software will work as an additional anti virus software in your PC and will provide Total Protection without any cost.
Smadav 2018 Free Antivirus will protect your PC from virus incoming through USB, E-mail or web.

Download Smadav 2018 Free USB Antivirus and Clean Your USB

How to download Smadav 2018 Free USB Antivirus Software

Just open the website of Smadav 2018 USB Antivrus and download free version. The link of Smadav 2018 USB anti virus is as follows:

Smadav 2018 Free USB Antivirus Protection Download Link

Download Smadav USB Antivirus 2018 Free

ڈاون لوڈ کرنے کے لیے نیچے دیے گئے لنک پر کلک کریں

Click to Download Smadav 2018 Free USB Antivirus now

How to Install Smadav 2018 USB Antivirus in Easy Steps with Pictures
(انسٹال کرنے کا طریقہ تصاویر کے ساتھ)

1. Click on the downloaded file of Smadav 2018

2. Click on Run

click on Next

3. Select English language.

4. Select the option for licence agreement ( I accept the agreement).

5. Select Create desktop icon option

6. Select Launch SMADAV and click on finish button.

7. Congratulations. Now your computer is protected against bad and dangerous USB Viruses.

8. You can scan your computer system by clicking on the scanner option on left side. You can select virus scanning areas like C drive, D drive or system area etc.

Results of the scan will be shown

If you like this post / article on Downloading , installing and using Smadav 2018 USB Antivirus Free, please share on Face book, Twitter, Pinterest, Google Plus and other social media websites. Thanks.

Jobs in NAB National Accountability Bureaue in Different Cities 24 April Jang

2018-04-25T07:18:00.001+05:00

National Accountability Bureau, invites applications from only Pakistani Nationals for hiring the services of Law Officers in different cities:-

NAB HQs Islamabad,
NAB Rawalpindi,
NAB Multan,
NAB Sukhur,
NAB KPK,
NAB Bluchistan
NAB Karachi
NAB Lahore

40 Most Important Short Cut Keys Every Microsoft Excel User Must Know

2018-04-22T10:18:00.002+05:00

Today we will discuss 40 Most Important Shortcut Keys in MS Excel Everyone Should Know. Keyboard shortcuts saves a lot of time. Using keyboard shortcuts instead of mouse will make typing easier and faster.

40 Most Important Short Cut Keys Every Microsoft Excel Users Must Know

Sr.No.	Keyboard Shortcut	Function of Shortcut Key
1	CTRL + N	To Create a new Workbook [New File]
2	CTRL + O	To open an existing Workbook in Excel
3	CTRL + S	To Save an Excel Workbook. If workbook is not saved yet, it will ask filename and location to save the workbook for first time. If you have saved workbook already with a filename, it will save any changes occurred since last save.
4	CTRL + W	To Close the selected workbook window.
5	F12	To display Save As dialog box, You can save the workbook with a new name and / or on a different location.
6	CTRL + F2	To show Print Preview
7	CTRL + P	To display Print dialog box you can set different print options like page size, margin size, number of copies etc and print worksheet.
8	ALT + F4	To Exit from Excel
9	CTRL + F1	To collapse or expand Ribbon
10	CTRL + A	Select all, To select entire current worksheet
11	CTRL + C	Copy contents of selected cells
12	CTRL + X	Cut contents of selected cells
13	CTRL + V	Paste copied or cut contents from clipboard
14	CTRL + ALT + V	Show paste special dialog box
15	CTRL + F	Find, To display Find dialogbox
16	CTRL + H	Replace, To show Find / Replace dialog box. Replace option selected. You can replace occurrences of an existing word by a new word easily.
17	SHIFT+SPACE	To Select entire current row
18	CTRL + SPACE	To Select entire current column
19	CTRL + V	Paste copied or cut contents from clipboard
20	SHIFT+F11	To insert new worksheet
21	CTRL + PageDown	To go to next worksheet
22	CTRL + PageUp	To go to previous worksheet
23	F7	To show Spelling check dialog box
24	SHIFT+F7	To display Thesaurus dialog box
25	ALT+Enter	To insert a line break in a cell
26	CTRL + Z	To undo last action
27	CTRL + Y	To redo last action
28	F1	To show Help dialog box
29	F10	To activate the menu bar
30	CTRL + G	To display go to dialog box
31	CTRL + ;	Insert current date in a cell
32	CTRL + Shift + ;	Inserts current time in a cell
33	CTRL + B	To apply / toggle bold text on contents of selected cells
34	CTRL + U	To apply / toggle underline text on contents of selected cells
35	CTRL + I	To apply / toggle italic text on contents of selected cells
36	CTRL + K	To show Insert Hyperlink dialog box
37	F2	To edit the active cell
38	Esc	To cancel
39	CTRL + 5	To apply strike through in selected cells
40	CTRL + 1	To show Format cells dialog box

MS Excel Formulas and Functions

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

MS Excel House Building Expense Management Formulas Worksheet

Excel Worksheet With Income Tax Calculation Formula on Employee Pay

Microsoft Excel Formulas To Calculate Your Age in Years Months Days and Day of Birth

Create 3D Line Chart in MS EXCEL for 2 Cricket Teams

Create Save Password Protect Workbook in Excel

Use of Text Functions Left Right Mid in Excel

Use of Max Min Functions in Excel

Use of Average Function With Examples

Uses of Excel in Business and Commerce

Use of SUM Function With Examples in MS Excel

Create PIE Chart in MS Excel

40 Most Important Short Cut Keys Every Microsoft Excel User Must Know

Jobs for Matric Pass F.A. Pass Dars-e-Nizami Pass in Pak Army 2018

2018-04-17T16:52:00.002+05:00

Jobs in Pakistan Army 2018

Candidates may get registered by going to the nearest Army selection offices army recruitment offices or regimental offices from 15 April 2018 to 15 May 2018.

Last date: 15 May 2018

1. Junior Commissioned Officers ( Naib Khateeb )

2. Soldiers

3. Military Police

4. Clerk

5. Cook

5 Sweepers / Sanitary Workers.

For details of Age, Qualification and other criteria for available jobs 2018 in Pakistan army , view and read the advertisement provided below:

Jobs in Pakistan Army 2018 Junior Commissioned Officer Soldiers Military Police clerk cook Sanitary Workers

Online registration for Pakistan Army Jobs 2018

For Online registration for Pakistan Army Jobs 2018, you can visit Pak Army website:
www.joinpakarmy.gov.pk

Practical Schedule of B.A. / B.Sc. First Annual Examination 2018, Islamia University Bahawalpur

2018-04-17T06:14:00.000+05:00

The islamia University of Bahawalpur has announced the Practical Schedule of B.A. / B.Sc. First Annual Examination 2018.

Practical Schedule of B.A. / B.Sc. First Annual Examination 2018, Islamia University Bahawalpur

Detailed Practical schedule will be published on the website of the Islamia University of Bahawaplpur soon.

Teaching Jobs in Rahim Yar Khan

2018-04-16T17:20:00.001+05:00

Jobs in Khawaja Farid University Of Engineering and Information Technology, Rahim Yar Khan

Last date to apply: 20 April 2018

Teaching Jobs:

Associate Professor (Chemical Engineering )

No. of Post = 01, BPS 20, Maximum Age Limit 55 Years, Department: Chemical Engineering

Assistant Professor (Chemical Engineering )

No. of Post = 02, BPS 19, Maximum Age Limit 50 Years, Department: Chemical Engineering

Lecturer (Chemical Engineering )

No. of Post = 02, BPS 18, Maximum Age Limit 45 Years, Department: Chemical Engineering

Lab Engineer (Chemical Engineering )

No. of Post = 02, BPS 17, Maximum Age Limit 40 Years, Department: Chemical Engineering

FOR DEATAILED INFORMATION: view the Job advertisement image by Khawaja Fareed University of Engineering and Information Technology, Rahim Yar Khan, provided below:

Download application from

Teaching Jobs of associate professor, Assistant Professor, lecturer, lab engineer at Khawaja farid University of Engineering and Information Technology Rahim Yar Khan

Sponsored Links

Teaching Jobs Agricultural Engineering KFUEIT Rahim yar Khan Last date 30 April 2018

2018-04-15T19:41:00.000+05:00

Jobs in Khawaja Farid University Of Engineering and Information Technology, Rahim Yar Khan

Last date to apply: 30 April 2018

Teaching Jobs:

Associate Professor (Agricultural Engineering )

No. of Post = 01, BPS 20, Maximum Age Limit 55 Years, Department: Agricultural Engineering

Assistant Professor (Agricultural Engineering )

No. of Post = 02, BPS 19, Maximum Age Limit 50 Years, Department: Agricultural Engineering

Lecturer (Agricultural Engineering )

No. of Post = 02, BPS 18, Maximum Age Limit 45 Years, Department: Agricultural Engineering

Lab Engineer (Agricultural Engineering )

No. of Post = 02, BPS 17, Maximum Age Limit 40 Years, Department: Agricultural Engineering

Lab Engineer (Electrical Engineering specialized in Power Engineering)

No. of Post = 02, BPS 17, Maximum Age Limit 40 Years, Department: Electrical Engineering

Download application from

Sponsored Links

Teaching Jobs Agricultral Engineering at KFUEIT Rahim Yar Khan last date 30 April 2018

Jobs for Primary Pass in Agriculture Department at Khan Pur Rahim Yar Khan Last Date 20 April 2018

2018-04-15T17:43:00.001+05:00

Jobs in Agriculture Department at Khan Pur Rahim Yar Khan Last Date 20 April 2018

Jobs:

Field Man
Baildar
Khakroob
Naib Qasid

LAST DATE to Apply: 20 April 2018

Agriculture Department, Govt. of Punjab announced vacancies for

1. Field Man - 3, Open Merit, scale number 1 - Education: Primary Pass, Healthy, Age 18-25 years

2. Baildar - 1, Open Merit, scale number 1 - Education: Literate, Height 5 feet 6 inches or more, Chest 33 inch or more. Healthy, Age 18-25 years

3. Naib Qasid - 1, Open Merit, scale number 1 - Education: Primary Passs, Healthy, Age 18-25 years

4. Khakroob - 1, Open Merit, scale number 1 - Education: Primary Pass, Healthy, Age 18-25 years

Last date for submitting application and necessary documents mentioned in advertisement: 20 April 2018

Test / Interview date: 2 May 2018

Chak Number 4/P Khanpur, Rahim Yar Khan

Sponsored Links

How to Print Your Monthly Electricity Bill Copy Online

2018-04-15T16:06:00.002+05:00

Topics covered: How to Check Wapda electricity Bill online on your mobile phone
How to Print Your Monthly Electricity Bill Copy Online
How to Check Kesco electricity Bill online on your mobile phone

How to Check Mepco electricity Bill online on your mobile phone

How to Check Lesco electricity Bill online on your mobile phone
How to Check Iesco electricity Bill online on your mobile phone
How to Check Gepco electricity Bill online on your mobile phone
How to Check Hesco electricity Bill online on your mobile phone
How to Check Pesco electricity Bill online on your mobile phone

For checking your WAPDA electricity bill of current month online, you will visit the website concerned electric supply company with the help of your web browser.

How to Check your WAPDA Electricity Bill for current month online

Here is a list of all Electric Power supply companies and their website addresses.

There are following Electric Power Supply Companies in Pakistan. You may online Electric Powerity bill for each month on the websites of these Electric Power supply companies.

Multan Electric Power Power Company (MEPCO)
Lahore Electric Power Supply Company (LESCO)
Islamabad Electric Power Supply Company (IESCO)
Faisalabad Electric Power Supply Company (FESCO)
Gujranwala Electric Power Power Company (GEPCO)
Hyderabad Electric Power Supply Company (HESCO)
K-Electric Power / Karachi Electric Power Supply Company – KESCO
Sukkur Electric Power Power Company (SEPCO)
Quetta Electric Power Supply Company (QESCO)
Peshawar Electric Power Supply Company (PESCO)

The websites of these Electric Power supply companies are as follows. Click on the related link and check youe wapda Electric Powerity bill by entering Consumer Number given on your Electricity bill.

MEPCO Online Electricity Bill ( Multan )
LESCO Online Electricity Bill ( Lahore )
IESCO Online Electricity Bill ( Islamabad )
FESCO Online Electricity Bill ( Faisal Abad )
GEPCO Online Electricity Bill ( Gujranwala )

HESCO Online Electricity Bill ( Hyder Abad)
SEPCO Online Electricity Bill ( Sukkur )
K-Electric Online Electricity Bill ( Karachi )

QESCO Online Electricity Bill ( Quetta )

PESCO Online Electricity Bill ( Peshawar )

Steps To Check Your Electricity WAPDA Bill Online

1. Open website of your Electric supply company. Remember that websites of all electric companies for checking online bills are provided above.
For example, if you live in Rahim Yar Khan, you will open website of MEPCO - Multan Electric Power Supply Company. Click on MEPCO Online Electricity Bill ( Multan )

Method of checking your electricity bill online

2. Act upon the instructions provided on the web page.
3. Generally, Reference number printed on your electricity bill will be used to check your bill of current month online. Reference number is normally of 14 digits excluding the last character like U. You will ignore the last character like U.

Check your electricity bill of current month on Internet

4. Therefore, read the reference number from printed bill, input that number on web form as shown in the figure.
5. Click on submit button as shown in the figure. If you have provided the correct reference number, your updated electricity bill of current month will be loaded and shown in the browser.

Easy steps to Check your electricity bill through internet

6. you can also print your electricity bill by clicking on Print button, if you have a printer attached with the computer system.

Sponsored Links

Printing Instructions To Print Your Electricity Bill Online

In Internet Explorer from the FILE menu click "PAGE SETUP"

Select PAPER SIZE as "A4"

Delete the values under HEADER and FOOTER

Select ORIENTATION as "Portrait"

Click the OK button

From the FILE menu click "PRINT"

Choose appropriate printer and click the PRINT button

Or Press CTRL + P from keyboard while the window containing your electricity bill is active.
Follow the instructions.

You can also click on Print bill button on top of bill, and follow the instructions.

Similarly, you can check your electricity bill online from any Electric Power supply company's website.

Topics covered: How to Check Wapda electricity Bill online on your mobile phone
How to Print Your Monthly Electricity Bill Copy Online
How to Check Kesco electricity Bill online on your mobile phone

How to Check Mepco electricity Bill online on your mobile phone

Jobs at Rahim Yar Khan Health Care Department Last Date 24 April 2018

2018-04-14T06:41:00.001+05:00

Jobs in 14 Districts including Rahim Yar Khan, Lahore, Faisal abad, sahiwal, Chakwal, Vehari, Lodhran, Pak pattan, Toba Tek Singh,

Jobs at Rahim Yar Khan: Last date 24 April 2018

Medical Officer / Woman Medical Officer
Charge Nurses
Junior Technician / laboratory Assistant (Patalogy Technology )
Junior technician / Operation Theater Assistant ( Surgical technology )

Junior Technician ( MCH Technology / lady health viistor )
Junior Technician / Dispenser / Dresser ( Pharmacy Technology)
Junior Technician ( sanitory Inspector / Public health technology)
Junior Technician / vaccinator

Jobs in Punjab Health Facilities Management Company ( PHFMC )

Jobs in Primary and Secondary Health Care Department Government of Punjab.

Date of Advetisement: 13 April 2018
Newspaper: The Jang News paper
Last Date to apply: 24 April 2018

Jobs: General Surgeon, Anesthetist, Eye Specialist, Gynecologist, Pediatrician, Junior Technicians, Medical Officer, Charge Nurse

Detail of Districts with addresses:

Datesheet MCS Semester III Session 2016 2018 Affiliated Colleges IUB

2018-04-13T12:59:00.001+05:00

Download Datesheet of MCS (Third Term)Semester III Final Term, Session 2016-2018 for students of Affiliated Colleges with Islamia University of Bahawalpur - ( IUB Bahawalpur )

Datesheet of MCS Semester III Session 2016-2018 for students of Affiliated Colleges with Isamia University of Bahawalpur - ( IUB Bahawalpur )

According to the Date sheet issued by the Islamia University of bahawalpur, the Final term examination of MCS Third Term (3rd Semester)session 2016-2018 will start from Monday, 23 April, 2018.

Timings of the papers will be in evening from 2:30 PM to 4:45 PM. The center for all students of Rahim yar khan city is Khawaja Farid Govt. Postgraduate College, Rahim Yar Khan. For details check the image of date sheet of Masters in Computer Science:

Use of Power and Sqrt Function in Excel Worksheet

2018-04-12T00:10:00.001+05:00

Today, we will discuss the use of POWER( ) function and SQRT( ) function in Microsoft Excel Worksheets. We will prepare a worksheet to practically learn the use of Power () function and Sqrt() function

as shown in the following figure:

Use of POWER( ) function and SQRT( ) function in Microsoft Excel Worksheets

The Use of POWER( ) function in MS Excel Worksheet

POWER function may be used to raise a number to a certain power. For example, to calculate number 2 raise to the power of 3, we will type the power function as:
=POWER(2,3)
which will return the result 8. If the number is in cell B3, we will type the power function as follows:
=POWER(B2,3)

Steps To Create an Excel Worksheet To Demonstrate Use of Power() and Sqrt() Function

1. Start Microsoft Excel with a new blank workbook.

2. Type the data as shown below in the first worksheet.

3. Perform formatting in Excel worksheet as shown in the following figure.

4. Type data in Column A and Column B of worksheet.

5. In cell C3 of column C , we will type a formula using Power() function to calculate Square of given number.

6. Type = in cell with reference C3.

7. Type POWER(B3,2) and press Enter.

8. Since we have entered number 4 in B3 cell so Power(B3,2) will return 16 in cell C3.

The Use of POWER( ) function in MS Excel Workshee

The Use of SQRT( ) function in MS Excel Worksheet

The Excel function SQRT is used to calculate the square root of any number given as its argument.
For example, if you use wish to calculate square root of 4, you will type SQRT function as follows:
=SQRT(4)
which will give 2 as a result.

9. In cell D3 of column D , we will type a formula using Power() function to calculate Cube of given number.

10. Type = in cell with reference D3.

11. Type POWER(B3,3) and press Enter.

12. Since we have entered number 4 in B3 cell so Power(B3,3) will return 64 in cell D3.

The Use of SQRT( ) function in MS Excel Worksheet

13. In cell with reference E3 , we will type a formula using Sqrt() function to calculate Square root of given number.

14. Type = in cell with reference E3.

15. Type SQRT(B3) and press Enter.

16. Since we have entered number 4 in B3 cell so SQRT(B3) will return 2 in cell E3.

We have completed the task of creating a worksheet in MS Excel using Power function and SQRT() function.

Excel Worksheet Student Absence Fine Calculation Formulas

2018-04-11T12:22:00.001+05:00

Today, we will discuss how to create an Excel Worksheet that helps calculate Students Absence Fine Calculation on basis of Total Lectures Delivered and Total Lectures Attended (Presence) of the student.

Excel Worksheet Student Absence Fine Calculation Formulas

Steps To Prepare an Excel Worksheet for Student Absence Fine Calculation

1. Start MS Excel with a blank workbook option.

2. Type sample data in first Excel worksheet as shown in the given image.

3. Type formula for calculation of number of absence of a student.

Place cursor in Cell with reference E3.

Type = sign in E3

Type C3-D3 and press Enter

Steps To Prepare an Excel Worksheet for Student Absence Fine Calculation

4. Copy the formula of cell E3 in all lower level cells with the help of Fill Handle in

lower right corner of Cell E3.

5. Type formula for calculation of fine by multiplying cell E3 with 50.

6. Type formula of fine calculation =E3 * 50 and press enter in cell referenced by F3.

7. Copy the fine calculation formula downward in all required cells of column F.

8. Congratulations you have successfully prepared Excel Worksheet for Absence Fine calculation of students.

9. Please, do not forget to save file.

How to Create College Admission Inquiry Report in Excel

2018-04-04T14:50:00.002+05:00

Today, we will discuss how to prepare an Excel worksheet for Admission Inquiry in a College. Actually the management of the college wishes to monitor the Performance of the marketing and advertising staff. The advertising and publicity staff of the college is responsible for taking steps to better publicize the good reputation of the college and attract new students for admission in college classes.

Excel Worksheet For College Admission Inquiries Performance Report

The Excel worksheet about Admission inquiries performance report will perform the following tasks:

It will record Serial No., Date, Inquiries for ICS, B.Sc.(ACS) and MCS

Note: ICS stands for Intermediate in Computer Science, ACS stands for Advanced Computer studies and MCS stands for Master in Computer Science.

It will calculate total inquiries by adding the inquiries of the three classes.
It will output a message in Performance column as given below:

Show a message "Excellent" for inquiries greter than or equal to 100
Show a message "Good" for inquiries greter than or equal to 80
Show a message "Satidfactory" for inquiries greter than or equal to 40
Show a message "Unsatisfactory" otherwise, that is when inquiries are less than 40 per day.

Steps to create Admission Inquiries of a College Worksheet in Excel

1. Prepare the basic admission inquiries worksheet with proper formatting

Guidelines for Formatting the Admission Inquiries Performance Report Worksheet

Type necessary headings in the worksheet. If you wish to merge cells, perform the steps as shown in the figure below:

Apply Merge and center option in Excel worksheet

You can apply middle align options as shown in the figure below:

Apply middle align option in Excel worksheet

You can increase font size of the text in cells:

You can apply borders option to selected cells in the worksheet as shown in the following picture:

You can insert word art in Excel worksheet as shown in the image below:

You can insert word art in Excel worksheet

2. Enter sample data in worksheet as shown in the figure.

3. Enter necessary formulas and predefined functions
4. First of all, when you start work on the worksheet, save the workbook with a proper name as College Admissions Inquiries Report Worksheet. During your work, press CTRL + S from keyboard to save changes, often.

How To Use Necessary Formulas and Functions

In this worksheet, we will use two functions according to the requirements
1. SUM function
2. IF function

Using SUM function to get Total Inquiries

Place cursor in cell referenced by F4.
Type =
Type name of function that is SUM
Type address of ICS cell referenced by C4
Type a colon :
Type address of cell MCS referenced by address E4
Press enter
The total of inquiries will be shown in cell F4.

Apply Sum function in Excel worksheet

Using Logical IF Function To Show Suitable Message according to Total Inquiries

We will use IF function as following:

=IF(F4>=100,"EXCELLENT",IF(F4>=80,"GOOD",IF(F4>=40,"SATISFACTORY","UNSATISFACTORY")))

Syntax of IF logical function is:

IF(Logical-Test, Value-If-True, Value-If-False)

Example of IF Function is

=IF(F4>=40,"Satisfactory","Unsatisfactory")

It will give Satisfactory if cell F4 contains a number greater than or equal to forty or it will return Unsstisfactory otherwise, when less than forty.

Apply Logical IF function in College Admission Inquiries Report Excel worksheet