[sims] Sims.net - Achievements and Behavior Report

[naysweb]

Hi,

 

We need a report in excel from Sims.net that displays like the below...

 

Need the total for the school year "Achievements" - "Behavior" = Total Points

 

First Name, Last Name, Tutor Group, Year, Achievements Points Total, Behavior Points Total, Achievements - Behavior Total

 

e.g

 

John,Bloggs, NE, Y11, 20, 15, 5

Jane,Doe,JW,Y7,50,12,38

 

Hope someone can help, Please ask for more information if needed.

 

Thanks in advance.

[Kyle]

Are you saying you want someone to compose one for you or to tell you how?

[naysweb]

Hi Kyle

 

Compose one if possible and export it so i can import it.

 

Have tried to use the "built-in" reports but don't give the "Achievements" - "Behavior" = Total Points.

 

Thanks for the quick reply....

[Kyle]

I can get you the report to show total points in a date range but have no idea how to - the achievement from the behaviour.

 

Is this any good?

[BKGarry]

I can do this, there is a section called Conduct, which does the Total Behaviour, Total Achievement and Then Total conduct (achievement - behaviour)

 

If you want an export give me a shout, but I think it is their entire school life not by year.

 

I could probably do Behaviour Incidents and Achievement Incidents (not points) filtered and use a custom excel layout to do the rest, but I have never tried that before

[naysweb]

Thank you for all your reply's.

I have made the report using conduct points..

 

Attached the report for anyone else.

Dropbox Link