Completing the daily DfE Educational Settings form

To support schools in completing the daily DfE Educational Settings form we have put together a SIMS report that brings together the key student data in a simple to read table. Running this report should reduce the time required to complete the Educational Settings form.   Please follow the instructions in the setting up guide…

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  

Where can I find the SPS Safety Reports?

Capita have recently released a new suite of reports called the SPS Safety Reports. The SPS Safety Reports are a suite of reports which simply imports into SIMS and will allow detailed analysis on any key group, subject, class and individual for attendance, behaviour, achievements, staff absence and homework. For both primary and secondary schools….

* 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…

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. …

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….

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‘…

Teacher salary statements in HCSS budgeting / FPS

Within HCSS budgeting, you may be asked to produce teacher salary statements. To do this, log into the HCSS web portal here: https://www.hcss-web.co.uk/login and load your budget/scenario. After doing this, go to: Scenario > Reporting Module > Pupil/Staff Reports > Teacher salary assessment You can then choose whether you would like to do this for…

Deleting SIMS Reports created by another user.

As you know, when a user creates a report within SIMS, only that user can amend or delete the report. Other users can use this as a base for their own report but the original report remains in effect. Therefore when a person leaves or changes role, their reports were orphaned within SIMS in previous…

‘Error: Could not open macro storage.’ when running a SIMS report

‘Error: Could not open macro storage.’ when running a report via Reports > Run Report.     The cause of this problem was a Microsoft Word File Block Setting. To resolve this you will need to open Microsoft Word and click on File -> Options. On this screen select Trust Centre -> File Block Settings….

Unable to format dates in Excel reports

To format the date in the report as required after export to excel, please follow the below mentioned steps: Select the column with the dates in the Excel spreadsheet. Select Data tab on the menu bar and click the button that says ‘Text to Columns’. A wizard will now appear. Select ‘Delimited’ in Step 1 click ‘Next’,…

Exporting Attendance or Lesson Monitor reports to Excel

The inbuilt Attendance and Lesson Monitor reports are designed to output to a web browser such as Internet Explorer. It is possible to export the data from the web browser to Microsoft Excel. After running your report it will open a new window and you will see your information. If you right click on the…

Report output exceeds maximum width

Error: This exceeds the maximum width when running a report in SIMS.     This is because the report is running as a Word List Report. It would need to be changed to a Form Report (RTF)  output on the Define Presentations screen. Ensure that Form Report (RTF) is selected. Sometimes it will show as…

Staff Data Collection Sheet Report

This report uses all of the non-confidential School Workforce Census fields within SIMS and should be sent out to all staff in September of each year, in order to get all your data accurate and updated in time for the SWC in November. You can download this report by clicking here. 1.  Save the Scomis Staff…