Blog Comments

  1. alisabenjami's Avatar
    • |
    • permalink
    [url=http://www.risingjerseys.net/mlb-jerseys/]Wholesale MLB jerseys[/url]
    [url=http://www.risingjerseys.net/nhl-jerseys/]Cheap NHL jerseys[/url]
  2. ctaylor's Avatar
    • |
    • permalink
    Yes - this is what I suspected would be the solution. Thanks Neil.
  3. NeilF's Avatar
    • |
    • permalink
    Hi,
    I created a grade set containing whole levels only with the value of each level set at the lower boundary for that level. I then set up aspects for KS2 and KS3 levels for each subject I wished to do the calculation on using this grade set. Within the template I then added columns using formula VALUE to get the points for each KS2 and KS3 teacher assessment. I added columns for 'data entry using formula' so that I could use the MARKS TO GRADE function to convert these values into the newly created aspects with the limited set of levels. This allows you to perform a much simpler calculation using DIFFERENCE that gives answers in multiples of 6 or whole levels. You will end up with 6 new columns per subject which is probably why I only did it for En, Ma and Sc.
    Hope this helps.