It is important to note that Vlookup equations are case sensitive therefore pay close attention to capitalization, spaces, and punctuation in the questionnaire. The hat symbol (ˆ) at the front of the equal symbol (=) is placed so that the Vlookup formula is inactive and visible for editing. In the cell at column D and row 2 ( Figure 10 purple arrow), copy and paste this Vlookup formula: ˆ=VLOOKUP(‘Form Responses!C2,‘Vlookup Table’!$B$2:$C$6,2,0). In the cell at column C and row 2, adjacent to the ordinal ratings, type in their respective numerical values ( Figure 10 orange arrow). In this case, it is the 5 ordinal severity ratings from the CFS Severity Score. Starting from the cell in column B and row 2, type in the severities used in the questionnaire ( Figure 10 blue arrow). This will identify which words are being transformed to their number format. In column A and row 1 cell type in “For All Questions” ( Figure 10 green arrow).
The “Vlookup Table” tab will contain all of the equations necessary to convert the word responses (that are in the Form Responses tab) to their numerical format (that are in the Number Responses tab).Ĭlick on “Vlookup Table” tab in the spreadsheet to begin forming your equations ( Figure 10). The “Number Responses” tab will contain the numerical form of the questionnaire responses. Right click on the “Sheet2” tab and rename it to Number Responses and the “Sheet3” tab to Vlookup Table ( Figure 9B). This creates two tabs labeled “Sheet2” and “Sheet3”. To setup the workbook with three spreadsheets, press the “plus symbol (+)” twice at the bottom left of the screen ( Figure 9A red arrow).
#HOW TO USE GOOGLE DOCS FOR ONLINE SURVEY FREE#
This paper provides step by step directions to setup the free and secure Googledocs system for questionnaire administration.Ĭreating the 3 tab spreadsheet to begin the “Vlookup” process. The responses were formatted so all questionnaire data could be copied to separate spreadsheets for subsequent data analysis. No personal identifying information was collected, although additional productions could be allowed to do this. A confidential log in system was developed that allowed secure data collection. Paper based questionnaires were programmed to allow a simple to read and complete push button format. To overcome these problems, we adapted the existing Google docs format to create an effective computerized questionnaire system. This has become increasingly problematic as grant funds and research budgets are shrinking. However, some platforms are expensive and/or require special tablets that are available only during clinical visits. Electronic versions of questionnaires have shown consistent test-retest reliability of data. Computer based methods obviate many of those concerns. This may lead to risk of data loss and fidelity. In addition, researchers must often re-enter hand written data into recording forms after patients have fill out the questionnaires. Missing data compromises the ability to perform statistical analysis, support vector machine learning, and advanced modeling. Completion of paper-based questions by research study participants is often incomplete.
0 kommentar(er)
