Statewide Field Team Tools Automation.pdf

Email: chandleg@calhounisd.org

Subject Line: SWFT Tools Automation

RFP – Statewide Field Team (SWFT) Tools Automation

Scope of Work The MI Excel Statewide Field Team (SWFT) at the Calhoun Intermediate School District seeks to outsource the continued development of our automation of tools to receive and store performance metrics in a secure manner and allow the entered metrics to be retrieved, edited and deleted in a web interface. This data is currently entered through a php form and stored in a Microsoft SQL relational database. Users would be given the ability to access, edit, and delete only the data they have been given access to based on tables stored in the database and Word Press user sessions.

The selected vendor will provide an experienced, professional development team to assess needs, design the edit forms and test security.

This Request for Proposal (RFP) details our requirements for the product and process deliverables as well as guidelines for proposal submission.

The automation of tools is being developed to continue enhancement of the effectiveness of the Blueprint Installation suite of tools in an electronic form. This will increase the organization’s ability to assist districts in building systems through the use of real time data that can be accessed anytime and anywhere. As a Statewide Field Team responsible for providing support to districts, schools and regional service agencies throughout the state, we recognize the need to provide this platform for data input and display.

Through this work, the Statewide Field Team (SWFT) aims to have a substantial impact on the following performance indicators:

● Increase the ability of District Leaders to use real time data to make decisions that will impact student, teacher and leader performance.

● Increase the ability of District Leaders to monitor and articulate progress of systemically reconfiguring their district through Blueprint Installation.

In your proposal, be sure to identify what resources you plan to assign to the project and what their responsibilities will be. Also, be sure to identify what resources you will need from us, their roles and responsibilities, and their estimated time commitment.

The vendor will provide weekly updates to the MI Excel Statewide Field Team on project progress and adjustments to project timelines.

The proposal should include the following:

● A detailed description of your design and development process, explaining who does what and when;

● Proposed project and resource plans;

● Project fees detailed by the following:

Email Automation create a system that will send a formatted email containing all the data entered in the form to the email address entered by user.

Security integration allow users to only see their information. Give users the ability to edit and delete that information. User rights are determined based on Word Press session matched through email to record in database.

Ongoing Support for PHP Forms and webpages (retainer of 10 hours per month beginning in November) Ideally this will include support for:

Help with and debug of any errors Support of the AWS Apache server the forms are installed on SAML, security integration issues PHP Input form additions and edits

Selection Criteria Proposals will be reviewed with the following criteria:

● Demonstrated experience in designing desired systems

● Understanding of the project and quality of response

● Evidence of completing projects on time

● Proposed price compares to the average within the industry

● Accessibility compliance knowledge

Content Specifications A subject matter expert from the Statewide Field Team will be provided for on-going collaboration with the vendor to ensure alignment to the Blueprint’s Suite of Tools.

Format/Specifications All of the forms that are developed must meet the WCAG 2.0 Level AA accessibility guidelines.

Project Timeline Project planning and collaboration should begin immediately after the contractor is selected and a contract and scope of work has been formalized. The project email automation and security integration must be completed no later than November 30, 2018. Ongoing support will start on November 1, 2018.

Term of Contract This is a one-time contract that would provide services for the duration of the project.

Product Requirements Your proposal should indicate what strategies your team will employ to address these requirements. Ideally, you will provide examples from previous systems your team has developed which highlight your team’s ability to develop a system of the nature described below.

Technology

● Ability to gather session from Word Press site hosted by Word Press and pass through to PHP server.

● Ability to send an email from a PHP web form based on data entered in the form.

During the selection process, the Statewide Field Team may request additional information or clarifications from the proposers. The SWFT reserves the right to retain all proposals submitted and to use any ideas in a proposal regardless of whether the proposal was selected.

Response Format All submittals should include the following information:

1. Introduction letter with complete contact information and website. Please include a cover letter summarizing your firm’s background, resources, and relevant experience. This letter should also include a cost estimate for the project.

2. Examples of three relevant past projects. Please include a summary describing three relevant past projects. These examples should include a brief summary of each project and a sample of the project.

4. Detailed description of project proposal and approach.

3. List of references and past projects/clients. Please provide a list of references and past projects/clients.

Deadline and Delivery If you have questions in response to this RFP, please submit them to Dr. Grant Chandler, at chandleg@calhounisd.org in writing via email by October 10, 2018. Please use Statewide Field Team Tools Automation in the Subject Line. Responses will be sent in writing via email within 24-36 hours of receipt.

To be considered, proposals must be submitted by October 11, 2018 at 5:00 PM. Proposals should be submitted by emailing them to the Primary Contact as indicated on the cover sheet. Proposals received after the deadline will not be accepted.

A final determination will be made by October 17, 2018. Work is scheduled to begin by October 22, 2018. The deadline for completion of this project is November 30, 2018. This does not include the monthly ongoing support.