Perfect Computer Notes

Super Easy Short Computer Notes To Improve Computer Literacy and Your IT Skills

Calculate Percentage of Lectures Attended by Students using Excel Worksheet

Today, we will prepare a Microsoft Excel Worksheet For Lectures Attendance Percentage of Students For Checking the Eligibility in Appearing in Exams. Excel Worksheet for Calculating Lecture Attendance Percentage of Students

We will open a new Excel worksheet and prepare the basic structure of worksheet according to the given picture of Excel Worksheet for Calculating percentage of Lectures attended by students to enter data of students about lectures attended and lectures delivered. We will also note the Serial number and Students Name also. With the help of two facts that is Lectures Delivered and Lectures Attended, Attendance Percentage will be calculated by the formula given below:

Attendance Percentage = Lectures Attended / Lectures Delivered * 100

In Excel Formula,  Calculate Percentage of Lectures Attended by Students using Excel Worksheet Formula:

Attendance Percentage = =E4/D4*100

Explanation of Excel Formula for Calculation of Attendance Percentage

As we can see in the Excel worksheet's image provided that Lectures Attended by first student are in the cell with cell reference E4 and Total Lectures Delivered by the teacher are in cell D4, therefore, we divide cell E4 by D4 and multiply by 100 to get the required percentage.

Calculation of Remarks for Eligibility of a Student to appear in Examination

Similarly, we will calculate the Remarks with the following formula:

Remarks = Allowed  (if Attendance Percentage is greater than or equal to 80 %)

and

Remarks = Rejected (if Attendance percentage is less than 80%)

For this purpose we will use IF() logical function.