DFE FSM Ever 6 Report for 2021/22

To download the report file, click here : FSM EVER 6 – Secondary FSM EVER 6 – Primary Please note that these reports can only be an approximation of FSM Ever6 as used by the DfE for allocating Deprivation Pupil Premium. For example, the DfE knows the YTI reported for pupils in School Census when…

Report to generate classes and teachers

To generate this report, please go to: -Reports > Design Report > Create a new report -Select “Student” and then “on roll” -On the select data fields screen, select “Classes” (blue sub report), then select Class Name, Class Teacher, Students (blue sub report) First Name, surname.  Your previewed report will look like this:   Reviewed…

Percentage Attendance in Discover is different to Attendance Reports

Percentage Attendance figures produced by a Discover Percentage Attendance Graph are different when compared with the figures produced by an Attendance / Lesson Monitor report.   This is due to the way that Discover calculates attendance figures as an average, therefore the data will not always match. The differences are because the Discover graphs and…

Change from Gifted & Talented to More Able and Talented

Following the Sims Summer 2019 upgrade, changes have been made to the Reporting Dictionary Report | Design Reports and the Additional Student Columns in Assessment and Attendance.  The fields previously referred to as Gifted & Talented have been changed to More Able and Talented.  Reviewed 27/7/20  

How do I add reports to the favourites panel on the SIMS homepage?

There are two ways to get your favourite report(s) to show on the SIMS homepage favourites panel. Option 1 Reports > Design Reports > Open Existing Report > right click over the report you want to add and select Add to favourites. Option 2 Reports > Run reports > locate the report from the report…

Running The School Report

What is the SIMS School Report and how can you access it? The School Report provides an instant overview of your school based on the latest data held in SIMS, giving school leadership and governors insight into areas of strength and weakness to inform their decisions. The report can be exported in a number of…

How can I see all InTouch messages that have been sent and received?

There are two ways that this information can be viewed. The first is through Focus/In Touch/Show Messages. This displays an Inbox and Sent box. However, an easier and more beneficial way to see this information is by running an InTouch report. Please go to Reports/InTouch/Messaging Audit. This report provides details of all messages sent to,…

* Updated 8th July 2019* Primary School SIP (School Improvement Programme) Statutory Key Stage Analysis Resources

(Updated 7th July 2019) Capita have developed a series of reports to assist primary school leaders, governors and any other relevant stake holders to analyse statutory Key Stage data in line with the DfE Primary Accountability Measures 2018 updated September 2018 and Provisional 2018 National Figures from Statistics at DfE – Department for Education. These…

Adding new group to System Manager

This example is for enabling scheduled reports. Go to Focus>System Manager>Manage Groups – Click on New Section 1 – enter a Code and Description eg RepSched and Report Scheduler Section 2 – click the green + to add the required users Section 3 – click on the + to expand Core System>Core>Home Page>Report Execution Manager>execute Scheduled…

Pupil Premium Report

Please find a report to show all current pupil premium pupils below. This report is based on the tick box within ‘Additional Information’ within the student records. Pupil Premium To import the report, download and save this file in a location you can get to from within SIMS make sure you unzip the file when…

Making Private Reports Public

If you have previously created a report within SIMS and made it private but would now like to make it public, you will need to do the following. 1 – Go to Reports – Design Report – Open Existing Report   2 – Open up the Private Report that you want to make public. Click Save…

Individual Session Summary Report – Print more than one student on one page

The Individual Session Summary Report (Reports/Attendance/Individual Pupil Reports/Individual Session Summary Report) will only display one student’s attendance details per page.  Unfortunately it is not possible to change this. As a workaround, please follow the instructions below: Open File Manager Choose a destination (Eg: F:/Public/Updates) Right click on the white background and select New/Microsoft Word Document. …

Colour in Sims Assessment – Individual Reports

When adding colours within a cell in a marksheet, (right clicking on the cell “Select colour to a cell”)  the colour will NOT pull into individual reports.  If you want the colour to pull into an individual report along with the result, it will need to be coloured using a Nested If Then Else formula…

Identifying addresses modified by CTF import bug

The report can be downloaded by clicking below, please save as to a suitable location, and extract the file so that it shows in your File Explorer as Address change history.rptdef, ready for import into SIMS. Address change history report.zip download For instructions on how to import a report into SIMS, please see the in-depth…

Report for Behaviour/Achievement points over a date range

Current functionality in SIMS makes this almost near impossible or extremely complex to make, so that you can run a report for behaviour/achievement conduct points over a date range. You can download the report definition file below and import into SIMS (Reports > Import), which has made this possible:   Conduct Net points over date…

Exporting a SIMS report as a CSV (comma separated) file

There are two ways to create a CSV file from a report, this is usually to import or send the file where it is imported into third party software. After creating the report, on the ‘Default output’ screen at the end of the report, select the Text option under Presentation, in the Format box selected…

Reporting on users SIMS permissions

It is not possible to report on users SIMS permissions groups in the normal reporting/design report area of SIMS, however there is a workaround as below: Go to Focus > System Manager > Manage Users. Click Search. The Print button will become live, click Print and choose the option to Export to a web browser….

Report for students who live with both parents/only live with one parent

A report to show students who live with both parents or either parent is becoming a common request due to a freedom of information request going around. There is no simple way to produce this report however there is a rptdef (Report Definition File) that can be imported into SIMS under Reports > Import and…

Reporting on open contracts in SIMS

Occasionally when reporting on Peronnel and Contracts within SIMS, it will display a closed contract for the member of staff. There is no specific option within the Reporting module to only make the open contracts show, you will need to filter the workaround as follows: Expand the ‘Employment Details‘ section and pick the blue ‘Contracts‘…

Exams – Component Clash Analysis Report Not Showing All Clashes

There are 3 reasons why a clash would not show on a Component Clash Analysis Report 1   The Award has not been attached to a Course. You can check this by right clicking on the Award and select Properties, is the correct course showing in the Course field?  If not go into Course Manager, select…

How To Bulk Update Result Sets in Individual Reports (AM7)

*Please back up your templates before you make any changes as tags can break very easily* With your Word template open, you need to click on reveal codes by clicking on the pilcrow symbol – ¶ which is under the “home” Screen.  This reveals punctuation, paragraph markers / hidden formatting.  If that doesn’t work try…

Profiles – splitting on two pages

To avoid tabled report comments splitting across the page.  Within the Word template; Select the paragraph or section of text you want to keep together. On the Home tab in Word 2010 or Word 2007, click the Paragraph group’s dialog launcher (the small arrow at the bottom-right. In Word 2003 (and earlier), choose Paragraph from…

Students Profiles are not being generated when I click the generate button

This issue can arise because there are illegal characters ( \ / : * ? ” < > | ) in the session name for which you are generating.  The issue can also occur if there is a problem with the template. Rename the session removing any illegal characters.  Also run the ‘Verify Template’ routine…

Troubleshooting KS5 16-18 Performance Tables Report

Students at End of KS5 Measure Detail All    % Male    % Female    % KS5 Cohort Information A levels Students at end of KS5 66 100.00 32 48.48 34 51.52 Number of A Level students at end of KS5 66 100.00 32 100.00 34 100.00 Number of A Level full time equivalent students…

How to add date range to SEN report

In the fields section expand the +SEN option then choose the Special Needs sub report – this is at the bottom and not the same as the SEN Needs at the top. Once this is active the Start date and/or End dates may be chosen and used in the filter definitions.   Reviewed – 19/03/2018