curlo9597

Hi, am assuming that you don't want this extra lesson to appear on student and teacher timetables but need it for registering the students who turn up to this extra lesson? If so, you could add a new subject and create a block in the model screen. Add the classes to the block and assign 0 lessons. You can create a derived block if you want to mix the classes up or set up blocks in each year group. Then assign staff in the Classes screen and send across to SIMS via SQL. The classes will then be available in the Curriculum Assignment by Scheme screen and the students can be assigned. These classes will not appear on student or staff timetables but can be found in Take Register if this is what you want to do. I hope this helps anyway.

You have two possible options to try. Use the Analysis output within the report design and once the report is generated you can select various row and column combinations to hopefully provide what is required (this can then be exported to Excel once you are happy with it). A more complex solution would be to use an excel template that uses Macros to automatically output the data into a pivot table and can be configured accordingly so it will give you the desired report. It may be worth trying the Analysis output option first and if that doesn't work an Excel template would definitely work for you in this instance.