+ Post New Thread
Results 1 to 3 of 3
MIS Systems Thread, Help creating report to show classes and attached teachers. in Technical; I need a report to output the classes (class names) and then at the side of this show the teachers ...
  1. #1
    Kyle's Avatar
    Join Date
    Jan 2006
    Posts
    974
    Thank Post
    91
    Thanked 14 Times in 13 Posts
    Rep Power
    21

    Help creating report to show classes and attached teachers.

    I need a report to output the classes (class names) and then at the side of this show the teachers that teach the classes.

    I need it to show that yr7Eng\1 has more than one teacher teach that group over the week.

    Something like:

    Yr7Eng\1. Mr Smith. Mrs Jones
    Ye7Maths3. Mr Trent. Miss Bridge


    Does anyone know if this can be done?

  2. #2
    nickbro's Avatar
    Join Date
    Jul 2010
    Location
    Gilwern, Wales
    Posts
    3,520
    Thank Post
    37
    Thanked 501 Times in 432 Posts
    Rep Power
    113
    If you are using SIMS, load NOVA-T

    Reports > Curriculum Analysis > List of Classes for a Year(s)

    Select Yes at Do you want all years?

    Leave as is on the next box, and ok

    You get something like this

    Code:
     10C/Gr1   Gr      10C/Gr1   Mr X                           5       5       
     10C/He1   He      10C/He1   Miss X                    5       5       
     10C/Ic1   Ic      10C/Ic1   Mr X                          3       3       
                       10C/Ic1   Mr X                        2       2       5       5       
     10C/Pe1   Pe      10C/Pe1   Mrs X                   5       5       
     10C/Dt1   Dt      10C/Dt1   Mr X                        5       5       
     10D/Hi1   Hi      10D/Hi1   Mrs X                       5       5       
     10D/Pa1   Pa      10D/Pa1   Mrs X                      2       2       
                       10D/Pa1   Miss X                       1       1       
                       10D/Pa1   Mr X                          1       1       
                       10D/Pa1   Mrs X                     1       1       5       5
    In this report you can see, for 10D/Pa1 there are 4 teachers on the class
    Last edited by nickbro; 17th December 2013 at 11:04 PM.

  3. Thanks to nickbro from:

    Kyle (18th December 2013)

  4. #3
    Kyle's Avatar
    Join Date
    Jan 2006
    Posts
    974
    Thank Post
    91
    Thanked 14 Times in 13 Posts
    Rep Power
    21
    Perfect nickbro


    Just what i needed.


    Many Many thanks

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 30
    Last Post: 22nd August 2014, 04:21 PM
  2. Replies: 4
    Last Post: 8th February 2013, 10:44 AM
  3. [SIMS] Report to show titles of linked documents
    By pubgrub277 in forum MIS Systems
    Replies: 2
    Last Post: 22nd May 2012, 02:49 PM
  4. Ideas for creating forms to be emailed and returned
    By sidewinder in forum General Chat
    Replies: 2
    Last Post: 18th May 2012, 12:09 PM
  5. Replies: 36
    Last Post: 5th August 2011, 07:13 AM

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
  •