How to code a questionnaire on Google Forms using Excel and SPSS

[@MohamedBenhimaPhD]

📌 For assistance with data analysis, kindly contact me via this email: [e-mail] or WhatsApp: [phone] / or follow this link wa.link/l6jvny Facebook: facebook.com/benhima1/ Instagram: instagram.com/medbenhima2015/ Linkedin: www.linkedin.com/in/mohamed-benhima-6a1087109/ Twitter: twitter.com/Mohamed_Benhima WhatsApp: [phone] E-mail: [e-mail] Zoom: us05web.zoom.us/j/5038752034?pwd=SDVjZGZXaEl5b0d2bVJ2c3M2VzVWUT09 Google Meet: meet.google.com/tgr-vmww-aoj GoogleClassroom: classroom.google.com/c/MzI0MDc1MjM4NDI0?cjc=s2vuft2 Code: s2vuft2 Telegram Research Support Group: t.me/joinchat/FqMy6gQ-xRU6bgLg

[@harmeetchhabra8412]

If my questionnaire contains a yes or no question and if the respondent answers yes he moves to a certain section of the questionnaire and if he answers no then he moves to a different section how to enter data of such type to be used in smartpls

[@krishnadevibonia1542]

Ok

[@classicaltutor1013]

Thank you

[@devrsingh854]

Sir how to reverse code likert scale items?

[@deborahkhairmode223]

You have no idea that you saved a student in her research. Basically left to fend for myself by my guide and you came in like an angel 😭❤️

[@hayetdriai4216]

What do you do after coding the data , please? I couldn't find the next video.

[@deborahkhairmode223]

@@hayetdriai4216 So basically you change your "Always" to 5 and your "Never" to 1. Exactly how it's mentioned in the video. Then you start to add the values up. So say, Body Image Concern Inventory has 19 questions, and their score can reach from 19 (where someone selects 'Never' for every question) to 98 (where they select 'Always' for every question). What you do is, you make the sum of the scores for the questions. Then select the + sign and drag it down to get the sum of the scores for all the responses for whichever particular questionnaire you've used. For something like Rosenberg's Self-esteem Scale, you'll have to follow the scoring mentioned. Hope this helps! P.S. Love the Arietty pfp.

[@deborahkhairmode223]

@@hayetdriai4216 So you just sum them up. Because since you have numbers now it becomes easier to score the data. Basically you need scores for each response right? After turning those 'Always' to 5 and 'Never' to 1 you can now do the scoring. Depends on the tool you're using and whether you're on a five-point or a four-point Likert scale. P.S. Love the Arietty pfp.

[@UnluckySouvlaki]

You just saved the lives of 3 desarate college seniors with this! Thank you very good job!

[@notalie7514]

Make that 4❤

[@UnluckySouvlaki]

@@notalie7514 By now it's actually way more! We send this to the new senior students now that we graduated so we can help them. Thank you! :D

[@novemberchizurumoke9556]

Two years down the line and this video is still saving our asses 😂 Thank you ❤❤❤

[@kellyanderson4910]

God bless you, you literally saved my life. There was a problem with my coding and I couldn’t figure out what it was. I used your list of codes and my analysis is fine now

[@hanas_340]

I have only one month left for a whole dissertatio and you my dear, just saved my life.

[@tharshinisandaragesan2342]

I was panicking for not being able to use SPSS. But this video deserves a big thumbs up!!!!

[@Standard_Playzz]

Thanks buddy ,you are a legend I understood it from you but my university teacher was not able to explain it properly.

[@VidanelageSashini]

I watched so much videos but couldn't clearly get any, This video saved me it's very clear, Thank you sir!

[@05madavan58]

docs.google.com/forms/d/e/1FAIpQLSe0vOzBP6BVh1FZl5FDCZz4gf5ZwH2BwXhCy_V57ao52SvHAw/viewform?usp=sf_link Please fill this form and thanks in advance

[@kwakuklinsman1687]

i don't usually comment on KZbin videos but you just saved me boss thank you

[@ChosenSix6]

You just showed me a way to finish the analysis of my MSc dissertation on time. God bless you 🙏🏾

[@abaza1428]

yo i love this guy, in the span of 5 min i went from panicking to chilling, keep it up bud✌🏼✌🏼✌🏼✌🏼✌🏼✌🏼

[@josephinewileswarner6549]

Thanks, Mohamed, for sharing this video. You are a life saver.

[@LugandaLearner]

Thank you brother. Am to submit my desertion for BMLS Mbarara University you've saved me a science student

[@MohamedBenhimaPhD]

Most welcome

[@janeben-caleb7418]

You are simply God-sent! Thank you so much! 🤗

[@bbmeow210]

This is super helpful! Thank you so much for the wonderful tutorial😃

[@vijaykumarmohan4033]

Thank you, Sir. I learned coding from the Google form questionnaire from you..🙏Once again, thank you so much, sir.

[@sonusitu234]

I watched so many videos wasn't clear.... Thank you.... I got cleared how to proceed

[@05madavan58]

docs.google.com/forms/d/e/1FAIpQLSe0vOzBP6BVh1FZl5FDCZz4gf5ZwH2BwXhCy_V57ao52SvHAw/viewform?usp=sf_link Please fill this form Thanks in advance for your time

[@kayelidanhog8357]

THIS HELPED A LOT THANK YOU SO MUCH I WAS HAVING A BREAKDOWN BECAUSE OF MY STATISTICS AND THEN THERE IS THIS MIRACLE

[@MohamedBenhimaPhD]

Glad to hear this

[@hdrrecipesandvlogs1234]

Thank you soooo much sir Half of my Research is done after watching ur video It really helped a lot

[@MohamedBenhimaPhD]

All the best!

[@TheMushMe]

For the Male and Female issues, one could also click the "Options >>" button in the prompt and then select the Match to all case. This will ensure only Male is replaced into 1 and not Female as Fe1.

[@LugandaLearner]

It works I've just tried it

[@muskanarora5573]

Facing problem while coding data my replace and find is not working due to error or protected sheet excel says that it can’t change tha data of protected sheet

[@DilfuzaKarimova-ty5gv]

Very useful and easy to follow, thanks a lot.

[@Jumana373]

Thank you, the tutorial was really helpful

[@searchrightthings.947]

Thanks jasakala allah kheyr for sharing good knowledge.

[@teyaa.k.2165]

WAW IT WORKED FOR ME AMAZING THANK YOU!!!!!!!!

[@05madavan58]

docs.google.com/forms/d/e/1FAIpQLSe0vOzBP6BVh1FZl5FDCZz4gf5ZwH2BwXhCy_V57ao52SvHAw/viewform?usp=sf_link Please fill this form Thanks in advance for your time

[@wizard5021]

You saved the day broo❤

[@us6427]

very concise and helpful. Thank you

[@MohamedBenhimaPhD]

Glad it was helpful!

[@us6427]

@@MohamedBenhimaPhD Yes, basically i succeeded at my qualitative research because of you. Once again thank you

[@MohamedBenhimaPhD]

@@us6427 glad to hear this!

[@JanhaZ013]

what shall be the order of replacement when using 7 point likert scale ?

[@phoebe1913]

Can I ask? Thru changing the gender in numerical value, can I apply other descriptive tool to find more data?

[@arunamaharjan945]

Thank you, this is very helpful!

[@MohamedBenhimaPhD]

Most welcome

[@shivaani1769]

Thank you for this helpful video.

[@iqrazafar7941]

excellent, much needed video

[@nehalelmesbahy538]

Professor, is it necessary to use SPSS when analyzing data? Can’t we just use the graphs from the google form and analyze them directly?

[@Dchallenger.]

Hello sir pls I need d exact questionaire questions u used for this particular explanation can I get it

[@elsarehana6336]

Is there any video of spss factor analysis?

[@BhautikParekh-uf6ze]

really very helpful.

[@lekarb1324]

where can i find part 2 or way forward to this video?

[@elsarehana6336]

Thank you... Clearly understood

[@atharvashelke4296]

Sir we have a query, we asked 25 questions to 400, and there is 4 category in age groups 20-25, 25-30, 30-35, we want to calculate mean and standard deviations of opinion of each age group.

[@adelalbokhari3260]

Sir this video helped a lot, thank you very much

[@05madavan58]

docs.google.com/forms/d/e/1FAIpQLSe0vOzBP6BVh1FZl5FDCZz4gf5ZwH2BwXhCy_V57ao52SvHAw/viewform?usp=sf_link Please fill this form and thanks in advance

[@conquestech]

what of those ones separated by comma

[@lavanya7081]

Should I create google form to code the data? Is it necessary.? I have data in pencil paper form.. please can someone tell me about this

[@user-kp8fz8jj7j]

Thank you so much, this was super helpful!

[@yasminasdiary3509]

hi! thank you for such a helpful tutorial! i have a question: if I need to code "agree" as "1" and "don't agree" as "0", which one should be coded first? thanks in advance!!

[@MohamedBenhimaPhD]

@@yasminasdiary3509 hi! You can start with "don't agree" as 0

[@art_prati_bimb]

It's helpful for me... Thanks a lot

[@05madavan58]

docs.google.com/forms/d/e/1FAIpQLSe0vOzBP6BVh1FZl5FDCZz4gf5ZwH2BwXhCy_V57ao52SvHAw/viewform?usp=sf_link Please fill this form Thanks in advance for your time

[@subashinishankar9686]

how to I extract code of questionaire, it has to be done manually or there is method to download from google form responses?

[@umamaheswari4358]

Very useful thku🙏👌🏼

[@rmdm5944]

My man thank you very much

[@kamoliddinmannonov261]

Thank you Sir, great video

[@sanjana8357]

Where is the other video for the other analysis plz??

[@ruchivohra]

Thank you so much sir, you really made it simple!

[@MohamedBenhimaPhD]

Most welcome

[@paraskaith8073]

What about reverse coded items in same scale?

[@rameshkunwar8730]

Thank you so much sir

[@MohamedBenhimaPhD]

Most welcome

[@keishaclements4674]

How do you create a 5-point likert scale?

[@alizaerom1019]

so easy.thanx a lot sir

[@pamelapeter9417]

Thank you so much 💓

[@israezougaret439]

sir, what about an open ended question ?

[@teacherrmor3804]

Hi Sir, how can I get your SpSS? Need Help, Thank you

[@notalie7514]

Jazakallah Khairan !

[@MohamedBenhimaPhD]

Amin

[@humairatajammul2805]

its really help full thank U so much

[@soumayaezazaa531]

Hello !! How can code my data if I have multiple dependent variables and multiple independent variables !! For example have 10 DV that depends on 5 depending variables each !!!!is there an easy way to code the answers for Spss.

[@MohamedBenhimaPhD]

Select them all, find and replace the values with numbers for each similar variables

[@soumayaezazaa531]

@@MohamedBenhimaPhD so that was a quick response !! Well what if 100 people answers differently for the 10 dependent variables that are impacted by 5 IV and the answers were multiple choice !!! I got the answer in google sheet but it is very hard to convert to spss it is taking me forever to code it ... idk if u understood what I mean . Thank you anywya

[@MohamedBenhimaPhD]

if you hqve qualitative data. It is hard to do it. Contact me via Whatsapp [phone], and take screenshots for me to tell you what to do@@soumayaezazaa531

[@soumayaezazaa531]

@@MohamedBenhimaPhD omg I didn’t expect ur answer !!! I will text you right away !!! Thank you alot

[@nandhiniparthi1640]

Very clear to understood thank you sir

[@MohamedBenhimaPhD]

Welcome!

[@05madavan58]

docs.google.com/forms/d/e/1FAIpQLSe0vOzBP6BVh1FZl5FDCZz4gf5ZwH2BwXhCy_V57ao52SvHAw/viewform?usp=sf_link Please fill this form and thanks in advance

[@channeldl143]

Learnt something new.thanks

[@parvezmussarf6150]

After coding how to enter those data into pivot table please can you help ?

[@angels8688]

What about épi info ?? How to use it with Google forms ?? Please answer..

[@dohamounir1668]

Thank you so much, this was extremely helpful and well explained!

[@sivapri6638]

Thank you sir for the vedio.Is it possible to enter qualitative data in Excel and code them

[@nikithabenny8927]

Sir how to code and set values for rank questions

[@aayushishrestha4314]

What about somewhat disagree?

[@MohamedBenhimaPhD]

That is another type of Likert scale

[@zuhaow2013]

Thank you so so much

[@judyturel3497]

What if you don’t have access to spss is there anyway to do it without

[@MohamedBenhimaPhD]

You can use Excel itself

[@nipunirathnasena5184]

How coding branching questions

[@MohamedBenhimaPhD]

Coding can be done on SPSS by find and replace options

[@pezzergaming963]

How to enter the 5 th question (multiple answers)?

[@maviaiftikhar4778]

Best vedio... Aik bt poochni h k jo coding hm dy rhy responses ko smj a gai h kesy krna h pr yhan pr ap ne sb se phly strongly agree ko 5 kha or strongly disagree ko 1 to agr hm phly replace kren strongly Disagree ko 1 se or end Pr strongly agree ko 5 to koi frq to mi prta??

[@maysr10]

Sir my filen ame is not showing on spss

[@Bustamamgendut]

What if the part strongly disagree part has already been existed as numeric?

[@MohamedBenhimaPhD]

what do you mean exactly? Could you explain more?

[@Bustamamgendut]

@@MohamedBenhimaPhD i just found out from my friend. I should make an adjustment on my Excel since I copied from Excel, then to SPSS

[@MohamedBenhimaPhD]

If you have five point likert scale follow this method. There are other methods in the channel, check them out

[@Bustamamgendut]

@@MohamedBenhimaPhD the difference is your content for Strongly Disagree - Strongly Agree didn't yet numbered as 1-5 at the first place while mine already being numbered as 1-5.

[@MohamedBenhimaPhD]

You can number them the way you like. It is based on personal choice. Just report that

[@TrenchesBaby-o7e]

Whats the name of the website

[@cherryberry2366]

What about questionnaires from printed paper and not google form.??? How to do it??

[@upamamitra5310]

Develop a excel with all the questions and the respective response for each question. Just like the one Google form generates for their responses. You just have to do it manually

[@keulluni1112]

thank u king

[@Poojasingh11112]

My Excel file didn't not open in spss it is showing empty 🥺😭😭

[@najlaaalmana9579]

Interesting video can we check your second video for running test

[@clarathylmesiona6210]

How to add blank page???

[@zaidismael7262]

How to code for example age below 20 from 20 to 30 , from 31 to 40 from 41 to 50 above 50

[@MohamedBenhimaPhD]

They can be coded from 1 to 5 Lowest to highest

[@sreevidyasankarasubramania733]

Thank you .

[@evangelistesther.o]

do you know how to put in billions and millions (large number values) into SPSS?

[@MohamedBenhimaPhD]

Just increase the decimals in the variable view

[@evangelistesther.o]

@@MohamedBenhimaPhD ok so for 2.46 billion I would put 2.46 in the value column and then put 8 in the decimal column representing 8 decimal places?

[@MohamedBenhimaPhD]

@@evangelistesther.o this is what I think. You can make sure of that. You can also just normalise the numbers per 10000 for example

[@evangelistesther.o]

@@MohamedBenhimaPhD sorry can you explain a bit better I’m a little confused at what you mean can you give me an example for let’s say 2.46 billion and 2.46 trillion how would I put those ones in ?

[@MohamedBenhimaPhD]

@@evangelistesther.o you normalise per billions for instance and enter the numbers into spss

[@fatimazahraahyaoui7327]

How about open ended questionnaires. How can I score them and code them in SPSS ??

[@MohamedBenhimaPhD]

You can use thematic analysis of open-ended questions by looking for recurrent themes

[@05madavan58]

docs.google.com/forms/d/e/1FAIpQLSe0vOzBP6BVh1FZl5FDCZz4gf5ZwH2BwXhCy_V57ao52SvHAw/viewform?usp=sf_link Please fill this form Thanks in advance for your time

[@kanimozhi5451]

How to code for multiple choice question

[@MohamedBenhimaPhD]

You can code them as 0 and 1 (chosen or not chosen)

[@humairatajammul2805]

upload more videos regarding SPPS test

[@LaloElGentuzas]

buena hermano

[@barbieann1265]

Thank you!!!

[@dyey-en8492]

Where to get SPSS ?

[@MohamedBenhimaPhD]

Get customizable templates developed over eight years of research work experience: 📄✏: Customizable research templates catalogue: redev.gumroad.com/ 📄✏: Likert scale survey 1: Get a Likert scale template customizable in Microsoft Office Word via: redev.gumroad.com/l/hmmwj 📄✏: Likert scale survey 2: Another short version of a five-point Likert scale in MS Word: redev.gumroad.com/l/ptsbz 📄✏: Likert scale survey 3: redev.gumroad.com/l/oxnve 📄✏: Likert scale reliability report template: redev.gumroad.com/l/jdbxdz 📄✏: Lkert scale EFA, CFA, PCA, Eigenvalue, Cronbach alpha reliability, Kaiser-Meyer-Olkin (KMO) Measure of Sampling Adequacy, Bartlett's Test of Sphericity: redev.gumroad.com/l/cynbjf 📄✏: Mediation analysis template: redev.gumroad.com/l/yeaff 📄✏: Moderation analysis template: redev.gumroad.com/l/atsdw 📄✏: Ten customizable Likert scale templates: redev.gumroad.com/l/qcamn

[@sivakumar-zq2df]

Thank you sir

[@foodswithlam9952]

Thanks 👍

[@jamesmaibale8533]

You didn't explain how to make a code book

[@naziabegum6067]

❤❤❤

[@MohamedBenhimaPhD]

You will need to check reverse coding first.

[@dynur4568]

thank you so much but where is part 2 video haha

[@MohamedBenhimaPhD]

Most welcome

[@MohamedBenhimaPhD]

Kindly check the channel to see what tests to use

[@nguyenthithuthao5447]

thanks a lot

[@zoulikhamennif8309]

thank you