First question I had was: how does Blackboard arrive to the "possible points" you see when you hover above the weighed total column? I'm unable to find any information about this and faculty frequently asks about this number.

Second question: Conceptually it should not matter the basic point value you use for your assignment, it should arrive to the same grade at the end. However when I experimented with this, it did not calculate the same

Third question: Would any of you happen to have a grade center template using excel (and formulas) to show how the math is being done step by step? I am trying to develop one but struggling with building the formulas.

Since all the points in their respective categories are the same, it shouldn't matter in this instance if it was equally vs proportionally. However, the points possible value is achieved like such for your grades:

Example 1

Homework: [(20+20+20+20+20)/5]*.20 = (100/5)*.20 = 20*.20 = 4

Project: [(25+25+25+25)/4)*.20 = (100/4)*.20 = 25*.20 = 5

Midterm: [(100)/1]*.20 = 100*.20 = 20

Survey: [(100)/1]*.20 = 100*.20 = 20

Final: [(100)/1]*.20 = 100*.20 = 20

4+5+20+20+20 = 69

Example 2:

Homework: [(100+100+100+100+100)/5]*.20 = (500/5)*.20 = 100*.20 = 20

Project: [(100+100+100+100)/4)*.20 = (400/4)*.20 = 200*.20 = 20

Midterm: [(100)/1]*.20 = 100*.20 = 20

Survey: [(100)/1]*.20 = 100*.20 = 20

Final: [(100)/1]*.20 = 100*.20 = 20

20+20+20+20+20 = 100.