Standard letters system integrated with SEEMiS system

Tender description

Why the Work is Being Done Quotations are sought for a solution to create and digitally store letters sent by schools to parents. SEEMiS provides an MIS solution that captures pupil information for 670,000 pupils attending 2500 schools in Scotland. An existing solution is currently provided by SEEMiS that allows school staff and local authority HQ staff to create bespoke word templates that "mail merges" information from the SEEMiS MIS and creates letters to be posted to parents. The letters are then stored as PDF format against the pupil record. The current solution has reached end of life and an improved solution is sought. Problem to Be Solved Users will be allowed to store word templates that incorporate information from an existing MIS. Restrictions in the access of information at a field level and user account level must be included in any solution. All letters sent should be digitally stored in a PDF format (preferred) and recorded against individual pupils. The solution does not require storage space; this will be provided by SEEMiS. Templates created at a local authority level will be available to all schools within that area. Batch processing including pdf conversion of 1000 letters is standard. Who Are the Users Current users are: school admin staff and local authority HQ education staff. Requirements: The system will handle templates up to 0.5 Mb in size. No data used in letter generation will be placed on the client machine, even temporarily. Access control relating to fields or groups of fields must be secured at the server end and not depend on the client software behaving in a compliant manner. Users will be able to customise individual letters with additional information. Document management including deletion and search facilities. Users will be able to preview letters before processing Early Market Engagement Work Already Done Existing Team SEEMiS is a SME software house (57) handling the full software development lifecycle. Any solution proposed must be configurable by SEEMiS to allow for data configuration Current Phase Not applicable Work Location At the suppliers location any meeting etc will be at the SEEMiS Group LLP , Hamilton, Scotland Working Arrangments We are flexible in the working arrangements we believe that a minimum of one meeting on site in Hamilton will be beneficial. We have video conferencing facilities that we will utilise. Expenses are limited to : £100 for hotel accommodation, £25 for meal allowance. All expenses must be submitted to SEEMiS. Any expenses must be pre-agreed Security Clearance dependant upon the solution proposed the supplier's staff may require PVG basic disclosure Additional T&Cs Skills & Experience Demonstrable experience of development of a solution that meets the scope of the works or an existing solution that meets scope AGILE project methodology knowledge and experience JAVA and SQL server development for any proposed system development Experience of knowledge transfer to customers ISO 27001 familiarity Nice to Haves Providing solutions for educational establishments No. of Suppliers to Evaluate 3 Proposal Criteria Solution proposed will be evaluated against the System Usability,customer data, Integrations, Performance and Reporting criteria listed below. Suppliers will provide responses to how they will achieve the requirements listed System Usability : The system must have in-system help features available for users to access at any time. System Usability:The system must have a configurable, customisable interface that Relevant Users and System Administrators can navigate and understand easily System Usability : The system's interface must meet accessibility standards for users with special needs. It must be WCAG 2.0 compliant. System Usability: The solution must allow users to specify selection criteria for letters for upto ten fields Customer Data : The solution must record letters against individual pupil record.The solution must have security assigned at a user level to restrict access to view information Customer Data : The solution must allow for additional information to be added to all letters generated from templates at the point of letter creation Customer Data : The solution must allow for additional information to be added to a selected pupil letter generated from templates at the point of letter creation Customer Data: Version control of templates must be implemented Customer Data: Templates should have user rights assigned to prevent unauthorised changes. This should be at local authority level and school level Customer Data: Templates created by local authorities should be pushed to all schools within that specific authority Customer Data: The solution must have the facility to create letters for both parents when requested Performance: The solution must specify the time required to generate ,store and retreive letters. Reporting: The system must have effective basic reporting functionality which allows the Council to schedule reports and export to various file formats. Audit log: The system must allow System Administrators to efficiently access and interrogate the audit trail and error log data. The system must have effective and efficient issue/error logging functionality. Integrations: The solution must integrate with the SEEMiS MIS Document Management: The solution must incorporate a document management solution that allows users to delete, view and retreive individual archived documents Added Value: Please detail any other added value you propose to provide at no additional cost Cultural Fit Criteria Specify how you propose to work with SEEMiS How your experience with other public sector bodies will prove beneficial What areas of this proposed development you have identified as risks Payment Approach Fixed price Assessment Method Written proposal Evaluation Weighting Technical competence 55% Cultural fit 5% Price 40% Questions from Suppliers Budget range