EXCEL QUESTIONNAIRE ANALYSIS

I think four of my questions are the most important ones because they best answer the unit question. They are:

In this question, the main idea was to test the general knowledge of students about Web 2.0. I found out that very little of the year 7's know or understand what Web 2.0 is. This may be because they have not learnt about it in IT year, unlike years 8 and 9 who have a higher percentage of people who know what Web 2.0 is. Therefore, the higher your grade is, the more you learn about information technology and it's components and features.

In this question, the reason for it was to see whether there is any connection between age and social networking websites that are used. I found out that most year 7's use Instagram, however year 8's use Facebook most and year 9's use other websites most. I think this is because people in year 7 might not be allowed to have Facebook as they are under 13 years old. Also, they tend to use twitter the most as well which shows they like keeping up with friends and celebrities. The fact that each year uses different social networking websites most shows that Web 2.0 offers a large variety and that is vey useful to us.

Here, according to the data, most people from all years use google and it's interactive options like google plus, gmail etc. Also, the higher the grade is, the more people use google most. This might be because they get more homework and need to send more documents etc. using google as the year and its difficulty rises. Year 7 don't use blogger much, this might be because they don't have as much IT work to post of their blogs.

This data shows how Web 2.0 can be used for different matters. It helps each year in different ways and that shows that it is a very useful tool. It is used for interaction, homework and general information depending on the year and that shows how it is useful to people for different things and options.

EXCEL QUESTIONNAIRE RESULTS

LEARNING HOW TO USE EXCEL

Today, Ms.Veena explained some key components of how to use excel, and taught us some terminology to use. I found this lesson very interesting and I learnt a lot about how to use it. In addition to that, she also explained how to use excel to present our data from our questionnaires.

At first, we learnt what a cell was, I understood that it was quite similar to coordinates, for example, this is the cell C275:

It is shown in the square above when you click on the cell and the letter C and the number 275 are both highlighted.

After that we learnt how to present our questions in a graph, first, we have to write down the answer options in cells next to each other. For example, these are the options to my first question, "What is Web 2.0? Because I have asked three different age groups, I must have three different sets:

Next, we learnt how to type in our data. To do this, I had to write 1 for the each option they chose and 0 for the rest. This is an example from my first question:

After that, before presenting the data in a graph, we learnt how to use the COUNTIF function. It enables you to count how many of a criteria you have in a certain range. In this case, the criteria would be 1. Here is a step by step process of how I used the COUNTIF option:

First, I typed =countif directly in the cell below the range:

Then, I opened a bracket and selected the range:

 After that, I typed in the criteria (1) and closed the brackets:

And thats it, I pressed enter and it calculated the total, this is all three done:

After calculating the total for each year, I learnt how to present the data in a graph. First, I selected the the options, and the totals, then I chose the Pie graph option in the Charts section, and then I chose it to show the percentage. This is a step by step process of how I did this, including a picture of the outcome:

Overall, I enjoyed this experience very much. I learnt how to create graphs in detail and it will really help to covert the data of the questionnaires into graphs in excel as it is easy and interesting to do. 

ANSWERED QUESTIONNAIRES

These are some of the questionnaires that have been answered by each year (7,8,9). As you can see, I have presented my questionnaires according to my planning, I printed out copies (Unfortunately in black and white because colored ink was not available) and I gave the students a highlighter and a pen each so they could highlight the answers and write the ones that required justification. Overall, it was a good experience, I learnt how questionnaires work and even though it was a little stressful to run around asking people to answer them, I now have a better understanding of how questionnaires are actually presented and used. It was an enjoyable experience.

QUESTIONNAIRE PLANNING

I have now improved my questionnaire based on feedback from my peers and Ms.Veena. Now, the next step is to ask people to complete my questionnaire. My target audience will be years 7, 8 and 9. Therefore, I will ask 10 people from year 7, 10 people from year 8 and 10 people from year 9 to answer my Web 2.0 questionnaire. The reason I have chosen to present my work to three different age groups is because I would like to analyze the responses and find links between the age of the audience. Also, it will give me a variety, and that will make it easier to find connections between answers and age and compare it with other ages. It will also allow me to answer the unit question in more detail as I will be able to explain differences between how Web 2.0 helps the daily life of students from different agar groups. I have decided to present my questionnaire on printed paper rather than an online survey. There are many reasons for my choice, one of them being that it will encourage people to answer it. From experience, I know that asking people to answer questions from a link will take more time than asking them to do it in person on paper because most people aren't bothered to answer them online. Also, many people might not use or might not have access to social networking websites, if I post the link there. Therefore, seeing as it is the more suitable option, I chose to print out 30 copies of the questionnaire and ask people to answer them in person. I will be doing this in lunchtimes tomorrow and after tomorrow as I know where the people usually sit. I will give them highlighters/pens and ask them to answer each question. In general, the reason for these choices are because I believe they are the best and easiest options to help answering the unit question in the final presentation.

IMPROVED WEB 2.0 QUESTIONNAIRE

Questionnaire Evaluation

Today, I received feedback from Ms.Veena for my work on the Web 2.0 questionnaire. After seeking advice, I can see that I must pay more attention to the result of the survey. As I need to present my data in a graph, I must make sure that I give options to the person completing the survey. Therefore, I can present the information I collect in a suitable graph. This is why I have to change many questions and add options to create my final questionnaire suitable and easy to answer and collect data from for a detailed survey analysis. I have decide to add options for every question that I have created. For example, for my first question (How many hours do you spend on the Internet daily on average?) I can include options such as 0-2 hours, 2-4 hours, 4-6 hours and 6+ hours. This will make the entire outcome of the survey make more sense as I can collect data and present it in a graph. Also, it will make the job for the person who completes the survey as well as they have options to choose from. Overall, I think my questions are alright but I need improvement in adding options and changing the format of some of them.