trackers

Thanks. I was thinking about this on the drive home from work and I think I've got the idea of it now. Probably be Monday before I can try it out. Just wondering if I would have to reassign the aspect to the report after the aspect is updated on the marksheet or shoukd it automatically react to the change...

I think I get the gist of this. I have had a play around with it and I think I am closer to getting what I want. I was able to find the formula with the colours in the template. I think I am going off track at the If 1=1 then1. I'll take another look as soon as I can.

Thank you both for the replies. The grade that is coloured on the marksheet is generated by comparing a numerical entered value with grade boundaries which must then be compared with the target grade to create the colour on the marksheet. This grade and associated colour then appear on the report card. The grade I am having a problem with is the target grade which is a straight entry on the marksheet of a grade. It has not background colour. I am attempting to get this to appear with a white background when it is picked up by the report card. I thought that the suggestion that white could not be used might have helped - so I changed the colour to another alternative on the marksheet by right clicking and selecting set colour for cell. But the colour still does not copy across. I realise that it is probably something to do with formula but I am not sure how to set this or if it is even possible. I am hoping to get a few pointers. I was hoping that if I could see the way the green red and yellows are generated ( I imagine with some sort of If and then statements) that I might work through it but I can't seem to find how to access these formula either.

I have a SIMS marksheet that uses two fields I need to bring to a Report sheet that is on Word document. One of these fields on the marksheet is has a coloured background which appears thge same colour on the Word document ..as I want it to. and in doing so this colour eg Yellow overwrites the greay background that is on the report sheet.. just as I want it to. My issue is that the other field has no colour so when the grade is brought across to the marksheet, it is putting that grade onto the grey colour. What I want to happen is for this grade to "white out" the grey. I am not sure how to go about this.... I would imagine there must be a way to do this and I also think that if the marksheet grade had a white background associated with it that it would work the same as the coloured cells that are transferring as I want them to in the other cells. Hoping I might get some advice on this Trackers

I have seen some recent threads on this but I believe the protocol is to not hijack a question thread so I guess it is best to post a new thread. We have a tracking document that shows marksheet grades and brings the conditional formatted grades through , I believe, from the marksheets themselves which compare given marks with a set target grade, ie red - blow target, yellow - on target and green - above target. A student who is targeted for an A* and achieves it get s yellow - I have a notion of changing the green to mean - "above target (or A*)". I have two issues 1. I am not sure how to change this in the marksheets and even more importantly 2. Is there a way of changing this for all marksheets or would it have to be done manually for each sheet? Typically we have 4 tracking marks per year and as many as 16 subjects in a year - and 7 year groups - so I am hoping there is some way it might be easily achieved...

Getting on..........ok. Must admit it is all taking up huge amounts of my time. The bulk update is something I'll put on the long-finger for now. The IT in house expert left at Christmas so now it's pretty much up to me to learn as I go. Latest issue is that simple marksheets are printing with some blanks even though I have a box checked that says it shouldn't print empty sections. The sections are empty because students are not taking a particular course - eg "Design and Creativity" - they are not in the marksheet class list, yet the subject is appearing on the students tracking sheet. I know there is a quick way to fix it somehow - but as I don't know it yet - I spent over an hour opening xml files - deleting the offending rows on the report table - saving and printing. luckily the offending subjects do not appear on the fuller "winter report" that includes all the teacher comments.

The advice given has been brilliant. I tried out the setting of the date range and as long as I do it for Grade, comment and teacher initials the reports I don't want from previous academic years disappear and the reports from the current year , appear properly. When I do it for our A2 repeat students who have dropped from 3 to 2 subjects - the dropped subject no longer appears. So all is good. I am interested in Esteban Child of the Sun's suggestion about cloning and using find and replace. Does this mean that using the find and replace I don't have to go through the fairly slow process of clicking on the aspect I want to change selecting "result" and browsing for the correct result or comment to insert? I thought that maybe I had to do this to create the correct link - but if I don't then the process won't be so slow after all. Does this also mean that on my simpler marksheet reports - that if my first report shows target grade and track grade 1 for each particular subject, that when our second phase of reports shows track grade 2 as well - I can copy and paste the text, change the 1 to a 2, rather than having to search for the correct track2 in the menus to insert it?

Thanks Mistert89. As a new user - does this mean that when I go Focus>Assessment>Individual report>Year 13 Winter Report that when I select Students...that when the options window pops up and I select the year group that the date range I need to set is at the top of this pop up window? I notice that at the moment it starts at 01/08/17 - perhaps this is a date that will pick up last years info? Another - somewhat related question is: I have a laptop that I can access SIMS on at home - it seems that I can do everything apart from generate the actual reports - when I try to do this SIMS freezes indefinitely. I wonder if it is likely to be a bandwidth problem or a laptop problem. I have BT infinity. I wonder if I am trying to do something that it is not possible to do at home? (Perhaps this question should be in a separate post too?)

Thanks for the reply Pink_Panda. Tried some of your suggestions. Changing the "read-only" in the Templates as you suggested seems to have got me there. We have 4 track grades per year and I was able to delete grades/scores 3 and 4 (that shouldn't be there yet) using this method you suggested. It's going to be a bit of a slow process to do this for the group of repeaters in each subject - but if it is a one time job each year I think it will be worth it. As I said I have just started using this program and this is something I was told couldn't be done - so thanks for your help. I am just hoping that it doesn't cause any difficulties when the time comes to enter values in the cells by the teachers - ie the grades will still be calculated and grades generated as before. I will have to see how I print out the next set of tracks using a date range - it seems that might even solve the problem I was having without the need for the process above...although I am not sure if I have this right?

I am very new to SIMS and this is probably a very basic question......and a second question that is perhaps more of a problem... 1. I am about to print out a set of reports. Is it possible to remove an X from a marksheet field? Because a "0" was entered for a tracking mark there is an X in the grade column on the marksheet and it is being displayed on the report. If I remove the "0" - the X remains. I think the settings are such, that if I could remove the X (which is greyed out) the report would not display the subject report. 2. We have a group of students who are repeating their AS year but have kept on one A2 subject. In the A2 subject, when the reports are printed, they are picking up the teacher comment from the previous year (the AS year) rather than the A2 teacher comment that I would like to display. I can manually change this on the exported Word document report - but am wondering if there is an easy way around this - because it is a problem that is going to present itself every year. My predecessors tell me that they never found a way around this! ..................... any advice appreciated. trackers