Creating a report of students' locations for each class

You can now produce a report in the Custom Report Writer that shows the location of every student in each period, for the whole day. And it takes just 5 minutes, with no downloads, v-lookups or manual messing about with data!

We've designed these Custom Report Writer fields based on feedback from our schools that they need to produce a list of year 9 girls, including where they are for periods 1, 2 and 3 to take them out of lessons for their immunisation jabs. This is the example we'll use in this article, but you can use these new fields to report any way you wish!

Please note: For this report to work, you will need to have set up periods on your site. Take a look at this article on Creating Timetable Periods for how to do this.

 

Example - creating an immunisations report

Just go to School > Custom Report Writer and click the Create New Report buttons to get started!

First, add your report name and specify that the report is about students.

Next, select the date range of your report. In my example, I'm choosing a specific date but you could also set this to 'today'. 

Screen_Shot_2020-03-04_at_11.29.45.png

 

In step 3, search for the word 'timetable' in the search box and click and drag the Timetabled event field over to the right-hand side.

Screen_Shot_2020-03-04_at_11.31.55.png

 

In the slide over, select period 1, then click Save.

Screen_Shot_2020-03-04_at_11.37.36.png

 

Next, drag the Timetabled location field over to the right-hand side. In the slide over, select period 1, then click Save

Screen_Shot_2020-03-04_at_11.38.01.png

 

You'll then need to repeat this for the other periods you would also like to show, for example, period 2 and 3 as well.

We then recommend clicking the Skip setup wizard link at the bottom of the page. This will take you to your report editing overview.

Screen_Shot_2020-03-04_at_11.40.42.png

 

In the Filters section, type in NC year 9, select it, then click Add Filter.

Screen_Shot_2020-03-04_at_11.45.09.png

 

In the slide over, click Save without changing the details.

Screen_Shot_2020-03-04_at_11.46.01.png

 

Next, add another filter for Gender, and in the slide over select Female.

Screen_Shot_2020-03-04_at_11.47.06.png

 

Finally, click the Save and View Report button to see your report.

Screen_Shot_2020-03-04_at_11.49.04.png

 

Top Tip: Want to sort students by the class they're in so all students in the same class are grouped together? Just click the column header!

Screen_Shot_2020-03-04_at_11.50.24.png

 

0 out of 0 found this helpful
I'm still stuck!

Comments

0 comments

Please sign in to leave a comment.