+ Post New Thread
Results 1 to 2 of 2
MIS Systems Thread, Class Average in Individual Report in Technical; I've been asked to set up a field in an Individual Report where the results in a column from AM7 ...
  1. #1
    CAM
    CAM is offline

    CAM's Avatar
    Join Date
    Mar 2008
    Location
    Reigate Area, Surrey
    Posts
    4,411
    Thank Post
    880
    Thanked 416 Times in 316 Posts
    Blog Entries
    61
    Rep Power
    328

    Class Average in Individual Report

    I've been asked to set up a field in an Individual Report where the results in a column from AM7 are averaged across one entire class and displayed on the report.

    I can see how to get a % or count up for grade aspects but not for numerical ones. Is it even possible? Same for min max.

    Example in hand:
    - Assessment columns are filled in, say 5, and these are averaged to give a final result.
    - Final result is averaged over the whole class and a min-max worked out.
    - Report shows the class average for a subject is 60%, the highest result is 90% and the lowest 20%. The child has only 30% so their parents can see he is doing relatively poor. Repeat for other subjects on the report.

  2. #2

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,953
    Thank Post
    770
    Thanked 1,487 Times in 1,234 Posts
    Rep Power
    367
    You'd need to do the calculation in AM7 or perf analysis. We don't really do it. The best i've done up and down a column is to use the position formula field to show a kids position in the class. There's nothing that really does the maths across the group. You need to use something else like group analysis, but i don't know if you can pull fields in from that. I've not done it. Do you use Discover? isn't there something in there you can use?

    Group Analysis does give nice figures.

    The thing that is built in to ind.reps is you can pull in group totals / results. So you could show what percentage of results were a certain grade(s), that you enter in the tag.

    We don't do much analysis so there are probably other ways of presenting the data.

  3. Thanks to vikpaw from:

    CAM (5th May 2012)



SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] HOW-TO: Bulk Update Result Set in Individual Reports (AM7)
    By LosOjos in forum MIS Systems
    Replies: 7
    Last Post: 19th December 2012, 11:15 AM
  2. [SIMS] Individual Reports in SIMS
    By tben2505 in forum MIS Systems
    Replies: 8
    Last Post: 6th March 2012, 02:07 PM
  3. [SIMS] Line Breaks in Individual Reports via comment Aspects
    By tben2505 in forum MIS Systems
    Replies: 11
    Last Post: 22nd October 2011, 07:48 AM
  4. [SIMS] Data Graphs in AM7 Individual Reports - SIMS
    By Sivadam in forum MIS Systems
    Replies: 4
    Last Post: 8th March 2011, 09:53 PM
  5. Individual reports for students in SIMS
    By cjohnsonuk in forum MIS Systems
    Replies: 2
    Last Post: 25th March 2008, 12:27 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •