There are various reports you can use in order to obtain student ages and their birth dates.
Student birthdays
Go to Reporting > Reports > Students (Tab) > Birthdays report.
Enter a date range, and this report will display all students with a birthday in that given period, as well as the age they will be on their birthday.
You can use the Quick dates to select a date range or the date pickers. You can also specify group or form, such as current, former or future students.
- Click the column headers to sort the data by that column (alphabetically, numerically or chronologically, according to the data). If holding Shift you may apply this function to further columns.
- Click the Bin icon (above column header) to delete a column.
- Use the filter box (text entry field below column header) to filter the data using specific criteria in that category. Click into a filter box then hover over it with your mouse for a full list of operators that can be used.
If you want to check which students are going to be a certain age ( e.g. 5 years old), enter that figure in the New Age column and press return. This filters the report to display only those who will be 5 years in the period of time selected.
- Exporting your data allows you to print, save, or further edit the information on screen. To do so, click this icon (in the top-right corner):
- Names highlighted in red represent the students who are no longer on roll
- The star on the report identifies a Favourite report. Click on the star to add or remove it from the Favourites area of the reports panel.
Student ages in years and months
Go to Reporting > Reports > students (tab) > Date of Birth.
This report allows you to view all the students within a year or form with a date of birth between a selected date range. It will display the student's current age in years together with address details, their contact 1 telephone number and their birthday plus their year and form.
You are able to filter by group and form and have the option to show current, former and future students.
- Group (this includes year groups, key stages, dynamic and static groups and any set intervention groups)
- Forms choose from pastoral groups
- There is the option to include or exclude current, former and future students (by default the report will only show students who are on roll)
- select your 'born between' range (this will only students with a birth date within your chosen date range)
Simply click on the column header to order the data or select the bin icon to remove the column.
To filter this data further each column header will have a white text entry field where you can produce data only relating to that value, for example if you type 2 in the text box under the Year column, only Year 2 pupils will be displayed.
The information displayed can be exported as either a Word, Excel or PDF document by clicking on the yellow download arrow on the top right of the screen.
You can choose to display the report as either landscape or portrait.
- Clicking on the student's surname will take you to their individual profile page.
- Names which are highlighted in red represent the students who are no longer on roll.
- The star on the report icon identifies a 'favourite' report. If starred this will appear in your favourites area.
Student exact ages
Go to Reporting > Reports > Students (tab) > Student Ages.
The student ages report displays the students age to date in: years, months and days. you also have the option to show the age of a student on a specific date by using the date picker. The report will show current age and age on the date selected. At the bottom of the report when produced, an aggregate number will be shown representing the students returned after your query.
When you access this report you will have the following filters; year, form, dynamic and static groups and the option to include former students (by default the report will only show students who are on roll).
Click Choose to produce your report based on these filters:
- Group (this includes Year groups, Key Stages, and all your Dynamic and Static groups)
Forms (all form groups) - option to Include former students (by default the report will only show students who are on roll)
- option to Show only future students (showing all students with a future start date)
- option to Show Current Students (showing all current students)
The report will be produced in a tabular format displaying columns relating to the report title. Simply click on the column header to order the data or select the bin icon to remove the column. To filter this data further, each column header will have a text entry field where you can produce data only relating to that value.
Exporting your data allows you to print, save, or further edit the information on screen. To do so, click this icon (in the top-right corner).
- Clicking on the student's name will take you to their individual profile.
- Names which are highlighted in red represent the students who are no longer on roll.
- The star on the report identifies a 'favourite' report. Click the star to toggle yes or no.
Including student UPNs in a birth date or age report
Go to Reporting > Custom Report
Select New Report. Then, on the right side, Dates tab, select Age in Years and Exact Age, then run the report.
You will automatically get student UPN, Name, Form, Year as well as columns for the Date of Birth, Exact Age and Age in Years.