Figuring out your grade via a Excel app?

On December 08 2009 14:52 Mickey wrote:
So I want to figure out my grade so I know how my future PP grade might influence my total grade.

Does anyone have any knowledge with Excel? I remember taking a class on Microsoft Office 2 years ago, but we didn't really touch on Excel and I can't really remember anything.

My geology grade consists of

Four Midterm Exams 36%
Final Exam 20%
Laboratory Reports 20%
PP Presentation 20%
Quizzes 10%

Edit: Would you need anymore information, like total points?

If anyone would take the time to write it really quick, and maybe post it/e-mail it. I would really appreciate it.

On December 08 2009 15:02 oxidized wrote:
If you put your grade averages for each category in the 'A' column (say Midterm=A1, Final=A2, etc), then you can just make an arithemtic equation in another cell to take the weighted average to calculate final grade.

So in the weighted average cell you would enter the equation:
= A1 * .36 + A2 * 0.2 + A3 * 0.2 + A4 * 0.14 +A5 * 0.10

Then that cell will calculate the weighted average of whatever you put in the previous cells.

Edit: and yeah, you really don't need excel for this lol. You can do what JeeJee said

On December 08 2009 15:19 affinity wrote:
Well, in case if you were still too lazy to calculate your grade yourself, I decided to get a teenie bit of practice with excel~

Here's a quicky, I think it should work out fine. I assumed that all the midterm grades were weighted equally; I also didn't know how many quizzes/labs you had, so you can enter up to 20 . Just fill out everything in yellow(if a quiz/lab didn't happen just leave it blank).

http://ifile.it/72ylkwc/mickey grade.xlsx

On December 08 2009 15:32 affinity wrote:
Haha, yea the formula isn't too hard to calculate by hand. Saved in 2003 format?
http://ifile.it/f0eckho/mickey grade.xls

Sorry :o

On December 09 2009 01:59 Mickey wrote:

That's really awesome. Now I feel really stupid that I didn't know how to do this =/ Most people forget right?...