Wednesday, August 10, 2016

A project of surveys


I got a project of analyzing to do during my internship. The project included about twelve surveys from the past years until this year. It was on an excel file with raw data of the questions and answers mixed. My job was to try to reorganize all similar answers for each question and divide them by age and genders. The job seems easy when I heard of it, so I told my supervisor that I could make them on charts too. However, when I started working, it became confusing, and I had to put them on different sheets to make it easy. I spent a good two hours with only one survey, and I could not even finish it.
I started thinking how these surveys were done, and if they were made online, there must be a way to get all answers, questions, and genders divided and organized correctly. I went to my supervisor asking her, and she said yes that they have their account on one of the online survey services. I asked if that website could have all functions and charts to organize what we want. Her answer was: I have no idea! I could get the date as you see. She then gave me the username and password of the account if I wish to check it out myself.
It took me a little bit time to figure it out, but I found all functions to create many things such as charts and words map. So, it was worth checking out, and it was so easy from the actual survey website to reorganize whatever you like and make some sense out of that raw data. I finished all surveys at the next day, and I put every survey on a separate PDF file with charts and words map.
What I learned from that is not to underestimate any job, and not to keep doing things by the old ways while technology provides me with quick, easy, and better options.

2 comments:

  1. I'd probably be doing the same things as you, technology and those sorts of things are not always my friends. I have found that while making my art or doing similar tasks it's sometimes easiest to break them down a little at a time and then you have everything laid out and can better organize it. We chefs have something similar in cooking, it's called Mise En Place, it means everything in it's place. We always lay out all of our ingredients for a dish first, the measurements and which order it goes in before we start cooking, that way when you are ready and the recipe is very specific on order, times, etc., you are ready to go and not cutting onions while your garlic is burning! I like to lay it all out, organize it, break it down, then reassemble it the best way possible, I have had great outcomes that way and it's a tried and true technique! Good job for trying something that you aren't familiar with, those sorts of things do take quite a bit of skill and organization, jump on in and give it a shot!

    ReplyDelete