antonponniah

Thanks for your input, that's what I intend to do.

You are right that 9 shouldn't map to the Legacy grades. In my case, we wouldn't have any targets set to A*1 so I can take the 9 off. Somehow we have to set the targets and there are no guidelines how to go about setting targets from KS2 to new GCSE grades, we have to rely on our existing method. Hope this will lead to close to desired outcome. Thanks for you advice.

I am in the process of generating KS4 targets and need some assistance how to map the old GCSE grades to the new equivalent GCSE grade. Since we know the correlation between KS2 and Legacy GCSE grades, I can easily set the target for the Legacy grades, for example if I want 3levels of progress then I add 13 to the KS2 and find the corresponding GCSE grade. In order to set the target for 1-9 grade, firstly I find the Old grade and I want to convert this to the new 1-9 grade. According to the points shown on the 4Matrix (analyse software that we use at our school), I have roughly converted the grades as below and wondering if anyone confirm whether this is correct. Please note that I need the fine GCSE grades (A, B and C refers higher, middle and low respectively). A*1 --> 9 ; A*2 --> 8A ; A*3 -->8B ; A1 --> 8C ; A2 --> 7B ; A3 -->6A ; B1 -->6B ; B2 --> 6C ; B3 --> 5B ; C1 --> 4A ; C2 --> 4B ; C3 --> 4C ; D1 --> 3A ; D2 --> 3B ; D3 --> 3C ; E1 --> 2A ....etc. Thanks for your time.

Thanks Vikpaw for your input, my colleague who edit this is off sick this week so won’t be able to test this for the time being (I only deal with Assessment Manager), I will come back to you once I tested this. Thanks again.

Yes, mark sheet shows the owner and the selected course is correct on the report template. One other thing I notice is, on the course manager, i can only see those classes in question when I put a past date than the default census date;for all the rest of the courses I can see all the classes with the default date selected.

thank you both for the quick replies. updating course membership is the first thing I tried too, which is always a life saver.. but not this time.

Teachers of one of the course is not showing up on the individual report, all the other course teachers are fine, by looking further I found out that particular course was setup after the census was done, I think this may be causing this, just wondering if anyone had this issue and if any workaround possible?

I have tested this and all working fine but needed to tweak a bit to get a better result as I also need to show the user that column2 should be left blank when column1 is not ‘3’, which means I have the following scenarios. Column1 is ‘3’ and column2 is empty – Error, invalid data input Column1 is 3 and column2 is NOT empty – All good Column1 is NOT ‘3’ and column2 is NOT empty – Error, invalid data input Column1 is NOT ‘3’ and column2 is empty – All good I have created 2 additional columns which checks above two columns with ‘if then else’: Column3 àif column1 is ‘3’ then assign 1 else 0 Column4 àif column2 is Not empty then assign 1 else 0 Another column (column5) which adds the above integers, which gives me 2,1and 0 Final column uses the ‘nested if then else’ which checks the column5 value to notify the user – 2 and 0 are good; invalid data input when the value is 1 Any feedback is welcome.

Great idea, certainly useful, Thank you Esteban!!

Thanks Esteban for the good idea. Only issue is a teacher can still ignore this and save the mark sheet without filling the column2 but I don't think we have any other choice like we do in a web application.

Hi Is it possible to force a user to fill in a column based on a specific value entered in another column, for example I have two columns in a mark sheet, allowed values on Column1 are 1, 2 and 3 when a teacher enters 1 or 2, column 2 can be left blank when a teacher enters 3 then teacher has to enter some value in the second column important thing here is, this need to be automatically triggered. Thanks in advance

I have created a report in AM to retrieve the incomplete mark sheets, this works fine for me (I have assessment coordinator role permission), but it only shows mark sheet name column when a year head run this report, this doesn't display the name of the teacher who the mark sheet belongs. I think this is something to do with the permissions but year heads are set up in Sims Pastoral structure and they can see all the mark sheets of the year group, so I am wondering why can't they see the teacher name column on the report. I don't think we have to give them Assessment coordinator role permission, which will give access to everything in AM. Any help will be much appreciated.

Am really grateful for your advice, theoretically I expected what you explained but I was hesitant to put this into practice, now I am confident to do the changes. Fortunately I haven't used this in any marks to grade formula. Have a great day.

Thanks for your advice, I have 100s of different aspects use this gradeset, will the aspects automatically pick up the grade set change? Fortunately I don't have any data inputted for current academic year for which we want to make the change. I am only worries about the data from previous years, will this become unusable?

I have been asked to change a grade set, actually remove a grade from it, I know this will affect the existing data but as long as we are not looking to change the past data I assume this can be done without any issue, please advise.

Thanks for the suggestions, at this moment I have bee deleting the targets but this is very time consuming, I will try your other suggestions.

Could anyone please give me some advice on how to hide/delete a row in a report, this can be done when nothing is filled for all the cells in the row but I want to be able to hide the row when compulsory fields are not filled in. For example, we record targets to students but some times when a student drop a subject student will get a row in the report as the target still there, so to hide I have to delete those targets, this is sometime very time consuming. Thanks in advance if anyone had a solution for this.

I just want to display a colour on the mark sheet cell instead of the grades, I know I can do this using a nested if construction, however there is property called PG Colour in grade set and wondering what is the use of this, I have assigned a colour for each grade and hoping this will show up but unfortunately this is not happening.. please can someone explain what is the use of this property, can't find anything in documentation. Thanks.