+ Post New Thread
Results 1 to 4 of 4
MIS Systems Thread, Reports of internal exam results in Technical; I now know that I am missing something obvious! Please tell me how to design a report that lists students ...
  1. #1

    Join Date
    Apr 2012
    Location
    Ireland
    Posts
    23
    Thank Post
    15
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Reports of internal exam results

    I now know that I am missing something obvious! Please tell me how to design a report that lists students with exam results so that I can vary it to present by subject, by year, in ranked order etc...

  2. #2

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,843
    Thank Post
    671
    Thanked 1,381 Times in 1,143 Posts
    Rep Power
    349
    Depends where you're storing them.
    I'd have thought you just start a report based on student then go down to either assessment or exams sub tables and pull out the data.
    You can also probably set up marksheets to display the data and export from there which might be easier.

  3. #3

    Join Date
    Apr 2012
    Location
    Ireland
    Posts
    23
    Thank Post
    15
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    We have set up aspects for each subject (e.g. English mark, Science mark) and result sets for each reporting session (monthly for all students and weekly for some). I am trying to design, in advance, a series of reports to allow us to present results (for internal review) along the lines of:

    1. September test results in [subject] for year group, alphabetical and in rank order
    2. September test results in [subject] by class, alphabetical and in rank order
    3. September test results in all subjects for year group, alphabetical and in rank order

    I am spending a bit of time trying to filter the report and it looks like I will have to create multiple variations of it - select result set at run time / select subject at run time / select year group at run time etc. It is also running quite slowly due to the number of queries in it.

    This is proving difficult to explain internally because the legacy system (Access - based and set up 10+ years ago) had a "simple" query that printed all of these reports. This appears to compare rather favourably to some staff when the first weekly report print (200 students) took over an hour to process / print.

    Is there a more straightforward way to do this?

  4. #4

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,843
    Thank Post
    671
    Thanked 1,381 Times in 1,143 Posts
    Rep Power
    349
    You could use marksheets to collate the data and then use it live or export to Excel. This could also require multiple versions or filters.
    You could also use Independent Reports to pull through assessment data into Word, and make it pretty, but this is more for individual student view.
    I have a number of data reports like you've tried, but they tend to have few filters, like, year group and subject. or aspect name contains and they put in comment. stuff like that. It is long winded, but works for certain cases.

  5. Thanks to vikpaw from:

    ProjectO (10th September 2012)

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 7
    Last Post: 9th June 2008, 03:55 PM
  2. GCSE Exam Results
    By mark80 in forum MIS Systems
    Replies: 0
    Last Post: 2nd April 2008, 09:42 AM
  3. Replies: 4
    Last Post: 31st August 2007, 11:31 AM
  4. CMIS exam results
    By slilley in forum MIS Systems
    Replies: 4
    Last Post: 11th July 2007, 03:19 PM
  5. security of internally hosted web server
    By Wizzer in forum Web Development
    Replies: 7
    Last Post: 27th June 2006, 08:50 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
  •