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

Explain Main Difference Between System Software and Application Software

Topic: Explain Main Difference Between System Software and Application Software            Differentiate between system software and application software Before , explaining the main differences between application software and system software, let us know the definitions of Application software and System software with examples. What is System Software: System software is a set of programs to control all components of computer and to manage overall operations of computer system. Differences between System software and application software System software is used as a base to install and run all application software. Examples of system software include: Operating Systems, like Microsoft Windows, DOS, Unix and Linux Device Drivers like Device driver software of a Printer (found on CD normally provided with the printer) Utility Programs like AVAST anti virus, Disk Scanners and File Viewers etc. What is Applicat...

Explain Data Processing Cycle and Main Activities of Data Processing Cycle

After collecting data, it is processed to convert into information. The data is processed again and again until accurate result is achieved. This is called data processing cycle . Data processing cycle involves following three basic activities: Major Activities Involved in Data Processing Cycle Explain Data processing cycle 1. Input 2. Processing 3. Output 1. INPUT It is the process in which collected data is given to computer after converting into binary form. Input step can be further divided into following steps: i) Planning Here objectives of data processing are defined. For example, in examination system, objective is to process student examination data to get result cards. ii) Data Collecting Here data is collected. Data is the raw material for data processing. This must be accurate for getting accurate results. iii) Input Here data is entered into computer. iv) Verification Here collected data is verified to determine whether it is valid for ...

Advantages and Disadvantages of Mesh Topology

Topic: Advantages and Disadvantages of Mesh Topology Mesh Topology In a mesh topology, every device on the network is physically connected to every other device on the network. Therefore, data can be sent on several possible paths from source computer to destination computer. Mesh topology is more reliable with better performance. Mesh Network Topology is mostly used in wide area networks where reliability is important. Advantages of Mesh Network Topology 1. Since, there are many links to transfer data, Mesh topology gets rid of the traffic problem . Data may be transferred through different links. 2. If one link becomes unusable, it does not disturb the whole system . Other links can be used for communication. 3. Since each node has physical connection with other nodes, therefore, one node can transfer data to many nodes at the same time. Disadvantages of Mesh Network Topology 1. It is very expensive due to implementation of multiple links for each no...