H
Hellaby
Guest
I have a research project. I need to capture numerical values from a scroll bar into a table so they can be used to produce excel charts. I can capture the data no problem, my problem is how to present it in a user friendly format - a form.
I have to capture the following data via a form for each research respondent:
Name
Age
Sex
Occupation
Each respondent is then asked to rank five brands against seven different attributes. In format terms, my researcher wants to display one attribute at the top of a page with five brands listed underneath with the slider beside each brand. For example:
"The Worst IT Information" is the attribute at the page top
"Microsoft" is the brand, with a slider beside it so the resondent can select how much they associate/rank this attribute with Microsoft.
"Adobe" is the second brand with slider
"PaintShop Pro" is the third brand with slider
"Corel" is the fourth brand with slider
"Sage" is the fifth brand with slider
The same respondent then clicks to the next page which has a new attribute at the top, but with the same five brands underneath to rank the attribute against.
eg "full of bugs" is the attribute at the page top
brands and sliders are all as above
There are seven pages in all. At the end of the data collection I need to be able to find the average ranking for each brand against each attribute and apply the demographic information, for example
Microsoft had an average ranking of 7 out of 10 against the attribute "Worst IT INformation" against women 30Plus.
I can't figure out how to do this without collecting the information into tables called PageOne, PageTwo, PageThree, PageFour, PageFive, PageSix, Page Seven and using fields like: brand 1 (text), brand 1 (value), brand 2, (text) brand 2, (value). This seems to fly in the face of how you would normally create a table and will require queries to add together all the values gathered using different fields.
Does anyone have any suggestions on where I might be going wrong?
I have to capture the following data via a form for each research respondent:
Name
Age
Sex
Occupation
Each respondent is then asked to rank five brands against seven different attributes. In format terms, my researcher wants to display one attribute at the top of a page with five brands listed underneath with the slider beside each brand. For example:
"The Worst IT Information" is the attribute at the page top
"Microsoft" is the brand, with a slider beside it so the resondent can select how much they associate/rank this attribute with Microsoft.
"Adobe" is the second brand with slider
"PaintShop Pro" is the third brand with slider
"Corel" is the fourth brand with slider
"Sage" is the fifth brand with slider
The same respondent then clicks to the next page which has a new attribute at the top, but with the same five brands underneath to rank the attribute against.
eg "full of bugs" is the attribute at the page top
brands and sliders are all as above
There are seven pages in all. At the end of the data collection I need to be able to find the average ranking for each brand against each attribute and apply the demographic information, for example
Microsoft had an average ranking of 7 out of 10 against the attribute "Worst IT INformation" against women 30Plus.
I can't figure out how to do this without collecting the information into tables called PageOne, PageTwo, PageThree, PageFour, PageFive, PageSix, Page Seven and using fields like: brand 1 (text), brand 1 (value), brand 2, (text) brand 2, (value). This seems to fly in the face of how you would normally create a table and will require queries to add together all the values gathered using different fields.
Does anyone have any suggestions on where I might be going wrong?
