How to calculate your average (1/08 update)

I've had a few requests for class averages. Here's how you calculate it.

From the Syllabus:

• Presentation 10%
• Concert Reports 10%
• Tests 60%
• Final Exam 20%

So here's how you calculate it. (You CAN setup an excel spreadsheet to do this for you. That will let you play "what if" - "what if I make an 80 on the final......" etc).

Figure up an average of the test scores. Then the

Final grade =
Presentation grade times .10
plus
Concert report grade average times .10
plus
Average of the tests times .60
plus
Final exam grade times .20
and then subtract 3 points for every class you missed greater than 2
(i.e. 3 classes missed, subtract 3 points. 4 classes, subtract 6 points)

That will be a percentage - i.e. .88 = 88%


How to setup a Spreadsheet (using Excel)

In this cell:	Type This:
A4	Description
B4	Grade
C4	Average
D4	Final Grade
A5	Presentation
A6	Concert 1
A7	Concert 2
A8	Test 1
A9	Test 2
A10	Test 3
A11	Test 4
A12	Final Exam
A13	No. Classes Missed
C7	=AVERAGE(b6,b7)
C11	=AVERAGE(a8,a9,a10,a11)
C13	=IF(B13>2, -1*(B13-2*3),0)
C14	Attendance
D5	=(B12*.2)+(C11*.6)+(C7*.1)+(B5*.1)+(C13)