Develop a database-driven CD application for HSC's "Green Clean" program
Healthy Schools Campaign Request for Proposal
Project: Develop a database-driven CD application for HSC's "Green Clean" program
Deadline to Submit Proposal: 5pm (Chicago Time), Friday October 30, 2009
V.04_DB_10/21/2009
A. About Us
Healthy Schools Campaigns mission is to advocate for policies and practices that allow all students, teachers and staff to learn and work in a healthy school environment. The organization started in 2002 and has programs locally in Chicago and nationally. For more information, visit the website at http://healthyschoolscampaign.org and for more on the "Green Clean" program see http://greencleanschools.org.
B. Key Project Requirement
We are looking to develop a database-driven website-like application to run off of a CD (from both Macs and PC's)
C. Specific requirements
The application will be able to run (auto run) from a CD and perform in a similar way to our website version.
Functionality will exist to take flat files and update the data for future updates. Live, updated database is maintained as a mySQL database on HSC's server.
That the project have two check-in stages where HSC will review status of the project with the successful contractor to ensure accurate direction of the project.
D. Background and Data about the project
We currently have a CD/Website that is being distributed to schools to encourage them to eliminate toxic cleaning chemicals from their cleaning programs. We have distributed more than 90,000 of these to schools throughout the US. We currently list about 600 products on the web database. This is available to view here (sign in required):
http://www.healthyschoolscampaign.org/programs/gcs/signin.php
Once logged in, the specific dynamic, database driven pages that need to be recreated on the cd are:
Products: http://www.healthyschoolscampaign.org/programs/gcs/guide2/products.php
Companies/Sponsors: http://www.healthyschoolscampaign.org/programs/gcs/guide2/sponsors.php
Distributors: http://www.healthyschoolscampaign.org/programs/gcs/guide2/region.php
Distributors (from Triple S): http://www.healthyschoolscampaign.org/programs/gcs/guide2/SSS.php
Version 3.0 of the CD will be released in September 2010. The function that we need includes:
Access a database for products, companies, distributors (please see excel sheets below to see the current form of data)
Create viewable page for products that are searchable and sortable by various fields including by Company, by product type, by distributor, by geographic location etc.
Create viewable page for company listings
Create ability to update the database application will read for future versions.
This database must run off of a CD.
Sample data exported from mySQL (please request access to these files at [email protected]):
Companies: http://spreadsheets.google.com/ccc?key=0Amx0m691FwZBdHo5UHM5cWRhWV9wN1VnY3JMUEtEbXc&hl=en
Products: http://spreadsheets.google.com/ccc?key=0Amx0m691FwZBdGNCRTY3Q3o1MWdoTUJJN2NlNUFPT0E&hl=en
E. Your proposal should include
An estimate for the number of hours the project will require
An estimate for the cost per hour and the total cost
An estimated completion date for the project
Contact information of two references
Provide one example/case study of a similar type project
State if you will be able to create a free prototype or sample to review before signing a contract.
F. Estimated Project Duration
RFP sent out: Wednesday, Oct 21, 2009
Proposals due no later than: 5pm (Chicago Time), Wednesday October 30, 2009
Project Completion Date: Friday, January 15, 2009
G. Submission Information
Send your proposal via email to Dorian Breuer at [email protected]
H. For Additional Information
Please contact:
Dorian Breuer
[email protected]
Information Systems Director
Healthy Schools Campaign
175 N. Franklin #300
Chicago, IL 60606
312 419 1810
773 809 3817 (cell)
312 419 1806 (fax)
http://healthyschoolscampaign.org
Updates to this document are available online at http://docs.google.com/Doc?id=dfrxr9p9_39fcvvnmdj
