Capita (SIMS)

Capita

 

The MIS Challenge – Community Response for Capita SIMS.

PLEASE NOTE: This response has been compiled by several independent sources that are NOT Capita. Capita refused to complete the survey, but it was felt that a response showing the capabilities of SIMS was necessary for the whole project. Capita neither endorse, confirm, deny or have anything to do with this response; answers have been sourced by experts in the industry and by current and former SIMS customers. No responsibility is taken by the Eduware Network, Graham Reed or any of the professionals who have completed this survey for the total accuracy and cannot be held responsible for any action or inaction taken as a result of reading this survey response.

Note too that all answers represent the current public knowledge of SIMS 7 as of July 2014 (Summer 2014 release 2)

Should Capita wish to add or amend any responses, please contact the Eduware Network and amendments will be actioned.

Section 1: Product Services
Data Policies
Is you solution’s database stored locally in the school, hosted offsite by the local authority or hosted offsite in your own/leased servers/data centres? Please state which if multiple options are available. SIMS is hosted locally on school site or remotely on Local Authority or Capita Servers (Connection to remote services is made via RDP or similar technology).
Which method is most advantageous for schools and why? Whilst a subjective question, SIMS hosted by an LA or by Capita has the advantage of being managed at a technical level, for updates, backups, maintenance, disaster recovery, etc. Server hardware and software is also catered for. On the whole it usually offers better value for money than a locally hosted solution, but an individual cost analysis should be considered before proceeding.
If your solution’s database is hosted offsite, is this hosting on dedicated servers or is it hosted in the cloud (i.e. using distributed servers using services such as Amazon Cloud)? Hosted on Local Authority data centres or on Capita data centres, using dedicated servers (not in ‘the cloud’).
Assuming you follow all Data Protection policies, where is the ECC is the data stored? Do you make this information available to your customers/are they actively aware? Could you prove this if questioned by customers/partners/Information Commissioner? (If data is stored outside the UK, but in the ECC, of course this still complies with the DPA, so feel free to reinforce this in your answer and help dispel any remaining myths that data MUST be stored within the UK). Data stored within the UK if using the hosted solution. If hosted by your Local Authority, contact them for specific details.
Is your solution security audited by an external third party (Yes or No) and how frequently does this occur (every release, every year)? Each release is submitted to a penetration (PEN) test by an external third party.
How do you deal with security vulnerabilities? For example do you do specific security patches or are they bundled into main releases. If you use underlying technology such as Java or .NET how do you notified customers of security patches. Do you provide public information – such as reference to CVS ratings (http://cve.mitre.org/about/index.html) Security patches are released as required either with regular update bundles or ad-hoc as required. If on a hosted environment, such updates are provided for schools (by Capita or the LA). If locally hosted, patches are downloaded by SOLUS (SIMS OnLine Update Service) and customers must update their own instance of SIMS.
What are the estimated timescales for patch\release rollout, and how much effect is required by the school or LA to update the system? Updates are scheduled 3 times a year. If on a hosted environment, such updates are provided for schools (by Capita or the LA). If locally hosted, patches are downloaded by SOLUS (SIMS OnLine Update Service) and customers must update their own instance of SIMS.
Are you registered with the Information Commissioner? Yes.
If you do host services in any form, what back-up procedures do you employ? [Unable to respond accurately]
If you do host services in any form, what disaster recovery precautions do you employ? [Unable to respond accurately]
Please state you minimum server specification and setup (if multiple servers are recommended) to support a single school of 1000 students and 150 staff. This would be deemed a secondary school. See – http://www.capita-sims.co.uk/files/sims/downloads/min_system_reqs.pdfGuide: Quad core, 12GB RAM, Windows Server 2012 R2, MS SQL 2012 Standard.
Please state you minimum server specification and setup (if multiple servers are recommended) to support a single school of 300 students and 30 staff. This would be deemed a primary school. See – http://www.capita-sims.co.uk/files/sims/downloads/min_system_reqs.pdfGuide: Quad core, 8GB RAM, Windows Server 2012 R2, MS SQL 2012 Express/Standard.
Please describe how your solution’s database is updated including any supporting applications, services or user intervention required. If on a hosted environment, such updates are provided for schools (by Capita or the LA). If locally hosted, patches are downloaded by SOLUS (SIMS OnLine Update Service) and customers must update their own instance of SIMS.
Markets
Which markets do you have customers in? Markets are Primary, Secondary, Independent, International British, International Other (Academies, Free Schools and other divisions should be included appropriately with the states groups). Primary, Secondary, Independent, International (all), Academies, Free Schools, UTCs, PRUs, Studio Schools.
Which markets do you typically target? Markets are Primary, Secondary, Independent, International British, International Other (Academies, Free Schools and other divisions should be included appropriately with the states groups). Note that this question is not designed to limit your audience but describe if your software is specific to a subsection of schools. Please be honest if, for example, you software is currently designed for Independent schools, but also mention if you are now or soon developing for other markets too. Primary, Secondary, Independent, International (all), Academies, Free Schools, UTCs, PRUs, Studio Schools.
Database Structure
What back end database technology can be used with you solution (MS-SQL, MySQL, Oracle, etc.)? MS-SQL.
Does your data structure comply with any ISB (Information Standards Board) standards? Please use one example if Yes. [Unable to respond accurately]
Is you data structure compatible with any SIF objects, or do you have a SIF agent? Please use one example if Yes. Yes.
Client/User Interface
Is your solution presented via a dedicated application or through web browser? Application
If you employ a browser interface, what browsers are supported currently? N/A.
If you employ a browser interface, does you solution employ HTML5? N/A.
Does your solution require any players or stud applications to support functionality (i.e. Flash Player, .Net Framework)? .NET Framework. In addition, players such as Adobe Reader required for reports.All needs Microsoft Office.see: http://www.capita-sims.co.uk/files/sims/downloads/min_system_reqs.pdf
Please state the Operating Systems (including versions) you solution supports. Windows 7 onwards.
Please state you minimum system requirements.
Please describe how your solution’s user interface is updated including any supporting applications, services or user intervention required. SIMS client is updated using SOLUS. Updates are applied centrally and the client checks for updates at each startup.
Updates, enhancements, fixes, new features and general support
What is your typical release schedule? 3 times a year, in line with Census releases.
How many staff do you employ per customer (as a ratio) on your helpdesk? [Unable to respond accurately].
Where is your helpdesk located (in the UK or outside the UK)? UK
What are your support hours? 08:00 to 17:30 Monday – Friday, excluding bank holidays.
Do you have an online helpdesk? Yes, SupportNet.
Do you employ a live online helpdesk/chat facility to support customers? No.
What support models do you employ (for example, direct to school, via LA, via third party support) Direct to Schools, Via Support Teams (such as LAs).
What is your method for reporting a bug or issue? Via telephone support or using SupportNet.
What is your typical SLA timescales for issues of all seriousness? [Unable to respond accurately].
What is your method for requesting an enhancement or change? Change Request via SupportNet.
How do you engage with the market for new features and what sectors or bodies influence how and what is implemented? Strategy groups meet to discuss all major functional areas. A separate group advises on Independent school needs. Regularly meet with ASCL for senior leader input.
Do you publish your 12 month (or more) roadmap? Please share this as part of your response (if you do). Yes, available on SupportNet (Closed to SIMS customers only).
Data Integration
Do you have an API? Yes.
Describe how this works. For example, does it employ web services? [Unable to respond accurately].
Does it cover all the basic aspects for your solution (Pupil details, contact details, relationships, staff details, attendance, behaviour, markbooks, and timetable?) Please state which if only part covers, or covers more aspects. Yes.
Does your API allow write back? Please state which data elements can be written back. Yes.
If this API free to access? If there is any aspect of using the API that you charge schools or third parties for, please state. This includes charging for write back, charging for sandbox or test environment use, requirement to pay for a licence of the software (but does not include charges for consultancy or support of the software or API). Free for Read Access. Charged for Write Access (on a scale for increasing access to the database).
Does your solution use any other form of open standard integration or technology? CTF & VLE Service.
Does your solution integrate in any way with popular cloud services such as Google Apps or Microsoft Office 365? No.
Legislative Requirements
For the following questions, it is expected that your solution will provide any census or other exports stated in the defined file type and structure requested by the DfE or Awarding Organisations (An Excel export requiring user intervention for example is not acceptable as a yes answer)
Does you solution, either internally or through a third party interface, produce the School Census? Yes, Internally.
Does you solution, either internally or through a third party interface, produce the Staff Workforce Census? Yes, Internally.
Does you solution, either internally or through a third party interface, produce the Independent Census? Yes, Internally.
Does you solution, either internally or through a third party interface, produce the Key Stage Assessment Returns? Yes, Internally.
Does you solution, either internally or through a third party interface, produce the CTF File? Yes, Internally.
Does you solution, either internally or through a third party interface, produce Exam Entries and other files in EDF compatible files? Are you working towards the A2C standard? Yes, Internally. Working towards the A2C Project.
Section 2: Software Characteristics
Core Pupil Database (Real time alerting)
Does your solution store pupil basic/demographic/personal information? Yes.
Does your solution contain all statutory fields required for School Census? Yes.
Does your solution have any real-time alerting to inform staff of changes in any aspect of ongoing observation? Yes.
Does your solution archive past student records? How far back can a student record be recovered/reviewed? Yes. All of History.
Does your solution accept the latest CTF import? Yes.
Does your solution accept the latest ATF import? Yes.
Pupil Attendance
Does your solution record AM/PM (Statutory) attendance? Yes.
Does your solution record lesson by lesson attendance? Yes.
Does your solution alert to patterns of absence or patterns of students consistently absent? Please elaborate if yes. Yes.
Does your solution record the number of minutes late? Yes.
Does your solution allow the storage of absence notes? Yes.
Does your solution connect with messaging systems to alert absence to parents? Yes.
Does your solution record responses through such a system, if yes? Yes.
Can a teacher see their class absences for a whole term? A whole year? Yes.
Can a school administrator see a student statutory attendance record for a whole term? A whole year? Yes.
Can a school administrator see a class/form/year group statutory attendance record for a whole term? A whole year? Yes.
Can the system report back to the Local Authority system, such as to ONE via B2B OPEN? Yes.
Pupil Behaviour
Does you solution record behaviour incidents? Yes.
Does you solution record positive achievement events? Yes.
Does you solution record conduct points (positive/negative)? Yes.
Does you solution record exclusions? Yes.
Does you solution report exclusions to the local authority where necessary? Yes.
Can your solution record evidence for incidents (and achievements) such as photos, videos, audio recordings, documents etc? Yes.
SEN
Does your solution record SEN data? Yes.
Does your solution maintain SEN records in a workflow to ensure date sensitive information is acquired in a timely fashion? No.
Does your solution maintain an IEP within the software (that is, not on Word documents)? Yes.
Document Storage/Content Management/Discovery
Does your solution store documents against student records? Yes.
Does your solution store documents against staff records? Yes.
Does your solution store documents in internal but public locations (for example, on a notice board facility)? No.
Does your solution have facility to make documents private to an individual or group of individuals? Yes.
What file types can your solution store? Common Office File Types.
Are documents stored within the database itself or on a generic file store outside the database (Note that this is specifically the files and the back end database, not the interface)? Within a file store outside the database.
Does your solution provide interfaces to external content, such as education resources, eBooks, etc? No.
If so, is this content searchable? N/A.
Markbooks
Does your solution contain a markbook style facility? Yes.
Does your facility require the creation of each class markbook each year, as a manual or semi-automated process, or are markbooks provides for each class regardless based on a pre-defined template? Briefly elaborate on the process. This is a free answer. Markbook creation required each year.
Can teachers create their own markbook columns? No.
Can homework be set and associated with a markbook column? Yes.
Can online tests be set and associated with a markbook column? No.
Can comment banks be used on markbook columns (or you have another facilities where comment banks are used, often for parental reporting, then this is an acceptable answer)? Yes.
Can formulae be placed into markbook cells to make calculations on other cells? Yes.
Can conditional formatting be placed into markbook cells? Yes.
Can gradesets or other value limiting mechanism be used on markbook cells? Yes.
Can averages and other summary calculation be made on columns or rows in the markbook? Yes.
Does your solution have any built in parameters for measuring progress against targets, assessments etc? Yes.
Assessment
Does your solution record statutory (non GCSE) assessment such as Key Stage assessments? Yes.
Are these assessments recorded in the main markbook or elsewhere? Within the main markbook.
Does your solution record baseline assessment such as FFT or MIDYIS assessments/results? Please list all baseline assessments available to be imported. Yes.
Are these assessments recorded in the main markbook or elsewhere? Within the main markbook.
Please briefly describe the import process for any of the above. This is a free answer. Import from spreadsheet.
Does your solution contain progress tracking or other analysis on these assessments? Yes.
Early Years Assessment
Does your solution provide assessment templates and features for Early Years assessment and the Foundation Stage Profiling? Yes.
Does this assessment facility show levels of progress against criteria based on age group? If not, but does provide other analysis, please briefly describe. This is a free answer, but please keep to brief features. Yes.
Does your solution provide for the Early Years statutory return? Yes.
Progress Tracking
Please detail what progress measures can be tracked within your system. This is a free answer but please list the measures. Marksheets support formula from which any tracking can be managed.
Does your solution have any alerting mechanism to inform staff of changes? Yes.
Exams Management
Does your solution record exams (by this, GCSE/A Level)? Yes.
Does your solution import basedata from Awarding Organisations? Yes.
Does your solution send Entry and Amendment files in the EDF format? Yes.
Does your solution accept Results files? Yes.
Does your solution facilitate seating charts? Yes.
Does your solution facilitate exam timetables, for both students and rooms/exams? Yes.
Does your solution alert to exam clashes? Yes.
Is your solution being converted to the new A2C protocols in preparation for the A2C switchover? Yes.
Multi-Tenancy/Multi-School
Is your solution a multi-school solution? By this, can multiple schools access the one solution, each with their own protected information set, but able to still share data or resources? No, but Partnership Xchange \ MultiView partially allows this.
If yes, does your solution contain a multi-school interface, particularly useful for academy chains to view and analyse cross school/trust wide information. Yes. SIMS MultiView
Admissions Management/Online Admissions
Does your solution provide admissions management? Yes.
Does your solution provide enquiry management? Yes.
Does your solution provide facilities to manage waiting lists and priorities on enrolments? Yes.
Does your solution provide facilities for entering entry test results? No.
Does your solution provide facilities for recording enrolment fees? Yes.
Does your solution provide Fees management facilities? This would be associated with billing. Yes.
Lesson Planning/Curriculum Planning
Does your solution contain any form of curriculum planner? (This being a facility to manage the content of lessons over a term or year). Yes.
Does your solution contain any form of lesson planner? (This being a facility to create and manage a plan for a lesson, with content, resources, outcomes planned, homework assignments, individualised learning styles etc.). No.
Is this facility integrated or able to integrate with the markbook, if available? No.
Timetable/Curriculum Structure
Does your solution contain a timetable creation facility? Yes.
Is this facility integrated with your solution? (Integrated means data is not synchronised or sent back and forth). If not, briefly describe the data movement process. No. Via Nova-T
Does your solution manage ‘Options’? Yes.
Are option ‘Choices’ able to be entered by students/parents online? No.
Does the options facility directly integrate with the timetable creation facility? (Integrated means data is not synchronised or sent back and forth). If not, briefly describe the data movement process. No.
Does the timetable facility:
         Incorporate student data Yes.
         Incorporate staff data Yes.
         Allow rules to be set on student/staff availability, student/student in the same classes, student/staff in the same classes, lesson blocking, and lesson pattern structure? Are these rules customisable? Yes.
         Allow multiple timetables to be created Yes.
         View room and staff utilisation Yes.
         View class sizes Yes.
Can your solution have different timetables, even different day structures, for different year groups? Yes. School tiers are supported allowing separate timetable structures to be applied. Staff are assigned to one or more tiers.
When the timetable structure is built, do students have to be manually added to classes or is this already does (because student data have been incorporated into the timetable creation). Yes.
Are student/staff timetables available online? Yes (via SLG).
Are student/staff timetables available to print? Yes.
Can your timetable solution take multiple schools into account (that is, is a student or staff attends a second or more schools for part of their week, can time timetable incorporate this) No.
Portals:
Pupil Portal
Does your solution contain a specific student portal? If so, what information is available to a student? Yes via SIMS Learning Gateway.  Timetable, Achievements, Homework & Assessments
What security is provided to protect data? Usernames/Passwords. Server Security.
Can student amend or request an amendment to their personal details? No.
Parent Portal
Does your solution contain a specific parent portal? If so, what information is available to a parent? Yes, Sims Learning Gateway (SLG).
What security is provided to protect data? Usernames/Passwords. Server Security.
Can parents amend or request an amendment to their/their children’s personal details? Yes. Data collection sheets are available with workflow to office staff.
What safeguards are in place to protect split parents from seeing data about each other or their children they are barred from accessing? Parents only see their own data plus that of their child.  Court order restrictions immediately bar contacts from viewing any details.
Governor Portal
Does your solution contain a specific governor portal? If so, what information is available to a governor? [Unable to Answer]
What security is provided around sensitive data? [Unable to Answer]
Mobile Apps/Access
Does your solution have a mobile ready interface? Yes, mobile views are available for pupils and parents.
Does your solution have a dedicated app for mobile devices? Partially. Apps both in house and externally provide features for part of the database.
For either question, please provide details of which Operating System (iOS, Android, Windows) and browser your solution is available for. iOS, Android.
Remote Access
How can staff access your solution from outside the school? List options that are offered by your software (i.e. not taking into account what schools might put into place separate from your solution) Yes, using RDP connection or using SLG as a paid add-on.
How can parents access your solution from outside the school? List options that are offered by your software (i.e. not taking into account what schools might put into place separate from your solution) Using SLG.
Staff Management
Does your solution record and manage staff personal/demographic details? Yes.
Does your solution contain all statutory fields required for Staff Workforce Census? Yes.
Does your solution archive past staff records? How far back can a staff record be recovered/reviewed? Yes. All records.
Does your solution record contractual details? If so, what security safeguards are available to prevent administrative but non-HR staff from viewing this information? Yes. Security is controlled section by section and user accounts are associated with pre-built or custom security profiles.
Does your solution record financial/bank details? If so, what security safeguards are available to prevent administrative but non-HR staff from viewing this information? Yes. Security is controlled section by section and user accounts are associated with pre-built or custom security profiles.
Does your solution manage and monitor staff checks and renewals for these (Checks being CRB, List 99, and Immigration). Yes.
CPD
Does your solution manage staff professional development? Yes.
Does your solution allow staff to interact with their own CPD recording? Yes.
Does your solution allow managers to review and evaluation CPD records? Yes.
Does your solution allow training courses to be provides, signed up for and managed online? No.
Does your solution interface with IfL for CPD recording? No.
Cover Management
Does your solution provide cover management facilities?  Yes.
Can a staff member be covered for part day, full day, or for long periods of time (several days/weeks) in one step? Yes.
Can a room be covered for part day, full day, or for long periods of time (several days/weeks) in one step? Yes.
Are cover statistics recorded against staff records? No.
Does your solution provide analysis for staff absences/covers against pupil performance, attendance and behaviour? If so, please briefly describe. This is a free answer, but please keep to brief features. Yes.
Transport/Bus Management
Does your solution provide facility to manage school or LA sponsored transport (such as buses or taxies)? No.
Does your solution provide route management and optimisation technology? No.
Does your solution provide alerting to staff/parents/student for changes in transport provision (such as bus cancelation for example)? Only via the same messaging facilities as any other event.
Extra-Curricular Activities
Does your solution provide facility to manage extra-curricular activities? Yes.
Can fees be associated and charged through this facility? Yes.
Can attendance be associated, recorded and reported on through this facility? Yes.
Can progress (markbooks) be used and reported on through this facility? Yes.
Reports
Does your solution provide a reporting toolset? (This should be answered no if you connect to a third party solution to create the report, but this does not include the final output, such as Word or Excel or PDF). Yes.
Are all data fields within your solution available to be reported on? Yes.
What output formats are available for these reports? Word, Excel, PDF, TXT.
Can charts be produced as reports? Yes.
Can mail merges be produced as reports? Yes.
Can reports be sent or viewed online via portals? Yes.
Can termly reports be sent or viewed online via parent interfaces, if available? Yes.
Can termly reports be sent via email by facilities within the solution? (This should be answered no if a report or batch of reports would need to be produced, output, saved and then separately attached to emails, manually by staff). Yes.
Does it allow importing\exporting of templates, for example provided by the LA? Yes.
Can you integrate third party BI systems – such as Cognos, Microsoft Power BI or Business Objects? Yes.
Does your solution have a dedicated data warehouse for reporting to reduce load on the main transactional database Yes (Discover).
Communications
Does your solution provide text messaging facilities? (This should be answered no if you connect to a third party solution). Are responses able to be recorded against student records? Yes.
Does your solution provide emailing facilities? (This should be answered no if you connect to a third party solution). Are responses able to be recorded against student records? Yes.
Does your solution provide voice message facilities? (This should be answered no if you connect to a third party solution). Are responses able to be recorded against student records? No.
VLE
Does your solution have an integrated learning platform (This should be answered no if you connect to a third party solution). No.
If yes, please describe the basic characteristics of this platform. This is a free answer, but please keep to brief features. N/A.
Library Management
Does your solution have an integrated library management solution (This should be answered no if you connect to a third party solution). No.
Asset Management
Does your solution have an integrated asset management solution (This should be answered no if you connect to a third party solution). Yes.
Facilities Management
Does your solution have an integrated facilities management solution (This should be answered no if you connect to a third party solution). No.
Helpdesk
Does your solution have an integrated helpdesk management solution (This should be answered no if you connect to a third party solution). Helpdesk does not need to be specifically for IT support, although this is the common need. No.
Room Booking/Facilities Booking
Does your solution have an integrated room booking or facilities booking solution (This should be answered no if you connect to a third party solution). No.
Can booking be managed by the customers, if yes? N/A.
Parents Evening Management
Does your solution have an integrated parents evening management solution (This should be answered no if you connect to a third party solution). Yes.
Can booking be managed by the parents, if yes? No
AD Integration/Provisioning/Single Sign On
Does your solution provide any form of provisioning of Active Directory accounts? Are these accounts synchronised with the MIS account? Yes.
Does your solution provide other forms of Active Directory integration? No.
Does your solution provide Single Sign On? What technology is used for this? Yes, via LDAP
Is yes, what level of security policy is provided to mitigate data loss? [Unable to Answer]
Customisation/Workflows/Imports/Exports/Process Management/Database Management/UDFs/Validation Control
Please list any facilities within your solution that allow the creation and customisation of:
         Customise interface (over and above the colour of the interface and logos) No.
         Workflows, to control data flow based on school requirements No.
         Data imports Yes.
         Data exports (this is different from general reports that output to Word or Excel formats) Yes.
         Custom processes (where a school might want to build a process of data specific to them, within the solution) No.
         Database Management (Can the school manage the database tables directly or indirectly, create or remove base and user defined fields, assign complex data types and relationships, add data format and validation). No.
Data Auditing & Data Migration
Does your solution audit data entry/change/delete and is that data audit reportable? No.
Please list what popular MIS solutions you are able to migrate a school from, in terms of the data transfer. Facility, E1, Integris, iSAMS.
What are your typical migration times from each MIS solution you have mentioned? [Unable to Answer]
What is the typical data migration success rate (that is, how much data in breadth and history are you able to transfer) for each MIS solution you have mentioned? [Unable to Answer]

 

As Capita refused to participate in this community survey, no contact details have been provided.

Original Response File can be found here: Capita SIMS – The MIS Challenge

This questionnaire is completely objective and responses have only been edited to fit to a standardised format in places. Information supplied by the supplier is accurate at the time of receiving responses. Every effort will be made to timely update the responses in line with changes to the product.

Graham Reed, the Eduware Network and its associates take no responsibility whatsoever for actions taken as a result of reading this or any other responses or opinions, nor do they in any way endorse this or any product or supplier. This is intended as a guide only, and is expected to be used as such.

%d bloggers like this: