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 30 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 (first name, last name) 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 (first name, last name) 6) By date of interview (00/00/00) 7) By district name (text field, ie., East River School District) 8) By individual survey questions (survey question #1, #2, #3, etc.) 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 reason for this is so we can ask the database to pull up several responses, like all the Y's, for question 1, from ALL the survey records. The other field required for each survey question will be a "comments" field to record ACTUAL interviewee answers/comments for that question, for later qualitative 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 a tab delimmted file of all the data for each record for analysis in a stats program.
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.
This will be running on an NT server, I'm thinking we'll want to use PHP and MS-SQL or mySQL. think both are available. I am gathering more info from the provider.