View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
GS[_2_] GS[_2_] is offline
external usenet poster
 
Posts: 3,514
Default Weighted Grades Worksheet

GS fixed some typos :
In my student grades manager app, scores can be comprised of any number of
individual score components *but* the average is what determines the weighted
score for that module those components belong to. For example, a course
module consisting of 11 components each worth 20 marks means the total
available score for that module is 220. If a student scores a total of 198
then the average is 90% (198/220*100%).

If the module has a --weight value-- of 20% (value is out of possible total
of 100%, as pointed out by joeu2004) then the --weighted score-- for that
module is 18%. If the same student scored 90% in another course module with
a --weight value-- of 30% the --weighted score-- will be 27%, giving this
student a rolling average of 45%. There is another 55% of --weight values--
yet to be used by other achievement score modules.


--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion