1.

Solve : online form and online data collection?

Answer»

Hi
I want to collect the participants  of an online psychology study to 56 words, each one to appear in one page with a blank area to collect the responses in text format. In addition, I have  prepared the pages in such a way that each one present each word stimuli for 30 seconds.

The pages are ready now and what i am looking for is how to SETUP the pages/website in such a way that the I could have the responses to be output in a spreadsheet like excel.

And advice is really appreciated.

Many have already done that. Why not just use stools others have crated?
The main difference between Excel and HTML, in a simplified way,  is the Excel is offend as  interactive and DYNAMIC wile HTML is often static.

Do a search on this key Phrase
convert excel to interactive web page
Here is one place to start.
http://www.softatoz.com/how-to-excel/convert-excel-spreadsheet-to-web-page/

Please don't ask me to do it for you. I have a two handicaps.
A three-year-old grand child
and a  little dog.

Which keep me buzy 




Thanks a lot for the valuable comments. I have tried to see the excel worksheets in FORM of the webpages, that is fine. Indeed the google docs offer this FACILITY and that very well. The only problem is tuning the pages to be presented for 30 seconds each one that I am not sure how to do that.

This is why I used the http://wextor.org/wextor/en/ to create the experiment and now looking to see how to publish it in the web so I could have the respondents answers collected.

Glad to see you are making progress.
There is a standard HTML thing that goes to another page after a time lapse. It is the refresh object. It is a meta gizmo. Alto I have used it fort years, I can not remember then syntax.
Here is one from my collection.
Code: [Select] <meta http-equiv="refresh" content="4;url=./wpk/">
It has to be in the META section at the top of a page. This one waits just 4 seconds and the goes to a directory named wpk under the current directory.

Hope this is of some help.
Of course, .you can always do it with JavaScript.
Thanks for the kind attention and for  the comments. Indeed,  I have no problem in timing as I have done it via wextor. Just need to know how to GET my website connected to spreadsheet. I am trying to use the html(s) i have prepared so far.

Cheers,
MasoudSorry I can not offer direct help. Microsoft supports use of Office software by means of ASP code. This kind of stuff  is called "Server Side Program" because the server itself grinds the code and gives the output over the network.

http://support.microsoft.com/kb/257757
Considerations for server-side Automation of Office

In general, it means almost anything you do with office,  can run over the Internet, even o n PCs that do not have MS Office installed.



Discussion

No Comment Found