Page 206 - DCAP101_BASIC_COMPUTER_SKILLS
P. 206
Unit 10: Microsoft Excel
10.5.6 Sample Example Using Functions to Calculating Grades Notes
Grading of the students performance can be done very easily using excel. Suppose the
students have been assessed by ten class test and their performance is graded by assigning
H grade for marks between 90-100, A grade for 80-89, B for 70-79, C for 60-69 and students
less than 60 are fail i.e. F grade. We can chose the same weight age for all the test or it can
vary. When we give different weigh ages then the performance index may be calculated by
the formula (e.g. 0.4*Testl+0.l*Test2+0.05*Test3+ .) or if the weight ages are equal then the
performance index can be calculated by a simple average. For the following exercise it is
an average.
Hide column A, C and D.
In cell M3, type Average Performance
Move the pointer to cell M4, and on the Standard toolbar click Paste Function.
Under the Function category, click Statistical; under Function name, select Average,
and click OK.
It asks for the cells of which the average to be calculated. Select E4-M-i and then Click
OK to complete the function and average one row of grades.
Click and Hold down the cursor at right-bottom of cell M4 and stretch it up to M 13.
The average for all the students has been calculated.
Figure 10.6: Calculating Grades
LOVELY PROFESSIONAL UNIVERSITY 199
