Scribd
Upload
2 views2 pages

Faculty and Student Performance Analysis

The document outlines a series of tasks related to job performance evaluation, academic performance assessment, and certificate generation for students. It includes instructions for calculating averages, ranking faculty members, providing verbal interpretations, and generating graphs using Excel functions. Additionally, it details the process for preparing certificates of recognition based on student grades and honors.

Uploaded by

Toni Marie P. Lopez
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
2 views2 pages

Faculty and Student Performance Analysis

The document outlines a series of tasks related to job performance evaluation, academic performance assessment, and certificate generation for students. It includes instructions for calculating averages, ranking faculty members, providing verbal interpretations, and generating graphs using Excel functions. Additionally, it details the process for preparing certificates of recognition based on student grades and honors.

Uploaded by

Toni Marie P. Lopez
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Job performance

1. Get the average per core-value of all teachers and put it in a bar graph.
2. Get the average of each core-values for each teacher using “averageif”
a. =AVERAGEIF(range, criteria, [average_range]) - The AVERAGEIF
function uses the following arguments: Range (required argument) – This
is the range of one or more cells that we want to average. The argument
may include numbers or names, arrays, or references that contain
numbers.
3. Get the composite mean (average) of the computed weighted mean for all core
values per faculty member
4. Rank the faculty members from highest to lowest
a. =RANK(number,ref,[order])The RANK function uses the following
arguments: Number (required argument) – This is the value for which we
need to find the rank. Ref (required argument) – Can be a list of, or an
array of, or reference to, numbers. Order (0-Descending; 1-Ascending)
5. Indicate the verbal interpretation of the composite mean using LOOKUP
The LOOKUP function in Excel retrieves a value from a one-row or one-column
range. It performs a rough match lookup either vertically or horizontally. The
vector form syntax is =LOOKUP(lookup_value, lookup_vector, [result_vector])

Lookupvalue Formula Lookup result_vector


vector
1.00 1.50 Very Low
3.42 =lookup( 1.51 2.50 Low
)
2.51 3.50 Average
3.51 4.50 High
4.51 5.00 Very High

6. Get average Performance per department using AVERAGEIF(range, criteria,


[average_range]

The AVERAGEIFS function syntax has the following arguments:

Average_range Required. One or more cells to average, including numbers or


names, arrays, or references that contain numbers.
Academic Performance
1. Arrange the names of the students alphabetically
2. Provide automatic numbering: from TLE001 to TLE048
3. Get the average of scores for English, Math and Science
4. Give the remarks either Passed or Failed if the grade >=75 Passed otherwise
Failed
a. Use the IF function, one of the logical functions, to return one value if a
condition is true and another value if it's false.

b.
5. Indicate the verbal description using lookup
Lookupvalue Formula Lookup result_vecto
vector r
60.00 74.49 Failed
89.2 =lookup( Very Low
) 74.50 79.59
79.60 84.69 Low
84.70 89.79 Average
89.80 94.89 High
94.90 100 Very High

6. Make a Graph for the performance between male and female for three subjects.

Certificate
1. Paste the names, sex and grades of the students in Sheet No. 3
2. Identify the award:
Award
90.00 94.00 With Honors
94.01 97.00 With High Honors
98.01 100 With Highest Honors

3. Open MS Word (Workshop – Certificate of Recognition)


4. In the menu bar Select “mailings”, then choose “start Mail merge” then letters

You might also like