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

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:

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

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

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

Bus Topology Advantages Disadvantages

Bus Topology Bus topology is the simplest network topology . In bus topology , all computers in network are connected to a common communication wire. This wire is called BUS. Terminators are used at both ends of wire. Bus Topology is Cheap, easy to handle and implement. Bus Topology require less cable. Bus Topology is best suited for small networks. Working of Bus Topology with Advantages and Disadvantages Advantages of Bus Network Topology 1. It is very simple topology . 2. It is easy to use. 3. It needs small amount of wire for connecting computers. 4. It is less expensive due to small wire needed. 5. If one computer fails, it does not disturb the other computers in network. Other computers will continue to share information and other resources with other connected computers. Disadvantages of Bus Network Topology 1. Only small number of computers can be connected in a bus network . 2. Network speed slows down as the number of computer increases in b...

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

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

Perfect Computer Notes

Search This Blog