This data automation process converts Google Form responses into a format ready for analysis in IBM SPSS. It covers downloading and converting data, handling multiple responses, mapping answers to numbers, and creating SPSS Variable Views for streamlined analysis.
This step downloads your from responses and converts them to excel and prepares data for pandas.
Watch the video below
step.1.mp4
Download step 1 software from here:
https://github.com/Mahmadabid/Data_Analysis_Automation/blob/main/csvToExcel.exe
Having trouble downloading file, Watch this video
This step is for those who directly downloaded their excel sheet. Instead of following Step 1.
You have to manually prepare file for pandas.
Watch the video below
step.1.alt.mp4
This step is for those who have questions which contain multiple responses in their google form. If your form has questions with options containing ";" in them, then add ";" in brackets.
Add ";" in brackets "()"
Watch the video below
step.2.mp4
Download step 2 software from here:
https://github.com/Mahmadabid/Data_Analysis_Automation/blob/main/MultipleToSingle.exe
Having trouble downloading file, Watch this video
This step is for those who followed step 1 alt, and have questions which contain multiple responses in their google form.
Dont use Step 2, If you used Step 1 alt, use Step 2 alt. If your form has questions with options containing "," in them, then add "," in brackets.
Add "," in brackets "()"
Watch the video below
step.2.alt.mp4
Download step 2 alt software from here:
https://github.com/Mahmadabid/Data_Analysis_Automation/blob/main/MultipleToSingleResponses.exe
Having trouble downloading file, Watch this video
Whether you followed alt guide or normal. From here all the steps will be same.
This step is to create a mapping file to convert your form to numbers in next step. If your form contain questions with multiple answers then use output of step 2, or step 2 alt (if you followed step 2 alt). Otherwise use output of step 1, or step 1 alt (if you followed step 1 alt).
Watch the video below
step.3.mp4
Download step 3 software from here:
https://github.com/Mahmadabid/Data_Analysis_Automation/blob/main/autoMapping.exe
Having trouble downloading file, Watch this video
This step is to convert your form responses to numbers. If your form contain questions with multiple answers then use output of step 2, or step 2 alt (if you followed step 2 alt). Otherwise use output of step 1, or step 1 alt (if you followed step 1 alt).
Watch the video below
step.4.mp4
Download step 4 software from here:
https://github.com/Mahmadabid/Data_Analysis_Automation/blob/main/formToNumber.exe
Having trouble downloading file, Watch this video
This step is to create Spss variable view. If your form contain questions with multiple answers then use output of step 2, or step 2 alt (if you followed step 2 alt). Otherwise use output of step 1, or step 1 alt (if you followed step 1 alt).
Watch the videos below
Part 1
Step.5.1.mp4
Part 2
Step.5.2.mp4
Part 3
Step.5.3.mp4
Download step 5 software from here:
https://github.com/Mahmadabid/Data_Analysis_Automation/blob/main/formToSPSS.exe
Having trouble downloading file, Watch this video
This step is for those who have questions which contain multiple responses in their google form.