Science Communication, Group O

Food Labels
Science Communication, 2010

Activity 14

Capture data from your food label survey

Assignment:

1. "Yes", "no" and "maybe" answers are easy to capture. Difficult answers to capture are value judgements or long verbal responses. Sit together as a group and look at the responses you recorded on your questionnaires. Try to classify or group them and write down classifications or codes for your answers.
2. Each group member has to create an Excel workbook with at least two worksheets.
3. Rename one worksheet: "questions". (Don't know how? Ask)
4. Rename the second worksheet: "answersN" or "reponsesN" were N is a number (1 to 5) as allocated by your group members.
5. Write down all the questions on the question worksheet. After each question, note the values or classifications of the different responses.
   (Note: Do not type in ALL CAPS!)
6. Once each group member has captured all the data, combine the 4(5) workbooks into one workbook with 5 (6) worksheets.
7. Greate a new worksheet, named "Totals"; combine the answers from all worksheets in this sheet. Each group member should then copy this sheet into his/her excel workbook.
8. Analise the responses and draw at suitable graphs for your questions - each member to do at least 2 graphs.
9. Prepare a short PowerPoint presentation using some of the graphs to share your findings with the rest of the group.

Remember to save your file in 'yourSurname' folder and "save often".

Make sure your cells have the right format (right-click, select "Format Cells ..." and choose General or Number of Text, or... ... ...)

Examples of formulas you should know:

• To add the numbers in cells A1 to A10 you can either type
  • =A1+A2+A3+A4+A5+A6+A7+A8+A9+A10
    or
  • =SUM(A1:A10)
• =COUNTBLANK(L3:L15)
  count how many cells in the column L from cell L3 to L15 are blank
• =AVERAGE(G3:G13)
  calculates the average value of the numbers in cells G3 to G13; blank cells are not taken into account. A zero does not count as a blank cell.
• =COUNTIF(C1:C20,"1")
  counts the number of cells that have the value 1
• =COUNTIF(K2:K21,"BioChem")
  counts the number of cells that have the word BioChem.

References & Resources