Programming in Using Microsoft excel

Asked By jeremy ngo 20 points N/A Posted on - 03/29/2012

I need someone who can teach me to use microsoft excel as a program for my students grades to avoid manual computation and just input their grades to produce final grades.

• Status: Open
• Question Views: 1070
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Anthew Staw

Go To Solution

Answered By asadlion 0 points N/A #110352

Programming in Using Microsoft excel

The easiest way is to use the sum function wherein you will calculate the total grades on all quarters and then divide it to the total quarters on each year. Say, we have four quarters on each year and you want to calculate the total percentage of each student, just get the sum of the total of quizzes, examinations, recitations, projects, others.

And then do the same step for each quarter:

To compute the final grade of student1, get the sum on each quarter and then divide it from the total quarters you have. Here, we have four quarters so the sum on all quarters will be divided by 4. The result will be the final grade of student 1.

 

About asadlion

Questions
0

Answers
7

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 03/29/2012
• Question Category: MS Excel

Best Answer

Best Answer

Answered By Anthew Staw 0 points N/A #110353

Programming in Using Microsoft excel

 

name of student	subject1	subject2	subject3	subject4	subject5	subject6	subject7	FINAL GRADE
Anthew	0	0	0	0	0	0	0	60

Based on your problem, I created this system. You should pay me for doing this but I'll put it here anyway. So you wanted a table that when you input grades you’ll get the resulting or final grade automatically right? Here’s the formula:

1.     Click the cell below the “FINAL GRADE”

2.     Then paste this equation ‘=(SUM(X)/COUNT(X))*0.4+60’

Note: X = the cells where you input the grades

Hope this helps.

About Anthew Staw

Questions
3

Answers
34

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 08/02/2012
• Question Category: MS Excel