How do I calculate my grade point average in Excel?
I would like to create an Excel document for my school grades, as shown in the diagram above. The first row in the first column should contain the assignment grade for German, for example. Assignments are graded twice. The second row in the first column should contain the single-grade grades, such as short-term assignment grades, impromptu assignment grades, presentation grades, etc. The third row, also in the first column, should contain the average grade for the subject.
The second column would then, of course, contain a different subject, e.g., math. The rest of the principle would be the same: the first row would be homework, the second row would be graded grades, and the third row would be average.
Does anyone know how to create this? I'm not familiar with Excel.
(1 votes)
Loading...
right?
Supplement:
In the case of different weightings, which may also change or additional notes, I would enter the weighting, since it is then possible to obtain the (sum of all weightings), not as I now manually calculate the first note x 2 and then the result : 3
Instead of divided by 3, divided by number of notes
Thanks for the supplement, but this does not make any sense number of notes is always 2 a double weighted one just weighted. Let’s take the example Math
(5×2+2) : Number of notes so 2 = 6 that cannot vote. Or I get you wrong.
the
No matter what I’ve been wondering, it happens to everyone, I’m always grateful if someone knows about potential thinking mistakes.
I’m afraid I’m standing on it 😉
For me; the result of 2 weighted notes / 2 … or I just stand on the hose
Yes, but the upper one should be weighted twice, so in the end I have to share the number of weightings or do I stand completely on the hose?
You have 2 notes in column A if I see that right.
Hello,
I would do it like this:
There are also some comments:
1. I find your division from top to bottom not well chosen as it is more difficult to add new notes. Therefore, I would add the notes from left to right. To the cell B4 then comes this formula (just copy!):
=(SUMME(B2:Z2)*2+SUMME(B3:Z3))/(ANZAHL(B2:Z2)*2+ANZAHL(B3:Z3))
Two. For the individual subjects I would create individual tables. To do this, you can copy a once created table sheet and then simply rename it to the desired subject.
If you’re in the cell by the way B1 the following formula:
=CELL(“filename”;$A$1);FIND(“)”; TABLE(“filename”;$A$1))+1;31
the respective sheet name is correspondingly output in cell B 1 . In this way you simply rename your table sheet and have the right compartment in cell B1.
3. If you want to add to the other notes what this is for a note (referat, short work, ex), you can register Check the Comment function use, or you simply use an additional line above or below the current 3rd line in which you enter the respective grade.
4. If you want to see all your averages from all compartments next to each other in a complete overview, I would create a separate table sheet, in which I will display the calculated average from each table sheet of a compartment.
Five. If you actually want to add weights other than simple and double weightings, you should consider a completely different classification of the table in which the weighting can be entered manually.
Greeting, BerchGerch
PS: Normally, the second decimal place is rounded at average. This makes Excel anyway when you set the cell format to a number with two decimal places. If at your school the second decimal place is not rounded at the average, but is “cut off” after the 2nd decimal place, the formula for the average in cell B4 must also look like this:
REQUEST(SUMME(B2:Z2)*2+SUMME(B3:Z3)/(ANZAHL(B2:Z2)*2+ANZAHL(B3:Z3));2)
If a note is weighted twice, for example, this note is added twice for the sum of the notes and is also taken into account twice in the number of notes.
Could look like that.
You could do it like this: Rate twice = write twice. With formula =SUMME()/ANZAHL().