Part 1 - Using Excel for Open-ended Question Data Analysis

Показать описание

Completing data analysis on open-ended questions using Excel.
Note: Selecting "HD" in the video settings (click on the "gear" icon) makes it easier to view the data entries

Рекомендации по теме

Комментарии

Very useful, short, precise and gives the answers to qualitative analysis right away without a person having to go through all the literature. Amazing!

Seftehandle

Didn't know it was this easy to analyse open ended questions on excel. Now i can explain better in my analysis. Thanks for this excellent video

manoizere

I cannot thank you enough. I pray that my teaching will improve to reflect the clarity, patience, care. I learnt the outcomes and much more. You are an amazing teacher. Best wishes.

bgabbidon

girl you saved my life istg...
This was the most easiest way someone has explained bar charts.
Keep going.You're doing amazing<3

maheenzafar

Thank you. I barely finished watching the video and I knew how to start my analysis. this really helped me.

cleaneat_shealthyrecipes

Part 1 and Part of your videos are absolutely fantastic. I have been searching over the last couple of days for SIMPLE easy ways to teach my students to analyse survey responses. I am so, so glad for your 2 videos.

patriciapeters

OMGGG... Jacqueline; you just made my life easy... girl... that's so easy and without any technical software or so.. thanks a bunch

shafaqkhalid

She made it so easy unlike other videos

bikatblk

Very useful, easy and quick process to analyse open-ended questions, even for beginners in Excel. I am really thankful to this video because I am a beginner in Excel and doing calculation for the first time. This video helped me in analysing datas of the researh questions in short time. Please keep uploading other videos regarding data analysis. Thank you! :)

sawanabhatta

Thanks Jacqueline this is giving so much help to my thesis. I was searching for here and there to find the easier way to count the open-ended questionnaire as the students gave various responses to my questionnaire. This video is easy to understand :)

ekayustina

Dear Jacqueline,
Thank you so much for sharing your class course work on u-tube!
I am writing up the results section of my dissertation, I analysed the questionnaire data through SPSS which was fine as we had been taught how to use this as part of our course. However, I had two open-ended questions which also needed analysed, I down loaded Nvivo on to my computer and spent a couple hours looking at the tutorials and lost the will to live! I decided to search on Google "how to analyse open-ended questions" and to my great relieve your tutorial came up 5th or 6th on the first page! Excellent tutorial, at just the right speed to take it in, no fuss, straight forward and a lovely accent/voice to go with it! Thank you so much! My tutor loves my graphes! :)

penelopemaclellanhawkes

It is very very useful for me. You saved my terrible life. Thank you so much

sustainableworldbysangay

Been searching for a tutorial like this for days. Thank you.

nathanmcmullen

1. The tutorials are part of a 3rd-year course on research concepts in a 4-year degree program. 2. Since we are looking for themes related to how the students feel rather than what action will be required, my preference would be to focus on themes that capture student feelings rather than actions that could be taken to address shortcomings. 3. The main determining factor when deciding on whether to include an open-ended question is: will the responses help to address the purpose/goal of the survey? A secondary determining factor is: does the researcher have the resources to analyze the results? For a survey with thousands of responses, the surveyor could use qualitative research software for the data analysis. Several options are available.

jacquelineclarke