Hi, There's a lot of differences between public and private schools' averaging here in the Philippines. Private schools often gives high grades. So, I am asking you now the correct averaging. CATEGORY---------PERCENTAGE---ITEMS-----SCORE--PUPIL PERCENTAGE PROJECT----------------10%-------10%------95%/100%--------9.5 RECITATION--------------15%-----15%-------90%/100%--------13.5 HOMEWORK/SEATWORK---10%-----200--------185/200----------9.25 MONTHLY EXAM----------20%------50---------50/50------------20 PERIODICAL EXAM--------30%------50---------50/50------------30 QUIZ---------------------15%------25--------20/25-------------12 INSTRUCTIONS: 1. I divided my score to a total score. Like 20÷25. 2. I multiply the answer by 100. Like 0.8x100 3. I multiply the answer by 0.15. Like 80x0.15 The answer was 12. Note: If you noticed, I add "0." before the category's percentage. Like "0.15" My average will be 94.25. Right? If there is something wrong please let me know. P.S. The averaging system I made is the averaging system of most public schools here in the Philippines. Thank you and answers will be greatly appreciated. God bless.
Wasn't your question on this just answered: http://forum.allaboutcircuits.com/showthread.php?t=49405 John
Yes. but if you noticed, my quiz there is only 12 which is to be 13.5. so 13.5 would be correct? my formula/method is 20 divided by 25. I multiplied the answer to 50. Then add more 50. Then times it to 0.15. thanks.
The process of doing a weighted average is the same, regardless of the values assigned for the individual weights. You just need to update your values. You have added a couple of new columns, and your addition seems correct. Your current average is 94.25%, which is what you calculated. So, you seem to have the right idea. John