Our school frequently scans student test results into text files. We have a set of PHP scripts someone in the tech department wrote that reads these scores and stores them into a MySQL database, but the system is good, but not as easy to use as it needs to be. We would also like to have this system fixed or replaced, and the scores tabulated and output to Excel spreadsheets. (See sample files attached.) Attached are 3 files that would serve as input to the reporting program. They are what is generated by the optical scanning of bubble sheets used for answers. That data should be used to generate the output report(s) desired which should look somewhat like the 2 Excel spreadsheet examples attached. The more automated the better. A clean and simple user interface would also be very helpful. This is something that we will need to do almost weekly in almost every class.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.
Linux, Apache, PHP, MySQL, MS Excel.