Reporting on Courses/ Classes

This guide will explain the possible reports you could create when using our custom report writer to create a report using the report focus of Courses/ Classes.

Courses/ Classes Specific Report Fields

• Course ID
• Course/ Class name
• Parent course
• Faculty
• Academic year
• Course leads
• Is bottom level course?
• Subject
• Year group

Permissions

Access to data in the Custom Report Writer is based on a user's permissions. This means you are able to regulate what data they can see in order to safeguard your students and staff. Certain types of data may be restricted for some staff members without the correct permissions. For example, if you are unable to view course details in the School > Programmes > Courses area of the system, you won't be able to see it on the Custom Report Writer. 

You can view the permissions needed to report on each thing in Arbor by going to School > Users & Security > Access Control > Permissions. 

If you need to give someone permission to create reports or report on certain items, you can follow these instructions.

Top Tip: You may find it easier to click 'Skip setup wizard' after choosing your report focus and title to head straight to the main Edit screen. 

Adding a Filter

If you would like to filter your report to look for specific course/ classes you can do so by scrolling down to the Filters section.

From the drop down, select the filter that you are interested in. For example, if you would like your report to only show courses/ classes that are part of a particular faculty, you could choose the Faculty filter.

Select Faculty from the drop-down, and then click the green Add filter button on the right-hand side.

Then you can set your filter parameters. For example, identify which faculty you are interested in. You can add more than one faculty if needed. Then click Save.

Adding a Grouping

If you would like to sort the data into groups, you can do this by adding a grouping to the report. 

Please be aware that when adding a grouping you may loose some of the contextual information and end up with just the number of items. 

For example, if you add a grouping of course leads to the report, you will see how many course each course leads has, but you would no longer see the detail of the course like parent course, faculty etc. 

You can see which data will no longer be displayed in the Report Columns section as it adds (Hidden - does not support groupings) after the column name.

To add a grouping, scroll down to Groupings. From the drop-down, select the grouping that you are interested in, for example, Course Leads. Then click on the green Add grouping  button.

Set the parameters, if required, and then click Save.

Adding a Collation

Collating a report allows you to collect results into different sections. This means when you download the report, you can choose how rows are grouped. 

For example, if your report is a list of all courses/ classes in your school, but you want the classes to appear on separate pages depending on the Year group that they are in when you print or download the report, you add a collation to do this. 

Collations are not compatible with groupings, so if you added a grouping, you will see a message stating "Sorry - you can't add a collation to this report, as your report is already grouped." you would need to delete your grouping using the bin icon. 

To add a collation, scroll down to Collations and then choose the relevant option from the drop-down menu, for example, Year group(s).

Click the green Add collation button. Set the date range in the slide-over and then click Save.

Once you are happy with your report, you can click on the green Save & View Report button. 

All Available Report Fields for Courses/ Classes Reports

To see a matrix of all available report fields and which report types they can be used with, please take a look at this article: What report fields can I use with each report type in the custom report writer?

• 10 years old Student Count
• 11 years old Student Count
• 12 years old Student Count
• 13 years old Student Count
• 14 years old Student Count
• 15 years old Student Count
• 16 years old Student Count
• 17 years old Student Count
• 18 years old Student Count
• 19 years old Student Count
• 2 years old Student Count
• 20 years old Student Count
• 3 years old Student Count
• 4 years old Student Count
• 5 years old Student Count
• 6 years old Student Count
• 7 years old Student Count
• 8 years old Student Count
• 9 years old Student Count
• Academic Year
• Achievement against school assessment measures
• Advanced Calculation/Formula Column
• Born in April Student Count
• Born in August Student Count
• Born in Autumn Student Count
• Born in December Student Count
• Born in February Student Count
• Born in January Student Count
• Born in July Student Count
• Born in June Student Count
• Born in March Student Count
• Born in May Student Count
• Born in November Student Count
• Born in October Student Count
• Born in September Student Count
• Born in Spring Student Count
• Born in Summer Student Count
• Compulsory School Age (5 - 15) Student Count
• Count of Female Students
• Count of Male Students
• Course ID
• Course Leads
• Course/Class Name
• Disadvantaged (Ofsted 2023) Student Count
• Disadvantaged Student Count
• EAL Student Count
• Ever 6 FSM Student Count
• Ever 6 Service Child Student Count
• EYPP Recipient Student Count
• Faculty
• FSM Student Count
• Gifted + Talented Student Count
• Gifted Student Count
• Gypsy / Roma / Traveller Student Count
• Has Key Worker Guardian Student Count
• In Year Admission Student Count
• Is bottom level course?
• Looked After (In Care) Student Count
• Mobile (Y10 & Y11) Student Count
• Mobile (Y5 & Y6) Student Count
• Number of Enrolled Students
• Out Of Age Group Cohort Student Count
• Parent Course
• Pupil Premium Eligible Student Count
• Pupil Premium Recipient Student Count
• SEN Student Count
• Service Child Student Count
• Subject
• Talented Student Count
• Total Detentions
• Year Group
• Young Carer Student Count