+ Post New Thread
Results 1 to 9 of 9
MIS Systems Thread, Tracking Grid/Progress Level Monitoring help in Technical; Hello everyone, I've recently become a SIMs user and I've had a mammoth of a task. I've exported about 1000 ...
  1. #1

    Join Date
    Mar 2014
    Posts
    4
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Tracking Grid/Progress Level Monitoring help

    Hello everyone,

    I've recently become a SIMs user and I've had a mammoth of a task.

    I've exported about 1000 tracking grids in the past week. It has been way too time consuming

    I need to make a quicker way to generate the same data

    What I am doing is placing ks2 sublevels as the rows and ks3/ks4 as the columns

    The 'target' would be the expected level of progress (e.g depending on year group 2 levels, 3 levels etc)

    However the catch is I've been doing that for every class in every subject and there are dozens of subjects and roughly 500 classes.

    I previously used chance analysis for this but the data needs to be printed with the students names.

    Would this be possible to generate using a report template?

    I just need something similar and a little more automatic than the grids as it will need to be used frequently

    I'll be extremely grateful for any help or suggestions anyone can offer

    Thanks

  2. #2

    Join Date
    Mar 2014
    Posts
    4
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Also as I neglected to say: I do have discover. Any suggestion discover wise would be fine.

    A marksheet idea would be fine too. Long as it can show the level of progress. I have that for ks4 but not ks3- if anyone can point me towards how to make a ks2 to ks3 levels of progress calculator on the marksheets- that'd be excellent in itself.

    If using a marksheet- I guess I'd need a way to calculate the expected level of progress, the amount of progress the student is targetted to achieve, the current progress the student has achieved and whether the current progress is on target/above/below expectations.

    If anyone has any help with that- that'd also be appreciated/excellent

    I'm in the unfortunate position of having to get to these done as soon as possible so anything that anyone has would be a massive help!

    thanks again
    Last edited by ZombieBatman; 2nd March 2014 at 03:22 AM.

  3. #3

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,326
    Thank Post
    36
    Thanked 353 Times in 238 Posts
    Rep Power
    79
    I don't think it is necessary to export to loads of spreadsheets If you don't get help here try on Support Net where there are many AM experts.

  4. #4

    Join Date
    Mar 2010
    Location
    UK
    Posts
    166
    Thank Post
    0
    Thanked 16 Times in 15 Posts
    Rep Power
    16
    Quote Originally Posted by ZombieBatman View Post
    Also as I neglected to say: I do have discover. Any suggestion discover wise would be fine.

    A marksheet idea would be fine too. Long as it can show the level of progress. I have that for ks4 but not ks3- if anyone can point me towards how to make a ks2 to ks3 levels of progress calculator on the marksheets- that'd be excellent in itself.
    There is no official progress between KS2-KS3. KS3 is being phased out - no KS3 levels are being collected this year.

    My advice would be to attend a HOF/HOD meeting and show them how to access the tracking grids and apply filters for themselves. They can then cascade this down into their depts.

  5. #5

    Join Date
    Mar 2014
    Posts
    4
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    thanks for the advice so far.

    I am aware that ks3 is on the way out and not collected but this is an idea taken at a school level to try and aid staff monitoring their students.

    I have setup a marksheet that calculates ks2-ks3 levels but the darn sublevels tend to make it slightly inaccurate.

  6. #6

    Join Date
    Mar 2011
    Location
    Bristol
    Posts
    119
    Thank Post
    24
    Thanked 24 Times in 20 Posts
    Rep Power
    18
    There may be more, but I can think of 2 options for calculating whole levels progress from full levels in a marksheet template.

    1. Create a second aspect called 'XXX Whole Level' with the lower bound of the level as the points and then use VALUE and MARKS TO GRADES to convert any sub leveled columns to whole levels and then work from there. This is messy as it creates multiple aspects and results but may have other benefits if you want to use the whole levels elsewhere.

    2. Use 'Lookup Tables' to create a sub-level to whole level converter. Set it up as follows:

    Type: Grade
    From (yy/mm): 10/00
    To (yy/mm): 20/00
    Step (in months): 24

    Grade Set - pick whatever KS3 sub level grade set you are using.

    Click apply and you will see a grid with all of you sub levels as rows and the age brackets as columns. All you need to do is put in the whole level values into the relevant cells for all age brackets. So the 5C, 5B and 5A row would all be filled with 30. A little hint here is to click copy and paste this table into Excel which obviouslly makes it much quicker to fill in the table. Then copy the whole table in excel and click paste on the lookup window which will transfer all of this in.

    Once you have this lookup table set up you can use the LOOKUP function in a template to do whole level calculations on sub level columns.

    I might be over complicating (I often do!) so I'd be interested to hear if there is a more elegant way of doing that!

  7. #7
    CAM
    CAM is offline

    CAM's Avatar
    Join Date
    Mar 2008
    Location
    Burgh Heath, Surrey
    Posts
    4,116
    Thank Post
    826
    Thanked 358 Times in 282 Posts
    Blog Entries
    60
    Rep Power
    281
    Try this:

    - Make a marksheet with KS2 level, form group and their KS3 level for a Year Group (or KS4 or whatever you want).
    - Export to Excel and put it into a PivotTable (Ensure student names are not split!). These are very useful, learn them now!
    - Set form group as filter, KS2 as row and KS3 as values.
    - Fiddle with the data to your heart's content. Do not be afraid to experiment by dragging fields between boxes, above/below each other, etc.

  8. #8
    tombry's Avatar
    Join Date
    Jan 2012
    Location
    Bassingbourn
    Posts
    194
    Thank Post
    45
    Thanked 37 Times in 29 Posts
    Rep Power
    22
    Quote Originally Posted by CAM View Post
    Try this:

    - Make a marksheet with KS2 level, form group and their KS3 level for a Year Group (or KS4 or whatever you want).
    - Export to Excel and put it into a PivotTable (Ensure student names are not split!). These are very useful, learn them now!
    - Set form group as filter, KS2 as row and KS3 as values.
    - Fiddle with the data to your heart's content. Do not be afraid to experiment by dragging fields between boxes, above/below each other, etc.
    This is how I always did it, now I use chance analysis, as only the head and I look at it, and it's helpful to see the names.

  9. #9

    Join Date
    Mar 2014
    Posts
    4
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Thanks for all the responses,

    Some good ideas here!

    The sheer number of classes that I am producing these for was the issue. I tried the pivot table idea as well before posting on here but with over 500 classes and 2 tracking grids required per class I had 1000 pages to produce (and on a regular basis). So even 1 minute a page would still be 1000 minutes worktime.

    I've found a solution though (thanks to help you've all given).

    I've calculated the level of progress data I require as an assessment/marksheet (it displays all the same data as the tracking grids i.e who is on target etc hence condensed two tracking grids into one). I used Ecclesbury's Lookup table suggestion as it meant I could create one uniform template for all my subjects. I had some results as sublevels and some as whole- converted them all to whole using Lookup tables and 'Marks to grade' on the result to turn it into a level.

    With that done I could simply clone my template and switch aspects in the formulas. So everything is now automatic AND I get more detail AND its less paper used. I just have to update the result sets every time and hit print.

    In regards to chance analysis- I used that until recently but have recently required more detail.

SHARE:
+ Post New Thread

Similar Threads

  1. Class Sound Level Monitor (Software)
    By SimpleSi in forum Windows
    Replies: 1
    Last Post: 21st October 2011, 07:04 AM
  2. Pupil Achievement points monitoring/tracking
    By Jamman960 in forum General Chat
    Replies: 2
    Last Post: 2nd March 2009, 07:09 PM
  3. Monitor Help (Button Presses)
    By garethedmondson in forum Hardware
    Replies: 3
    Last Post: 5th January 2009, 10:50 AM
  4. Projector help... What is Monitor Re-drive?
    By karlieb in forum Hardware
    Replies: 3
    Last Post: 18th July 2008, 05:18 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
  •