Author Topic: Bug in HA total calculation?  (Read 5787 times)

Ian Kivlichan

  • Sr. Member
  • ****
  • Posts: 51
  • Karma: 17
    • View Profile
Bug in HA total calculation?
« on: December 21, 2012, 02:15:04 PM »
I think there might be some bug with the total homework mark calculation mentioned in this post ( ).

Calculating my total homework mark using the same formula, I get a total HA mark 2 points greater than the one I see online on Portal. Does anyone else have a similar issue? I wonder if it might affect people who did not submit HA9 in particular, since I did not submit it, and know of someone else who did not submit it who seemed to have the same problem.



Victor Ivrii

  • Administrator
  • Elder Member
  • *****
  • Posts: 2550
  • Karma: 0
    • View Profile
    • Personal website of Victor Ivrii
Re: Bug in HA total calculation?
« Reply #1 on: December 21, 2012, 05:19:13 PM »
Ian, thanks for alerting!

There really was a bug albeit not exactly one you thought. It appears that functions
Code: [Select]
SMALL(E2:M2,1), SMALL(E2:M2,2) were stupid enough to skip empty cells. So for a student who had, say, '-,-,19,18,20,20,20,20,13' these functions had dropped not '-,-' but '13,18'.

There was no problem with HA9 as it was rescaled and those who missed it had '0' in the calculations rather than'-' but with any other missed homework. I solved this by temporarily creating columns which were copies of those corresponding to HA1:HA8 but with '-' replaced by '0' and using them to calculate total.

I recalculated marks and uploaded them.

Everyone who was affected should thank Ian

I hate spreadsheets, Microsoft and Blackboard!!!!
« Last Edit: December 21, 2012, 06:25:43 PM by Victor Ivrii »