1 / 11

Spreadsheet Evidence

Spreadsheet Evidence. STEP 1: . Firstly I typed in all the questions from my questionnaire and then filled out the answers from the 20 people that I surveyed. . STEP 2:. In order to do make a ‘list’ I had to do the ‘data validation’.

haru
Download Presentation

Spreadsheet Evidence

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Spreadsheet Evidence

  2. STEP 1: Firstly I typed in all the questions from my questionnaire and then filled out the answers from the 20 people that I surveyed.

  3. STEP 2: In order to do make a ‘list’ I had to do the ‘data validation’. Firstly I highlighted the selected area for where I would like my drop down boxes. In order to do this I clicked ‘data’ on the top row Then I clicked ‘data validation’

  4. STEP 3: Then this box shall appear. In order to have drop down boxes I clicked ‘list’

  5. STEP 4: I then clicked the source button and then it asks me to highlight the words/numerals I would like in my drop down box.

  6. STEP 5: Then, as you can see, my drop down box has now been created

  7. STEP 6: I then hid all my excess data which was at the bottom in order to make my spreadsheet more presentable

  8. STEP 7: To create my ‘COUNTIF’ I firstly labelled my whole column with my gender data ‘gender’ as this would make my ‘COUNTIF’ easier to complete.

  9. STEP 8: I then clicked the ‘fx’ button at the top to create my ‘COUNTIF’ As i labelled my gender data ‘gender’ this then made it easier as i could simply just type in ‘gender’ into the range box. For the criteria i typed in ‘female’ as i wanted to know how many people who took my questionnaire were female I then got my answer of ‘10’ meaning there were 10 females who took my questionnaire

  10. STEP 9: I then decided to have some ‘COUNTIFS’. My question was ‘how many females prefer having fun with their friends than males? In order to do so i first did my criteria range1 for gender, where i typed in gender as that is what i labelled my column. For criteria1 i then typed in ‘Female’ as it was part of my question. Then as i was contrasting two questions, i needed a second range and criteria, them being ‘wellbeing’ as that is what i labelled my data column and ‘have fun with my friends’ as it was necessary for my question.

  11. STEP 10: CREATING A GRAPH In order to create a graph i first had to highlight the necessary data I then had to click ‘insert’ on the top row, then choose any of the various graphs. This then created my graph

More Related