Weighted scores for student tasks
I have a workbook that I am using for student results.
I have had some great help from the forum and am asking for more.
In each section, I have 10 columns for teacher to write the title of the task.
I have 4 sections in total
I would like each of the last 2 columns in each section to be weighted more than the previous 8. I would like the 2nd to last to be weighted 25% and the last column to be 40%
Pl explain with example how you decide total%.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
I've hardcoded the weighting into the array below. I assumed the remaining 8 scores were equally weighted at 4.375% each.
Check this gives the answer you were expecting though. a quick check my end seems to work OK
Please Login or Register to view this content.
Happy with my advice? Click on the * reputation button below
Thank you so much Crooza.
Sorry for the delayed response. I had forgotten I had asked.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks