APM346-2018S > APM346--Announcements

Sum of all Quizzes

(1/1)

Victor Ivrii:
Quiz 7 on Blackboard

Also Quiz-total =
--- Code: ---LARGE(Q1:Q7,1)+ LARGE(Q1:Q7,2)+ LARGE(Q1:Q7,3)+ LARGE(Q1:Q7,4)+ LARGE(Q1:Q7,5)
--- End code ---
(Excel pseudocode), for those who wrote less than 5 quizzes it is undefined and replaced by
--- Code: ---SUM(Q1:Q7)
--- End code ---
(nobody submitted more than 1 doctor note for Quizzes, so no adjustment)

Bonus Q will be counted in Bonuses when I count them just before submitting Final Mark

Not calculating for Term Tests since they are pooled with Final Exam

Andrew Hardy:
In your original announcement, when you said
  "I will offer a bonus quiz--which means that the mark for it will be simply added to the final mark"
I was under the impression you would add it to final quiz mark?  This has a more positive impact on marks, and seems more intuitive to me? It tested a fundamentally different thing than the Bonus contributions section.

Victor Ivrii:

--- Quote from: Andrew Hardy on April 06, 2018, 06:02:20 PM ---In your original announcement, when you said
  "I will offer a bonus quiz--which means that the mark for it will be simply added to the final mark"
I was under the impression you would add it to final quiz mark?  This has a more positive impact on marks, and seems more intuitive to me? It tested a fundamentally different thing than the Bonus contributions section.

--- End quote ---

Why? It is just added to the Final Mark. Just for you I created Quizzes* .

The problem is that if someone wrote < 5 Quizzes the general formula I used returns UNDEFINED (in Excel) and I need to use alternative formula SUM (because in your class nobody legitimately missed >2 quizzes) and decision when to apply the latter was done manually. So I want not to throw another field into this, but to keep it  separate

Andrew Hardy:
Dr. Ivrii,
OK now I understand. Thanks for such a transparent process

Navigation

[0] Message Index

Go to full version