Looking for advice. Have been asked by a Pupil referral unit school to create marksheets to monitor behaviour in every lesson.

Each student is given a behaviour grade each lesson. This is then averaged on a weekly/termly/yearly basis.

Currently have a marksheet setup in the MIS RM Integris. This has been working but now would like to link this to the timetable to produce report on subject classes.

The columns work something like this:

[TABLE=width: 711]

[TR]

[TD][/TD]

[TD]Mon1[/TD]

[TD]Mon2[/TD]

[TD]Mon3[/TD]

[TD]Mon4[/TD]

[TD]Mon5[/TD]

[TD]Tues1[/TD]

[TD]Tues2[/TD]

[TD]Tues3[/TD]

[TD]Tues4[/TD]

[TD]Tues5[/TD]

[/TR]

[TR]

[TD]Joe Bloggs [/TD]

[TD]3[/TD]

[TD]2[/TD]

[TD]2[/TD]

[TD]3[/TD]

[TD]1[/TD]

[TD]1[/TD]

[TD]2[/TD]

[TD]3[/TD]

[TD]4[/TD]

[TD]3[/TD]

[/TR]

[/TABLE]

etc.

This involves a separate marksheet for each week of the school year. plus different marksheet for different years.

As you can imagine I'm running into hundreds of marksheets which is becoming too difficult to manage.

My trouble is although I know Joe Bloggs' timetable, how can I say what his behaviour averages are for each subject without a lot of manual work.

I'm thinking there must be a software package out there that could do this all for me, plus have extensive reporting.

Would a package like Sleuth or Behaviour watch be able to manage input values for each student in every lesson for the whole year?

We are using the behaviour module in integris to log behaviour incidents this behaviour monitoring is separate.

Does anyone have any suggestions how to manage this better?

All advice welcome and good advice appreciated.

Thanks