+ Post New Thread
Results 1 to 14 of 14
MIS Systems Thread, Individual Report Examples in Technical; Has anyone got any good examples of progress reports created on sims individual reports. we are looking at changing from ...
  1. #1

    Join Date
    Sep 2009
    Posts
    24
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Individual Report Examples

    Has anyone got any good examples of progress reports created on sims individual reports.

    we are looking at changing from the traiditional school report to termly progress report for all students and i am trying to come up with ideas for format with some more information other than just a table of current and predicted grades.

    has anyone used the graphs before? and have you any advice

    thanks

    Emma

  2. #2

    Join Date
    Sep 2006
    Location
    Reading
    Posts
    177
    Thank Post
    14
    Thanked 41 Times in 39 Posts
    Rep Power
    23
    Hi Emma,
    we don't use graphs here but I'm sure Sivadam will have some information on that! We do use a lot of grades, targets and colours in our progress reports and they look quite good but really you need to think about the data you collect first and then think about how to display it if you are going to change from a traditional report.

  3. #3

    Join Date
    Sep 2009
    Posts
    24
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    thanks for that, yes i think the data we have is workable.

    we report on predicted grade, current grade, attitude to learning (a level of 1-5) then a homework mark of satisfactory, unsatisfactory of not completed.

    I use traffic light systems on our marksheets so could copy over the colours.

    is there any chance you could give me an example of yours? I am looking for some ideas and will be taking them to senior team next week for discussions.

    thanks

  4. #4
    NorthernSands's Avatar
    Join Date
    Mar 2011
    Location
    Qatar
    Posts
    134
    Thank Post
    21
    Thanked 19 Times in 19 Posts
    Rep Power
    10
    Hi Emma,

    I re-did ours when I arrived at this school in September. They were using the old 'landscape with a table' style. I'm not saying mine is any good. Given time I'm sure it could be better (well, given time or a new senior team!), but it might get your creative juices flowing, as it were, along with any others you see.

    I've also included the template so you can see how it's constructed and what's missing for this particular student. Pay attention to the <Report Section> and </Report Section> tags as what's between them won't appear if there's no data (eg EAL and AEN in this case).

    Hope this helps!

    Pete.
    Attached Files Attached Files

  5. Thanks to NorthernSands from:

    vikpaw (22nd June 2011)

  6. #5

    Join Date
    Sep 2009
    Posts
    24
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    thanks Peter that looks really good, has already given me some ideas!

  7. #6

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    I like the coloring and use of description not grade from the aspect.

  8. #7
    NorthernSands's Avatar
    Join Date
    Mar 2011
    Location
    Qatar
    Posts
    134
    Thank Post
    21
    Thanked 19 Times in 19 Posts
    Rep Power
    10
    @emmaburt; you're welcome. Let us know if you need any help with the creation of the templates. A word to the wise though: Word is still utterly pants at dealing with tables. You'll notice there's a very narrow (shallow? thin?) row at the top of each table, with columns that may not match the rest of the table. If I need to add extra columns or something, this top row is something I always refer back to, and quite often spit cells further down to match the top row when making amendments, then merge the cells back again, always leaving the top row as is. Er, clear as mud?!

    @vikpaw; I think the description works better than grade considering most of our parents are EAL / haven't a clue what a [Sub-]Level is. Although the Middle School like it like that, the Upper School insist on the grade! Grrr! The colouring works well, but we actually switch it off for printing at the moment, and back on again when uploading to the DMS.
    Last edited by NorthernSands; 22nd June 2011 at 11:33 AM.

  9. #8

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    When we did use graphs, we had this for ESL and the other is just your bog standard table.

    esl graph report.jpg

    ib summary.jpg

  10. Thanks to vikpaw from:

    NorthernSands (22nd June 2011)

  11. #9
    NorthernSands's Avatar
    Join Date
    Mar 2011
    Location
    Qatar
    Posts
    134
    Thank Post
    21
    Thanked 19 Times in 19 Posts
    Rep Power
    10
    I like those graphs, @vikpaw. Very clear and very informative. Maybe I should take another look at them next year. I presume 5 years worth of computer enhancements will make running them take less than three weeks...

  12. #10
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,449
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    55
    Quote Originally Posted by number34 View Post
    Hi Emma,
    we don't use graphs here but I'm sure Sivadam will have some information on that! ........
    Emma,
    If you PM me (or email me!) your email address then I will send you an example of our KS3 AM7 Individual report.
    Amongst other things, the report contains progress graphs for English and Maths, across the Key Stage. Obviously these are also published to parents etc on SLG as well!
    The graph labels show the AM7 Sublevel value for each data collection. This is despite there being a KB on SupportNet that suggests that this is not possible! We have also pasted on a more meaningful scale for the Y axis of each graph.
    Last edited by Sivadam; 22nd June 2011 at 01:17 PM.

  13. #11

    Join Date
    Sep 2009
    Posts
    24
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    got it!

    thanks Sividam, looks great!

  14. #12

    Join Date
    Jan 2009
    Posts
    32
    Thank Post
    4
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Hi how do you put different colors depending on the grades? i think that is awesome

  15. #13
    NorthernSands's Avatar
    Join Date
    Mar 2011
    Location
    Qatar
    Posts
    134
    Thank Post
    21
    Thanked 19 Times in 19 Posts
    Rep Power
    10
    Quote Originally Posted by joseph View Post
    Hi how do you put different colors depending on the grades? i think that is awesome
    Yeah, it can look pretty good. The colours are taken straight from the cell colour in the marksheet, so you can either colour the cells / columns manually or colour them based on the contents (which I guess is what you're referring to). Doing the latter is straight forward, if time consuming. You essentially have to use a Nested If Then Else formula column which refers to the column you want to colour, with each 'If' testing the criteria for each colour, and the 'Then' returning the original column and the colour. You have to do this for every column you want coloured, so a marksheet to do a year group might run to well over 100 columns (half the original columns, half formula columns). Once done though, it's done (and @vikpaw has an amazing VB script so you can change result sets in bulk so you can just clone the first template). A screenshot might help:

    NestedIfThenElseColouring.jpg

    You have to be careful when using colours, as Red is the exact same shade as unsaved Cell text (so you can't see the data). In my case I don't care 'cause the the data is going to be saved (to save the colour to the result) and the result will turn black and be visible again, but there are some circumstances when you do want to read unsaved data.

    The colours I used are (the same as used by default in Office 2007 for some conditional formatting):

    Code:
    Colour	R	G	B
    Blue	0	112	192
    Green	0	176	80
    Amber	255	192	0
    Red	255	0	0
    Pete


    EDIT: Oh after you've created your first If Then Else formula column, when creating the next one, choose ITE formula type then choose to clone it from the first ITE column. This'll save you having to re-enter the colours.
    Last edited by NorthernSands; 23rd June 2011 at 05:04 AM.

  16. #14

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    There also is the possibility of putting in a conditional formatting rule in the Word Template to do colouring. This may, {not sure as not used it myself}, be quicker than editing marksheets. This was how it was done before the Ind. Reps. pulled colours through.

SHARE:
+ Post New Thread

Similar Threads

  1. RoboCopy GUI Examples
    By mattx in forum Windows
    Replies: 5
    Last Post: 27th July 2010, 06:58 PM
  2. Fronter VLE examples
    By grinch in forum Virtual Learning Platforms
    Replies: 3
    Last Post: 19th November 2009, 09:47 PM
  3. Examples of good Moodle course?
    By gaz350 in forum Virtual Learning Platforms
    Replies: 5
    Last Post: 19th December 2008, 04:12 PM
  4. How about some examples ! (Joomla Websites)
    By tuthmosis in forum Web Development
    Replies: 9
    Last Post: 16th July 2007, 08:00 AM
  5. Any one got any AUP examples?
    By tosca925 in forum How do you do....it?
    Replies: 4
    Last Post: 9th February 2006, 10:23 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
  •