Hey guys I'm new to the forums so I'm sorry if some of the questions that I'm asking are noobish :/
have received a task to do for school and I tried my heart out but I can't seem to figure this out. It's really simple but I
can't seem to do it... I'm not very good with excel.
The excel file is attached.
Basically, I need to
create a gradebook for a professor.
Here are the task specifications:
You must accomplish all of the following in your task:
* Use the
appropriate formulas for rows 21-25
* Column G must contain ONE formula that can be filled down the column
o IF the student took all exams (total defined in B27), the formula will drop the lowest grade and average the rest
of the exams
o IF the student did not take all the exams, it will just take an average of the exams taken
* Column H will contain a formula that rounds Column G to the nearest whole number
* Column J will contain a formula that does the following:
o IF there is a "YES" in column I, the formula must check if the student's rounded average (in column H)
is equal or greater than 65. If it is, the formula will output a PASS instead of a letter grade. If it is lower than 65, it
will output an F
o If there is no "YES", it will check the rounded average to the grade table and output a letter grade
* Column K will rank the student's grade in column G against the rest of the class
Finally, print out a bar
chart that displays each of the students' final "number" grades and also labels each of the bars with the
appropriate students' name. Use the capabilities of Excel to do this, which means that you should take the students' names
from the original spreadsheet and have them linked into your bar chart.
I got most of it done but there are still
some things wrong.
Here's what I'm having problems with:
1)The formula in column J must be the same for each row (meaning it must
determine if column I says yes or not)
2)The grade distribution should be calculated (I need a formula that detects how many A's, B's, C's, etc.. there are and put
in in the grade distrubition.
Help would be greatly appreciated
Thank you..Attachment 45873