Skip to main content

How to Create College Admission Inquiry Report in Excel

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
Excel Worksheet For College Admission Inquiries Performance Report


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

  1. 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.
  1. It will calculate total inquiries by adding the inquiries of the three classes.
  2. 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
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
Apply middle align option in Excel worksheet

You can increase font size of the text in cells:
Increase font size in excel worksheet

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

You can insert word art in Excel worksheet as shown in the image below:
You can insert word art in Excel worksheet
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
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
Apply Logical IF function in College Admission Inquiries Report Excel worksheet


Comments

Popular posts from this blog

Introduction to Algorithms and Algorithmic Notation With Examples

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 perfor...

Define Data and Information With Examples

DATA Data is the collection of raw facts and figures. Actually data is unprocessed, that is why data is called collection of raw facts and figures. Define Data and Information with Examples We collect data from different resources. After collection, data is entered into computer for processing. Data may be collection of words, numbers, pictures,  or sounds etc. Examples of Data 1) Student Data on Admission Forms When students get admission in a college. They fill admission form. This form  contains raw facts (data of student) like name, father’s name, address of student, obtained marks, photo graph etc. 2)    Data of Citizens During census, data of all citizens is collected. The staff will go house to house and collect data about citizens like number of persons living in a home, either they are literate or illiterate, number of children, data of each child, cast, religion, Computerized national Identity Card number, address, how many rooms and...

What are Dual Devices or Both Input/ Output Devices

The devices that can be used to perform both functions -input and output- are called Dual Devices. These devices are also called Dual Purpose Devices or Both Input/Output Devices. With the help of a dual purpose device, we can enter data into computer as well as we can output data from the computer to outside world.  For example, Dual devices include:  Touch Screen Monitor, Modem, Network Interface Card, Sound card, Hard disk drive, Floppy disk Drive, Magnetic Tape Drive CD-Writer and DVD-Writer etc. These are also called Input/output devices, because they perform both functions. Touch Screen Monitor Dual Devices or Both Input / Output Devices - Touch screens Touch Screen Monitor is an input/output device. It uses a special touch sensitive screen. The User can enter data by touching icons or menus on the screen. As soon as the user selects a command from menu, output is displayed on screen. Commonly touch screen monitors use sensors to detect touch of finger. ...