Completed

PHP mySQL Survey Database

I'm part of a group doing some educational research and we're gathering the questionnaire results using face to face interviews. The interviewer's notes will be used to enter data into the database. Some of the survey questions will be yes/no/don't know, some will be a numerical values, some will be multiple choice, and some will be open-ended. The important thing is that we must be able to pull up and sort any combination of the data from all the records and all the survey questions. We must be able to sort as follows: 1) By survey record (a numeric ID we will assign to each survey) 2) By name of interviewee (last name, first) 3) By letter-code assigned position of interviewee (a letter code we will come up with) 4) By ACTUAL position of interviewee (a text-based description) 5) By individual conducting the interview (last name, first name) 6) By date of interview (00/00/00) 7) By district name (text field, ie., East River School District) 8) sort by survey question Each survey question will need two fields. One will be a field for a coded answer - either numeric or text answer (ie., Y for yes, N for no and D for Don't Know). The other field required for each survey question will be a "comments" field to record ACTUAL interviewee answers/comments for that question, for later study, if necessary. For Yes/No questions, a simple Y, N or D (Don't Know) will do. In cases where a numeric answer is expected a whole number might not be used, we need to allow for fractions (ie., "How long have you had an building plan in place?") If the response is 1.5 years, we need to be able to add that to other responses and divide by the total to get an average for that question. We'll also need to generate a current overview for the database, something like this... =========================== Survey Database (Currently 9 Records, latest entry August 12, 2002) QUESTION 1 YES(3/30%) NO(3/33%) DON'T KNOW(3/33%) QUESTION 2 LOW(1.5) HIGH(5.5) AVE(3.5) DATA = 1.5, 2, 2, 1, 1, 4, 4, 4, 5.5 QUESTION 3 A(1/11%) B(3/33%) C(5/55%) D(0) E(0) ====================================================== We'll also need to be able to export data to a CSV file, tab delimmted file, or a text file and either show it on the screen save it to disk, or email it as an attachment. see [url removed, login to view] for the survey questions and [url removed, login to view] for a mockup of what I wznt.

## Deliverables

Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased.

## Platform

The platform is PHP / mySQL running on NT server. see [url removed, login to view] for the survey questions and [url removed, login to view] for a mockup of what I want.

## Deadline information

Need ASAP

Skills: Database Administration, Engineering, MySQL, PHP, Software Architecture, Software Testing, SQL

See more: what is numeric data entry, what is database entry, what is a data entry form in a database, survey t, simple interview questions, re nt, questions for the interviewer, questions for interviews, questions for interviewer, questions for data entry interview, questions and answers for interview, question for interview, open interview questions, open ended interview questions, it river, it interview questions and answers, interviews questions, interview questions for data entry position, interview questions for data entry, interview questions data entry position

About the Employer:
( 48 reviews ) East Lansing, United States

Project ID: #2868518

Awarded to:

terrysu

See private message.

$361.25 USD in 14 days
(96 Reviews)
7.0

9 freelancers are bidding on average $225 for this job

vinznet

See private message.

$212.5 USD in 14 days
(50 Reviews)
6.9
vw181638vw

See private message.

$212.5 USD in 14 days
(44 Reviews)
5.4
jamescammarata

See private message.

$212.5 USD in 14 days
(5 Reviews)
4.6
webffiliates

See private message.

$170 USD in 14 days
(19 Reviews)
3.7
nayagan

See private message.

$306 USD in 14 days
(1 Review)
0.0
nanduvw

See private message.

$297.5 USD in 14 days
(1 Review)
0.0
webrelation

See private message.

$170 USD in 14 days
(0 Reviews)
0.9
valmur

See private message.

$85 USD in 14 days
(0 Reviews)
0.0